|
From: Jon O. <jon...@us...> - 2006-08-01 21:01:11
|
Update of /cvsroot/mxbb/mx_kb In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv21873/modules/mx_kb Modified Files: db_install.php db_upgrade.php kb.php Log Message: Index: kb.php =================================================================== RCS file: /cvsroot/mxbb/mx_kb/kb.php,v retrieving revision 1.37 retrieving revision 1.38 diff -C2 -d -r1.37 -r1.38 *** kb.php 5 Jul 2006 22:48:25 -0000 1.37 --- kb.php 1 Aug 2006 21:00:37 -0000 1.38 *************** *** 168,171 **** --- 168,172 ---- 'stats' => 'stats', 'moderate' => 'moderator', + 'mcp' => 'mcp', 'post_comment' => 'post_comment', 'main' => 'main' ); Index: db_install.php =================================================================== RCS file: /cvsroot/mxbb/mx_kb/db_install.php,v retrieving revision 1.43 retrieving revision 1.44 diff -C2 -d -r1.43 -r1.44 *** db_install.php 5 Jul 2006 22:48:25 -0000 1.43 --- db_install.php 1 Aug 2006 21:00:37 -0000 1.44 *************** *** 84,88 **** auth_post tinyint(3) NOT NULL DEFAULT '0', auth_rate tinyint(3) NOT NULL DEFAULT '0', ! auth_comment tinyint(3) NOT NULL DEFAULT '0', auth_edit tinyint(3) NOT NULL DEFAULT '0', auth_delete tinyint(3) NOT NULL DEFAULT '2', --- 84,91 ---- auth_post tinyint(3) NOT NULL DEFAULT '0', auth_rate tinyint(3) NOT NULL DEFAULT '0', ! auth_view_comment tinyint(3) NOT NULL DEFAULT '0', ! auth_post_comment tinyint(3) NOT NULL DEFAULT '0', ! auth_edit_comment tinyint(3) NOT NULL DEFAULT '0', ! auth_delete_comment tinyint(3) NOT NULL DEFAULT '2', auth_edit tinyint(3) NOT NULL DEFAULT '0', auth_delete tinyint(3) NOT NULL DEFAULT '2', *************** *** 93,101 **** auth_post_groups smallint(5) NOT NULL default '0', auth_rate_groups smallint(5) NOT NULL default '0', ! auth_comment_groups smallint(5) NOT NULL default '0', auth_edit_groups smallint(5) NOT NULL default '0', auth_delete_groups smallint(5) NOT NULL default '0', ! auth_approval_groups smallint(5) NOT NULL default '0', ! auth_approval_edit_groups smallint(5) NOT NULL default '0', auth_moderator_groups smallint(5) NOT NULL default '0', --- 96,107 ---- auth_post_groups smallint(5) NOT NULL default '0', auth_rate_groups smallint(5) NOT NULL default '0', ! auth_view_comment_groups smallint(5) NOT NULL default '0', ! auth_post_comment_groups smallint(5) NOT NULL default '0', ! auth_edit_comment_groups smallint(5) NOT NULL default '0', ! auth_delete_comment_groups smallint(5) NOT NULL default '0', auth_edit_groups smallint(5) NOT NULL default '0', auth_delete_groups smallint(5) NOT NULL default '0', ! auth_approval_groups smallint(5) NOT NULL default '0', // not really used ! auth_approval_edit_groups smallint(5) NOT NULL default '0', // not really used auth_moderator_groups smallint(5) NOT NULL default '0', *************** *** 105,109 **** )", ! "INSERT INTO " . $mx_table_prefix . "kb_categories VALUES (1, 'Test Category', 'Just a test category', '0', '10', '-1', '-1','-1','-1','-1','-1','-1','-1', '-1', '0', '', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0' )", "CREATE TABLE " . $mx_table_prefix . "kb_articles ( --- 111,115 ---- )", ! "INSERT INTO " . $mx_table_prefix . "kb_categories VALUES (1, 'Test Category', 'Just a test category', '0', '10', '-1', '-1','-1','-1','-1','-1','-1','-1', '-1', '0', '', '0', '0', '0', '0', '0', '0', '0', '2', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0' )", "CREATE TABLE " . $mx_table_prefix . "kb_articles ( *************** *** 215,218 **** --- 221,225 ---- "INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('header_banner', '0')", + "INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('use_simple_navigation', '1')", "INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('cat_col', '2')", "INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('settings_newdays', '1')", Index: db_upgrade.php =================================================================== RCS file: /cvsroot/mxbb/mx_kb/db_upgrade.php,v retrieving revision 1.36 retrieving revision 1.37 diff -C2 -d -r1.36 -r1.37 *** db_upgrade.php 5 Jul 2006 22:48:25 -0000 1.36 --- db_upgrade.php 1 Aug 2006 21:00:37 -0000 1.37 *************** *** 415,418 **** --- 415,428 ---- $sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories MODIFY cat_order int(50) default NULL "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories CHANGE auth_comment auth_view_comment tinyint(3) NOT NULL DEFAULT '0' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories ADD auth_post_comment tinyint(3) NOT NULL DEFAULT '0' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories ADD auth_edit_comment tinyint(3) NOT NULL DEFAULT '0' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories ADD auth_delete_comment tinyint(3) NOT NULL DEFAULT '0' "; + + $sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories CHANGE auth_comment_groups auth_view_comment_groups smallint(5) NOT NULL DEFAULT '0' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories ADD auth_post_comment_groups smallint(5) NOT NULL DEFAULT '0' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories ADD auth_edit_comment_groups smallint(5) NOT NULL DEFAULT '0' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories ADD auth_delete_comment_groups smallint(5) NOT NULL DEFAULT '0' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_votes ADD rate_point tinyint(3) unsigned NOT NULL default '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_votes CHANGE votes_userid user_id mediumint(8) NOT NULL default '0' "; *************** *** 420,423 **** --- 430,434 ---- // Appearance + $sql[] = "INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('use_simple_navigation', '1') "; $sql[] = "INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('cat_col', '2') "; $sql[] = "INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('settings_newdays', '1') "; |