Menu
▾
▴
[mxbb-commits] mx_linkdb db_install.php, 1.10, 1.11 db_upgrade.php, 1.12, 1.13
|
From: Jon O. <jon...@us...> - 2006-07-03 09:18:06
|
Update of /cvsroot/mxbb/mx_linkdb In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv22188/modules/mx_linkdb Modified Files: db_install.php db_upgrade.php Log Message: Working... Index: db_install.php =================================================================== RCS file: /cvsroot/mxbb/mx_linkdb/db_install.php,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** db_install.php 1 Jul 2006 22:01:23 -0000 1.10 --- db_install.php 3 Jul 2006 09:18:01 -0000 1.11 *************** *** 57,115 **** cat_id int(10) NOT NULL auto_increment, cat_name text, cat_parent int(50) default NULL, parents_data text NOT NULL, cat_order int(50) default NULL, cat_links mediumint(8) NOT NULL default '-1', PRIMARY KEY (cat_id), KEY cat_order (cat_order) )", ! "INSERT INTO " . $mx_table_prefix . "linkdb_categories VALUES (1,'PHP',0,'',1,1)", ! "INSERT INTO " . $mx_table_prefix . "linkdb_categories VALUES (2,'Bulletin Board',1,'',2,-1)", "CREATE TABLE " . $mx_table_prefix . "linkdb ( link_id mediumint(8) unsigned NOT NULL auto_increment, link_name text, link_longdesc text, link_catid mediumint(8) unsigned NOT NULL default '0', link_url varchar(100) NOT NULL default '', link_logo_src varchar(120) default NULL, link_time int(25) default '0', - link_approved tinyint(1) NOT NULL default '0', - link_hits int(10) unsigned NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', poster_ip varchar(8) NOT NULL default '', - last_user_ip varchar(8) NOT NULL default '', post_username varchar(25) default NULL, PRIMARY KEY (link_id) )", ! "INSERT INTO " . $mx_table_prefix . "linkdb VALUES (1, 'phpBB Official Website', 'Official phpBB Website', 2, 'http://www.phpbb.com/', 'linkdb/images/phpBB_88a.gif', " . time() . ", 1, 0, " . $tmp . ", '', '', '')", "CREATE TABLE " . $mx_table_prefix . "linkdb_config ( config_name varchar(255) NOT NULL default '', ! config_value varchar(255) NOT NULL default '' )", ! "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 ('width', '88')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('height', '31')", ! "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 ('display_logo_num', '10')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('display_links_logo', '1')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('email_notify', '1')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('pm_notify ', '0')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('lock_submit_site', '0')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_no_logo', '0')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('cat_col', '2')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('sort_method', 'link_time')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('sort_order', 'DESC')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_guest_submit_site', '0')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('split_links', '1')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_vote', '1')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('linkdb_versions', '0.0.7')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('link_validation', '1')", "CREATE TABLE " . $mx_table_prefix . "linkdb_custom ( --- 57,153 ---- cat_id int(10) NOT NULL auto_increment, cat_name text, + cat_desc text, cat_parent int(50) default NULL, parents_data text NOT NULL, cat_order int(50) default NULL, + cat_allow_file tinyint(2) NOT NULL default '1', + + cat_allow_comments tinyint(2) NOT NULL default '-1', + internal_comments tinyint(2) NOT NULL default '-1', + autogenerate_comments tinyint(2) NOT NULL default '-1', + comments_forum_id mediumint(8) NOT NULL DEFAULT '-1', + + cat_allow_ratings tinyint(2) NOT NULL default '-1', + + show_pretext tinyint(2) NOT NULL default '-1', + + notify tinyint(2) NOT NULL default '-1', + notify_group mediumint(8) NOT NULL default '-1', + cat_links mediumint(8) NOT NULL default '-1', + cat_last_link_id mediumint(8) unsigned NOT NULL default '0', + cat_last_link_name varchar(255) NOT NULL default '', + cat_last_link_time INT(50) UNSIGNED NOT NULL default '0', + + auth_view tinyint(3) NOT NULL DEFAULT '0', + 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', + auth_approval tinyint(3) NOT NULL DEFAULT '0', + auth_approval_edit tinyint(3) NOT NULL DEFAULT '0', + + auth_view_groups smallint(5) NOT NULL default '0', + 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', + PRIMARY KEY (cat_id), KEY cat_order (cat_order) )", ! "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 ( link_id mediumint(8) unsigned NOT NULL auto_increment, link_name text, + link_desc text, link_longdesc text, link_catid mediumint(8) unsigned NOT NULL default '0', + link_approved tinyint(1) NOT NULL default '0', + link_url varchar(100) NOT NULL default '', link_logo_src varchar(120) default NULL, + link_time int(25) default '0', user_id mediumint(8) NOT NULL default '0', poster_ip varchar(8) NOT NULL default '', post_username varchar(25) default NULL, + last_user_ip varchar(8) NOT NULL default '', + link_hits int(10) unsigned NOT NULL default '0', + PRIMARY KEY (link_id) )", ! "INSERT INTO " . $mx_table_prefix . "linkdb VALUES (1, 'phpBB Official Website', 'Official phpBB Website', '', 2, 1, 'http://www.phpbb.com/', 'linkdb/images/phpBB_88a.gif', " . time() . ", " . $userdata['user_id'] . ", '', '', '', '')", "CREATE TABLE " . $mx_table_prefix . "linkdb_config ( config_name varchar(255) NOT NULL default '', ! config_value varchar(255) NOT NULL default '', ! PRIMARY KEY (config_name) )", ! // -------------------------------------------------------- ! // Table structure for table `phpbb_pa_comments` ! "CREATE TABLE " . $mx_table_prefix . "linkdb_comments ( ! comments_id int(10) NOT NULL auto_increment, ! link_id int(10) NOT NULL default '0', ! comments_text text NOT NULL, ! comments_title text NOT NULL, ! comments_time int(50) NOT NULL default '0', ! comment_bbcode_uid varchar(10) default NULL, ! poster_id mediumint(8) NOT NULL default '0', ! PRIMARY KEY (comments_id), ! KEY comments_id (comments_id), ! FULLTEXT KEY comment_bbcode_uid (comment_bbcode_uid) ! )", "CREATE TABLE " . $mx_table_prefix . "linkdb_custom ( *************** *** 136,140 **** rate_point tinyint(3) unsigned NOT NULL default '0', KEY user_id (user_id) ! )" ); --- 174,240 ---- rate_point tinyint(3) unsigned NOT NULL default '0', KEY user_id (user_id) ! )", ! ! // General ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('enable_module', '0')", // settings_disable ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('module_name', 'Download Database')", // settings_dbname ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('wysiwyg_path', 'modules/mx_shared/')", ! "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')", ! ! // Link ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('width', '88')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('height', '31')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('display_links_logo', '1')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_no_logo', '0')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('split_links', '1')", ! ! // Appearance ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('sort_method', 'link_time')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('sort_order', 'DESC')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('pagination', '10')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('cat_col', '2')", ! ! // New -------------------- ! // Comments ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('use_comments', '0')", // comments_show ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('internal_comments', '1')", // NEW ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('formatting_comment_wordwrap', '1')", // formatting_comment_fixup ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('formatting_comment_image_resize', '300')", // NEW ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('formatting_comment_truncate_links', '1')", // NEW ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('max_comment_subject_chars', '50')", // NEW ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('max_comment_chars', '5000')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_wysiwyg', '0')", // allow_wysiwyg_comments & allow_wysiwyg ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_html', '1')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_bbcode', '1')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_smilies', '1')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_links', '1')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_images', '0')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('no_comment_image_message', '[No image please]')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('no_comment_link_message', '[No links please]')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allowed_comment_html_tags', 'b,i,u,a')", // NEW ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('del_topic', '1')", // NEW ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('autogenerate_comments', '1')", // NEW ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('comments_pagination', '5')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('comments_forum_id', '0')", // New ! ! // Ratings ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('use_ratings', '0')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('votes_check_userid', '1')", ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('votes_check_ip', '1')", ! ! // Instructions ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('show_pretext', '0')", // NEW ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('pt_header', 'Link Submission Instructions')", // NEW ! "INSERT INTO " . $mx_table_prefix . "linkdb_config values ('pt_body', 'Please check your references and include as much information as you can.')", // NEW ! ! ! // Notifications ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('notify', 'pm')", // pm_notify ! "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('notify_group', '0')", // NEW ! ); Index: db_upgrade.php =================================================================== RCS file: /cvsroot/mxbb/mx_linkdb/db_upgrade.php,v retrieving revision 1.12 retrieving revision 1.13 diff -C2 -d -r1.12 -r1.13 *** db_upgrade.php 1 Jul 2006 22:01:23 -0000 1.12 --- db_upgrade.php 3 Jul 2006 09:18:01 -0000 1.13 *************** *** 58,66 **** { //$sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('comments_forum_id', '0')"; ! //$sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_cat MODIFY cat_allow_ratings tinyint(2) NOT NULL default '-1' "; ! //$sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_cat ADD auth_approval_groups tinyint(2) NOT NULL default '0' "; --- 58,183 ---- { //$sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('comments_forum_id', '0')"; ! //$sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories MODIFY cat_allow_ratings tinyint(2) NOT NULL default '-1' "; ! //$sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_approval_groups tinyint(2) NOT NULL default '0' "; ! ! // ! // Category ! // ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD cat_desc text "; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD cat_allow_file tinyint(2) NOT NULL default '1' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD cat_allow_comments tinyint(2) NOT NULL default '-1' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD internal_comments tinyint(2) NOT NULL default '-1' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD autogenerate_comments tinyint(2) NOT NULL default '-1' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD comments_forum_id mediumint(8) NOT NULL DEFAULT '-1' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD cat_allow_ratings tinyint(2) NOT NULL default '-1' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD show_pretext tinyint(2) NOT NULL default '-1' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD notify tinyint(2) NOT NULL default '-1' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD notify_group mediumint(8) NOT NULL default '-1' "; + + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD cat_last_link_id mediumint(8) unsigned NOT NULL default '0' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD cat_last_link_name varchar(255) NOT NULL default '' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD cat_last_link_time INT(50) UNSIGNED NOT NULL default '0' "; + + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_view tinyint(3) NOT NULL DEFAULT '0' "; + $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' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_approval tinyint(3) NOT NULL DEFAULT '0' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_approval_edit tinyint(3) NOT NULL DEFAULT '0' "; + + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_view_groups smallint(5) NOT NULL default '0' "; + $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' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_approval_groups smallint(5) NOT NULL default '0' "; + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_approval_edit_groups smallint(5) NOT NULL default '0' "; + + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_categories ADD auth_moderator_groups smallint(5) NOT NULL default '0' "; + + // + // linkdb + // + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb ADD link_desc text "; + + // + // Config + // + $sql[] = "ALTER TABLE " . $mx_table_prefix . "linkdb_config DROP PRIMARY KEY, ADD PRIMARY KEY (config_name) "; + + $sql[] = "DELETE FROM " . $mx_table_prefix . "linkdb_config" . " WHERE config_name = 'allow_guest_submit_site'"; + $sql[] = "DELETE FROM " . $mx_table_prefix . "linkdb_config" . " WHERE config_name = 'allow_vote'"; + $sql[] = "DELETE FROM " . $mx_table_prefix . "linkdb_config" . " WHERE config_name = 'linkdb_versions'"; + $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[] = "UPDATE " . $mx_table_prefix . "linkdb_config" . " + SET config_name = 'notify', + config_value = 'pm' + WHERE config_name = 'pm_notify'"; + + $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 + + // Comments + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('use_comments', '0') "; // comments_show + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('internal_comments', '1') "; // NEW + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('formatting_comment_wordwrap', '1') "; // formatting_comment_fixup + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('formatting_comment_image_resize', '300') "; // NEW + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('formatting_comment_truncate_links', '1') "; // NEW + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('max_comment_subject_chars', '50') "; // NEW + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('max_comment_chars', '5000') "; + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_wysiwyg', '0') "; // allow_wysiwyg_comments & allow_wysiwyg + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_html', '1') "; + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_bbcode', '1') "; + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_smilies', '1') "; + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_links', '1') "; + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allow_comment_images', '0') "; + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('no_comment_image_message', '[No image please]') "; + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('no_comment_link_message', '[No links please]') "; + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('allowed_comment_html_tags', 'b,i,u,a') "; // NEW + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('del_topic', '1') "; // NEW + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('autogenerate_comments', '1') "; // NEW + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('comments_pagination', '5') "; + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('comments_forum_id', '0') "; // New + + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('show_pretext', '0') "; // NEW + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('pt_header', 'Link Submission Instructions') "; // NEW + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config values ('pt_body', 'Please check your references and include as much information as you can.') "; // NEW + + // Ratings + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('use_ratings', '0') "; + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('votes_check_userid', '1') "; + $sql[] = "INSERT INTO " . $mx_table_prefix . "linkdb_config VALUES ('votes_check_ip', '1') "; + + // + // Comments + // + // -------------------------------------------------------- + // Table structure for table `phpbb_pa_comments` + $sql[] = "CREATE TABLE " . $mx_table_prefix . "linkdb_comments ( + comments_id int(10) NOT NULL auto_increment, + link_id int(10) NOT NULL default '0', + comments_text text NOT NULL, + comments_title text NOT NULL, + comments_time int(50) NOT NULL default '0', + comment_bbcode_uid varchar(10) default NULL, + poster_id mediumint(8) NOT NULL default '0', + PRIMARY KEY (comments_id), + KEY comments_id (comments_id), + FULLTEXT KEY comment_bbcode_uid (comment_bbcode_uid) + )"; |
