UserProc.php 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557
  1. <?php
  2. namespace loyalsoft;
  3. /**
  4. * Description of UserProc
  5. * 玩家数据处理流程
  6. *
  7. */
  8. class UserProc {
  9. const role_Table = 'tab_rolename';
  10. /**
  11. * 逻辑分发
  12. * 所有的Proc中必须有这样一个方法
  13. * @param Req $req
  14. */
  15. public static function procMain($req) {
  16. switch ($req->cmd) {
  17. case CmdCode::cmd_user_getzonelist: # 6000 分区列表
  18. return UserProc::GetZoneList();
  19. case CmdCode::cmd_user_loginuserinfo: # 6001 登录
  20. return UserProc::loginUserInfo();
  21. case CmdCode::cmd_user_gameconstinfo: # 6002 下载游戏配置
  22. return UserProc::downloadConstInfo();
  23. case CmdCode::cmd_user_acceptcontidaysgift: # 6003 领取连续登陆奖励
  24. return UserProc::acceptContiDaysGift();
  25. case CmdCode::cmd_user_registerNewRole: # 6006 注册新角色
  26. return UserProc::RegisterNewRole();
  27. case CmdCode::cmd_user_completeNewbieGuide: # 6007 提交新手引导步骤
  28. return UserProc::completeNewbieGuide();
  29. // case CmdCode::cmd_user_setNewbieGuideCards: # 6008 发放新手引导所需卡牌
  30. // return self::SetNewbieGuideCards($req);
  31. // case CmdCode::cmd_user_setNewbieGuideOver: # 6009 跳过新手引导
  32. // return UserProc::setNewbieGuideOver();
  33. case CmdCode::cmd_user_setNickname: # 6010 设置/修改玩家昵称
  34. return self::SetUserNickname();
  35. case CmdCode::cmd_user_SetUserHeadImageBorder: # 6011 修改玩家头像框
  36. return self::SetUserImageBorder();
  37. case CmdCode::cmd_user_setUserImage: # 6012 更换玩家形象
  38. return self::SetUserImage();
  39. case CmdCode::cmd_user_changeUserHeadImg: # 6013 更换玩家头像
  40. return self::SetUserHeadImage();
  41. default:
  42. Err(ErrCode::cmd_err);
  43. }
  44. }
  45. //
  46. // <editor-fold defaultstate="collapsed" desc="玩家信息 修改">
  47. /**
  48. * [6013]修改玩家头像
  49. */
  50. static function SetUserHeadImage() {
  51. list($headImage) = req()->paras; # 参数, 新头像
  52. req()->userInfo->game->baseInfo->headImg = $headImage;
  53. UserProc::updateUserInfo();
  54. return Resp::ok(array('ret' => 'ok'));
  55. }
  56. /**
  57. * [6012]修改玩家形象
  58. */
  59. static function SetUserImage() {
  60. list($image) = req()->paras; # 参数, 新形象
  61. req()->userInfo->game->baseInfo->img = $image;
  62. UserProc::updateUserInfo();
  63. return Resp::ok(array('ret' => 'ok'));
  64. }
  65. /**
  66. * [6011]修改玩家头像框
  67. */
  68. static function SetUserImageBorder() {
  69. list($imgborderId) = req()->paras; # 参数, 新头像框ID
  70. req()->userInfo->game->baseInfo->imgBorderId = $imgborderId;
  71. UserProc::updateUserInfo();
  72. return Resp::ok(array('ret' => 'ok'));
  73. }
  74. /**
  75. * [6010] 设置/修改玩家昵称
  76. */
  77. static function SetUserNickname() {
  78. list($newname) = req()->paras; # 参数: 新昵称, 头像
  79. my_Assert(isset(glc()->User_SetNickname_Cost), "全局变量中未找到改名消耗钻石数量的配置字段");
  80. $amt = glc()->User_SetNickname_Cost; # 改名需要消耗钻石
  81. $ok = req()->userInfo->game->base()->Consume_Cash($amt); # 扣除钻石
  82. my_Assert($ok, ErrCode::notenough_cash_msg);
  83. my_Assert(self::checkRoleNameNotExist($newname), ErrCode::user_nicknameexist); # 昵称已存在
  84. req()->userInfo->game->baseInfo->name = $newname;
  85. daoInst()->update(self::role_Table)
  86. ->data(array('roleName' => $newname))
  87. ->where('userID')->eq(req()->uid)
  88. ->andWhere('zoneid')->eq(req()->zoneid)
  89. ->exec();
  90. UserProc::updateUserInfo();
  91. return Resp::ok(array('ret' => 'ok'));
  92. }
  93. // </editor-fold>
  94. //
  95. // <editor-fold defaultstate="collapsed" desc="新手引导">
  96. // /**
  97. // * [6009] 新手引导 发送n张碎片到玩家身上
  98. // */
  99. // static function SetNewbieGuideCards() {
  100. // Err(ErrCode::function_notopen_msg); # 功能已经废弃 -wg
  101. // $private = req()->userInfo->game->privateState;
  102. // if (!property_exists($private, 'newbieguideCards')) { # 逻辑检查, 是否已经发放过
  103. // $private->newbieguideCards = true;
  104. // req()->userInfo->game->privateState = $private; # 回写私有数据
  105. // $sp = explode(';', glc()->User_SetNewbieGuideCards); # 碎片
  106. // foreach ($sp as $cardinfo) {
  107. // $arr = explode(',', $cardinfo);
  108. // $itemid = $arr[0];
  109. // $num = $arr[1];
  110. // StoreProc::addSegmentIntoStore(req()->userInfo->game->store, $itemid, $num);
  111. // }
  112. // $exp = explode(';', glc()->User_SetNewbieGuideExps); # 经验卡
  113. // foreach ($exp as $expinfo) {
  114. // $arr = explode(',', $expinfo);
  115. // $itemid = $arr[0];
  116. // $num = $arr[1];
  117. // StoreProc::PutOverlyingItemInStore($itemid, $num);
  118. // }
  119. // UserProc::updateUserInfo(); # 回存玩家数据
  120. // return Resp::ok(array('store' => req()->userInfo->game->store));
  121. // }
  122. // return Resp::err(ErrCode::active_hasgetted);
  123. // }
  124. /**
  125. * [6009] 增加 设置引导结束的标志位
  126. */
  127. public static function setNewbieGuideOver() {
  128. Err(ErrCode::function_notopen_msg); # 功能已经废弃 -wg
  129. // $user = new Data_UserGame(req()->userInfo->game); # user
  130. // if (!CommUtil::isPropertyExists($user, "NewbieGuideOver")) { # 防御: 变量未初始化
  131. // $user->NewbieGuideOver = 1;
  132. // }
  133. // $user->NewbieGuideOver = 1;
  134. // req()->userInfo->game = $user;
  135. // UserProc::updateUserInfo(); # 回写数据
  136. // return Resp::ok(array(# # 返回值
  137. // 'result' => "succeed"
  138. // ));
  139. }
  140. /**
  141. * [6007] 更新初始的强制的新手引导阶段步骤
  142. * 第一阶段的引导
  143. */
  144. public static function completeNewbieGuide() {
  145. $guideIndex = req()->paras[0]; # 参数: 新手引导步骤
  146. $user = new Data_UserGame(req()->userInfo->game); # user
  147. my_default_Obj($user->NewbieGuide); # 防御: 变量未初始化
  148. $NewbieGuide = $user->NewbieGuide;
  149. if (!CommUtil::isPropertyExists($NewbieGuide, "guideStep")) { # 防御: 变量未初始化
  150. $NewbieGuide->guideStep = 0;
  151. }
  152. my_Assert($guideIndex >= $NewbieGuide->guideStep, ErrCode::user_settutorialscompletedfail_err);
  153. $NewbieGuide->guideStep = $guideIndex;
  154. $user->NewbieGuide = $NewbieGuide;
  155. req()->userInfo->game = $user;
  156. UserProc::updateUserInfo(); # 回写数据
  157. return Resp::ok(array(
  158. "store" => $user->store, # # 目前来看只涉及到items变化
  159. "heros" => $user->heros, # # 英雄数据
  160. ));
  161. }
  162. // </editor-fold>
  163. //
  164. /**
  165. * 6006 注册新角色
  166. */
  167. public static function RegisterNewRole() {
  168. $userID = req()->uid;
  169. list($rolename, $gender, $profile_img) = req()->paras; # 参数: 昵称,性别,头像
  170. $id = gMem()->increment(MemKey_GameRun::Stat_UserCountByZone_int(req()->zoneid)); # 增加玩家数量计数
  171. $rolename = "No." . sprintf("%03d", req()->zoneid) . sprintf("%07d", $id); # 生成编号
  172. if (self::checkRoleNameNotExist($rolename)) { # 记录玩家
  173. $userinfo = self::createUser($rolename, $gender, $profile_img);
  174. if (1 == self::regRole(req()->zoneid, $userID, $rolename, $gender, $profile_img, $userinfo->getPlatStr())) {
  175. $resp = Resp::ok($userinfo);
  176. self::updtateUserZoneInfo();
  177. } else {
  178. $resp = Resp::err(ErrCode::err_db);
  179. }
  180. // StatProc::UserGuidStep($userinfo->user->firstLogOn, $req->zoneid, -2, 1);
  181. } else { # 昵称已存在
  182. $resp = Resp::ok(array('ret' => '用户已存在.'));
  183. }
  184. return $resp;
  185. }
  186. /**
  187. * 6000 【移动端】 获取分区列表
  188. */
  189. public static function GetZoneList() {
  190. $defaultZone = new Ins_ZoneInfo(1, 0, ""); # 新用户默认分区
  191. $bGetRecommended = false;
  192. if (count(req()->paras) > 0) { # 是否只拉取推荐分区
  193. $bGetRecommended = req()->paras[0];
  194. }
  195. $zoneList = array();
  196. $ts = now();
  197. foreach (GameConfig::zonelist() as $zoneid => $zone) {
  198. isEditor() and $zone = new \sm_zonelist();
  199. if ($zone->publicTs > $ts) {
  200. continue;
  201. }
  202. $zone->zoneid = $zoneid; # 把zoneid塞进zone数据结构中
  203. if ($bGetRecommended) {
  204. if ($zone->isRecommended > 0 && $zone->status == 1) {
  205. $zoneList[] = $zone;
  206. } else {
  207. }
  208. } else {
  209. $zoneList[] = $zone;
  210. }
  211. unset($zone->isRecommended);
  212. }
  213. UserProc::_AddTesterZonelist($zoneList); # 添加测试分区
  214. #
  215. // <editor-fold defaultstate="collapsed" desc=" 取玩家分区记录 ">
  216. $userZoneInfo = self::getUserZoneInfo(); # 玩家分区记录
  217. $isNewUser = false;
  218. if ($userZoneInfo == null) { // 这里使用推荐分区的数据,推荐分区信息,在后台编辑,编辑器可用
  219. $userZoneInfo = new Data_UserZoneInfo();
  220. $userZoneInfo->lastZone = $defaultZone; # 新用户导向默认分区
  221. $isNewUser = true;
  222. // $err = self::RegisterNewUser($req); # 新用户添加到总表中
  223. // if ($err != ErrCode::succeed) {
  224. // return ResponseVo::myErrResponse($req, $err);
  225. // }
  226. # 统计模块添加记录
  227. // StatProc::UserGuidStep(CommUtil::tsCurrent(), $req->zoneid, -1, 1); // 第一次进入游戏
  228. } else { # 转换一下格式,去掉key,只保留value的集合
  229. // $userZoneInfo->playedZones = ArrayInit();
  230. // array_merge($userZoneInfo->playedZones, array_values((array) $userZoneInfo->playedZones));
  231. }
  232. // </editor-fold>
  233. $ret = array(
  234. 'isNewUser' => $isNewUser,
  235. 'zonelist' => json_decode(json_encode($zoneList)),
  236. 'userZoneInfo' => $userZoneInfo
  237. );
  238. return Resp::ok($ret); # 返回值
  239. }
  240. private static function _AddTesterZonelist(&$zoneList) {
  241. if (config::Inst()->isTester(req()->uid)) { # 添加测试分区
  242. $zoneList[] = array('zoneid' => 999, 'name' => '内测专区', 'status' => 2, 'publicTs' => 0);
  243. }
  244. }
  245. /**
  246. * 6002 客户端下载常量配置信息
  247. * @return type
  248. */
  249. public static function downloadConstInfo() {
  250. list($clientDataVer) = req()->paras; # 客户端数据版本号,程序版本号
  251. $serverVer = GameConfig::ver(); # 最新数据版本号
  252. my_Assert($serverVer, ErrCode::err_const_no); # 找不到常量数据
  253. if ($clientDataVer == $serverVer) { # 如果版本一致,数据体抹掉,只传回版本号
  254. // $md5 = md5(json_encode($constInfo)); # 计算MD5值,多余计算md5
  255. $ret = array(
  256. 'version' => $clientDataVer,
  257. 'data' => null);
  258. return Resp::ok($ret);
  259. }
  260. $constInfo = GameConfig::client(); # 取出来的已经是base64过的压缩数据
  261. my_Assert($constInfo, ErrCode::err_const_no); # 找不到配置数据
  262. return Resp::ok(array('data' => $constInfo));
  263. }
  264. /**
  265. * 6001 客户端登录并返还玩家信息
  266. * @return Resp
  267. */
  268. public static function loginUserInfo() {
  269. $userInfo = UserProc::getUserInfo(req()->zoneid, req()->uid); # 取玩家信息
  270. if ($userInfo == null) { # 新用户, -> 6006创建账号
  271. $ret = array(
  272. 'isNewUser' => true
  273. );
  274. return Resp::ok($ret);
  275. } else { # 2.如果玩家已存在,则处理普通登录流程
  276. req()->userInfo = $userInfo; # 给Req挂载userInfo
  277. UserProc::checkContidays(); # 连续登录,状态检查
  278. PayProc::m_refreshChargeOrders(); # 刷新订单, 多平台版本
  279. PayProc::checkDeltest(); # 检查内侧充值记录(函数内部会只检查一次)
  280. UserProc::updateUserInfo(); # 这一步回存操作只有在 userInfo正常存在的情况下才进行
  281. $resp = Resp::ok($userInfo); # 设置返回值
  282. self::backupUserInfo(); # 数据回写
  283. self::updtateUserZoneInfo(); # 1. 更新玩家分区记录
  284. }
  285. return $resp;
  286. }
  287. /**
  288. * 6003 领取连续登录奖励
  289. */
  290. public static function acceptContiDaysGift() {
  291. $resp = Resp::err(ErrCode::err_method_notimplement);
  292. return $resp;
  293. }
  294. //
  295. // <editor-fold defaultstate="collapsed" desc=" 辅助方法 ">
  296. /**
  297. * 检查昵称是否已经存在
  298. * @param string $roleName
  299. * @return boolean
  300. */
  301. static function checkRoleNameNotExist($roleName) {
  302. static $sqlFormat = "SELECT count(*) as rows FROM `tab_rolename` WHERE roleName='%s';";
  303. $sql = sprintf($sqlFormat, $roleName);
  304. $n = daoInst()->query($sql)->fetch();
  305. return $n->rows <= 0;
  306. }
  307. /**
  308. * 插入玩家新角色
  309. *
  310. * @param string $zoneid
  311. * @param string $userID
  312. * @param string $nickname
  313. * @param string $gender
  314. * @param string $profile_img
  315. * @param string $plat
  316. */
  317. static function regRole($zoneid, $userID, $nickname, $gender, $profile_img, $plat) {
  318. return daoInst()->insert('tab_rolename')
  319. ->data(array(
  320. 'zoneid' => $zoneid,
  321. 'userID' => $userID,
  322. 'roleName' => $nickname,
  323. 'gender' => $gender,
  324. 'profile' => $profile_img,
  325. 'plat' => $plat
  326. ))->exec();
  327. }
  328. /**
  329. * 检测连续登录状态,重置必要字段[时间戳自动记录]
  330. */
  331. static function checkContidays($isnew = 0) {
  332. $ret = TimeUtil::tsDay() - TimeUtil::tsDay(req()->userInfo->game->baseInfo->lastLogin); // 对比登录日期
  333. if ($ret > 0) { # 当天第一次登录
  334. self::OnNewDay($isnew);
  335. } else { # 更新下登录次数记录(任务计数器)
  336. }
  337. if ($ret == 1) { # 连续登录
  338. } else if ($ret >= 2) { # 隔天登录
  339. }
  340. req()->userInfo->game->baseInfo->lastLogin = now(); # 更新下访问时间
  341. TaskProc::ResetDailyTask(); # 重置每日任务
  342. TaskProc::OnUserLogin();
  343. return $ret;
  344. }
  345. /**
  346. * 处理当天第一次登录
  347. * @param bool $isnew Description
  348. */
  349. static function OnNewDay($isnew) {
  350. self::updatePlatUserRecord($isnew); # 添加到到当天活跃玩家记录集合
  351. ActiveProc::DailyReset(); # 抽奖、每日任务状态,计数器...
  352. FightProc::ClearByDay(); # 战斗相关状态每日清理
  353. ShopProc::DailyCheck();
  354. }
  355. // <editor-fold defaultstate="collapsed" desc="创建新用户">
  356. /**
  357. * 创建用户
  358. * @return UserInfoMo
  359. */
  360. static function createUser($rolename, $gender, $profile_img) {
  361. $userInfo = new UserInfoMo();
  362. req()->userInfo = $userInfo; # 更新Req的userinfo,
  363. // $userInfo->uid = req()->uid;
  364. // $userInfo->zoneid = req()->zoneid;
  365. $userInfo->game = new Data_UserGame();
  366. $userInfo->game->initialize(); # 初始化玩家数据
  367. $userInfo->game->baseInfo->name = $rolename;
  368. $userInfo->game->baseInfo->gender = $gender;
  369. $userInfo->game->baseInfo->headImg = $profile_img;
  370. $userInfo->game->baseInfo->firstLogin = now();
  371. // $userInfo->game->pvp->socre = PVPProc::_getScore_by_uid($req, $req->uid); # 初始化pvp积分
  372. // $userInfo->game->NewbieGuideOver = 1;
  373. // UserProc::_intiHeroManual($userInfo->game); # 初始化图鉴
  374. #Ps 6006是没有获得到Userinfo到Req中的
  375. UserProc::checkContidays(1); # 每日状态检查
  376. // UserProc::fetchFromInteract($mem, $req); # 从interact拉取数据,Ps.初始化的过程应该还拉取不到什么有效数据
  377. UserProc::updateUserInfo(); # 回存用户数据
  378. // FriendProc::Init($req);
  379. // StatProc:: ...
  380. // GoalsDailyProc::dealDailyLogin($mem, $req, $resp); # 每日登录任务
  381. return $userInfo;
  382. }
  383. /**
  384. * 整理平台玩家记录集
  385. * @param int $isnew
  386. */
  387. private static function updatePlatUserRecord($isnew = 0) {
  388. $zoneid = req()->zoneid;
  389. $uid = req()->uid;
  390. $user = req()->userInfo->game->baseInfo;
  391. $day = tsDay();
  392. $level = $user->level;
  393. $platUser = ObjectInit();
  394. $platUser->uid = $uid; #
  395. $platUser->name = $user->name; #
  396. $platUser->level = $level;
  397. $platUser->img = $user->headImg; # 头像字段
  398. $platUser->cash = $user->cash;
  399. $platUser->gold = $user->gold;
  400. $platUser->tili = $user->tili;
  401. $platUser->ts = now();
  402. $platUser->isnew = $isnew;
  403. gMem()->delete(MemKey_GameRun::DailyLoginUser_byUID_hash($zoneid, $day - 108));
  404. gMem()->hset(MemKey_GameRun::DailyLoginUser_byUID_hash($zoneid), $uid, $platUser);
  405. gMem()->delete(MemKey_GameRun::DailyLoginUser_byLevel_hash($zoneid, $level, $day - 108));
  406. gMem()->hset(MemKey_GameRun::DailyLoginUser_byLevel_hash($zoneid, $level), $uid, $platUser);
  407. }
  408. // </editor-fold>
  409. //
  410. // <editor-fold defaultstate="collapsed" desc="读写玩家数据">
  411. /**
  412. * 玩家数据
  413. * @param type $zoneid
  414. * @param type $uid
  415. * @return UserInfoMo
  416. */
  417. public static function getUserInfo($zoneid, $uid) {
  418. $key = MemKey_User::Info_hash($zoneid, $uid);
  419. $a = new Data_UserGame();
  420. if (null == $a->readDataFromMem($key)) {
  421. return null;
  422. }
  423. $usrInfo = new UserInfoMo();
  424. // $usrInfo->zoneid = $zoneid;
  425. // $usrInfo->uid = $uid;
  426. $g = new Data_UserGame($a);
  427. $usrInfo->game = $g;
  428. return $usrInfo;
  429. }
  430. /**
  431. * 更新用户数据(设置标志位,最后统一更新-gwang 2017.07.18)
  432. */
  433. public static function updateUserInfo() {
  434. my_Assert(req(), "req()为空");
  435. my_Assert(req()->userInfo, "[" . req()->cmd . "] 玩家数据正在被清空!" . req()->uid);
  436. req()->userInfoChanged = TRUE; # 设置回写标志位
  437. }
  438. /**
  439. * 回写玩家数据
  440. * @param UserInfoMo $userInfo
  441. */
  442. public static function setUserInfo($userInfo) {
  443. if ($userInfo) {
  444. $zoneid = req()->zoneid;
  445. $uid = req()->uid;
  446. $userInfo->game->baseInfo->lastSaveTs = now();
  447. $key = MemKey_User::Info_hash($zoneid, $uid);
  448. return $userInfo->game->updateData($key);
  449. }
  450. return false;
  451. }
  452. // </editor-fold>
  453. //
  454. // <editor-fold defaultstate="collapsed" desc="玩家分区记录">
  455. /**
  456. * 读取玩家的分区记录
  457. * @return Data_UserZoneInfo Description
  458. */
  459. public static function getUserZoneInfo() {
  460. $ret = gMem()->get(MemKey_User::Union_PlayedZoneInfo_normal(req()->uid));
  461. return $ret;
  462. }
  463. /**
  464. * 更新玩家分区记录
  465. */
  466. public static function updtateUserZoneInfo() {
  467. $req = req();
  468. $userZoneInfo = self::getUserZoneInfo(); # 取玩家分区记录
  469. if (!$userZoneInfo) {
  470. $userZoneInfo = new Data_UserZoneInfo;
  471. }
  472. $level = 0;
  473. $zoneid = $req->zoneid;
  474. $playerName = "";
  475. $headImg = "";
  476. if (isset($req->userInfo)) { # 防御确保玩家数据不为空
  477. $level = $req->userInfo->game->baseInfo->level;
  478. $playerName = $req->userInfo->game->baseInfo->name;
  479. $headImg = $req->userInfo->game->baseInfo->headImg;
  480. } else {
  481. Err('玩家数据为空!' . __CLASS__ . '.' . __FUNCTION__);
  482. }
  483. if (is_null($level)) {
  484. $level = 0;
  485. }
  486. $userZoneInfo->lastZone = new Ins_ZoneInfo($zoneid, $level, $playerName, $headImg); # 更新玩家分区记录
  487. $userZoneInfo->playedZones->$zoneid = $userZoneInfo->lastZone; # 玩过的分区集合
  488. gMem()->set(MemKey_User::Union_PlayedZoneInfo_normal($req->uid), $userZoneInfo); # 回写数据
  489. }
  490. // </editor-fold>
  491. // <editor-fold defaultstate="collapsed" desc=" 用户数据备份 ">
  492. /**
  493. * 备份玩家数据,(玩家数据落地),一天一份,当天记为最后一次登录时的状态而非最后一次操作的状态
  494. * @history
  495. * version 3.0.13 mysql版备份玩家数据, (性能优化后表现还不错)
  496. * 除非用脚本在redis中实现备份,否则直接写入mysql.
  497. * 主要是mysql版本利用存储过程之后性能已经和redis版相差不多.
  498. * version 2.0.0 Redis storage 从MySQL转到Redis中存储. 这个备份数据没有大规模导出硬盘的需求
  499. * 因为mysql版本实在是负载太大了, 上百毫秒. 所以改在redis中了.
  500. * version 1.0.0 Mysql storagef 1. 分表不做了, 2. 存储过程不用了 3. 先能用再说
  501. */
  502. public static function backupUserInfo() {
  503. $tsday = TimeUtil::tsDay(); # 精确到天,保留10个最近记录.
  504. $value = base64_encode(gzdeflate(JsonUtil::encode(req()->userInfo))); # blob数据,序列化下
  505. $sql = sprintf("call insertUserInfo('%s', %d, %d, '%s');", # # 所以直接将序列化后的结果存进去吧,
  506. req()->uid, req()->zoneid, $tsday, $value); # zoneid, uid, tsday
  507. daoInst()->exec($sql); # 也可以用exec($sql)
  508. }
  509. // </editor-fold>
  510. //</editor-fold>
  511. //
  512. }