Xaraya / Postnuke CVS Notices - Message

Note: this list is kept only as a demonstration for CVSNotice. For the latest CVS notices, see the Xaraya and Postnuke sites

Directory filter : [ all ] / postnuke_modules / New_pnadmin / html / modules / admin [ view in CVS ]

Date	Directory [filter]	File(s) [view]	Author [filter]
16 Aug 2002 17:22:18	postnuke_modules/New_pnadmin/html/modules/admin	pninit.php,1.5,1.6	Richard Cave
	Fixed SQL error in restoreToDefault()

Update of /home/cvsroot/postnuke_modules/New_pnadmin/html/modules/admin
In directory ns7.hostnuke.net:/tmp/cvs-serv8482/New_pnadmin/html/modules/admin

Modified Files:
	pninit.php 
Log Message:
Fixed SQL error in restoreToDefault()


Index: pninit.php
===================================================================
RCS file: /home/cvsroot/postnuke_modules/New_pnadmin/html/modules/admin/pninit.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** pninit.php	14 Aug 2002 21:36:18 -0000	1.5
--- pninit.php	16 Aug 2002 17:22:16 -0000	1.6
***************
*** 40,49 ****
      $column     = &$pntable['members'];
  
!     $query      = "SELECT COUNT(*) FROM ".$table." WHERE ".$column['mid']."='".$mID."'";
      $result = $dbconn->Execute( $query );
      if ($result == false) {        
!         pnSessionSetVar('errormsg', "SELECT of ".$table." table failed."); 
!     } else ( !$result->EOF ) {
!         $recordCount = $result->fields[0];
      }
  
--- 40,52 ----
      $column     = &$pntable['members'];
  
!     $query      = "SELECT ".$column['mid']." FROM ".$table." WHERE ".$column['mid']."='".$mID."'";
      $result = $dbconn->Execute( $query );
      if ($result == false) {        
!         pnSessionSetVar('errormsg', "SELECT of ".$table." table failed.");
!         return $recordCount;
!     }
!     
!     if ( !$result->EOF ) {
!         $recordCount = 1;
      }
  
***************
*** 145,149 ****
  
                  $query = "INSERT INTO ".$table.
!                     " (". $infotype_cols['gid'].")".",". $infotype_cols['mid'].
                      " VALUES ('".$groupID."','".$modID."')";
  
--- 148,152 ----
  
                  $query = "INSERT INTO ".$table.
!                     " (". $infotype_cols['gid'].",". $infotype_cols['mid'].")".
                      " VALUES ('".$groupID."','".$modID."')";
  

View Statistics - Next Notice - Previous Notice