[TOC=1,4]
### site.php 升級步驟
#### 步驟 1: 引入必要的組件文件
```
load()->Xxx('xx');
```
#### 步驟 2: 用戶身份驗證
在需要粉絲用戶或操作員身份驗證時，調用以下方法。
##### Web端 - checklogin()
在 Web 端，操作用戶登錄方可執行的頁面功能，在入口須調用 ''checklogin()''，驗證失敗，操作用戶須登錄，方可向下執行。
##### App端 - checkauth()
在 App 端，粉絲用戶登錄方可操作的頁面功能
#### 步驟 3: 數據庫操作
不要執行直接拼接的 sql 語句，請使用 ''pdo_query( $sql, $params);'' 等帶參數的方法，以防 SQL 注入漏洞。
#### 步驟 4: 讀取模塊配置信息
在模塊內部直接訪問 **$this->module['config']** 即可.
#### 0.6 代碼
可以將 site.php 中大量定義的入口方法分離單獨的文件中 **(文件名稱為小寫單詞, 如: sendmessage.inc.php )**
* doWebXxx 分離到 wxwall/inc/web/xxx.inc.php
* doMobileXxx 分離到 wxwall/inc/mobile/xxx.inc.php
如下:
```
<?php
/**
* 微信墻模塊
*
* [WeEngine System] Copyright (c) 2013 WE7.CC
*/
defined('IN_IA') or exit('Access Denied');
/**
* 微信墻內容
*/
/***************************************************
** 此文件等價于在 site.php 中定義 doWebDetail 方法.
**
** 此文件代碼可以隨意使用 WxwallModuleSite 中定義的所有方法.
**
****************************************************/
global $_GPC, $_W;
$id = intval($_GPC['id']);
$wall = $this->getWall($id);
$wall['onlinemember'] = pdo_fetchcolumn("SELECT COUNT(*) FROM ".tablename('wxwall_members')." WHERE rid = :rid ", array(':rid'=>$wall['rid']));
$list = pdo_fetchall("SELECT id, content, from_user, type, createtime FROM ".tablename('wxwall_message')." WHERE rid = :rid AND isshow = '2' AND from_user <> '' ORDER BY createtime DESC", array(':rid'=>$wall['rid']));
$this->formatMsg($list);
include $this->template('detail');
```
```
<?php
/**
* 微信墻模塊
*
* [WeEngine System] Copyright (c) 2013 WE7.CC
*/
defined('IN_IA') or exit('Access Denied');
class WxwallModuleSite extends WeModuleSite {
/**
* 微信墻內容
*/
// 未定義的 doWebDetail 方法, 等價于引用 ./addons/wxwall/inc/web/detail.inc.php 文件
// public function doWebDetail() {
// require 'inc/web/detail.inc.php';
// }
/**
* 內容管理
*/
public function doWebManage() {
global $_GPC, $_W;
checklogin();
$id = intval($_GPC['id']);
$isshow = isset($_GPC['isshow']) ? intval($_GPC['isshow']) : 0;
if (checksubmit('verify') && !empty($_GPC['select'])) {
foreach ($_GPC['select'] as &$row) {
$row = intval($row);
}
$sql = 'UPDATE '.tablename('wxwall_message')." SET isshow=1 WHERE rid=:rid AND id IN ('".implode("','", $_GPC['select'])."')";
pdo_query($sql, array(':rid' => $id));
message('審核成功！', $this->createWebUrl('manage', array('id' => $id, 'isshow'=>$isshow, 'page' => $_GPC['page'])));
}
if (checksubmit('delete') && !empty($_GPC['select'])) {
foreach ($_GPC['select'] as &$row) {
$row = intval($row);
}
$sql = 'DELETE FROM'.tablename('wxwall_message')." WHERE rid=:rid AND id IN ('".implode("','", $_GPC['select'])."')";
pdo_query($sql, array(':rid' => $id));
message('刪除成功！', $this->createWebUrl('manage', array('id' => $id, 'isshow'=>$isshow, 'page' => $_GPC['page'])));
}
$condition = '';
if($isshow == 0) {
$condition .= 'AND isshow = '.$isshow;
} else {
$condition .= 'AND isshow > 0';
}
$pindex = max(1, intval($_GPC['page']));
$psize = 20;
$wall = pdo_fetch("SELECT id, isshow, rid FROM ".tablename('wxwall_reply')." WHERE rid = '{$id}' LIMIT 1");
$list = pdo_fetchall("SELECT * FROM ".tablename('wxwall_message')." WHERE rid = '{$wall['rid']}' {$condition} ORDER BY createtime DESC LIMIT ".($pindex - 1) * $psize.",{$psize}");
if (!empty($list)) {
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('wxwall_message') . " WHERE rid = '{$wall['rid']}' {$condition}");
$pager = pagination($total, $pindex, $psize);
foreach ($list as &$row) {
if ($row['type'] == 'link') {
$row['content'] = iunserializer($row['content']);
$row['content'] = '<a href="'.$row['content']['link'].'" target="_blank" title="'.$row['content']['description'].'">'.$row['content']['title'].'</a>';
} elseif ($row['type'] == 'image') {
$row['content'] = '<img src="'.$_W['attachurl'] . $row['content'].'" />';
} else {
$row['content'] = emotion($row['content']);
}
$userids[] = $row['from_user'];
}
unset($row);
if (!empty($userids)) {
$userids = array_unique($userids);
$member = array();
load()->model('mc');
$member = mc_fetch($userids, array('nickname','avatar'));
$blacklist = pdo_fetchall("SELECT from_user, isblacklist FROM ".tablename('wxwall_members')." WHERE rid=:rid AND from_user IN ('".implode("','", $userids)."')", array(':rid'=>$id), 'from_user');
foreach ($member as $key => &$row) {
$row['isblacklist'] = $blacklist[$key]['isblacklist'];
}
unset($row);
}
}
include $this->template('manage');
}
/**
* 增量數據調用
*/
public function doWebIncoming() {
global $_GPC, $_W;
$id = intval($_GPC['id']);
$lastmsgtime = intval($_GPC['lastmsgtime']);
$sql = "SELECT id, content, from_user, type, createtime FROM ".tablename('wxwall_message')." WHERE rid = :rid ";
$params = array(':rid'=>$id);
$page = max(1, intval($_GPC['page']));
if (!empty($lastmsgtime)) {
$sql .= " AND createtime >= :createtime AND isshow > 0 ORDER BY id ASC LIMIT ".($page-1).", 1";
$params[':createtime'] = $lastmsgtime;
} else {
$sql .= " AND isshow = '1' ORDER BY createtime ASC LIMIT 1";
}
$list = pdo_fetchall($sql,$params);
if (!empty($list)) {
$this->formatMsg($list);
$row = $list[0];
pdo_update('wxwall_message', array('isshow' => '2'), array('id' => $row['id']));
$row['content'] = emotion($row['content'], '48px');
message($row, '', 'ajax');
}
}
/**
* 黑名單
*/
public function doWebBlacklist() {
global $_W, $_GPC;
$id = intval($_GPC['id']);
if (checksubmit('delete') && isset($_GPC['select']) && !empty($_GPC['select'])) {
foreach ($_GPC['select'] as &$row) {
$row = intval($row);
}
$sql = 'UPDATE ' . tablename('wxwall_members') . " SET isblacklist=0 WHERE rid=:rid AND id IN ('".implode("','", $_GPC['select'])."')";
pdo_query($sql, array(':rid'=>$id));
message('黑名單解除成功！', $this->createWebUrl('blacklist', array('id' => $id, 'page' => $_GPC['page'])));
}
if (!empty($_GPC['from_user'])) {
$isshow = isset($_GPC['isshow']) ? intval($_GPC['isshow']) : 0;
pdo_update('wxwall_members', array('isblacklist' => intval($_GPC['switch'])), array('from_user' => $_GPC['from_user'], 'rid'=>$id));
message('黑名單操作成功！', $this->createWebUrl('manage', array('id' => $id, 'isshow' => $isshow)));
}
$pindex = max(1, intval($_GPC['page']));
$psize = 20;
$list = pdo_fetchall("SELECT id, from_user, lastupdate FROM ".tablename('wxwall_members')." WHERE isblacklist = '1' AND rid=:rid ORDER BY lastupdate DESC LIMIT ".($pindex - 1) * $psize.",{$psize}", array(':rid' => $id), 'from_user');
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('wxwall_members') . " WHERE isblacklist = '1' AND rid=:rid ", array(':rid' => $id));
$pager = pagination($total, $pindex, $psize);
load()->model('mc');
$member = mc_fetch(array_keys($list), array('nickname', 'avatar'));
include $this->template('blacklist');
}
/**
* 二維碼
*/
public function doWebQrcode() {
global $_GPC, $_W;
$id = intval($_GPC['id']);
$wall = $this->getWall($id);
include $this->template('qrcode');
}
/**
* 抽獎
*/
public function doWebLottery() {
global $_GPC, $_W;
checklogin();
$id = intval($_GPC['id']);
$type = intval($_GPC['type']);
$wall = $this->getWall($id);
if ($type == 1) {
$list = pdo_fetchall("SELECT id, content, from_user, type, createtime FROM ".tablename('wxwall_message')." WHERE rid = '{$wall['rid']}' AND isshow = '2' AND from_user <> '' ORDER BY createtime DESC");
} else {
$list = pdo_fetchall("SELECT id, content, from_user, type, createtime FROM ".tablename('wxwall_message')." WHERE rid = '{$wall['rid']}' AND isshow = '2' AND from_user <> '' GROUP BY from_user ORDER BY createtime DESC LIMIT 10");
}
$this->formatMsg($list);
include $this->template('lottery');
}
/**
* 抽獎
*/
public function doWebAward() {
global $_GPC, $_W;
checklogin();
$message = pdo_fetch("SELECT * FROM ".tablename('wxwall_message')." WHERE id = :id LIMIT 1", array(':id'=>intval($_GPC['mid'])));
if (empty($message)) {
message('抱歉，參數不正確！', '', 'error');
}
$data = array(
'rid' => $message['rid'],
'from_user' => $message['from_user'],
'createtime' => TIMESTAMP,
'status' => 0,
);
pdo_insert('wxwall_award', $data);
message('', '', 'success');
}
/**
* 中獎列表
*/
public function doWebAwardlist() {
global $_GPC, $_W;
checklogin();
$id = intval($_GPC['id']);
if (checksubmit('delete') && !empty($_GPC['select'])) {
pdo_delete('wxwall_award', " id IN ('".implode("','", $_GPC['select'])."')");
message('刪除成功！', $this->createWebUrl('awardlist', array('id' => $id, 'page' => $_GPC['page'])));
}
if (!empty($_GPC['wid'])) {
$wid = intval($_GPC['wid']);
pdo_update('wxwall_award', array('status' => intval($_GPC['status'])), array('id' => $wid));
message('標識領獎成功！', $this->createWebUrl('awardlist', array('id' => $id, 'page' => $_GPC['page'])));
}
$pindex = max(1, intval($_GPC['page']));
$psize = 20;
$sql = "SELECT * FROM ".tablename('wxwall_award')." WHERE rid = :rid ORDER BY status ASC LIMIT ".($pindex - 1) * $psize.",{$psize}";
$list = pdo_fetchall($sql, array(':rid'=>$id));
if (!empty($list)) {
$total = pdo_fetchcolumn("SELECT COUNT(*) FROM ".tablename('wxwall_award')." WHERE rid = :rid", array(':rid'=>$id));
$pager = pagination($total, $pindex, $psize);
foreach ($list as $row) {
$users[$row['from_user']] = $row['from_user'];
}
load()->model('mc');
$users = mc_fetch($users, array('nickname', 'avatar'));
}
include $this->template('awardlist');
}
/**
* 獲取微信墻附加字段信息
* @param int $id
* @return array
*/
private function getWall($id) {
$wall = pdo_fetch("SELECT id, acid, isshow, rid, syncwall, logo, background FROM ".tablename('wxwall_reply')." WHERE rid = :rid LIMIT 1", array(':rid'=>$id));
$wall['syncwall'] = unserialize($wall['syncwall']);
$wall['rule'] = pdo_fetch("SELECT name, uniacid FROM ".tablename('rule')." WHERE id = :rid LIMIT 1", array(':rid'=>$id));
load()->model('account');
$accounts = uni_accounts();
$wall['account'] = $accounts[$wall['acid']];
$wall['keyword'] = pdo_fetchall("SELECT content FROM ".tablename('rule_keyword')." WHERE rid = :rid ", array(':rid'=>$id));
return $wall;
}
/**
* 格式化輸出微信墻信息
* @param array $list 消息集合
*/
private function formatMsg(&$list) {
global $_W;
if (empty($list)) {
return false;
}
$uids = $members = array();
foreach ($list as &$row) {
$uids[$row['from_user']] = $row['from_user'];
if ($row['type'] == 'link') {
$row['content'] = iunserializer($row['content']);
$row['content'] = '<a href="'.$row['content']['link'].'" target="_blank" title="'.$row['content']['description'].'">'.$row['content']['title'].'</a>';
} elseif ($row['type'] == 'image') {
$row['content'] = '<img src="'.$_W['attachurl'] . $row['content'].'" />';
} elseif ($row['type'] == 'txwall') {
$content = unserialize($row['content']);
$row['content'] = $content['content'];
$row['avatar'] = $content['avatar'];
$row['nickname'] = $content['nickname'];
}
$row['content'] = emotion($row['content'], '48px');
}
unset($row);
if (!empty($uids)) {
load()->model('mc');
$members = mc_fetch($uids, array('nickname', 'avatar'));
}
if (!empty($members)) {
foreach ($list as $index => &$row) {
if ($row['type'] == 'txwall') {
continue;
}
$row['nickname'] = $members[$row['from_user']]['nickname'];
$row['avatar'] = $members[$row['from_user']]['avatar'];
}
unset($row);
}
}
/**
* 異步處理騰訊墻信息
*/
public function doWebIncomingTxWall() {
global $_W, $_GPC;
$id = intval($_GPC['id']);
$result = array('status' => 0);
$lastmsgtime = intval($_GPC['lastmsgtime']);
$lastuser = '';
$wall = pdo_fetchcolumn("SELECT syncwall FROM ".tablename('wxwall_reply')." WHERE rid = :rid LIMIT 1", array(':rid'=>$id));
if (empty($wall)) {
message($result, '', 'ajax');
}
$wall = unserialize($wall);
if (empty($wall['tx']['status'])) {
message($result, '', 'ajax');
}
$response = ihttp_request('http://wall.v.t.qq.com/index.php?c=wall&a=topic&ak=801424380&t='.$wall['tx']['subject'].'&fk=&fn=&rnd='.TIMESTAMP);
if (empty($response['content'])) {
$result['status'] = -1;
message($result, '', 'ajax');
}
$last = pdo_fetch("SELECT createtime, from_user FROM ".tablename('wxwall_message')." WHERE createtime >= :createtime AND type = 'txwall' AND rid = :rid ORDER BY createtime DESC LIMIT 1", array(':createtime'=>$lastmsgtime, ':rid'=>$id));
if (!empty($last)) {
$lastmsgtime = $last['createtime'];
$lastuser = $last['from_user'];
}
$list = json_decode($response['content'], true);
if (!empty($list['data']['info'])) {
foreach ($list['data']['info'] as $row) {
if ($row['timestamp'] < $lastmsgtime || ($lastmsgtime == $row['timestamp'] && !empty($lastuser) && $lastuser == $row['name'])) {
break;
}
$content = array('nickname' => $row['nick'], 'avatar' => !empty($row['head']) ? $row['head'] . '/120' : '', 'content' => $row['text']);
$insert[] = array(
'rid' => $id,
'content' => serialize($content),
'from_user' => $row['name'],
'type' => 'txwall',
'isshow' => 1,
'createtime' => $row['timestamp'],
);
}
unset($row);
$insert = array_reverse($insert);
foreach ($insert as $row) {
pdo_insert('wxwall_message', $row);
}
$lastmsgtime = $row['timestamp'];
$result = array(
'status' => 1,
'lastmsgtime' => $lastmsgtime,
);
message($result, '', 'ajax');
} else {
message($result, '', 'ajax');
}
}
/**
* 騰訊墻信息登記
*/
public function doMobileRegister() {
global $_GPC, $_W;
$title = '微信墻登記';
// 驗證用戶注冊, 注冊后方能進如活動
checkauth();
if (!empty($_GPC['submit'])) {
$data = array(
'nickname' => $_GPC['nickname'],
);
if (empty($data['nickname'])) {
die('<script>alert("請填寫您的昵稱！");location.reload();</script>');
}
if (!empty($_FILES['avatar']['tmp_name'])) {
load()->func('file');
$upload = file_upload($_FILES['avatar']);
if (is_error($upload)) {
die('<script>alert("登記失敗！請重試！");location.reload();</script>');
}
$data['avatar'] = $upload['path'];
} else {
$data['avatar'] = $_GPC['avatar_radio'];
}
load()->model('mc');
mc_update($_W['member']['uid'], $data);
die('<script>alert("登記成功！現在進入話題發表內容！");location.href = "'.$this->createMobileUrl('register').'";</script>');
}
$member = mc_fetch($_W['member']['uid'], array('nickname', 'avatar'));
if (empty($member['avatar'])) {
$member['avatar'] = 'images/global/noavatar_middle.gif';
}
load()->func('tpl');
include $this->template('register');
}
}
```
- 入門
- 系統安裝
- 接入公眾平臺
- 關鍵字回復
- 更上一層樓
- 編碼規范
- php編碼規范
- html&css編碼規范
- JavaScript編碼規范
- 系統概述
- 結構概述
- 入口腳本
- 微擎MVC
- URL路由&創建
- $_W&全局變量
- 加載器
- 錯誤處理
- 日志記錄
- 模板
- 模板標簽
- 數據調用
- 常用變量
- 手機端組件
- 概述及依賴
- 圖像上傳
- 彈出選項
- 后臺組件
- 概述及依賴
- 后臺文件上傳
- 富文本編輯器
- 系統鏈接選擇器
- 其它常用組件
- 數據庫
- 參數綁定
- 數據操作
- 主從配置
- 連接其它數據庫
- 緩存
- 配置
- 緩存操作
- Http請求
- 概述及依賴
- GET&POST請求
- 發送郵件
- 會員與積分
- 統一用戶中心
- 借用OAuth
- 積分操作
- 資料操作
- 卡券
- 營銷卡券
- 會員卡
- 消息響應
- 消息概述
- 消息響應
- 微信API
- 公眾號AccessToken
- 共享收貨地址（廢棄）
- 共享收貨地址（新）
- 粉絲標簽
- 客服消息
- 模板消息
- 粉絲信息
- 素材
- 群發
- 二維碼
- 在線支付
- 概述及依賴
- 發起支付（PHP）
- 發起支付（JS）
- 驗證支付
- 模塊
- 設計模塊
- 目錄結構
- module.php
- processor.php
- site.php
- receiver.php
- 模塊高級專題
- 自定義分享
- 智能應答
- 微信卡券
- 遠程附件
- 權限控制
- 特殊事件觸發模塊
- 粉絲信息
- 小程序
- 概述
- Uitl類
- 云服務
- 云API
- 系統接口
- 模塊云配置
- 云短信
- 云短信錯誤代碼
- 云短信發送函數
- 批量群發短信
- 應用推廣
- 懸賞文案
- 折扣碼
- 系統消息
- 開發者等級資料認證
- 應用標簽
- 模塊自動檢測訂閱支持
- 小程序
- 開發實例
- 參數設置
- 常見問題