/**
  * View a single response in detail
  *
  * @param mixed $iSurveyID
  * @param mixed $iId
  * @param mixed $sBrowseLang
  */
 public function view($iSurveyID, $iId, $sBrowseLang = '')
 {
     if (Permission::model()->hasSurveyPermission($iSurveyID, 'responses', 'read')) {
         $aData = $this->_getData(array('iId' => $iId, 'iSurveyId' => $iSurveyID, 'browselang' => $sBrowseLang));
         $sBrowseLanguage = $aData['language'];
         extract($aData);
         $aViewUrls = array();
         $fieldmap = createFieldMap($iSurveyID, 'full', false, false, $aData['language']);
         $bHaveToken = $aData['surveyinfo']['anonymized'] == "N" && tableExists('tokens_' . $iSurveyID);
         // Boolean : show (or not) the token
         if (!Permission::model()->hasSurveyPermission($iSurveyID, 'tokens', 'read')) {
             unset($fieldmap['token']);
             $bHaveToken = false;
         }
         //add token to top of list if survey is not private
         if ($bHaveToken) {
             $fnames[] = array("token", gT("Token ID"), 'code' => 'token');
             $fnames[] = array("firstname", gT("First name"), 'code' => 'firstname');
             // or token:firstname ?
             $fnames[] = array("lastname", gT("Last name"), 'code' => 'lastname');
             $fnames[] = array("email", gT("Email"), 'code' => 'email');
         }
         $fnames[] = array("submitdate", gT("Submission date"), gT("Completed"), "0", 'D', 'code' => 'submitdate');
         $fnames[] = array("completed", gT("Completed"), "0");
         foreach ($fieldmap as $field) {
             if ($field['fieldname'] == 'lastpage' || $field['fieldname'] == 'submitdate') {
                 continue;
             }
             if ($field['type'] == 'interview_time') {
                 continue;
             }
             if ($field['type'] == 'page_time') {
                 continue;
             }
             if ($field['type'] == 'answer_time') {
                 continue;
             }
             //$question = $field['question'];
             $question = viewHelper::getFieldText($field);
             if ($field['type'] != "|") {
                 $fnames[] = array($field['fieldname'], viewHelper::getFieldText($field), 'code' => viewHelper::getFieldCode($field, array('LEMcompat' => true)));
             } elseif ($field['aid'] !== 'filecount') {
                 $qidattributes = getQuestionAttributeValues($field['qid']);
                 for ($i = 0; $i < $qidattributes['max_num_of_files']; $i++) {
                     $filenum = sprintf(gT("File %s"), $i + 1);
                     if ($qidattributes['show_title'] == 1) {
                         $fnames[] = array($field['fieldname'], "{$filenum} - {$question} (" . gT('Title') . ")", 'code' => viewHelper::getFieldCode($field) . '(title)', "type" => "|", "metadata" => "title", "index" => $i);
                     }
                     if ($qidattributes['show_comment'] == 1) {
                         $fnames[] = array($field['fieldname'], "{$filenum} - {$question} (" . gT('Comment') . ")", 'code' => viewHelper::getFieldCode($field) . '(comment)', "type" => "|", "metadata" => "comment", "index" => $i);
                     }
                     $fnames[] = array($field['fieldname'], "{$filenum} - {$question} (" . gT('File name') . ")", 'code' => viewHelper::getFieldCode($field) . '(name)', "type" => "|", "metadata" => "name", "index" => $i);
                     $fnames[] = array($field['fieldname'], "{$filenum} - {$question} (" . gT('File size') . ")", 'code' => viewHelper::getFieldCode($field) . '(size)', "type" => "|", "metadata" => "size", "index" => $i);
                     //$fnames[] = array($field['fieldname'], "File ".($i+1)." - ".$field['question']." (extension)", "type"=>"|", "metadata"=>"ext",     "index"=>$i);
                 }
             } else {
                 $fnames[] = array($field['fieldname'], gT("File count"));
             }
         }
         $nfncount = count($fnames) - 1;
         if ($iId < 1) {
             $iId = 1;
         }
         $exist = SurveyDynamic::model($iSurveyID)->exist($iId);
         $next = SurveyDynamic::model($iSurveyID)->next($iId, true);
         $previous = SurveyDynamic::model($iSurveyID)->previous($iId, true);
         $aData['exist'] = $exist;
         $aData['next'] = $next;
         $aData['previous'] = $previous;
         $aData['id'] = $iId;
         $aViewUrls[] = 'browseidheader_view';
         if ($exist) {
             $oPurifier = new CHtmlPurifier();
             //SHOW INDIVIDUAL RECORD
             $oCriteria = new CDbCriteria();
             if ($bHaveToken) {
                 $oCriteria = SurveyDynamic::model($iSurveyID)->addTokenCriteria($oCriteria);
             }
             $oCriteria->addCondition("id = {$iId}");
             $iIdresult = SurveyDynamic::model($iSurveyID)->findAllAsArray($oCriteria);
             foreach ($iIdresult as $iIdrow) {
                 $iId = $iIdrow['id'];
                 $rlanguage = $iIdrow['startlanguage'];
             }
             $aData['bHasFile'] = false;
             if (isset($rlanguage)) {
                 $aData['rlanguage'] = $rlanguage;
             }
             foreach ($iIdresult as $iIdrow) {
                 $highlight = false;
                 for ($i = 0; $i < $nfncount + 1; $i++) {
                     if ($fnames[$i][0] != 'completed' && is_null($iIdrow[$fnames[$i][0]])) {
                         continue;
//.........这里部分代码省略.........

                <?php 
    }
    ?>

                <?php 
    if ($showLastQuestion) {
        ?>
                    <span id="last_question" class="rotateHidden">
                    <?php 
        eT("Last visited question:");
        ?>
                    <a href="<?php 
        echo $last_question_link;
        ?>
" class=""><?php 
        echo viewHelper::flatEllipsizeText($last_question_name, true, 60);
        ?>
</a>
                    </span>
                <?php 
    }
    ?>
                </div>
                <br/><br/>
            </div>
        </div>
    <?php 
}
?>

    <!-- Rendering all boxes in database -->

print utf8_decode($antiSpamQuestion);
?>
                    </td>
                </tr>    
                <tr>
                    <td class="afltr-public-label"></td>
                    <td class="afltr-public-content">
                        <input type="text" class="afltr-public-input-text" name="antiSpamAnswer" size="25" maxlength="255" value="<?php 
print $value;
?>
">
                    </td>
                </tr>                   
                <tr>
                    <td colspan="2" class="afltr-public-button-line">
                        <?php 
viewHelper::submitButton('submsave', language::returnLanguageConstant('AFFILIATE_PUB_SUBMIT'), $isNotUtf8);
?>
                        <?php 
viewHelper::resetButton('subreset', $isNotUtf8);
?>
                    </td>
                </tr>
            </table>
    </div>
</form>

<!-- Powered by Affiliat*r <?php 
print $systemVersion;
?>
 - http://nobody-knows.org/download/affiliatr/ -->

//.........这里部分代码省略.........
                             $theanswer = addcslashes($arows['answer'], "'");
                             $canswers[] = array($rows['sid'] . $X . $rows['gid'] . $X . $rows['qid'], $arows['code'], $theanswer);
                         }
                         if ($rows['type'] == "D") {
                             // Only Show No-Answer if question is not mandatory
                             if ($rows['mandatory'] != 'Y') {
                                 $canswers[] = array($rows['sid'] . $X . $rows['gid'] . $X . $rows['qid'], " ", gT("No answer"));
                             }
                         } elseif ($rows['type'] != "M" && $rows['type'] != "P" && $rows['type'] != "J" && $rows['type'] != "I") {
                             // For dropdown questions
                             // optinnaly add the 'Other' answer
                             if (($rows['type'] == "L" || $rows['type'] == "!") && $rows['other'] == "Y") {
                                 $canswers[] = array($rows['sid'] . $X . $rows['gid'] . $X . $rows['qid'], "-oth-", gT("Other"));
                             }
                             // Only Show No-Answer if question is not mandatory
                             if ($rows['mandatory'] != 'Y') {
                                 $canswers[] = array($rows['sid'] . $X . $rows['gid'] . $X . $rows['qid'], " ", gT("No answer"));
                             }
                         }
                         break;
                 }
                 //switch row type
             }
             //else
         }
         //foreach theserows
     }
     //if questionscount > 0
     //END Gather Information for this question
     $questionNavOptions = CHtml::openTag('optgroup', array('class' => 'activesurveyselect', 'label' => gT("Before", "js")));
     foreach ($theserows as $row) {
         $question = $row['question'];
         $question = strip_tags($question);
         $questionselecter = viewHelper::flatEllipsizeText($question, true, '40');
         $questionNavOptions .= CHtml::tag('option', array('value' => $this->getController()->createUrl("/admin/conditions/sa/index/subaction/editconditionsform/surveyid/{$iSurveyID}/gid/{$row['gid']}/qid/{$row['qid']}")), strip_tags($row['title']) . ':' . $questionselecter);
     }
     $questionNavOptions .= CHtml::closeTag('optgroup');
     $questionNavOptions .= CHtml::openTag('optgroup', array('class' => 'activesurveyselect', 'label' => gT("Current", "js")));
     $question = strip_tags($sCurrentFullQuestionText);
     $questiontextshort = viewHelper::flatEllipsizeText($question, true, '40');
     $questionNavOptions .= CHtml::tag('option', array('value' => $this->getController()->createUrl("/admin/conditions/sa/index/subaction/editconditionsform/surveyid/{$iSurveyID}/gid/{$gid}/qid/{$qid}"), 'selected' => 'selected'), $questiontitle . ': ' . $questiontextshort);
     $questionNavOptions .= CHtml::closeTag('optgroup');
     $questionNavOptions .= CHtml::openTag('optgroup', array('class' => 'activesurveyselect', 'label' => gT("After", "js")));
     foreach ($postrows as $row) {
         $question = $row['question'];
         $question = strip_tags($question);
         $questionselecter = viewHelper::flatEllipsizeText($question, true, '40');
         $questionNavOptions .= CHtml::tag('option', array('value' => $this->getController()->createUrl("/admin/conditions/sa/index/subaction/editconditionsform/surveyid/{$iSurveyID}/gid/{$row['gid']}/qid/{$row['qid']}")), strip_tags($row['title']) . ':' . $questionselecter);
     }
     $questionNavOptions .= CHtml::closeTag('optgroup');
     //Now display the information and forms
     //BEGIN: PREPARE JAVASCRIPT TO SHOW MATCHING ANSWERS TO SELECTED QUESTION
     $javascriptpre = CHtml::openTag('script', array('type' => 'text/javascript')) . "<!--\n" . "\tvar Fieldnames = new Array();\n" . "\tvar Codes = new Array();\n" . "\tvar Answers = new Array();\n" . "\tvar QFieldnames = new Array();\n" . "\tvar Qcqids = new Array();\n" . "\tvar Qtypes = new Array();\n";
     $jn = 0;
     if (isset($canswers)) {
         foreach ($canswers as $can) {
             $an = ls_json_encode(flattenText($can[2]));
             $javascriptpre .= "Fieldnames[{$jn}]='{$can[0]}';\n" . "Codes[{$jn}]='{$can[1]}';\n" . "Answers[{$jn}]={$an};\n";
             $jn++;
         }
     }
     $jn = 0;
     if (isset($cquestions)) {
         foreach ($cquestions as $cqn) {
             $javascriptpre .= "QFieldnames[{$jn}]='{$cqn['3']}';\n" . "Qcqids[{$jn}]='{$cqn['1']}';\n" . "Qtypes[{$jn}]='{$cqn['2']}';\n";
             $jn++;

 /**
  * Get the complete HTML from a string
  * @param string $sExpression : the string to parse
  * @param array $aReplacement : optionnal array of replacemement
  * @param string $sDebugSource : optionnal debug source (for templatereplace)
  * @uses ExpressionValidate::$iSurveyId
  * @uses ExpressionValidate::$sLang
  *
  * @author Denis Chenu
  * @version 1.0
  */
 private function getHtmlExpression($sExpression, $aReplacement = array(), $sDebugSource = __CLASS__)
 {
     $LEM = LimeExpressionManager::singleton();
     $LEM::SetDirtyFlag();
     // Not sure it's needed
     $LEM::SetPreviewMode('logic');
     $aReData = array();
     if ($this->iSurveyId) {
         $LEM::StartSurvey($this->iSurveyId, 'survey', array('hyperlinkSyntaxHighlighting' => true));
         // replace QCODE
         $aReData['thissurvey'] = getSurveyInfo($this->iSurveyId, $this->sLang);
     }
     // TODO : Find error in class name, style etc ....
     // need: templatereplace without any filter and find if there are error but $bHaveError=$LEM->em->HasErrors() is Private
     $oFilter = new CHtmlPurifier();
     templatereplace($oFilter->purify(viewHelper::filterScript($sExpression)), $aReplacement, $aReData, $sDebugSource, false, null, array(), true);
     return $LEM::GetLastPrettyPrintExpression();
 }

 /**
  * Return the question code according to options
  *
  * @param Survey $oSurvey
  * @param FormattingOptions $oOptions
  * @param string $fieldName
  * @return string
  */
 public function getHeadingCode(SurveyObj $oSurvey, FormattingOptions $oOptions, $fieldName)
 {
     if (isset($oSurvey->fieldMap[$fieldName])) {
         return viewHelper::getFieldCode($oSurvey->fieldMap[$fieldName], array('separator' => array('[', ']'), 'LEMcompat' => $oOptions->useEMCode));
     } else {
         return $fieldName;
     }
 }

                                                        </span>
                                                    </div>

                                                <!-- Other questions -->
                                                <?php else: ?>
                                                    <a href="<?php echo $this->createUrl("/admin/questions/sa/view/surveyid/$iSurveyId/gid/".$aGroup->gid."/qid/".$question->qid); ?>" class="question-link" >
                                                        <span class="question-collapse-title">
                                                            <span class="glyphicon glyphicon-list"></span>
                                                            <strong>
                                                                <?php echo sanitize_html_string(strip_tags($question->title));?>
                                                            </strong>
                                                            <br/>
                                                            <em>
                                                                <?php
                                                                    templatereplace($question->question, array(),$aReplacementData,'Unspecified', false ,$question->qid);
                                                                    echo viewHelper::stripTagsEM(LimeExpressionManager::GetLastPrettyPrintExpression());
                                                                ?>
                                                            </em>
                                                        </span>
                                                    </a>
                                                <?php endif; ?>
                                            <?php endif; ?>
                                        <?php endforeach;?>
                                    <?php else:?>
                                        <a href="" onclick="event.preventDefault();" style="cursor: default;">
                                            <?php eT('There are no questions in this group.');?>
                                        </a>
                                    <?php endif;?>
                                </div>
                            </div>
                        <?php endforeach;?>

//.........这里部分代码省略.........
                         break;
                     case 'html':
                         if (isset($aattr["statistics_graphtype"])) {
                             $req_chart_type = $aattr["statistics_graphtype"];
                         }
                         //// If user forced the chartype from statistics_view
                         if (isset($_POST['charttype']) && $_POST['charttype'] != 'default') {
                             $req_chart_type = $_POST['charttype'];
                         }
                         //// The value of the select box in the question advanced setting is numerical. So we need to translate it.
                         if (isset($req_chart_type)) {
                             switch ($req_chart_type) {
                                 case '1':
                                     $charttype = "Pie";
                                     break;
                                 case '2':
                                     $charttype = "Radar";
                                     break;
                                 case '3':
                                     $charttype = "Line";
                                     break;
                                 case '4':
                                     $charttype = "PolarArea";
                                     break;
                                 case '5':
                                     $charttype = "Doughnut";
                                     break;
                                 default:
                                     $charttype = "Bar";
                                     break;
                             }
                         }
                         //// Here the 72 colors of the original limesurvey palette.
                         //// This could be change by some user palette coming from database.
                         $COLORS_FOR_SURVEY = array('20,130,200', '232,95,51', '34,205,33', '210,211,28', '134,179,129', '201,171,131', '251,231,221', '23,169,161', '167,187,213', '211,151,213', '147,145,246', '147,39,90', '250,250,201', '201,250,250', '94,0,94', '250,125,127', '0,96,201', '201,202,250', '0,0,127', '250,0,250', '250,250,0', '0,250,250', '127,0,127', '127,0,0', '0,125,127', '0,0,250', '0,202,250', '201,250,250', '201,250,201', '250,250,151', '151,202,250', '251,149,201', '201,149,250', '250,202,151', '45,96,250', '45,202,201', '151,202,0', '250,202,0', '250,149,0', '250,96,0', '184,230,115', '102,128,64', '220,230,207', '134,191,48', '184,92,161', '128,64,112', '230,207,224', '191,48,155', '230,138,115', '128,77,64', '230,211,207', '191,77,48', '80,161,126', '64,128,100', '207,230,220', '48,191,130', '25,25,179', '18,18,125', '200,200,255', '145,145,255', '255,178,0', '179,125,0', '255,236,191', '255,217,128', '255,255,0', '179,179,0', '255,255,191', '255,255,128', '102,0,153', '71,0,107', '234,191,255', '213,128,255');
                         //// $lbl is generated somewhere upthere by the original code. We translate it for chartjs.
                         $labels = array();
                         foreach ($lbl as $name => $lb) {
                             $labels[] = $name;
                         }
                         if (isset($lblPercent)) {
                             foreach ($lblPercent as $name => $lb) {
                                 $labels_percent[] = $name;
                             }
                         } else {
                             $labels_percent = array();
                         }
                         break;
                     default:
                         break;
                 }
             }
         }
     }
     //close table/output
     if ($outputType == 'html') {
         // show this block only when we show graphs and are not in the public statics controller
         if ($usegraph == 1 && $bShowGraph && get_class(Yii::app()->getController()) !== 'Statistics_userController') {
             // We clean the labels
             $iMaxLabelLength = 0;
             // We clean the labels
             // Labels for graphs
             $iMaxLabelLength = 0;
             foreach ($aGraphLabels as $key => $label) {
                 $cleanLabel = $label;
                 $cleanLabel = viewHelper::flatEllipsizeText($cleanLabel, true, 20);
                 $graph_labels[$key] = $cleanLabel;
                 $iMaxLabelLength = strlen($cleanLabel) > $iMaxLabelLength ? strlen($cleanLabel) : $iMaxLabelLength;
             }
             if (isset($aGraphLabelsPercent)) {
                 foreach ($aGraphLabelsPercent as $key => $label) {
                     $cleanLabel = $label;
                     $cleanLabel = viewHelper::flatEllipsizeText($cleanLabel, true, 20);
                     $graph_labels_percent[$key] = $cleanLabel;
                 }
             } else {
                 $graph_labels_percent = array();
             }
             $iCanvaHeight = $iMaxLabelLength * 3;
             $aData['iCanvaHeight'] = $iCanvaHeight > 150 ? $iCanvaHeight : 150;
             $qqid = str_replace('#', '_', $qqid);
             $aData['rt'] = $rt;
             $aData['qqid'] = $qqid;
             $aData['graph_labels'] = $graph_labels;
             $aData['graph_labels_percent'] = $labels_percent;
             $aData['labels'] = $labels;
             //$aData['COLORS_FOR_SURVEY'] = COLORS_FOR_SURVEY;
             $aData['charttype'] = isset($charttype) ? $charttype : 'Bar';
             $aData['sChartname'] = '';
             $aData['grawdata'] = $grawdata;
             $aData['color'] = rand(0, 70);
             $aData['COLORS_FOR_SURVEY'] = $COLORS_FOR_SURVEY;
             $aData['lbl'] = $lbl;
             ///
             $statisticsoutput .= Yii::app()->getController()->renderPartial('/admin/export/generatestats/_statisticsoutput_graphs', $aData, true);
         }
         $statisticsoutput .= "</table></div> <!-- in statistics helper --> \n";
     }
     return array("statisticsoutput" => $statisticsoutput, "pdf" => $this->pdf, "astatdata" => $astatdata);
 }

 /**
  * Returns the adapted heading using parent function
  *
  * @param Survey $survey
  * @param FormattingOptions $oOptions
  * @param string $fieldName
  * @return string (or false)
  */
 public function getFullHeading(SurveyObj $survey, FormattingOptions $oOptions, $fieldName)
 {
     $sQuestion = "";
     static $aColumnDone = array();
     switch ($this->oldHeadFormat) {
         case 'abbreviated':
             $sQuestion = parent::getAbbreviatedHeading($survey, $fieldName);
             break;
         case 'full':
             $sQuestion = parent::getFullHeading($survey, $oOptions, $fieldName);
             break;
         default:
         case 'code':
             if (isset($survey->fieldMap[$fieldName])) {
                 $sQuestion = viewHelper::getFieldCode($survey->fieldMap[$fieldName]);
             } else {
                 // Token field
                 $sQuestion = $column;
             }
             break;
     }
     if ($oOptions->headerSpacesToUnderscores) {
         $sQuestion = str_replace(' ', '_', $sQuestion);
     }
     if ($this->exportAnswerPosition == 'aseperatecodetext') {
         if (isset($survey->fieldMap[$fieldName])) {
             $aField = $survey->fieldMap[$fieldName];
             if (!self::sameTextAndCode($aField['type'], $fieldName)) {
                 if (!array_key_exists($fieldName, $aColumnDone)) {
                     // Code export
                     $sQuestion = $this->beforeHeadColumnCode . $sQuestion . $this->afterHeadColumnCode;
                     $aColumnDone[$fieldName] = 1;
                 } else {
                     // Text export
                     $sQuestion = $this->beforeHeadColumnFull . $sQuestion . $this->afterHeadColumnFull;
                     unset($aColumnDone[$fieldName]);
                 }
             } else {
                 $sQuestion = $sQuestion;
             }
         } else {
             $sQuestion = $sQuestion;
         }
     }
     return $sQuestion;
 }

 /**
  * Delete multiple questions.
  * Called by ajax from question list.
  * Permission check is done by questions::delete()
  * @return HTML
  */
 public function deleteMultiple()
 {
     $aQidsAndLang = json_decode(Yii::app()->request->getPost('sItems'));
     $aResults = array();
     foreach ($aQidsAndLang as $sQidAndLang) {
         $aQidAndLang = explode(',', $sQidAndLang);
         $iQid = $aQidAndLang[0];
         $sLanguage = $aQidAndLang[1];
         $oQuestion = Question::model()->find('qid=:qid and language=:language', array(":qid" => $iQid, ":language" => $sLanguage));
         if (is_object($oQuestion)) {
             $aResults[$iQid]['question'] = viewHelper::flatEllipsizeText($oQuestion->question, true, 0);
             $aResults[$iQid]['result'] = $this->delete($oQuestion->sid, $oQuestion->gid, $iQid, true);
         }
     }
     Yii::app()->getController()->renderPartial('/admin/survey/Question/massive_actions/_delete_results', array('aResults' => $aResults));
 }

<?php

if (!defined('VIEW')) {
    die;
}
?>
<form method="post" action="">
    <div class="afltr-acp-top-buttons">
        <?php 
viewHelper::submitButton('submdelete', language::returnLanguageConstant('OPTIONS_CLEAR_LOG'));
?>
    </div>
    <h2><?php 
language::printLanguageConstant('HL_LOGS_SYSTEM');
?>
</h2>    
    <div class="afltr-acp-list">
        <div class="tabs">
                <ul>
                    <li><a href="#tabs-log-php"><?php 
language::printLanguageConstant('HL_LOGS_ERROR');
?>
</a></li>
                    <li><a href="#tabs-log-system"><?php 
language::printLanguageConstant('HL_LOGS_SYSTEM');
?>
</a></li>                   
                </ul>            
            
            <div id="tabs-log-php" class="small-text">
            <?php 

        ?>
</td>
                    <td class="afltr-acp-td-w1 afltr-align-center"><?php 
        if ($affiliate->getAffiliateEditedTime() > 0) {
            print date($dtMask, $affiliate->getAffiliateEditedTime());
        } else {
            print date($dtMask, $affiliate->getAffiliateAddedTime());
        }
        ?>
</td>
                    <td class="afltr-acp-td-w0 afltr-align-center"><?php 
        viewHelper::boolToText($affiliate->affiliateIsMarked());
        ?>
</td>
                    <td class="afltr-acp-td-w0 afltr-align-center"><?php 
        viewHelper::boolToText($affiliate->affiliateIsAccpted());
        ?>
</td>
                    <td class="afltr-acp-td-35px afltr-align-center"><input type="checkbox" class="afltr-checkbox" name="affiliateDelList[]" value="<?php 
        print $affiliate->getId();
        ?>
"></td>
                </tr>  
            <?php 
    }
    ?>
        <?php 
}
?>
        </table>
    </div>

<form method="post" action="index.php?step=1">
    <div class="afltr-acp-top-buttons">
        <?php 
viewHelper::submitButton('continue', language::returnLanguageConstant('NEXT_BTN'));
?>
    </div>
    <h2>Choose your language</h2>
    <div class="afltr-acp-form afltr-align-center"><?php 
viewHelper::select('lang', $languages);
?>
</div>
</form>

?>
:

                <?php 
if ($afieldcount > 255) {
    echo "\t<img src='{$imageurl}/help.gif' alt='" . $clang->gT("Help") . "' onclick='javascript:alert(\"" . $clang->gT("Your survey contains more than 255 columns of responses. Spreadsheet applications such as Excel are limited to loading no more than 255. Select the columns you wish to export in the list below.", "js") . "\")' />";
} else {
    echo "\t<img src='{$imageurl}/help.gif' alt='" . $clang->gT("Help") . "' onclick='javascript:alert(\"" . $clang->gT("Choose the columns you wish to export.", "js") . "\")' />";
}
?>
                <br /><select name='colselect[]' multiple size='20'>
                    <?php 
$i = 1;
foreach ($excesscols as $sFieldName => $fieldinfo) {
    $questiontext = viewHelper::getFieldText($fieldinfo);
    $questioncode = viewHelper::getFieldCode($fieldinfo);
    echo "<option value='{$sFieldName}'";
    if (isset($_POST['summary'])) {
        if (in_array($ec, $_POST['summary'])) {
            echo "selected";
        }
    } elseif ($i < 256) {
        echo " selected";
    }
    echo " title='{$sFieldName} : " . str_replace("'", "&#39;", $questiontext) . "'>" . ellipsize("{$i} : {$questioncode} - " . str_replace(array("\r\n", "\n", "\r"), " ", $questiontext), 45) . "</option>\n";
    $i++;
}
?>
                </select>
                <br />&nbsp;</fieldset>
            <?php 

    <h2><?php 
language::printLanguageConstant('HL_INSTALL_DBCONNECT');
?>
</h2>
    <div class="afltr-acp-form afltr-align-center">     
        <table class="afltr-acp-table">
            <tr>
                <td class="afltr-td-label afltr-align-right">
                    <?php 
language::printLanguageConstant('INSTALL_DBTYPE');
?>
:
                </td>
                <td class="afltr-padding-left">
                <?php 
viewHelper::select('dbconfig[DBTYPE]', $dbtypes, null, false, false);
?>
                </td>                
            </tr>            
            <?php 
foreach ($fields as $key => $value) {
    ?>
                <tr>
                    <td class="afltr-td-label afltr-align-right">
                        <?php 
    language::printLanguageConstant('INSTALL_' . strtoupper($key));
    ?>
:
                    </td>
                    <td class="afltr-padding-left">
                        <?php 

 private function _surveyexport($action, $iSurveyID)
 {
     viewHelper::disableHtmlLogging();
     if ($action == "exportstructurexml") {
         $fn = "limesurvey_survey_{$iSurveyID}.lss";
         $this->_addHeaders($fn, "text/xml", "Mon, 26 Jul 1997 05:00:00 GMT");
         echo surveyGetXMLData($iSurveyID);
         exit;
     } elseif ($action == "exportstructurejson") {
         $fn = "limesurvey_survey_{$iSurveyID}.json";
         $this->_addHeaders($fn, "application/json", "Mon, 26 Jul 1997 05:00:00 GMT");
         $surveyInXmlFormat = surveyGetXMLData($iSurveyID);
         // now convert this xml into json format and then return
         echo _xmlToJson($surveyInXmlFormat);
         exit;
     } elseif ($action == "exportstructurequexml") {
         if (isset($surveyprintlang) && !empty($surveyprintlang)) {
             $quexmllang = $surveyprintlang;
         } else {
             $quexmllang = Survey::model()->findByPk($iSurveyID)->language;
         }
         if (!(isset($noheader) && $noheader == TRUE)) {
             $fn = "survey_{$iSurveyID}_{$quexmllang}.xml";
             $this->_addHeaders($fn, "text/xml", "Mon, 26 Jul 1997 05:00:00 GMT");
             echo quexml_export($iSurveyID, $quexmllang);
             exit;
         }
     } elseif ($action == 'exportstructuretsv') {
         $this->_exporttsv($iSurveyID);
     } elseif ($action == "exportarchive") {
         $this->_exportarchive($iSurveyID);
     }
 }

 /**
  * This method is made final to prevent extending code from circumventing the
  * initialization process that must take place prior to any of the translation
  * infrastructure to work.
  *
  * The inialization process is dependent upon the survey being passed into the
  * write function and so must be performed when the method is called and not
  * prior to (such as in a constructor).
  *
  * All extending classes must implement the internalWrite function which is
  * the code that is called after all initialization is completed.
  *
  * @param Survey $survey
  * @param string $sLanguageCode
  * @param FormattingOptions $oOptions
  * @param boolean $bOutputHeaders Set if header should be given back
  */
 public final function write(SurveyObj $survey, $sLanguageCode, FormattingOptions $oOptions, $bOutputHeaders = true)
 {
     //Output the survey.
     $headers = array();
     if ($bOutputHeaders) {
         foreach ($oOptions->selectedColumns as $column) {
             //Survey question field, $column value is a field name from the getFieldMap function.
             switch ($oOptions->headingFormat) {
                 case 'abbreviated':
                     $value = $this->getAbbreviatedHeading($survey, $column);
                     break;
                 case 'full':
                     $value = $this->getFullHeading($survey, $oOptions, $column);
                     break;
                 default:
                 case 'code':
                     if (isset($survey->fieldMap[$column])) {
                         $value = viewHelper::getFieldCode($survey->fieldMap[$column]);
                     } else {
                         // Token field
                         $value = $column;
                     }
                     break;
             }
             if ($oOptions->headerSpacesToUnderscores) {
                 $value = str_replace(' ', '_', $value);
             }
             //$this->output.=$this->csvEscape($value).$this->separator;
             $headers[] = $value;
         }
     }
     //Output the results.
     $sFile = '';
     foreach ($survey->responses as $response) {
         $elementArray = array();
         foreach ($oOptions->selectedColumns as $column) {
             $value = $response[$column];
             if (isset($survey->fieldMap[$column]) && $survey->fieldMap[$column]['type'] != 'answer_time' && $survey->fieldMap[$column]['type'] != 'page_time' && $survey->fieldMap[$column]['type'] != 'interview_time') {
                 switch ($oOptions->answerFormat) {
                     case 'long':
                         $elementArray[] = $this->transformResponseValue($survey->getFullAnswer($column, $value, $this->translator, $this->languageCode), $survey->fieldMap[$column]['type'], $oOptions);
                         break;
                     default:
                     case 'short':
                         $elementArray[] = $this->transformResponseValue($value, $survey->fieldMap[$column]['type'], $oOptions);
                         break;
                 }
             } else {
                 $elementArray[] = $value;
             }
         }
         if ($oOptions->output == 'display') {
             $this->outputRecord($headers, $elementArray, $oOptions);
         } else {
             $sFile .= $this->outputRecord($headers, $elementArray, $oOptions);
         }
     }
     return $sFile;
 }

 /**
  * Show side menu for survey view
  * @param array $aData all the needed data
  */
 function _surveysidemenu($aData)
 {
     $iSurveyID = $aData['surveyid'];
     // TODO : create subfunctions
     $sumresult1 = Survey::model()->with(array('languagesettings' => array('condition' => 'surveyls_language=language')))->find('sid = :surveyid', array(':surveyid' => $aData['surveyid']));
     //$sumquery1, 1) ; //Checked
     if (Permission::model()->hasSurveyPermission($iSurveyID, 'surveycontent', 'read')) {
         $aData['permission'] = true;
     } else {
         $aData['gid'] = $gid = null;
         $qid = null;
         $aData['permission'] = false;
     }
     if (!is_null($sumresult1)) {
         $surveyinfo = $sumresult1->attributes;
         $surveyinfo = array_merge($surveyinfo, $sumresult1->defaultlanguage->attributes);
         $surveyinfo = array_map('flattenText', $surveyinfo);
         $aData['activated'] = $surveyinfo['active'] == 'Y';
         // Tokens
         $bTokenExists = tableExists('{{tokens_' . $iSurveyID . '}}');
         if (!$bTokenExists) {
             $aData['tokenmanagement'] = Permission::model()->hasSurveyPermission($iSurveyID, 'surveysettings', 'update') || Permission::model()->hasSurveyPermission($iSurveyID, 'tokens', 'create');
         } else {
             $aData['tokenmanagement'] = Permission::model()->hasSurveyPermission($iSurveyID, 'surveysettings', 'update') || Permission::model()->hasSurveyPermission($iSurveyID, 'tokens', 'create') || Permission::model()->hasSurveyPermission($iSurveyID, 'tokens', 'read')