brusselopole / Worldopole

    return $reqRanking;

}

function req_trainer_levels_for_team($teamid)

{

    global $config;

    $reqLevels = "SELECT level, count(level) AS count FROM trainer WHERE team = '" . $teamid . "'";

    if (!empty($config->system->trainer_blacklist)) {

        $reqLevels .= " AND name NOT IN ('" . implode("','", $config->system->trainer_blacklist) . "')";

    }

    $reqLevels .= " GROUP BY level";

    return $reqLevels;

}

// Raids

########

// Nests

########

function req_map_data()

{

    global $config;

    $pokemon_exclude_sql = "";

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

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

    }

    return "SELECT p.pokemon_id, max(p.latitude) AS latitude, max(p.longitude) AS longitude, count(p.pokemon_id) AS total_pokemon, s.latest_seen, (LENGTH(s.kind) - LENGTH( REPLACE ( kind, \"s\", \"\") )) * 900 AS duration

          FROM pokemon p 

          INNER JOIN spawnpoint s ON (p.spawnpoint_id = s.id) 

          WHERE p.disappear_time > UTC_TIMESTAMP() - INTERVAL 24 HOUR 

          " . $pokemon_exclude_sql . " 

          GROUP BY p.spawnpoint_id, p.pokemon_id 

          HAVING COUNT(p.pokemon_id) >= 6 

          ORDER BY p.pokemon_id";

}