UserProc.php 25 KB

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