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 />';
}
!
?>
|
