public function dumplabel() { $lid = sanitize_int(Yii::app()->request->getParam('lid')); // DUMP THE RELATED DATA FOR A SINGLE QUESTION INTO A SQL FILE FOR IMPORTING LATER ON OR // ON ANOTHER SURVEY SETUP DUMP ALL DATA WITH RELATED QID FROM THE FOLLOWING TABLES // 1. questions // 2. answers $lids = returnGlobal('lids'); if (!$lid && !$lids) { die('No LID has been provided. Cannot dump label set.'); } if ($lid) { $lids = array($lid); } $lids = array_map('sanitize_int', $lids); $fn = "limesurvey_labelset_" . implode('_', $lids) . ".lsl"; $xml = getXMLWriter(); $this->_addHeaders($fn, "text/html/force-download", "Mon, 26 Jul 1997 05:00:00 GMT", "cache"); $xml->openURI('php://output'); $xml->setIndent(TRUE); $xml->startDocument('1.0', 'UTF-8'); $xml->startElement('document'); $xml->writeElement('LimeSurveyDocType', 'Label set'); $xml->writeElement('DBVersion', getGlobalSetting("DBVersion")); // Label sets table $lsquery = "SELECT * FROM {{labelsets}} WHERE lid=" . implode(' or lid=', $lids); buildXMLFromQuery($xml, $lsquery, 'labelsets'); // Labels $lquery = "SELECT lid, code, title, sortorder, language, assessment_value FROM {{labels}} WHERE lid=" . implode(' or lid=', $lids); buildXMLFromQuery($xml, $lquery, 'labels'); $xml->endElement(); // close columns $xml->endDocument(); exit; }
// 1. questions // 2. answers //Ensure script is not run directly, avoid path disclosure include_once "login_check.php"; require_once "export_data_functions.php"; $lids = returnglobal('lids'); $lid = returnglobal('lid'); if (!$lid && !$lids) { die('No LID has been provided. Cannot dump label set.'); } if ($lid) { $lids = array($lid); } $lids = array_map('sanitize_int', $lids); $fn = "limesurvey_labelset_" . implode('_', $lids) . ".lsl"; $xml = getXMLWriter(); header("Content-Type: text/html/force-download"); header("Content-Disposition: attachment; filename={$fn}"); header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Pragma: cache"); // HTTP/1.0 $xml->openURI('php://output'); $xml->setIndent(true); $xml->startDocument('1.0', 'UTF-8'); $xml->startElement('document'); $xml->writeElement('LimeSurveyDocType', 'Label set'); $xml->writeElement('DBVersion', $dbversionnumber); getXMLStructure($xml, $lids);
function getXMLData($exclude = array()) { global $dbversionnumber, $surveyid; $xml = getXMLWriter(); $xml->openMemory(); $xml->setIndent(true); $xml->startDocument('1.0', 'UTF-8'); $xml->startElement('document'); $xml->writeElement('LimeSurveyDocType', 'Survey'); $xml->writeElement('DBVersion', $dbversionnumber); $xml->startElement('languages'); $surveylanguages = GetAdditionalLanguagesFromSurveyID($surveyid); $surveylanguages[] = GetBaseLanguageFromSurveyID($surveyid); foreach ($surveylanguages as $surveylanguage) { $xml->writeElement('language', $surveylanguage); } $xml->endElement(); getXMLStructure($xml, $exclude); $xml->endElement(); // close columns $xml->endDocument(); return $xml->outputMemory(true); }
function questionExport($action, $iSurveyID, $gid, $qid) { $fn = "limesurvey_question_{$qid}.lsq"; $xml = getXMLWriter(); header("Content-Type: application/force-download"); header("Content-Disposition: attachment; filename={$fn}"); header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Pragma: cache"); // HTTP/1.0 $xml->openURI('php://output'); $xml->setIndent(true); $xml->startDocument('1.0', 'UTF-8'); $xml->startElement('document'); $xml->writeElement('LimeSurveyDocType', 'Question'); $xml->writeElement('DBVersion', getGlobalSetting('DBVersion')); $xml->startElement('languages'); $aLanguages = Survey::model()->findByPk($iSurveyID)->additionalLanguages; $aLanguages[] = Survey::model()->findByPk($iSurveyID)->language; foreach ($aLanguages as $sLanguage) { $xml->writeElement('language', $sLanguage); } $xml->endElement(); questionGetXMLStructure($xml, $gid, $qid); $xml->endElement(); // close columns $xml->endDocument(); exit; }