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;
}
