brusselopole / Worldopole

        return $data;

    }

    public function getNestData($time, $minLatitude, $maxLatitude, $minLongitude, $maxLongitude)

    {

        $pokemon_exclude_sql = '';

        if (!empty(self::$config->system->nest_exclude_pokemon)) {

            $pokemon_exclude_sql = 'AND p.pokemon_id NOT IN ('.implode(',', self::$config->system->nest_exclude_pokemon).')';

        }

        $req = 'SELECT p.pokemon_id, MAX(p.lat) AS latitude, MAX(p.lon) AS longitude, count(p.pokemon_id) AS total_pokemon, MAX(s.updated) as latest_seen, coalesce(CASE WHEN MAX(duration) = 0 THEN NULL ELSE MAX(duration) END ,30)*60 as duration

			          FROM sightings p

			          INNER JOIN spawnpoints s ON (p.spawn_id = s.spawn_id)

			          WHERE p.expire_timestamp > UNIX_TIMESTAMP() - '.($time * 3600).'

			            AND p.lat >= '.$minLatitude.' AND p.lat < '.$maxLatitude.' AND p.lon >= '.$minLongitude.' AND p.lon < '.$maxLongitude.'

			          '.$pokemon_exclude_sql.'

			          GROUP BY p.spawn_id, p.pokemon_id

			          HAVING COUNT(p.pokemon_id) >= '.($time / 4).'

			          ORDER BY p.pokemon_id';

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

        $nests = array();

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

            $nests[] = $data;

        }

        return $nests;

    }

        return $data;

    }

    public function getNestData($time, $minLatitude, $maxLatitude, $minLongitude, $maxLongitude)

    {

        $pokemon_exclude_sql = '';

        if (!empty(self::$config->system->nest_exclude_pokemon)) {

            $pokemon_exclude_sql = 'AND pokemon_id NOT IN ('.implode(',', self::$config->system->nest_exclude_pokemon).')';

        }

        $req = 'SELECT spawnpoint_id, pokemon_id, MAX(latitude) AS latitude, MAX(longitude) AS longitude, count(pokemon_id) AS total_pokemon,

				MAX(UNIX_TIMESTAMP(disappear_time)) as latest_seen

				FROM pokemon

				WHERE disappear_time > (UTC_TIMESTAMP() - INTERVAL '.$time.' HOUR)

				AND latitude >= '.$minLatitude.' AND latitude < '.$maxLatitude.' AND longitude >= '.$minLongitude.' AND longitude < '.$maxLongitude.'

				'.$pokemon_exclude_sql.' 

				GROUP BY spawnpoint_id, pokemon_id 

				HAVING COUNT(pokemon_id) >= '.($time / 4).'

				ORDER BY pokemon_id';

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

        $nests = array();

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

            $nests[] = $data;

        }

        return $nests;

    }