|
From: Jon O. <jon...@us...> - 2007-04-28 20:04:15
|
Update of /cvsroot/mxbb/mx_bugsbt In directory sc8-pr-cvs16:/tmp/cvs-serv28107 Added Files: db_install.php Log Message: lost file --- NEW FILE: db_install.php --- <?php /** * * @package mxBB Portal Module - mx_bugsbt * @version $Id: db_install.php,v 1.1 2007/04/28 20:04:09 jonohlsson Exp $ * @copyright (c) 2002-2006 [Jon Ohlsson, Cezary Tomczak] mxBB Project Team * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2 * */ define( 'IN_PORTAL', true ); if ( !defined( 'IN_ADMIN' ) ) { $mx_root_path = './../../'; $phpEx = substr(strrchr(__FILE__, '.'), 1); include( $mx_root_path . 'common.' . $phpEx ); // Start session management $mx_user->init($user_ip, PAGE_INDEX); if ( !$userdata['session_logged_in'] ) { die( "Hacking attempt(1)" ); } if ( $userdata['user_level'] != ADMIN ) { die( "Hacking attempt(2)" ); } // End session management } $mx_module_version = '1.0.0'; $mx_module_copy = 'Designed for mxBB by <a href="http://www.mxbb.net" target="_blank">Jon</a>'; // If fresh install if ( !$result = $db->sql_query( "SELECT config_name from " . $mx_table_prefix . "bugsbt_config" ) ) { $message = "<b>This is a new module installation!</b><br/><br/>"; $sql = array( "DROP TABLE IF EXISTS " . $mx_table_prefix . "bugsbt_bugs ", "DROP TABLE IF EXISTS " . $mx_table_prefix . "bugsbt_products ", "DROP TABLE IF EXISTS " . $mx_table_prefix . "bugsbt_config ", "DROP TABLE IF EXISTS " . $mx_table_prefix . "bugsbt_types ", "CREATE TABLE " . $mx_table_prefix . "bugsbt_products ( category_id int(10) NOT NULL auto_increment, category_name text, category_details text, parent int(50) default NULL, parents_data text NOT NULL default '', 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', show_pretext tinyint(2) NOT NULL default '-1', notify tinyint(2) NOT NULL default '-1', notify_group mediumint(8) NOT NULL default '-1', number_bugs mediumint(8) NOT NULL default '-1', cat_last_bug_id mediumint(8) unsigned NOT NULL default '0', cat_last_bug_name varchar(255) NOT NULL default '', cat_last_bug_time INT(50) UNSIGNED DEFAULT '0' NOT NULL, auth_view tinyint(3) NOT NULL DEFAULT '0', auth_post 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', auth_approval tinyint(3) NOT NULL DEFAULT '0', auth_approval_edit tinyint(3) NOT NULL DEFAULT '0', auth_view_groups varchar(255) NOT NULL default '0', auth_post_groups varchar(255) NOT NULL default '0', auth_view_comment_groups varchar(255) NOT NULL default '0', auth_post_comment_groups varchar(255) NOT NULL default '0', auth_edit_comment_groups varchar(255) NOT NULL default '0', auth_delete_comment_groups varchar(255) NOT NULL default '0', auth_edit_groups varchar(255) NOT NULL default '0', auth_delete_groups varchar(255) NOT NULL default '0', auth_approval_groups varchar(255) NOT NULL default '0', /* not really used */ auth_approval_edit_groups varchar(255) NOT NULL default '0', /* not really used */ auth_moderator_groups varchar(255) NOT NULL default '0', PRIMARY KEY (category_id), KEY cat_order (cat_order) )", "INSERT INTO " . $mx_table_prefix . "bugsbt_products VALUES (1, 'Test Product', 'Just a test product', '0', '10', '-1', '-1','-1','-1','-1','-1','-1', '-1', '0', '', '0', '0', '0', '0', '0', '0', '2', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0' )", "CREATE TABLE " . $mx_table_prefix . "bugsbt_bugs ( bug_id mediumint(8) unsigned NOT NULL auto_increment, bug_title varchar(255) binary NOT NULL default '', bug_description varchar(255) binary NOT NULL default '', bug_category_id mediumint(8) unsigned NOT NULL default '0', approved tinyint(1) unsigned NOT NULL default '0', bug_body text NOT NULL, bbcode_uid varchar(10) binary NOT NULL default '', bug_type mediumint(8) unsigned NOT NULL default '0', bug_status mediumint(8) unsigned NOT NULL default '0', bug_closed tinyint(1) unsigned NOT NULL default '0', bug_date int(50) NOT NULL default NULL, bug_update_date int(50) NOT NULL default NULL, bug_author_id mediumint(8) NOT NULL, username VARCHAR(255), topic_id mediumint(8) unsigned NOT NULL default '0', attached_topic_id mediumint(8) unsigned NOT NULL default '0', views BIGINT(8) NOT NULL DEFAULT '0', PRIMARY KEY (bug_id) )", "CREATE TABLE " . $mx_table_prefix . "bugsbt_config ( config_name VARCHAR(255) NOT NULL default '', config_value varchar(255) NOT NULL default '', PRIMARY KEY (config_name) )", // -------------------------------------------------------- "CREATE TABLE " . $mx_table_prefix . "bugsbt_comments ( comments_id int(10) NOT NULL auto_increment, bug_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 . "bugsbt_types ( id mediumint(8) unsigned NOT NULL auto_increment, type varchar(255) binary DEFAULT '' NOT NULL, KEY id (id) )", "INSERT INTO " . $mx_table_prefix . "bugsbt_types VALUES (1, 'Confirmed')", "INSERT INTO " . $mx_table_prefix . "bugsbt_types VALUES (2, 'Unconfirmed')", "INSERT INTO " . $mx_table_prefix . "bugsbt_types VALUES (3, 'Partially Fixed')", "INSERT INTO " . $mx_table_prefix . "bugsbt_types VALUES (4, 'Feature')", "INSERT INTO " . $mx_table_prefix . "bugsbt_types VALUES (5, 'Not a Bug')", "INSERT INTO " . $mx_table_prefix . "bugsbt_types VALUES (6, 'Fixed')", "INSERT INTO " . $mx_table_prefix . "bugsbt_types VALUES (7, 'Internal To-Do')", "INSERT INTO " . $mx_table_prefix . "bugsbt_types VALUES (8, 'Postponed')", // -------------------------------------------------------- "CREATE TABLE " . $mx_table_prefix . "bugsbt_custom ( custom_id int(50) NOT NULL auto_increment, custom_name text NOT NULL, custom_description text NOT NULL, data text NOT NULL, field_order int(20) NOT NULL default '0', field_type tinyint(2) NOT NULL default '0', regex varchar(255) NOT NULL default '', PRIMARY KEY (custom_id) )", // -------------------------------------------------------- "CREATE TABLE " . $mx_table_prefix . "bugsbt_customdata ( customdata_file int(50) NOT NULL default '0', customdata_custom int(50) NOT NULL default '0', data text NOT NULL )", // // Insert Configs // // General "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('enable_module', '1')", // allow_new "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('module_name', 'BugsBT')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('wysiwyg_path', 'modules/mx_shared/')", // Articles "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('formatting_wordwrap', '1')", // formatting_fixup "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('formatting_image_resize', '300')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('formatting_truncate_links', '1')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_wysiwyg', '0')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_html', '1')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_bbcode', '1')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_smilies', '1')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allowed_html_tags', 'b,i,u,a')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_links', '1')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_images', '0')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('no_image_message', '[No image please]')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('no_link_message', '[No links please]')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('max_subject_chars', '100')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('max_desc_chars', '500')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('max_chars', '0')", // NEW // Appearance "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('sort_method', 'Alphabetic')", // news_sort "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('sort_order', 'ASC')", // news_sort_par "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('pagination', '10')", // art_pagination "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('stats_list', '1')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('header_banner', '0')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('use_simple_navigation', '1')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('cat_col', '2')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('settings_newdays', '5')", // Comments "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('use_comments', '0')", // comments_show "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('internal_comments', '1')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('formatting_comment_wordwrap', '1')", // formatting_comment_fixup "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('formatting_comment_image_resize', '300')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('formatting_comment_truncate_links', '1')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('max_comment_subject_chars', '50')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('max_comment_chars', '5000')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_comment_wysiwyg', '0')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_comment_html', '1')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_comment_bbcode', '1')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_comment_smilies', '1')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_comment_links', '1')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allow_comment_images', '0')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('no_comment_image_message', '[No image please]')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('no_comment_link_message', '[No links please]')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('allowed_comment_html_tags', 'b,i,u,a')", // NEW "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('del_topic', '1')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('autogenerate_comments', '1')", // bump_post "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('comments_pagination', '5')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('comments_forum_id', '0')", // New // Instructions "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('show_pretext',0)", "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('pt_header','Article Submission Instructions')", "INSERT INTO " . $mx_table_prefix . "bugsbt_config values ('pt_body','Please check your references and include as much information as you can.')", // Notifications "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('notify', 'pm')", // updated "INSERT INTO " . $mx_table_prefix . "bugsbt_config VALUES ('notify_group', '0')", // admin_id ); $sql[] = "UPDATE " . $mx_table_prefix . "module" . " SET module_version = '" . $mx_module_version . "', module_copy = '" . $mx_module_copy . "' WHERE module_id = '" . $mx_module_id . "'"; $message .= mx_do_install_upgrade( $sql ); } else { // If already installed $message = "<b>Module is already installed...consider upgrading ;)</b><br/><br/>"; } echo "<br /><br />"; echo "<table width=\"90%\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" border=\"0\" class=\"forumline\">"; echo "<tr><th class=\"thHead\" align=\"center\">Module Installation/Upgrading/Uninstallation Information - module specific DB tables</th></tr>"; echo "<tr><td class=\"row1\" align=\"left\"><span class=\"gen\">" . $message . "</span></td></tr>"; echo "</table><br />"; ?> |