[Stack-cvs] stack-1-0/scripts/rqp/moodle_16_rqp/quiz/db mysql.php,1.1,1.2 postgres7.php,1.1,1.2

[pkiddie <pk...@us...>]

Update of /cvsroot/stack/stack-1-0/scripts/rqp/moodle_16_rqp/quiz/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4725/scripts/rqp/moodle_16_rqp/quiz/db

Modified Files:
	mysql.php postgres7.php 
Log Message:
Latest version of RQPServer and client

Implemented options
Error reporting

Index: mysql.php
===================================================================
RCS file: /cvsroot/stack/stack-1-0/scripts/rqp/moodle_16_rqp/quiz/db/mysql.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql.php	12 Sep 2005 09:46:59 -0000	1.1
--- mysql.php	5 Oct 2005 11:43:44 -0000	1.2
***************
*** 912,918 ****
  										options longblob NOT NULL default '')");
  	
! 	    //Quiz options									
  	    execute_sql('ALTER TABLE '.$CFG->prefix."quiz_rqp ADD `options` longblob NOT NULL default ''");
      }
  										
      return true;
--- 912,926 ----
  										options longblob NOT NULL default '')");
  	
! 	    //Question Options									
  	    execute_sql('ALTER TABLE '.$CFG->prefix."quiz_rqp ADD `options` longblob NOT NULL default ''");
      }
+     
+     if ($oldversion < 2005093000) {
+ 	    //Quiz options
+ 	    execute_sql('CREATE TABLE '.$CFG->prefix."quiz_rqp_quiz_options (id INT( 10 ) UNSIGNED PRIMARY KEY AUTO_INCREMENT, 
+ 	    								  	quizid INT( 10 ) UNSIGNED NOT NULL,
+ 										typeid INT( 10 ) UNSIGNED NOT NULL,
+ 										options longblob NOT NULL default '')");
+     }
  										
      return true;

Index: postgres7.php
===================================================================
RCS file: /cvsroot/stack/stack-1-0/scripts/rqp/moodle_16_rqp/quiz/db/postgres7.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** postgres7.php	12 Sep 2005 09:46:59 -0000	1.1
--- postgres7.php	5 Oct 2005 11:43:44 -0000	1.2
***************
*** 1007,1010 ****
--- 1007,1017 ----
  	    modify_database('',"ALTER TABLE prefix_quiz_rqp ADD options TEXT NOT NULL default ''");
      }
+     
+     if ($oldversion < 2005093000) {
+ 	    modify_database('',"CREATE TABLE prefix_quiz_rqp_quiz_options (id SERIAL PRIMARY KEY, 
+ 										quizid integer NOT NULL default '0',
+ 										typeid integer NOT NULL default '0',
+ 										options TEXT NOT NULL default '');");    
+     }