Example #1
0
 public function get_user()
 {
     $oUser = new Data_Account();
     $sql = 'select name from account where name <> "" limit ' . $this->page_index . ',' . $this->page_num . ';';
     $oUser->query($sql);
     $records = array();
     while ($oUser->next_record()) {
         $records[] = $oUser->get_record();
     }
     $this->page_index += $this->page_num;
     return $records;
 }
Example #2
0
 public function run()
 {
     $oUser = new Data_Account();
     $oPlayer = new Data_Player();
     $sql = 'select player_id,name from account;';
     $oUser->query($sql);
     $records = array();
     while ($oUser->next_record()) {
         $records[] = $oUser->get_record();
     }
     foreach ($records as $user) {
         if ($user['name']) {
             $player_id = $user['player_id'];
             $cache_key = 'data|player:' . $player_id;
             $data = $oPlayer->redis()->hash_get($cache_key);
             if ($data) {
                 $ret = $oPlayer->backup_to_db($data, '_field');
                 echo "backup player player_id:{$player_id} ret:{$ret}\n";
                 unset($ret);
             }
             unset($data, $cache_key);
         }
     }
 }
 public function run()
 {
     if (1 == OPERATOR_ID && SERVER_ID > 2) {
         $url = "http://api.uuzu.com/platform/user/info";
         $oPlayer = new Data_Player();
         $oAccount = new Data_Account();
         $sql = 'select * from account where plat_reg_time=-1;';
         $oAccount->query($sql);
         $records = array();
         while ($oAccount->next_record()) {
             $records[] = $oAccount->get_record();
         }
         foreach ($records as $user) {
             $arrData = array();
             $arrData['account'] = $user['user_account'];
             $arrData['game_id'] = 1;
             $arrData['fields'] = 'reg_time';
             ksort($arrData);
             $auth = $this->createAuth($arrData);
             $arrData['verify'] = md5($auth . 'NBg5akoBBLiiqKsW');
             $dataArr = json_decode(Com_System::open_url($url, 'post', $arrData, 5), true);
             if ($dataArr['status'] == 0 && isset($dataArr['userinfo']) && isset($dataArr['userinfo']['reg_time']) && !empty($dataArr['userinfo']['reg_time'])) {
                 $oPlayer->start_trans();
                 if (date('Ymd', $user['add_time']) == date('Ymd', $dataArr['userinfo']['reg_time'])) {
                     $new_acc = 1;
                 } else {
                     $new_acc = 0;
                 }
                 $arr = array('plat_reg_time' => $dataArr['userinfo']['reg_time'], 'new_plat_account' => $new_acc);
                 $sql = 'update account set  plat_reg_time=' . $arr['plat_reg_time'] . ' , new_plat_account=' . $new_acc . ' where player_id=' . $user['player_id'];
                 $ret = $oAccount->query($sql);
                 if ($ret) {
                     if ($user['name'] && $user['new_plat_account'] != $new_acc) {
                         $ret = $oPlayer->update_player_info($user['player_id'], $arr);
                         if ($ret) {
                             $sql = 'update player set plat_reg_time=' . $arr['plat_reg_time'] . ' , new_plat_account=' . $new_acc . ' where player_id=' . $user['player_id'];
                             $oPlayer->query($sql);
                             if ($oPlayer->affected_rows() > 0) {
                                 $ret = true;
                             } else {
                                 $ret = false;
                             }
                         }
                     }
                 }
                 if ($ret) {
                     $oPlayer->commit();
                 } else {
                     $oPlayer->rollback();
                 }
             } else {
                 $arr = array('plat_reg_time' => 1, 'new_plat_account' => 0);
                 $oPlayer->start_trans();
                 $sql = 'update account set  plat_reg_time=' . $arr['plat_reg_time'] . ' , new_plat_account=0 where player_id=' . $user['player_id'];
                 $ret = $oAccount->query($sql);
                 if ($ret) {
                     if ($user['name']) {
                         $ret = $oPlayer->update_player_info($user['player_id'], $arr);
                         if ($ret) {
                             $sql = 'update player set plat_reg_time=' . $arr['plat_reg_time'] . ' , new_plat_account=0 where player_id=' . $user['player_id'];
                             $oPlayer->query($sql);
                             if ($oPlayer->affected_rows() > 0) {
                                 $ret = true;
                             } else {
                                 $ret = false;
                             }
                         } else {
                             $ret = false;
                         }
                     }
                 }
                 if ($ret) {
                     $oPlayer->commit();
                 } else {
                     $oPlayer->rollback();
                 }
             }
             $rd = rand(1, 10);
             if (1 == $rd) {
                 sleep(1);
             }
         }
     }
 }