brusselopole / Worldopole

        return $points;

    }

    public function getPokemonGraph($pokemon_id)

    {

        $req = "SELECT COUNT(*) AS total, HOUR(disappear_time) AS disappear_hour

					FROM (SELECT FROM_UNIXTIME(expire_timestamp) as disappear_time FROM sightings WHERE pokemon_id = '".$pokemon_id."' LIMIT 100000) AS pokemonFiltered

				GROUP BY disappear_hour

				ORDER BY disappear_hour";

        $result = $this->mysqli->query($req);

        $array = array_fill(0, 24, 0);

        while ($result && $data = $result->fetch_object()) {

            $array[$data->disappear_hour] = $data->total;

        }

        // shift array because AM/PM starts at 1AM not 0:00

        $array[] = $array[0];

        array_shift($array);

        return $array;

    }

        return $points;

    }

    public function getPokemonGraph($pokemon_id)

    {

        $req = "SELECT COUNT(*) AS total,

				HOUR(CONVERT_TZ(disappear_time, '+00:00', '".self::$time_offset."')) AS disappear_hour

				FROM (SELECT disappear_time FROM pokemon WHERE pokemon_id = '".$pokemon_id."' LIMIT 100000) AS pokemonFiltered

				GROUP BY disappear_hour

				ORDER BY disappear_hour";

        $result = $this->mysqli->query($req);

        $array = array_fill(0, 24, 0);

        while ($result && $data = $result->fetch_object()) {

            $array[$data->disappear_hour] = $data->total;

        }

        // shift array because AM/PM starts at 1AM not 0:00

        $array[] = $array[0];

        array_shift($array);

        return $array;

    }