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