[phpwsbb-commits] phpwsbb/boost install.sql,1.18,1.19 update.php,1.39,1.40

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

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

Modified Files:
	install.sql update.php 
Log Message:
Added field to track forum-specific moderators

Index: install.sql
===================================================================
RCS file: /cvsroot/phpwsbb/phpwsbb/boost/install.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -d -r1.18 -r1.19
*** install.sql	13 Sep 2004 19:48:23 -0000	1.18
--- install.sql	17 Sep 2004 15:56:35 -0000	1.19
***************
*** 20,23 ****
--- 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)
  );

Index: update.php
===================================================================
RCS file: /cvsroot/phpwsbb/phpwsbb/boost/update.php,v
retrieving revision 1.39
retrieving revision 1.40
diff -C2 -d -r1.39 -r1.40
*** update.php	13 Sep 2004 21:41:54 -0000	1.39
--- update.php	17 Sep 2004 15:56:36 -0000	1.40
***************
*** 290,294 ****
  
      if($status = $GLOBALS['core']->query('ALTER TABLE mod_phpwsbb_threads ADD lastpost_post_id int NOT NULL default "0"', TRUE)) {
!         if($status = $GLOBALS['core']->query('ALTER TABLE mod_phpwsbb_forums ADD posts int NOT NULL default "0", ADD lastpost_topic_label text NOT NULL, ADD lastpost_topic_id int NOT NULL default "0", ADD lastpost_post_id int NOT NULL default "0"', TRUE)) {
              $sql = 'SELECT id FROM mod_phpwsbb_threads';
              $result = $GLOBALS['core']->getCol($sql,TRUE);
--- 290,294 ----
  
      if($status = $GLOBALS['core']->query('ALTER TABLE mod_phpwsbb_threads ADD lastpost_post_id int NOT NULL default "0"', TRUE)) {
!         if($status = $GLOBALS['core']->query('ALTER TABLE mod_phpwsbb_forums ADD posts int NOT NULL default "0", ADD lastpost_topic_label text NOT NULL, ADD lastpost_topic_id int NOT NULL default "0", ADD lastpost_post_id int NOT NULL default "0", ADD moderators varchar(40) NOT NULL default ""', TRUE)) {
              $sql = 'SELECT id FROM mod_phpwsbb_threads';
              $result = $GLOBALS['core']->getCol($sql,TRUE);