public function receive() { global $_W; $type = $this->message['type']; //这里定义此模块进行消息订阅时的, 消息到达以后的具体处理过程, 请查看WORMWOOD文档来编写你的代码 if ($type != "text" && $type != "image" && $type != "voice") { return; } $file = IA_ROOT . '/source/modules/mechat/function.php'; if (!file_exists($file)) { return array(); } include_once $file; $sql = "SELECT * FROM " . tablename($this->tablename) . " WHERE `weid`=:weid"; $row = pdo_fetch($sql, array(':weid' => $_W['weid'])); if ($row) { $pdata = array("ToUserName" => $this->message['tousername'], "FromUserName" => $this->message['fromusername'], "CreateTime" => $this->message['createtime'], "MsgType" => $this->message['msgtype'], "Content" => $this->message['content'], "MsgId" => $this->message['msgid']); if ($type == "voice") { $pdata["MsgType"] = "text"; $pdata["Content"] = "系统:微信公众号粉丝发送语音消息,系统暂不能接收请客服处理。"; } $dat = array('unit' => $row["name"], 'msg' => json_encode($pdata)); $dat2 = iunserializer($row["cdata"]); $actoken = account_mechat_token(array("weid" => $_W['weid'], "access_token" => $dat2["access_token"], "appid" => $dat2["appid"], "appsecret" => $dat2["appsecret"])); $url = sprintf($this->gateway['mechat_receive'], $actoken); $content = ihttp_post($url, $dat); } }
public function respond() { global $_W; $content = $this->message['content']; $reply = pdo_fetch('SELECT * FROM ' . tablename('cover_reply') . ' WHERE `rid`=:rid', array(':rid' => $this->rule)); if (!empty($reply)) { load()->model('module'); $module = module_fetch($reply['module']); if (empty($module) && !in_array($reply['module'], array('site', 'mc', 'card'))) { return ''; } $url = $reply['url']; if (empty($reply['url'])) { $entry = pdo_fetch("SELECT eid FROM " . tablename('modules_bindings') . " WHERE module = :module AND do = :do", array(':module' => $reply['module'], ':do' => $reply['do'])); $url = url('entry', array('eid' => $entry['eid'])); } if (!strexists($url, '&j=') && !empty($_W['acid'])) { $url = str_replace("?i={$_W['uniacid']}&", "?i={$_W['uniacid']}&j={$_W['acid']}&", $url); } $news = array(); $news[] = array('title' => $reply['title'], 'description' => $reply['description'], 'picurl' => $reply['thumb'], 'url' => $url); return $this->respNews($news); } return ''; }
public function respond() { global $_W; $content = $this->message['content']; $foods = pdo_fetchall("SELECT * FROM " . tablename('jufeng_wcy_foods') . " WHERE weid = '{$_W['uniacid']}' AND title LIKE '%{$content}%' "); $pcate = pdo_fetchall("SELECT * FROM " . tablename('jufeng_wcy_category') . " WHERE weid = '{$_W['uniacid']}' AND parentid = '0' AND name LIKE '%{$content}%' "); $news[] = array('title' => '在线订餐', 'description' => '方便快捷,价格优惠', 'picurl' => '../addons/jufeng_wcy/images/dc.jpg', 'url' => $this->createMobileUrl('dianjia')); $foodsnum = count($foods); $pcatenum = count($pcate); if ($foodsnum == 0 && $pcatenum == 0) { $news[] = array('title' => '直接回复你想吃的,可搜索菜品和餐馆哦'); $news[] = array('title' => '没有关于【' . $content . '】的菜品或餐馆'); } if ($pcatenum < 9) { $printnum = $pcatenum; } else { $printnum = 9; } for ($i = 0; $i < $printnum; $i++) { $news[] = array('title' => "【" . $pcate[$i]['name'] . "】——" . "热度:" . $pcate[$i]['total'], 'description' => "", 'picurl' => $_W['attachurl'] . $pcate[$i]['thumb'], 'url' => $this->createMobileUrl('list', array('pcate' => $pcate[$i]['id']))); } $printnum = 9 - $printnum; if ($foodsnum < $printnum) { $printnum = $foodsnum; } for ($i = 0; $i < $printnum; $i++) { $dianjia = pdo_fetch("SELECT * FROM " . tablename('jufeng_wcy_category') . " WHERE weid = '{$_W['uniacid']}' AND id = '{$foods[$i]['pcate']}'"); $news[] = array('title' => "【" . $foods[$i]['title'] . "】——" . $dianjia['name'], 'description' => "菜品热度:" . $foods[$i]['hits'], 'picurl' => $_W['attachurl'] . $foods[$i]['thumb'], 'url' => $this->createMobileUrl('list', array('pcate' => $foods[$i]['pcate']))); } return $this->respNews($news); }
public function fieldsFormDisplay($rid = 0) { //要嵌入规则编辑页的自定义内容,这里 $rid 为对应的规则编号,新增时为 0 global $_W; $reply = pdo_fetch("SELECT * FROM " . tablename('game2048_reply') . " WHERE rid = :rid", array(':rid' => $rid)); include $this->template('form'); }
function site_category($params = array()) { global $_GPC, $_W; extract($params); if (!isset($parentid)) { $condition = ""; } else { $condition = " AND parentid = '{$parentid}'"; } $category = array(); $result = pdo_fetchall("SELECT * FROM " . tablename('article_category') . " WHERE weid = '{$_W['weid']}' {$condition} ORDER BY parentid ASC, displayorder ASC, id ASC "); if (!isset($parentid)) { if (!empty($result)) { foreach ($result as $row) { if (empty($row['parentid'])) { $category[$row['id']] = $row; } else { $category[$row['parentid']]['children'][$row['id']] = $row; } } } } else { $category = $result; } return $category; }
public function respond() { global $_W; $rid = $this->rule; $sql = "SELECT id FROM " . tablename('news_reply') . " WHERE `rid`=:rid AND parentid = 0 ORDER BY RAND()"; $main = pdo_fetch($sql, array(':rid' => $rid)); if (empty($main['id'])) { return array(); } $sql = "SELECT * FROM " . tablename('news_reply') . " WHERE id = :id OR parentid = :parentid ORDER BY parentid ASC, id ASC LIMIT 8"; $commends = pdo_fetchall($sql, array(':id'=>$main['id'], ':parentid'=>$main['id'])); $news = array(); foreach($commends as $c) { $row = array(); $row['title'] = $c['title']; $row['description'] = $c['description']; !empty($c['thumb']) && $row['picurl'] = $_W['attachurl'] . trim($c['thumb'], '/'); $row['url'] = empty($c['url']) ? $_W['siteroot'] . create_url('index/module', array('do' => 'detail', 'name' => 'news', 'id' => $c['id'])) : $c['url']; $news[] = $row; } $r['FromUserName'] = $this->message['to']; $r['ToUserName'] = $this->message['from']; $r['MsgType'] = 'news'; $r['ArticleCount'] = count($news); $r['Articles'] = array(); foreach ($news as $row) { $r['Articles'][] = array( 'Title' => $row['title'], 'Description' => $row['description'], 'PicUrl' => $row['picurl'], 'Url' => $row['url'], 'TagName' => 'item', ); } return $r; }
function site_article($params = array()) { global $_GPC, $_W; extract($params); $pindex = max(1, intval($_GPC['page'])); $psize = 20; $result = array(); $condition = " WHERE weid = '{$_W['weid']}'"; if (!empty($cid)) { $category = pdo_fetch("SELECT parentid FROM " . tablename('category') . " WHERE id = '{$cid}'"); if (!empty($category['parentid'])) { $condition .= " AND ccate = '{$cid}'"; } else { $condition .= " AND pcate = '{$cid}'"; } } if ($iscommend == 'true') { $condition .= " AND iscommend = '1'"; } if ($ishot == 'true') { $condition .= " AND ishot = '1'"; } $sql = "SELECT * FROM " . tablename('article') . $condition . ' ORDER BY displayorder DESC, id DESC'; $result['list'] = pdo_fetchall($sql . " LIMIT " . ($pindex - 1) * $psize . ',' . $psize); $total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('article') . $condition); $result['pager'] = pagination($total, $pindex, $psize); if (!empty($result['list'])) { foreach ($result['list'] as &$row) { $row['url'] = create_url('mobile/module/hdetail', array('name' => 'shouse', 'id' => $row['id'], 'weid' => $_W['weid'])); } } return $result; }
private function getMember() { global $_W; $sql = 'SELECT `lastupdate`, `isblacklist`, `rid` FROM ' . tablename('wxwall_members') . ' WHERE `from_user` = :from_user AND `rid` = :rid'; $params = array(':from_user' => $_W['openid'], ':rid' => $this->rule); $member = pdo_fetch($sql, $params); // 获取粉丝头像 $account = WeAccount::create($_W['acid']); $fansInfo = $account->fansQueryInfo($_W['openid']); if (empty($member)) { $member = array('from_user' => $_W['openid'], 'rid' => $this->rule, 'isjoin' => 1, 'lastupdate' => TIMESTAMP, 'isblacklist' => 0); if (!is_error($fansInfo)) { $member['avatar'] = rtrim($fansInfo['headimgurl'], '0') . '132'; } pdo_insert('wxwall_members', $member); } else { if (!is_error($fansInfo)) { $member['avatar'] = rtrim($fansInfo['headimgurl'], '0') . '132'; } $member['lastupdate'] = TIMESTAMP; $params = array('from_user' => $_W['openid'], 'rid' => $this->rule); pdo_update('wxwall_members', $member, $params); } return $member; }
public function respond() { global $_W; $content = $this->message['content']; //这里定义此模块进行消息处理时的具体过程, 请查看WORMWOOD文档来编写你的代码 $isfill = pdo_fetchcolumn("SELECT isfill FROM " . tablename('feng_testingreply') . " WHERE rid =:rid AND testingid = '0'", array(':rid' => $this->rule)); $reply = pdo_fetchall("SELECT * FROM " . tablename('feng_testingreply') . " WHERE rid = :rid", array(':rid' => $this->rule)); if (!empty($reply)) { foreach ($reply as $row) { $ids[$row['testingid']] = $row['testingid']; } $article = pdo_fetchall("SELECT id,title,photo,smalltext FROM " . tablename('feng_testing') . " WHERE id IN (" . implode(',', $ids) . ")", array(), 'id'); } if ($isfill && ($count = 8 - count($reply)) > 0) { $articlefill = pdo_fetchall("SELECT id,title,photo,smalltext FROM " . tablename('feng_testing') . " WHERE weid = '{$_W['weid']}' AND id NOT IN (" . implode(',', $ids) . ") ORDER BY id DESC LIMIT {$count}", array(), 'id'); if (!empty($articlefill)) { foreach ($articlefill as $row) { $article[$row['id']] = $row; $reply[]['testingid'] = $row['id']; } unset($articlefill); } } if (!empty($reply)) { $response = array(); foreach ($reply as $row) { $row = $article[$row['testingid']]; if (!empty($row)) { $response[] = array('title' => $row['title'], 'description' => $row['description'], 'picurl' => $row['thumb'], 'url' => $this->buildSiteUrl($this->createMobileUrl('detail', array('id' => $row['id'])))); } } } return $this->respNews($response); }
function __buildSiteUrl($url) { global $_W, $engine; $mapping = array('[from]' => $engine->message['from'], '[to]' => $engine->message['to'], '[uniacid]' => $_W['uniacid']); $url = str_replace(array_keys($mapping), array_values($mapping), $url); $pass = array(); $pass['openid'] = $engine->message['from']; $pass['acid'] = $_W['acid']; $sql = 'SELECT `fanid`,`salt`,`uid` FROM ' . tablename('mc_mapping_fans') . ' WHERE `acid`=:acid AND `openid`=:openid'; $params = array(); $params[':acid'] = $_W['acid']; $params[':openid'] = $pass['openid']; $fan = pdo_fetch($sql, $params); if (empty($fan) || !is_array($fan) || empty($fan['salt'])) { $fan = array('salt' => ''); } $pass['time'] = TIMESTAMP; $pass['hash'] = md5("{$pass['openid']}{$pass['time']}{$fan['salt']}{$_W['config']['setting']['authkey']}"); $auth = base64_encode(json_encode($pass)); $vars = array(); $vars['uniacid'] = $_W['uniacid']; $vars['__auth'] = $auth; $vars['forward'] = base64_encode($url); return $_W['siteroot'] . 'app/' . url('auth/forward', $vars); }
public function fieldsFormSubmit($rid) { //规则验证无误保存入库时执行,这里应该进行自定义字段的保存。这里 $rid 为对应的规则编号 global $_GPC, $_W; $currentprompt = trim($_GPC['currentprompt']) ? trim($_GPC['currentprompt']) : '当前数字是 {LUCKYNUM}!'; $awardprompt = trim($_GPC['awardprompt']) ? trim($_GPC['awardprompt']) : '恭喜您,当前数字是 {LUCKYNUM},获得 {AWARD} 奖品!'; $data = array('rid' => $rid, 'uniacid' => $_W['uniacid'], 'luckynumstart' => $_GPC['luckynumstart'], 'luckynumfilter' => $_GPC['luckynumfilter'], 'show_instruction' => $_GPC['show_instruction'], 'time_instruction' => $_GPC['time_instruction'], 'limit_instruction' => $_GPC['limit_instruction'], 'end_instruction' => $_GPC['end_instruction'], 'awardnum_instruction' => $_GPC['awardnum_instruction'], 'award_instruction' => $_GPC['award_instruction'], 'starttime' => strtotime($_GPC['datelimit']['start']), 'endtime' => strtotime($_GPC['datelimit']['end']), 'limittype' => $_GPC['limittype'], 'awardnum' => $_GPC['awardnum'], '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'], 'currentprompt' => $currentprompt, 'awardprompt' => $awardprompt, 'sponsors1' => $_GPC['sponsors1'], 'sponsors1link' => $_GPC['sponsors1link'], 'sponsors2' => $_GPC['sponsors2'], 'sponsors2link' => $_GPC['sponsors2link'], 'sponsors3' => $_GPC['sponsors3'], 'sponsors3link' => $_GPC['sponsors3link'], 'sponsors4' => $_GPC['sponsors4'], 'sponsors4link' => $_GPC['sponsors4link'], 'sponsors5' => $_GPC['sponsors5'], 'sponsors5link' => $_GPC['sponsors5link'], 'ruletext' => $_GPC['ruletext'], 'title' => $_GPC['title'], 'shareimg' => $_GPC['shareimg'], 'sharetitle' => $_GPC['sharetitle'], 'sharedesc' => $_GPC['sharedesc']); $id = pdo_fetchcolumn("SELECT id FROM " . tablename('stonefish_luckynum') . " WHERE rid = :rid", array(':rid' => $rid)); //if ($_GPC['shouquan']==$_GPC['we7_ValidCode_server']){ if (empty($id)) { $data['isshow'] = 1; pdo_insert('stonefish_luckynum', $data); } else { pdo_update('stonefish_luckynum', $data, array('id' => $id)); } //} //update if (!empty($_GPC['award_number'])) { foreach ($_GPC['award_number'] as $key => $val) { $update_data = array('numbers' => $_GPC['award_number'][$key], 'title' => $_GPC['award_title'][$key], 'description' => $_GPC['award_desc'][$key]); //if ($_GPC['shouquan']==$_GPC['we7_ValidCode_server']){ pdo_update($this->tablename, $update_data, array('id' => $key)); //} } } //insert if (!empty($_GPC['newaward_number'])) { foreach ($_GPC['newaward_number'] as $key => $val) { $new_data = array('rid' => $rid, 'uniacid' => $_W['uniacid'], 'numbers' => $_GPC['newaward_number'][$key], 'title' => $_GPC['newaward_title'][$key], 'description' => $_GPC['newaward_desc'][$key], 'dateline' => $_W['timestamp']); //if ($_GPC['shouquan']==$_GPC['we7_ValidCode_server']){ pdo_insert($this->tablename, $new_data); //} } } }
public function respond() { global $_W; $rid = $this->rule; $sql = "SELECT title,description,start_picurl,isshow,starttime,endtime,end_theme,end_instruction,end_picurl FROM " . tablename('smashegg_reply') . " WHERE `rid`=:rid LIMIT 1"; $row = pdo_fetch($sql, array(':rid' => $rid)); if ($row == false) { return array(); } if ($row['isshow'] == 0) { return array(); } if ($row['endtime'] < time()) { if (substr($row['end_picurl'], 0, 7) == "http://") { $picurl = $row['end_picurl']; } else { $picurl = $_W['siteroot'] . trim($row['end_picurl'], '/'); } return $this->respNews(array('Title' => $row['end_theme'], 'Description' => $row['end_instruction'], 'PicUrl' => $picurl, 'Url' => $this->createMobileUrl('index', array('id' => $rid)))); } else { if (substr($row['start_picurl'], 0, 7) == "http://") { $picurl = $row['start_picurl']; } else { $picurl = $_W['siteroot'] . trim($row['start_picurl'], '/'); } return $this->respNews(array('Title' => $row['title'], 'Description' => $row['description'], 'PicUrl' => $picurl, 'Url' => $this->createMobileUrl('index', array('id' => $rid)))); } }
private function reply_kaquanDetail($card_id) { $sql = "SELECT card_detail FROM " . tablename($this->tb_cards) . " WHERE card_id = :card_id"; $param[':card_id'] = $card_id; $card_detail = pdo_fetch($sql, $param); return $card_detail['card_detail']; }
public function fieldsFormSubmit($rid) { global $_GPC, $_W; $id = intval($_GPC['reply_id']); $insert = array('rid' => $rid, 'weid' => $this->weid, 'title' => $_GPC['title'], 'kptime' => strtotime($_GPC['kptime']), 'rztime' => strtotime($_GPC['rztime']), 'kfs' => $_GPC['kfs'], 'price' => $_GPC['price'], 'lpaddress' => $_GPC['lpaddress'], 'sltel' => $_GPC['sltel'], 'zxtel' => $_GPC['zxtel'], 'news_title' => $_GPC['news_title'], 'news_icon' => $_GPC['news_icon'], 'news_content' => $_GPC['news_content'], 'share_title' => $_GPC['share_title'], 'share_icon' => $_GPC['share_icon'], 'share_content' => $_GPC['share_content'], 'order_title' => $_GPC['order_title'], 'order_remark' => $_GPC['order_remark'], 'cover_img' => $_GPC['cover_img'], 'overview_img' => $_GPC['overview_img'], 'intro_img' => $_GPC['intro_img'], 'dt_img' => $_GPC['dt_img'], 'dt_intro' => htmlspecialchars_decode($_GPC['dt_intro']), 'intro' => htmlspecialchars_decode($_GPC['intro']), 'createtime' => TIMESTAMP); if (empty($id)) { $id = pdo_insert($this->table_hosue, $insert); } else { pdo_update($this->table_hosue, $insert, array('id' => $id)); } ///说明项处理 $house_ids = $_GPC['house_ids']; $house_names = $_GPC['house_iname']; $house_conents = $_GPC['house_icontent']; $house_sorts = $_GPC['house_sort']; pdo_query("delete from " . tablename($this->table_house_item) . " where hid=:hid", array(":hid" => $id)); if (is_array($house_ids)) { foreach ($house_ids as $key => $value) { $value = intval($value); $d = array("rid" => $rid, "hid" => $id, "iname" => $house_names[$key], "icontent" => $house_conents[$key], "sort" => $house_sorts[$key]); pdo_insert($this->table_house_item, $d); } } return true; }
public function respond() { global $_W; load()->func('compat.biz'); $rid = $this->rule; $sql = "SELECT * FROM " . tablename('bm_top_reply') . " WHERE `rid`=:rid LIMIT 1"; $row = pdo_fetch($sql, array(':rid' => $rid)); if (empty($row['id'])) { return $this->respText("系统升级中,请稍候!"); } $desc = $row['desc']; //描述 $n = $row['n']; //粉丝基数 $fromuser = $this->message['from']; $num = mc_fansinfo($fromuser); $numx = $n + $num['fanid']; $name = $_W['account']['name']; //公众号名称 $str = str_replace('{name}', $name, $desc); $str = str_replace('{numx}', $numx, $str); if ($row['pictype'] == 1) { //$str = "嗨,欢迎关注【".$name."】,您是第".$numx."位关注人!\n".$desc."\n <a href='".$url."'>".$urltext."</a>"; return $this->respText($str); } else { $response['FromUserName'] = $this->message['to']; $response['ToUserName'] = $this->message['from']; $response['MsgType'] = 'news'; $response['ArticleCount'] = 1; $response['Articles'] = array(); $response['Articles'][] = array('Title' => $row['title'], 'Description' => $str, 'PicUrl' => !strexists($row['picurl'], 'http://') ? $_W['attachurl'] . $row['picurl'] : $row['picurl'], 'Url' => $row['urlx'], 'TagName' => 'item'); return $response; } }
public function getCategory() { global $_W; $shopset = m('common')->getSysset('shop'); $allcategory = array(); $category = pdo_fetchall("SELECT * FROM " . tablename('ewei_shop_category') . " WHERE uniacid=:uniacid and enabled=1 ORDER BY parentid ASC, displayorder DESC", array(':uniacid' => $_W['uniacid'])); $category = set_medias($category, array('thumb', 'advimg')); foreach ($category as $c) { if (empty($c['parentid'])) { $children = array(); foreach ($category as $c1) { if ($c1['parentid'] == $c['id']) { if (intval($shopset['catlevel']) == 3) { $children2 = array(); foreach ($category as $c2) { if ($c2['parentid'] == $c1['id']) { $children2[] = $c2; } } $c1['children'] = $children2; } $children[] = $c1; } } $c['children'] = $children; $allcategory[] = $c; } } return $allcategory; }
public function doMobileshow() { global $_W, $_GPC; $rid = $_GPC['id']; $sql = "SELECT * FROM " . tablename($this->tablename_log) . " WHERE `rid`=:rid"; $info = pdo_fetchall($sql, array(':rid' => $rid)); $sql = "SELECT * FROM " . tablename($this->tablename) . " WHERE `rid`=:rid LIMIT 1"; $quiz = pdo_fetch($sql, array(':rid' => $rid)); $sql = "SELECT * FROM " . tablename($this->tablename_question) . " WHERE `id`=:id"; $q = pdo_fetch($sql, array(':id' => $quiz['qid'])); //var_dump($q); $arr = array(); foreach ($info as $key => $value) { $arr[] = $info[$key]['chk_answer']; } $per = array_count_values($arr); ksort($per); //var_dump($per); $total_count = sizeof($info); $config = $this->get_config($q); //foreach($per as $key => $value){ //$str .= '选项'.$key.'次数'.$value; //} //var_dump($str); //var_dump($per); include $this->template('show'); }
private function getShowID() { global $_W; $sql = 'select showID from ' . tablename('ice_picWallMain') . ' where uniacid = :uniacid order by showID DESC'; $result = pdo_fetchcolumn($sql, array('uniacid' => $_W['uniacid']), 0) + 1; return $result; }
public function getGroupName($uid = 0) { $uid = $uid ?: v('user.uid'); $sql = "SELECT title,id FROM " . tablename('member') . " m JOIN " . tablename('member_group') . " g ON m.group_id = g.id WHERE m.uid={$uid}"; $d = Db::query($sql); return $d ? $d[0] : NULL; }
/** * 获取单条用户信息,如果查询参数多于一个字段,则查询满足所有字段的用户 * PS:密码字段不要加密 * @param array $member 要查询的用户字段,可以包括 uid, username, password, status * @param bool 是否要同时获取状态信息 * @return array 完整的用户信息 */ function member_single($member) { $sql = 'SELECT * FROM ' . tablename('members') . " WHERE 1"; $params = array(); if (!empty($member['uid'])) { $sql .= ' AND `uid`=:uid'; $params[':uid'] = intval($member['uid']); } if (!empty($member['username'])) { $sql .= ' AND `username`=:username'; $params[':username'] = $member['username']; } if (!empty($member['email'])) { $sql .= ' AND `email`=:email'; $params[':email'] = $member['email']; } if (!empty($member['status'])) { $sql .= " AND `status`=:status"; $params[':status'] = intval($member['status']); } $sql .= " LIMIT 1"; $record = pdo_fetch($sql, $params); if (!$record) { return false; } if (!empty($member['password'])) { $password = member_hash($member['password'], $record['salt']); if ($password != $record['password']) { return false; } } return $record; }
public function doWebWelcome() { global $_W; $sql = 'select pretype,count(*) as num from ' . tablename('chips'); $sql .= ' where projguid=:projguid and deleted=0 group by pretype '; $cnt = pdo_fetchall($sql, array(':projguid' => $_W['project']['projguid']), 'pretype'); $status = array(0 => '登记', 1 => '付款', 2 => '无交款'); $count = array(0 => 0); foreach ($status as $k => $v) { $count[$k + 1] = 0; if (isset($cnt[$k])) { $count[$k + 1] = $cnt[$k]['num']; } $count[0] += $count[$k]; } // 诚意金统计 $sql = "select count(*) as num, sum(premoney) as total from " . tablename('chips'); $sql .= ' where premoney>0 and projguid=:projguid and deleted=0'; $premoney = pdo_fetch($sql, array(':projguid' => $_W['project']['projguid'])); // 认购统计 $sql = "select count(*) as num, coalesce(SUM(ordermoney),0) as total from " . tablename('chips'); $sql .= ' where ordermoney>0 and projguid=:projguid and deleted=0'; $ordermoney = pdo_fetch($sql, array(':projguid' => $_W['project']['projguid'])); include $this->template('welcome'); }
public function doMobileIndex() { global $_W, $_GPC; $sql = "select * from" . tablename('chax') . "where weid='{$_W['weid']}' and status =1"; $navs = pdo_fetchall($sql); include $this->template('index'); }
public function respond() { global $_W; $rid = $this->rule; $sql = "SELECT * FROM " . tablename('news_reply') . " WHERE rid = :id AND parent_id = -1 ORDER BY displayorder DESC, id ASC LIMIT 8"; $commends = pdo_fetchall($sql, array(':id' => $rid)); if (empty($commends)) { $sql = "SELECT * FROM " . tablename('news_reply') . " WHERE rid = :id AND parent_id = 0 ORDER BY RAND()"; $main = pdo_fetch($sql, array(':id' => $rid)); if (empty($main['id'])) { return false; } $sql = "SELECT * FROM " . tablename('news_reply') . " WHERE id = :id OR parent_id = :parent_id ORDER BY parent_id ASC, displayorder DESC, id ASC LIMIT 8"; $commends = pdo_fetchall($sql, array(':id' => $main['id'], ':parent_id' => $main['id'])); } if (empty($commends)) { return false; } $news = array(); foreach ($commends as $c) { $row = array(); $row['title'] = $c['title']; $row['description'] = $c['description']; !empty($c['thumb']) && ($row['picurl'] = tomedia($c['thumb'])); $row['url'] = empty($c['url']) ? $this->createMobileUrl('detail', array('id' => $c['id'])) : $c['url']; $news[] = $row; } return $this->respNews($news); }
public function respond() { if ($this->message['event'] == 'scancode_waitmsg') { $qrtype = $this->message['scancodeinfo']['scantype']; if ($qrtype == 'barcode') { $CodeInfo = $this->message['scancodeinfo']['scanresult']; $Codearr = explode(",", $CodeInfo); $Code = $Codearr['1']; } else { $Code = $this->message['scancodeinfo']['scanresult']; } } else { $rid = $this->rule; $sql = "SELECT * FROM " . tablename('rule_keyword') . " WHERE `rid`=:rid LIMIT 1"; $row = pdo_fetch($sql, array(':rid' => $rid)); $keywords = $row['content']; // 取得正则表达式 //查询防伪码 preg_match('/' . $keywords . '(.*)/', $this->message['content'], $match); $Code = $match[1]; } //return $this->respText($Code); $express = new Express(); $result = $express->getorder($Code); if ($result['status'] == '200') { $time = $result['updatetime']; foreach ($result['data'] as $trace) { $reply .= "{$trace['time']}\n{$trace['context']}\n-------\n"; } $msg = "快递单号:\n" . $Code . "\n最后更新:\n" . $time . "\n流转情况:\n" . $reply; } else { $msg = '查询失败 ' . $result['message']; } return $this->respText($msg); }
function cron_run($cronid = 0) { if (empty($cronid)) { $cron = pdo_fetch('SELECT * FROM ' . tablename('cron') . ' WHERE available > 0 AND nextrun <= ' . TIMESTAMP . ' ORDER BY nextrun ASC'); } else { $cron = pdo_fetch('SELECT * FROM ' . tablename('cron') . ' WHERE cronid = :id', array(':id' => intval($cronid))); } if (empty($cron)) { return false; } if ($cron['type'] == 'system') { //定义系统内置的计划任务文件放在哪个路径 $cronfile = IA_ROOT . '/cron/' . $cron['filename']; } elseif ($cron['type'] == 'module') { //定义模块的计划任务文件放在哪个路径 $cronfile = IA_ROOT . '/cron/' . $cron['filename']; } if (is_file($cronfile)) { $cron['minute'] = explode("\t", $cron['minute']); //设置下次执行时间 cron_setnexttime($cron); @set_time_limit(1000); //@ignore_user_abort(TRUE); if (!@(include $cronfile)) { return false; } } }
public function respond() { global $_W; load()->func('compat.biz'); $rid = $this->rule; $sql = "SELECT * FROM " . tablename('bm_qrsign_reply') . " WHERE `rid`=:rid LIMIT 1"; $reply = pdo_fetch($sql, array(':rid' => $rid)); if (empty($reply['id'])) { return $this->respText("系统升级中,请稍候!"); } if (time() > strtotime($reply['endtime'])) { if (empty($reply['memo2'])) { $msg = '对不起,活动已经于' . $reply['endtime'] . '结束,感谢您的参与!!!'; } else { $msg = $reply['memo2']; } return $this->respText($msg); } if (time() < strtotime($reply['starttime'])) { if (empty($reply['memo1'])) { $msg = '对不起,活动将于' . $reply['starttime'] . '开始,敬请期待!!!'; } else { $msg = $reply['memo1']; } return $this->respText($msg); } $url = $_W['siteroot'] . 'app/' . $this->createMobileUrl('show', array('rid' => $rid, 'from_user' => $this->message['from'])); $response['FromUserName'] = $this->message['to']; $response['ToUserName'] = $this->message['from']; $response['MsgType'] = 'news'; $response['ArticleCount'] = 1; $response['Articles'] = array(); $response['Articles'][] = array('Title' => $reply['title'], 'Description' => $reply['desc'], 'PicUrl' => !strexists($reply['picurl'], 'http://') ? $_W['attachurl'] . $reply['picurl'] : $reply['picurl'], 'Url' => $url, 'TagName' => 'item'); return $response; }
public function respond() { if ($this->rule == -1) { return $this->respCustom(); } $sql = "SELECT * FROM " . tablename('custom_reply') . " WHERE `rid` IN ({$this->rule}) ORDER BY RAND() LIMIT 1"; $reply = pdo_fetch($sql); $nhour = date('H', TIMESTAMP); $flag = 0; if ($reply['start1'] == 0 && $reply['end'] == 24) { $flag = 1; } elseif ($reply['start1'] != '-1' && $nhour >= $reply['start1'] && $nhour < $reply['end1']) { $flag = 1; } elseif ($reply['start2'] != '-1' && $nhour >= $reply['start2'] && $nhour < $reply['end2']) { $flag = 1; } if ($flag == 1) { return $this->respCustom(); } else { $content = '多客服接入时间为:' . intval($reply['start1']) . '时~' . $reply['end1'] . '时'; if ($reply['start2'] != '-1') { $content .= ',' . $reply['start2'] . '时~' . $reply['end2'] . '时'; } $reply['content'] = $content; return $this->respText($reply['content']); } }
public function respond() { global $_W, $_GPC; $rid = $this->rule; $row = pdo_fetch("SELECT * FROM " . tablename($this->reply_table) . " WHERE weid = :acid AND rid = :rid", array(':acid' => $_W['uniacid'], ':rid' => $rid)); return $this->respNews(array('title' => $row['title'], 'description' => $row['description'], 'picurl' => $row['avatar'], 'url' => $this->createMobileUrl('Index'))); }
public function fieldsFormDisplay($rid = 0) { //要嵌入规则编辑页的自定义内容,这里 $rid 为对应的规则编号,新增时为 0 global $_W; load()->func('tpl'); $reply = pdo_fetch("SELECT * FROM " . tablename('eso_runman_reply') . " WHERE rid = :rid", array(':rid' => $rid)); if (empty($reply)) { $reply['starttime'] = time(); $reply['endtime'] = time() + 2592000; $reply['setting'] = array(); } else { $reply['setting'] = string2array($reply['setting']); } $sql = "SELECT * FROM " . tablename('uni_account'); $uniaccounts = pdo_fetchall($sql); $accounts = array(); if (!empty($uniaccounts)) { foreach ($uniaccounts as $uniaccount) { $accountlist = uni_accounts($uniaccount['uniacid']); if (!empty($accountlist)) { foreach ($accountlist as $account) { if (!empty($account['key']) && !empty($account['secret']) && in_array($account['level'], array(3, 4))) { $accounts[$account['acid']] = $account['name']; } } } } } include $this->template('form'); }
public function respond() { global $_W; $rid = $this->rule; $reply = pdo_fetch("SELECT * FROM " . tablename('vote_reply') . " WHERE `rid`=:rid LIMIT 1", array(':rid' => $rid)); if ($reply == false) { return $this->respText('活动已经取消...'); } $nowtime = time(); $endtime = $reply['endtime'] + 86399; if ($reply['status'] == 0) { return $this->respText("投票已暂停,请等待..."); } if ($reply['votelimit'] == 1) { if ($reply['votetotal'] > 0 && $reply['votenum'] >= $reply['votetotal']) { return $this->respText("投票人数已满,活动结束..."); } } else { if ($reply['starttime'] > $nowtime) { return $this->respText("投票未开始,请等待..."); } elseif ($endtime < $nowtime) { return $this->respText("投票已结束..."); } else { // if ($reply['status'] != 1) { // return $this->respText("投票已暂停,请等待..."); // } } } return $this->respNews(array('Title' => $reply['title'], 'Description' => $reply['description'], 'PicUrl' => tomedia($reply['thumb']), 'Url' => $this->createMobileUrl("index", array("id" => $rid)))); }