[phpwsbb-commits] phpwsbb/boost install.sql,1.19,1.20 update.php,1.41,1.42

[Eloi G. <ada...@us...>]

Update of /cvsroot/phpwsbb/phpwsbb/boost
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1420/boost

Modified Files:
	install.sql update.php 
Log Message:
Fixed Bug Report [1033715] "Inserting new member rank SQL error"

Index: install.sql
===================================================================
RCS file: /cvsroot/phpwsbb/phpwsbb/boost/install.sql,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -d -r1.19 -r1.20
*** install.sql	17 Sep 2004 15:56:35 -0000	1.19
--- install.sql	26 Sep 2004 05:11:54 -0000	1.20
***************
*** 20,24 ****
      lastpost_topic_id     int NOT NULL default '0',
      lastpost_post_id      int NOT NULL default '0',
-     moderators  varchar(40) NOT NULL default '',
      PRIMARY KEY (id)
  );
--- 20,23 ----
***************
*** 110,115 ****
      PRIMARY KEY (rank_id)
  );
! INSERT INTO mod_phpwsbb_user_ranks VALUES (0, 'Site Admin', 0, 1, NULL, NULL);
! INSERT INTO mod_phpwsbb_user_ranks VALUES (1, 'Member', 0, 0, NULL, NULL);
  
  CREATE TABLE mod_phpwsbb_user_info (
--- 109,114 ----
      PRIMARY KEY (rank_id)
  );
! INSERT INTO mod_phpwsbb_user_ranks VALUES ('Site Admin', 0, 1, NULL, NULL);
! INSERT INTO mod_phpwsbb_user_ranks VALUES ('Member', 0, 0, NULL, NULL);
  
  CREATE TABLE mod_phpwsbb_user_info (

Index: update.php
===================================================================
RCS file: /cvsroot/phpwsbb/phpwsbb/boost/update.php,v
retrieving revision 1.41
retrieving revision 1.42
diff -C2 -d -r1.41 -r1.42
*** update.php	21 Sep 2004 03:12:04 -0000	1.41
--- update.php	26 Sep 2004 05:11:54 -0000	1.42
***************
*** 283,288 ****
  
      if($status = $GLOBALS['core']->query("CREATE TABLE mod_phpwsbb_user_ranks (rank_id int DEFAULT '0' NOT NULL, rank_title varchar(50) NOT NULL, rank_min smallint DEFAULT '0' NOT NULL, rank_special smallint DEFAULT '0', rank_image varchar(255), rank_image_caption varchar(255), PRIMARY KEY (rank_id))", TRUE)
!       && $status = $GLOBALS['core']->query("INSERT INTO `mod_phpwsbb_user_ranks` VALUES (0, 'Site Admin', 0, 1, NULL, NULL)", TRUE) 
!       && $status = $GLOBALS['core']->query("INSERT INTO `mod_phpwsbb_user_ranks` VALUES (1, 'Member', 0, 0, NULL, NULL)", TRUE)) 
          $content .= 'Successfully created the phpwsBB User Ranking table.<br />';
      else 
--- 283,288 ----
  
      if($status = $GLOBALS['core']->query("CREATE TABLE mod_phpwsbb_user_ranks (rank_id int DEFAULT '0' NOT NULL, rank_title varchar(50) NOT NULL, rank_min smallint DEFAULT '0' NOT NULL, rank_special smallint DEFAULT '0', rank_image varchar(255), rank_image_caption varchar(255), PRIMARY KEY (rank_id))", TRUE)
!       && $status = $GLOBALS['core']->sqlInsert(array('rank_title'=>'Site Admin','rank_min'=>'0','rank_special'=>'1','rank_image'=>NULL,'rank_image_caption'=>NULL), 'mod_phpwsbb_user_ranks')
!       && $status = $GLOBALS['core']->sqlInsert(array('rank_title'=>'Member','rank_min'=>'0','rank_special'=>'0','rank_image'=>NULL,'rank_image_caption'=>NULL), 'mod_phpwsbb_user_ranks')
          $content .= 'Successfully created the phpwsBB User Ranking table.<br />';
      else 
***************
*** 319,322 ****
          $content .= 'There was a problem creating the phpwsBB User Information table.<br />';
  }
!         
  ?>
--- 319,322 ----
          $content .= 'There was a problem creating the phpwsBB User Information table.<br />';
  }
! 
  ?>