柚子家政 wnjz_sun 6.2.6+分销插件.rar完整版小程序

<?php //升级数据表 pdo_query("CREATE TABLE IF NOT EXISTS `ims_wnjz_sun_addnews` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `title` varchar(255) NOT NULL COMMENT '标题，展示用', `left` int(10) unsigned NOT NULL, `state` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '状态，1显示，2为关闭', `uniacid` int(11) NOT NULL, `type` int(11) NOT NULL COMMENT '类型', `time` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; "); if(!pdo_fieldexists('wnjz_sun_addnews','id')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_addnews')." ADD `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id'");} if(!pdo_fieldexists('wnjz_sun_addnews','title')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_addnews')." ADD `title` varchar(255) NOT NULL COMMENT '标题，展示用'");} if(!pdo_fieldexists('wnjz_sun_addnews','left')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_addnews')." ADD `left` int(10) unsigned NOT NULL");} if(!pdo_fieldexists('wnjz_sun_addnews','state')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_addnews')." ADD `state` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '状态，1显示，2为关闭'");} if(!pdo_fieldexists('wnjz_sun_addnews','uniacid')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_addnews')." ADD `uniacid` int(11) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_addnews','type')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_addnews')." ADD `type` int(11) NOT NULL COMMENT '类型'");} if(!pdo_fieldexists('wnjz_sun_addnews','time')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_addnews')." ADD `time` varchar(50) NOT NULL");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_wnjz_sun_address` ( `adid` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(45) NOT NULL COMMENT '收货人', `telNumber` varchar(30) NOT NULL, `countyName` varchar(100) NOT NULL COMMENT '地址', `detailInfo` varchar(100) NOT NULL, `isdefault` varchar(11) DEFAULT '0', `oprnid` varchar(55) NOT NULL, `uniacid` int(11) DEFAULT NULL, `cityName` varchar(100) NOT NULL, `provinceName` varchar(100) NOT NULL, PRIMARY KEY (`adid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; "); if(!pdo_fieldexists('wnjz_sun_address','adid')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_address')." ADD `adid` int(11) NOT NULL AUTO_INCREMENT");} if(!pdo_fieldexists('wnjz_sun_address','name')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_address')." ADD `name` varchar(45) NOT NULL COMMENT '收货人'");} if(!pdo_fieldexists('wnjz_sun_address','telNumber')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_address')." ADD `telNumber` varchar(30) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_address','countyName')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_address')." ADD `countyName` varchar(100) NOT NULL COMMENT '地址'");} if(!pdo_fieldexists('wnjz_sun_address','detailInfo')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_address')." ADD `detailInfo` varchar(100) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_address','isdefault')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_address')." ADD `isdefault` varchar(11) DEFAULT '0'");} if(!pdo_fieldexists('wnjz_sun_address','oprnid')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_address')." ADD `oprnid` varchar(55) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_address','uniacid')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_address')." ADD `uniacid` int(11) DEFAULT NULL");} if(!pdo_fieldexists('wnjz_sun_address','cityName')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_address')." ADD `cityName` varchar(100) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_address','provinceName')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_address')." ADD `provinceName` varchar(100) NOT NULL");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_wnjz_sun_adminstore` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account` varchar(45) DEFAULT NULL, `password` varchar(45) DEFAULT NULL, `uniacid` int(11) DEFAULT NULL, `build_id` int(11) DEFAULT NULL, `mobile` varchar(45) DEFAULT NULL, `store_name` varchar(45) DEFAULT NULL COMMENT '店长名称', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; "); if(!pdo_fieldexists('wnjz_sun_adminstore','id')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_adminstore')." ADD `id` int(11) NOT NULL AUTO_INCREMENT");} if(!pdo_fieldexists('wnjz_sun_adminstore','account')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_adminstore')." ADD `account` varchar(45) DEFAULT NULL");} if(!pdo_fieldexists('wnjz_sun_adminstore','password')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_adminstore')." ADD `password` varchar(45) DEFAULT NULL");} if(!pdo_fieldexists('wnjz_sun_adminstore','uniacid')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_adminstore')." ADD `uniacid` int(11) DEFAULT NULL");} if(!pdo_fieldexists('wnjz_sun_adminstore','build_id')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_adminstore')." ADD `build_id` int(11) DEFAULT NULL");} if(!pdo_fieldexists('wnjz_sun_adminstore','mobile')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_adminstore')." ADD `mobile` varchar(45) DEFAULT NULL");} if(!pdo_fieldexists('wnjz_sun_adminstore','store_name')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_adminstore')." ADD `store_name` varchar(45) DEFAULT NULL COMMENT '店长名称'");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_wnjz_sun_banner` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bname` varchar(200) CHARACTER SET utf8 NOT NULL, `url` varchar(300) NOT NULL COMMENT '文章图片', `lb_imgs` varchar(500) NOT NULL COMMENT '文章那个内容', `uniacid` int(11) NOT NULL, `bname1` varchar(200) NOT NULL, `bname2` varchar(200) NOT NULL, `bname3` varchar(200) NOT NULL, `lb_imgs1` varchar(500) CHARACTER SET utf8 NOT NULL, `lb_imgs2` varchar(500) NOT NULL, `lb_imgs3` varchar(500) NOT NULL, `url1` varchar(300) NOT NULL, `url2` varchar(300) NOT NULL, `url3` varchar(300) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=gbk; "); if(!pdo_fieldexists('wnjz_sun_banner','id')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `id` int(11) NOT NULL AUTO_INCREMENT");} if(!pdo_fieldexists('wnjz_sun_banner','bname')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `bname` varchar(200) CHARACTER SET utf8 NOT NULL");} if(!pdo_fieldexists('wnjz_sun_banner','url')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `url` varchar(300) NOT NULL COMMENT '文章图片'");} if(!pdo_fieldexists('wnjz_sun_banner','lb_imgs')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `lb_imgs` varchar(500) NOT NULL COMMENT '文章那个内容'");} if(!pdo_fieldexists('wnjz_sun_banner','uniacid')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `uniacid` int(11) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_banner','bname1')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `bname1` varchar(200) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_banner','bname2')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `bname2` varchar(200) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_banner','bname3')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `bname3` varchar(200) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_banner','lb_imgs1')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `lb_imgs1` varchar(500) CHARACTER SET utf8 NOT NULL");} if(!pdo_fieldexists('wnjz_sun_banner','lb_imgs2')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `lb_imgs2` varchar(500) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_banner','lb_imgs3')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `lb_imgs3` varchar(500) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_banner','url1')) {pdo_query("ALTER TABLE ".tablename('wnjz_sun_banner')." ADD `url1` varchar(300) NOT NULL");} if(!pdo_fieldexists('wnjz_sun_banner','url2')) {pdo_query("ALTER TABLE ".tablena