PHP某分类信息网站系统4.0i单城市版去域名限制测试可用

DROP TABLE IF EXISTS `my_about`; CREATE TABLE IF NOT EXISTS `my_about` ( `id` int(5) NOT NULL auto_increment, `typename` char(25) NOT NULL, `content` mediumtext NOT NULL, `displayorder` smallint(3) NOT NULL, `pubdate` int(10) NOT NULL, `dir_type` tinyint(1) NOT NULL, `dir_typename` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `my_about` (`id`, `typename`, `content`, `displayorder`, `pubdate`, `dir_type`, `dir_typename`) VALUES (1, '网站简介', '在这里填写网站简介，填写完成后保存提交即可', 1, 0, 2, 'wangzhanjianjie'), (2, '广告服务', '在这里填写广告服务，填写完成后保存提交即可', 2, 1263483208, 4, 'advertisement'), (3, '联系我们', '在这里填写联系方式，填写完成后保存提交即可', 3, 1259399384, 4, 'contactus'); DROP TABLE IF EXISTS `my_admin`; CREATE TABLE IF NOT EXISTS `my_admin` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` char(30) NOT NULL default '', `pwd` char(32) NOT NULL default '', `uname` char(20) NOT NULL default '', `tname` char(30) NOT NULL default '', `email` char(30) NOT NULL default '', `typeid` smallint(5) unsigned NOT NULL default '0', `logintime` int(10) unsigned NOT NULL default '0', `loginip` varchar(20) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `my_admin_record_action`; CREATE TABLE IF NOT EXISTS `my_admin_record_action` ( `id` int(11) NOT NULL auto_increment, `adminid` char(30) NOT NULL, `pubdate` int(10) NOT NULL, `ip` varchar(20) NOT NULL, `action` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `my_admin_record_login`; CREATE TABLE IF NOT EXISTS `my_admin_record_login` ( `id` int(11) unsigned NOT NULL auto_increment, `adminid` char(32) NOT NULL, `adminpwd` char(30) NOT NULL, `pubdate` int(10) NOT NULL, `ip` varchar(20) NOT NULL, `result` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `my_admin_type`; CREATE TABLE IF NOT EXISTS `my_admin_type` ( `id` smallint(5) NOT NULL auto_increment, `typename` varchar(30) NOT NULL, `ifsystem` tinyint(1) NOT NULL, `purviews` mediumtext NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `my_admin_type` (`id`, `typename`, `ifsystem`, `purviews`) VALUES (1, '超级管理员', 1, 'purview_焦点图列表,purview_上传焦点图,purview_栏目设置,purview_已发布公告,purview_发布公告,purview_问题帮助,purview_发布帮助主题,purview_友情链接,purview_增加链接,purview_链接导航,purview_生活百宝箱,purview_便民电话,purview_分类信息,purview_删除重复,purview_批量管理,purview_信息评论,purview_信息举报,purview_模型管理,purview_选项管理,purview_个人会员,purview_商家会员,purview_增加会员,purview_会员组类型,purview_实名认证,purview_会员文档,purview_站内短消息,purview_空间管理,purview_会员登录记录,purview_会员消费记录,purview_信息分类,purview_添加分类,purview_地区分类,purview_增加地区,purview_商家分类,purview_增加分类,purview_用户列表,purview_用户组,purview_管理记录,purview_数据库备份,purview_数据库还原,purview_数据库维护,purview_系统配置,purview_模板管理,purview_SEO优化设置,purview_验证过滤点评,purview_积分信用等级,purview_缓存设置,purview_文字内链设置,purview_附件管理,purview_手机访问设置,purview_已安装插件,purview_优惠券分类,purview_已上传优惠券,purview_团购分类,purview_已发起团购,purview_报名管理,purview_新闻管理,purview_新闻类别,purview_新闻评论,purview_商品分类,purview_商品管理,purview_订单管理,purview_一键更新网站,purview_生成网站HTML,purview_邮件服务器,purview_邮件模板,purview_邮件发送记录,purview_管理支付接口,purview_管理支付记录,purview_管理广告位,purview_信息JS调用,purview_整合接口设置'); DROP TABLE IF EXISTS `my_advertisement`; CREATE TABLE IF NOT EXISTS `my_advertisement` ( `advid` mediumint(8) unsigned NOT NULL auto_increment, `available` tinyint(1) NOT NULL default '0', `type` varchar(50) NOT NULL default '0', `displayorder` tinyint(3) NOT NULL default '0', `title` varchar(50) NOT NULL default '', `targets` mediumtext NOT NULL, `parameters` mediumtext NOT NULL, `code` mediumtext NOT NULL, `starttime` int(10) unsigned NOT NULL default '0', `endtime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`advid`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `my_announce`; CREATE TABLE IF NOT EXISTS `my_announce` ( `id` int(10) NOT NULL auto_increment, `title` varchar(100) NOT NULL, `redirecturl` varchar(250) NOT NULL, `titlecolor` char(10) NOT NULL, `content` mediumtext NOT NULL, `author` varchar(20) NOT NULL, `pubdate` int(10) NOT NULL, `begintime` int(10) NOT NULL, `endtime` int(10) NOT NULL, `hits` int(11) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `my_area`; CREATE TABLE IF NOT EXISTS `my_area` ( `areaid` mediumint(6) NOT NULL auto_increment, `areaname` varchar(32) NOT NULL, `parentid` int(11) unsigned NOT NULL, `areaorder` smallint(6) NOT NULL, PRIMARY KEY (`areaid`) ) TYPE=MyISAM; INSERT INTO `my_area` VALUES (1, '地区1', 0, 1); DROP TABLE IF EXISTS `my_badwords`; CREATE TABLE IF NOT EXISTS `my_badwords` ( `words` mediumtext NOT NULL, `view` varchar(100) NOT NULL, `ifcheck` tinyint(1) NOT NULL )TYPE=MyISAM; INSERT INTO `my_badwords` (`words`, `view`, `ifcheck`) VALUES ('激情交友', '**', 1); DROP TABLE IF EXISTS `my_cache`; CREATE TABLE IF NOT EXISTS `my_cache` ( `id` smallint(3) NOT NULL auto_increment, `page` varchar(20) NOT NULL, `time` int(10) NOT NULL, `open` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `my_cache` (`id`, `page`, `time`, `open`) VALUES (237, 'site', 10800, 0), (238, 'info', 10800, 0), (239, 'list', 10800, 0), (240, 'aboutus', 10800, 0), (241, 'announce', 10800, 0), (242, 'faq', 10800, 0), (243, 'friendlink', 10800, 0), (244, 'guestbook', 10800, 0); DROP TABLE IF EXISTS `my_category`; CREATE TABLE IF NOT EXISTS `my_category` ( `catid` mediumint(6) NOT NULL auto_increment, `if_view` tinyint(1) NOT NULL default '1', `color` char(10) NOT NULL, `catname` varchar(32) NOT NULL, `title` varchar(250) NOT NULL, `keywords` varchar(255) default NULL, `description` varchar(255) default NULL, `parentid` int(11) default NULL, `modid` smallint(5) NOT NULL, `catorder` smallint(6) NOT NULL, `if_upimg` tinyint(1) NOT NULL default '1', `if_mappoint` tinyint(1) NOT NULL default '0', `dir_type` tinyint(1) NOT NULL, `dir_typename` varchar(100) NOT NULL, `template` varchar(20) NOT NULL default 'list', `template_info` varchar(20) NOT NULL default 'info', `html_dir` varchar(200) NOT NULL, `htmlpath` varchar(200) NOT NULL, PRIMARY KEY (`catid`), KEY `parentid` (`parentid`), KEY `catname` (`catname`), KEY `catorder` (`catorder`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `my_certification`; CREATE TABLE IF NOT EXISTS `my_certification` ( `id` int(11) unsigned NOT NULL auto_increment, `typeid` tinyint(1) NOT NULL, `userid` varchar(30) NOT NULL, `img_path` varchar(250) NOT NULL, `pubtime` int(10) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `my_channel`; CREATE TABLE IF NOT EXISTS `my_channel` ( `catid` mediumint(6) NOT NULL auto_increment, `if_view` tinyint(1) NOT NULL default '1', `color` char(10) NOT NULL, `catname` varchar(32) NOT NULL, `title` varchar(250) NOT NULL, `keywords` varchar(255) default NULL, `description` varchar(255) default NULL, `parentid` int(11) default NULL, `catorder` smallint(6) NOT NULL, `dir_type` tinyint(1) NOT NULL, `dir_typename` varchar(100) NOT NULL, `html_dir` varchar(200) NOT NULL, `htmlpath` varchar(200) NOT NULL, PRIMARY KEY (`catid`), KEY `parentid` (`parentid`), KEY `catname` (`catname`), KEY `catorder` (`catorder`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `my_checkanswer`; CREATE TABLE IF NOT EXISTS `my_checkanswer` ( `id` smallint(3) NOT NULL auto_increment, `questio