[Xoops-cvs2] xoops2/install index.php,1.6,1.7

[<ok...@us...>]

Update of /cvsroot/xoops/xoops2/install
In directory sc8-pr-cvs1:/tmp/cvs-serv14503/install

Modified Files:
	index.php 
Log Message:
added global comments feature

Index: index.php
===================================================================
RCS file: /cvsroot/xoops/xoops2/install/index.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** index.php	6 Jan 2003 09:07:18 -0000	1.6
--- index.php	7 Jan 2003 21:31:58 -0000	1.7
***************
*** 874,877 ****
--- 874,878 ----
            `hassearch` tinyint(1) unsigned NOT NULL default '0',
            `hasconfig` tinyint(1) unsigned NOT NULL default '0',
+           hascomments tinyint(1) unsigned NOT NULL default '0',
            PRIMARY KEY  (`mid`),
            KEY `hasmain` (`hasmain`),
***************
*** 891,895 ****
          }
  
!         $xoopsDB->queryF("INSERT INTO ".$xoopsDB->prefix("modules")." VALUES (1, '"._MI_SYSTEM_NAME."', 100, ".time().", 0, 1, 'system', 0, 1, 0, 0)");
  
  
--- 892,896 ----
          }
  
!         $xoopsDB->queryF("INSERT INTO ".$xoopsDB->prefix("modules")." VALUES (1, '"._MI_SYSTEM_NAME."', 100, ".time().", 0, 1, 'system', 0, 1, 0, 0, 0)");
  
  
***************
*** 1280,1284 ****
            `user_msnm` varchar(100) NOT NULL default '',
            `pass` varchar(32) NOT NULL default '',
!           `posts` mediumint(8) NOT NULL default '0',
            `attachsig` TINYINT(1) unsigned NOT NULL default '0',
            `rank` smallint(5) unsigned NOT NULL default '0',
--- 1281,1285 ----
            `user_msnm` varchar(100) NOT NULL default '',
            `pass` varchar(32) NOT NULL default '',
!           `posts` mediumint(8) unsigned NOT NULL default '0',
            `attachsig` TINYINT(1) unsigned NOT NULL default '0',
            `rank` smallint(5) unsigned NOT NULL default '0',
***************
*** 1859,1862 ****
--- 1860,1900 ----
  }
  $result = $xoopsDB->queryF("INSERT INTO ".$xoopsDB->prefix('imgset_themeset_link')." VALUES (1, 'default')");
+ 
+ 
+ $result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('comments')." (
+   com_id mediumint(8) unsigned NOT NULL auto_increment,
+   com_pid mediumint(8) unsigned NOT NULL default '0',
+   com_rootid mediumint(8) unsigned NOT NULL default '0',
+   com_modid smallint(5) unsigned NOT NULL default '0',
+   com_itemid mediumint(8) unsigned NOT NULL default '0',
+   com_icon varchar(25) NOT NULL default '',
+   com_created int(10) unsigned NOT NULL default '0',
+   com_modified int(10) unsigned NOT NULL default '0',
+   com_uid mediumint(8) unsigned NOT NULL default '0',
+   com_ip varchar(15) NOT NULL default '',
+   com_title varchar(255) NOT NULL default '',
+   com_text text NOT NULL,
+   com_sig tinyint(1) unsigned NOT NULL default '0',
+   com_status tinyint(1) unsigned NOT NULL default '0',
+   dohtml tinyint(1) unsigned NOT NULL default '0',
+   dosmiley tinyint(1) unsigned NOT NULL default '0',
+   doxcode tinyint(1) unsigned NOT NULL default '0',
+   doimage tinyint(1) unsigned NOT NULL default '0',
+   dobr tinyint(1) unsigned NOT NULL default '0',
+   PRIMARY KEY  (com_id),
+   KEY com_pid (com_pid),
+   KEY com_itemid (com_itemid),
+   KEY com_uid (com_uid),
+   KEY com_title (com_title(40))
+ ) TYPE=MyISAM");
+ 
+ if (!$result) {
+ 	for ($i = 0; $i < count($madetables); $i++) {
+ 		$xoopsDB->queryF("DROP table ".$madetables[$i]."");
+ 	}
+ 	dieXoopsInstall("<b>".sprintf(_INSTALL_L44, $xoopsDB->prefix('comments'))."</b>");
+ } else {
+ 	array_push($madetables, $xoopsDB->prefix('comments'));
+ }
  
  $result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('online')." (