<?php header('Access-Control-Allow-Origin: *'); ?>
<?php
$servername = "127.0.0.1";
$username = "";
$password = "";
$dbname = "";

$content = "Empty";
$input = file_get_contents('php://input');
$data = json_decode($input, TRUE);
$data2 = json_decode($data);
foreach ($data2 as $name => $value) {
    if ($name != "result") { echo 'Error - Call Failed'; break; }
    echo $name . ':';
    echo '<br><br>';
    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }
    foreach ($value as $entry) {
        $spawnid = $entry->spawn_point_id;
        $encounterid = $entry->encounter_id;
        $pokemonName = strtolower($entry->pokemon_id);
        $epochTime = $entry->expiration_timestamp_ms;
        $longitude = $entry->longitude;
        $latitude = $entry->latitude;
        $dissapear_time = gmdate('Y-m-d H:i:s', $epochTime/1000);
		//$content = $content . $dissapear_time;
        echo '<br>';

        //Pokemon Name to PokeID translation
switch ($pokemonName) {
case "ditto":
$pokemonid = 132;
break;
case "poliwag":
$pokemonid = 60;
break;
case "poliwhirl":
$pokemonid = 61;
break;
case "poliwrath":
$pokemonid = 62;
break;
case "abra":
$pokemonid = 63;
break;
case "kadabra":
$pokemonid = 64;
break;
case "alakazam":
$pokemonid = 65;
break;
case "machop":
$pokemonid = 66;
break;
case "machoke":
$pokemonid = 67;
break;
case "machamp":
$pokemonid = 68;
break;
case "bellsprout":
$pokemonid = 69;
break;
case "omastar":
$pokemonid = 139;
break;
case "omanyte":
$pokemonid = 138;
break;
case "arbok":
$pokemonid = 24;
break;
case "pikachu":
$pokemonid = 25;
break;
case "raichu":
$pokemonid = 26;
break;
case "sandshrew":
$pokemonid = 27;
break;
case "raticate":
$pokemonid = 20;
break;
case "spearow":
$pokemonid = 21;
break;
case "fearow":
$pokemonid = 22;
break;
case "ekans":
$pokemonid = 23;
break;
case "sandslash":
$pokemonid = 28;
break;
case "nidoran♀":
$pokemonid = 29;
break;
case "marowak":
$pokemonid = 105;
break;
case "gyarados":
$pokemonid = 130;
break;
case "ivysaur":
$pokemonid = 2;
break;
case "charmander":
$pokemonid = 4;
break;
case "charizard":
$pokemonid = 6;
break;
case "tauros":
$pokemonid = 128;
break;
case "wartortle":
$pokemonid = 8;
break;
case "drowzee":
$pokemonid = 96;
break;
case "seaking":
$pokemonid = 119;
break;
case "staryu":
$pokemonid = 120;
break;
case "kingler":
$pokemonid = 99;
break;
case "krabby":
$pokemonid = 98;
break;
case "mr. mime":
$pokemonid = 122;
break;
case "scyther":
$pokemonid = 123;
break;
case "jynx":
$pokemonid = 124;
break;
case "goldeen":
$pokemonid = 118;
break;
case "magmar":
$pokemonid = 126;
break;
case "pinsir":
$pokemonid = 127;
break;
case "cloyster":
$pokemonid = 91;
break;
case "arcanine":
$pokemonid = 59;
break;
case "haunter":
$pokemonid = 93;
break;
case "gastly":
$pokemonid = 92;
break;
case "onix":
$pokemonid = 95;
break;
case "gengar":
$pokemonid = 94;
break;
case "hypno":
$pokemonid = 97;
break;
case "growlithe":
$pokemonid = 58;
break;
case "metapod":
$pokemonid = 11;
break;
case "caterpie":
$pokemonid = 10;
break;
case "weedle":
$pokemonid = 13;
break;
case "butterfree":
$pokemonid = 12;
break;
case "beedrill":
$pokemonid = 15;
break;
case "kakuna":
$pokemonid = 14;
break;
case "pidgeotto":
$pokemonid = 17;
break;
case "pidgey":
$pokemonid = 16;
break;
case "rattata":
$pokemonid = 19;
break;
case "pidgeot":
$pokemonid = 18;
break;
case "primeape":
$pokemonid = 57;
break;
case "mankey":
$pokemonid = 56;
break;
case "dugtrio":
$pokemonid = 51;
break;
case "diglett":
$pokemonid = 50;
break;
case "persian":
$pokemonid = 53;
break;
case "meowth":
$pokemonid = 52;
break;
case "golduck":
$pokemonid = 55;
break;
case "horsea":
$pokemonid = 116;
break;
case "psyduck":
$pokemonid = 54;
break;
case "porygon":
$pokemonid = 137;
break;
case "shellder":
$pokemonid = 90;
break;
case "flareon":
$pokemonid = 136;
break;
case "mew":
$pokemonid = 151;
break;
case "mewtwo":
$pokemonid = 150;
break;
case "jolteon":
$pokemonid = 135;
break;
case "vaporeon":
$pokemonid = 134;
break;
case "kangaskhan":
$pokemonid = 115;
break;
case "tangela":
$pokemonid = 114;
break;
case "grimer":
$pokemonid = 88;
break;
case "muk":
$pokemonid = 89;
break;
case "rhyhorn":
$pokemonid = 111;
break;
case "weezing":
$pokemonid = 110;
break;
case "chansey":
$pokemonid = 113;
break;
case "rhydon":
$pokemonid = 112;
break;
case "magneton":
$pokemonid = 82;
break;
case "farfetch'd":
$pokemonid = 83;
break;
case "slowbro":
$pokemonid = 80;
break;
case "magnemite":
$pokemonid = 81;
break;
case "seel":
$pokemonid = 86;
break;
case "dewgong":
$pokemonid = 87;
break;
case "doduo":
$pokemonid = 84;
break;
case "dodrio":
$pokemonid = 85;
break;
case "cubone":
$pokemonid = 104;
break;
case "seadra":
$pokemonid = 117;
break;
case "magikarp":
$pokemonid = 129;
break;
case "venonat":
$pokemonid = 48;
break;
case "venomoth":
$pokemonid = 49;
break;
case "paras":
$pokemonid = 46;
break;
case "parasect":
$pokemonid = 47;
break;
case "gloom":
$pokemonid = 44;
break;
case "vileplume":
$pokemonid = 45;
break;
case "golbat":
$pokemonid = 42;
break;
case "oddish":
$pokemonid = 43;
break;
case "wigglytuff":
$pokemonid = 40;
break;
case "zubat":
$pokemonid = 41;
break;
case "bulbasaur":
$pokemonid = 1;
break;
case "venusaur":
$pokemonid = 3;
break;
case "charmeleon":
$pokemonid = 5;
break;
case "squirtle":
$pokemonid = 7;
break;
case "blastoise":
$pokemonid = 9;
break;
case "moltres":
$pokemonid = 146;
break;
case "dratini":
$pokemonid = 147;
break;
case "articuno":
$pokemonid = 144;
break;
case "zapdos":
$pokemonid = 145;
break;
case "aerodactyl":
$pokemonid = 142;
break;
case "snorlax":
$pokemonid = 143;
break;
case "kabuto":
$pokemonid = 140;
break;
case "kabutops":
$pokemonid = 141;
break;
case "dragonair":
$pokemonid = 148;
break;
case "dragonite":
$pokemonid = 149;
break;
case "ponyta":
$pokemonid = 77;
break;
case "golem":
$pokemonid = 76;
break;
case "graveler":
$pokemonid = 75;
break;
case "geodude":
$pokemonid = 74;
break;
case "tentacruel":
$pokemonid = 73;
break;
case "tentacool":
$pokemonid = 72;
break;
case "victreebel":
$pokemonid = 71;
break;
case "weepinbell":
$pokemonid = 70;
break;
case "exeggcute":
$pokemonid = 102;
break;
case "exeggutor":
$pokemonid = 103;
break;
case "voltorb":
$pokemonid = 100;
break;
case "electrode":
$pokemonid = 101;
break;
case "hitmonlee":
$pokemonid = 106;
break;
case "hitmonchan":
$pokemonid = 107;
break;
case "slowpoke":
$pokemonid = 79;
break;
case "rapidash":
$pokemonid = 78;
break;
case "eevee":
$pokemonid = 133;
break;
case "lickitung":
$pokemonid = 108;
break;
case "jigglypuff":
$pokemonid = 39;
break;
case "ninetales":
$pokemonid = 38;
break;
case "starmie":
$pokemonid = 121;
break;
case "nidorino":
$pokemonid = 33;
break;
case "nidoran♂":
$pokemonid = 32;
break;
case "nidoqueen":
$pokemonid = 31;
break;
case "nidorina":
$pokemonid = 30;
break;
case "vulpix":
$pokemonid = 37;
break;
case "clefable":
$pokemonid = 36;
break;
case "clefairy":
$pokemonid = 35;
break;
case "nidoking":
$pokemonid = 34;
break;
case "lapras":
$pokemonid = 131;
break;
case "koffing":
$pokemonid = 109;
break;
case "electabuzz":
$pokemonid = 125;
break;
}

		echo $pokemonid . "<BR>";
		echo $spawnid . "<BR>";
        echo $encounterid . "<BR>";
        echo $pokemonName . "<BR>";
        echo $epochTime . "<BR>";
        echo $longitude . "<BR>";
        echo $latitude . "<BR>";
        echo $dissapear_time;
        $sql = "INSERT INTO pokemon (encounter_id, spawnpoint_id, pokemon_id, latitude, longitude, disappear_time) VALUES ('$encounterid', '$spawnid', '$pokemonid', '$latitude', '$longitude', '$dissapear_time') ON DUPLICATE KEY UPDATE pokemon_id='$pokemonid', latitude='$latitude', longitude='$longitude', disappear_time='$dissapear_time';";
        if ($conn->query($sql) === TRUE) { echo "Inserted to database successfully"; }
        else { echo "Error: " . $sql . "<br>" . $conn->error; }
        $content = $conn->error;

    }
        $conn->close();
}
$fp = fopen("output.txt","wb");
fwrite($fp,$content);
fclose($fp);
?>