我爱抽奖盒子小程序源码V4.1.3

<?php //升级数据表 pdo_query("CREATE TABLE IF NOT EXISTS `ims_panda_luckybox_address` ( `address_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id', `uniacid` int(11) NOT NULL COMMENT '公众号id', `member_id` int(11) NOT NULL COMMENT '会员id', `name` varchar(100) NOT NULL COMMENT '收货人姓名', `telephone` varchar(50) NOT NULL COMMENT '电话', `address` varchar(255) NOT NULL COMMENT '收货地址', `address_name` enum('HOME','WORK') NOT NULL DEFAULT 'HOME' COMMENT '收货地址类型', `lon_lat` varchar(30) DEFAULT '' COMMENT '地址经纬度', `lou_meng_hao` varchar(100) DEFAULT '' COMMENT '门牌号-楼号', `is_default` tinyint(1) NOT NULL COMMENT '是否默认的收货地址', `city_id` int(10) NOT NULL COMMENT '市', `country_id` int(10) NOT NULL COMMENT '县乡', `province_id` int(10) NOT NULL COMMENT '省', PRIMARY KEY (`address_id`), KEY `uniacid` (`uniacid`,`member_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='海鸥商城地址库'; "); if(!pdo_fieldexists('panda_luckybox_address','address_id')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `address_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id'");} if(!pdo_fieldexists('panda_luckybox_address','uniacid')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `uniacid` int(11) NOT NULL COMMENT '公众号id'");} if(!pdo_fieldexists('panda_luckybox_address','member_id')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `member_id` int(11) NOT NULL COMMENT '会员id'");} if(!pdo_fieldexists('panda_luckybox_address','name')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `name` varchar(100) NOT NULL COMMENT '收货人姓名'");} if(!pdo_fieldexists('panda_luckybox_address','telephone')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `telephone` varchar(50) NOT NULL COMMENT '电话'");} if(!pdo_fieldexists('panda_luckybox_address','address')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `address` varchar(255) NOT NULL COMMENT '收货地址'");} if(!pdo_fieldexists('panda_luckybox_address','address_name')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `address_name` enum('HOME','WORK') NOT NULL DEFAULT 'HOME' COMMENT '收货地址类型'");} if(!pdo_fieldexists('panda_luckybox_address','lon_lat')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `lon_lat` varchar(30) DEFAULT '' COMMENT '地址经纬度'");} if(!pdo_fieldexists('panda_luckybox_address','lou_meng_hao')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `lou_meng_hao` varchar(100) DEFAULT '' COMMENT '门牌号-楼号'");} if(!pdo_fieldexists('panda_luckybox_address','is_default')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `is_default` tinyint(1) NOT NULL COMMENT '是否默认的收货地址'");} if(!pdo_fieldexists('panda_luckybox_address','city_id')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `city_id` int(10) NOT NULL COMMENT '市'");} if(!pdo_fieldexists('panda_luckybox_address','country_id')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `country_id` int(10) NOT NULL COMMENT '县乡'");} if(!pdo_fieldexists('panda_luckybox_address','province_id')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD `province_id` int(10) NOT NULL COMMENT '省'");} if(!pdo_fieldexists('panda_luckybox_address','address_id')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_address')." ADD PRIMARY KEY (`address_id`)");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_panda_luckybox_adv` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id', `uniacid` int(11) NOT NULL COMMENT '公众号id', `advname` varchar(200) NOT NULL COMMENT '广告名称', `thumb` varchar(255) NOT NULL COMMENT '图片地址', `link` varchar(255) NOT NULL COMMENT '广告链接地址', `appid` varchar(255) DEFAULT NULL COMMENT '外部小程序appid', `linktype` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0外链 1小程序内 2外部小程序', `type` enum('slider','nav') NOT NULL COMMENT '广告类型，slider幻灯，nav导航小图', `displayorder` int(10) NOT NULL COMMENT '排序，越大排序越前面', `enabled` tinyint(1) NOT NULL COMMENT '是否生效，1生效，0不生效', `addtime` int(10) NOT NULL COMMENT '添加广告时间', PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='海鸥商城商品广告表'; "); if(!pdo_fieldexists('panda_luckybox_adv','id')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id'");} if(!pdo_fieldexists('panda_luckybox_adv','uniacid')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD `uniacid` int(11) NOT NULL COMMENT '公众号id'");} if(!pdo_fieldexists('panda_luckybox_adv','advname')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD `advname` varchar(200) NOT NULL COMMENT '广告名称'");} if(!pdo_fieldexists('panda_luckybox_adv','thumb')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD `thumb` varchar(255) NOT NULL COMMENT '图片地址'");} if(!pdo_fieldexists('panda_luckybox_adv','link')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD `link` varchar(255) NOT NULL COMMENT '广告链接地址'");} if(!pdo_fieldexists('panda_luckybox_adv','appid')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD `appid` varchar(255) DEFAULT NULL COMMENT '外部小程序appid'");} if(!pdo_fieldexists('panda_luckybox_adv','linktype')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD `linktype` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0外链 1小程序内 2外部小程序'");} if(!pdo_fieldexists('panda_luckybox_adv','type')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD `type` enum('slider','nav') NOT NULL COMMENT '广告类型，slider幻灯，nav导航小图'");} if(!pdo_fieldexists('panda_luckybox_adv','displayorder')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD `displayorder` int(10) NOT NULL COMMENT '排序，越大排序越前面'");} if(!pdo_fieldexists('panda_luckybox_adv','enabled')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD `enabled` tinyint(1) NOT NULL COMMENT '是否生效，1生效，0不生效'");} if(!pdo_fieldexists('panda_luckybox_adv','addtime')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD `addtime` int(10) NOT NULL COMMENT '添加广告时间'");} if(!pdo_fieldexists('panda_luckybox_adv','id')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv')." ADD PRIMARY KEY (`id`)");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_panda_luckybox_adv_video_log` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id', `uniacid` int(11) NOT NULL COMMENT '公众号id', `member_id` int(10) NOT NULL COMMENT '会员id', `state` tinyint(1) NOT NULL COMMENT '0未发放 1已发放', `type` tinyint(3) DEFAULT '0' COMMENT '0普通激励视频观看 1任务视频观看', `add_time` int(10) NOT NULL COMMENT '开始时间', `end_time` int(10) NOT NULL COMMENT '结束时间', PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`), KEY `member_id` (`member_id`) ) ENGINE=InnoDB AUTO_INCREMENT=12133 DEFAULT CHARSET=utf8mb4 COMMENT='潘达抽奖盒子广告观看记录表'; "); if(!pdo_fieldexists('panda_luckybox_adv_video_log','id')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv_video_log')." ADD `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id'");} if(!pdo_fieldexists('panda_luckybox_adv_video_log','uniacid')) {pdo_query("ALTER TABLE ".tablename('panda_luckybox_adv_video_log')." ADD `uniacid` int(11) NOT NULL COMMENT '公众号id'");} if(!pdo_fieldexists('panda_luckybox_adv_video_log','member_id')) {pdo_query("ALTER TABLE ".tablename('p