Menu
▾
▴
[mxbb-commits] bugsBT.pak, NONE, 1.1 bugsbt.php, NONE, 1.1 db_install.php, NONE, 1.1 db_uninstall.php, NONE, 1.1 db_upgrade.php, NONE, 1.1 index.htm, NONE, 1.1 mx_install_readme.htm, NONE, 1.1
|
From: Jon O. <jon...@us...> - 2007-02-15 12:43:55
|
Update of /cvsroot/mxbb In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv7691 Added Files: bugsBT.pak bugsbt.php db_install.php db_uninstall.php db_upgrade.php index.htm mx_install_readme.htm Log Message: Ok. here we go. This is the cool new mxBB Bugtracker ;) --- NEW FILE: bugsbt.php --- <?php /** * * @package mxBB Portal Module - mx_bugsbt * @version $Id: bugsbt.php,v 1.1 2007/02/15 12:43:42 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 * */ if( !defined('IN_PORTAL') || !is_object($mx_block)) { die("Hacking attempt"); } // // Read Block Settings (default mode) // $title = !empty( $mx_block->block_info['block_title'] ) ? $mx_block->block_info['block_title'] : $lang['bugsbt_title']; $desc = $mx_block->block_info['block_desc']; $block_size = ( isset( $block_size ) && !empty( $block_size ) ? $block_size : '100%' ); // ------------------------------------------------------------------------------------------------------------------------- // ------------------------------------------------------------------------------------------------------------------------- // Start // ------------------------------------------------------------------------------------------------------------------------- // ------------------------------------------------------------------------------------------------------------------------- // =================================================== // Include the common file // =================================================== include_once( $module_root_path . 'bugsbt/bugsbt_common.' . $phpEx ); // =================================================== // Get mode variables, otherwise set it to the main // =================================================== $mode = $mx_request_vars->request('mode', MX_TYPE_NO_TAGS, 'index'); // =================================================== // Is admin? // =================================================== $is_admin = ( ( $userdata['user_level'] == ADMIN ) && $userdata['session_logged_in'] ) ? true : 0; // =================================================== // if the database disabled give them a nice message // =================================================== if ( intval( $bugsbt_config['module_enable'] ) ) { mx_message_die( GENERAL_MESSAGE, $lang['bugsbt_disable'] ); } // =================================================== // an array of all expected actions // =================================================== $actions = array( 'index' => 'index', ); // =================================================== // Lets Build the page // =================================================== $mx_bugsbt->module( $actions[$mode] ); $mx_bugsbt->modules[$actions[$mode]]->main( $mode ); // // load module header // //$mx_bugsbt_functions->page_header(); // // Some general template vars // $template->assign_vars( array( 'U_PORTAL' => $mx_root_path, 'L_PORTAL' => "<<", 'U_BUGSBT' => append_sid( $mx_bugsbt->this_mxurl() ), 'L_BUGSBT' => $lang['bugsbt_title'] ) ); $template->pparse( 'body' ); // // load module footer // $mx_bugsbt_functions->page_footer(); ?> --- NEW FILE: db_uninstall.php --- <?php /** * * @package mxBB Portal Module - mx_bugsbt * @version $Id: db_uninstall.php,v 1.1 2007/02/15 12:43:43 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 } // For compatibility with core 2.7.+ define( 'MXBB_27x', file_exists( $mx_root_path . 'mx_login.php' ) ); if ( MXBB_27x ) { include_once( $mx_root_path . 'modules/mx_kb/includes/functions_kb_mx.' . $phpEx ); } $sql = array( "DROP TABLE " . $mx_table_prefix . "kb_articles ", "DROP TABLE " . $mx_table_prefix . "kb_categories ", "DROP TABLE " . $mx_table_prefix . "kb_config ", "DROP TABLE " . $mx_table_prefix . "kb_types ", //"DROP TABLE " . $mx_table_prefix . "kb_wordlist ", //"DROP TABLE " . $mx_table_prefix . "kb_results ", //"DROP TABLE " . $mx_table_prefix . "kb_wordmatch ", "DROP TABLE " . $mx_table_prefix . "kb_votes ", "DROP TABLE " . $mx_table_prefix . "kb_custom ", "DROP TABLE " . $mx_table_prefix . "kb_comments ", "DROP TABLE " . $mx_table_prefix . "kb_customdata " ); 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/Uninstalling Information - module specific db tables</th></tr>"; echo "<tr><td class=\"row1\" align=\"left\"><span class=\"gen\">" . mx_do_install_upgrade( $sql ) . "</span></td></tr>"; echo "</table><br />"; ?> --- NEW FILE: mx_install_readme.htm --- <html> <head> <title>Mx Portal installation - readme</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <!-- link rel="stylesheet" href="templates/subSilver/subSilver.css" type="text/css" --> <style type="text/css"> <!-- /* The original subSilver Theme for phpBB version 2+ Created by subBlue design http://www.subBlue.com NOTE: These CSS definitions are stored within the main page body so that you can use the phpBB2 theme administration centre. When you have finalised your style you could cut the final CSS code and place it in an external file, deleting this section to save bandwidth. */ /* General page style. The scroll bar colours only visible in IE5.5+ */ body { background-color: #E5E5E5; scrollbar-face-color: #DEE3E7; scrollbar-highlight-color: #FFFFFF; scrollbar-shadow-color: #DEE3E7; scrollbar-3dlight-color: #D1D7DC; scrollbar-arrow-color: #006699; scrollbar-track-color: #EFEFEF; scrollbar-darkshadow-color: #98AAB1; } /* General font families for common tags */ font,th,td,p { font-family: Verdana, Arial, Helvetica, sans-serif } a:link,a:active,a:visited { color : #006699; } a:hover { text-decoration: underline; color : #DD6900; } hr { height: 0px; border: solid #D1D7DC 0px; border-top-width: 1px;} /* This is the border line & background colour round the entire page */ .bodyline { background-color: #FFFFFF; border: 1px #98AAB1 solid; } /* This is the outline round the main forum tables */ .forumline { background-color: #FFFFFF; border: 2px #006699 solid; } /* Main table cell colours and backgrounds */ td.row1 { background-color: #EFEFEF; } td.row2 { background-color: #DEE3E7; } td.row3 { background-color: #D1D7DC; } /* This is for the table cell above the Topics, Post & Last posts on the index.php page By default this is the fading out gradiated silver background. However, you could replace this with a bitmap specific for each forum */ td.rowpic { background-color: #FFFFFF; background-image: url(../../install/templates/subSilver/images/cellpic2.jpg); background-repeat: repeat-y; } /* Header cells - the blue and silver gradient backgrounds */ th { color: #FFA34F; font-size: 11px; font-weight : bold; background-color: #006699; height: 25px; background-image: url(../../install/templates/subSilver/images/cellpic3.gif); } td.cat,td.catHead,td.catSides,td.catLeft,td.catRight,td.catBottom { background-image: url(../../install/templates/subSilver/images/cellpic1.gif); background-color:#D1D7DC; border: #FFFFFF; border-style: solid; height: 28px; } /* Setting additional nice inner borders for the main table cells. The names indicate which sides the border will be on. Don't worry if you don't understand this, just ignore it :-) */ td.cat,td.catHead,td.catBottom { height: 29px; border-width: 0px 0px 0px 0px; } th.thHead,th.thSides,th.thTop,th.thLeft,th.thRight,th.thBottom,th.thCornerL,th.thCornerR { font-weight: bold; border: #FFFFFF; border-style: solid; height: 28px; } td.row3Right,td.spaceRow { background-color: #D1D7DC; border: #FFFFFF; border-style: solid; } th.thHead,td.catHead { font-size: 12px; border-width: 1px 1px 0px 1px; } th.thSides,td.catSides,td.spaceRow { border-width: 0px 1px 0px 1px; } th.thRight,td.catRight,td.row3Right { border-width: 0px 1px 0px 0px; } th.thLeft,td.catLeft { border-width: 0px 0px 0px 1px; } th.thBottom,td.catBottom { border-width: 0px 1px 1px 1px; } th.thTop { border-width: 1px 0px 0px 0px; } th.thCornerL { border-width: 1px 0px 0px 1px; } th.thCornerR { border-width: 1px 1px 0px 0px; } /* The largest text used in the index page title and toptic title etc. */ .maintitle { font-weight: bold; font-size: 22px; font-family: "Trebuchet MS",Verdana, Arial, Helvetica, sans-serif; text-decoration: none; line-height : 120%; color : #000000; } /* General text */ .gen { font-size : 12px; } .genmed { font-size : 11px; } .gensmall { font-size : 10px; } .gen,.genmed,.gensmall { color : #000000; } a.gen,a.genmed,a.gensmall { color: #006699; text-decoration: none; } a.gen:hover,a.genmed:hover,a.gensmall:hover { color: #DD6900; text-decoration: underline; } /* The register, login, search etc links at the top of the page */ .mainmenu { font-size : 11px; color : #000000 } a.mainmenu { text-decoration: none; color : #006699; } a.mainmenu:hover{ text-decoration: underline; color : #DD6900; } /* Forum category titles */ .cattitle { font-weight: bold; font-size: 12px ; letter-spacing: 1px; color : #006699} a.cattitle { text-decoration: none; color : #006699; } a.cattitle:hover{ text-decoration: underline; } /* Forum title: Text and link to the forums used in: index.php */ .forumlink { font-weight: bold; font-size: 12px; color : #006699; } a.forumlink { text-decoration: none; color : #006699; } a.forumlink:hover{ text-decoration: underline; color : #DD6900; } /* Used for the navigation text, (Page 1,2,3 etc) and the navigation bar when in a forum */ .nav { font-weight: bold; font-size: 11px; color : #000000;} a.nav { text-decoration: none; color : #006699; } a.nav:hover { text-decoration: underline; } /* titles for the topics: could specify viewed link colour too */ .topictitle,h1,h2 { font-weight: bold; font-size: 11px; color : #000000; } a.topictitle:link { text-decoration: none; color : #006699; } a.topictitle:visited { text-decoration: none; color : #5493B4; } a.topictitle:hover { text-decoration: underline; color : #DD6900; } /* Name of poster in viewmsg.php and viewtopic.php and other places */ .name { font-size : 11px; color : #000000;} /* Location, number of posts, post date etc */ .postdetails { font-size : 10px; color : #000000; } /* The content of the posts (body of text) */ .postbody { font-size : 12px; line-height: 18px} a.postlink:link { text-decoration: none; color : #006699 } a.postlink:visited { text-decoration: none; color : #5493B4; } a.postlink:hover { text-decoration: underline; color : #DD6900} /* Quote & Code blocks */ .code { font-family: Courier, 'Courier New', sans-serif; font-size: 11px; color: #006600; background-color: #FAFAFA; border: #D1D7DC; border-style: solid; border-left-width: 1px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px } .quote { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #444444; line-height: 125%; background-color: #FAFAFA; border: #D1D7DC; border-style: solid; border-left-width: 1px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px } /* Copyright and bottom info */ .copyright { font-size: 10px; font-family: Verdana, Arial, Helvetica, sans-serif; color: #444444; letter-spacing: -1px;} a.copyright { color: #444444; text-decoration: none;} a.copyright:hover { color: #000000; text-decoration: underline;} /* Form elements */ input,textarea, select { color : #000000; font: normal 11px Verdana, Arial, Helvetica, sans-serif; border-color : #000000; } /* The text input fields background colour */ input.post, textarea.post, select { background-color : #FFFFFF; } input { text-indent : 2px; } /* The buttons used for bbCode styling in message post */ input.button { background-color : #EFEFEF; color : #000000; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; } /* The main submit button option */ input.mainoption { background-color : #FAFAFA; font-weight : bold; } /* None-bold submit button */ input.liteoption { background-color : #FAFAFA; font-weight : normal; } /* This is the line in the posting page which shows the rollover help line. This is actually a text box, but if set to be the same colour as the background no one will know ;) */ .helpline { background-color: #DEE3E7; border-style: none; } /* Import the fancy styles for IE only (NS4.x doesn't use the @import function) */ @import url("templates/subSilver/formIE.css"); --> </style> <script language="Javascript" type="text/javascript"> <!-- if ( 0 ) { window.open('privmsg.php?mode=newpm', '_phpbbprivmsg', 'HEIGHT=225,resizable=yes,WIDTH=400');; } //--> </script> </head> <body bgcolor="#FFFFFF" text="#000000"> <table> <tr> <td colspan="2"><p><b><font size="5">mxBB</font><font size="5"> Module - Knowledge Base <br> <font size="2">v. 2.0.2</font></font></b></p> <p><span style="font-weight: bold"><span style="font-size: 16px; line-height: normal">Module</span></span> <br /> - for Mx Portal v. 2.7.5+ (with some notes, see below)</p> <p><strong>Author</strong><br /> Haplo<br /> <br /> <span style="font-weight: bold">Description</span> <br /> The mxBB Module is an addon product for the mxBB Portal.</p> <p><strong>Features</strong> <br /> Easy to use and install/uninstall module.</p> <p> <br /> I. <a href="#install">Installation instructions</a> <br /> <br /> II. <a href="#themes">Additional styles</a> <br /> <br /> III. <a href="#languages">Additional languages</a><br /> <br /> <a href="http://www.mx-system.com" target="_blank" class="postlink">DEMO </a> <br /> <br /> <a href="http://www.mx-system.com/index.php?page=4" target="_blank" class="postlink"> DOWNLOAD </a> <br /> <br /><a name="install"> <br /> <span style="font-weight: bold">I. Installation Instructions</span> <br /> To install this module, follow these instructions. If you encounter any problems during install, visit the <a href="http://www.mx-system.com/forum/viewforum.php?f=20" target="_blank" class="postlink"> module support forum</a>. </p> <p>All install notes are maintained at www.mx-system.com, <a href="http://www.mx-system.com/forum/viewforum.php?f=11">here</a>.<br> <br> <i>To summarize:</i></p> <ul> <li> If installing from scratch, use the "install module" option in the AdminCP - Modules</li> <li> If upgrading, use the "upgrade module" option in the AdminCP - Modules</li> <li> If uninstalling, use the "delete module" feature in the AdminCP - Modules</li> </ul> <p><i>Note:</i> If upgrading, do NOT delete module prior to upgrading, or else you'll lose all module data!</p> <p><i>Note also:</i> Since this module is developed for next generation mxBB core, you have to patch your core 2.7.5 portal if downloaded prior to this module release. If using latest core this patch is already included.</p> <p>OPEN admin/admin_mx_module.php</p> <p>FIND</p> <table width="100%" border="1" cellpadding="2"> <tr> <td><font size="1">// <br> // Generate safe object identifiers for the target DB<br> // where this module pack is going to be imported...<br> // </font></td> </tr> </table> <p>BEFORE ADD</p> <table width="100%" border="1" cellpadding="2"> <tr> <td><font size="1">// Start - For compatibility with mxBB modules 2.x<br> $fcontents_temp = array();<br> for($i = 0; $i < count($fcontents); $i++) {<br> $module_data = explode($delimeter, trim($fcontents[$i]));<br> <br> if ( $module_data[0] != 'New_function' && $module_data[4] != 'endoflist' )<br> {<br> $fcontents_temp[] = implode($delimeter, $module_data);<br> }<br> }<br> $fcontents = $fcontents_temp;<br> // End - mxBB modules 2.x code patch</font></td> </tr> </table> <p><br /> <a href="#top"> Back to Top</a> <br /> <br /> <a name="themes"> <br /> <span style="font-weight: bold">II. Additional Styles</span> <br /> This module is compatible with any theme/style. <br /> <br /> <a href="#top"> Back to Top</a> <br /> <br /> <a name="languages"> <br /> <span style="font-weight: bold">III. Additional Languages</span> <br /> First check to see if your language is already translated. <br /> <br /> Translated languages are downloaded <a href="http://www.mx-system.com/index.php?page=4&action=category&cat_id=5" target="_blank" class="postlink"> here</a>. <br /> <br /> If exists, download and install in the modules/mx_modulename/language folder. If not, duplicate (copy and paste) any included language file, rename to match your language, translate using any texteditor, save and upload. <br /> <br /> <a href="#top"> Back to Top</a> </p> <p> /mxBB Team</p> </td> </tr> </table> </body> </html> --- NEW FILE: db_upgrade.php --- <?php /** * * @package mxBB Portal Module - mx_bugsbt * @version $Id: db_upgrade.php,v 1.1 2007/02/15 12:43:43 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-portal.com" target="_blank">Jon</a>'; $sql = array(); // Precheck if ( $result = $db->sql_query( "SELECT config_name from " . $mx_table_prefix . "bugsbt_config" ) ) { if(false) { } else { $message .= "<b>Nothing to upgrade...</b><br/><br/>"; } $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 ); // // Empty module cache // include_once( $mx_root_path . 'includes/mx_functions_tools.' . $phpEx ); $module_cache = new module_cache($mx_root_path . 'modules/mx_bugsbt/bugsbt/'); $module_cache->tidy(); $module_cache->save(); } else { // If not installed $message = "<b>Module is not installed...and thus cannot be upgraded ;)</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/Uninstalling Information - module specific db tables</th></tr>"; echo "<tr><td class=\"row1\" align=\"left\"><span class=\"gen\">" . $message . "</span></td></tr>"; echo "</table><br />"; ?> --- NEW FILE: db_install.php --- <?php /** * * @package mxBB Portal Module - mx_bugsbt * @version $Id: db_install.php,v 1.1 2007/02/15 12:43:43 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 varchar(255) binary NOT NULL default '', 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', '1')", // 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 />"; ?> --- NEW FILE: bugsBT.pak --- module=+:41=+:BugsBT=+:modules/mx_bugsbt/=+:mxBB BugTracker module=+:1 New_function=+:---------------------------=+:0=+:0=+:0=+:0=+:0 function=+:41=+:42=+:BugsBT - Main=+:mxBB BugTracker module=+:bugsbt.php=+: parameter=+:0=+:0=+:0=+:endoflist=+:0=+:0 block=+:=+:Demo - BugsBT=+:Demo block=+:42=+:0=+:5=+:0=+:0=+:0=+:0=+:1=+:1 function=+:0=+:0=+:0=+:endoflist=+:0=+:0 --- NEW FILE: index.htm --- <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body bgcolor="#FFFFFF" text="#000000"> </body> </html> |
