[Stack-cvs] stack-1-0/scripts/install stackBackup.php,NONE,1.1

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/stack/stack-1-0/scripts/install
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9469/scripts/install

Added Files:
	stackBackup.php 
Log Message:


--- NEW FILE: stackBackup.php ---
<?php
/**
* Installs the various functions needed by STACK.
* @package install
* @subpackage Stack
*/

/** 
* Include the stack settings.
*/
require('../../stackConfig.php');
require('../../stackLib.php');

include_once("{$stack_root}/scripts/stackXML.php");

$file_names = NULL;

?>
<html>
<head>
</head>
<hody>

<h1>STACK backup.</h1>

<h2>Backup all quizzes, including their questions.</h2>

<?php
/** 
* Include the stack settings.
*/

    $quiz_store = stack_db_quiz_get();

    foreach($quiz_store as $quizs) {
        $quizid = $quizs['quizid'];
        $quiz = stack_db_quiz_get($quizid);  
        stack_xml_remove_quiz_meta_defaults($quiz);         //Pass quiz by reference and remove all default metadata
        $name = stack_xml_write_quiz($quiz,"{$stack_root}/{$stack_tmpdir}/"); 
        $file_names[] = $name;
        echo get_string('FE_quiz_download','stack',''). "<a href='{$stack_web_url}tmp/{$name}'>$name</a>.<br />";
    }
?>

<h2>Backup all questions, not in quizzes.</h2>

<?php

    $query  = 'SELECT questionID, questionName, questionKeywords FROM stackQuestion';
    $result = stack_db_query($query);

    if(0 != mysql_num_rows($result)) {
       
        $question_store = NULL;
        echo '<table>'; 
        $trcol = FALSE;
        for ($i = 0; $i < mysql_num_rows($result); $i++) { 
            $row = mysql_fetch_row($result); 
            
            $usage = stack_db_quiz_question_use_report($row[0]);
            
            if (FALSE === $usage) {
                $trcol = !$trcol;
                $qkeywords = stripslashes($row[2]);
                if ('' == $row[1]) {
                    $qname = '';
                } else {
                    $qname =  stripslashes($row[1]);
                }
                
                if ($trcol) { echo "\n<tr bgcolor='#DDDDDD'>\n"; } else {  echo "\n<tr bgcolor='#DDDDFF'>\n";  }    
                echo('  <td>' .  $row[0] . "</td>\n"); 
                echo('  <td>' .  $qname . "</td>\n"); 
                echo('  <td>' . $qkeywords . "</td>\n");
                echo "</tr>\n";  
                $question_store[]=$row[0];
            } 
        }            
        echo '</table>';    

      if (NULL !== $question_store) {
          $name = stack_xml_write_question_list($question_store, "{$stack_root}/{$stack_tmpdir}/");
          $file_names[] = $name;
          echo "<p>Please download the file <a href='{$stack_web_url}tmp/{$name}'>$name</a>.</p>";
      } 

    } else {
        echo "<p>No unused questions!</p>";
    } 

show_array($file_names);

?>

</body>
</html>