竹貓星球

代碼: 選擇全部

INSERT INTO `phpbb_config` VALUES ('config_id', '1'); 
INSERT INTO `phpbb_config` VALUES ('board_disable', '0'); 
INSERT INTO `phpbb_config` VALUES ('sitename', 'yourdomain.com'); 
INSERT INTO `phpbb_config` VALUES ('site_desc', 'A _little_ text to describe your forum'); 
INSERT INTO `phpbb_config` VALUES ('cookie_name', 'phpbb2mysql1211'); 
INSERT INTO `phpbb_config` VALUES ('cookie_path', '/'); 
INSERT INTO `phpbb_config` VALUES ('cookie_domain', ''); 
INSERT INTO `phpbb_config` VALUES ('cookie_secure', '0'); 
INSERT INTO `phpbb_config` VALUES ('session_length', '3600'); 
INSERT INTO `phpbb_config` VALUES ('allow_html', '0'); 
INSERT INTO `phpbb_config` VALUES ('allow_html_tags', 'b,i,u,pre'); 
INSERT INTO `phpbb_config` VALUES ('allow_bbcode', '1'); 
INSERT INTO `phpbb_config` VALUES ('allow_smilies', '1'); 
INSERT INTO `phpbb_config` VALUES ('allow_sig', '1'); 
INSERT INTO `phpbb_config` VALUES ('allow_namechange', '0'); 
INSERT INTO `phpbb_config` VALUES ('allow_theme_create', '0'); 
INSERT INTO `phpbb_config` VALUES ('allow_avatar_local', '0'); 
INSERT INTO `phpbb_config` VALUES ('allow_avatar_remote', '0'); 
INSERT INTO `phpbb_config` VALUES ('allow_avatar_upload', '0'); 
INSERT INTO `phpbb_config` VALUES ('enable_confirm', '0'); 
INSERT INTO `phpbb_config` VALUES ('override_user_style', '[color=red]1[/color]'); 
INSERT INTO `phpbb_config` VALUES ('posts_per_page', '15'); 
INSERT INTO `phpbb_config` VALUES ('topics_per_page', '50'); 
INSERT INTO `phpbb_config` VALUES ('hot_threshold', '25'); 
INSERT INTO `phpbb_config` VALUES ('max_poll_options', '10'); 
INSERT INTO `phpbb_config` VALUES ('max_sig_chars', '255'); 
INSERT INTO `phpbb_config` VALUES ('max_inbox_privmsgs', '50'); 
INSERT INTO `phpbb_config` VALUES ('max_sentbox_privmsgs', '25'); 
INSERT INTO `phpbb_config` VALUES ('max_savebox_privmsgs', '50'); 
INSERT INTO `phpbb_config` VALUES ('board_email_sig', 'Thanks, The Management'); 
INSERT INTO `phpbb_config` VALUES ('board_email', '[color=red]系統管理員電子信箱[/color]'); 
INSERT INTO `phpbb_config` VALUES ('smtp_delivery', '0'); 
INSERT INTO `phpbb_config` VALUES ('smtp_host', ''); 
INSERT INTO `phpbb_config` VALUES ('smtp_username', ''); 
INSERT INTO `phpbb_config` VALUES ('smtp_password', ''); 
INSERT INTO `phpbb_config` VALUES ('sendmail_fix', '0'); 
INSERT INTO `phpbb_config` VALUES ('require_activation', '0'); 
INSERT INTO `phpbb_config` VALUES ('flood_interval', '15'); 
INSERT INTO `phpbb_config` VALUES ('board_email_form', '0'); 
INSERT INTO `phpbb_config` VALUES ('avatar_filesize', '6144'); 
INSERT INTO `phpbb_config` VALUES ('avatar_max_width', '80'); 
INSERT INTO `phpbb_config` VALUES ('avatar_max_height', '80'); 
INSERT INTO `phpbb_config` VALUES ('avatar_path', 'images/avatars'); 
INSERT INTO `phpbb_config` VALUES ('avatar_gallery_path', 'images/avatars/gallery'); 
INSERT INTO `phpbb_config` VALUES ('smilies_path', 'images/smiles'); 
INSERT INTO `phpbb_config` VALUES ('default_style', '[color=red]2[/color]'); 
INSERT INTO `phpbb_config` VALUES ('default_dateformat', 'D M d, Y g:i a'); 
INSERT INTO `phpbb_config` VALUES ('board_timezone', '8'); 
INSERT INTO `phpbb_config` VALUES ('prune_enable', '1'); 
INSERT INTO `phpbb_config` VALUES ('privmsg_disable', '0'); 
INSERT INTO `phpbb_config` VALUES ('gzip_compress', '0'); 
INSERT INTO `phpbb_config` VALUES ('coppa_fax', ''); 
INSERT INTO `phpbb_config` VALUES ('coppa_mail', ''); 
INSERT INTO `phpbb_config` VALUES ('record_online_users', '2'); 
INSERT INTO `phpbb_config` VALUES ('record_online_date', '1102778480'); 
INSERT INTO `phpbb_config` VALUES ('server_name', '[color=red]你的網域名稱[/color]'); 
INSERT INTO `phpbb_config` VALUES ('server_port', '80'); 
INSERT INTO `phpbb_config` VALUES ('script_path', '/[color=red]系統存放位置[/color]/'); 
INSERT INTO `phpbb_config` VALUES ('version', '.0.11'); 
INSERT INTO `phpbb_config` VALUES ('board_startdate', '1102777223'); 
INSERT INTO `phpbb_config` VALUES ('default_lang', 'chinese_traditional_taiwan');

代碼: 選擇全部

<?php
#########################################################
## SQL commands to phpBB2
## Author: Niels Chr. R鷣\r
## Nickname: Niels Chr. Denmark
## Email: ncr@db9.dk
##
## Ver 1.0.7
##
## phpBB2 database update script for mods
## this file is intended to use with phpBB2, when installing mods
## after so you may delete this file, but only admin can use so it really doesen't matter
## The script will look what prefix you are using, and use the existing DB defined by congig.php
## The execution of this script's included SQL is harmless, so you can run it as meny times you like
## note, though that the users last visit, will be set back to his/her last login, 
## but that is a minor cosmetic isue, that will correct it self next time the use  logs in
##
## the following example are from my mods, and you can add some self, for other mods if you like
## you will after execution get a list over those commands that are run with succes and those with warnings !
## delete the sample lines if you are using it only for other mods
##
#########################################################

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($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_birthday INT DEFAULT "999999" not null  ',
'ALTER TABLE '.USERS_TABLE.' ADD user_next_birthday_greeting INT DEFAULT "0" not null ',
[color=red]'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("birthday_required", "0")',
'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("birthday_greeting", "1")',
'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("max_user_age", "100")',
'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("min_user_age", "5")',
'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("birthday_check_day", "7")'
);[/color]

$mods = array ( 
'Birthday PART 1 Mod','Birthday PART 1 Mod','Birthday PART 2 Mod','Birthday PART 2 Mod','Birthday PART 2 Mod','Birthday PART 2 Mod','Birthday PART 2 Mod',
);

############################################### 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); 
?>