[Stack-cvs] stack-1-0/scripts stackDatabase.php,1.38,1.39

[Chris S. <san...@us...>]

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

Modified Files:
	stackDatabase.php 
Log Message:


Index: stackDatabase.php
===================================================================
RCS file: /cvsroot/stack/stack-1-0/scripts/stackDatabase.php,v
retrieving revision 1.38
retrieving revision 1.39
diff -C2 -d -r1.38 -r1.39
*** stackDatabase.php	30 Aug 2005 14:29:25 -0000	1.38
--- stackDatabase.php	30 Aug 2005 14:46:54 -0000	1.39
***************
*** 1190,1195 ****
      $user = FALSE;
      $stackUserKeys = array_keys($stackUser);
!     
!     $query  = "SELECT * FROM stackUser WHERE username = '$username'";
  
      $result = stack_db_query($query);
--- 1190,1199 ----
      $user = FALSE;
      $stackUserKeys = array_keys($stackUser);
! 
!     foreach ($stackUserKeys as $val) {
!           $query     .= ' ,'.$val;
!     }    
!     $query  = substr($query,2,strlen($query)-2);
!     $query  = "SELECT $query FROM stackUser WHERE username = '$username'";
  
      $result = stack_db_query($query);
***************
*** 1384,1391 ****
     $quiz_list   = NULL;
     $quiz_fields = array_keys($stackQuiz);
     if ('' == $quizid) {
!        $query       = "SELECT * FROM stackQuiz";
     } else {
!        $query       = "SELECT * FROM stackQuiz WHERE quizid = '$quizid'";
     }   
     $result = stack_db_query($query);
--- 1388,1401 ----
     $quiz_list   = NULL;
     $quiz_fields = array_keys($stackQuiz);
+ 
+     foreach ($quiz_fields as $val) {
+           $query     .= ' ,'.$val;
+     }    
+     $query = substr($query,2,strlen($query)-2);
+ 
     if ('' == $quizid) {
!        $query       = "SELECT $query FROM stackQuiz";
     } else {
!        $query       = "SELECT $query FROM stackQuiz WHERE quizid = '$quizid'";
     }   
     $result = stack_db_query($query);
***************
*** 1530,1544 ****
  * @param int     $quizid     The quizid number of the quiz needed.
  * @param int     $questionID The questionID of the question!
! * @param int	 $qord	     The order of the question in the quiz, optional
  * @return void
  */
  function stack_db_quiz_add_question($quizid,$questionID,$qord='NULL') {
  
! 	if ($qord==='NULL')
             $query  = "INSERT INTO quiz_question (quizid, questionID) VALUES ('$quizid','$questionID')"; 
! 	
! 	else
! 	   $query = "INSERT INTO quiz_question (quizid, questionID, qord) VALUES ('$quizid','$questionID','$qord')";
! 	   
      $result = stack_db_query($query);
  }
--- 1540,1554 ----
  * @param int     $quizid     The quizid number of the quiz needed.
  * @param int     $questionID The questionID of the question!
! * @param int     $qord       The order of the question in the quiz, optional
  * @return void
  */
  function stack_db_quiz_add_question($quizid,$questionID,$qord='NULL') {
  
!     if ($qord==='NULL')
             $query  = "INSERT INTO quiz_question (quizid, questionID) VALUES ('$quizid','$questionID')"; 
!     
!     else
!        $query = "INSERT INTO quiz_question (quizid, questionID, qord) VALUES ('$quizid','$questionID','$qord')";
!        
      $result = stack_db_query($query);
  }