Exemplo n.º 1
0
 /**
  * 腾讯IDIP接口
  * @param array  通过HTTP POST方式提交数据,数据只有一个data_packet字段,里面包括IDIP协议定义好的各项数据,JSON编码
  * @return array 按IDIP要求返回格式返回一个JSON数组,
  */
 public function sendAction()
 {
     $ts1 = microtime(true);
     $logger = $this->getServiceLocator()->get('Zend\\Log');
     $config = $this->getServiceLocator()->get('config');
     //$logger->debug('sendAction start' . $ts1);
     $data = $this->params()->fromPost('data_packet');
     //$logger->debug($data);
     $data = json_decode($data, true);
     //$logger->debug($data);
     $request = new IdipRequest($data);
     //$logger->debug($idip_request);
     $area_id = $request->getBody('AreaId');
     $plat_id = $request->getBody('PlatId');
     $cmd_id = $request->getHead('Cmdid');
     $ts2 = microtime(true);
     $time = $ts2 - $ts1;
     $response = new IdipResponse();
     $response->setHead(array('Seqid' => $request->getHead('Seqid'), 'ServiceName' => $request->getHead('ServiceName'), 'Version' => $request->getHead('Version'), 'Authenticate' => null));
     if (!$request->existBody('Partition') || $request->getBody('Partition') == 0) {
         //查询目标大区所有服
         if ($cmd_id == 0x1027) {
             //查询用户角色信息
             $adapter_name = "namespace_{$area_id}_{$plat_id}";
             $adapter = $this->getServiceLocator()->get($adapter_name);
             $openid = $request->getBody('OpenId');
             $page = $request->getBody('PageNo');
             $start = ($page - 1) * IdipResponse::NUMBERS_PER_PAGE;
             $offset = IdipResponse::NUMBERS_PER_PAGE;
             $total_cnt = 0;
             $sql = "SELECT COUNT(*) AS cnt FROM PLAYER_TBL WHERE account = '{$openid}'";
             //$logger->debug("execute sql: {$sql}");
             $result = $adapter->query($sql, Adapter::QUERY_MODE_EXECUTE);
             foreach ($result as $row) {
                 $total_cnt = $row['cnt'];
             }
             $total_pages = ceil($total_cnt / IdipResponse::NUMBERS_PER_PAGE);
             $sql = "SELECT id, name, svr_name FROM PLAYER_TBL WHERE account='{$openid}' LIMIT {$start}, {$offset}";
             $logger->info("execute sql: {$sql}");
             $result = $adapter->query($sql, Adapter::QUERY_MODE_EXECUTE);
             $res = array();
             foreach ($result as $row) {
                 $res[] = array('RoleId' => $row['id'], 'RoleName' => $row['name'], 'Partition' => (int) $row['svr_name'], 'TotalPageNo' => $total_pages);
             }
             //$logger->debug($res);
             $response->setHead('Cmdid', 0x1028);
             $response->setBody(array('RoleList_count' => count($res), 'RoleList' => $res));
         } else {
             $response->setHead(array('Cmdid' => $cmd_id + 1, 'Result' => -101, 'RetErrMsg' => "CmdId({$cmd_id}) cannot be supported on multiple partitions"));
             $response->setBody(array('Result' => -101, 'RetMsg' => "CmdId({$cmd_id}) cannot be supported on multiple partitions"));
         }
     } else {
         //查询指定服
         $partition = $request->getBody('Partition');
         //根据area_id/plat_id/partition查找数据库连接
         //$adapter_name = "gateway";
         //$adapter = $this->getServiceLocator()->get($adapter_name);
         //$sql = "SELECT ip, port, db_host, db_port, db_name, db_user, db_pass, status FROM servers WHERE area_id = {$area_id} AND plat_id = {$plat_id} AND partition = {$partition}";
         //$logger->info("execute sql: $sql");
         //$result = $adapter->query($sql, Adapter::QUERY_MODE_EXECUTE);
         //$logger->debug('find db info on gateway');
         //$logger->debug(print_r($result, true));
         //if (empty($result)) {
         //    $response->setHead(array(
         //        'Result'        => -102,
         //        'RetErrMsg'     => "Cannot find this area_id/plat_id/partition on the gateway",
         //    ));
         //    $response->setBody(array(
         //        'Result'        => -102,
         //        'RetMsg'        => "Cannot find this area_id/plat_id/partition on the gateway",
         //    ));
         //} elseif (count($result) > 1) {
         //    $response->setHead(array(
         //        'Result'        => -103,
         //        'RetErrMsg'     => "Multiple servers are found with this area_id/plat_id/partition on the gateway",
         //    ));
         //    $response->setBody(array(
         //        'Result'        => -103,
         //        'RetMsg'        => "Multiple servers are found with this area_id/plat_id/partition on the gateway",
         //    ));
         //} else {
         //    $gs_config = array();
         //    foreach ($result as $row) {
         //        $gs_config['status'] = $row['status'];
         //        $gs_config['host'] = $row['db_host'];
         //        $gs_config['port'] = $row['db_port'];
         //        $gs_config['name'] = $row['db_name'];
         //        $gs_config['user'] = $row['db_user'];
         //        $gs_config['pass'] = $row['db_pass'];
         //
         //        $gs_config['gs_ip'] = $row['ip'];
         //        $gs_config['gs_port'] = $row['port'];
         //    }
         //
         //    if (!isset($gs_config['status'])) {
         //        $response->setHead(array(
         //            'Result'        => -102,
         //            'RetErrMsg'     => "Cannot find this area_id/plat_id/partition on the gateway",
         //        ));
         //        $response->setBody(array(
         //            'Result'        => -102,
         //            'RetMsg'        => "Cannot find this area_id/plat_id/partition on the gateway",
         //        ));
         //    } elseif ($gs_config['status'] != Idip::STATUS_OPEN) {
         //        $status_txt = Idip::$status_list[$gs_config['status']];
         //        $response->setHead(array(
         //            'Result'        => -104,
         //            'RetErrMsg'     => "This server has been {$status_txt}",
         //        ));
         //        $response->setBody(array(
         //            'Result'        => -104,
         //            'RetMsg'        => "This server has been {$status_txt}",
         //        ));
         //    } else {
         if ($cmd_id == 0x1029) {
             //查询用户基本 信息
             $driver = array('driver' => 'Pdo', 'dsn' => "mysql:dbname={$gs_config['name']};host={$gs_config['host']};port={$gs_config['port']};charset=utf8", 'driver_options' => array(\PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''), 'username' => $gs_config['user'], 'password' => $gs_config['pass']);
             $adapter = new Adapter($driver);
             $openid = $request->getBody('OpenId');
             $sql = "SELECT \n                            last_logout_ip, \n                            online_time, \n                            name, \n                            account, \n                            gold, \n                            silver, \n                            wood, \n                            score, \n                            soul,\n                            power, \n                            merit, \n                            guild_name,\n                            vip,  \n                            level,  \n                            online_time \n                        FROM PLAYER_TBL\n                        WHERE account='{$openid}'";
             $logger->info("execute sql: {$sql}");
             $result = $adapter->query($sql, Adapter::QUERY_MODE_EXECUTE);
             $res = array();
             foreach ($result as $row) {
                 $res['Ip'] = $row['last_logout_ip'];
                 $res['OnlineTime'] = $row['online_time'];
                 $res['AvgOnlineTime'] = null;
                 //TODO
                 $res['RoleName'] = $row['name'];
                 $res['Level'] = $row['level'];
                 $res['Diamond'] = $row['gold'];
                 $res['Money'] = $row['silver'];
                 $res['Stone'] = $row['wood'];
                 $res['Reputation'] = $row['score'];
                 $res['Soul'] = $row['soul'];
                 $res['Achieve'] = $row['merit'];
                 $res['ArmyName'] = $row['guild_name'];
                 $res['Vip'] = $row['vip'];
                 $res['Physical'] = $row['power'];
             }
             //$logger->debug($res);
             $response->setHead('Cmdid', 0x102a);
             if (empty($res)) {
                 $response->setHead(array('Result' => 1, 'RetErrMsg' => "Cannot find this OpenID exists any partitions on this platform"));
             }
             $response->setBody($res);
         } else {
             //Send GM to GS
             //$logger->debug("Connect to server {$gs_config['gs_ip']}:{$gs_config['gs_port']}");
             //$logger->debug("Connect to server {"192.168.0.3"}:{9012}");
             $gm = new \ServerApi($logger);
             //$ret = $gm->sendIdipCmd($gs_config['gs_ip'], $gs_config['gs_port'], $data);
             //$ret = $gm->sendIdipCmd("192.168.0.3", 9012, $data);
             //$logger->debug($ret);
             $ret = array('body' => array('Result' => 0, 'RetMsg' => 'player_is_offline'), 'head' => array('Cmdid' => 4098, 'SendTime' => 1416835614, 'Version' => 3, 'RetErrMsg' => 'player_is_offline', 'ServiceName' => 'CX', 'Result' => 0, 'Seqid' => 4980, 'Authenticate' => ''));
             $response->makeHeadBody($ret);
         }
         //    }
         //}
     }
     $ts3 = microtime(true);
     $ret = $response->generateResponse();
     //$logger->debug($ret);
     $logger->info('-------------------------------------------');
     echo $ret;
     $time = $ts3 - $ts2;
     $total = $ts3 - $ts1;
     //$logger->debug("sendAction return: {$ts3}, total time {$total}");
     exit;
 }
Exemplo n.º 2
0
 }
 $adapters = $config['db']['adapters'];
 $ts1 = microtime(true);
 $logger->debug('sendAction start' . $ts1);
 $data = $_POST['data_packet'];
 $logger->debug($data);
 $data = json_decode($data, true);
 $logger->debug($data);
 $request = new IdipRequest($data);
 //$logger->debug($idip_request);
 $area_id = $request->getBody('AreaId');
 $plat_id = $request->getBody('PlatId');
 $cmd_id = $request->getHead('Cmdid');
 $ts2 = microtime(true);
 $time = $ts2 - $ts1;
 $response = new IdipResponse();
 $response->setHead(array('Seqid' => $request->getHead('Seqid'), 'ServiceName' => $request->getHead('ServiceName'), 'Version' => $request->getHead('Version'), 'Authenticate' => null));
 if (!$request->existBody('Partition') || $request->getBody('Partition') == 0) {
     //查询目标大区所有服
     if ($cmd_id == 0x1027) {
         //查询用户角色信息
         $adapter_name = "namespace_{$area_id}_{$plat_id}";
         $adapter_config = $adapters[$adapter_name];
         $adapter = new PDO($adapter_config['dsn'], $adapter_config['username'], $adapter_config['password'], $adapter_config['driver_options']);
         $openid = $request->getBody('OpenId');
         $page = $request->getBody('PageNo');
         $start = ($page - 1) * IdipResponse::NUMBERS_PER_PAGE;
         $offset = IdipResponse::NUMBERS_PER_PAGE;
         $total_cnt = 0;
         $sql = "SELECT COUNT(*) AS cnt FROM PLAYER_TBL WHERE account = '{$openid}'";
         $logger->debug("execute sql: {$sql}");