api_load_toons.php

<?
if(strpos($_SERVER['SERVER_NAME'], "docker")===false) {
    require_once("../vars.php");
    require_once("../libs.php");
    require_once("../api_swgoh_help3.php");
    $db = new mymysqli("swgoh");
    error_reporting(0);
} else {
    require_once("../../vars.php");
    require_once("../libs.php");
    require_once("../api_swgoh_help3.php");
    $db = new mymysqli("swgoh");
    error_reporting(E_ALL);
}
?>
<pre>
<?
try {
    
    //https://api.swgoh.help/swgoh
    $swgoh = new SwgohHelp($swgohHelpKeys);
    
    $db->query("DELETE FROM swgoh_toons2");

    $data = $swgoh->fetchData('unitsList',"eng_us",array("rarity"=>7,"obtainable"=>true,"obtainableTime"=>0),array("id"=>1,"nameKey"=>1,"combatType"=>1,"obtainable"=>1,"maxRarity"=>1,"forceAlignment"=>1,"obtainableTime"=>1));
    print_r($data);
    foreach($data as $toon) {
        $id = explode(":", $toon->id);
        if($toon->obtainable && $toon->maxRarity==7 && $toon->obtainableTime==0) {
            $db->query("REPLACE INTO swgoh_toons2(id,name,type) VALUES('".$db->str($id[0])."','".$db->str($toon->nameKey)."',".intval($toon->combatType).")");
            echo $toon->nameKey."<br />";
        }
    }

//TODO: Get farming locations
// $data = $swgoh->fetchData('materialList',"eng_us",array("type"=>3),array("id"=>1,"nameKey"=>1,"lookupMissionList"=>1));
// print_r($data);

   

} catch(Exception $e) {
    echo $e;
}
?>