WeedCMS之install.php
<div id="cnblogs_post_body"><div class="cnblogs_code">1 <?php2 if(version_compare(PHP_VERSION,'5.0.0','<')){ //SDF:比较版本大小，operator默认为">"3 exit('PHP>5.0.0');4 }5 @header("content-type:text/html;charset=utf-8");6 if($_POST){ //如果填写了安装表单，则接受表单的值并填充7 $form_db_host =$_POST['DB_HOST'];8 $form_db_user =$_POST['DB_USER'];9 $form_db_password =$_POST['DB_PASSWORD']; 10 $form_db_name =$_POST['DB_NAME']; 11 $form_db_prefix =$_POST['DB_PREFIX']; 12 $connect=@mysql_connect($form_db_host,$form_db_user,$form_db_password) or die(mysql_error()); 13 if(!@mysql_select_db($form_db_name,$connect)){ 14 if(!@mysql_query("CREATE DATABASE {$form_db_name} DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci",$connect)){ 15 exit('您没有权限创建数据库！'); 16 } 17 } 18 @mysql_select_db($form_db_name,$connect) or die(mysql_error()); 19 @mysql_query("set names 'utf8'", $connect); 20 $sql=array(); 21 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."ad` ( 22 `ad_id` smallint(2) NOT NULL AUTO_INCREMENT, 23 `ad_name` varchar(255) NOT NULL DEFAULT '', 24 `ad_content` text NOT NULL, 25 `ad_start` int(10) unsigned NOT NULL DEFAULT '0', 26 `ad_end` int(10) unsigned NOT NULL DEFAULT '0', 27 `ad_state` tinyint(1) unsigned NOT NULL DEFAULT '0', 28 PRIMARY KEY (`ad_id`) 29 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;"; 30 31 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."admin` ( 32 `admin_id` tinyint(1) unsigned NOT NULL AUTO_INCREMENT, 33 `admin_name` varchar(50) NOT NULL, 34 `admin_password` varchar(100) NOT NULL, 35 `admin_permissions` text NOT NULL, 36 `admin_state` tinyint(1) unsigned NOT NULL DEFAULT '0', 37 PRIMARY KEY (`admin_id`) 38 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;"; 39 40 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."admin_log` ( 41 `log_time` int(10) NOT NULL DEFAULT '0', 42 `log_info` varchar(255) NOT NULL, 43 `log_ip` varchar(50) NOT NULL DEFAULT '', 44 `log_agent` varchar(255) NOT NULL, 45 `admin_id` int(4) unsigned NOT NULL DEFAULT '0' 46 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;"; 47 48 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."config` ( 49 `config_type` varchar(10) NOT NULL DEFAULT '', 50 `config_value` text NOT NULL 51 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;"; 52 53 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."content` ( 54 `content_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 55 `content_title` varchar(255) NOT NULL, 56 `content_url` varchar(255) NOT NULL DEFAULT '', 57 `content_keywords` varchar(255) NOT NULL DEFAULT '', 58 `content_text` text NOT NULL, 59 `content_description` varchar(255) NOT NULL DEFAULT '', 60 `content_password` varchar(255) NOT NULL, 61 `content_thumb` varchar(255) NOT NULL, 62 `content_support` smallint(5) unsigned NOT NULL DEFAULT '0', 63 `content_against` smallint(5) unsigned NOT NULL DEFAULT '0', 64 `content_click_count` mediumint(8) unsigned NOT NULL DEFAULT '0', 65 `content_comment_count` smallint(5) unsigned NOT NULL DEFAULT '0', 66 `content_is_best` tinyint(1) unsigned NOT NULL DEFAULT '0', 67 `content_is_comment` tinyint(1) unsigned NOT NULL DEFAULT '0', 68 `content_state` tinyint(1) unsigned NOT NULL DEFAULT '0', 69 `content_time` int(10) unsigned NOT NULL DEFAULT '0', 70 `channel_id` tinyint(3) unsigned NOT NULL DEFAULT '0', 71 `category_id` tinyint(3) unsigned NOT NULL DEFAULT '0', 72 `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 73 PRIMARY KEY (`content_id`) 74 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;"; 75 76 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."content_attachment` ( 77 `attachment_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 78 `attachment_name` varchar(30) NOT NULL, 79 `content_id` mediumint(8) unsigned NOT NULL DEFAULT '0', 80 PRIMARY KEY (`attachment_id`) 81 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;"; 82 83 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."content_category` ( 84 `category_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, 85 `category_name` varchar(50) NOT NULL DEFAULT '', 86 `category_deep` tinyint(3) unsigned NOT NULL DEFAULT '0', 87 `category_sort` tinyint(3) unsigned NOT NULL DEFAULT '0', 88 `category_state` tinyint(1) unsigned NOT NULL DEFAULT '0', 89 `parent_id` tinyint(3) unsigned NOT NULL DEFAULT '0', 90 `channel_id` tinyint(3) NOT NULL DEFAULT '0', 91 PRIMARY KEY (`category_id`) 92 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;"; 93 94 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."content_channel` ( 95 `channel_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, 96 `channel_name` varchar(50) NOT NULL, 97 `channel_description` varchar(255) NOT NULL, 98 `channel_banner` varchar(255) NOT NULL DEFAULT '', 99 `channel_index` tinyint(1) unsigned NOT NULL DEFAULT '0',100 `channel_index_truncate` tinyint(3) unsigned NOT NULL DEFAULT '0',101 `channel_index_size` tinyint(3) unsigned NOT NULL DEFAULT '0',102 `channel_index_style` tinyint(3) unsigned NOT NULL DEFAULT '0',103 `channel_list_truncate` tinyint(3) unsigned NOT NULL DEFAULT '0',104 `channel_list_size` tinyint(3) unsigned NOT NULL DEFAULT '0',105 `channel_list_style` tinyint(3) unsigned NOT NULL DEFAULT '0',106 `channel_content_style` tinyint(1) unsigned NOT NULL DEFAULT '0',107 `channel_content_count` mediumint(8) unsigned NOT NULL DEFAULT '0',108 `channel_sort` tinyint(3) NOT NULL DEFAULT '0',109 `channel_read_permissions` tinyint(3) NOT NULL DEFAULT '0',110 `channel_write_permissions` tinyint(3) NOT NULL DEFAULT '0',111 `channel_comment_permissions` tinyint(3) NOT NULL DEFAULT '0',112 `channel_upload_ext` varchar(255) NOT NULL DEFAULT '',113 `channel_cache` tinyint(1) unsigned NOT NULL DEFAULT '0',114 `channel_state` tinyint(1) unsigned NOT NULL DEFAULT '0',115 PRIMARY KEY (`channel_id`)116 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;";117 118 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."content_comment` (119 `comment_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,120 `comment_content` text NOT NULL,121 `comment_reply` text NOT NULL,122 `comment_time` int(10) unsigned NOT NULL DEFAULT '0',123 `comment_ip` varchar(50) NOT NULL DEFAULT '',124 `comment_agent` varchar(255) NOT NULL DEFAULT '',125 `comment_state` tinyint(1) unsigned NOT NULL DEFAULT '0',126 `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',127 `content_id` mediumint(8) unsigned NOT NULL DEFAULT '0',128 `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',129 PRIMARY KEY (`comment_id`)130 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;";131 132 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."content_link` (133 `link_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,134 `link_url` varchar(255) NOT NULL,135 `content_id` mediumint(8) unsigned NOT NULL DEFAULT '0',136 PRIMARY KEY (`link_id`)137 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;";138 139 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."feedback` (140 `feedback_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,141 `feedback_name` varchar(50) NOT NULL DEFAULT '',142 `feedback_content` text NOT NULL,143 `feedback_reply` text NOT NULL,144 `feedback_time` int(10) unsigned NOT NULL DEFAULT '0',145 `feedback_reply_time` int(10) unsigned NOT NULL DEFAULT '0',146 `feedback_ip` varchar(20) NOT NULL DEFAULT '',147 `feedback_state` tinyint(1) unsigned NOT NULL DEFAULT '0',148 PRIMARY KEY (`feedback_id`)149 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;";150 151 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."link` (152 `link_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,153 `link_name` varchar(50) NOT NULL,154 `link_logo` varchar(100) NOT NULL DEFAULT '',155 `link_text` varchar(255) NOT NULL,156 `link_url` varchar(255) NOT NULL,157 `link_sort` int(4) unsigned NOT NULL DEFAULT '0',158 `link_state` tinyint(1) unsigned NOT NULL DEFAULT '0',159 PRIMARY KEY (`link_id`)160 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;";161 162 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."member` (163 `member_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,164 `member_nickname` varchar(50) NOT NULL DEFAULT '',165 `member_mail` varchar(255) NOT NULL,166 `member_password` varchar(255) NOT NULL,167 `member_safecode` varchar(255) NOT NULL,168 `member_name` varchar(50) NOT NULL DEFAULT '',169 `member_sex` tinyint(1) unsigned NOT NULL DEFAULT '0',170 `member_birthday` int(10) unsigned NOT NULL DEFAULT '0',171 `member_phone` varchar(50) NOT NULL DEFAULT '',172 `member_photo` varchar(50) NOT NULL DEFAULT '',173 `member_from` varchar(255) NOT NULL DEFAULT '',174 `member_other` varchar(255) NOT NULL DEFAULT '',175 `member_join_time` int(10) NOT NULL DEFAULT '0',176 `member_last_time` int(10) NOT NULL DEFAULT '0',177 `member_last_ip` varchar(50) NOT NULL,178 `member_validation` tinyint(1) unsigned NOT NULL DEFAULT '0',179 `member_validation_key` varchar(32) NOT NULL,180 `member_state` tinyint(1) unsigned NOT NULL DEFAULT '0',181 `group_id` tinyint(3) unsigned NOT NULL DEFAULT '0',182 PRIMARY KEY (`member_id`)183 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;";184 185 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."member_group` (186 `group_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,187 `group_name` varchar(50) NOT NULL DEFAULT '',188 PRIMARY KEY (`group_id`)189 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;";190 191 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."menu` (192 `menu_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,193 `menu_name` varchar(50) NOT NULL,194 `menu_link` varchar(255) NOT NULL,195 `menu_target` tinyint(1) unsigned NOT NULL DEFAULT '0',196 `menu_mode` tinyint(1) unsigned NOT NULL DEFAULT '0',197 `menu_sort` tinyint(3) unsigned NOT NULL DEFAULT '0',198 `menu_state` tinyint(1) unsigned NOT NULL DEFAULT '0',199 `parent_id` tinyint(3) unsigned NOT NULL DEFAULT '0',200 PRIMARY KEY (`menu_id`)201 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;";202 203 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."online` (204 `online_time` int(10) unsigned NOT NULL DEFAULT '0',205 `online_ip` varchar(20) NOT NULL,206 `online_url` varchar(255) NOT NULL,207 `online_agent` varchar(255) NOT NULL,208 KEY `onlinetime` (`online_time`)209 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;";210 211 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."page` (212 `page_id` int(3) NOT NULL AUTO_INCREMENT,213 `page_title` varchar(255) NOT NULL DEFAULT '',214 `page_content` text NOT NULL,215 `page_permissions` int(3) NOT NULL DEFAULT '0',216 `page_sort` int(3) unsigned NOT NULL DEFAULT '0',217 `page_state` tinyint(1) NOT NULL DEFAULT '0',218 PRIMARY KEY (`page_id`)219 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;";220 221 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."vote` (222 `vote_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,223 `vote_title` varchar(255) NOT NULL,224 `vote_start` int(10) unsigned NOT NULL DEFAULT '0',225 `vote_end` int(10) unsigned NOT NULL DEFAULT '0',226 `vote_mode` tinyint(1) unsigned NOT NULL DEFAULT '0',227 `vote_place` tinyint(1) unsigned NOT NULL DEFAULT '0',228 `vote_state` tinyint(1) unsigned NOT NULL DEFAULT '0',229 PRIMARY KEY (`vote_id`)230 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;";231 232 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."vote_item` (233 `item_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,234 `item_title` varchar(255) NOT NULL DEFAULT '',235 `item_count` smallint(5) unsigned NOT NULL DEFAULT '0',236 `vote_id` tinyint(3) unsigned NOT NULL DEFAULT '0',237 PRIMARY KEY (`item_id`)238 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;";239 240 $sql[]="CREATE TABLE IF NOT EXISTS `".$form_db_prefix."vote_log` (241 `log_id` int(4) unsigned NOT NULL AUTO_INCREMENT,242 `log_ip` varchar(50) NOT NULL DEFAULT '',243 `log_agent` varchar(255) NOT NULL DEFAULT '',244 `log_time` int(10) unsigned NOT NULL DEFAULT '0',245 `vote_id` tinyint(3) unsigned NOT NULL,246 PRIMARY KEY (`log_id`)247 ) ENGINE=MyISAMDEFAULT CHARSET=utf8;";248 249 $sql[]="INSERT INTO `".$form_db_prefix."admin`(`admin_name`,`admin_password`,`admin_permissions`,`admin_state`) VALUES('admin', 'D033E22AE348AEB5660FC2140AEC35850C4DA997','all',1);";250 251 $sql[]="INSERT INTO `".$form_db_prefix."config` (`config_type`, `config_value`) VALUES ('config','YTozNTp7czo5OiJzaXRlX25hbWUiO3M6MjQ6IumHjuiNiee9keermeeuoeeQhuezu+e7nyI7czo4OiJzaXRlX2ljcCI7czoxNzoiSUNQ5aSHMDAwMDAwMDHlj7ciO3M6MTM6InNpdGVfa2V5d29yZHMiO3M6MTY6IumHjuiNiSxQSFAsTVlTUUwiO3M6MTY6InNpdGVfZGVzY3JpcHRpb24iO3M6MTAwOiLph47ojYnnvZHnq5nnrqHnkIbns7vnu5/vvIhXRUVEQ01T77yJ5piv55Sx6YeO6I2J54us56uL5Z+65LqOUEhQK01ZU1FM5byA5Y+R55qE5YaF5a65566h55CG57O757uf44CCIjtzOjExOiJzaXRlX25vdGljZSI7czo3Njoi5qyi6L+O5L2/55So6YeO6I2J5YaF5a65566h55CG57O757ufV2VlZENNUyzmnInpl67popjor7fov5vlhaVRUee+pDoxNjc0MDYyMiI7czoxMDoic2l0ZV9zdGF0ZSI7czozOiJ5ZXMiO3M6MTU6InNpdGVfY2xvc2VfdGV4dCI7czoxOToi57u05oqk5Lit4oCm4oCmXl9eISI7czo3OiJzaXRlX2lwIjtzOjIyOiIxMC4xMC4xMC4qDQoxMjcuMC4wLjEwIjtzOjEzOiJzaXRlX2JhZHdvcmRzIjtzOjY4OiLkuK3lm7095aSp5pydDQpTQj3mlofmmI7nlKjor60NCjJCPeaWh+aYjueUqOivrQ0K5pONPeeIsQ0K6I2JPeWTiOWTiCI7czoxMzoic2l0ZV9sYW5ndWFnZSI7czo3OiJjaGluZXNlIjtzOjEzOiJzaXRlX3RlbXBsYXRlIjtzOjc6ImRlZmF1bHQiO3M6MTE6Im9ubGluZV90aW1lIjtpOjMwO3M6MTM6InJld3JpdGVfc3RhdGUiO3M6Mjoibm8iO3M6MTQ6ImZlZWRiYWNrX3N0YXRlIjtzOjI6Im5vIjtzOjEzOiJmZWVkYmFja19zaXplIjtzOjE6IjUiO3M6MTM6ImNvbW1lbnRfc3RhdGUiO3M6Mjoibm8iO3M6MTI6Im1lbWJlcl9zdGF0ZSI7czozOiJ5ZXMiO3M6MjM6Im1lbWJlcl92YWxpZGF0aW9uX3N0YXRlIjtzOjI6Im5vIjtzOjE4OiJpbmRleF9jb21tZW50X3NpemUiO2k6MTA7czoyNjoiaW5kZXhfY29tbWVudF9jb250ZW50X3NpemUiO2k6MTg7czoxNjoiY29udGVudF9ob3Rfc2l6ZSI7aToxMDtzOjIyOiJjb250ZW50X2hvdF90aXRsZV9zaXplIjtpOjE1O3M6MTc6ImNvbnRlbnRfYmVzdF9zaXplIjtpOjEwO3M6MjM6ImNvbnRlbnRfYmVzdF90aXRsZV9zaXplIjtpOjE1O3M6MTI6ImNvbW1lbnRfc2l6ZSI7aToxNTtzOjExOiJzZWFyY2hfc2l6ZSI7aToxNTtzOjExOiJzbXRwX3NlcnZlciI7czowOiIiO3M6OToic210cF9wb3J0IjtzOjI6IjI1IjtzOjk6InNtdHBfdXNlciI7czowOiIiO3M6MTM6InNtdHBfcGFzc3dvcmQiO3M6MDoiIjtzOjE2OiJpbWFnZV90aHVtYl9vcGVuIjtzOjI6Im5vIjtzOjE3OiJpbWFnZV90aHVtYl93aWR0aCI7aToxMDA7czoxODoiaW1hZ2VfdGh1bWJfaGVpZ2h0IjtpOjEwMDtzOjE1OiJpbWFnZV90ZXh0X29wZW4iO3M6Mjoibm8iO3M6OToiaW1hZ2VfcG9zIjtpOjE7fQ==');";252 253 254 if(!empty($_POST['DATA'])&&$_POST['DATA']=='yes'){255 $sql[]="INSERT INTO `".$form_db_prefix."link` (`link_name`, `link_logo`, `link_text`, `link_url`, `link_sort`, `link_state`) VALUES ( '官方网站', '', '', 'http://weedcms.net', '1', '1');";256 $sql[]="INSERT INTO `".$form_db_prefix."link` (`link_name`, `link_logo`, `link_text`, `link_url`, `link_sort`, `link_state`) VALUES ( '站长下载', '', '', 'http://down.chinaz.com/', '1', '1');";257 $sql[]="INSERT INTO `".$form_db_prefix."link` (`link_name`, `link_logo`, `link_text`, `link_url`, `link_sort`, `link_state`) VALUES ( '源码之家', '', '', 'http://www.mycodes.net/', '1', '1');";258 $sql[]="INSERT INTO `".$form_db_prefix."link` (`link_name`, `link_logo`, `link_text`, `link_url`, `link_sort`, `link_state`) VALUES ( '野草在线', '', '', 'http://www.yecao.me', '1', '1');";259 $sql[]="INSERT INTO `".$form_db_prefix."content_channel` (`channel_name`, `channel_description`, `channel_banner`, `channel_index`, `channel_index_truncate`, `channel_index_size`,`channel_index_style`, `channel_list_truncate`, `channel_list_size`, `channel_list_style`, `channel_content_style`, `channel_content_count`, `channel_sort`, `channel_read_permissions`, `channel_write_permissions`, `channel_comment_permissions`, `channel_upload_ext`, `channel_cache`, `channel_state`) VALUES('第一频道', '第一频道', '', 1, 20, 10,1, 10, 10, 1, 1, 0, 0, -1, -2, -1, 'jpg,png,gif,bmp,zip,rar,tar,7z,torrent,mp3,wma,swf,doc,docx,xls,xlsx,ppt,pptx,mdb,mdbx', 1, 1)";260 $sql[]="INSERT INTO `".$form_db_prefix."content_channel` (`channel_name`, `channel_description`, `channel_banner`, `channel_index`, `channel_index_truncate`, `channel_index_size`,`channel_index_style`, `channel_list_truncate`, `channel_list_size`, `channel_list_style`, `channel_content_style`, `channel_content_count`, `channel_sort`, `channel_read_permissions`, `channel_write_permissions`, `channel_comment_permissions`, `channel_upload_ext`, `channel_cache`, `channel_state`) VALUES('第二频道', '第二频道', '', 1, 10, 6,2, 10, 12, 2, 2, 0, 0, -1, -2, 0, 'jpg,png,gif,bmp,zip,rar,tar,7z,torrent,mp3,wma,swf,doc,docx,xls,xlsx,ppt,pptx,mdb,mdbx', 1, 1)";261 $sql[]="INSERT INTO `".$form_db_prefix."content_channel` (`channel_name`, `channel_description`, `channel_banner`, `channel_index`, `channel_index_truncate`, `channel_index_size`,`channel_index_style`, `channel_list_truncate`, `channel_list_size`, `channel_list_style`, `channel_content_style`, `channel_content_count`, `channel_sort`, `channel_read_permissions`, `channel_write_permissions`, `channel_comment_permissions`, `channel_upload_ext`, `channel_cache`, `channel_state`) VALUES('第三频道', '第频道三', '', 1, 12, 3,3, 50, 10, 3, 1, 0, 0, -1, -2, 0, 'jpg,png,gif,bmp,zip,rar,tar,7z,torrent,mp3,wma,swf,doc,docx,xls,xlsx,ppt,pptx,mdb,mdbx', 1, 1)";262 $sql[]="INSERT INTO `".$form_db_prefix."content_channel` (`channel_name`, `channel_description`, `channel_banner`, `channel_index`, `channel_index_truncate`, `channel_index_size`,`channel_index_style`, `channel_list_truncate`, `channel_list_size`, `channel_list_style`, `channel_content_style`, `channel_content_count`, `channel_sort`, `channel_read_permissions`, `channel_write_permissions`, `channel_comment_permissions`, `channel_upload_ext`, `channel_cache`, `channel_state`) VALUES('第四频道', '第四频道', '', 1, 15, 10,1, 60, 10, 4, 4, 0, 0, -1, -1, 0, 'jpg,png,gif,bmp,zip,rar,tar,7z,torrent,mp3,wma,swf,doc,docx,xls,xlsx,ppt,pptx,mdb,mdbx', 1, 1);";263 264 $sql[]="INSERT INTO `".$form_db_prefix."menu`(`menu_name`,`menu_link`,`menu_target`,`menu_mode`,`menu_sort`,`menu_state`,`parent_id`) VALUES('首页','./',0,0,1,1,0);";265 $sql[]="INSERT INTO `".$form_db_prefix."menu`(`menu_name`,`menu_link`,`menu_target`,`menu_mode`,`menu_sort`,`menu_state`,`parent_id`) VALUES('第一频道','channel.php?id=1',0,0,1,1,0);";266 $sql[]="INSERT INTO `".$form_db_prefix."menu`(`menu_name`,`menu_link`,`menu_target`,`menu_mode`,`menu_sort`,`menu_state`,`parent_id`) VALUES('第二频道','channel.php?id=2',0,0,1,1,0);";267 $sql[]="INSERT INTO `".$form_db_prefix."menu`(`menu_name`,`menu_link`,`menu_target`,`menu_mode`,`menu_sort`,`menu_state`,`parent_id`) VALUES('第三频道','channel.php?id=3',0,0,1,1,0);";268 $sql[]="INSERT INTO `".$form_db_prefix."menu`(`menu_name`,`menu_link`,`menu_target`,`menu_mode`,`menu_sort`,`menu_state`,`parent_id`) VALUES('第四频道','channel.php?id=4',0,0,1,1,0);";269 $sql[]="INSERT INTO `".$form_db_prefix."menu`(`menu_name`,`menu_link`,`menu_target`,`menu_mode`,`menu_sort`,`menu_state`,`parent_id`) VALUES('关于我们','#',0,1,1,1,0);";270 $sql[]="INSERT INTO `".$form_db_prefix."menu`(`menu_name`,`menu_link`,`menu_target`,`menu_mode`,`menu_sort`,`menu_state`,`parent_id`) VALUES('联系我们','#',0,1,1,1,0);";271 $sql[]="INSERT INTO `".$form_db_prefix."menu`(`menu_name`,`menu_link`,`menu_target`,`menu_mode`,`menu_sort`,`menu_state`,`parent_id`) VALUES('访客留言','feedback.php',0,1,1,1,0);";272 $sql[]="INSERT INTO `".$form_db_prefix."menu`(`menu_name`,`menu_link`,`menu_target`,`menu_mode`,`menu_sort`,`menu_state`,`parent_id`) VALUES('第一分类','#',0,0,1,1,2);";273 $sql[]="INSERT INTO `".$form_db_prefix."menu`(`menu_name`,`menu_link`,`menu_target`,`menu_mode`,`menu_sort`,`menu_state`,`parent_id`) VALUES('第二分类','#',0,0,1,1,2);";274 $sql[]="INSERT INTO `".$form_db_prefix."menu`(`menu_name`,`menu_link`,`menu_target`,`menu_mode`,`menu_sort`,`menu_state`,`parent_id`) VALUES('第三分类','#',0,0,1,1,2);";275 276 $sql[]="INSERT INTO `".$form_db_prefix."vote` (`vote_title`, `vote_start`, `vote_end`, `vote_mode`, `vote_place`, `vote_state`) VALUES('您正在使用什么浏览器？', 1293724800,1327075200, 1, 0, 1);";277 $sql[]="INSERT INTO `".$form_db_prefix."vote_item` ( `item_title`, `item_count`, `vote_id`) VALUES('IE浏览器', 0,1)";278 $sql[]="INSERT INTO `".$form_db_prefix."vote_item` ( `item_title`, `item_count`, `vote_id`) VALUES('谷歌浏览器', 0,1)";279 $sql[]="INSERT INTO `".$form_db_prefix."vote_item` ( `item_title`, `item_count`, `vote_id`) VALUES('火狐浏览器', 0,1)";280 $sql[]="INSERT INTO `".$form_db_prefix."vote_item` ( `item_title`, `item_count`, `vote_id`) VALUES('Opera浏览器', 0,1)";281 $sql[]="INSERT INTO `".$form_db_prefix."vote_item` ( `item_title`, `item_count`, `vote_id`) VALUES('Safari浏览器', 0,1)";282 }283 284 foreach($sql as $v){285 @mysql_query($v,$connect);286 }287 $CONFIG="<?php\n";288 $CONFIG.="\$db_host='".$form_db_host."';\n";289 $CONFIG.="\$db_user='".$form_db_user."';\n";290 $CONFIG.="\$db_password='".$form_db_password."';\n";291 $CONFIG.="\$db_name='".$form_db_name."';\n";292 $CONFIG.="\$db_prefix='".$form_db_prefix."';\n";293 $CONFIG.="?>\n";294 @chmod('includes',0777);295 @chmod('includes/config.php',0777); //为了后面能够向config.php中写入数据296 @chmod('uploads',0777);297 @chmod('temps',0777);298 @chmod('temps/cache',0777);299 @chmod('temps/compile',0777);300 @chmod('install.php',0777); //为了后面能将其改为.lock301 file_put_contents('includes/config.php',$CONFIG) or die("Please check the includes/config.php permissions!");302 @rename("install.php","install.lock"); //SDF:重命名303 //@unlink("install.php"); //SDF:删除文件304 echo("<script>location.href='./admin.php'</script>");//安装完毕，链接到网站后台305 exit();306 }307 ?>308 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">309 <html xmlns="http://www.w3.org/1999/xhtml">310 <head>311 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />312 <title>安装程序</title>313 <style type="text/css">314 html,body{MARGIN:0;padding:0;font:normal 14px 'Microsoft Yahei','Arial';color:#333}315 .input{padding:5px;border:1px solid #ccc;font-family:arial;font-size:1.4em}316 .blank{padding:3px}317 </style>318 </head>319 <body>320 <div style="padding:15px;background:#333;color:#fff;">321 <div style="margin:auto;width:600px">322 <span style="font-size:2em;font-weight:bold;color:#eee;"><?php323 if(PHP_OS=='WINNT'){ //PHP_OS:PHP所在系统环境324 echo('Windows');325 }else{326 echo(PHP_OS);327 }?></span><br />328 PHP <?=@PHP_VERSION?>/<?=@$_SERVER['SERVER_SOFTWARE']?>329 </div></div>330 <form method="post" style="margin:15px auto;width:600px;">331 (数据库主机：一般数据库和网站在同一个服务器上默认即可)<div class="blank"></div>332 <input type="text" name="DB_HOST" size="30" class="input" value="localhost" /><div class="blank"></div>333 (数据库用户)<div class="blank"></div>334 <input type="text" name="DB_USER" size="30"class="input" value="root" /><div class="blank"></div>335 (数据库密码)<div class="blank"></div>336 <input type="text" name="DB_PASSWORD" size="30"class="input"value="123456"/><div class="blank"></div>337 (数据库名称：如果您有建立数据库权限则自动生成数据库否则需要和空间商联系帐号信息)<div class="blank"></div>338 <input type="text" name="DB_NAME" size="30"class="input" value="test" /><div class="blank"></div>339 (数据表前缀：必须是以字母开头的字符串)<div class="blank"></div>340 <input type="text" name="DB_PREFIX" size="30"class="input" value="x_"/><div class="blank"></div>341 <label><input type="checkbox" name="DATA" value="yes" checked/> 插入测试数据</label><br /><br />342 <divstyle="font:normal 14px 'Microsoft Yahei','Arial';width:100px;height:28px;line-height:28px;text-align:center;background:#333;color:#fff;cursor:pointer">开始安装</div>343 </form>344 </body>345 </html>
页:
[1]