Example #1
0
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);
}
Example #2
0
    // 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";
Example #3
0
$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";