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); }
// HTTP/1.0 $xml->openURI('php://output'); } $xml->setIndent(true); $xml->startDocument('1.0', 'UTF-8'); $xml->startElement('document'); $xml->writeElement('LimeSurveyDocType', 'Group'); $xml->writeElement('DBVersion', $dbversionnumber); $xml->startElement('languages'); $lquery = "SELECT language\n FROM {$dbprefix}groups \n WHERE gid={$gid} group by language"; $lresult = db_execute_assoc($lquery); while ($row = $lresult->FetchRow()) { $xml->writeElement('language', $row['language']); } $xml->endElement(); getXMLStructure($xml, $gid); $xml->endElement(); // close columns $xml->endDocument(); exit; function getXMLStructure($xml, $gid) { global $dbprefix, $connect; // Groups $gquery = "SELECT *\n FROM {$dbprefix}groups \n WHERE gid={$gid}"; BuildXMLFromQuery($xml, $gquery); // Questions table $qquery = "SELECT *\n FROM {$dbprefix}questions \n WHERE gid={$gid} and parent_qid=0 order by question_order, language, scale_id"; BuildXMLFromQuery($xml, $qquery); // Questions table - Subquestions $qquery = "SELECT *\n FROM {$dbprefix}questions \n WHERE gid={$gid} and parent_qid>0 order by question_order, language, scale_id";
$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); $xml->endElement(); // close columns $xml->endDocument(); exit; function getXMLStructure($xml, $lids) { global $dbprefix; // Label sets table $lsquery = "SELECT * FROM {$dbprefix}labelsets WHERE lid=" . implode(' or lid=', $lids); BuildXMLFromQuery($xml, $lsquery, 'labelsets'); // Labels $lquery = "SELECT lid, code, title, sortorder, language, assessment_value FROM {$dbprefix}labels WHERE lid=" . implode(' or lid=', $lids); BuildXMLFromQuery($xml, $lquery, 'labels'); }
// 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', $dbversionnumber); $xml->startElement('languages'); $lquery = "SELECT language\n FROM {$dbprefix}questions \n WHERE qid={$qid} or parent_qid={$qid} group by language"; $lresult = db_execute_assoc($lquery); while ($row = $lresult->FetchRow()) { $xml->writeElement('language', $row['language']); } $xml->endElement(); getXMLStructure($xml, $qid); $xml->endElement(); // close columns $xml->endDocument(); exit; function getXMLStructure($xml, $qid) { global $dbprefix, $connect; // Questions table $qquery = "SELECT *\n FROM {$dbprefix}questions \n WHERE qid={$qid} and parent_qid=0 order by language, scale_id, question_order"; BuildXMLFromQuery($xml, $qquery); // Questions table - Subquestions $qquery = "SELECT *\n FROM {$dbprefix}questions \n WHERE parent_qid={$qid} order by language, scale_id, question_order"; BuildXMLFromQuery($xml, $qquery, 'subquestions'); // Answers table $aquery = "SELECT *\n FROM {$dbprefix}answers \n WHERE qid = {$qid} order by language, scale_id, sortorder";