ErrorMsg()); //Checked if($result->RecordCount() > 0) { $listsurveys= "
"; $gbc = "evenrow"; $dateformatdetails=getDateFormatData($_SESSION['dateformat']); while($rows = $result->FetchRow()) { if($rows['private']=="Y") { $privacy=$clang->gT("Yes") ; } else $privacy =$clang->gT("No") ; if (tableExists('tokens_'.$rows['sid'])) { $visibility = $clang->gT("Closed-access"); } else { $visibility = $clang->gT("Open-access"); } if($rows['active']=="Y") { if ($rows['expires']!='' && $rows['expires'] < date_shift(date("Y-m-d H:i:s"), "Y-m-d", $timeadjust)) { $status=$clang->gT("Expired") ; } elseif ($rows['startdate']!='' && $rows['startdate'] > date_shift(date("Y-m-d H:i:s"), "Y-m-d", $timeadjust)) { $status=$clang->gT("Not yet active") ; } else { $status=$clang->gT("Active") ; } // Complete Survey Responses - added by DLR $gnquery = "SELECT count(id) FROM ".db_table_name("survey_".$rows['sid'])." WHERE submitdate IS NULL"; $gnresult = db_execute_num($gnquery); //Checked while ($gnrow = $gnresult->FetchRow()) { $partial_responses=$gnrow[0]; } $gnquery = "SELECT count(id) FROM ".db_table_name("survey_".$rows['sid']); $gnresult = db_execute_num($gnquery); //Checked while ($gnrow = $gnresult->FetchRow()) { $responses=$gnrow[0]; } } else $status =$clang->gT("Inactive") ; $datetimeobj = new Date_Time_Converter($rows['datecreated'] , "Y-m-d H:i:s"); $datecreated=$datetimeobj->convert($dateformatdetails['phpdate']); if (in_array($rows['owner_id'],getuserlist('onlyuidarray'))) { $ownername=$rows['users_name'] ; } else { $ownername="---"; } $questionsCount = 0; $questionsCountQuery = "SELECT * FROM ".db_table_name('questions')." WHERE sid={$rows['sid']} AND language='".$rows['language']."'"; //Getting a count of questions for this survey $questionsCountResult = $connect->Execute($questionsCountQuery); //Checked $questionsCount = $questionsCountResult->RecordCount(); if ($gbc == "oddrow") {$gbc = "evenrow";} else {$gbc = "oddrow";} $listsurveys.=""; if ($rows['active']=="Y") { if ($rows['expires']!='' && $rows['expires'] < date_shift(date("Y-m-d H:i:s"), "Y-m-d", $timeadjust)) { $listsurveys .= ""; } else { if (hasRight($rows['sid'],'activate_survey')) { $listsurveys .= "\n"; } else { $listsurveys .= "\n"; } } } else { if ( $questionsCount > 0 && hasRight($rows['sid'],'activate_survey') ) { $listsurveys .= "\n" ; } else { $listsurveys .= "\n"; } } $listsurveys.=""; $listsurveys.="". "". "". "" . ""; if ($rows['active']=="Y") { $complete = $responses - $partial_responses; $listsurveys .= ""; $listsurveys .= ""; $listsurveys .= ""; }else{ $listsurveys .= ""; $listsurveys .= ""; $listsurveys .= ""; } $listsurveys .= "" ; } $listsurveys.="". ""; $listsurveys.="
".$clang->gT("Status")." ".$clang->gT("Survey ID")." ".$clang->gT("Survey")." ".$clang->gT("Date Created")." ".$clang->gT("Owner") ." ".$clang->gT("Access")." ".$clang->gT("Anonymous answers")." ".$clang->gT("Full Responses")." ".$clang->gT("Partial Responses")." ".$clang->gT("Total Responses")."
gTview("This survey is active - click here to deactivate this survey.")."\" >" . "".$clang->gT("This survey is active - click here to deactivate this survey.")."gTview("This survey is currently not active - click here to activate this survey.")."\" >" . "".$clang->gT("This survey is currently not active - click here to activate this survey.")."".$clang->gT("This survey is currently not active.")."" . "{$rows['sid']}{$rows['surveyls_title']}".$datecreated."".$ownername."".$visibility."".$privacy."".$complete."".$partial_responses."".$responses."   
 

" ; } else $listsurveys="

".$clang->gT("No Surveys available - please create one.")."

" ; } if ($action == "personalsettings") { // prepare data for the htmleditormode preference $edmod1=''; $edmod2=''; $edmod3=''; $edmod4=''; switch ($_SESSION['htmleditormode']) { case 'none': $edmod2="selected='selected'"; break; case 'inline': $edmod3="selected='selected'"; break; case 'popup': $edmod4="selected='selected'"; break; default: $edmod1="selected='selected'"; break; } $cssummary = "

" . "".$clang->gT("Your personal settings")."\n" . "
\n" . "
\n" . "
" . "\n" . "

"; } if ($surveyid) { if(hasRight($surveyid)) { $baselang = GetBaseLanguageFromSurveyID($surveyid); $sumquery3 = "SELECT * FROM ".db_table_name('questions')." WHERE sid=$surveyid AND language='".$baselang."'"; //Getting a count of questions for this survey $sumresult3 = $connect->Execute($sumquery3); //Checked $sumcount3 = $sumresult3->RecordCount(); $sumquery6 = "SELECT * FROM ".db_table_name('conditions')." as c, ".db_table_name('questions')."as q WHERE c.qid = q.qid AND q.sid=$surveyid"; //Getting a count of conditions for this survey $sumresult6 = $connect->Execute($sumquery6) or die("Can't coun't conditions"); //Checked $sumcount6 = $sumresult6->RecordCount(); $sumquery2 = "SELECT * FROM ".db_table_name('groups')." WHERE sid=$surveyid AND language='".$baselang."'"; //Getting a count of groups for this survey $sumresult2 = $connect->Execute($sumquery2); //Checked $sumcount2 = $sumresult2->RecordCount(); $sumquery1 = "SELECT * FROM ".db_table_name('surveys')." inner join ".db_table_name('surveys_languagesettings')." on (surveyls_survey_id=sid and surveyls_language=language) WHERE sid=$surveyid"; //Getting data for this survey $sumresult1 = db_select_limit_assoc($sumquery1, 1) ; //Checked if ($sumresult1->RecordCount()==0){die('Invalid survey id');} // if surveyid is invalid then die to prevent errors at a later time // Output starts here... $surveysummary = ""; $surveyinfo = $sumresult1->FetchRow(); $surveyinfo = array_map('strip_tags', $surveyinfo); //$surveyinfo = array_map('htmlspecialchars', $surveyinfo); $activated = $surveyinfo['active']; //BUTTON BAR $surveysummary .= "" //"\n" . "\n"; // $surveysummary .= "

 

"; //CSS Firefox 2 transition fix //SURVEY SUMMARY if ($gid || $qid || $action=="deactivate"|| $action=="activate" || $action=="surveysecurity" || $action=="surveyrights" || $action=="addsurveysecurity" || $action=="addusergroupsurveysecurity" || $action=="setsurveysecurity" || $action=="setusergroupsurveysecurity" || $action=="delsurveysecurity" || $action=="editsurvey" || $action=="addgroup" || $action=="importgroup" || $action=="ordergroups" || $action=="updatesurvey" || $action=="deletesurvey" || $action=="resetsurveylogic" || $action=="importsurveyresources" || $action=="exportstructure" || $action=="quotas" ) {$showstyle="style='display: none'";} if (!isset($showstyle)) {$showstyle="";} $additionnalLanguagesArray = GetAdditionalLanguagesFromSurveyID($surveyid); $surveysummary .= "\n" . "\n"; $surveysummary2 = ""; if ($surveyinfo['private'] != "N") {$surveysummary2 .= $clang->gT("Answers to this survey are anonymized.")."
\n";} else {$surveysummary2 .= $clang->gT("This survey is NOT anonymous.")."
\n";} if ($surveyinfo['format'] == "S") {$surveysummary2 .= $clang->gT("It is presented question by question.")."
\n";} elseif ($surveyinfo['format'] == "G") {$surveysummary2 .= $clang->gT("It is presented group by group.")."
\n";} else {$surveysummary2 .= $clang->gT("It is presented on one single page.")."
\n";} if ($surveyinfo['datestamp'] == "Y") {$surveysummary2 .= $clang->gT("Responses will be date stamped")."
\n";} if ($surveyinfo['ipaddr'] == "Y") {$surveysummary2 .= $clang->gT("IP Addresses will be logged")."
\n";} if ($surveyinfo['refurl'] == "Y") {$surveysummary2 .= $clang->gT("Referer-URL will be saved")."
\n";} if ($surveyinfo['usecookie'] == "Y") {$surveysummary2 .= $clang->gT("It uses cookies for access control.")."
\n";} if ($surveyinfo['allowregister'] == "Y") {$surveysummary2 .= $clang->gT("If tokens are used, the public may register for this survey")."
\n";} if ($surveyinfo['allowsave'] == "Y") {$surveysummary2 .= $clang->gT("Participants can save partially finished surveys")."
\n";} switch ($surveyinfo['notification']) { case 0: $surveysummary2 .= $clang->gT("No email notification")."
\n"; break; case 1: $surveysummary2 .= $clang->gT("Basic email notification")."
\n"; break; case 2: $surveysummary2 .= $clang->gT("Detailed email notification with result codes")."
\n"; break; } if(hasRight($surveyid,'edit_survey_property')) { $surveysummary2 .= $clang->gT("Regenerate Question Codes:") // . " [gT("Are you sure you want regenerate the question codes?","js")."')) {".get2post("$scriptname?action=renumberquestions&sid=$surveyid&style=straight")."}\" " . ">".$clang->gT("Straight")."] " // . "[gT("Are you sure you want regenerate the question codes?","js")."')) {".get2post("$scriptname?action=renumberquestions&sid=$surveyid&style=bygroup")."}\" " . ">".$clang->gT("By Group")."]"; $surveysummary2 .= "\n"; } $surveysummary .= "" . "\n"; if ( $modrewrite ) { $tmp_url = $GLOBALS['publicurl'] . '/' . $surveyinfo['sid']; $surveysummary .= "\n" . "\n\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n\n" . "\n"; $dateformatdetails=getDateFormatData($_SESSION['dateformat']); if (trim($surveyinfo['startdate'])!= '') { $datetimeobj = new Date_Time_Converter($surveyinfo['startdate'] , "Y-m-d H:i:s"); $startdate=$datetimeobj->convert($dateformatdetails['phpdate'].' H:i'); } else { $startdate="-"; } $surveysummary .= "\n" . "\n"; if (trim($surveyinfo['expires'])!= '') { $datetimeobj = new Date_Time_Converter($surveyinfo['expires'] , "Y-m-d H:i:s"); $expdate=$datetimeobj->convert($dateformatdetails['phpdate'].' H:i'); } else { $expdate="-"; } $surveysummary .= "\n" . "\n" . "\n" . "\n"; if (!$surveyinfo['language']) {$language=getLanguageNameFromCode($currentadminlang);} else {$language=getLanguageNameFromCode($surveyinfo['language']);} $surveysummary .= "\n"; // get the rowspan of the Additionnal languages row // is at least 1 even if no additionnal language is present $additionnalLanguagesCount = count($additionnalLanguagesArray); if ($additionnalLanguagesCount == 0) $additionnalLanguagesCount = 1; $surveysummary .= "\n"; $first=true; foreach ($additionnalLanguagesArray as $langname) { if ($langname) { if (!$first) {$surveysummary .= "";} $first=false; $surveysummary .= "\n"; } } if ($first) $surveysummary .= ""; if ($surveyinfo['surveyls_urldescription']==""){$surveyinfo['surveyls_urldescription']=$surveyinfo['surveyls_url'];} $surveysummary .= "\n" . "\n"; $surveysummary .= "\n"; $surveysummary .= "\n"; if ($activated == "Y") { $surveysummary .= "\n"; } $surveysummary .= "
" . "".$clang->gT("Title").":{$surveyinfo['surveyls_title']} " . "(".$clang->gT("ID")." {$surveyinfo['sid']})
" . $clang->gT("Survey URL") ." (".getLanguageNameFromCode($surveyinfo['language'],false)."): $tmp_url/lang-".$surveyinfo['language'].""; foreach ($additionnalLanguagesArray as $langname) { $surveysummary .= " ".getLanguageNameFromCode($langname,false)." ".$clang->gT("Flag").""; } } else { $tmp_url = $GLOBALS['publicurl'] . '/index.php?sid=' . $surveyinfo['sid']; $surveysummary .= " $tmp_url&lang=".$surveyinfo['language'].""; foreach ($additionnalLanguagesArray as $langname) { $surveysummary .= " ".getLanguageNameFromCode($langname,false)." ".$clang->gT("Flag").""; } } $surveysummary .= "
" . $clang->gT("Description:").""; if (trim($surveyinfo['surveyls_description'])!='') {$surveysummary .= " {$surveyinfo['surveyls_description']}";} $surveysummary .= "
" . $clang->gT("Welcome:")." {$surveyinfo['surveyls_welcometext']}
" . $clang->gT("Administrator:")." {$surveyinfo['admin']} ({$surveyinfo['adminemail']})
" . $clang->gT("Fax To:").""; if (trim($surveyinfo['faxto'])!='') {$surveysummary .= " {$surveyinfo['faxto']}";} $surveysummary .= "
" . $clang->gT("Start date/time:")."$startdate
" . $clang->gT("Expiry date/time:")."$expdate
" . $clang->gT("Template:")." {$surveyinfo['template']}
" . $clang->gT("Base Language:")."$language
" . $clang->gT("Additional Languages").":
 ".getLanguageNameFromCode($langname)."
" . $clang->gT("Exit Link").":"; if ($surveyinfo['surveyls_url']!="") {$surveysummary .=" {$surveyinfo['surveyls_urldescription']}";} $surveysummary .="
" . $clang->gT("Number of questions/groups").":$sumcount3/$sumcount2
" . $clang->gT("Survey currently active").":"; if ($activated == "N") { $surveysummary .= $clang->gT("No"); } else { $surveysummary .= $clang->gT("Yes"); } $surveysummary .="
" . $clang->gT("Survey table name").":".$dbprefix."survey_$surveyid
" . $clang->gT("Hints").":\n"; if ($activated == "N" && $sumcount3 == 0) { $surveysummary .= $clang->gT("Survey cannot be activated yet.")."
\n"; if ($sumcount2 == 0 && hasRight($surveyid,'define_questions')) { $surveysummary .= "[".$clang->gT("You need to add groups")."]
"; } if ($sumcount3 == 0 && hasRight($surveyid,'define_questions')) { $surveysummary .= "[".$clang->gT("You need to add questions")."]
"; } } $surveysummary .= $surveysummary2 . "
\n"; } else { include("access_denied.php"); } } if ($surveyid && $gid ) // Show the group toolbar { // TODO: check that surveyid and thus baselang are always set here $sumquery4 = "SELECT * FROM ".db_table_name('questions')." WHERE sid=$surveyid AND gid=$gid AND language='".$baselang."'"; //Getting a count of questions for this survey $sumresult4 = $connect->Execute($sumquery4); //Checked $sumcount4 = $sumresult4->RecordCount(); $grpquery ="SELECT * FROM ".db_table_name('groups')." WHERE gid=$gid AND language='".$baselang."' ORDER BY ".db_table_name('groups').".group_order"; $grpresult = db_execute_assoc($grpquery); //Checked // Check if other questions/groups are dependent upon this group $condarray=GetGroupDepsForConditions($surveyid,"all",$gid,"by-targgid"); $groupsummary = "\n"; // $groupsummary .= "

 

"; //CSS Firefox 2 transition fix if ($qid || $action=='editgroup'|| $action=='addquestion') {$gshowstyle="style='display: none'";} else {$gshowstyle="";} $groupsummary .= "\n" . "\n" . "\n\n"; if (!is_null($condarray)) { $groupsummary .= "\n" . ""; } } $groupsummary .= "\n
" . $clang->gT("Title").":" . "{$grow['group_name']} ({$grow['gid']})
" . $clang->gT("Description:").""; if (trim($grow['description'])!='') {$groupsummary .=$grow['description'];} $groupsummary .= "
" . $clang->gT("Questions with conditions to this group").":"; foreach ($condarray[$gid] as $depgid => $deprow) { foreach ($deprow['conditions'] as $depqid => $depcid) { //$groupsummary .= "[QID: ".$depqid."]"; $listcid=implode("-",$depcid); $groupsummary .= " [QID: ".$depqid."]"; } } $groupsummary .= "
\n"; } if ($surveyid && $gid && $qid) // Show the question toolbar { // TODO: check that surveyid is set and that so is $baselang //Show Question Details $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(); $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."
".$connect->ErrorMsg()); //Checked $questionsummary = "\n"; $questionsummary .= "

 

"; //CSS Firefox 2 transition fix if (returnglobal('viewanswer') || $action =="editquestion" || $action =="copyquestion") {$qshowstyle = "style='display: none'";} else {$qshowstyle = "";} $questionsummary .= "\n" . "\n" . "\n\n" . "\n\n"; if ($qrrow['preg']) { $questionsummary .= "\n\n"; } $qtypes = getqtypelist("", "array"); //qtypes = array(type code=>type description) $questionsummary .= "\n\n"; if ($qct == 0 && ($qrrow['type'] == "O" || $qrrow['type'] == "L" || $qrrow['type'] == "!" || $qrrow['type'] == "M" || $qrrow['type'] == "Q" || $qrrow['type'] == "K" || $qrrow['type'] == "A" || $qrrow['type'] == "B" || $qrrow['type'] == "C" || $qrrow['type'] == "E" || $qrrow['type'] == "P" || $qrrow['type'] == "R" || $qrrow['type'] == "F" || $qrrow['type'] == "1" || $qrrow['type'] == "H" || $qrrow['type'] == ":" || $qrrow['type'] == ";")) { $questionsummary .= "\n"; } // For Labelset Questions show the label set and warn if there is no label set configured if (($qrrow['type'] == "1" || $qrrow['type'] == "F" || $qrrow['type'] == "H" || $qrrow['type'] == "W" || $qrrow['type'] == "Z" || $qrrow['type'] == ":" || $qrrow['type'] == ";" )) { $questionsummary .= ""; if (!$qrrow['lid']) { $questionsummary .= ""; if ($qrrow['type'] == "1") // Second labelset for "multi scale" { $questionsummary .= ""; if (!$qrrow['lid1']) { $questionsummary .= ""; } } if ($qrrow['type'] == "M" or $qrrow['type'] == "P") { $questionsummary .= "" . "\n" . "\n"; } if (isset($qrrow['mandatory']) and ($qrrow['type'] != "X")) { $questionsummary .= "" . "\n" . "\n"; } if (!is_null($condarray)) { $questionsummary .= "" . "\n"; } $qid_attributes=getQuestionAttributes($qid); $questionsummary .= "
" . $clang->gT("Code:")."{$qrrow['title']}"; if ($qrrow['type'] != "X") { if ($qrrow['mandatory'] == "Y") {$questionsummary .= ": (".$clang->gT("Mandatory Question").")";} else {$questionsummary .= ": (".$clang->gT("Optional Question").")";} } $questionsummary .= "
" . $clang->gT("Question:")."".strip_tags($qrrow['question'])."
" . $clang->gT("Help:").""; if (trim($qrrow['help'])!=''){$questionsummary .= strip_tags($qrrow['help']);} $questionsummary .= "
" . $clang->gT("Validation:")."{$qrrow['preg']}" . "
" .$clang->gT("Type:")."{$qtypes[$qrrow['type']]}"; $questionsummary .="
" . "" . $clang->gT("Warning").": ". $clang->gT("You need to add answer options to this question")." " . "
". $clang->gT("Label Set").":" . $clang->gT("Warning")." - ".$clang->gT("You need to choose a label set for this question!")."\n"; } else // If label set ID is configured show the labelset name and ID { $labelsetname=$connect->GetOne("SELECT label_name FROM ".db_table_name('labelsets')." WHERE lid = ".$qrrow['lid']); $questionsummary .= "".$labelsetname." (LID: {$qrrow['lid']}) "; } // If the user has the right to edit the label sets show the icon for the label set administration if (hasRight($surveyid,'define_questions')) { $questionsummary .= "\n"; } $questionsummary .= "
". $clang->gT("Second Label Set").":" . $clang->gT("Warning")." - ".$clang->gT("You need to choose a second label set for this question!")."\n"; } else // If label set ID is configured show the labelset name and ID { $labelsetname=$connect->GetOne("SELECT label_name FROM ".db_table_name('labelsets')." WHERE lid = ".$qrrow['lid1']); $questionsummary .= "".$labelsetname." (LID: {$qrrow['lid1']}) "; } // If the user has the right to edit the second label sets show the icon for the label set administration if (hasRight($surveyid,'define_questions')) { $questionsummary .= "\n"; } $questionsummary .= "
" . $clang->gT("Option 'Other':").""; $questionsummary .= ($qrrow['other'] == "Y") ? ($clang->gT("Yes")) : ($clang->gT("No")) ; $questionsummary .= "
" . $clang->gT("Mandatory:").""; $questionsummary .= ($qrrow['mandatory'] == "Y") ? ($clang->gT("Yes")) : ($clang->gT("No")) ; $questionsummary .= "
" . $clang->gT("Other questions having conditions on this question:") . "\n"; foreach ($condarray[$qid] as $depqid => $depcid) { $listcid=implode("-",$depcid); $questionsummary .= " [QID: ".$depqid."]"; } $questionsummary .= "
"; } } if (returnglobal('viewanswer')) { $_SESSION['FileManagerContext']="edit:answer:$surveyid"; // Get languages select on survey. $anslangs = GetAdditionalLanguagesFromSurveyID($surveyid); $baselang = GetBaseLanguageFromSurveyID($surveyid); // check that there are answers for every language supported by the survey foreach ($anslangs as $language) { $qquery = "SELECT count(*) as num_ans FROM ".db_table_name('answers')." WHERE qid=$qid AND language='".$language."'"; $qresult = db_execute_assoc($qquery); //Checked $qrow = $qresult->FetchRow(); if ($qrow["num_ans"] == 0) // means that no record for the language exists in the answers table { $qquery = "INSERT INTO ".db_table_name('answers')." (SELECT `qid`,`code`,`answer`,`default_value`,`sortorder`, '".$language."' FROM ".db_table_name('answers')." WHERE qid=$qid AND language='".$baselang."')"; $connect->Execute($qquery); //Checked } } array_unshift($anslangs,$baselang); // makes an array with ALL the languages supported by the survey -> $anslangs //delete the answers in languages not supported by the survey $qquery = "SELECT DISTINCT language FROM ".db_table_name('answers')." WHERE (qid = $qid) AND (language NOT IN ('".implode("','",$anslangs)."'))"; $qresult = db_execute_assoc($qquery); //Checked while ($qrow = $qresult->FetchRow()) { $qquery = "DELETE FROM ".db_table_name('answers')." WHERE (qid = $qid) AND (language = '".$qrow["language"]."')"; $connect->Execute($qquery); //Checked } // Check sort order for answers $qquery = "SELECT type FROM ".db_table_name('questions')." WHERE qid=$qid AND language='".$baselang."'"; $qresult = db_execute_assoc($qquery); //Checked while ($qrow=$qresult->FetchRow()) {$qtype=$qrow['type'];} if (!isset($_POST['ansaction'])) { //check if any nulls exist. If they do, redo the sortorders $caquery="SELECT * FROM ".db_table_name('answers')." WHERE qid=$qid AND sortorder is null AND language='".$baselang."'"; $caresult=$connect->Execute($caquery); //Checked $cacount=$caresult->RecordCount(); if ($cacount) { fixsortorderAnswers($qid); // !!Adjust this!! } } // Print Key Control JavaScript $vasummary = PrepareEditorScript("editanswer"); $query = "SELECT sortorder FROM ".db_table_name('answers')." WHERE qid='{$qid}' AND language='".GetBaseLanguageFromSurveyID($surveyid)."' ORDER BY sortorder desc"; $result = db_execute_assoc($query) or safe_die($connect->ErrorMsg()); //Checked $anscount = $result->RecordCount(); $row=$result->FetchRow(); $maxsortorder=$row['sortorder']+1; $vasummary .= "\n" ."\n" ."\n" ."\n" ."
\n" .$clang->gT("Edit answer options") ."
gT("Error: You are trying to use duplicate answer codes.",'js')."','".$clang->gT("Error: 'other' is a reserved keyword.",'js')."');\">\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n"; $vasummary .= "
"; $first=true; $sortorderids=''; $codeids=''; $vasummary .= "
\n"; // the following line decides if the assessment input fields are visible or not // for some question types the assessment values is set in the label set instead of the answers $assessmentvisible=($surveyinfo['assessments']=='Y' && !in_array($qtype,array('A','B','C','E','F','K','R','Z',':'))); foreach ($anslangs as $anslang) { $position=0; $query = "SELECT * FROM ".db_table_name('answers')." WHERE qid='{$qid}' AND language='{$anslang}' ORDER BY sortorder, code"; $result = db_execute_assoc($query) or safe_die($connect->ErrorMsg()); //Checked $anscount = $result->RecordCount(); $vasummary .= "
" ."

".getLanguageNameFromCode($anslang, false); if ($anslang==GetBaseLanguageFromSurveyID($surveyid)) {$vasummary .= '('.$clang->gT("Base Language").')';} $vasummary .= "

\n" ."" ."\n" ."\n"; if ($assessmentvisible) { $vasummary .="\n" ."\n" ."\n" ."" .""; $alternate=false; while ($row=$result->FetchRow()) { $row['code'] = htmlspecialchars($row['code']); $row['answer']=htmlspecialchars($row['answer']); $sortorderids=$sortorderids.' '.$row['language'].'_'.$row['sortorder']; if ($first) {$codeids=$codeids.' '.$row['sortorder'];} $vasummary .= "gT("Default")."" .""; } if (($activated != 'Y' && $first) || ($activated == 'Y' && $first && (($qtype=='O') || ($qtype=='L') || ($qtype=='!') ))) { $vasummary .= ""; $vasummary .= ""; } elseif (($activated != 'N' && $first) ) // If survey is activated and its not one of the above question types who allows modfying answers on active survey { $vasummary .= "{$row['code']}"; $vasummary .= ""; } else { $vasummary .= "{$row['code']}"; } $vasummary .= "\n" .""; } elseif ( $first) { $vasummary .= " style='display:none;'>"; } elseif ($assessmentvisible) { $vasummary .= '>'.$row['assessment_value']; } else { $vasummary .= " style='display:none;'>"; } $vasummary .= "\n" ."\n" ."\n"; $position++; } ++$anscount; if ($anscount > 0) { $vasummary .= "\n"; } $position=sprintf("%05d", $position); if ($activated != 'Y' || (($activated == 'Y') && (($qtype=='O' ) || ($qtype=='L' ) ||($qtype=='!' )))) { if ($first==true) { $vasummary .= "" .""; } else { $vasummary .= " style='display:none;'>"; } $vasummary .="\n" ."\n" ."\n" ."\n" ."\n"; } } else { $vasummary .= "\n" ."\n" ."\n"; } $first=false; $vasummary .= "
\n" .$clang->gT("Code") ."".$clang->gT("Assessment value"); } else { $vasummary .=""; } $vasummary .="\n" .$clang->gT("Answer option") ."\n" .$clang->gT("Action") ."\n" .$clang->gT("Order"); $vasummary .= "
\n" ."\n" . getEditor("editanswer","answer_".$row['language']."_".$row['sortorder'], "[".$clang->gT("Answer:", "js")."](".$row['language'].")",$surveyid,$gid,$qid,'editanswer') ."\n"; // Deactivate delete button for active surveys if ($activated != 'Y' || ($activated == 'Y' && (($qtype=='O' ) || ($qtype=='L' ) ||($qtype=='!' )))) { $vasummary .= "\n"; } else { $vasummary .= "gT("Del")."' />\n"; } // Don't show Default Button for array question types if ($qtype != "A" && $qtype != "B" && $qtype != "C" && $qtype != "E" && $qtype != "F" && $qtype != "H" && $qtype != "R" && $qtype != "Q" && $qtype != "1" && $qtype != ":" && $qtype != ";") $vasummary .= "\n"; $vasummary .= "\n"; if ($position > 0) { $vasummary .= "\n"; }; if ($position < $anscount-1) { // Fill the sortorder hiddenfield so we now what field is moved down $vasummary .= "\n"; } $vasummary .= "
" ."\n" ."

" ."".$clang->gT("New answer option").": "; if (!isset($_SESSION['nextanswercode'])) $_SESSION['nextanswercode']=''; $vasummary .= ""; unset($_SESSION['nextanswercode']); $first=false; $vasummary .= "\n" ."\n" . getEditor("addanswer","insertanswer", "[".$clang->gT("Answer:", "js")."]",'','','',$action) ."\n" ."\n" ."\n" ."\n" ."\n" ."\n" ."
\n" ."" .$clang->gT("Warning").": ".$clang->gT("You cannot add answers or edit answer codes for this question type because the survey is active.")."\n" ."
\n"; $vasummary .= "\n"; $vasummary .= "\n"; $vasummary .= "
"; } $vasummary .= "
"; } // ************************************************* // Survey Rights Start **************************** // ************************************************* if($action == "addsurveysecurity") { $addsummary = "
".$clang->gT("Add User")."
\n"; $addsummary .= "
\n"; $query = "SELECT sid, owner_id FROM ".db_table_name('surveys')." WHERE sid = {$surveyid} AND owner_id = ".$_SESSION['loginID']." AND owner_id != ".$postuserid; $result = db_execute_assoc($query); //Checked if( ($result->RecordCount() > 0 && in_array($postuserid,getuserlist('onlyuidarray'))) || $_SESSION['USER_RIGHT_SUPERADMIN'] == 1) { if($postuserid > 0){ $isrquery = "INSERT INTO {$dbprefix}surveys_rights VALUES($surveyid,". $postuserid.",0,0,0,0,0,0)"; $isrresult = $connect->Execute($isrquery); //Checked if($isrresult) { $addsummary .= "
".$clang->gT("User added.")."
\n"; $addsummary .= "
" ."" ."" ."" ."
\n"; } else { // Username already exists. $addsummary .= "
".$clang->gT("Failed to add user.")."
\n" . "
" . $clang->gT("Username already exists.")."
\n"; $addsummary .= "
gT("Continue")."\"/>\n"; } } else { $addsummary .= "
".$clang->gT("Failed to add User.")."
\n" . "
" . $clang->gT("No Username selected.")."
\n"; $addsummary .= "
gT("Continue")."\"/>\n"; } } else { include("access_denied.php"); } $addsummary .= "
\n"; } if($action == "addusergroupsurveysecurity") { $addsummary = "
".$clang->gT("Add User Group")."
\n"; $addsummary .= "
\n"; $query = "SELECT sid, owner_id FROM ".db_table_name('surveys')." WHERE sid = {$surveyid} AND owner_id = ".$_SESSION['loginID']; $result = db_execute_assoc($query); //Checked if( ($result->RecordCount() > 0 && in_array($postusergroupid,getsurveyusergrouplist('simpleugidarray')) ) || $_SESSION['USER_RIGHT_SUPERADMIN'] == 1) { if($postusergroupid > 0){ $query2 = "SELECT b.uid FROM (SELECT uid FROM ".db_table_name('surveys_rights')." WHERE sid = {$surveyid}) AS c RIGHT JOIN ".db_table_name('user_in_groups')." AS b ON b.uid = c.uid WHERE c.uid IS NULL AND b.ugid = {$postusergroupid}"; $result2 = db_execute_assoc($query2); //Checked if($result2->RecordCount() > 0) { while ($row2 = $result2->FetchRow()) { $uid_arr[] = $row2['uid']; $values[] = "($surveyid, {$row2['uid']},0,0,0,0,0,0)"; } $values_implode = implode(",", $values); $isrquery = "INSERT INTO {$dbprefix}surveys_rights VALUES ".$values_implode; $isrresult = $connect->Execute($isrquery); //Checked if($isrresult) { $addsummary .= "
".$clang->gT("User Group added.")."
\n"; $_SESSION['uids'] = $uid_arr; $addsummary .= "
" ."" ."" ."" ."
\n"; } } else { // no user to add $addsummary .= "
".$clang->gT("Failed to add User Group.")."
\n"; $addsummary .= "
gT("Continue")."\"/>\n"; } } else { $addsummary .= "
".$clang->gT("Failed to add User.")."
\n" . "
" . $clang->gT("No Username selected.")."
\n"; $addsummary .= "
gT("Continue")."\"/>\n"; } } else { include("access_denied.php"); } $addsummary .= "
\n"; } if($action == "delsurveysecurity") { $addsummary = "
".$clang->gT("Deleting User")."
\n"; $addsummary .= "
\n"; $query = "SELECT sid, owner_id FROM ".db_table_name('surveys')." WHERE sid = {$surveyid} AND owner_id = ".$_SESSION['loginID']." AND owner_id != ".$postuserid; $result = db_execute_assoc($query); //Checked if($result->RecordCount() > 0 || $_SESSION['USER_RIGHT_SUPERADMIN'] == 1) { if (isset($postuserid)) { $dquery="DELETE FROM {$dbprefix}surveys_rights WHERE uid={$postuserid} AND sid={$surveyid}"; // added by Dennis $dresult=$connect->Execute($dquery); //Checked $addsummary .= "
".$clang->gT("Username").": ".sanitize_xss_string($_POST['user'])."

\n"; $addsummary .= "
".$clang->gT("Success!")."
\n"; } else { $addsummary .= "
".$clang->gT("Could not delete user. User was not supplied.")."
\n"; } $addsummary .= "
gT("Continue")."\"/>\n"; } else { include("access_denied.php"); } $addsummary .= "
\n"; } if($action == "setsurveysecurity") { $query = "SELECT sid, owner_id FROM ".db_table_name('surveys')." WHERE sid = {$surveyid} AND owner_id = ".$_SESSION['loginID']." AND owner_id != ".$postuserid; $result = db_execute_assoc($query); //Checked if($result->RecordCount() > 0 || $_SESSION['USER_RIGHT_SUPERADMIN'] == 1) { $query2 = "SELECT uid, edit_survey_property, define_questions, browse_response, export, delete_survey, activate_survey FROM ".db_table_name('surveys_rights')." WHERE sid = {$surveyid} AND uid = ".$postuserid; $result2 = db_execute_assoc($query2); //Checked if($result2->RecordCount() > 0) { $resul2row = $result2->FetchRow(); $usersummary = "
\n" . "\n\n"; $usersummary .= "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n"; //content $usersummary .= "" . "
\n" . "".$clang->gT("Set Survey Rights")."
".$clang->gT("Edit Survey Properties")."".$clang->gT("Define Questions")."".$clang->gT("Browse Responses")."".$clang->gT("Export")."".$clang->gT("Delete Survey")."".$clang->gT("Activate Survey")."
" ."" ."
\n"; } } else { include("access_denied.php"); } } if($action == "setusergroupsurveysecurity") { $query = "SELECT sid, owner_id FROM ".db_table_name('surveys')." WHERE sid = {$surveyid} AND owner_id = ".$_SESSION['loginID'];//." AND owner_id != ".$postuserid; $result = db_execute_assoc($query); //Checked if($result->RecordCount() > 0 || $_SESSION['USER_RIGHT_SUPERADMIN'] == 1) { $usersummary = "\n\n"; $usersummary .= "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n"; //content $usersummary .= "" ."" . "
\n" . "".$clang->gT("Set Survey Rights")."
".$clang->gT("Edit Survey Property")."".$clang->gT("Define Questions")."".$clang->gT("Browse Response")."".$clang->gT("Export")."".$clang->gT("Delete Survey")."".$clang->gT("Activate Survey")."
" ."" ."
\n"; } else { include("access_denied.php"); } } // This is the action to export the structure of a complete survey if($action == "exportstructure") { if(hasRight($surveyid,'export')) { $exportstructure = "
\n" ."
" .$clang->gT("Export Survey Structure")."\n

\n" ."\n"; // XXX //include("../config.php"); //echo $export4lsrc; if($export4lsrc) { $exportstructure.="
" ."\n"; } $exportstructure.="

\n" ."\n" ."\n" ."\n"; $exportstructure.="

\n"; } } // This is the action to export the structure of a group if($action == "exportstructureGroup") { if($export4lsrc === true && hasRight($surveyid,'export')) { $exportstructure = "
\n" ."\n\n" ."\n" ."\n" ."\n" ."\n" ."\n" ."\n" ."\n"; $exportstructure.="
" .$clang->gT("Export Group Structure")."\n
\n"; $exportstructure.="
" ."
\n"; // $exportstructure.="" // ."\n"; // XXX //include("../config.php"); //echo $export4lsrc; if($export4lsrc) { $exportstructure.="
" ."\n"; } $exportstructure.="
 
\n" ."\n" ."\n" ."\n" ."\n" ."

\n"; } else { include('dumpgroup.php'); } } // This is the action to export the structure of a question if($action == "exportstructureQuestion") { if($export4lsrc === true && hasRight($surveyid,'export')) { $exportstructure = "
\n" ."\n\n" ."\n" ."\n" ."\n" ."\n" ."\n" ."\n" ."\n"; $exportstructure.="
" .$clang->gT("Export Question Structure")."\n
\n"; $exportstructure.="
" ."
\n"; // $exportstructure.="" // ."\n"; // XXX //include("../config.php"); //echo $export4lsrc; if($export4lsrc) { $exportstructure.="
" ."\n"; } $exportstructure.="
 
\n" ."\n" ."\n" ."\n" ."\n" ."\n" ."

\n"; } else { include('dumpquestion.php'); } } if($action == "surveysecurity") { if(hasRight($surveyid)) { $js_adminheader_includes[]='../scripts/jquery/jquery.tablesorter.min.js'; $js_adminheader_includes[]='scripts/surveysecurity.js'; $query2 = "SELECT a.*, b.users_name, b.full_name FROM ".db_table_name('surveys_rights')." AS a INNER JOIN ".db_table_name('users')." AS b ON a.uid = b.uid WHERE a.sid = {$surveyid} AND b.uid != ".$_SESSION['loginID'] ." ORDER BY b.users_name"; $result2 = db_execute_assoc($query2); //Checked $surveysecurity ="
".$clang->gT("Survey Security")."
\n"; $surveysecurity .= "" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n"; $style="style='width: 15em;'"; $surveysecurity .= "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n"; if (isset($usercontrolSameGroupPolicy) && $usercontrolSameGroupPolicy == true) { $authorizedGroupsList=getusergrouplist('simplegidarray'); } $surveysecurity .= "\n"; if($result2->RecordCount() > 0) { // output users $row = 0; while ($resul2row = $result2->FetchRow()) { $query3 = "SELECT a.ugid FROM ".db_table_name('user_in_groups')." AS a RIGHT OUTER JOIN ".db_table_name('users')." AS b ON a.uid = b.uid WHERE b.uid = ".$resul2row['uid']; $result3 = db_execute_assoc($query3); //Checked while ($resul3row = $result3->FetchRow()) { if (!isset($usercontrolSameGroupPolicy) || $usercontrolSameGroupPolicy == false || in_array($resul3row['ugid'],$authorizedGroupsList)) { $group_ids[] = $resul3row['ugid']; } } if(isset($group_ids) && $group_ids[0] != NULL) { $group_ids_query = implode(" OR ugid=", $group_ids); unset($group_ids); $query4 = "SELECT name FROM ".db_table_name('user_groups')." WHERE ugid = ".$group_ids_query; $result4 = db_execute_assoc($query4); //Checked while ($resul4row = $result4->FetchRow()) { $group_names[] = $resul4row['name']; } if(count($group_names) > 0) $group_names_query = implode(", ", $group_names); } // else {break;} //TODO Commented by lemeur if(($row % 2) == 0) $surveysecurity .= "\n"; else $surveysecurity .= "\n"; $surveysecurity .= "\n" . "\n" . "\n"; //Now insert the rights $rightsarr = array('edit_survey_property','define_questions','browse_response','export','delete_survey','activate_survey'); foreach ($rightsarr as $right) { if ($resul2row[$right]==1) { $insert = "
"; } else { $insert = "
"; } $surveysecurity .= "\n"; } $surveysecurity .= "\n" . "\n"; $row++; } } else { $surveysecurity .= ""; //fix error on empty table } $surveysecurity .= "\n"; $surveysecurity .= "
".$clang->gT("Username")."".$clang->gT("User Group")."".$clang->gT("Full name")."\"".$clang-gT("Edit Survey Property")."\"/>\"".$clang-gT("Define Questions")."\"/>\"".$clang-gT("Browse Response")."\"/>\"".$clang-gT("Export")."\"/>\"".$clang-gT("Delete Survey")."\"/>\"".$clang-gT("Activate Survey")."\"/>".$clang->gT("Action")."
" . "
\n" . "".$clang->gT("User").": \n" . "gT("Please select a user first","js")."'); return false;}\"/>" . "" . "
\n" . "
" . "
\n" . "".$clang->gT("Groups").": \n" . "gT("Please select a user group first","js")."'); return false;}\" />" . "\n" . "
\n" . "
{$resul2row['users_name']}"; if(isset($group_names) > 0) { $surveysecurity .= $group_names_query; } else { $surveysecurity .= "---"; } unset($group_names); $surveysecurity .= "\n{$resul2row['full_name']}\n$insert\n\n"; $surveysecurity .= "
" ."" ."" ."" ."" ."
"; $surveysecurity .= "
" ."" ."" ."" ."" ."
\n"; $surveysecurity .= "
\n"; } else { include("access_denied.php"); } } elseif ($action == "surveyrights") { $addsummary = "
".$clang->gT("Set Survey Rights")."
\n"; $addsummary .= "
\n"; if(isset($postuserid)){ $query = "SELECT sid, owner_id FROM ".db_table_name('surveys')." WHERE sid = {$surveyid} "; if ($_SESSION['USER_RIGHT_SUPERADMIN'] != 1) { $query.=" AND owner_id != ".$postuserid." AND owner_id = ".$_SESSION['loginID']; } } else{ $query = "SELECT sid, owner_id FROM ".db_table_name('surveys')." WHERE sid = {$surveyid} AND owner_id = ".$_SESSION['loginID']; } $result = db_execute_assoc($query); //Checked if($result->RecordCount() > 0) { $rights = array(); if(isset($_POST['edit_survey_property']))$rights['edit_survey_property']=1; else $rights['edit_survey_property']=0; if(isset($_POST['define_questions']))$rights['define_questions']=1; else $rights['define_questions']=0; if(isset($_POST['browse_response']))$rights['browse_response']=1; else $rights['browse_response']=0; if(isset($_POST['export']))$rights['export']=1; else $rights['export']=0; if(isset($_POST['delete_survey']))$rights['delete_survey']=1; else $rights['delete_survey']=0; if(isset($_POST['activate_survey']))$rights['activate_survey']=1; else $rights['activate_survey']=0; if(isset($postuserid)){ $uids[] = $postuserid; } else{ $uids = $_SESSION['uids']; unset($_SESSION['uids']); } if(setsurveyrights($uids, $rights)) { $addsummary .= "
".$clang->gT("Update survey rights successful.")."
\n"; } else { $addsummary .= "
".$clang->gT("Failed to update survey rights!")."
\n"; } $addsummary .= "
gT("Continue")."\"/>\n"; } else { include("access_denied.php"); } $addsummary .= "
\n"; } // ************************************************* // Survey Rights End **************************** // ************************************************* // Editing the survey if ($action == "editsurvey") { if(hasRight($surveyid,'edit_survey_property')) { $esquery = "SELECT * FROM {$dbprefix}surveys WHERE sid=$surveyid"; $esresult = db_execute_assoc($esquery); //Checked while ($esrow = $esresult->FetchRow()) { $esrow = array_map('htmlspecialchars', $esrow); // header $editsurvey = "
".$clang->gT("Edit survey settings - Step 1 of 2")."
\n"; // beginning TABs section - create tab pane $editsurvey .= "
\n"; $editsurvey .= "
\n"; // General & Contact TAB $editsurvey .= "

".$clang->gT("General")."

    \n"; // Base Language $editsurvey .= "
  • \n" .GetLanguageNameFromCode($esrow['language']) . "
  • \n" // Additional languages listbox . "
  • \n" . "" . "\n" // Available languages listbox . "" . "
    gT("Add")."\" onclick=\"DoAdd()\" id=\"AddBtn\" />
    gT("Remove")." >>\" onclick=\"DoRemove(0,'')\" id=\"RemoveBtn\" />
  • \n"; $editsurvey .= ""; // Administrator... $editsurvey .= "" . "
  • \n" . "
  • \n" . "
  • \n" . "
  • \n" . "
  • \n" . "
  • \n" . "
  • \n" . "
  • \n"; // End General TAB // Create Survey Button // $editsurvey .= "
  • \n"; $editsurvey .= "
\n"; // Presentation and navigation TAB $editsurvey .= "

".$clang->gT("Presentation & Navigation")."

    \n"; //Format $editsurvey .= "
  • \n" . "\n" . "
  • \n"; //TEMPLATES $editsurvey .= "
  • \n" . "\n" . "\n" . "\n" . "
  • \n"; //Show Prev Button $editsurvey .= "
  • \n" . "
  • \n"; //Result printing $editsurvey .= "
  • \n" . "\n" . "
  • \n"; //Public statistics $editsurvey .= "
  • \n" . "\n" . "
  • \n"; //Public statistics $editsurvey .= "
  • \n" . "\n" . "
  • \n"; //Public Surveys $editsurvey .= "
  • \n" . "\n" . "
  • \n"; // End URL block $editsurvey .= "
  • \n" . "
  • "; // End Presention and navigation TAB $editsurvey .= "
\n"; // Publication and access control TAB $editsurvey .= "

".$clang->gT("Publication & Access control")."

    \n"; /* Token access $editsurvey .= "
  • \n" . "
  • \n"; */ //Set token length $editsurvey .= "
  • \n" . "\n" . "
  • \n"; // Self registration $editsurvey .= "
  • \n" . "
  • \n"; // Start date $dateformatdetails=getDateFormatData($_SESSION['dateformat']); $startdate=''; if (trim($esrow['startdate'])!= '') { $datetimeobj = new Date_Time_Converter($esrow['startdate'] , "Y-m-d H:i:s"); $startdate=$datetimeobj->convert($dateformatdetails['phpdate'].' H:i'); } $editsurvey .= "
  • \n" . "
  • \n"; // Expiration date $expires=''; if (trim($esrow['expires'])!= '') { $datetimeobj = new Date_Time_Converter($esrow['expires'] , "Y-m-d H:i:s"); $expires=$datetimeobj->convert($dateformatdetails['phpdate'].' H:i'); } $editsurvey .="
  • \n" . "
  • \n"; //COOKIES $editsurvey .= "
  • \n" . "\n" . "
  • \n"; // Use Captcha $editsurvey .= "
  • \n" . "gT("If you switch email mode, you'll have to review your email templates to fit the new format","js")."');\">\n" . "\n" . "\n" . "
  • \n"; // End Publication and access control TAB $editsurvey .= "
\n"; // Notification and Data management TAB $editsurvey .= "

".$clang->gT("Notification & Data Management")."

    \n"; //NOTIFICATION $editsurvey .= "
  • \n" . "\n" . "
  • \n"; //EMAIL SURVEY RESPONSES TO $editsurvey .= "
  • \n" . "\n" . "
  • \n"; //ANONYMOUS $editsurvey .= "
  • \n"; if ($esrow['active'] == "Y") { $editsurvey .= "\n"; if ($esrow['private'] == "N") {$editsurvey .= " ".$clang->gT("This survey is NOT anonymous.");} else {$editsurvey .= $clang->gT("Answers to this survey are anonymized.");} $editsurvey .= " (".$clang->gT("Cannot be changed").")\n" . "\n"; $editsurvey .= "\n"; } else { $editsurvey .= "\n"; } $editsurvey .= "
  • \n"; // date stamp $editsurvey .= "
  • \n"; if ($esrow['active'] == "Y") { $editsurvey .= "\n"; if ($esrow['datestamp'] != "Y") {$editsurvey .= " ".$clang->gT("Responses will not be date stamped.");} else {$editsurvey .= $clang->gT("Responses will be date stamped.");} $editsurvey .= " (".$clang->gT("Cannot be changed").")\n" . "\n"; $editsurvey .= "\n"; } else { $editsurvey .= "\n"; } $editsurvey .= "
  • \n"; // Ip Addr $editsurvey .= "
  • \n"; if ($esrow['active'] == "Y") { $editsurvey .= "\n"; if ($esrow['ipaddr'] != "Y") {$editsurvey .= " ".$clang->gT("Responses will not have the IP address logged.");} else {$editsurvey .= $clang->gT("Responses will have the IP address logged");} $editsurvey .= " (".$clang->gT("Cannot be changed").")\n" . "\n"; $editsurvey .= "\n"; } else { $editsurvey .= "\n"; } $editsurvey .= "
  • \n"; // begin REF URL Block $editsurvey .= "
  • \n"; if ($esrow['active'] == "Y") { $editsurvey .= "\n"; if ($esrow['refurl'] != "Y") {$editsurvey .= " ".$clang->gT("Responses will not have their referring URL logged.");} else {$editsurvey .= $clang->gT("Responses will have their referring URL logged.");} $editsurvey .= " (".$clang->gT("Cannot be changed").")\n" . "\n"; $editsurvey .= "\n"; } else { $editsurvey .= "\n"; } $editsurvey .= "
  • \n"; // BENBUN - END REF URL Block // Token answers persistence $editsurvey .= "
  • \n" . "
  • \n"; // Enable assessments $editsurvey .= "
  • \n" . "
  • \n"; // End Notification and Data management TAB $editsurvey .= "
\n"; // Ending First TABs Form $editsurvey .= "" . "\n" . "\n" . "\n" . "\n" ."
"; // TAB Uploaded Resources Management $ZIPimportAction = " onclick='if (validatefilename(this.form,\"".$clang->gT('Please select a file to import!','js')."\")) {this.form.submit();}'"; if (!function_exists("zip_open")) { $ZIPimportAction = " onclick='alert(\"".$clang->gT("zip library not supported by PHP, Import ZIP Disabled","js")."\");'"; } $disabledIfNoResources = ''; if (hasResources($surveyid,'survey') === false) { $disabledIfNoResources = " disabled='disabled'"; } $editsurvey .= "

".$clang->gT("Uploaded Resources Management")."

\n" . "
\n" . "\n" . "\n" . "
    \n" . "
  • \n" . "gT("Browse Uploaded Resources")."\" $disabledIfNoResources />
  • \n" . "
  • \n" . "gT("Export Resources As ZIP Archive")."\" $disabledIfNoResources />
  • \n" . "
  • \n" . "
  • \n" . "
  • \n" . "
  • \n" . "
\n"; // End TAB Uploaded Resources Management $editsurvey .= "
\n"; // End TAB pane $editsurvey .= "
\n"; // The external button to sumbit Survey edit changes $editsurvey .= "

\n"; } } else { include("access_denied.php"); } } if ($action == "updatesurvey") // Edit survey step 2 - editing language dependent settings { if(hasRight($surveyid,'edit_survey_property')) { $grplangs = GetAdditionalLanguagesFromSurveyID($surveyid); $baselang = GetBaseLanguageFromSurveyID($surveyid); array_unshift($grplangs,$baselang); $editsurvey = PrepareEditorScript(); $editsurvey .="\n" . "\n
" . "".$clang->gT("Edit survey settings - Step 2 of 2")."
\n"; $editsurvey .= "

\n" . '
'; foreach ($grplangs as $grouplang) { // this one is created to get the right default texts fo each language $bplang = new limesurvey_lang($grouplang); $esquery = "SELECT * FROM ".db_table_name("surveys_languagesettings")." WHERE surveyls_survey_id=$surveyid and surveyls_language='$grouplang'"; $esresult = db_execute_assoc($esquery); //Checked $esrow = $esresult->FetchRow(); $editsurvey .= '

'.getLanguageNameFromCode($esrow['surveyls_language'],false); if ($esrow['surveyls_language']==GetBaseLanguageFromSurveyID($surveyid)) {$editsurvey .= '('.$clang->gT("Base Language").')';} $editsurvey .= '

    '; $esrow = array_map('htmlspecialchars', $esrow); $editsurvey .= "
  • \n" . "
  • \n" . "
  • \n" . "\n" . getEditor("survey-desc","description_".$esrow['surveyls_language'], "[".$clang->gT("Description:", "js")."](".$esrow['surveyls_language'].")",'','','',$action) . "
  • \n" . "
  • \n" . "\n" . getEditor("survey-welc","welcome_".$esrow['surveyls_language'], "[".$clang->gT("Welcome:", "js")."](".$esrow['surveyls_language'].")",'','','',$action) . "
  • \n" . "
  • \n" . "\n" . getEditor("survey-endtext","endtext_".$esrow['surveyls_language'], "[".$clang->gT("End message:", "js")."](".$esrow['surveyls_language'].")",'','','',$action) . "
  • \n" . "
  • \n" . "\n" . "
  • " . "
  • \n" . "\n" . "
  • " . "
  • \n" . "
" . "
"; } $editsurvey .= '
'; $editsurvey .= "

\n" . "\n" . "\n" . "\n" . "

\n" . "
\n"; } else { include("access_denied.php"); } } if($action == "quotas") { include("quota.php"); } // Show the screen to order groups if ($action == "ordergroups") { if(hasRight($surveyid,'edit_survey_property')) { // Check if one of the up/down buttons have been clicked if (isset($_POST['groupordermethod']) && isset($_POST['sortorder'])) { $postsortorder=sanitize_int($_POST['sortorder']); switch($_POST['groupordermethod']) { // Pressing the Up button case $clang->gT("Up", "unescaped"): $newsortorder=$postsortorder-1; $oldsortorder=$postsortorder; $cdquery = "UPDATE ".db_table_name('groups')." SET group_order=-1 WHERE sid=$surveyid AND group_order=$newsortorder"; $cdresult=$connect->Execute($cdquery) or safe_die($connect->ErrorMsg()); //Checked $cdquery = "UPDATE ".db_table_name('groups')." SET group_order=$newsortorder WHERE sid=$surveyid AND group_order=$oldsortorder"; $cdresult=$connect->Execute($cdquery) or safe_die($connect->ErrorMsg()); //Checked $cdquery = "UPDATE ".db_table_name('groups')." SET group_order='$oldsortorder' WHERE sid=$surveyid AND group_order=-1"; $cdresult=$connect->Execute($cdquery) or safe_die($connect->ErrorMsg()); //Checked break; // Pressing the Down button case $clang->gT("Dn", "unescaped"): $newsortorder=$postsortorder+1; $oldsortorder=$postsortorder; $cdquery = "UPDATE ".db_table_name('groups')." SET group_order=-1 WHERE sid=$surveyid AND group_order=$newsortorder"; $cdresult=$connect->Execute($cdquery) or safe_die($connect->ErrorMsg());//Checked $cdquery = "UPDATE ".db_table_name('groups')." SET group_order='$newsortorder' WHERE sid=$surveyid AND group_order=$oldsortorder"; $cdresult=$connect->Execute($cdquery) or safe_die($connect->ErrorMsg());//Checked $cdquery = "UPDATE ".db_table_name('groups')." SET group_order=$oldsortorder WHERE sid=$surveyid AND group_order=-1"; $cdresult=$connect->Execute($cdquery) or safe_die($connect->ErrorMsg());//Checked break; } } // Move the question to specific position if ((!empty($_POST['groupmovefrom']) || (isset($_POST['groupmovefrom']) && $_POST['groupmovefrom'] == '0')) && (!empty($_POST['groupmoveto']) || (isset($_POST['groupmoveto']) && $_POST['groupmoveto'] == '0'))) { $newpos=(int)$_POST['groupmoveto']; $oldpos=(int)$_POST['groupmovefrom']; if($newpos > $oldpos) { //Move the group we're changing out of the way $cdquery = "UPDATE ".db_table_name('groups')." SET group_order=-1 WHERE sid=$surveyid AND group_order=$oldpos"; $cdresult=$connect->Execute($cdquery) or safe_die($cdquery."
".$connect->ErrorMsg()); //Move all question_orders that are less than the newpos down one $cdquery = "UPDATE ".db_table_name('groups')." SET group_order=group_order-1 WHERE sid=$surveyid AND group_order > $oldpos and group_order<=$newpos"; $cdresult=$connect->Execute($cdquery) or safe_die($connect->ErrorMsg()); //Renumber the question we're changing $cdquery = "UPDATE ".db_table_name('groups')." SET group_order=$newpos WHERE sid=$surveyid AND group_order=-1"; $cdresult=$connect->Execute($cdquery) or safe_die($connect->ErrorMsg()); } if(($newpos+1) < $oldpos) { //echo "Newpos $newpos, Oldpos $oldpos"; //Move the question we're changing out of the way $cdquery = "UPDATE ".db_table_name('groups')." SET group_order=-1 WHERE sid=$surveyid AND group_order=$oldpos"; $cdresult=$connect->Execute($cdquery) or safe_die($connect->ErrorMsg()); //Move all question_orders that are later than the newpos up one $cdquery = "UPDATE ".db_table_name('groups')." SET group_order=group_order+1 WHERE sid=$surveyid AND group_order > $newpos AND group_order <= $oldpos"; $cdresult=$connect->Execute($cdquery) or safe_die($connect->ErrorMsg()); //Renumber the question we're changing $cdquery = "UPDATE ".db_table_name('groups')." SET group_order=".($newpos+1)." WHERE sid=$surveyid AND group_order=-1"; $cdresult=$connect->Execute($cdquery) or safe_die($connect->ErrorMsg()); } } $ordergroups = "\n" . "
" . "".$clang->gT("Change Group Order")."
\n"; // Get groups dependencies regarding conditions // => Get an array of groups containing questions with conditions outside the group // $groupdepsarray[dependent-gid][target-gid]['conditions'][qid-having-conditions]=Array(cids...) $groupdepsarray = GetGroupDepsForConditions($surveyid); $nicegroupdeps=array(); if (!is_null($groupdepsarray)) { $ordergroups .= ""; } $ordergroups .= "
\n" . "\n" . "\n" . "" . "" . "
" ; $ordergroups .="
" ; } else { include("access_denied.php"); } } if ($action == "newsurvey") { if($_SESSION['USER_RIGHT_CREATE_SURVEY']) { $dateformatdetails=getDateFormatData($_SESSION['dateformat']); $newsurvey = PrepareEditorScript(); // header $newsurvey .= "
" . "".$clang->gT("Create or Import Survey")."
\n"; // begin Tabs section $newsurvey .= "
\n"; $newsurvey .= "
gT("Error: You have to enter a title for this survey.",'js')."');\" >\n"; // General and Contact TAB $newsurvey .= "

".$clang->gT("General")."

\n"; // * Survey Language $newsurvey .= "
  • \n" . " ".$clang->gT("This setting cannot be changed later!")."\n" . "
  • \n"; $newsurvey .= "" . "
  • \n" . " ".$clang->gT("(This field is mandatory.)")."
  • \n" . "
  • \n" . "" . getEditor("survey-desc","description", "[".$clang->gT("Description:", "js")."]",'','','',$action) . "
  • \n" . "
  • \n" . "" . getEditor("survey-welc","welcome", "[".$clang->gT("Welcome message:", "js")."]",'','','',$action) . "
  • \n" . "
  • \n" . "" . getEditor("survey-endtext","endtext", "[".$clang->gT("End message:", "js")."]",'','','',$action) . "
  • \n" . "
  • \n" . "
  • \n" . "
  • \n" . "
  • \n" . "
  • \n" . "
  • \n"; $newsurvey .= "
  • \n" . "
\n"; // End General TAB // Create Survey Button $newsurvey .= "

gT("Error: You have to enter a title for this survey.",'js')."')) { document.getElementById('addnewsurvey').submit(); }; return false;\" value='".$clang->gT("Create Survey")."' />\n"; $newsurvey .= "

\n"; // Presentation and navigation TAB $newsurvey .= "

".$clang->gT("Presentation & Navigation")."

\n"; $newsurvey .= "
  • \n" . "\n" . "
  • \n"; $newsurvey .= "
  • \n" . "\n" . "\n" . "\n" . "
  • \n"; //ALLOW PREV $newsurvey .= "
  • \n" . "
  • \n"; //Result printing $newsurvey .= "
  • \n" . "
  • \n"; //Public statistics $newsurvey .= "
  • \n" . "
  • \n"; //Public statistics graphs $newsurvey .= "
  • \n" . "
  • \n"; //List survey publicly $newsurvey .= "
  • \n" . "
  • \n"; // End URL $newsurvey .= "
  • \n" . "
  • \n"; // URL description $newsurvey.= "
  • \n" . "gT("Automatically load URL when survey complete?")."\n" . "
  • " //Default date format . "
  • \n" . "
"; // End Presention and navigation TAB // Create Survey Button $newsurvey .= "

gT("Error: You have to enter a title for this survey.",'js')."')) { document.getElementById('addnewsurvey').submit(); }; return false;\" value='".$clang->gT("Create Survey")."' />\n"; $newsurvey .= "

\n"; // Publication and access control TAB $newsurvey .= "

".$clang->gT("Publication & Access control")."

    \n"; // Use tokens /* $newsurvey .= "
  • \n" . "
  • \n"; */ // Set token length $newsurvey .= "
  • \n" . "" . "
  • \n"; // Public registration $newsurvey .= "
  • \n" . "
  • \n"; // Timed Start $newsurvey .= "
  • \n" . "" . " ".sprintf($clang->gT("Date format: %s"), $dateformatdetails['dateformat'].' hh:nn')."
  • \n"; // Expiration $newsurvey .= "
  • \n" . "" . " ".sprintf($clang->gT("Date format: %s"), $dateformatdetails['dateformat'].' hh:nn')."
  • \n"; //COOKIES $newsurvey .= "
  • \n" . "
  • \n"; // Use Captcha $newsurvey .= "
  • \n" . "
  • \n"; // Email format $newsurvey .= "
  • \n" . "
  • \n"; // End Publication and access control TAB // Create Survey Button $newsurvey .= "

    gT("Error: You have to enter a title for this survey.",'js')."')) { document.getElementById('addnewsurvey').submit(); }; return false;\" value='".$clang->gT("Create Survey")."' />\n"; $newsurvey .= "

\n"; // Notification and Data management TAB $newsurvey .= "

".$clang->gT("Notification & Data Management")."

    \n"; //NOTIFICATIONS $newsurvey .= "
  • \n" . "
  • \n"; //EMAIL SURVEY RESPONSES TO $newsurvey .= "
  • \n" . "\n" . "
  • \n"; // ANONYMOUS $newsurvey .= "
  • \n"; $newsurvey .= "
  • \n"; // Datestamp $newsurvey .= "
  • \n" . "
  • \n"; // IP Address $newsurvey .= "
  • \n" . "
  • \n"; // Referring URL $newsurvey .= "
  • \n" . "
  • \n"; // Token answers persistence $newsurvey .= "
  • \n" . "
  • \n"; // enable assessment mote $newsurvey .= "
  • \n" . "
\n"; // end of addnewsurvey form $newsurvey .= "\n"; // End Notification and Data management TAB // Create Survey Button $newsurvey .= "

gT("Error: You have to enter a title for this survey.",'js')."')) { document.getElementById('addnewsurvey').submit(); }; return false;\" value='".$clang->gT("Create Survey")."' />\n"; $newsurvey .= "

\n"; $newsurvey .= "
\n"; // Import TAB $newsurvey .= "

".$clang->gT("Import Survey")."

\n"; // Import Survey $newsurvey .= "
\n" . "
    \n" . "
  • \n" . "
  • \n" . "
  • \n" . "
\n" . "

\n" . "

\n"; // . "\n"; // End Import TAB $newsurvey .= "
\n"; // End TAB pane $newsurvey .= "
\n"; } else { include("access_denied.php"); } } function replacenewline ($texttoreplace) { $texttoreplace = str_replace( "\n", '
', $texttoreplace); // $texttoreplace = htmlentities( $texttoreplace, ENT_QUOTES, UTF-8); $new_str = ''; for($i = 0; $i < strlen($texttoreplace); $i++) { $new_str .= '\x' . dechex(ord(substr($texttoreplace, $i, 1))); } return $new_str; } ?>