PHP实例开发源码-php高仿赶集网58同城源码.zip

-- phpMyAdmin SQL Dump -- version 4.0.4 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2013 年 08 月 19 日 02:24 -- 服务器版本: 5.6.12-log -- PHP 版本: 5.4.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- 数据库: `ganji` -- /* CREATE DATABASE IF NOT EXISTS `ganji` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `ganji`; */ -- -------------------------------------------------------- -- -- 表的结构 `qb_admin_menu` -- CREATE TABLE IF NOT EXISTS `qb_admin_menu` ( `id` mediumint(5) NOT NULL AUTO_INCREMENT, `fid` mediumint(5) NOT NULL DEFAULT '0', `name` text NOT NULL, `linkurl` varchar(150) NOT NULL DEFAULT '', `color` varchar(15) NOT NULL DEFAULT '', `target` tinyint(1) NOT NULL DEFAULT '0', `list` smallint(4) NOT NULL DEFAULT '0', `groupid` mediumint(5) NOT NULL DEFAULT '0', `iftier` tinyint(1) NOT NULL DEFAULT '0', `ifcompany` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `groupid` (`groupid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=187 ; -- -- 转存表中的数据 `qb_admin_menu` -- INSERT INTO `qb_admin_menu` (`id`, `fid`, `name`, `linkurl`, `color`, `target`, `list`, `groupid`, `iftier`, `ifcompany`) VALUES (87, 0, '重要功能', '', '', 0, 7, 3, 0, 0), (90, 87, '首页分类布局设置', 'index.php?lfj=module_admin&dirname=f&file=center&job=settable', '', 0, 0, 3, 0, 0), (144, 0, '参数设置', '', '', 0, 8, 3, 0, 0), (145, 144, '全局参数设置', 'index.php?lfj=center&job=config', '', 0, 0, 3, 0, 0), (146, 144, '分类相关参数', 'index.php?lfj=module_admin&dirname=f&file=center&job=post', '', 0, 0, 3, 0, 0), (147, 87, '更新首页标签', 'index.php?lfj=module_admin&dirname=f&file=center&job=label', '', 0, 10, 3, 0, 0), (148, 87, '分类信息管理', 'index.php?lfj=module_admin&dirname=f&file=list&job=list', '', 0, 0, 3, 0, 0), (149, 87, '评论管理', 'index.php?lfj=module_admin&dirname=f&file=comment&job=list', '', 0, 0, 3, 0, 0), (150, 87, '分类栏目管理', 'index.php?lfj=module_admin&dirname=f&file=sort&job=listsort', '', 0, 0, 3, 0, 0), (151, 87, '城市地区管理', 'index.php?lfj=module_admin&dirname=f&file=city&job=city', '', 0, 0, 3, 0, 0), (152, 87, '友情链接管理', 'index.php?lfj=module_admin&dirname=f&file=friendlink&job=list', '', 0, 0, 3, 0, 0), (154, 0, '店铺服务', '', '', 0, 0, -8, 0, 0), (155, 154, '首页', 'hy/member/homepage_ctrl.php?atn=info', '', 0, 0, -8, 0, 0), (156, 0, '基本功能', '', '', 0, 4, -8, 0, 0), (157, 156, '修改个人资料', 'userinfo.php?job=edit', '', 0, 6, -8, 0, 0), (158, 156, '站内短消息', 'pm.php?job=list', '', 0, 5, -8, 0, 0), (159, 156, '积分充值', 'money.php?job=list', '', 0, 4, -8, 0, 0), (160, 156, '购买会员等级', 'buygroup.php?job=list', '', 0, 3, -8, 0, 0), (161, 156, '身份验证', 'yz.php?job=email', '', 0, 2, -8, 0, 0), (162, 156, '积分消费记录', 'moneylog.php?job=list', '', 0, 1, -8, 0, 0), (163, 156, '购买空间', 'buyspace.php', '', 0, 0, -8, 0, 0), (164, 0, '插件功能', '', '', 0, 3, -8, 0, 0), (165, 164, '推广赚积分', 'hack.php?hack=propagandize&job=list', '', 0, 0, -8, 0, 0), (166, 0, '分类信息', '', '', 0, 2, -8, 0, 0), (167, 166, '发布分类信息', '/f/member/http://localhost/ganji/post.php', '', 0, 4, -8, 0, 0), (168, 166, '分类信息管理', '/f/member/list.php', '', 0, 3, -8, 0, 0), (169, 166, '收藏夹', '/f/member/collection.php', '', 0, 2, -8, 0, 0), (170, 166, '管理他人评论', '/f/member/comment.php?job=list', '', 0, 1, -8, 0, 0), (171, 166, '我发布的评论', '/f/member/comment.php?job=mylist', '', 0, 0, -8, 0, 0), (172, 0, '广告系统', '', '', 0, 1, -8, 0, 0), (173, 172, '购买普通广告', '/a_d/member/norm.php?job=list', '', 0, 1, -8, 0, 0), (174, 172, '购买竞价广告', '/a_d/member/compete.php?job=list', '', 0, 0, -8, 0, 0), (175, 0, '黄页商铺', '', '', 0, 0, -8, 0, 0), (176, 175, '登记店铺', '/hy/member/post_company.php', '', 0, 10, -8, 0, 0), (177, 175, '公司资料', '/hy/member/homepage_ctrl.php?atn=info', '', 0, 9, -8, 0, 0), (178, 175, '公司介绍', '/hy/member/homepage_ctrl.php?atn=info2', '', 0, 8, -8, 0, 0), (179, 175, '联系方式', '/hy/member/homepage_ctrl.php?atn=contactus', '', 0, 7, -8, 0, 0), (180, 175, '模板设置', '/hy/member/homepage_ctrl.php?atn=base', '', 0, 6, -8, 0, 0), (181, 175, '横幅设置', '/hy/member/homepage_ctrl.php?atn=banner', '', 0, 5, -8, 0, 0), (182, 175, '公司图库', '/hy/member/homepage_ctrl.php?atn=pic', '', 0, 4, -8, 0, 0), (183, 175, '新闻管理', '/hy/member/homepage_ctrl.php?atn=news', '', 0, 3, -8, 0, 0), (184, 175, '发布新闻', '/hy/member/homepage_ctrl.php?atn=postnews', '', 0, 2, -8, 0, 0), (185, 175, '友情链接管理', '/hy/member/cankao.php', '', 0, 1, -8, 0, 0), (186, 175, '企业认证', '/hy/member/renzheng.php', '', 0, 0, -8, 0, 0); -- -------------------------------------------------------- -- -- 表的结构 `qb_ad_compete_place` -- CREATE TABLE IF NOT EXISTS `qb_ad_compete_place` ( `id` mediumint(7) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `isclose` tinyint(1) NOT NULL DEFAULT '0', `list` int(10) NOT NULL DEFAULT '0', `price` mediumint(5) NOT NULL DEFAULT '0', `day` mediumint(4) NOT NULL DEFAULT '0', `adnum` smallint(3) NOT NULL DEFAULT '0', `wordnum` smallint(3) NOT NULL DEFAULT '0', `autoyz` tinyint(1) NOT NULL DEFAULT '1', `demourl` varchar(150) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=4 ; -- -- 转存表中的数据 `qb_ad_compete_place` -- INSERT INTO `qb_ad_compete_place` (`id`, `name`, `isclose`, `list`, `price`, `day`, `adnum`, `wordnum`, `autoyz`, `demourl`) VALUES (3, '顶客页竞价广告', 0, 0, 50, 5, 8, 36, 1, '/do/digg.php'); -- -------------------------------------------------------- -- -- 表的结构 `qb_ad_compete_user` -- CREATE TABLE IF NOT EXISTS `qb_ad_compete_user` ( `ad_id` mediumint(7) NOT NULL AUTO_INCREMENT, `uid` mediumint(7) NOT NULL DEFAULT '0', `username` varchar(30) NOT NULL DEFAULT '', `begintime` int(10) NOT NULL DEFAULT '0', `endtime` int(10) NOT NULL DEFAULT '0', `money` mediumint(6) NOT NULL DEFAULT '0', `id` mediumint(7) NOT NULL DEFAULT '0', `yz` tinyint(1) NOT NULL DEFAULT '1', `adlink` varchar(200) NOT NULL DEFAULT '', `adword` varchar(255) NOT NULL DEFAULT '', `hits` mediumint(7) NOT NULL DEFAULT '0', `color` varchar(20) NOT NULL DEFAULT '', `fonttype` tinyint(1) NOT NULL DEFAULT '0', `city_id` mediumint(7) NOT NULL DEFAULT '0', PRIMARY KEY (`ad_id`), KEY `id` (`id`,`endtime`,`money`,`yz`,`city_id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=13 ; -- -- 转存表中的数据 `qb_ad_compete_user` -- INSERT INTO `qb_ad_compete_user` (`ad_id`, `uid`, `username`, `begintime`, `endtime`, `money`, `id`, `yz`, `adlink`, `adword`, `hits`, `color`, `fonttype`, `city_id`) VALUES (11, 1, 'admin', 1239277578, 1239709578, 50, 3, 1, 'http://www.php168.com/', 'P8官方站', 0, '', 0, 0), (12, 1, 'admin', 1239279810, 1239711810, 50, 3, 1, 'http://www.php168.com/bbs', 'P8官方论坛', 0, '', 0, 0); -- -------------------------------------------------------- -- -- 表的结构 `qb_ad_config` -- CREATE TABLE IF NOT EXISTS `qb_ad_config` ( `c_key` varchar(50) NOT NULL DEFAULT '', `c_value` text NOT NULL, `c_descrip` text NOT NULL, PRIMARY KEY (`c_key`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; -- -- 转存表中的数据 `qb_ad_config` -- INSERT INTO `qb_ad_config` (`c_key`, `c_value`, `c_descrip`) VALUES ('module_pre', 'ad_', ''), ('Info_webOpen', '1', ''), ('module_id', '24', ''), ('module_close', '0', ''), ('Info_webname', '广告系统', ''); -- -------------------