private static function LoadPvPData() { if (!self::IsCorrect()) { WoW_Log::WriteError('%s : character was not found.', __METHOD__); return false; } self::$pvp_data = DB::Characters()->select("\n SELECT\n a.*,\n b.rating,\n b.games_week,\n b.wins_week,\n b.games_season,\n b.wins_season,\n b.games_week-b.wins_week AS lost_week,\n b.games_season-b.wins_season AS lost_season,\n b.rank,\n c.guid,\n c.played_week,\n c.wons_week,\n c.played_season,\n c.wons_season,\n c.played_week-c.wons_week AS lost_week_personal,\n c.played_season-c.wons_season AS lost_season_personal,\n c.personal_rating,\n d.name AS charName,\n d.race,\n d.class,\n d.gender,\n d.level\n FROM arena_team AS a\n JOIN arena_team_stats AS b ON b.arenateamid = a.arenateamid\n JOIN arena_team_member AS c ON c.arenateamid = a.arenateamid\n JOIN characters AS d ON d.guid = c.guid\n WHERE c.guid = %d", self::GetGUID()); return true; }