Esempio n. 1
0
 /**
  * Loads all characters from DB
  * 
  * @access   public
  * @static   WoW_Account::LoadCharacters()
  * @category Account Manager Class
  * @return   bool
  **/
 private static function LoadCharacters()
 {
     self::$characters_loaded = false;
     self::$myGamesList = DB::WoW()->select("SELECT `account_id` FROM `DBPREFIX_users_accounts` WHERE `id` = %d", self::GetUserID());
     $account_ids = array();
     $accounts_count = count(self::$myGamesList);
     for ($i = 0; $i < $accounts_count; ++$i) {
         $account_ids[] = self::$myGamesList[$i]['account_id'];
     }
     if (is_array($account_ids) && $accounts_count > 0) {
         $total_chars_count = DB::Realm()->selectCell("SELECT SUM(`numchars`) FROM `realmcharacters` WHERE `acctid` IN (%s)", implode(', ', $account_ids));
         sprintf("SELECT SUM(`numchars`) FROM `realmcharacters` WHERE `acctid` IN (%s)", implode(', ', $account_ids));
         self::$characters_data = DB::WoW()->select("SELECT * FROM `DBPREFIX_user_characters` WHERE `account` IN (%s) ORDER BY `index`", implode(', ', $account_ids));
     } else {
         $total_chars_count = 0;
     }
     if (!self::$characters_data || count(self::$characters_data) != $total_chars_count) {
         self::LoadCharactersFromWorld();
     } else {
         self::$characters_loaded = true;
         for ($i = 0; $i < $total_chars_count; ++$i) {
             // Rebuild *_text fields
             self::$characters_data[$i]['class_text'] = WoW_Locale::GetString('character_class_' . self::$characters_data[$i]['class'], self::$characters_data[$i]['gender']);
             self::$characters_data[$i]['race_text'] = WoW_Locale::GetString('character_race_' . self::$characters_data[$i]['race'], self::$characters_data[$i]['gender']);
             self::$characters_data[$i]['faction_text'] = WoW_Utils::GetFactionId(self::$characters_data[$i]['race']) == FACTION_ALLIANCE ? 'alliance' : 'horde';
             // Rebuild character url
             self::$characters_data[$i]['url'] = sprintf('%s/wow/%s/character/%s/%s/', WoW::GetWoWPath(), WoW_Locale::GetLocale(), self::$characters_data[$i]['realmName'], self::$characters_data[$i]['name']);
             // Realm status
             $status = WoW::GetRealmStatus(self::$characters_data[$i]['realmId']);
             self::$characters_data[$i]['realmStatus'] = isset($status[0], $status[0]['status']) ? $status[0]['status'] : 'down';
             if (self::$characters_data[$i]['isActive']) {
                 self::$active_character = self::$characters_data[$i];
             }
         }
         return true;
     }
     if (!self::$characters_data) {
         return false;
     }
     $active_set = false;
     $index = 0;
     DB::WoW()->query("DELETE FROM `DBPREFIX_user_characters` WHERE `account` IN (%s)", $account_ids);
     foreach (self::$characters_data as $char) {
         DB::WoW()->query("INSERT INTO `DBPREFIX_user_characters` VALUES (%d, %d, %d, %d, '%s', %d, '%s', '%s', %d, '%s', '%s', %d, %d, %d, '%s', %d, %d, '%s', %d, '%s', '%s', '%s')", self::GetUserID(), $char['account'], $index, $char['guid'], $char['name'], $char['class'], $char['class_text'], $char['class_key'], $char['race'], $char['race_text'], $char['race_key'], $char['gender'], $char['level'], $char['realmId'], $char['realmName'], $active_set ? 0 : 1, $char['faction'], $char['faction_text'], $char['guildId'], $char['guildName'], $char['guildUrl'], $char['url']);
         if (!$active_set) {
             self::$active_character = $char;
             $active_set = true;
         }
         ++$index;
     }
     self::$characters_loaded = true;
     return true;
 }