Menu
▾
▴
[mxbb-commits] mx_linkdb db_install.php, 1.13, 1.14 db_upgrade.php, 1.14, 1.15 linkdb.php, 1.11, 1.12
|
From: Jon O. <jon...@us...> - 2006-08-01 21:02:22
|
Update of /cvsroot/mxbb/mx_linkdb In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv22573/modules/mx_linkdb Modified Files: db_install.php db_upgrade.php linkdb.php Log Message: massive update Index: db_install.php =================================================================== RCS file: /cvsroot/mxbb/mx_linkdb/db_install.php,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** db_install.php 5 Jul 2006 22:49:20 -0000 1.13 --- db_install.php 1 Aug 2006 21:02:19 -0000 1.14 *************** *** 83,87 **** 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', --- 83,90 ---- 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 '0', auth_edit tinyint(3) NOT NULL DEFAULT '0', auth_delete tinyint(3) NOT NULL DEFAULT '2', *************** *** 92,100 **** 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', --- 95,106 ---- 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', *************** *** 104,109 **** )", ! "INSERT INTO " . $mx_table_prefix . "linkdb_categories VALUES (1, 'PHP', '', '', '', '1', 0, '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", ! "INSERT INTO " . $mx_table_prefix . "linkdb_categories VALUES (2, 'Bulletin Board', '', 1, '', '2', 1, '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", "CREATE TABLE " . $mx_table_prefix . "linkdb ( --- 110,115 ---- )", ! "INSERT INTO " . $mx_table_prefix . "linkdb_categories VALUES (1, 'PHP', '', '', '', '1', 0, '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", ! "INSERT INTO " . $mx_table_prefix . "linkdb_categories VALUES (2, 'Bulletin Board', '', 1, '', '2', 1, '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", "CREATE TABLE " . $mx_table_prefix . "linkdb ( *************** *** 182,186 **** "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('site_logo', 'http://" . $board_config['server_name'] . $board_config['script_path'] . "linkdb/images/web_logo88a.gif')", "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('site_url', 'http://" . $board_config['server_name'] . $board_config['script_path'] . "')", - "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('settings_link_page', '10')", "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('display_interval', '6000')", "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('lock_submit_site', '0')", --- 188,191 ---- *************** *** 198,201 **** --- 203,207 ---- "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('pagination', '10')", + "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('use_simple_navigation', '1')", "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('cat_col', '2')", "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('settings_newdays', '1')", Index: linkdb.php =================================================================== RCS file: /cvsroot/mxbb/mx_linkdb/linkdb.php,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** linkdb.php 5 Jul 2006 22:49:20 -0000 1.11 --- linkdb.php 1 Aug 2006 21:02:19 -0000 1.12 *************** *** 123,132 **** // an array of all expected actions // ! $actions = array( 'category' => 'category', 'link' => 'link', 'viewall' => 'viewall', 'search' => 'search', 'rate' => 'rate', 'user_upload' => 'user_upload', 'main' => 'main' ); --- 123,136 ---- // an array of all expected actions // ! $actions = array( ! 'category' => 'category', 'link' => 'link', + 'jump' => 'jump', 'viewall' => 'viewall', 'search' => 'search', 'rate' => 'rate', 'user_upload' => 'user_upload', + 'post_comment' => 'post_comment', + 'mcp' => 'mcp', 'main' => 'main' ); *************** *** 157,159 **** --- 161,164 ---- include( $mx_root_path . 'includes/page_tail.' . $phpEx ); } + ?> \ No newline at end of file Index: db_upgrade.php =================================================================== RCS file: /cvsroot/mxbb/mx_linkdb/db_upgrade.php,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** db_upgrade.php 3 Jul 2006 20:11:30 -0000 1.14 --- db_upgrade.php 1 Aug 2006 21:02:19 -0000 1.15 *************** *** 85,89 **** $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_post tinyint(3) NOT NULL DEFAULT '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_rate tinyint(3) NOT NULL DEFAULT '0' "; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_comment tinyint(3) NOT NULL DEFAULT '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_edit tinyint(3) NOT NULL DEFAULT '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_delete tinyint(3) NOT NULL DEFAULT '2' "; --- 85,92 ---- $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_post tinyint(3) NOT NULL DEFAULT '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_rate tinyint(3) NOT NULL DEFAULT '0' "; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_view_comment tinyint(3) NOT NULL DEFAULT '0' "; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_post_comment tinyint(3) NOT NULL DEFAULT '0' "; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_edit_comment tinyint(3) NOT NULL DEFAULT '0' "; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_delete_comment tinyint(3) NOT NULL DEFAULT '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_edit tinyint(3) NOT NULL DEFAULT '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_delete tinyint(3) NOT NULL DEFAULT '2' "; *************** *** 94,98 **** $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_post_groups smallint(5) NOT NULL default '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_rate_groups smallint(5) NOT NULL default '0' "; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_comment_groups smallint(5) NOT NULL default '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_edit_groups smallint(5) NOT NULL default '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_delete_groups smallint(5) NOT NULL default '0' "; --- 97,104 ---- $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_post_groups smallint(5) NOT NULL default '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_rate_groups smallint(5) NOT NULL default '0' "; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_view_comment_groups smallint(5) NOT NULL default '0' "; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_post_comment_groups smallint(5) NOT NULL default '0' "; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_edit_comment_groups smallint(5) NOT NULL default '0' "; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_delete_comment_groups smallint(5) NOT NULL default '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_edit_groups smallint(5) NOT NULL default '0' "; $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_delete_groups smallint(5) NOT NULL default '0' "; *************** *** 117,120 **** --- 123,127 ---- $sql[] = "DELETE FROM " . $mx_table_prefix . "linkdb_config" . " WHERE config_name = 'link_validation'"; $sql[] = "DELETE FROM " . $mx_table_prefix . "linkdb_config" . " WHERE config_name = 'email_notify'"; + $sql[] = "DELETE FROM " . $mx_table_prefix . "linkdb_config" . " WHERE config_name = 'display_logo_num'"; $sql[] = "UPDATE " . $mx_table_prefix . "linkdb_config" . " *************** *** 125,137 **** $sql[] = "UPDATE " . $mx_table_prefix . "linkdb_config" . " SET config_name = 'pagination' ! WHERE config_name = 'display_logo_num'"; // General ! $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('enable_module', '0') "; // settings_disable ! $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('module_name', 'Download Database') "; // settings_dbname ! $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('wysiwyg_path', 'modules/mx_shared/') "; // settings_dbname // Appearance ! $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('settings_newdays', '1') "; // settings_dbname // Comments --- 132,145 ---- $sql[] = "UPDATE " . $mx_table_prefix . "linkdb_config" . " SET config_name = 'pagination' ! WHERE config_name = 'settings_link_page'"; // General ! $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('enable_module', '0') "; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('module_name', 'Download Database') "; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('wysiwyg_path', 'modules/mx_shared/') "; // Appearance ! $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('use_simple_navigation', '1') "; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('settings_newdays', '1') "; // Comments |
