brusselopole / Worldopole

		if (isset($team) && $team != '') {

			$where .= ($where == "" ? " WHERE" : " AND")." team_id = ".$team;

		}

		switch ($ranking) {

			case 1:

				$order = " ORDER BY name, last_modified DESC";

				break;

			case 2:

				$order = " ORDER BY total_cp DESC, last_modified DESC";

				break;

			default:

				$order = " ORDER BY last_modified DESC, name";

		}

		$limit = " LIMIT ".($page * 10).",10";

		if ($team != 0) {

			$where .= ($where == "" ? " HAVING" : " AND")." team = ".$team;

		}

		switch ($ranking) {

			case 1:

				$order = " ORDER BY active DESC, level DESC";

				break;

			case 2:

				$order = " ORDER BY maxCp DESC, level DESC";

				break;

			default:

				$order = " ORDER BY level DESC, active DESC";

		}

		$order .= ", last_seen DESC, name ";

		$limit = " LIMIT ".($page * 10).",10 ";

		$req = "SELECT trainer.*, COUNT(actives_pokemons.trainer_name) AS active, max(actives_pokemons.cp) AS maxCp