public static function GetCharacterData($CharacterName) { global $FCCore; $Statement = Characters::$CharConnection->prepare(' SELECT cc.guid, cc.account, cc.name, cc.race, cc.class, cc.gender, cc.level, cc.chosenTitle, cc.health, cc.power1, cc.power2, cc.power3, cc.power4, cc.power5, cc.online, fct.name_loc0 as title, g.name as guild_name FROM characters cc LEFT JOIN ' . $FCCore['Database']['database'] . '.freedomcore_char_titles fct ON cc.chosenTitle = fct.id LEFT JOIN guild_member gm ON cc.guid = gm.guid LEFT JOIN guild g ON gm.guildid = g.guildid WHERE cc.name = :charname '); $Statement->bindParam(':charname', $CharacterName); $Statement->execute(); $Result = $Statement->fetch(PDO::FETCH_ASSOC); $Result['race_data'] = Characters::GetRaceByID($Result['race']); $Result['class_data'] = Characters::GetClassByID($Result['class']); $Result['title'] = str_replace('%s', '', str_replace('%s, ', '', $Result['title'])); $Result['side'] = Characters::GetSideByRaceID($Result['race'])['name']; $Result['side_id'] = Characters::GetSideByRaceID($Result['race'])['id']; $Result['side_translation'] = Characters::GetSideByRaceID($Result['race'])['translation']; $Result['apoints'] = Characters::GetAchievementPoints($Result['guid'])['points']; $Result['acount'] = Characters::GetAchievementPoints($Result['guid'])['count']; $LevelStatsStatement = Characters::$WConnection->prepare(' SELECT pls.str, pls.agi, pls.sta, pls.inte, pls.spi, pcls.basehp, pcls.basemana FROM player_levelstats pls LEFT JOIN player_classlevelstats pcls ON pls.class = pcls.class WHERE pls.level = pcls.level AND pls.race = :race AND pls.class = :class AND pls.level = :level '); $LevelStatsStatement->bindParam(':race', $Result['race']); $LevelStatsStatement->bindParam(':class', $Result['class']); $LevelStatsStatement->bindParam(':level', $Result['level']); $LevelStatsStatement->execute(); $Result['level_data'] = $LevelStatsStatement->fetch(PDO::FETCH_ASSOC); $Result['level_data']['parrypoints'] = Characters::GetParryRatingByLevel($Result['level']); $Result['level_data']['blockpoints'] = Characters::GetBlockRatingByLevel($Result['level']); $Result['level_data']['critpoints'] = Characters::GetCritRatingByLevel($Result['level']); $Result['level_data']['hastepoints'] = Characters::GetHasteRatingByLevel($Result['level']); $StatByClass = Characters::StatByClass($Result['class']); $Result['power_data'] = $StatByClass; $Result['power_data']['value'] = @$Result[$StatByClass['field']]; Characters::$CharacterLevel = $Result['level']; Characters::$CharacterClass = $Result['class']; Characters::$CharacterRace = $Result['race']; return $Result; }