function requreSubscribe() { global $_W; $hasSubscribe = 1; if (isset($_W['fans']['from_user']) && !empty($_W['fans']['from_user'])) { $openid = $_W['fans']['from_user']; $userinfo = mc_fansinfo($openid); if (!$userinfo || $userinfo['follow'] == 0) { $hasSubscribe = 0; } } else { $oauthAccount = $_W['oauth_account']; if (empty($oauthAccount)) { message('未指定网页授权公众号, 无法获取用户信息.', '', 'error'); } $userinfo = mc_oauth_userinfo(); $level = pdo_fetchcolumn("SELECT `level` FROM " . tablename('account_wechats') . " WHERE `uniacid`=:uniacid", array(':uniacid' => $_W['uniacid'])); if ($level == 4) { if ($userinfo['subscribe'] == 0) { $hasSubscribe = 0; } } else { $unionid = isset($userinfo['unionid']) ? $userinfo['unionid'] : ''; if (empty($unionid)) { message('获取unionid失败,请确认公众号已接入微信开放平台', '', 'error'); } $fieldsExist = pdo_fieldexists('mc_mapping_fans', 'unionid'); if (!$fieldsExist) { pdo_query("ALTER TABLE " . tablename('mc_mapping_fans') . " ADD column unionid varchar(255) default null"); } $openid = pdo_fetchcolumn("SELECT `openid` FROM " . tablename('mc_mapping_fans') . " WHERE `unionid`=:unionid AND `uniacid`=:uniacid ", array(':unionid' => $unionid, ':uniacid' => $_W['account']['uniacid'])); if (empty($openid)) { $hasSubscribe = 0; } else { $userinfo = mc_fansinfo($openid); if (!$userinfo || $userinfo['follow'] == 0) { $hasSubscribe = 0; } } } } return array('openid' => $openid, 'subscribe' => $hasSubscribe); }
} if (!pdo_fieldexists('weishare', 'background')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `background` varchar(100) NOT NULL COMMENT '背景颜色';"); } if (!pdo_fieldexists('weishare', 'tip')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `tip` varchar(100) NOT NULL COMMENT '提示语';"); } if (!pdo_fieldexists('weishare', 'copyright')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `copyright` varchar(100) NOT NULL COMMENT '版权' ;"); } if (!pdo_fieldexists('weishare', 'cardname')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `cardname` varchar(100) NOT NULL COMMENT '卡片名称' ;"); } if (!pdo_fieldexists('weishare', 'unit')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `unit` varchar(100) NOT NULL COMMENT '单位' ;"); } if (!pdo_fieldexists('weishare', 'helplimit')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `helplimit` int(11) NOT NULL COMMENT '每天助力限制次数';"); } if (!pdo_fieldexists('weishare', 'limittype')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `limittype` int(1) NOT NULL COMMENT '限制类型' ;"); } if (!pdo_fieldexists('weishare_firend', 'sid')) { pdo_query("ALTER TABLE " . tablename('weishare_firend') . " ADD `sid` int(10) NOT NULL DEFAULT '0' ;"); } if (!pdo_fieldexists('weishare', 'endtime')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD endtime\tint(11) unsigned NOT NULL COMMENT '日期' ;"); } if (!pdo_fieldexists('weishare_setting', 'weid')) { pdo_query("ALTER TABLE " . tablename('weishare_setting') . " ADD weid INT(11) UNSIGNED DEFAULT NULL ;"); }
} } $titles = implode("+", $titles); pdo_update("shopping_goods_option", array("title" => $titles), array("id" => $o['id'])); pdo_update("shopping_order_goods", array("optionname" => $titles), array("optionid" => $o['id'])); } //字段长度 if (pdo_fieldexists('shopping_goods', 'thumb')) { pdo_query("ALTER TABLE " . tablename('shopping_goods') . " CHANGE `thumb` `thumb` varchar(255) DEFAULT '';"); } if (!pdo_fieldexists('shopping_goods', 'spec')) { pdo_query("ALTER TABLE " . tablename('shopping_goods') . " ADD `spec` varchar(5000) NOT NULL DEFAULT '';"); } if (!pdo_fieldexists('shopping_goods', 'originalprice')) { pdo_query("ALTER TABLE " . tablename('shopping_goods') . " ADD `originalprice` DECIMAL(10, 2) NOT NULL DEFAULT '0.00' COMMENT '原价' AFTER `costprice`;"); } if (!pdo_fieldexists('shopping_order', 'paydetail')) { pdo_query("ALTER TABLE " . tablename('shopping_order') . " ADD `paydetail` varchar(255) NOT NULL COMMENT '支付详情';"); } if (pdo_fieldexists('shopping_goods', 'total')) { pdo_query("ALTER TABLE " . tablename('shopping_goods') . " CHANGE `total` `total` int(10) unsigned NOT NULL DEFAULT '0';"); } if (pdo_fieldexists('shopping_goods', 'credit')) { pdo_query("ALTER TABLE " . tablename('shopping_goods') . " CHANGE `credit` `credit` decimal(10,2) NOT NULL DEFAULT '0.00';"); } if (!pdo_fieldexists('shopping_goods', 'usermaxbuy')) { pdo_query("ALTER TABLE " . tablename('shopping_goods') . " ADD `usermaxbuy` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户最多购买数量';"); } if (!pdo_fieldexists('shopping_order', 'address')) { pdo_query("ALTER TABLE " . tablename('shopping_order') . " ADD `address` varchar(1024) NOT NULL DEFAULT '' COMMENT '收货地址信息';"); }
<?php if (!pdo_fieldexists('egg_reply', 'periodlottery')) { pdo_query("ALTER TABLE `ims_egg_reply` ADD `periodlottery` SMALLINT( 10 ) UNSIGNED NOT NULL DEFAULT '1' COMMENT '0������';"); } if (pdo_fieldexists('egg_award', 'activation_code')) { pdo_query("ALTER TABLE " . tablename('egg_award') . " CHANGE `activation_code` `activation_code` text;"); }
<?php if (!pdo_fieldexists('wxwall_reply', 'logo')) { pdo_query("ALTER TABLE " . tablename('wxwall_reply') . " ADD `logo` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `isshow`;"); pdo_query("ALTER TABLE " . tablename('wxwall_reply') . " ADD `background` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `logo`;"); }
<?php /* */ if (!pdo_fieldexists('feng_wechat', 'win_mess')) { pdo_query("ALTER TABLE " . tablename('feng_wechat') . " ADD `win_mess` varchar(200) DEFAULT NULL;"); }
<?php /** */ if (!pdo_fieldexists('weihaom_wb_reply', 'uniacid')) { pdo_query("ALTER TABLE " . tablename('weihaom_wb_reply') . " ADD `uniacid` int(10) unsigned NOT NULL;"); }
pdo_delete('rule', "id IN ('" . implode("','", $deleteid) . "')"); } $subaccount = pdo_fetchall("SELECT acid FROM " . tablename('account') . " WHERE uniacid = :uniacid", array(':uniacid' => $uniacid)); if (!empty($subaccount)) { foreach ($subaccount as $account) { @unlink(IA_ROOT . '/attachment/qrcode_' . $account['acid'] . '.jpg'); @unlink(IA_ROOT . '/attachment/headimg_' . $account['acid'] . '.jpg'); } } $tables = pdo_fetchall("SHOW TABLES;"); foreach ($tables as $table) { $tablename = str_replace($GLOBALS['_W']['config']['db']['tablepre'], '', array_shift($table)); if (pdo_fieldexists($tablename, 'uniacid')) { pdo_delete($tablename, array('uniacid' => $uniacid)); } if (pdo_fieldexists($tablename, 'weid')) { pdo_delete($tablename, array('weid' => $uniacid)); } } } message('公众帐号信息删除成功!', url('account/batch'), 'success'); } elseif ($do == 'group') { if (!$_GPC['accountarr']) { message('您没有选择要操作的公众号'); } $isexpire = intval($_GPC['isexpire']); $endtime = strtotime($_GPC['endtime']); if ($isexpire && $endtime <= TIMESTAMP) { message('套餐过期时间必须大于当前时间'); } $groupid = intval($_GPC['groupid']);
`mediaid` varchar(255) DEFAULT \'\', `ticket` varchar(250) NOT NULL, `url` varchar(80) NOT NULL, `createtime` int(10) unsigned NOT NULL, `goodsid` int(11) DEFAULT \'0\', `qrimg` varchar(1000) DEFAULT \'\', PRIMARY KEY (`id`), KEY `idx_acid` (`acid`), KEY `idx_sceneid` (`sceneid`), KEY `idx_type` (`type`), FULLTEXT KEY `idx_openid` (`openid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;'; $sql = 'CREATE TABLE IF NOT EXISTS ' . tablename('ewei_shop_poster_scan') . ' ( `id` int(11) NOT NULL AUTO_INCREMENT, `uniacid` int(11) DEFAULT \'0\', `posterid` int(11) DEFAULT \'0\', `openid` varchar(255) DEFAULT \'\', `from_openid` varchar(255) DEFAULT \'\', `scantime` int(11) DEFAULT \'0\', PRIMARY KEY (`id`), KEY `idx_uniacid` (`uniacid`), KEY `idx_posterid` (`posterid`), KEY `idx_scantime` (`scantime`), FULLTEXT KEY `idx_openid` (`openid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;'; pdo_query($sql); } if (!pdo_fieldexists('ewei_shop_poster', 'paytype')) { pdo_query('ALTER TABLE ' . tablename('ewei_shop_poster') . ' ADD `paytype` tinyint(1) DEFAULT \'0\';'); } pdo_update('ewei_shop_plugin', array('version' => 1.1), array('identity' => 'poster'));
<?php if (!pdo_fieldexists('wxwall_reply', 'logo')) { pdo_query("ALTER TABLE " . tablename('wxwall_reply') . " ADD `logo` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `isshow`;"); pdo_query("ALTER TABLE " . tablename('wxwall_reply') . " ADD `background` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `logo`;"); pdo_query("ALTER TABLE " . tablename('wxwall_reply') . " ADD `acid` INT NOT NULL AFTER `id`;"); } if (!pdo_fieldexists('wxwall_members', 'avatar')) { pdo_query("ALTER TABLE " . tablename('wxwall_members') . " ADD `avatar` varchar(255) NOT NULL COMMENT '粉丝头像';"); }
} if (!pdo_fieldexists('activity', 'location_p')) { pdo_query("ALTER TABLE " . tablename('activity') . " ADD `location_p` varchar(100) NOT NULL COMMENT '所在地区_省' ;"); } if (!pdo_fieldexists('activity', 'location_c')) { pdo_query("ALTER TABLE " . tablename('activity') . " ADD `location_c` varchar(100) NOT NULL COMMENT '所在地区_市' ;"); } if (!pdo_fieldexists('activity', 'location_a')) { pdo_query("ALTER TABLE " . tablename('activity') . " ADD `location_a` varchar(100) NOT NULL COMMENT '所在地区_区' ;"); } if (!pdo_fieldexists('activity', 'lng')) { pdo_query("ALTER TABLE " . tablename('activity') . " `lng` decimal(18,10) NOT NULL DEFAULT '0.0000000000' ;"); } if (!pdo_fieldexists('activity', 'lat')) { pdo_query("ALTER TABLE " . tablename('activity') . " `lat` decimal(18,10) NOT NULL DEFAULT '0.0000000000' ;"); } if (!pdo_fieldexists('activity', 'istip')) { pdo_query("ALTER TABLE " . tablename('activity') . " ADD istip INT(1) DEFAULT 0 ;"); } if (!pdo_fieldexists('activity', 'isrepeat')) { pdo_query("ALTER TABLE " . tablename('activity') . " ADD isrepeat INT(1) DEFAULT 0 ;"); } if (!pdo_fieldexists('activity', 'costdes')) { pdo_query("ALTER TABLE " . tablename('activity') . " ADD costdes VARCHAR(500) DEFAULT NULL ;"); } if (!pdo_fieldexists('activity_reply', 'new_pic')) { pdo_query("ALTER TABLE " . tablename('activity_reply') . " ADD new_pic VARCHAR(200) NOT NULL ;"); } if (!pdo_fieldexists('activity_reply', 'news_content')) { pdo_query("ALTER TABLE " . tablename('activity_reply') . " ADD news_content VARCHAR(500) NOT NULL ;"); }
<?php if (!pdo_fieldexists('ewei_dream_oversee', 'fansid')) { pdo_query("ALTER TABLE " . tablename('ewei_dream_oversee') . " ADD `fansid` int(11) NOT NULL DEFAULT '0';"); }
} if (!pdo_fieldexists('ewei_shop_goods', 'followurl')) { pdo_query("ALTER TABLE " . tablename('ewei_shop_goods') . " ADD `followurl` varchar(255) DEFAULT '0';"); } if (!pdo_fieldexists('ewei_shop_goods', 'deduct')) { pdo_query("ALTER TABLE " . tablename('ewei_shop_goods') . " ADD `deduct` decimal(10,2) DEFAULT '0.00';"); } if (!pdo_fieldexists('ewei_shop_member', 'agentselectgoods')) { pdo_query("ALTER TABLE " . tablename('ewei_shop_member') . " ADD `agentselectgoods` tinyint(3) DEFAULT '0';"); } if (!pdo_fieldexists('ewei_shop_order', 'verifytime')) { pdo_query("ALTER TABLE " . tablename('ewei_shop_order') . " ADD `verifytime` int(11) DEFAULT '0';"); } if (!pdo_fieldexists('ewei_shop_order', 'verifystoreid')) { pdo_query("ALTER TABLE " . tablename('ewei_shop_order') . " ADD `verifystoreid` int(11) DEFAULT '0';"); } if (!pdo_fieldexists('ewei_shop_order', 'deductprice')) { pdo_query("ALTER TABLE " . tablename('ewei_shop_order') . " ADD `deductprice` decimal(10,2) DEFAULT '0.00';"); } if (!pdo_fieldexists('ewei_shop_order', 'deductcredit')) { pdo_query("ALTER TABLE " . tablename('ewei_shop_order') . " ADD `deductcredit` int(11) DEFAULT '0';"); } if (!pdo_fieldexists('ewei_shop_order', 'deductcredit2')) { pdo_query("ALTER TABLE " . tablename('ewei_shop_order') . " ADD `deductcredit2` decimal(10,2) DEFAULT '0.00';"); } if (!pdo_fieldexists('ewei_shop_order', 'deductenough')) { pdo_query("ALTER TABLE " . tablename('ewei_shop_order') . " ADD `deductenough` decimal(10,2) DEFAULT '0.00';"); } if (!pdo_fieldexists('ewei_shop_plugin', 'status')) { pdo_query("ALTER TABLE " . tablename('ewei_shop_plugin') . " ADD `status` tinyint(3) DEFAULT '0';"); }
if (!pdo_fieldexists('xc_article_article', 'templatefile')) { pdo_query("ALTER TABLE " . tablename('xc_article_article') . " ADD `templatefile` varchar(500) NOT NULL DEFAULT '' AFTER `template`;"); } if (!pdo_fieldexists('xc_article_article', 'recommendation')) { pdo_query("ALTER TABLE " . tablename('xc_article_article') . " ADD `recommendation` varchar(1024) NOT NULL COMMENT '推荐ID列表' AFTER `author`;"); } if (!pdo_fieldexists('xc_article_article', 'recommendation_source')) { pdo_query("ALTER TABLE " . tablename('xc_article_article') . " ADD `recommendation_source` varchar(1024) NOT NULL COMMENT '推荐来源user自定义rand随机' AFTER `recommendation`;"); pdo_query("UPDATE " . tablename('xc_article_article') . " SET `recommendation_source`='rand'"); } if (!pdo_fieldexists('xc_article_article_category', 'templatefile')) { pdo_query("ALTER TABLE " . tablename('xc_article_article_category') . " ADD `templatefile` varchar(500) NOT NULL DEFAULT '' AFTER `template`;"); } if (!pdo_fieldexists('xc_article_share_track', 'ip')) { pdo_query("ALTER TABLE " . tablename('xc_article_share_track') . " ADD `ip` varchar(64) NOT NULL DEFAULT '' AFTER `access_time`;"); } if (!pdo_fieldexists('xc_article_share_track', 'clicker_id')) { pdo_query("ALTER TABLE " . tablename('xc_article_share_track') . " ADD `clicker_id` varchar(100) NOT NULL DEFAULT '' AFTER `access_time`;"); } if (!pdo_fieldexists('xc_article_article', 'adv_top')) { pdo_query("ALTER TABLE " . tablename('xc_article_article') . " ADD `adv_on_off` varchar(10) NOT NULL DEFAULT 'off', ADD `adv_top` TEXT(10240) NOT NULL DEFAULT '', ADD `adv_status` TEXT(10240) NOT NULL DEFAULT '', ADD `adv_bottom` TEXT(10240) NOT NULL DEFAULT '' "); } pdo_query("CREATE TABLE IF NOT EXISTS " . tablename('xc_article_adv_cache') . "(\r\n `weid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属帐号',\r\n `adv_on_off` varchar(10) NOT NULL DEFAULT 'off',\r\n `adv_top` TEXT(10240) NOT NULL DEFAULT '',\r\n `adv_status` TEXT(10240) NOT NULL DEFAULT '',\r\n `adv_bottom` TEXT(10240) NOT NULL DEFAULT ''\r\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8;"); pdo_query("UPDATE " . tablename('xc_article_article') . " SET template='jupai' WHERE template='round_box' or template='thumb_plain' or template='plain'"); pdo_query("UPDATE " . tablename('xc_article_article_category') . " SET template='jupai' WHERE template='round_box' or template='thumb_plain' or template='plain'"); if (!pdo_fieldexists('xc_article_article', 'per_user_credit')) { pdo_query("ALTER TABLE " . tablename('xc_article_article') . " ADD `per_user_credit` int(10) NOT NULL DEFAULT '0' AFTER `max_credit`;"); } if (pdo_fieldexists('xc_article_article', 'max_credit')) { pdo_query("ALTER TABLE " . tablename("xc_article_article") . " CHANGE `max_credit` `max_credit` INT( 10 ) NOT NULL DEFAULT '0' COMMENT '积分奖励上限';"); }
<?php if (!pdo_fieldexists('research', 'pretotal')) { pdo_query("ALTER TABLE " . tablename('research') . " ADD `pretotal` INT( 10 ) UNSIGNED NOT NULL DEFAULT '1';"); } //pdo_query("ALTER TABLE `ims_research` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';"); if (!pdo_fieldexists('research', 'noticeemail')) { pdo_query("ALTER TABLE " . tablename('research') . " ADD `noticeemail` VARCHAR( 50 ) NOT NULL DEFAULT '';"); } if (!pdo_fieldexists('research', 'endtime')) { pdo_query("ALTER TABLE " . tablename('research') . " ADD `endtime` INT( 10 ) UNSIGNED NOT NULL ;"); } if (!pdo_fieldexists('research', 'content')) { pdo_query("ALTER TABLE " . tablename('research') . " CHANGE `description` `content` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;"); pdo_query("ALTER TABLE " . tablename('research') . " ADD `description` VARCHAR( 1000 ) NOT NULL DEFAULT '' AFTER `title` ;"); } if (!pdo_fieldexists('research', 'status')) { pdo_query("ALTER TABLE " . tablename('research') . " ADD `status` VARCHAR(1) NULL DEFAULT '';"); }
} if (!pdo_fieldexists('brand_reply', 'news_content')) { pdo_query("ALTER TABLE " . tablename('brand_reply') . " ADD `news_content` VARCHAR(500) NOT NULL;"); } if (!pdo_fieldexists('brand', 'btnName')) { pdo_query("ALTER TABLE " . tablename('brand') . " ADD btnName VARCHAR(20) DEFAULT NUL ;"); } if (!pdo_fieldexists('brand', 'btnUrl')) { pdo_query("ALTER TABLE " . tablename('brand') . " ADD btnUrl VARCHAR(100) DEFAULT NULL ;"); } if (!pdo_fieldexists('brand', 'showMsg')) { pdo_query("ALTER TABLE " . tablename('brand') . " ADD showMsg INT(1) DEFAULT 0 ;"); } if (!pdo_fieldexists('brand', 'btnName1')) { pdo_query("ALTER TABLE " . tablename('brand') . " ADD btnName1 VARCHAR(20) DEFAULT NULL ;"); } if (!pdo_fieldexists('brand', 'btnUrl1')) { pdo_query("ALTER TABLE " . tablename('brand') . " ADD btnUrl1 VARCHAR(100) DEFAULT NULL ;"); } if (!pdo_fieldexists('brand', 'btnName2')) { pdo_query("ALTER TABLE " . tablename('brand') . " ADD btnName2 VARCHAR(20) DEFAULT NULL ;"); } if (!pdo_fieldexists('brand', 'btnUrl2')) { pdo_query("ALTER TABLE " . tablename('brand') . " ADD btnUrl2 VARCHAR(100) DEFAULT NULL ;"); } if (!pdo_fieldexists('brand', 'intro2')) { pdo_query("ALTER TABLE " . tablename('brand') . " ADD intro2 VARCHAR(500) NOT NULL ;"); } if (!pdo_fieldexists('brand_message', 'address')) { pdo_query("ALTER TABLE " . tablename('brand_message') . " ADD address VARCHAR(200) NOT NULL ;"); }
<?php if (!pdo_fieldexists('izclightbox_items', 'video')) { pdo_query("ALTER TABLE " . tablename('izclightbox_items') . " ADD `video` varchar(300) NOT NULL DEFAULT ''"); } if (!pdo_fieldexists('izclightbox_items', 'video_thumb')) { pdo_query("ALTER TABLE " . tablename('izclightbox_items') . " ADD `video_thumb` varchar(300) NOT NULL DEFAULT ''"); } if (!pdo_fieldexists('izclightbox_items', 'lng')) { pdo_query("ALTER TABLE " . tablename('izclightbox_items') . " ADD `lng` double unsigned NOT NULL DEFAULT '0'"); } if (!pdo_fieldexists('izclightbox_items', 'lat')) { pdo_query("ALTER TABLE " . tablename('izclightbox_items') . " ADD `lat` double unsigned NOT NULL DEFAULT '0'"); } if (!pdo_fieldexists('izclightbox_items', 'address')) { pdo_query("ALTER TABLE " . tablename('izclightbox_items') . " ADD `address` varchar(300) NOT NULL DEFAULT ''"); } if (!pdo_fieldexists('izclightbox_items', 'tel')) { pdo_query("ALTER TABLE " . tablename('izclightbox_items') . " ADD `tel` varchar(50) NOT NULL DEFAULT ''"); } if (!pdo_fieldexists('izclightbox_items', 'wechat')) { pdo_query("ALTER TABLE " . tablename('izclightbox_items') . " ADD `wechat` varchar(300) NOT NULL DEFAULT ''"); } if (!pdo_fieldexists('izclightbox_items', 'map_thumb')) { pdo_query("ALTER TABLE " . tablename('izclightbox_items') . " ADD `map_thumb` varchar(300) NOT NULL DEFAULT ''"); }
<?php /** */ if (!pdo_fieldexists('qiyue_canvas', 'uid')) { pdo_query("ALTER TABLE " . tablename('qiyue_canvas') . " ADD `uid` int(10) unsigned NOT NULL DEFAULT '0';"); }
* DELIMITER // * CREATE PROCEDURE schema_add() BEGIN * DECLARE CurrentDatabase VARCHAR(100); * SELECT DATABASE() INTO CurrentDatabase; * IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema=CurrentDatabase AND table_name = 'ims_users_profile' AND column_name = 'jd_account') THEN * ALTER TABLE `ims_users_profile` ADD `jd_account` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '无' COMMENT '京东账号'; * END IF; * IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema=CurrentDatabase AND table_name = 'ims_mc_members' AND column_name = 'jd_account') THEN * ALTER TABLE `ims_mc_members` ADD `jd_account` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '无' COMMENT '京东账号'; * END IF; * IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema=CurrentDatabase AND table_name = 'ims_mc_members' AND column_name = 'modifytime') THEN * ALTER TABLE `ims_mc_members` ADD `modifytime` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '修改时间'; * END IF; * END;// * DELIMITER ; * CALL schema_add(); * INSERT INTO `ims_profile_fields`(field,available, title,description,displayorder,required,unchangeable,showinregister) SELECT 'jd_account', '1', '京东帐号', '', '0', '0', '0', '1' FROM DUAL WHERE NOT EXISTS(SELECT `field` FROM `ims_profile_fields` WHERE `field` = 'jd_account');" */ if (!pdo_fieldexists('users_profile', 'jd_account')) { pdo_query("ALTER TABLE " . table('users_profile') . " ADD `jd_account` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '无' COMMENT '京东账号'"); } if (!pdo_fieldexists('mc_members', 'jd_account')) { pdo_query("ALTER TABLE " . table('mc_members') . " ADD `jd_account` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '无' COMMENT '京东账号'"); } if (!pdo_fieldexists('mc_members', 'modifytime')) { pdo_query("ALTER TABLE " . table('mc_members') . " ADD `modifytime` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '修改时间'"); } if (empty(pdo_fetch('SELECT field,title FROM ' . tablename('profile_fields') . ' WHERE field = :field', array(':field' => 'jd_account')))) { $data = array('field' => 'jd_account', 'available' => '1', 'title' => '京东帐号', 'description' => '', 'displayorder' => '0', 'required' => '0', 'unchangeable' => '0', 'showinregister' => '1'); pdo_insert('profile_fields', $data); }
} if (!pdo_fieldexists('article', 'type')) { pdo_query("ALTER TABLE " . tablename('article') . " ADD `type` VARCHAR( 10 ) NOT NULL DEFAULT '' ;"); } if (!pdo_fieldexists('article_category', 'template')) { pdo_query("ALTER TABLE " . tablename('article_category') . " ADD `template` VARCHAR(300) NOT NULL DEFAULT '' COMMENT '分类模板' AFTER `description`;"); } if (!pdo_fieldexists('article', 'template')) { pdo_query("ALTER TABLE " . tablename('article') . " ADD `template` VARCHAR(300) NOT NULL DEFAULT '' COMMENT '内容模板' AFTER `ccate`;"); } if (!pdo_fieldexists('article', 'displayorder')) { pdo_query("ALTER TABLE " . tablename('article') . " ADD `displayorder` int(10) unsigned NOT NULL DEFAULT '0' AFTER `author`;"); } if (!pdo_fieldexists('article', 'linkurl')) { pdo_query("ALTER TABLE " . tablename('article') . " ADD `linkurl` varchar(500) NOT NULL DEFAULT '' AFTER `displayorder`;"); } if (!pdo_fieldexists('article_category', 'linkurl')) { pdo_query("ALTER TABLE " . tablename('article_category') . " ADD `linkurl` VARCHAR( 500 ) NOT NULL DEFAULT '';"); } if (!pdo_fieldexists('article_category', 'templatefile')) { pdo_query("ALTER TABLE " . tablename('article_category') . " ADD `templatefile` VARCHAR( 100 ) NOT NULL DEFAULT '' AFTER `template`"); } if (!pdo_fieldexists('article_category', 'ishomepage')) { pdo_query("ALTER TABLE " . tablename('article_category') . " ADD `ishomepage` TINYINT( 1 ) NOT NULL DEFAULT '0'"); } if (!pdo_fieldexists('article_category', 'icontype')) { pdo_query("ALTER TABLE " . tablename('article_category') . " ADD `icontype` tinyint(1) unsigned NOT NULL"); } if (!pdo_fieldexists('article_category', 'css')) { pdo_query("ALTER TABLE " . tablename('article_category') . " ADD `css` varchar(500) NOT NULL"); }
pdo_query("ALTER TABLE " . tablename('weisrc_dish_print_setting') . " ADD `title` varchar(200) DEFAULT '';"); } //ims_weisrc_dish_email_setting if (!pdo_fieldexists('weisrc_dish_email_setting', 'email_host')) { pdo_query("ALTER TABLE " . tablename('weisrc_dish_email_setting') . " ADD `email_host` varchar(50) DEFAULT '' COMMENT '邮箱服务器';"); } if (!pdo_fieldexists('weisrc_dish_email_setting', 'email_send')) { pdo_query("ALTER TABLE " . tablename('weisrc_dish_email_setting') . " ADD `email_send` varchar(20) DEFAULT '' COMMENT '商户发送邮件邮箱';"); } if (!pdo_fieldexists('weisrc_dish_email_setting', 'email_pwd')) { pdo_query("ALTER TABLE " . tablename('weisrc_dish_email_setting') . " ADD `email_pwd` varchar(20) DEFAULT '' COMMENT '邮箱密码';"); } if (!pdo_fieldexists('weisrc_dish_email_setting', 'email_user')) { pdo_query("ALTER TABLE " . tablename('weisrc_dish_email_setting') . " ADD `email_user` varchar(100) DEFAULT '' COMMENT '发信人名称';"); } if (!pdo_fieldexists('weisrc_dish_stores', 'is_meal')) { pdo_query("ALTER TABLE " . tablename('weisrc_dish_stores') . " ADD `is_meal` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否店内点餐';"); } if (!pdo_fieldexists('weisrc_dish_stores', 'is_delivery')) { pdo_query("ALTER TABLE " . tablename('weisrc_dish_stores') . " ADD `is_delivery` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否外卖订餐';"); } if (!pdo_fieldexists('weisrc_dish_stores', 'sendingprice')) { pdo_query("ALTER TABLE " . tablename('weisrc_dish_stores') . " ADD `sendingprice` varchar(10) NOT NULL DEFAULT '' COMMENT '起送价格';"); } /** * 微点餐 * * 作者:迷失卍国度 * * qq : 15595755 */
<?php if (!pdo_fieldexists('lxy_buildpro_full_view', 'quanjinglink')) { pdo_query("ALTER TABLE " . tablename('lxy_buildpro_full_view') . " ADD `quanjinglink` varchar(500) DEFAULT NULL COMMENT '全景外链';"); } if (!pdo_fieldexists('lxy_buildpro_full_view', 'pic_xia')) { pdo_query("ALTER TABLE " . tablename('lxy_buildpro_full_view') . " ADD `pic_xia` varchar(1023) DEFAULT NULL;"); } if (!pdo_fieldexists('lxy_buildpro_full_view', 'sort')) { pdo_query("ALTER TABLE " . tablename('lxy_buildpro_full_view') . " ADD `sort` int(11) DEFAULT NULL;"); } if (!pdo_fieldexists('lxy_buildpro_full_view', 'status')) { pdo_query("ALTER TABLE " . tablename('lxy_buildpro_full_view') . " ADD `status` tinyint(4) DEFAULT '1';"); }
//0731 if (!pdo_fieldexists('fm_photosvote_reply', 'fansmostvote')) { pdo_query("ALTER TABLE " . tablename('fm_photosvote_reply') . " ADD `fansmostvote` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户最高投票数';"); } if (!pdo_fieldexists('fm_photosvote_reply', 'mtemplates')) { pdo_query("ALTER TABLE " . tablename('fm_photosvote_reply') . " ADD `mtemplates` varchar(500) NOT NULL COMMENT '模板ID';"); } if (!pdo_fieldexists('fm_photosvote_reply', 'huodong')) { pdo_query("ALTER TABLE " . tablename('fm_photosvote_reply') . " ADD `huodong` varchar(500) NOT NULL COMMENT '活动';"); } if (!pdo_fieldexists('fm_photosvote_reply', 'command')) { pdo_query("ALTER TABLE " . tablename('fm_photosvote_reply') . " ADD `command` varchar(10) NOT NULL COMMENT '报名命令';"); } if (!pdo_fieldexists('fm_photosvote_reply', 'istop')) { pdo_query("ALTER TABLE " . tablename('fm_photosvote_reply') . " ADD `istop` varchar(300) NOT NULL COMMENT '顶部设置';"); } if (!pdo_fieldexists('fm_photosvote_reply', 'isid')) { pdo_query("ALTER TABLE " . tablename('fm_photosvote_reply') . " ADD `isid` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'isid';"); } if (!pdo_fieldexists('fm_photosvote_reply', 'hhhdpicture')) { pdo_query("ALTER TABLE " . tablename('fm_photosvote_reply') . " ADD `hhhdpicture` varchar(150) NOT NULL COMMENT '会话活动图片';"); } if (!pdo_fieldexists('fm_photosvote_reply', 'iplocallimit')) { pdo_query("ALTER TABLE " . tablename('fm_photosvote_reply') . " ADD `iplocallimit` varchar(100) NOT NULL COMMENT '地区限制';"); } if (!pdo_fieldexists('fm_photosvote_reply', 'iplocaldes')) { pdo_query("ALTER TABLE " . tablename('fm_photosvote_reply') . " ADD `iplocaldes` varchar(100) NOT NULL COMMENT '地区限制';"); } if (!pdo_fieldexists('fm_photosvote_provevote', 'ysid')) { pdo_query("ALTER TABLE " . tablename('fm_photosvote_provevote') . " ADD `ysid` int(10) unsigned NOT NULL COMMENT 'ysid';"); }
} if (!pdo_fieldexists('stonefish_grabgifts_reply', 'xuninum')) { pdo_query("ALTER TABLE " . tablename('stonefish_grabgifts_reply') . " ADD `xuninum` int(10) unsigned NOT NULL DEFAULT '50' COMMENT '虚拟人数' AFTER `status`;"); } if (!pdo_fieldexists('stonefish_grabgifts_reply', 'xuninumtime')) { pdo_query("ALTER TABLE " . tablename('stonefish_grabgifts_reply') . " ADD `xuninumtime` int(10) unsigned NOT NULL DEFAULT '86400' COMMENT '虚拟间隔时间' AFTER `xuninum`;"); } if (!pdo_fieldexists('stonefish_grabgifts_reply', 'xuninuminitial')) { pdo_query("ALTER TABLE " . tablename('stonefish_grabgifts_reply') . " ADD `xuninuminitial` int(10) unsigned NOT NULL DEFAULT '10' COMMENT '虚拟随机数值1' AFTER `xuninumtime`;"); } if (!pdo_fieldexists('stonefish_grabgifts_reply', 'xuninumending')) { pdo_query("ALTER TABLE " . tablename('stonefish_grabgifts_reply') . " ADD `xuninumending` int(10) unsigned NOT NULL DEFAULT '50' COMMENT '虚拟随机数值2' AFTER `xuninuminitial`;"); } if (!pdo_fieldexists('stonefish_grabgifts_reply', 'xuninum_time')) { pdo_query("ALTER TABLE " . tablename('stonefish_grabgifts_reply') . " ADD `xuninum_time` int(10) unsigned NOT NULL COMMENT '虚拟更新时间' AFTER `xuninumending`;"); } if (!pdo_fieldexists('stonefish_grabgifts_reply', 'awarding')) { pdo_query("ALTER TABLE " . tablename('stonefish_grabgifts_reply') . " ADD `awarding` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '兑奖地点选择' AFTER `ndrankstatusnum`;"); } if (!pdo_fieldexists('stonefish_grabgifts_userlist', 'mikaid')) { pdo_query("ALTER TABLE " . tablename('stonefish_grabgifts_userlist') . " ADD `mikaid` varchar(500) NOT NULL DEFAULT '' COMMENT '领取密卡列表' AFTER `grabgifts`;"); } if (!pdo_fieldexists('stonefish_grabgifts_userlist', 'awardingid')) { pdo_query("ALTER TABLE " . tablename('stonefish_grabgifts_userlist') . " ADD `awardingid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '兑奖地址ID' AFTER `ndranknums`;"); } if (!pdo_fieldexists('stonefish_grabgifts_userlist', 'awardingtypeid')) { pdo_query("ALTER TABLE " . tablename('stonefish_grabgifts_userlist') . " ADD `awardingtypeid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '兑奖地址区域ID' AFTER `awardingid`;"); } pdo_query("CREATE TABLE IF NOT EXISTS `ims_stonefish_grabgifts_awarding` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `weid` int(10) unsigned NOT NULL COMMENT '公众号ID',\n `typeid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '区域ID',\n `shoptitle` varchar(50) NOT NULL DEFAULT '' COMMENT '兑奖店面名称',\n `address` varchar(512) NOT NULL DEFAULT '' COMMENT '兑奖地址',\n `tel` varchar(50) NOT NULL DEFAULT '' COMMENT '联系电话',\n `pass` varchar(20) NOT NULL DEFAULT '' COMMENT '兑奖密码',\n `images` varchar(512) NOT NULL DEFAULT '' COMMENT '广告或店面图',\n `carmap` varchar(50) NOT NULL COMMENT '地图导航',\n PRIMARY KEY (`id`)\n) ENGINE = MYISAM DEFAULT CHARSET = utf8;"); pdo_query("CREATE TABLE IF NOT EXISTS `ims_stonefish_grabgifts_awardingtype` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `weid` int(10) unsigned NOT NULL COMMENT '公众号ID',\n `quyutitle` varchar(50) NOT NULL DEFAULT '' COMMENT '分类名称',\n `orderid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',\n PRIMARY KEY (`id`)\n) ENGINE = MYISAM DEFAULT CHARSET = utf8;"); pdo_query("CREATE TABLE IF NOT EXISTS `ims_stonefish_grabgifts_giftmika` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\n `giftid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '礼盒ID', \n `from_user` varchar(50) NOT NULL DEFAULT '' COMMENT '用户openid', \n `mika` varchar(50) NOT NULL COMMENT '密卡字符串',\n `activationurl` varchar(200) NOT NULL COMMENT '激活地址',\n `description` varchar(100) NOT NULL DEFAULT '' COMMENT '描述',\n `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否领取1为领取过',\n PRIMARY KEY (`id`),\n KEY `indx_rid` (`rid`)\n) ENGINE = MYISAM DEFAULT CHARSET = utf8;");
<?php /** * 游戏设置 * * @version $Id: settings.inc.php 1 18:42 2015年09月15日Z lions $ * @copyright Copyright (c) 2013 - 2020, haobama.net, Inc. * @link http://www.haobama.net */ global $_W, $_GPC; if (isset($_GPC['item']) && $_GPC['item'] == 'ajax' && $_GPC['key'] == 'require') { $data['uniacid'] = $_W['uniacid']; $data['setting_key'] = 'require_subscribe'; $data['setting_value'] = $_GPC['require'] == 1 ? 1 : 0; if ($data['setting_value'] == 1) { $fieldsExist = pdo_fieldexists('mc_mapping_fans', 'unionid'); if (!$fieldsExist) { pdo_query("ALTER TABLE " . tablename('mc_mapping_fans') . " ADD column unionid varchar(255) default null"); } } pdo_query("DELETE FROM " . tablename('lions_zq_settings') . " WHERE `uniacid`=:uniacid AND `setting_key`='require_subscribe'", array(':uniacid' => $_W['uniacid'])); pdo_insert('lions_zq_settings', $data); echo pdo_insertid(); exit; } elseif (isset($_GPC['item']) && $_GPC['item'] == 'ajax' && $_GPC['key'] == 'thumb') { $data['uniacid'] = $_W['uniacid']; $data['setting_key'] = 'thumb'; $data['setting_value'] = $_GPC['thumb']; pdo_query("DELETE FROM " . tablename('lions_zq_settings') . " WHERE `uniacid`=:uniacid AND `setting_key`='thumb'", array(':uniacid' => $_W['uniacid'])); pdo_insert('lions_zq_settings', $data); echo pdo_insertid();
<?php if (!defined('IN_IA')) { exit('Access Denied'); } if (!pdo_fieldexists('ewei_dshop_goods', 'taotaoid')) { pdo_query('ALTER TABLE ' . tablename('ewei_dshop_goods') . ' ADD `taotaoid` varchar(255) DEFAULT \'\';'); } if (!pdo_fieldexists('ewei_dshop_goods', 'taobaourl')) { pdo_query('ALTER TABLE ' . tablename('ewei_dshop_goods') . ' ADD `taobaourl` varchar(255) DEFAULT \'\';'); } if (!pdo_fieldexists('ewei_dshop_goods', 'updatetime')) { pdo_query('ALTER TABLE ' . tablename('ewei_dshop_goods') . ' ADD `updatetime` int(11) default 0;'); } if (!pdo_fieldexists('ewei_dshop_goods', 'updatetime')) { pdo_query('ALTER TABLE ' . tablename('ewei_dshop_goods') . ' ADD `updatetime` int(11) default 0;'); } if (!pdo_fieldexists('ewei_dshop_goods_option', 'skuId')) { pdo_query('ALTER TABLE ' . tablename('ewei_dshop_goods_option') . ' ADD `skuId` varchar(255) DEFAULT \'\';'); } if (!pdo_fieldexists('ewei_dshop_goods_spec', 'propId')) { pdo_query('ALTER TABLE ' . tablename('ewei_dshop_goods_spec') . ' ADD `propId` varchar(255) DEFAULT \'\';'); } if (!pdo_fieldexists('ewei_dshop_goods_spec_item', 'valueId')) { pdo_query('ALTER TABLE ' . tablename('ewei_dshop_goods_spec_item') . ' ADD `valueId` varchar(255) DEFAULT \'\';'); }
} if (!pdo_fieldexists('weishare', 'tip')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `tip` varchar(100) NOT NULL COMMENT '提示语';"); } if (!pdo_fieldexists('weishare', 'copyright')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `copyright` varchar(100) NOT NULL COMMENT '版权' ;"); } if (!pdo_fieldexists('weishare', 'cardname')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `cardname` varchar(100) NOT NULL COMMENT '卡片名称' ;"); } if (!pdo_fieldexists('weishare', 'unit')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `unit` varchar(100) NOT NULL COMMENT '单位' ;"); } if (!pdo_fieldexists('weishare', 'helplimit')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `helplimit` int(11) NOT NULL COMMENT '每天助力限制次数';"); } if (!pdo_fieldexists('weishare', 'limittype')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `limittype` int(1) NOT NULL COMMENT '限制类型' ;"); } if (!pdo_fieldexists('weishare_firend', 'sid')) { pdo_query("ALTER TABLE " . tablename('weishare_firend') . " ADD `sid` int(10) NOT NULL DEFAULT '0' ;"); } if (!pdo_fieldexists('weishare', 'endtime')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD endtime\tint(11) unsigned NOT NULL COMMENT '日期' ;"); } if (!pdo_fieldexists('weishare_setting', 'weid')) { pdo_query("ALTER TABLE " . tablename('weishare_setting') . " ADD weid INT(11) UNSIGNED DEFAULT NULL ;"); } if (!pdo_fieldexists('weishare', 'rule')) { pdo_query("ALTER TABLE " . tablename('weishare') . " ADD `rule` text NOT NULL COMMENT '规则';"); }
<?php if (!pdo_fieldexists('wwx_sign', 'new_title')) { pdo_query("ALTER TABLE " . tablename('wwx_sign') . "ADD `new_title` varchar(200);"); } if (!pdo_fieldexists('wwx_sign', 'copyright')) { pdo_query("ALTER TABLE " . tablename('wwx_sign') . "ADD `copyright` varchar(200) ;"); } if (!pdo_fieldexists('wwx_sign', 'new_icon')) { pdo_query("ALTER TABLE " . tablename('wwx_sign') . "ADD `new_icon` varchar(200);"); } if (!pdo_fieldexists('wwx_sign', 'new_content')) { pdo_query("ALTER TABLE " . tablename('wwx_sign') . "ADD `new_content` varchar(200);"); } if (!pdo_fieldexists('wwx_sign_award', 'serial_day')) { pdo_query("ALTER TABLE " . tablename('wwx_sign_award') . "ADD serial_day int(10) ;"); } /** * links */ $sql = "\r\nCREATE TABLE IF NOT EXISTS " . tablename('wwx_sign_link') . " (\r\n`id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n`sid` INT(11) UNSIGNED DEFAULT NULL,\r\n`sort` int(2) default 0,\r\n`link_name` varchar(50) NOT NULL ,\r\n`link_url` varchar(50) NOT NULL,\r\n`createtime` int(10) unsigned NOT NULL COMMENT '日期',\r\n PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8"; pdo_query($sql);
<?php if (!pdo_fieldexists('mbrp_activities', 'banner')) { pdo_run("ALTER TABLE `ims_mbrp_activities` ADD `banner` VARCHAR(500) NOT NULL DEFAULT '';"); }
<?php if(!pdo_fieldexists('jufeng_wcy_category', 'count1')) { pdo_query("ALTER TABLE ".tablename('jufeng_wcy_category')." ADD `count1` varchar(20) NOT NULL;"); } if(!pdo_fieldexists('jufeng_wcy_category', 'count2')) { pdo_query("ALTER TABLE ".tablename('jufeng_wcy_category')." ADD `count2` varchar(20) NOT NULL;"); } if(!pdo_fieldexists('jufeng_wcy_category', 'count3')) { pdo_query("ALTER TABLE ".tablename('jufeng_wcy_category')." ADD `count3` varchar(20) NOT NULL;"); } ?>