public static function GetCharacterProfessions($CharacterGuid)
{
$Statement = Characters::$CharConnection->prepare('SELECT * FROM character_skills WHERE guid = :guid');
$Statement->bindParam(':guid', $CharacterGuid);
$Statement->execute();
$Result = $Statement->fetchAll(PDO::FETCH_ASSOC);
$Index = 0;
$CharacterProfessions = array();
foreach ($Result as $Profession) {
$ProfessionData = Characters::GetProfessionData($Profession['skill']);
if ($ProfessionData != false) {
$CharacterProfessions[] = array('id' => $Profession['skill'], 'name' => $ProfessionData['name'], 'primary' => $ProfessionData['primary'], 'translation' => $ProfessionData['translation'], 'current' => $Profession['value'], 'max' => $Profession['max'], 'title' => Characters::ProfessionTitle($Profession['max']));
}
}
return $CharacterProfessions;
}
