phpBB.de

Code: Alles auswählen

<?php 
/*************************************************************************** 
 *                               db_update.php 
 *                            ------------------- 
 * 
 *   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey 
 *   project              : http://sourceforge.net/projects/dbgenerator 
 *   Website              : http://freakingbooty.no-ip.com/ & http://www.rapiddr3am.net 
 * 
 ***************************************************************************/ 

/*************************************************************************** 
 * 
 *   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(); 


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.phpbbsupport.co.uk" target="_phpbbsupport">phpBBSupport.co.uk</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); 

?>

Code: Alles auswählen

Run the following command on your sql database (replace phpbb_ with your db prefix):
##
## ALTER TABLE `phpbb_users` ADD `user_reminded` TINYINT(4) DEFAULT '0' NOT NULL 

Code: Alles auswählen

<?php

define('IN_PHPBB', true);
$phpbb_root_path = './';
include_once($phpbb_root_path . 'extension.inc');
include_once($phpbb_root_path . 'common.'.$phpEx);
include_once($phpbb_root_path . 'includes/functions_selects.'.$phpEx);
define('SITE_HISTORY_TABLE', $table_prefix.'site_history');

###################################################################################################
##
## put the SQL commands below here, the SQL commands listed below are only exampels, substitude them with the one you need ##
##
###################################################################################################
$sql=array(
'ALTER TABLE '.USERS_TABLE.' ADD user_reminded TINYINT(4) DEFAULT "0" not null '
);

$mods = array ( 
'DB-Installer',
);

############################################### Do not change anything below this line #######################################

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

if ($userdata['user_level']!=ADMIN)
      message_die(GENERAL_ERROR, "You are not Authorised to do this"); 
$n=0;
$message="<b>This list is a result of the SQL queries needed for the additional mods in the pre-moded pack</b><br/><br/>";
while($sql[$n])
{
	$message .= ($mods[$n-1] != $mods[$n]) ? '<p><b><font size=3>'.$mods[$n].'</font></b><br/>' : '';
	if(!$result = $db->sql_query($sql[$n])) 
	$message .= '<b><font color=#FF0000>[Already added]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />';
	else $message .='<b><font color=#0000fF>[Added/Updated]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />';
	$n++;
}
 message_die(GENERAL_MESSAGE, $message); 
?>