[CMS程序]帝国网站管理系统(Ecms) v3.7繁体中文免费版_bigecms37.rar

<? //如果存在表的話，將刪除表 $del_table=mysql_query("DROP TABLE IF EXISTS $db_name.phome_ecms_article,$db_name.phome_ecms_download,$db_name.phome_ecms_flash,$db_name.phome_ecms_infoclass_article,$db_name.phome_ecms_infoclass_download,$db_name.phome_ecms_infoclass_flash,$db_name.phome_ecms_infoclass_movie,$db_name.phome_ecms_infoclass_news,$db_name.phome_ecms_infoclass_photo,$db_name.phome_ecms_infoclass_shop,$db_name.phome_ecms_infotmp_article,$db_name.phome_ecms_infotmp_download,$db_name.phome_ecms_infotmp_flash,$db_name.phome_ecms_infotmp_movie,$db_name.phome_ecms_infotmp_news,$db_name.phome_ecms_infotmp_photo,$db_name.phome_ecms_infotmp_shop,$db_name.phome_ecms_movie,$db_name.phome_ecms_news,$db_name.phome_ecms_photo,$db_name.phome_ecms_shop,$db_name.phome_enewsad,$db_name.phome_enewsadclass,$db_name.phome_enewsadminstyle,$db_name.phome_enewsbefrom,$db_name.phome_enewsbq,$db_name.phome_enewsbqclass,$db_name.phome_enewsbqtemp,$db_name.phome_enewsbqtempclass,$db_name.phome_enewsbuybak,$db_name.phome_enewscard,$db_name.phome_enewschecktext,$db_name.phome_enewsclass,$db_name.phome_enewsdo,$db_name.phome_enewsdolog,$db_name.phome_enewsdownrecord,$db_name.phome_enewsdownurlqz,$db_name.phome_enewsf,$db_name.phome_enewsfava,$db_name.phome_enewsfavaclass,$db_name.phome_enewsfeedback,$db_name.phome_enewsfeedbackclass,$db_name.phome_enewsfile,$db_name.phome_enewsgbook,$db_name.phome_enewsgbookclass,$db_name.phome_enewsgfenip,$db_name.phome_enewsgroup,$db_name.phome_enewsinfoclass,$db_name.phome_enewsjstemp,$db_name.phome_enewsjstempclass,$db_name.phome_enewskey,$db_name.phome_enewslink,$db_name.phome_enewslinktmp,$db_name.phome_enewslisttemp,$db_name.phome_enewslisttempclass,$db_name.phome_enewslog,$db_name.phome_enewsmember,$db_name.phome_enewsmemberadd,$db_name.phome_enewsmembergroup,$db_name.phome_enewsmod,$db_name.phome_enewsnewstemp,$db_name.phome_enewsnewstempclass,$db_name.phome_enewspic,$db_name.phome_enewspicclass,$db_name.phome_enewspl,$db_name.phome_enewsplwords,$db_name.phome_enewspostdata,$db_name.phome_enewspublic,$db_name.phome_enewssearch,$db_name.phome_enewssearchtemp,$db_name.phome_enewssearchtempclass,$db_name.phome_enewsshopdd,$db_name.phome_enewsshoppayfs,$db_name.phome_enewsshopps,$db_name.phome_enewstable,$db_name.phome_enewstempvar,$db_name.phome_enewstempvarclass,$db_name.phome_enewsuser,$db_name.phome_enewsvote,$db_name.phome_enewswords,$db_name.phome_enewswriter,$db_name.phome_enewszt,$db_name.phome_enewsztclass,$db_name.phome_enewsdownerror,$db_name.phome_enewsnotcj,$db_name.phome_enewspage,$db_name.phome_enewspageclass;"); echo"正在建立數据表．．．．．．<br>"; //數据表 $photo=mysql_query("create table `phome_ecms_photo`( `id` int(11) NOT NULL auto_increment, `classid` smallint(6) NOT NULL, `onclick` int(11) NOT NULL, `newspath` varchar(50) NOT NULL, `keyboard` varchar(255) NOT NULL, `keyid` varchar(255) NOT NULL, `userid` int(11) NOT NULL, `username` varchar(30) NOT NULL, `ztid` text NOT NULL, `checked` tinyint(1) NOT NULL, `istop` tinyint(4) NOT NULL, `truetime` int(11) NOT NULL, `ismember` tinyint(1) NOT NULL, `dokey` tinyint(1) NOT NULL, `userfen` int(11) NOT NULL, `isgood` tinyint(1) NOT NULL, `titlecolor` varchar(10) NOT NULL, `titlefont` varchar(255) NOT NULL, `titleurl` varchar(200) NOT NULL, `filename` varchar(60) NOT NULL, `filenameqz` varchar(28) NOT NULL, `fh` tinyint(1) NOT NULL, `groupid` smallint(6) NOT NULL, `newstempid` smallint(6) NOT NULL, `plnum` int(11) NOT NULL, `firsttitle` tinyint(1) NOT NULL, `checkuser` text NOT NULL, `docheckuser` text NOT NULL, `viewcheckuser` text NOT NULL, `returncheck` tinyint(1) NOT NULL, `notdocheckuser` text NOT NULL, `totaldown` int(11) NOT NULL, `title` varchar(200) NOT NULL, `newstime` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, `titlepic` varchar(200) NOT NULL, `wplay` tinyint(1) NOT NULL, `picsay` text NOT NULL, `filesize` varchar(30) NOT NULL, `picsize` varchar(30) NOT NULL, `picfbl` varchar(30) NOT NULL, `picurl` varchar(255) NOT NULL, `morepic` mediumtext NOT NULL, `picfrom` varchar(120) NOT NULL, `num` tinyint(4) NOT NULL, `width` varchar(30) NOT NULL, `height` varchar(30) NOT NULL, `closepl` tinyint(1) NOT NULL, `havehtml` tinyint(1) NOT NULL, PRIMARY KEY (id), KEY classid (classid)) Type=MyISAM COMMENT='';"); //采集臨時表 $phototmp=mysql_query("create table `phome_ecms_infotmp_photo`( `id` bigint(20) NOT NULL auto_increment, `classid` int(11) NOT NULL, `oldurl` varchar(255) NOT NULL, `checked` tinyint(1) NOT NULL, `tmptime` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, `title` varchar(200) NOT NULL, `newstime` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, `username` varchar(30) NOT NULL, `userid` int(11) NOT NULL, `truetime` int(11) NOT NULL, `keyboard` varchar(255) NOT NULL, `titlepic` varchar(255) NOT NULL, `picsay` text NOT NULL, `filesize` varchar(30) NOT NULL, `picsize` varchar(30) NOT NULL, `picfbl` varchar(30) NOT NULL, `picurl` varchar(255) NOT NULL, `morepic` mediumtext NOT NULL, `picfrom` varchar(120) NOT NULL, `num` tinyint(4) NOT NULL, `width` varchar(30) NOT NULL, `height` varchar(30) NOT NULL, PRIMARY KEY (id), KEY classid (classid)) Type=MyISAM COMMENT='';"); //采集節點表 $photoinfo=mysql_query("create table `phome_ecms_infoclass_photo`( `classid` int(11) NOT NULL, `zz_title` text NOT NULL, `z_title` varchar(255) NOT NULL, `qz_title` varchar(255) NOT NULL, `save_title` varchar(10) NOT NULL, `zz_titlepic` text NOT NULL, `z_titlepic` varchar(255) NOT NULL, `qz_titlepic` varchar(255) NOT NULL, `save_titlepic` varchar(10) NOT NULL, `zz_newstime` text NOT NULL, `z_newstime` varchar(255) NOT NULL, `qz_newstime` varchar(255) NOT NULL, `save_newstime` varchar(10) NOT NULL, `zz_picsay` text NOT NULL, `z_picsay` varchar(255) NOT NULL, `qz_picsay` text NOT NULL, `save_picsay` varchar(10) NOT NULL, `zz_filesize` text NOT NULL, `z_filesize` varchar(255) NOT NULL, `qz_filesize` text NOT NULL, `save_filesize` varchar(10) NOT NULL, `zz_picsize` text NOT NULL, `z_picsize` varchar(255) NOT NULL, `qz_picsize` varchar(255) NOT NULL, `save_picsize` varchar(10) NOT NULL, `zz_picfbl` text NOT NULL, `z_picfbl` varchar(255) NOT NULL, `qz_picfbl` varchar(255) NOT NULL, `save_picfbl` varchar(10) NOT NULL, `zz_picurl` text NOT NULL, `z_picurl` varchar(255) NOT NULL, `qz_picurl` text NOT NULL, `save_picurl` varchar(10) NOT NULL, `zz_morepic` text NOT NULL, `z_morepic` varchar(255) NOT NULL, `qz_morepic` varchar(255) NOT NULL, `save_morepic` varchar(10) NOT NULL, `zz_picfrom` text NOT NULL, `z_picfrom` varchar(255) NOT NULL, `qz_picfrom` varchar(255) NOT NULL, `save_picfrom` varchar(10) NOT NULL, `zz_num` text NOT NULL, `z_num` varchar(255) NOT NULL, `qz_num` varchar(255) NOT NULL, `save_num` varchar(10) NOT NULL, `zz_width` text NOT NULL, `z_width` varchar(255) NOT NULL, `qz_width` varchar(255) NOT NULL, `save_width` varchar(10) NOT NULL, `zz_height` text NOT NULL, `z_height` varchar(255) NOT NULL, `qz_height` varchar(255) NOT NULL, `save_height` varchar(10) NOT NULL, KEY classid (classid)) Type=MyISAM COMMENT='';"); //數据表 $download=mysql_query("create table `phome_ecms_download`( `id` int(11) NOT NULL auto_increment, `classid` smallint(6) NOT NULL, `onclick` int(11) NOT NULL, `newspath` varchar(50) NOT NULL, `keyboard` varchar(255) NOT NULL, `keyid` varchar(255) NOT NULL, `userid` int(11) NOT NULL, `username` varchar(30) NOT NULL, `ztid` text NOT NULL, `checked` tinyint(1) NOT NULL, `istop` tinyint(4) NOT NULL, `truetime` int(11) NOT NULL, `ismember` tinyint(1) NOT NULL, `dokey` tinyint(1) NOT NULL, `userfen` int(11) NOT NULL, `isgood` tinyint(1) NOT NULL, `titlecolor` varchar(10) NOT NULL, `titlefont` varchar(255) NOT NULL, `titleurl` varchar(200) NOT NULL, `filename` v