[COMMENT] /* +-------------------------------------------------------------------------- | Invision Board v1.3 | ======================================== | > Mod_Installer | > Module written by Peter(Pit) | > Peter member at ibforen.de, Pit member at invisionize.com | > email: Peter@ibforen.de | | > Mod_Installer Version Number: 1.2f (2006-01-29) | > 2006 by Peter | | > This is the CodeChange.php for Mod mySQL5 by Peter +-------------------------------------------------------------------------- */ [COMMENT_END] [INTERFACE] 'title' => 'IPB13 For mySQL5', 'sub_title' => 'Makes Invisionboard 1.3 compatible with nyMSQL5', 'category' => 'Major Mod', 'compatible' => 'Invision Power Board 1.3', 'version' => '1.0.2', 'author' => 'Peter', 'email' => 'Peter@ibforen.de', 'mod_token' => 'mod_mysql5', [INTERFACE_END] [HISTORY] [b]Version 1.0.2[/b] [List][*]Makes DynamicLite compatible with mySQL5 [*]Improved modification of the mySQL driver. Changes in sources/dynamiclite/csite.php and sources/Drivers/mySQL.php [/List] [HISTORY_END] [SQL] [QUERY] ALTER TABLE ibf_cache_store CHANGE cs_value cs_value text [QUERY] ALTER TABLE ibf_cache_store CHANGE cs_extra cs_extra varchar(255) default '' [QUERY] ALTER TABLE ibf_calendar_events CHANGE year year int(4) default '2002' [QUERY] ALTER TABLE ibf_calendar_events CHANGE month month int(2) default '1' [QUERY] ALTER TABLE ibf_calendar_events CHANGE mday mday int(2) default '1' [QUERY] ALTER TABLE ibf_calendar_events CHANGE title title varchar(254) default 'no title' [QUERY] ALTER TABLE ibf_calendar_events CHANGE event_text event_text text [QUERY] ALTER TABLE ibf_calendar_events CHANGE read_perms read_perms varchar(254) default '*' [QUERY] ALTER TABLE ibf_calendar_events CHANGE priv_event priv_event tinyint(1) default '0' [QUERY] ALTER TABLE ibf_calendar_events CHANGE show_emoticons show_emoticons tinyint(1) default '1' [QUERY] ALTER TABLE ibf_calendar_events CHANGE rating rating smallint(2) default '1' [QUERY] ALTER TABLE ibf_calendar_events CHANGE event_ranged event_ranged tinyint(1) default '0' [QUERY] ALTER TABLE ibf_calendar_events CHANGE event_repeat event_repeat tinyint(1) default '0' [QUERY] ALTER TABLE ibf_calendar_events CHANGE repeat_unit repeat_unit char(2) default '' [QUERY] ALTER TABLE ibf_calendar_events CHANGE event_bgcolor event_bgcolor varchar(32) default '' [QUERY] ALTER TABLE ibf_calendar_events CHANGE event_color event_color varchar(32) default '' [QUERY] ALTER TABLE ibf_contacts CHANGE contact_id contact_id mediumint(8) default '0' [QUERY] ALTER TABLE ibf_contacts CHANGE member_id member_id mediumint(8) default '0' [QUERY] ALTER TABLE ibf_contacts CHANGE contact_name contact_name varchar(32) default '' [QUERY] ALTER TABLE ibf_css CHANGE css_name css_name varchar(128) default '' [QUERY] ALTER TABLE ibf_email_logs CHANGE email_content email_content text [QUERY] ALTER TABLE ibf_email_logs CHANGE from_email_address from_email_address varchar(250) default '' [QUERY] ALTER TABLE ibf_email_logs CHANGE from_ip_address from_ip_address varchar(16) default '127.0.0.1' [QUERY] ALTER TABLE ibf_email_logs CHANGE topic_id topic_id int(10) default '0' [QUERY] ALTER TABLE ibf_emoticons CHANGE typed typed varchar(32) default '' [QUERY] ALTER TABLE ibf_emoticons CHANGE image image varchar(128) default '' [QUERY] ALTER TABLE ibf_emoticons CHANGE clickable clickable smallint(2) default '1' [QUERY] ALTER TABLE ibf_forum_perms CHANGE perm_name perm_name varchar(250) default '' [QUERY] ALTER TABLE ibf_forum_tracker CHANGE last_sent last_sent int(10) default '0' [QUERY] ALTER TABLE ibf_forums CHANGE last_poster_id last_poster_id mediumint(8) default '0' [QUERY] ALTER TABLE ibf_forums CHANGE name name varchar(128) default '' [QUERY] ALTER TABLE ibf_forums CHANGE start_perms start_perms varchar(255) default '' [QUERY] ALTER TABLE ibf_forums CHANGE reply_perms reply_perms varchar(255) default '' [QUERY] ALTER TABLE ibf_forums CHANGE read_perms read_perms varchar(255) default '' [QUERY] ALTER TABLE ibf_forums CHANGE allow_poll allow_poll tinyint(1) default '1' [QUERY] ALTER TABLE ibf_forums CHANGE allow_pollbump allow_pollbump tinyint(1) default '0' [QUERY] ALTER TABLE ibf_forums CHANGE inc_postcount inc_postcount tinyint(1) default '1' [QUERY] ALTER TABLE ibf_forums CHANGE redirect_on redirect_on tinyint(1) default '0' [QUERY] ALTER TABLE ibf_forums CHANGE redirect_hits redirect_hits int(10) default '0' [QUERY] ALTER TABLE ibf_forums CHANGE rules_title rules_title varchar(255) default '' [QUERY] ALTER TABLE ibf_forums CHANGE rules_text rules_text text [QUERY] ALTER TABLE ibf_forums CHANGE has_mod_posts has_mod_posts tinyint(1) default '0' [QUERY] ALTER TABLE ibf_forums CHANGE topic_mm_id topic_mm_id varchar(250) default '' [QUERY] ALTER TABLE ibf_groups CHANGE g_perm_id g_perm_id varchar(255) default '' [QUERY] ALTER TABLE ibf_groups CHANGE g_dohtml g_dohtml tinyint(1) default '0' [QUERY] ALTER TABLE ibf_groups CHANGE g_edit_topic g_edit_topic tinyint(1) default '0' [QUERY] ALTER TABLE ibf_groups CHANGE g_email_limit g_email_limit varchar(15) default '10:15' [QUERY] ALTER TABLE ibf_languages CHANGE ldir ldir varchar(64) default '' [QUERY] ALTER TABLE ibf_languages CHANGE lname lname varchar(250) default '' [QUERY] ALTER TABLE ibf_macro CHANGE macro_set macro_set smallint(3) NOT NULL default '0' [QUERY] ALTER TABLE ibf_members CHANGE password password varchar(32) default '' [QUERY] ALTER TABLE ibf_members CHANGE email email varchar(60) default '' [QUERY] ALTER TABLE ibf_members CHANGE joined joined int(10) default '0' [QUERY] ALTER TABLE ibf_members CHANGE ip_address ip_address varchar(16) default '' [QUERY] ALTER TABLE ibf_members CHANGE warn_lastwarn warn_lastwarn int(10) default '0' [QUERY] ALTER TABLE ibf_members CHANGE restrict_post restrict_post varchar(100) default '0' [QUERY] ALTER TABLE ibf_members CHANGE sub_end sub_end int(10) default '0' [QUERY] ALTER TABLE ibf_moderator_logs CHANGE ip_address ip_address varchar(16) default '0' [QUERY] ALTER TABLE ibf_moderator_logs CHANGE topic_id topic_id int(10) default '0' [QUERY] ALTER TABLE ibf_moderators CHANGE edit_user edit_user tinyint(1) default '0' [QUERY] ALTER TABLE ibf_moderators CHANGE can_mm can_mm tinyint(1) default '0' [QUERY] ALTER TABLE ibf_pfields_data CHANGE ftitle ftitle varchar(200) default '' [QUERY] ALTER TABLE ibf_polls CHANGE votes votes smallint(5) default '0' [QUERY] ALTER TABLE ibf_polls CHANGE forum_id forum_id smallint(5) default '0' [QUERY] ALTER TABLE ibf_posts CHANGE use_sig use_sig tinyint(1) default '0' [QUERY] ALTER TABLE ibf_posts CHANGE use_emo use_emo tinyint(1) default '0' [QUERY] ALTER TABLE ibf_posts CHANGE ip_address ip_address varchar(16) default '' [QUERY] ALTER TABLE ibf_reg_antispam CHANGE regcode regcode varchar(8) default '' [QUERY] ALTER TABLE ibf_search_results CHANGE topic_id topic_id text [QUERY] ALTER TABLE ibf_search_results CHANGE search_date search_date int(12) default '0' [QUERY] ALTER TABLE ibf_search_results CHANGE topic_max topic_max int(3) default '0' [QUERY] ALTER TABLE ibf_search_results CHANGE sort_key sort_key varchar(32) default 'last_post' [QUERY] ALTER TABLE ibf_search_results CHANGE sort_order sort_order varchar(4) default 'desc' [QUERY] ALTER TABLE ibf_search_results CHANGE post_max post_max int(10) default '0' [QUERY] ALTER TABLE ibf_sessions CHANGE in_forum in_forum smallint(5) default '0' [QUERY] ALTER TABLE ibf_skins CHANGE hidden hidden tinyint(1) default '0' [QUERY] ALTER TABLE ibf_skins CHANGE default_set default_set tinyint(1) default '0' [QUERY] ALTER TABLE ibf_spider_logs CHANGE bot bot varchar(255) default '' [QUERY] ALTER TABLE ibf_spider_logs CHANGE entry_date entry_date int(10) default '0' [QUERY] ALTER TABLE ibf_spider_logs CHANGE ip_address ip_address varchar(16) default '' [QUERY] ALTER TABLE ibf_spider_logs CHANGE query_string query_string text [QUERY] ALTER TABLE ibf_stats CHANGE TOTAL_REPLIES TOTAL_REPLIES int(10) default '0' [QUERY] ALTER TABLE ibf_stats CHANGE TOTAL_TOPICS TOTAL_TOPICS int(10) default '0' [QUERY] ALTER TABLE ibf_stats CHANGE LAST_MEM_ID LAST_MEM_ID mediumint(8) default '0' [QUERY] ALTER TABLE ibf_stats CHANGE MEM_COUNT MEM_COUNT mediumint(8) default '0' [QUERY] ALTER TABLE ibf_subscriptions CHANGE sub_title sub_title varchar(250) default '' [QUERY] ALTER TABLE ibf_subscriptions CHANGE sub_new_group sub_new_group mediumint(8) default 0 [QUERY] ALTER TABLE ibf_subscriptions CHANGE sub_length sub_length smallint(5) default '1' [QUERY] ALTER TABLE ibf_subscriptions CHANGE sub_unit sub_unit varchar(2) default 'm' [QUERY] ALTER TABLE ibf_subscriptions CHANGE sub_cost sub_cost decimal(10,2) default '0.00' [QUERY] ALTER TABLE ibf_subscriptions CHANGE sub_run_module sub_run_module varchar(250) default '' [QUERY] ALTER TABLE ibf_subscription_extra CHANGE subextra_sub_id subextra_sub_id smallint(5) default '0' [QUERY] ALTER TABLE ibf_subscription_extra CHANGE subextra_method_id subextra_method_id smallint(5) default '0' [QUERY] ALTER TABLE ibf_subscription_extra CHANGE subextra_product_id subextra_product_id varchar(250) default '0' [QUERY] ALTER TABLE ibf_subscription_extra CHANGE subextra_can_upgrade subextra_can_upgrade tinyint(1) default '0' [QUERY] ALTER TABLE ibf_subscription_extra CHANGE subextra_recurring subextra_recurring tinyint(1) default '0' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_sub_id subtrans_sub_id smallint(5) default '0' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_member_id subtrans_member_id mediumint(8) default '0' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_old_group subtrans_old_group smallint(5) default '0' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_paid subtrans_paid decimal(10,2) default '0.00' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_cumulative subtrans_cumulative decimal(10,2) default '0.00' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_method subtrans_method varchar(20) default '' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_start_date subtrans_start_date int(11) default '0' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_end_date subtrans_end_date int(11) default '0' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_state subtrans_state varchar(200) default '' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_trxid subtrans_trxid varchar(200) default '' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_subscrid subtrans_subscrid varchar(200) default '' [QUERY] ALTER TABLE ibf_subscription_trans CHANGE subtrans_currency subtrans_currency varchar(10) default 'USD' [QUERY] ALTER TABLE ibf_subscription_logs CHANGE sublog_date sublog_date int(10) default '0' [QUERY] ALTER TABLE ibf_subscription_logs CHANGE sublog_member_id sublog_member_id mediumint(8) default '0' [QUERY] ALTER TABLE ibf_subscription_logs CHANGE sublog_transid sublog_transid int(10) default '0' [QUERY] ALTER TABLE ibf_subscription_logs CHANGE sublog_ipaddress sublog_ipaddress varchar(16) default '' [QUERY] ALTER TABLE ibf_subscription_methods CHANGE submethod_title submethod_title varchar(250) default '' [QUERY] ALTER TABLE ibf_subscription_methods CHANGE submethod_name submethod_name varchar(20) default '' [QUERY] ALTER TABLE ibf_subscription_methods CHANGE submethod_email submethod_email varchar(250) default '' [QUERY] ALTER TABLE ibf_subscription_methods CHANGE submethod_is_cc submethod_is_cc tinyint(1) default '0' [QUERY] ALTER TABLE ibf_subscription_methods CHANGE submethod_is_auto submethod_is_auto tinyint(1) default '0' [QUERY] ALTER TABLE ibf_subscription_methods CHANGE submethod_active submethod_active tinyint(1) default '0' [QUERY] ALTER TABLE ibf_subscription_methods CHANGE submethod_use_currency submethod_use_currency varchar(10) default 'USD' [QUERY] ALTER TABLE ibf_subscription_currency CHANGE subcurrency_desc subcurrency_desc varchar(250) default '' [QUERY] ALTER TABLE ibf_subscription_currency CHANGE subcurrency_exchange subcurrency_exchange decimal(10, 8) default'0' [QUERY] ALTER TABLE ibf_subscription_currency CHANGE subcurrency_default subcurrency_default tinyint(1) default '0' [QUERY] ALTER TABLE ibf_tmpl_names CHANGE skname skname varchar(60) default 'Invision Board' [QUERY] ALTER TABLE ibf_topic_mmod CHANGE mm_title mm_title varchar(250) default '' [QUERY] ALTER TABLE ibf_topic_mmod CHANGE mm_enabled mm_enabled tinyint(1) default '0' [QUERY] ALTER TABLE ibf_topic_mmod CHANGE topic_state topic_state varchar(10) default 'leave' [QUERY] ALTER TABLE ibf_topic_mmod CHANGE topic_pin topic_pin varchar(10) default 'leave' [QUERY] ALTER TABLE ibf_topic_mmod CHANGE topic_move topic_move smallint(5) default '0' [QUERY] ALTER TABLE ibf_topic_mmod CHANGE topic_move_link topic_move_link tinyint(1) default '0' [QUERY] ALTER TABLE ibf_topic_mmod CHANGE topic_title_st topic_title_st varchar(250) default '' [QUERY] ALTER TABLE ibf_topic_mmod CHANGE topic_title_end topic_title_end varchar(250) default '' [QUERY] ALTER TABLE ibf_topic_mmod CHANGE topic_reply topic_reply tinyint(1) default '0' [QUERY] ALTER TABLE ibf_topic_mmod CHANGE topic_reply_content topic_reply_content text [QUERY] ALTER TABLE ibf_topic_mmod CHANGE topic_reply_postcount topic_reply_postcount tinyint(1) default '0' [QUERY] ALTER TABLE ibf_topics CHANGE last_poster_id last_poster_id mediumint(8) default '0' [QUERY] ALTER TABLE ibf_topics CHANGE total_votes total_votes int(5) default '0' [QUERY] ALTER TABLE ibf_tracker CHANGE last_sent last_sent int(10) default '0' [QUERY] ALTER TABLE ibf_validating CHANGE real_group real_group smallint(3) default '0' [QUERY] ALTER TABLE ibf_validating CHANGE temp_group temp_group smallint(3) default '0' [QUERY] ALTER TABLE ibf_validating CHANGE entry_date entry_date int(10) default '0' [QUERY] ALTER TABLE ibf_validating CHANGE coppa_user coppa_user tinyint(1) default '0' [QUERY] ALTER TABLE ibf_validating CHANGE lost_pass lost_pass tinyint(1) default '0' [QUERY] ALTER TABLE ibf_validating CHANGE email_chg email_chg tinyint(1) default '0' [QUERY] ALTER TABLE ibf_validating CHANGE ip_address ip_address varchar(16) default '0' [QUERY] ALTER TABLE ibf_voters CHANGE ip_address ip_address varchar(16) default '' [QUERY] ALTER TABLE ibf_voters CHANGE vote_date vote_date int(10) default '0' [QUERY] ALTER TABLE ibf_warn_logs CHANGE wlog_mid wlog_mid mediumint(8) default '0' [QUERY] ALTER TABLE ibf_warn_logs CHANGE wlog_notes wlog_notes text [QUERY] ALTER TABLE ibf_warn_logs CHANGE wlog_contact wlog_contact varchar(250) default 'none' [QUERY] ALTER TABLE ibf_warn_logs CHANGE wlog_contact_content wlog_contact_content text [QUERY] ALTER TABLE ibf_warn_logs CHANGE wlog_type wlog_type varchar(6) default 'pos' [QUERY] ALTER TABLE ibf_warn_logs CHANGE wlog_addedby wlog_addedby mediumint(8) default '0' [SQL_END] [CODE] [MOD_TOKEN] mod_mysql5 [FNAME] sources/Boards.php [STEP] [SEARCH] $DB->query("SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc, [INSERT] //-- mod_mysql5 begin if (TRUE) $DB->query("SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc, c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid FROM ibf_categories c,ibf_forums f LEFT JOIN ibf_moderators m ON (f.id=m.forum_id) WHERE c.id=f.category ORDER BY c.position, f.position"); else //-- mod_mysql5 end [MODE] insert_above [FNAME_END] [MOD_TOKEN] mod_mysql5 [FNAME] sources/dynamiclite/csite.php [STEP] [SEARCH] if ( $ibforums->vars['vb_configured'] ) { [INSERT] //-- mod_mysql5 begin if (TRUE) if ( $ibforums->vars['vb_configured'] ) $DB->query("SELECT t.*, f.read_perms, f.use_html, p.*, m.avatar, m.view_avs, m.avatar_size, m.id as member_id, m.name as member_name, m.mgroup, g.g_id, g.g_dohtml FROM ibf_posts p LEFT JOIN ibf_topics t ON (t.tid=p.topic_id) LEFT JOIN ibf_forums f ON (f.id=p.forum_id) LEFT JOIN ibf_members m ON (p.author_id=m.id) LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup) WHERE t.approved=1 AND t.moved_to IS NULL AND p.forum_id IN (-1{$ibforums->vars['csite_article_forum']}) $qe GROUP BY p.topic_id ORDER BY t.pinned DESC, p.post_date DESC LIMIT 0,$limit"); else $DB->query("SELECT t.*, f.read_perms, f.use_html, p.*, m.avatar, m.view_avs, m.avatar_size, m.id as member_id, m.name as member_name, m.mgroup, g.g_id, g.g_dohtml FROM ibf_topics t LEFT JOIN ibf_members m ON (t.starter_id=m.id) LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup) LEFT JOIN ibf_posts p ON (p.topic_id=t.tid) LEFT JOIN ibf_forums f on (f.id=p.forum_id) WHERE t.forum_id IN (-1{$ibforums->vars['csite_article_forum']}) $qe AND p.new_topic=1 AND t.approved=1 AND (t.moved_to IS NULL or t.moved_to='') ORDER BY t.pinned DESC, t.start_date DESC LIMIT 0,$limit"); else //-- mod_mysql5 end [MODE] insert_above [STEP] [SEARCH] $DB->query("SELECT t.tid, t.title, t.state, t.last_vote, p.* $sql [INSERT] //-- mod_mysql5 begin if (TRUE) { if ($extra) $DB->query("SELECT t.tid, t.title, t.state, t.last_vote, p.*, v.member_id as member_voted FROM ibf_polls AS p, ibf_topics AS t LEFT JOIN ibf_voters v ON (v.tid=t.tid) WHERE t.tid=$tid AND p.tid=t.tid AND v.member_id={$ibforums->member['id']}"); else $DB->query("SELECT t.tid, t.title, t.state, t.last_vote, p.* FROM ibf_polls AS p, ibf_topics AS t WHERE t.tid=$tid AND p.tid=t.tid"); } else //-- mod_mysql5 end [MODE] insert_above [FNAME_END] [MOD_TOKEN] mod_mysql5 [FNAME] sources/Drivers/mySQL.php [STEP] [SEARCH] if ($this->obj['debug']) { global $Debug, $ibforums; [INSERT] //-- mod_mysql5 begin if (!preg_match("`^create\s`ims", $the_query) && !preg_match("`^select\s`ims", $the_query)) $the_query = preg_replace("`([^\\\])''`", "\\1NULL", $the_query); //-- mod_mysql5 end [MODE] insert_above [FNAME_END] [CODE_END] [CUSTOMIZE] [color=red][b][size=5]Attention[/size][/b] [List][*][b]The installation must be processed before the update of your database to mySQL5[/b] [*][b]Before[/b] the installation process be sure to have made a complete backup of the board database. [*][b]After[/b] the installation process and before getting online test your board very very carefully. [*]If your database is already running under mySQL5, but the board does not work, then you can try to call directly mod_mysql5_install.php from the mod directory. Therefore copy that script into the root directory of your board and call it with your browser. If my ModInstaller does not work now, you have to apply the changes to the script files manually. [*]If you want to process a full new intallation of your IPB under mySQL5, then you have to customize sm_install.php first. In the mod directory you can find the file mysql5_create.txt. Use the content of that file to exchange the red marked part of sm_install.php. [quote]// DATA AND STUFF, ETC function get_sql() { $SQL = array(); [color=red]$SQL[] = "CREATE TABLE `ibf_admin_logs` ( `id` bigint(20) NOT NULL auto_increment, `act` varchar(255) default NULL, ... $SQL[] = "CREATE TABLE `ibf_warn_logs` ( `wlog_id` int(10) NOT NULL auto_increment, `wlog_mid` mediumint(8) default '0', `wlog_notes` text, `wlog_contact` varchar(250) default 'none', `wlog_contact_content` text, `wlog_date` int(10) NOT NULL default '0', `wlog_type` varchar(6) default 'pos', `wlog_addedby` mediumint(8) default '0', PRIMARY KEY (`wlog_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; [/color] $SQL[] = "INSERT INTO ibf_categories (id, position, state, name, description, image, url) VALUES (-1, NULL, NULL, '-', NULL, NULL, NULL)"; $SQL[] = "INSERT INTO ibf_categories (id, position, state, name, description, image, url) VALUES (1, 1, '1', 'A Test Category', '', '', '')"; [/quote] Thereafter you can call the install script without any further errrors. [*]If your board has to run under PHP5, then you have to customize sm_install.php again. INsert the blue code at the very beginning of the file: [quote] | > Update For mySQL5 AND PHP5 by Peter@ibforen.de | +-------------------------------------------------------------------------- */ error_reporting (E_ERROR | E_WARNING | E_PARSE); set_magic_quotes_runtime(0); [color=blue]$HTTP_SERVER_VARS = $_SERVER; $HTTP_GET_VARS = $_GET; $HTTP_POST_VARS = $_POST; $HTTP_POST_FILES = $_FILES; $HTTP_COOKIE_VARS = $_COOKIE; $HTTP_ENV_VARS = $_ENV; $HTTP_SESSION_FILES = $_SESSION;[/color] //+--------------------------------------- // ENTER YOUR PATH TO THE DIRECTORY THIS SCRIPT // IS IN. [/quote] [*]After the installation of the board under PHP5 you have to modify index.php and admin.php, too. In index.php insert the blue code as shown below: [quote]| > Wrapper script | > Script written by Matt Mecham | > Date started: 14th February 2002 | +-------------------------------------------------------------------------- */ [color=blue]//-- mod_sec_update_131 begin error_reporting (E_ALL); if (isset($HTTP_POST_VARS['GLOBALS']) || isset($_POST['GLOBALS']) || isset($HTTP_POST_FILES['GLOBALS']) || isset($_FILES['GLOBALS']) || isset($HTTP_GET_VARS['GLOBALS']) || isset($_GET['GLOBALS']) || isset($HTTP_COOKIE_VARS['GLOBALS']) || isset($_COOKIE['GLOBALS'])) { trigger_error('Is this a GLOBAL GPC hacking attempt?', E_USER_ERROR); } $HTTP_SERVER_VARS = isset($_SERVER)?$_SERVER:array(); $HTTP_GET_VARS = isset($_GET)?$_GET:array(); $HTTP_POST_VARS = isset($_POST)?$_POST:array(); $HTTP_POST_FILES = isset($_FILES)?$_FILES:array(); $HTTP_COOKIE_VARS = isset($_COOKIE)?$_COOKIE:array(); $HTTP_ENV_VARS = isset($_ENV)?$_ENV:array(); $HTTP_SESSION_VARS = isset($_SESSION)?$_SESSION:array(); //-- mod_sec_update_131 end[/color] //----------------------------------------------- // USER CONFIGURABLE ELEMENTS //----------------------------------------------- [/quote] In admin.php you have to insert the blue code like: [quote]| > Admin wrapper script | > Script written by Matt Mecham | > Date started: 1st March 2002 | +-------------------------------------------------------------------------- */ [color=blue]//-- mod_sec_update_131 begin define("ADMIN_SCRIPT_NAME", preg_replace("`^(.*?\.php).*$`", "\\1", basename(htmlentities($_SERVER['SCRIPT_NAME'])))); $HTTP_SERVER_VARS = isset($_SERVER)?$_SERVER:array(); $HTTP_GET_VARS = isset($_GET)?$_GET:array(); $HTTP_POST_VARS = isset($_POST)?$_POST:array(); $HTTP_POST_FILES = isset($_FILES)?$_FILES:array(); $HTTP_COOKIE_VARS = isset($_COOKIE)?$_COOKIE:array(); $HTTP_ENV_VARS = isset($_ENV)?$_ENV:array(); $HTTP_SESSION_VARS = isset($_SESSION)?$_SESSION:array(); //-- mod_sec_update_131 end[/color] /*----------------------------------------------- USER CONFIGURABLE ELEMENTS ------------------------------------------------*/ [/quote] [/list][/color] [CUSTOMIZE_END] [COMMENT_MOD] [COMMENT_MOD_END] [HISTORY_OLD] [HISTORY_OLD_END]