📄 installsql.php
字号:
`field_state` int(1) NOT NULL default '0',
`field_country` int(1) NOT NULL default '0',
`field_interests` int(1) NOT NULL default '0',
`categories_on` int(1) NOT NULL default '0',
`allow_avatars` int(1) NOT NULL default '0',
`avatar_filesize` int(14) NOT NULL default '0',
`avatar_height` int(14) NOT NULL default '0',
`avatar_width` int(14) NOT NULL default '0',
`show_memberlist` int(1) NOT NULL default '0',
`show_userstats` int(1) NOT NULL default '0',
`homepage` varchar(200) NOT NULL default '',
`tips` int(1) NOT NULL default '0',
`debug` int(1) NOT NULL default '0',
`banned_usernames` text NOT NULL,
`banned_emails` text NOT NULL,
`banned_ips` text NOT NULL,
`banned_ips_access` text NOT NULL,
`banned_badwords` text NOT NULL,
`banned_badwords_replace` text NOT NULL,
`comment_image` int(1) NOT NULL default '0',
`url` int(1) NOT NULL default '0'
)
");
//######### INSERT DEFAULTS INTO bhost_admin
mysql_query("INSERT INTO `bhost_admin` (username, password, license, fname, lname, email, language, html_header, html_footer, faq_on, allow_password, signup_choosetemplate, signup_templatedefault, signup_emaildupeok, signup_emaildomain, signup_emailverify, signup_notify, signup_timezone, signup_format_date, signup_format_time, signup_sendemail, signup_terms, signup_termstext, signup_image, comment_subject, comment_message, welcome_subject, welcome_message, verify_subject, verify_message, user_password_subject, user_password_email, forgot_subject, forgot_message, field_website, field_screenname, field_gender, field_birthday, field_city, field_state, field_country, field_interests, categories_on, allow_avatars, avatar_filesize, avatar_height, avatar_width, show_memberlist, show_userstats, homepage, tips, debug, banned_usernames, banned_emails, banned_ips, banned_ips_access, banned_badwords, banned_badwords_replace, comment_image, url) VALUES ('admin', 'blog4321', '', 'Admin', 'Admin', 'youremail@yourdomain.com', 'lang_english.php', '\n<html>\n<head>\n<title>Weblog Host</title>\n<style type=''text/css''>\n\n/* PAGE WIDTH */\ntable.page { width: 100%; }\n\n/* MENU */\ntd.item { background: #F5F5F5; font-size: 8pt; padding: 5px; padding-left: 4px; border-bottom: 1px solid #AAAAAA; }\ntd.item2 { background: #DDDDDD; font-size: 8pt; padding: 5px; padding-left: 4px; border-bottom: 1px solid #AAAAAA; }\ntd.itemcat { background: #666666; color: #FFFFFF; font-size: 8pt; padding: 5px; padding-left: 4px; border-bottom: 1px solid #AAAAAA; }\ntd.itemlogout { background: #F5F5F5; font-size: 8pt; padding: 5px; padding-left: 4px; }\n\n/* GLOBAL */\nbody { font-size: 8pt; font-family: verdana, arial, tahoma; color: #333333; }\nform { margin: 0px; }\ntd { font-size: 8pt; font-family: verdana, arial, tahoma; color: #333333; }\ntd.content { padding: 10px; padding-top: 2px; padding-right: 0px; line-height: 17px; color: #333333; }\ntd.list { background: #FFFFFF; padding: 7px; border: 1px solid #AAAAAA; border-top: none; }\ntd.header { border: 1px solid #AAAAAA; padding: 7px; padding-bottom: 7px; background: #DDDDDD; font-weight: bold; }\ntd.header2 { border: 1px solid #AAAAAA; border-right: none; padding: 7px; padding-bottom: 7px; background: #DDDDDD; font-weight: bold; }\ntd.announce { background: #F5F5F5; padding: 7px; border: 1px solid #CCCCCC; }\ntd.box { padding: 7px; line-height: 17px; padding-left: 0px; padding-top: 0px; }\ntd.empty { background: #F5F5F5; padding: 7px; border: 1px solid #AAAAAA; }\ntd.entry1 { border-right: 1px solid #DDDDDD; padding: 5px; padding-right: 10px; padding-bottom: 0px; }\ntd.entry2 { padding: 5px; padding-left: 10px; padding-bottom: 0px; }\ntd.advanced { padding: 5px; background: #EEEEEE; border-bottom: 1px solid #AAAAAA; }\ndiv.float { float: left; padding-right: 1px; }\ntable.box { width: 130px; border: 1px solid #666666; border-bottom: 2px solid #666666; background: #F5F5F5; }\n\n/* PROFILE PAGE */\nimg.avatar { border: 1px solid #666666; }\ntable.profile { border: 1px solid #AAAAAA; }\ntd.profile1 { background: #DDDDDD; font-weight: bold; border-bottom: 1px solid #AAAAAA; padding: 6px; padding-bottom: 0px; }\ntd.profile2 { background: #F5F5F5; padding: 6px; line-height: 17px; color: #333333; }\nli { list-style-type: square; }\n\n/* CHOOSE TEMPLATE PAGE */\nimg.template { border: 1px solid #AAAAAA; margin-top: 3px; }\ndiv.templatebox { padding: 5px; background: #FFFFFF; border: 1px solid #666666; margin-top: 5px; margin-right: 15px; }\n\n/* EDIT TEMPLATE PAGE */\ntextarea.edit_template { margin-top: 10px; width: 100%; font-family: \"Courier New\", courier, arial, tahoma; }\n\n/* GENERAL SETTINGS PAGE */\ntextarea.settings { width: 413px; font-size: 9pt; font-family: \"Courier New\"; }\n\n/* ALTERNATING LISTS */\ntd.list1a { background: #FFFFFF; padding: 7px; border: 1px solid #CCCCCC; border-top: none; border-right: none; }\ntd.list1b { background: #FFFFFF; padding: 7px; border: 1px solid #CCCCCC; border-top: none; }\ntd.list2a { background: #F5F5F5; padding: 7px; border: 1px solid #CCCCCC; border-top: none; border-right: none; }\ntd.list2b { background: #F5F5F5; padding: 7px; border: 1px solid #CCCCCC; border-top: none; }\n\n/* FONTS */\nh1 { margin-left: 3px; font-family: \"Trebuchet MS\", verdana, arial, tahoma; margin-bottom: 4px; font-size: 18pt; }\nh2 { font-family: \"Trebuchet MS\", verdana, arial, tahoma; margin-bottom: 2px; font-size: 12pt; }\nfont.disabled { color: #666666; }\nfont.gray { color: #666666; }\nfont.stats { font-size: 7pt; font-family: arial, verdana, tahoma; }\nfont.url { font-size: 9pt; font-weight: normal; }\n\n/* INPUT FIELDS */\ninput.button { background-color: #DDDDDD; padding: 3px; font-size: 9pt; font-weight: bold; font-family: verdana, arial, tahoma; }\ninput.sbutton { background-color: #DDDDDD; font-size: 8pt; font-weight: bold; font-family: verdana, arial, tahoma; }\ninput.text { font-family: arial, verdana, tahoma; }\ntextarea, select { font-family: arial, verdana, tahoma; margin-top: 1px; font-size: 10pt; }\nselect.small { font-size: 8pt; margin-left: 4px; }\ninput.status { border: none; background: clear; padding-left: 8px; font-size: 8pt; font-weight: bold; font-family: verdana, arial, tahoma; }\n\n/* NORMAL LINKS */\na:link { color: #000066; }\na:visited { color: #000066; }\na:hover { color: #000066; }\n\n/* MENU LINKS */\na.menu:link { color: #000000; text-decoration: none; }\na.menu:visited { color: #000000; text-decoration: none; }\na.menu:hover { color: #000000; text-decoration: underline; }\n\n</style>\n</head>\n<body>\n\n<!-- REPLACE WITH YOUR LOGO -->\n<table width=''300'' cellpadding=''7'' cellspacing=''0'' style=''border: 1px dashed #AAAAAA; background: #F5F5F5;''>\n<tr><td><font style=''font-size: 12pt;''><b>Your Logo/HTML Header Here</b></font><br>Replace this area in your admin control panel.</td></tr>\n</table>\n\n<br>\n', '</body>\r\n</html>\r\n', 1, 1, 1, 1, 1, '', 0, 0, '-8', 'n/j/Y', 'g:i A', 1, 0, '', 0, 'A comment has been posted by <author>', 'Hello <fname> <lname>,\r\n\r\n<author> posted a comment in your weblog. Follow this link to view the comment:\r\n<link>\r\n\r\nThank You', 'Your New Weblog', 'Hello <fname> <lname>,\r\n\r\nThank you for creating your new weblog! Your weblog can be viewed at this address:\r\n<link>\r\n\r\nThank You', 'Your New Weblog - Verification', 'Hello <fname> <lname>,\r\n\r\nTo verify your email address, please click the following link:\r\n<link>\r\n\r\nThank You', 'Your Account Password', 'Hello <fname> <lname>,\r\nThank you for creating your new weblog! You can login with the following information:\r\n\r\nUsername: <username>\r\nPassword: <password>\r\n\r\nThank You', 'Forgotten Password Request', 'Hello <fname> <lname>,\r\n\r\nYou have received this email because a password retrieval request was made for your account. Here is your login information:\r\n\r\nUsername: <username>\r\nPassword: <password>\r\n\r\nThank You', 2, 2, 2, 2, 2, 2, 2, 0, 0, 1, '50', '100', '100', 1, 1, '', 1, 0, '', '', '', '', '', '', 0, 0)");
//######### CREATE bhost_categories
mysql_query("CREATE TABLE `bhost_categories` (
`wc_id` int(8) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
PRIMARY KEY (`wc_id`)
)
");
//######### CREATE bhost_comments
mysql_query("CREATE TABLE `bhost_comments` (
`c_id` int(8) NOT NULL auto_increment,
`e_id` int(8) NOT NULL default '0',
`u_id` int(8) NOT NULL default '0',
`author_u_id` int(8) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`IP` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`contents` text NOT NULL,
`date` int(14) default NULL,
PRIMARY KEY (`c_id`)
)
");
//######### CREATE bhost_entries
mysql_query("CREATE TABLE `bhost_entries` (
`e_id` int(8) NOT NULL auto_increment,
`u_id` int(8) NOT NULL default '0',
`ec_id` int(8) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -