/** * 通过一组uid获取相应的gameuid * * @param 用户的uid数组 $uids * @return 相应的gameuids */ public function getGameuidList($uids) { if (empty($uids)) { return array(); } if (is_string($uids)) { $uids = explode(",", $uids); } if (!is_array($uids)) { $uids = array($uids); } if (count($uids) == 0) { return array(); } if ($this->logger->isDebugEnabled()) { $this->logger->writeDebug("start to get mapped gameuids from uid list[" . print_r($uids, true) . "]"); } $req = RequestFactory::createGetRequest(get_app_config()); $req->setTable($this->getTableName()); $req->addKeyValue("uid", $uids); $req->setCacheType(TCRequest::CACHE_IN_LIST); $gameuids = $req->execute(); if (empty($gameuids)) { return array(); } if ($this->logger->isDebugEnabled()) { $this->logger->writeDebug("retrieved gameuid uid mapping[" . print_r($gameuids, true) . "]"); } return $gameuids; }
public function getEventLogFromDB($limit = 30) { $req = RequestFactory::createGetRequest(get_app_config($this->gameuid)); $req->setKey('gameuid', $this->gameuid); $req->setTable($this->getTableName()); $req->setColumns("action,content, create_time"); $req->addKeyValue('gameuid', $this->gameuid); $req->setExtraCondition("order by create_time desc"); $req->setLimit($limit); $req->setNoCache(true); $list = $req->execute(); return $list; }
/** * 从数据库获取信息 * @param $gameuid * @param $key_values array,名称做key,数值做value * @param $cache_type 当要查的信息是cache_key_list时需要额外设置,默认为CACHE_PRIMARY_KEY * @return array 为cache_key_list时,调用fetchall;CACHE_PRIMARY_KEY调用fetchOne */ protected function getFromDb($gameuid, $key_values, $cache_type = TCRequest::CACHE_PRIMARY_KEY) { if (empty($key_values)) { return array(); } $req = RequestFactory::createGetRequest(get_app_config($gameuid)); $req->setKey($this->getKeyName(), $gameuid); $req->setTable($this->getTableName()); $req->setCacheType($cache_type); foreach ($key_values as $key => $value) { $req->addKeyValue($key, $value); } if ($cache_type == TCRequest::CACHE_KEY_LIST) { return $req->fetchAll(); } return $req->fetchOne(); }