基于PHP的一元云购网站源码(一元夺宝) php版.zip

DROP TABLE IF EXISTS `hx_activity`; CREATE TABLE `hx_activity` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` char(30) NOT NULL DEFAULT '', `title` char(80) NOT NULL DEFAULT '', `picurl` varchar(255) DEFAULT NULL, `remark` char(140) NOT NULL DEFAULT '', `rule` text, `log` text, `type` tinyint(2) unsigned NOT NULL DEFAULT '1', `icon` char(50) NOT NULL DEFAULT '', `status` tinyint(2) NOT NULL DEFAULT '0', `end_time` int(11) unsigned NOT NULL DEFAULT '0', `display` tinyint(3) unsigned NOT NULL DEFAULT '1', `web_index_tpl` char(50) NOT NULL DEFAULT '', `wap_index_tpl` char(50) NOT NULL DEFAULT '', `web_list_tpl` char(50) NOT NULL DEFAULT '', `wap_list_tpl` char(50) NOT NULL DEFAULT '', `web_content_tpl` char(50) NOT NULL DEFAULT '', `wap_content_tpl` char(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; INSERT INTO `hx_activity` VALUES (55,'tz_jl','购买欢乐送','./Picture/Activity/active-04.jpg','一次性每购买100人次送5欢乐币','table:user|field:black|condition:id={$self} and floor({$relf}/100)>=1|rule:black+floor({$relf}/100)*5|cycle:24|max:10','用户[user|get_user_name]投注[record]奖励[record|activity_mod]欢乐币[price=record|activity_mod]',4,'demo-icon icon-basket-1 a3 discount-icon',1,1483113600,1,'activity/activity-more4.html','explain-goumai.html','','','',''),(56,'sd_jl','晒单欢乐送','./Picture/Activity/active-03.jpg','中奖后成功晒单即送1欢乐币','table:user|field:black|condition:id={$self}|rule:black+1|cycle:24|max:10','用户[user|get_user_name]晒单[record]奖励1欢乐币[price=1]',6,'demo-icon icon-camera-1 a2 discount-icon',1,1483113600,1,'activity/activity-more3.html','explain-shared.html','','','',''),(57,'userfx_jl','邀请有礼','./Picture/Activity/active-02.jpg','分享你好友每关注5人即送1欢乐币','','',7,'demo-icon icon-picasa a4 discount-icon',1,1483113600,1,'activity/activity-more2.html','explain-share.html','','','activity/activity-share.html','activity-share.html'),(58,'recharge_jl','充值欢乐送','./Picture/Activity/active-01.jpg','每充值满100 即刻送 5 欢乐币','table:user|field:black|condition:id={$self} and floor({$relf}/100)>=1|rule:black+floor({$relf}/100)*5|cycle:24|max:10','用户[user|get_user_name]充值[record]奖励[record|activity_mod]欢乐币[price=record|activity_mod]',5,'demo-icon icon-money a5 discount-icon',1,1483113600,1,'activity/activity-more1.html','explain-pay.html','','','',''),(59,'turntable_jl','欢乐大转盘','./Picture/Activity/active-05.jpg','转盘奖励','table:user|field:black|condition:id={$self}|rule:black+{$relf}|cycle:16|max:2','用户[user|get_user_name]欢乐大转盘奖励[record]欢乐币[price=record]',9,'demo-icon icon-gift a1 discount-icon',1,1483113600,1,'activity/turntable/index.html','turntable/index.html','','','',''),(60,'share_turntable','大转盘分享增加机会','','大转盘分享增加机会','table:user|field:turntable|condition:id={$self}|rule:turntable+1|cycle:16|max:1','用户[user|get_user_name]分享增加一次欢乐大转盘机会',9,'',1,1483113600,0,'','','','','',''),(61,'login_turntable','登录增加转盘机会','','登录增加转盘机会','table:user|field:turntable|condition:id={$self}|rule:turntable+1|cycle:16|max:1','用户[user|get_user_name]登录增加一次欢乐大转盘机会',2,'',1,1483113600,0,'','','','','',''); DROP TABLE IF EXISTS `hx_activity_log`; CREATE TABLE `hx_activity_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` tinyint(2) unsigned NOT NULL DEFAULT '1', `activity_id` int(10) unsigned NOT NULL DEFAULT '0', `user_id` int(10) unsigned NOT NULL DEFAULT '0', `activity_ip` bigint(20) DEFAULT NULL, `record_id` varchar(255) NOT NULL DEFAULT '0', `remark` varchar(255) NOT NULL DEFAULT '', `status` tinyint(2) NOT NULL DEFAULT '1', `create_time` int(10) unsigned NOT NULL DEFAULT '0', `price` int(11) NOT NULL DEFAULT '0', `wid` int(11) DEFAULT '0', PRIMARY KEY (`id`), KEY `user_id_ix` (`user_id`), KEY `activity_id_ix` (`activity_id`), KEY `activity_ip_ix` (`activity_ip`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; DROP TABLE IF EXISTS `hx_category`; CREATE TABLE `hx_category` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `pid` int(10) unsigned NOT NULL DEFAULT '0', `icon` char(50) DEFAULT NULL, `sort` int(10) unsigned NOT NULL DEFAULT '0', `display` tinyint(3) unsigned NOT NULL DEFAULT '0', `meta_title` varchar(50) NOT NULL DEFAULT '', `keywords` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT '0', `update_time` int(10) unsigned NOT NULL DEFAULT '0', `status` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `pid` (`pid`) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; INSERT INTO `hx_category` VALUES (4,'手机平板',0,'icon icon-tablet',1,1,'','','',1440469030,1450770171,1),(8,'电脑办公',0,'icon icon-desktop',2,1,'','','',1450770206,1450770206,1),(9,'数码影音',0,'icon icon-camera-1',3,1,'','','',1450770234,1450770234,1),(10,'女性时尚',0,'icon icon-women',4,1,'','','',1450770259,1450770259,1),(11,'美食天地',0,'icon icon-food',5,1,'','','',1450770274,1450770274,1),(12,'潮流新品',0,'icon icon-fashion',6,1,'','','',1450770293,1450770293,1),(13,'其他商品',0,'icon icon-th',7,1,'','','',1450770304,1450770304,1); DROP TABLE IF EXISTS `hx_ten`; CREATE TABLE `hx_ten` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类ID', `title` varchar(50) NOT NULL COMMENT '标题', `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）', `display` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '可见性', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '数据状态', `unit` int(11) unsigned NOT NULL DEFAULT '1', `restrictions` tinyint(1) NOT NULL DEFAULT '0' COMMENT '限购', `restrictions_num` int(11) NOT NULL DEFAULT '0' COMMENT '限购数量', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='专区表'; INSERT INTO `hx_ten` VALUES (1,'十元专区',0,1,1459996782,1459996961,1,10,0,0),(4,'限购专区',2,1,1460619015,1462958262,1,1,1,15); DROP TABLE IF EXISTS `hx_config`; CREATE TABLE `hx_config` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL DEFAULT '', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `title` varchar(50) NOT NULL DEFAULT '', `group` tinyint(3) unsigned NOT NULL DEFAULT '0', `extra` varchar(255) NOT NULL DEFAULT '', `remark` varchar(100) NOT NULL, `create_time` int(10) unsigned NOT NULL DEFAULT '0', `update_time` int(10) unsigned NOT NULL DEFAULT '0', `value` text NOT NULL, `sort` smallint(3) unsigned NOT NULL DEFAULT '0', `display` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `uk_name` (`name`), KEY `type` (`type`), KEY `group` (`group`) ) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=utf8; INSERT INTO `hx_config` VALUES (1,'WEB_SITE_TITLE',1,'网站标题',1,'','网站标题前台显示标题',1378898976,1379235274,'弘讯云购',4,1),(2,'WEB_SITE_DESCRIPTION',2,'网站描述',1,'','网站搜索引擎描述',1378898976,1379235841,'弘讯云购，就是指只需1元就有机会获得一件商品，好玩有趣，不容错过。',5,1),(3,'WEB_SITE_KEYWORD',2,'网站关键字',1,'','网站搜索引擎关键字',1378898976,1381390100,'弘讯云购,1元云购,1元,一元,1元购,1元购物,一元购,一元购物',6,1),(4,'WEB_SITE_CLOSE',4,'关闭站点',1,'0:�