public static function GetReputation($CharacterGUID) { global $FCCore; $Statement = Characters::$CharConnection->prepare(' SELECT cr.*, ff.name_loc0 FROM character_reputation cr LEFT JOIN ' . $FCCore['Database']['database'] . '.freedomcore_factions ff ON cr.faction = ff.factionID WHERE guid = :guid AND ff.team != 0 AND cr.flags IN (17, 81) ORDER BY ff.name_loc0 '); $Statement->bindParam(':guid', $CharacterGUID); $Statement->execute(); $Result = $Statement->fetchAll(PDO::FETCH_ASSOC); $Index = 0; foreach ($Result as $Faction) { $ReputationData = Characters::ReputationSplitter($Faction['standing'], $Faction['faction']); $Result[$Index]['rank'] = $ReputationData['rank']; $Result[$Index]['translation'] = $ReputationData['translation']; $Result[$Index]['max'] = $ReputationData['maximum']; $Result[$Index]['site_reputation'] = Characters::SubstituteByRang($ReputationData['rank'], $Faction['standing'], $Faction['faction']); $Index++; } return $Result; }