public static function GetResetStatus($JSONP) { $WorldStates = [20001, 20002, 20003, 20006, 20007]; $Response = []; $Statement = parent::$CharConnection->prepare('SELECT * from worldstates WHERE entry IN(20001, 20002, 20003, 20006, 20007);'); $Statement->execute(); $Result = $Statement->fetchAll(PDO::FETCH_ASSOC); if (Database::IsEmpty($Statement)) { foreach ($WorldStates as $ID) { $Response[] = [ArmoryAPI::GetWorldstateByID($ID) => '0']; } } else { foreach ($Result as $WS) { foreach ($WorldStates as $ID) { if ($ID == $WS['entry']) { $Response[] = [ArmoryAPI::GetWorldstateByID($ID) => $WS['value']]; break; } else { $Response[] = [ArmoryAPI::GetWorldstateByID($WS['entry']) => '0']; break; } } } } return parent::Encode($Response, $JSONP, "wsrt"); }
public static function GetSimpleSpell($SpellID, $JSONP) { $SpellInfo = Spells::SpellInfo($SpellID); if ($SpellInfo) { $SpellData = Text::RemapArray($SpellInfo, ['SpellID', 'Name', 'Description', 'icon'], ['id', 'name', 'description', 'icon']); parent::Encode($SpellData, $JSONP); } else { parent::GenerateResponse(404, true); } }
public static function ItemClasses($JSONP) { $Result = Items::ItemSubClass(null, null, false, true); $JSONArray = []; foreach ($Result as $Key => $Value) { $ClassArray = []; $ClassArray['class'] = $Key; $ClassArray['name'] = Items::ItemClass($Key)['translation']; $ClassArray['subclasses'] = []; foreach ($Value as $SKey => $SValue) { $ClassArray['subclasses'][] = ['subclass' => $SValue['subclass'], "name" => $SValue['translation']]; } $JSONArray[] = $ClassArray; } parent::Encode($JSONArray, $JSONP, 'classes'); }
public static function GetSimpleAchievement($AchievementID, $JSONP) { $Statement = parent::$DBConnection->prepare('SELECT a.id, a.faction as factionID, a.name_loc0 as title, a.description_loc0 as description, a.points, a.reward_loc0 as reward, LOWER(si.iconname) as icon FROM freedomcore_achievement a LEFT JOIN freedomcore_spellicons si ON a.icon = si.id WHERE a.id = :aid'); $Statement->bindParam(':aid', $AchievementID); $Statement->execute(); $Result = $Statement->fetch(PDO::FETCH_ASSOC); if ($Statement->rowCount() > 0) { $GetAchievementCriterias = AchievementAPI::GetAchievementCriteria($AchievementID); foreach ($GetAchievementCriterias as $Criteria) { $Result['criteria'][] = $Criteria; } return parent::Encode($Result, $JSONP); } else { return parent::GenerateResponse(404, true); } }
public static function GetCharacters($Username, $Password, $JSONP) { $GameData = AccountAPI::GetUserBasicData($Username, $Password); if (isset($GameData['code'])) { return parent::Encode($GameData, $JSONP); } else { $Statement = parent::$CharConnection->prepare('SELECT name, race, class, gender, level, money FROM characters WHERE account = :accountid'); $Statement->bindParam(":accountid", $GameData['id']); $Statement->execute(); $Result = $Statement->fetchAll(PDO::FETCH_ASSOC); $ArrayIndex = 0; foreach ($Result as $Character) { $Result[$ArrayIndex]['race'] = Characters::GetRaceByID($Character['race']); $Result[$ArrayIndex]['class'] = Characters::GetClassByID($Character['class']); $Result[$ArrayIndex]['class'] = Characters::GetClassByID($Character['class']); $Result[$ArrayIndex]['money'] = Text::MoneyToCoins($Character['money']); $ArrayIndex++; } return parent::Encode($Result, $JSONP, "characters"); } }
public static function GetItemSet($SetID, $JSONP) { $Statement = parent::$DBConnection->prepare('SELECT * FROM freedomcore_itemset WHERE itemsetID = :setid'); $Statement->bindParam(':setid', $SetID); $Statement->execute(); $Result = $Statement->fetch(PDO::FETCH_ASSOC); if ($Statement->rowCount() > 0) { $FinalArray = []; $FinalArray['id'] = $Result['itemsetID']; $FinalArray['name'] = $Result['name_loc0']; $i = 8; while ($i > 0) { if ($Result['bonus' . $i] != 0) { $FinalArray['setBonuses'][] = ['description' => Spells::SpellInfo($Result['spell' . $i])['Description'], 'threshold' => $Result['bonus' . $i]]; } $i--; } $SetItems = []; for ($i = 1; $i <= 10; $i++) { if ($Result['item' . $i] != 0) { $SetItems[] = $Result['item' . $i]; } } $FinalArray['items'] = $SetItems; parent::Encode($FinalArray, $JSONP); } else { parent::GenerateResponse(404, true); } }