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);
|
