mambax7 / smartfaq

admin/docbook_export.php

<?php

For compatibility and reusability of your code, PSR1 recommends that a file should introduce either new symbols (like classes, functions, etc.) or have side-effects (like outputting something, or including other files), but not both at the same time. The first symbol is defined on line 102 and the first side effect is on line 9.

/**
 * Module: SmartFAQ
 * Author: mariuss
 * Licence: GNU
 */

include_once dirname(dirname(dirname(__DIR__))) . '/include/cp_header.php';

$op = 'go';//'start';

if (isset($HTTP_POST_VARS['op']) && ($HTTP_POST_VARS['op'] === 'go')) {
    $op = $HTTP_POST_VARS['op'];
}

if ($op === 'start') {
    include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php';

    xoops_cp_header();

    xoops_cp_footer();
    exit();
}

if ($op === 'go') {
    header('Content-Disposition: attachment; filename=smartfaq.xml');
    header('Connection: close');
    header('Content-Type: text/xml; name=smartfaq.xml');

    echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n";
    echo "<!DOCTYPE qandaset PUBLIC \"-//OASIS//DTD DocBook XML V4.2//EN\" \"http://www.oasis-open.org/docbook/xml/4.2/docbookx.dtd\">\r\n";
    echo "<qandaset defaultlabel=\"qanda\" Conformance=\"1.0 {module version}\">\r\n";

    echo "  <blockinfo>\r\n";
    echo "    <publisher>\r\n";
    echo "      <publishername>\r\n";
    echo "        {site name}\r\n";
    echo "        <ulink url=\"{site url}\"/>\r\n";
    echo "      </publishername>\r\n";
    echo "    </publisher>\r\n";
    echo "    <date>{time of export}</date>\r\n";
    echo "  </blockinfo>\r\n";

    echo "  <title>{module title}</title>\r\n";

    $resultC = $xoopsDB->query('select * from ' . $xoopsDB->prefix('smartfaq_categories'));
    while ($arrC = $xoopsDB->fetchArray($resultC)) {
        extract($arrC, EXTR_PREFIX_ALL, 'c');

        echo "  <qandadiv ID=\"c$c_categoryid\" Revision=\"$c_created\">\r\n";
        echo '    <title>' . encodeText($c_name) . "</title>\r\n";
        echo '    <para>' . encodeText($c_description) . "</para>\r\n";

        $resultQ = $xoopsDB->query('select * from ' . $xoopsDB->prefix('smartfaq_faq') . " where categoryid=$c_categoryid");
        while ($arrQ = $xoopsDB->fetchArray($resultQ)) {
            extract($arrQ, EXTR_PREFIX_ALL, 'q');

            echo "    <qandaentry ID=\"q$q_faqid\" Revision=\"$q_datesub\" Condition=\"$q_html $q_smiley $q_xcodes\" XrefLabel=\"$q_modulelink $q_contextpage\" Vendor=\"" . getUserFullName($q_uid) . "\">\r\n";
            echo "      <question>\r\n";
            echo '        <para>' . encodeText($q_question) . "</para>\r\n";
            if (!empty($q_howdoi)) {
                echo "        <note Conformance=\"howdoi\">\r\n";
                echo "          <title>{'How do I' from language file}</title>\r\n";
                echo '          <para>' . encodeText($q_howdoi) . "</para>\r\n";
                echo "        </note>\r\n";
            }
            if (!empty($q_diduno)) {
                echo "        <note Conformance=\"diduno\">\r\n";
                echo "          <title>{'Did you know' from language file}</title>\r\n";
                echo '          <para>' . encodeText($q_diduno) . "</para>\r\n";
                echo "        </note>\r\n";
            }
            echo "      </question>\r\n";

            $resultA = $xoopsDB->query('select * from ' . $xoopsDB->prefix('smartfaq_answers') . " where answerid=$q_answerid");
            while ($arrA = $xoopsDB->fetchArray($resultA)) {
                extract($arrA, EXTR_PREFIX_ALL, 'a');

                echo "      <answer ID=\"a$a_answerid\" Revision=\"$a_datesub\" Vendor=\"" . getUserFullName($a_uid) . "\">\r\n";
                echo '        <para>' . encodeText($a_answer) . "</para>\r\n";
                echo "      </answer>\r\n";
            }
            mysqli_free_result($resultA);

            echo "    </qandaentry>\r\n";
        }
        mysqli_free_result($resultQ);

        echo "  </qandadiv>\r\n";
    }

    echo "</qandaset>\r\n";

    exit();
}

/**
 * @param $text
 * @return string
 */
function encodeText($text)
{
    return utf8_encode(htmlspecialchars($text));
}

/**
 * @param $uid
 * @return mixed
 */
function getUserFullName($uid)
{
    global $xoopsDB;

    return $uid;
}