//Count answer-options for this question $qrq = "SELECT * FROM " . db_table_name('answers') . " WHERE qid={$qid} AND language='" . $baselang . "' ORDER BY sortorder, answer"; $qrr = $connect->Execute($qrq); //Checked $qct = $qrr->RecordCount(); //Count sub-questions for this question $sqrq = "SELECT * FROM " . db_table_name('questions') . " WHERE parent_qid={$qid} AND language='" . $baselang . "'"; $sqrr = $connect->Execute($sqrq); //Checked $sqct = $sqrr->RecordCount(); $qrquery = "SELECT * FROM " . db_table_name('questions') . " WHERE gid={$gid} AND sid={$surveyid} AND qid={$qid} AND language='" . $baselang . "'"; $qrresult = db_execute_assoc($qrquery) or safe_die($qrquery . "<br />" . $connect->ErrorMsg()); //Checked $questionsummary = "<div class='menubar'>\n"; // Check if other questions in the Survey are dependent upon this question $condarray = GetQuestDepsForConditions($surveyid, "all", "all", $qid, "by-targqid", "outsidegroup"); // PREVIEW THIS QUESTION BUTTON while ($qrrow = $qrresult->FetchRow()) { $qrrow = array_map('FlattenText', $qrrow); //$qrrow = array_map('htmlspecialchars', $qrrow); $questionsummary .= "<div class='menubar-title ui-widget-header'>\n" . "<strong>" . $clang->gT("Question") . "</strong> <span class='basic'>{$qrrow['question']} (" . $clang->gT("ID") . ":{$qid})</span>\n" . "</div>\n" . "<div class='menubar-main'>\n" . "<div class='menubar-left'>\n" . "<img src='{$imageurl}/blank.gif' alt='' width='55' height='20' />\n" . "<img src='{$imageurl}/seperator.gif' alt='' />\n"; if (bHasSurveyPermission($surveyid, 'surveycontent', 'read')) { if (count(GetAdditionalLanguagesFromSurveyID($surveyid)) == 0) { $questionsummary .= "<a href=\"#\" accesskey='q' onclick=\"window.open('{$scriptname}?action=previewquestion&sid={$surveyid}&qid={$qid}', '_blank')\"" . "title=\"" . $clang->gTview("Preview This Question") . "\">" . "<img src='{$imageurl}/preview.png' alt='" . $clang->gT("Preview This Question") . "' name='previewquestionimg' /></a>\n" . "<img src='{$imageurl}/seperator.gif' alt='' />\n"; } else { $questionsummary .= "<a href=\"#\" accesskey='q' id='previewquestion'" . "title=\"" . $clang->gTview("Preview This Question") . "\">" . "<img src='{$imageurl}/preview.png' title='' alt='" . $clang->gT("Preview This Question") . "' name='previewquestionimg' /></a>\n" . "<img src='{$imageurl}/seperator.gif' alt='' />\n"; $tmp_survlangs = GetAdditionalLanguagesFromSurveyID($surveyid); $baselang = GetBaseLanguageFromSurveyID($surveyid); $tmp_survlangs[] = $baselang; rsort($tmp_survlangs); // Test question Language Selection Popup
$cdresult = $connect->Execute($cdquery) or safe_die($connect->ErrorMsg()); //Renumber the question we're changing $cdquery = "UPDATE " . db_table_name('questions') . " SET question_order=" . ($newpos + 1) . " WHERE gid={$gid} AND question_order=-1"; $cdresult = $connect->Execute($cdquery) or safe_die($connect->ErrorMsg()); } } //Get the questions for this group $baselang = GetBaseLanguageFromSurveyID($surveyid); $oqquery = "SELECT * FROM " . db_table_name('questions') . " WHERE sid={$surveyid} AND gid={$gid} AND language='" . $baselang . "' and parent_qid=0 order by question_order"; $oqresult = db_execute_assoc($oqquery); $orderquestions = "<div class='header ui-widget-header'>" . $clang->gT("Change Question Order") . "</div>"; $questioncount = $oqresult->RecordCount(); $oqarray = $oqresult->GetArray(); $minioqarray = $oqarray; // Get the condition dependecy array for all questions in this array and group $questdepsarray = GetQuestDepsForConditions($surveyid, $gid); if (!is_null($questdepsarray)) { $orderquestions .= "<br/><div class='movableNode' style='margin:0 auto;'><strong><font color='orange'>" . $clang->gT("Warning") . ":</font> " . $clang->gT("Current group is using conditional questions") . "</strong><br /><br /><i>" . $clang->gT("Re-ordering questions in this group is restricted to ensure that questions on which conditions are based aren't reordered after questions having the conditions set") . "</i></strong><br /><br/>" . $clang->gT("See the conditions marked on the following questions") . ":<ul>\n"; foreach ($questdepsarray as $depqid => $depquestrow) { foreach ($depquestrow as $targqid => $targcid) { $listcid = implode("-", $targcid); $question = arraySearchByKey($depqid, $oqarray, "qid", 1); $orderquestions .= "<li><a href='#' onclick=\"window.open('admin.php?sid=" . $surveyid . "&gid=" . $gid . "&qid=" . $depqid . "&action=conditions&markcid=" . $listcid . "','_top')\">" . $question['title'] . ": " . FlattenText($question['question']) . " [QID: " . $depqid . "] </a> "; } $orderquestions .= "</li>\n"; } $orderquestions .= "</ul></div>"; } $orderquestions .= "<form method='post' action=''><ul class='movableList'>"; for ($i = 0; $i < $questioncount; $i++) { $downdisabled = "";