vars = $INFO;
//--------------------------------
// The clocks a' tickin'
//--------------------------------
$Debug = new Debug;
$Debug->startTimer();
//--------------------------------
// Load the DB driver and such
//--------------------------------
$ipsclass->init_db_connection();
//--------------------------------
// Set up our vars
//--------------------------------
$ipsclass->parse_incoming();
//--------------------------------
// Set debug mode
//--------------------------------
$ipsclass->DB->set_debug_mode( $ipsclass->vars['sql_debug'] == 1 ? intval($_GET['debug']) : 0 );
//--------------------------------
// Initialize the FUNC
//--------------------------------
$ipsclass->initiate_ipsclass();
//===========================================================================
// START THE MAGIC...
//===========================================================================
$message = '';
//insert Bump Me Up settings group
$result = $ipsclass->DB->query("SELECT * FROM `" . $INFO['sql_tbl_prefix'] . "conf_settings_titles` WHERE conf_title_title = 'Bump Me Up'");
if ($ipsclass->DB->get_num_rows($result) > 0) {
$message .= '- Bump Me Up settings group already exists ';
} else {
$ipsclass->DB->query("INSERT INTO `" . $INFO['sql_tbl_prefix'] . "conf_settings_titles` VALUES ( NULL , 'Bump Me Up', 'Bump Me Up Settings', 6, 0, 'bump_me_up', '');");
$message .= '- Bump Me Up settings group inserted ';
}
//get the id of the Bump Me Up settings group
$result = $ipsclass->DB->query("SELECT conf_title_id FROM `" . $INFO['sql_tbl_prefix'] . "conf_settings_titles` WHERE conf_title_title = 'Bump Me Up'");
$row = $ipsclass->DB->fetch_row($result);
$group_id = $row['conf_title_id'];
//insert Bump Me Up settings in to the group
$result = $ipsclass->DB->query("SELECT * FROM " . $INFO['sql_tbl_prefix'] . "conf_settings WHERE conf_title = 'Bump Me Up' OR conf_title = 'Bump page' OR conf_title = 'Start Date' OR conf_title = 'Recache forums' OR conf_title = 'Mark topic read' OR conf_title = 'Closed topics'");
if ($ipsclass->DB->get_num_rows($result) > 0) {
$message .= '- Bump Me Up settings already exists ';
} else {
$ipsclass->DB->query("INSERT INTO `" . $INFO['sql_tbl_prefix'] . "conf_settings` (conf_title,conf_description,conf_group,conf_type,conf_key,conf_value,conf_default,conf_extra,conf_evalphp,conf_protected,conf_position,conf_start_group,conf_end_group,conf_add_cache) VALUES ( 'Bump Me Up', 'Do you want to enable this mod ?', '{$group_id}', 'yes_no', 'bump_enable', '0' , '0' , NULL , NULL , 1, 0, '', '0', '1');");
$ipsclass->DB->query("INSERT INTO `" . $INFO['sql_tbl_prefix'] . "conf_settings` (conf_title,conf_description,conf_group,conf_type,conf_key,conf_value,conf_default,conf_extra,conf_evalphp,conf_protected,conf_position,conf_start_group,conf_end_group,conf_add_cache) VALUES ( 'Bump page', 'To which page do you want to be redirected after bumping a topic ?', '{$group_id}', 'dropdown', 'bump_redirect_page', '0' , '0' , '2=Bumped topic\r\n1=Forum index\r\n0=Board index' , NULL , 1, 1, '', '0', '1');");
$ipsclass->DB->query("INSERT INTO `" . $INFO['sql_tbl_prefix'] . "conf_settings` (conf_title,conf_description,conf_group,conf_type,conf_key,conf_value,conf_default,conf_extra,conf_evalphp,conf_protected,conf_position,conf_start_group,conf_end_group,conf_add_cache) VALUES ( 'Start date', 'Should the start date of the bumped topic be changed when bumping ?', '{$group_id}', 'yes_no', 'bump_start_date', '0' , '0' , NULL , NULL , 1, 2, '', '0', '1');");
$ipsclass->DB->query("INSERT INTO `" . $INFO['sql_tbl_prefix'] . "conf_settings` (conf_title,conf_description,conf_group,conf_type,conf_key,conf_value,conf_default,conf_extra,conf_evalphp,conf_protected,conf_position,conf_start_group,conf_end_group,conf_add_cache) VALUES ( 'Recache forums', 'Do you want to recache the forums after a bump (needed to update the forum index) ?', '{$group_id}', 'yes_no', 'bump_recache_forums', '0' , '0' , NULL , NULL , 1, 3, '', '0', '1');");
$ipsclass->DB->query("INSERT INTO `" . $INFO['sql_tbl_prefix'] . "conf_settings` (conf_title,conf_description,conf_group,conf_type,conf_key,conf_value,conf_default,conf_extra,conf_evalphp,conf_protected,conf_position,conf_start_group,conf_end_group,conf_add_cache) VALUES ( 'Mark topic read', 'Do you want to mark the bumped topic as read ?', '{$group_id}', 'yes_no', 'bump_mark_read', '0' , '0' , NULL , NULL , 1, 4, '', '0', '1');");
$ipsclass->DB->query("INSERT INTO `" . $INFO['sql_tbl_prefix'] . "conf_settings` (conf_title,conf_description,conf_group,conf_type,conf_key,conf_value,conf_default,conf_extra,conf_evalphp,conf_protected,conf_position,conf_start_group,conf_end_group,conf_add_cache) VALUES ( 'Closed topics', 'Allow locked topics to be bumped ?', '{$group_id}', 'yes_no', 'bump_closed', '0' , '0' , NULL , NULL , 1, 5, '', '0', '1');");
$message .= '- Bump Me Up settings inserted to group ';
}
//alter group table for Bump permissions
$query = mysql_query("SHOW COLUMNS FROM `" . $INFO['sql_tbl_prefix'] . "groups` LIKE 'g_bump_%'") or die(mysql_error());
if (mysql_num_rows($query) == 0) {
$ipsclass->DB->query("ALTER TABLE `" . $INFO['sql_tbl_prefix'] . "groups` ADD `g_bump_others` TINYINT( 1 ) NOT NULL ,
ADD `g_bump_interval` INT( 10 ) NOT NULL ,
ADD `g_bump_forums` TEXT ,
ADD `g_bump_enable` TINYINT( 1 ) NOT NULL");
$message .= '- Bump Me Up settings for groups inserted ';
} else {
$message .= '- Bump Me Up settings for groups already exists ';
}
//alter member table for Bump permissions
$query = mysql_query("SHOW COLUMNS FROM `" . $INFO['sql_tbl_prefix'] . "members` LIKE 'last_bump'") or die(mysql_error());
if (mysql_num_rows($query) == 0) {
$ipsclass->DB->query("ALTER TABLE `" . $INFO['sql_tbl_prefix'] . "members` ADD `last_bump` INT( 10 ) NOT NULL");
$message .= '- Bump Me Up settings for members inserted ';
} else {
$message .= '- Bump Me Up settings for members already exists ';
}
//add message that we are done
$message .= ' The installer has done all needed database changes. Please remove this file from your ipb installation';
//print message and that's a wrap!
echo "\n\nBump Me Up Installation\n\n\n";
echo "