phpBB.de

Code: Alles auswählen

#-----[ SQL ]------------------------------------------ 
#

INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) 
VALUES (
'dload_root', '0'
),(
'dload_pag', '0'
),(
'dload_perpag_num', '20'
),(
'dload_perpag_type', '2'
),(
'dload_folder', '0'
),(
'dload_dir', ''
),(
'dload_comm', '1'
),(
'dload_dir_sub', '0'
),(
'dload_search', '0'
);

ALTER TABLE `phpbb_forums` ADD `dload_check` TINYINT( 1 ) DEFAULT '0' NOT NULL ;

Code: Alles auswählen

<?php
/***************************************************************************
 *                               db_update.php
 *                            -------------------
 *
 *   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//


if( !$userdata['session_logged_in'] )
{
	$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
	header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));
	exit;
}

if( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}


$page_title = 'Updating the database';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">';


$sql = array();
$sql[] = "CREATE TABLE " . $table_prefix . "hacklist (
  hack_id mediumint(8) unsigned NOT NULL auto_increment,
  hack_name varchar(255) NOT NULL default '',
  hack_desc varchar(255) NOT NULL default '',
  hack_version varchar(32) NOT NULL default '',
  hack_download_url tinytext NOT NULL,
  hack_cat varchar(20) NOT NULL default '',
  hack_author varchar(255) NOT NULL default '',
  hack_author_email varchar(255) NOT NULL default '',
  hack_author_website tinytext NOT NULL,
  PRIMARY KEY  (hack_id),
  UNIQUE KEY hack_name (hack_name)
) TYPE=MyISAM";
$sql[] = "CREATE TABLE " . $table_prefix . "hack_cat(
cat_id mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
cat_order MEDIUMINT( 8 ) DEFAULT '10' NOT NULL ,
cat_name varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( cat_id ) ,
UNIQUE KEY hack_name( cat_name )
) TYPE = MYISAM";

for( $i = 0; $i < count($sql); $i++ )
{
	if( !$result = $db->sql_query ($sql[$i]) )
	{
		$error = $db->sql_error();

		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';
	}
	else
	{
		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successfull</b></font></li><br />';
	}
}


echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>';

echo '<tr><th>End</th></tr><tr><td><span class="genmed">Installation is now finished. Please be sure to delete this file now.<br />If you have run into any errors, please visit the <a href="http://www.phpbbhacks.com/forums" target="_phpbbhacks">phpBBHacks.com support forums</a> and ask someone for help.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Have a nice day</a></span></td></table>';

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>