竹貓星球

代碼: 選擇全部

<?php  
 /***************************************************************************  
 * nutport_install_sql.php  
 * -------------------  
 *  
 *  
 ***************************************************************************/  
  
 /***************************************************************************  
 *  
  
 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 . "portal (  
 portal_id mediumint(8) auto_increment NOT NULL,  
 portal_order mediumint(8) NOT NULL,  
 portal_title varchar(60) NOT NULL,  
 portal_description text NULL,  
 portal_bbcode_id varchar(10) NOT NULL,  
 portal_use_url tinyint(1) NULL,  
 portal_forum mediumint(8) NOT NULL,  
 portal_url varchar(250) NOT NULL,  
 portal_list_limit mediumint(8) NOT NULL,  
 portal_ascending tinyint(1) NULL,  
 portal_nodate tinyint(1) NULL,  
 portal_button_name varchar(100) NOT NULL,  
 portal_button_image varchar(100) NOT NULL,  
 portal_navbar tinyint(1) NULL,  
 portal_login tinyint(1) NULL,  
 portal_online tinyint(1) NULL,  
 portal_latest tinyint(1) NULL,  
 portal_poll tinyint(1) NULL,  
 PRIMARY KEY (portal_id)  
 )";  
  
 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">&</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);  
  
 ?>