public function doMobileLottery() { global $_GPC, $_W; $id = intval($_GPC['id']); $sql = 'SELECT * FROM ' . tablename('zzz_reply') . ' WHERE `rid` = :rid'; $params = array(':rid' => $id); $zzz = pdo_fetch($sql, $params); if (empty($zzz)) { message('非法访问,请重新发送消息进入!'); } checkauth(); load()->model("mc"); $profile = mc_require($_W['member']['uid'], array('nickname', 'mobile'), '需要完善资料后才能继续.'); $startgame = 1; if ($zzz['start_time'] > TIMESTAMP) { $startgame = 0; $str = "活动没开始"; } if ($zzz['end_time'] < TIMESTAMP) { $startgame = 0; $str = "活动已结束"; } if (empty($_W['fans']['fanid'])) { $sql = 'SELECT `fanid` FROM ' . tablename('mc_mapping_fans') . ' WHERE `uid` = :uid'; $params = array(':uid' => $_W['member']['uid']); $fansId = pdo_fetchcolumn($sql, $params); if (empty($fansId)) { message('必须关注公众号才可以进入游戏', $this->createMobileUrl('introduce', array('id' => $id)), 'error'); } $_W['fans']['fanid'] = $fansId; } $sql = 'SELECT * FROM ' . tablename('zzz_user') . ' WHERE `rid` = :rid AND `fanid` = :fanid'; $params = array(':rid' => $id, ':fanid' => $_W['fans']['fanid']); $myuser = pdo_fetch($sql, $params); // 用户不存在插入一条数据 if (empty($myuser)) { $zzz_user = array('rid' => $id, 'count' => 0, 'points' => 0, 'fanid' => $_W['fans']['fanid'], 'createtime' => TIMESTAMP); pdo_insert('zzz_user', $zzz_user); } $myph = ''; if (!empty($myuser)) { $sql = 'SELECT count(*) FROM ' . tablename('zzz_user') . ' WHERE `rid` = :rid AND `points` > :points'; $params = array(':rid' => $id, ':points' => $myuser['points']); $ph = pdo_fetchcolumn($sql, $params); $myph = intval($ph) + 1; } // 分享增加体力 $shareFid = intval($_GPC['shareuid']); if (!empty($shareFid)) { $sql = 'SELECT `id` FROM ' . tablename('zzz_share') . ' WHERE `rid` = :rid AND `fanid` = :fanid AND `sharefid` = :sharefid'; $params = array(':rid' => $id, ':fanid' => $_W['fans']['fanid'], 'sharefid' => $shareFid); $shareInfo = pdo_fetchcolumn($sql, $params); if (empty($shareInfo)) { pdo_insert('zzz_share', array('rid' => $id, 'fanid' => $_W['fans']['fanid'], 'sharefid' => $shareFid)); pdo_update('zzz_user', array('sharevalue' => $myuser['sharevalue'] + $zzz['sharevalue']), array('fanid' => $shareFid, 'rid' => $id)); } } $energylimit = ($zzz['maxlottery'] + $zzz['prace_times']) * 10; include $this->template('gamex'); }
public function doMobileWelcome() { global $_W, $_GPC; checkauth(); $rid = intval($_GPC['rid']); $reply = pdo_fetch("SELECT * FROM " . tablename('shake_reply') . " WHERE rid = :rid", array(':rid' => $rid)); if (empty($reply)) { message('抱歉,此活动不存在或是还未开始!', 'refresh', 'error'); } load()->model('mc'); $profile = mc_fetch($_W['member']['uid'], array('realname', 'mobile', 'avatar')); if (empty($profile['avatar'])) { mc_oauth_userinfo(); } if (empty($profile['realname']) || empty($profile['mobile'])) { mc_require($_W['member']['uid'], array('realname', 'mobile')); } $member = pdo_fetch("SELECT * FROM " . tablename('shake_member') . " WHERE rid = :rid AND openid = :openid", array(':rid' => $reply['rid'], ':openid' => $_W['member']['uid'])); if (!empty($member)) { header('Location: ' . $this->createMobileUrl('detail', array('rid' => $reply['rid']))); exit; } $reply['rule'] = html_entity_decode($reply['rule']); include $this->template('welcome'); }
public function doMobileMessage() { global $_GPC, $_W; $op = trim($_GPC['op']) ? trim($_GPC['op']) : 'list'; $set = pdo_fetch("SELECT * FROM " . tablename('we7car_message_set') . " WHERE weid = :weid ORDER BY `id` DESC LIMIT 1", array(':weid' => $_W['uniacid'])); if ($set == false) { $set = array('status' => 1, 'isshow' => 1); } if ($op == 'list') { if ($set['status'] == 0) { message('留言墙尚未开启,请耐心等待'); } $total = pdo_fetchcolumn("SELECT count(*) FROM " . tablename('we7car_message_list') . " WHERE fid = 0 AND isshow = 1 AND weid = :weid", array(':weid' => $_W['uniacid'])); $pindex = max(1, intval($_GPC['page'])); $psize = 20; $pager = pagination($total, $pindex, $psize); $messagelist = pdo_fetchall("SELECT * FROM " . tablename('we7car_message_list') . " WHERE weid = :weid and fid=0 and isshow=1 ORDER BY create_time DESC LIMIT " . ($pindex - 1) * $psize . ',' . $psize, array(':weid' => $_W['uniacid'])); foreach ($messagelist as &$v) { $v['reply'] = pdo_fetchall("SELECT * FROM " . tablename('we7car_message_list') . " WHERE weid = :weid AND fid = :fid AND isshow=1 LIMIT 20", array(':weid' => $_W['uniacid'], ':fid' => $v['id'])); } //获取fans表中的username // $nickname = pdo_fetchcolumn("SELECT `nickname` FROM " . tablename('fans') . " WHERE weid = :weid AND `from_user` = :from_user LIMIT 1", array(':from_user' => $_W['fans']['from_user'], ':weid' => $_W['uniacid'])); $mc = mc_require($_W['member']['uid'], array('nickname')); $nickname = $m['nickname']; include $this->template('message_list'); } if ($op == 'ajax') { if (empty($_W['fans']['from_user'])) { $data['msg'] = '登陆过期,请重新从微信进入!'; $data['success'] = false; } else { $sql = "SELECT * FROM " . tablename('we7car_message_list') . " WHERE from_user = :from_user AND weid = :weid ORDER BY id DESC"; $params = array(':weid' => $_W['uniacid'], ':from_user' => $_W['fans']['from_user']); $message = pdo_fetch($sql, $params); $insert = array('weid' => $_W['uniacid'], 'nickname' => trim($_GPC['nickname']), 'info' => trim($_GPC['info']), 'fid' => intval($_GPC['fid']), 'from_user' => $_W['fans']['from_user'], 'isshow' => $set['isshow'], 'create_time' => TIMESTAMP); if (empty($insert['nickname'])) { if (empty($_W['member']['uid'])) { $sql = "SELECT nickname FROM " . tablename('mc_mapping_fans') . " WHERE uniacid = :uniacid AND openid = :from_user"; $params = array(':uniacid' => $_W['uniacid'], ':from_user' => $_W['fans']['from_user']); $nickname = pdo_fetchcolumn($sql, $params); if (empty($nickname)) { $nickname = $_W['fans']['from_user']; } } else { load()->model('mc'); $nickname = mc_fetch($_W['member']['uid'], array('nickname')); $nickname = $nickname['nickname']; } $insert['nickname'] = $nickname; } if (empty($message)) { $id = pdo_insert('we7car_message_list', $insert); $data['success'] = true; $data['msg'] = '留言发表成功'; if ($set['isshow'] == 0) { $data['msg'] = $data['msg'] . ',进入审核流程'; } } else { if (TIMESTAMP - $message['create_time'] < 5) { $data['msg'] = '您的留言太过频繁,请5秒后留言'; $data['success'] = false; } else { $id = pdo_insert('we7car_message_list', $insert); $data['success'] = true; $data['msg'] = '留言发表成功'; if ($set['isshow'] == 0) { $data['msg'] = $data['msg'] . ',进入审核流程'; } } } } echo json_encode($data); } }
public function doMobileLottery() { global $_GPC, $_W; checkauth(); load()->model('mc'); mc_require($_W['member']['uid'], array('realname', 'mobile'), '需要完善资料后才能砸蛋.'); $where = ' WHERE `rid` = :rid'; $params = array(':rid' => intval($_GPC['id'])); $sql = 'SELECT * FROM ' . tablename('egg_reply') . $where; $egg = pdo_fetch($sql, $params); if (empty($egg)) { message('非法访问,请重新发送消息进入砸蛋页面!'); } if (TIMESTAMP < $egg['starttime']) { message('活动还没有开始!'); } if (TIMESTAMP > $egg['endtime']) { message('活动已经结束啦!'); } $where .= ' AND `uniacid` = :uniacid AND `uid` = :uid'; $params[':uniacid'] = $_W['uniacid']; $params[':uid'] = $_W['member']['uid']; $params[':createtime'] = strtotime(date('Y-m-d')); // 当日砸蛋次数 $sql = 'SELECT COUNT(*) FROM ' . tablename('egg_winner') . $where . ' AND `createtime` > :createtime'; $total = pdo_fetchcolumn($sql, $params); // 会员信息 $member = mc_fetch($_W['member']['uid'], array('realname', 'mobile')); // 我的奖品 $sql = 'SELECT `award`, `description` FROM ' . tablename('egg_winner') . $where . ' ORDER BY `createtime` DESC'; unset($params[':createtime']); $myAward = pdo_fetchall($sql, $params); // 中奖名单 $sql = 'SELECT `award`, `realname` FROM ' . tablename('egg_winner') . ' AS `w` JOIN ' . tablename('mc_members') . ' AS `m` ON `w`.`uid` = `m`.`uid` WHERE `rid` = :rid ORDER BY `w`.`id` DESC LIMIT 20'; $otherAward = pdo_fetchall($sql, array(':rid' => $params[':rid'])); // 分享信息 $shareTitle = empty($egg['title']) ? '砸蛋抽奖' : $egg['title']; $shareDesc = $egg['description']; $shareImage = tomedia($egg['picture']); include $this->template('lottery'); }
public function doMobileOauthuserinfo() { global $_W, $_GPC; load()->model('mc'); // 假设当前应用必需会员头像 $avatar = ''; // 1 如果是会员(存在 uid),从会员信息中获取 if (!empty($_W['member']['uid'])) { $member = mc_fetch($_W['member']['uid']); if (!empty($member)) { $avatar = $member['avatar']; } } // 2 如果存在 fans 记录, 从 fans 中获取 if (empty($avatar)) { $fan = mc_fansinfo($_W['openid']); if (!empty($fan) && !empty($fan['tag'])) { $avatar = $fan['tag']['avatar']; } } //3 最后调用网页授权, 如果有权限 if (empty($avatar)) { if (!empty($_W['oauth_account'])) { $userinfo = mc_oauth_userinfo(); if (is_error($userinfo)) { // you code here message($ret['message']); } else { $avatar = $userinfo['tag']['avatar']; } } else { mc_require($_W['uid'], array('avatar')); } } echo "<img src='{$avatar}'>"; }
public function doMobileLottery() { global $_GPC, $_W; $title = '打气球送积分'; $useragent = addslashes($_SERVER['HTTP_USER_AGENT']); if (strpos($useragent, 'MicroMessenger') === false && strpos($useragent, 'Windows Phone') === false) { //message('请使用微信客户端进入打气球吧!'); } checkauth(); load()->model('mc'); mc_require($_W['member']['uid'], array('realname', 'mobile'), '需要完善资料后才能打气球.'); $fromuser = $_W['fans']['from_user']; //$profile = fans_require($fromuser, array('realname', 'mobile', 'qq'), '需要完善资料后才能打气球.'); $id = intval($_GPC['id']); $dqq = pdo_fetch("SELECT id, maxlottery, default_tips, rule FROM " . tablename('dqq_reply') . " WHERE rid = '{$id}' LIMIT 1"); if (empty($dqq)) { message('非法访问,请重新发送消息进入打气球页面!'); } $total = pdo_fetchcolumn("SELECT COUNT(*) FROM " . tablename('dqq_winner') . " WHERE createtime > '" . strtotime(date('Y-m-d')) . "' AND from_user = '******' "); $member = fans_search($fromuser); $myaward = pdo_fetchall("SELECT award, description FROM " . tablename('dqq_winner') . " WHERE from_user = '******' AND rid = '{$id}' ORDER BY createtime DESC"); $sql = "SELECT a.award, b.realname FROM " . tablename('dqq_winner') . " AS a\r\n\t\t\t\t LEFT JOIN " . tablename('mc_mapping_fans') . " f on f.openid = a.from_user\r\n LEFT JOIN " . tablename('mc_members') . " b ON b.uid = f.uid WHERE b.mobile <> '' AND b.realname <> '' AND a.rid = '{$id}' ORDER BY a.createtime DESC LIMIT 20"; $otheraward = pdo_fetchall($sql); include $this->template('lottery'); }
public function doMobilePtjperfect() { //这个操作被定义用户 呈现用户完善信息的页面 global $_W, $_GPC; require_once 'sms.php'; load()->model('mc'); load()->func('tpl'); $avatar = ''; $openid = $_W['openid']; $count = 0; $uid = $_W['member']['uid']; if (!empty($_W['member']['uid'])) { $member = mc_fetch(intval($_W['member']['uid']), array('avatar', 'nickname')); if (!empty($member)) { $avatar = $member['avatar']; $nickname = $member['nickname']; } } if (empty($avatar)) { $fan = mc_fansinfo($_W['openid']); if (!empty($fan)) { $avatar = $fan['avatar']; } } if (empty($avatar)) { $userinfo = mc_oauth_userinfo(); if (!is_error($userinfo) && !empty($userinfo) && is_array($userinfo) && !empty($userinfo['avatar'])) { $avatar = $userinfo['avatar']; $nickname = $userinfo['nickname']; } } if (empty($avatar) && !empty($_W['member']['uid'])) { $avatar = mc_require($_W['member']['uid'], array('avatar')); } if (empty($avatar)) { // 提示用户关注公众号。; //echo "最终没有获取到头像,follow: {$_W['fans']['follow']}"; } else { $src = $avatar; } //////////////////////////////////////mc调用结束//////////////////////////// $sms = json_decode($sms, true); if ($_GPC['tel'] and $_GPC['verify'] !== 'ing') { //对TEL进行动态正则匹配 $tel = $_GPC['tel']; $t = preg_match('/^1[34578]\\d{9}$/', $tel); if ($t) { //给前端号码 $tel = $_GPC['tel']; message('tel_success'); } else { message('tel_fail'); } } if ($_GPC['verify'] === 'ing') { //开始构造短信信息 $statusStr = array("0" => "POSTED", "-1" => "参数不全", "-2" => "服务器空间不支持,请确认支持curl或者fsocket,联系您的空间商解决或者更换空间!", "30" => "密码错误", "40" => "账号不存在", "41" => "余额不足", "42" => "帐户已过期", "43" => "IP地址限制", "50" => "内容含有敏感词"); $smsapi = "http://api.smsbao.com/"; //$user = "******"; //短信平台帐号 $user = $sms['sms_account']; //$pass = md5("wa7plus"); //短信平台密码 $pass = md5($sms['sms_password']); $m_content = substr(time(), -4, 4); //要发送的短信内容 $time = 1; $content = "【老司机】" . "您的验证码为: {$m_content}," . "在{$time}分钟内有效---{$_W['account']['name']}"; $phone = $_GPC['tel']; //要发送短信的手机号码 $sendurl = $smsapi . "sms?u=" . $user . "&p=" . $pass . "&m=" . $phone . "&c=" . urlencode($content); $result = file_get_contents($sendurl); $msg = $statusStr[$result]; $resarr = array("msg" => $msg, "content" => $m_content); $res = json_encode($resarr); message($res); } $name = $_GPC['name']; $phone = $_GPC['phone']; $openid = $_W['openid']; if (isset($name) && isset($phone)) { pdo_insert('ptj_profile', array('name' => $name, 'phone' => $phone, 'sure' => 1, 'openid' => $openid)); } include $this->template('perfect'); }
public function doMobileLottery() { global $_GPC, $_W; if (empty($_W['fans']['from_user'])) { message('非法访问,请重新发送消息进入砸蛋页面!'); } $fromuser = $_W['fans']['from_user']; checkauth(); load()->model('mc'); mc_require($_W['member']['uid'], array('realname', 'mobile', 'qq'), '需要完善资料后才能砸蛋.'); $id = intval($_GPC['id']); $egg = pdo_fetch("SELECT * FROM " . tablename('egg_reply') . " WHERE rid = '{$id}' LIMIT 1"); if (empty($egg)) { message('非法访问,请重新发送消息进入砸蛋页面!'); } $total = pdo_fetchcolumn("SELECT COUNT(*) FROM " . tablename('egg_winner') . " WHERE createtime > '" . strtotime(date('Y-m-d')) . "' AND from_user = '******' AND status <> 3 AND award <> ''"); $member = fans_search($fromuser); $myaward = pdo_fetchall("SELECT award, description FROM " . tablename('egg_winner') . " WHERE from_user = '******' AND award <> '' AND rid = '{$id}' ORDER BY createtime DESC"); $sql = "SELECT a.award, b.realname FROM " . tablename('egg_winner') . " a LEFT JOIN " . tablename('mc_mapping_fans') . " f on f.openid = a.from_user\r\n\t\t\t\tLEFT JOIN " . tablename('mc_members') . " b ON b.uid = f.uid WHERE b.mobile <> '' AND b.realname <> '' AND a.award <> '' AND a.rid = '{$id}'\r\n\t\t\t\tORDER BY a.createtime DESC LIMIT 20"; $otheraward = pdo_fetchall($sql); // 分享信息 $shareTitle = '砸蛋抽奖'; $shareDesc = $egg['description']; $shareLink = $_W['siteroot'] . 'app' . ltrim($this->createMobileUrl('lottery', array('id' => $id, 'share' => 1)), '.'); $shareImage = tomedia($egg['picture']); include $this->template('lottery'); }
public function doMobileInfo() { global $_GPC, $_W; $title = '摇骰子抽奖'; $id = intval($_GPC['id']); $fromuser = $_W['fans']['from_user']; $sql = "SELECT COUNT(*) FROM " . tablename('bbb_user') . " WHERE from_user = '******' and rid=" . $id; $isuser = pdo_fetchcolumn($sql); //用户不存在,就插入 if (!$isuser) { $bbb_user = array('rid' => $id, 'count' => 0, 'points' => 0, 'from_user' => $fromuser, 'createtime' => TIMESTAMP); pdo_insert('bbb_user', $bbb_user); } load()->model('mc'); $profile = mc_require($_W['member']['uid'], array('nickname', 'mobile'), '需要完善资料后才能摇骰子.'); $bbb = pdo_fetch("SELECT * FROM " . tablename('bbb_reply') . " WHERE rid = '{$id}' LIMIT 1"); $bbb['descriptions'] = str_replace("\r", "", $bbb['description']); $bbb['descriptions'] = str_replace("\n", "", $bbb['descriptions']); if (empty($bbb)) { message('非法访问,请重新发送消息进入摇骰子页面!'); } $bbb['description'] = str_replace("\n", "", $bbb['description']); $bbb['description'] = str_replace("\r", "", $bbb['description']); $sql = "SELECT COUNT(*) FROM " . tablename('bbb_winner') . " WHERE createtime > '" . strtotime(date('Y-m-d')) . "' AND from_user = '******' and rid=" . $id; $totals = pdo_fetchcolumn($sql); $myuser = pdo_fetch("SELECT id,points,count FROM " . tablename('bbb_user') . " WHERE from_user = '******' AND rid=" . $id); $arr_times = $this->get_today_times($totals, $bbb['maxlottery'], $bbb['prace_times'], $myuser['count']); include $this->template('info'); }