Re: Where are the Tournament maps?
Posted: Sat Jul 30, 2016 5:01 pm
If deen really don't do it now just because Leute posted something then it's pretty strange. He probably just realiesed he got something to do the next weekends huh?
DDraceNetwork Forum
https://forum.ddnet.org:443/
Code: Select all
MariaDB [teeworlds]> select record_maps.Map, count(*) from record_race join record_maps on record_race.Map = record_maps.Map where record_maps.Server = "Novice" group by record_maps.Map order by count(*) desc limit 10;
+------------+----------+
| Map | count(*) |
+------------+----------+
| Just2Easy | 39590 |
| Kobra 2 | 27030 |
| Kobra | 23837 |
| StepByStep | 19996 |
| Gold Mine | 17410 |
| Absurd 4 | 17387 |
| Epix | 16266 |
| Absurd 2 | 15645 |
| Multimap | 15190 |
| Camouflage | 13801 |
+------------+----------+
10 rows in set (2.99 sec)
MariaDB [teeworlds]> select record_maps.Map, count(*) from record_race join record_maps on record_race.Map = record_maps.Map where record_maps.Server = "Moderate" group by record_maps.Map order by count(*) desc limit 10;
+--------------+----------+
| Map | count(*) |
+--------------+----------+
| Hookthrough | 10465 |
| HookThrough3 | 8458 |
| MonkeyDream | 6194 |
| Monster | 5391 |
| Coffee I | 4865 |
| Cup of Tee | 3968 |
| Baby Aim 2.0 | 3633 |
| SimplePlay 3 | 3580 |
| Baby Aim 1.0 | 3563 |
| Coffee II | 3343 |
+--------------+----------+
10 rows in set (0.96 sec)
Looks nice idea.deen wrote:SpoilerShowI honestly don't like the idea of winning something, since the tournaments are never 100% fair for everyone, so people end up pissed that they lose because of a lag.
My current plan for the next weekend (6. & 7. August) looks like this:
The Brutal Birthday Holiday WeekendSo whatever you like, you can participate in one or all, and we end up with 4 winning teams.
- Saturday: Until 19:30 long tournament on a nice old Novice or Moderate map, best time wins
- Saturday: 20:00 quick tournament on Tropical Island by RayB (Brutal 2*, tested by BlaGK, ready)
- Sunday: Until 19:30 long tournament on a nice old Novice or Moderate map, best time wins
- Sunday: 20:00 quick tournament on Aviate by SickCunt & [A] Awesome (Brutal, will be tested by Lady Saavik)
Any opinions? Suggestions for the long tournament maps? Should I just take the most popular ones? Which ones would be a good fit for a tournament?
For reference, the most finished Novice and Moderate maps:
Code: Select all
MariaDB [teeworlds]> select record_maps.Map, count(*) from record_race join record_maps on record_race.Map = record_maps.Map where record_maps.Server = "Novice" group by record_maps.Map order by count(*) desc limit 10; +------------+----------+ | Map | count(*) | +------------+----------+ | Just2Easy | 39590 | | Kobra 2 | 27030 | | Kobra | 23837 | | StepByStep | 19996 | | Gold Mine | 17410 | | Absurd 4 | 17387 | | Epix | 16266 | | Absurd 2 | 15645 | | Multimap | 15190 | | Camouflage | 13801 | +------------+----------+ 10 rows in set (2.99 sec) MariaDB [teeworlds]> select record_maps.Map, count(*) from record_race join record_maps on record_race.Map = record_maps.Map where record_maps.Server = "Moderate" group by record_maps.Map order by count(*) desc limit 10; +--------------+----------+ | Map | count(*) | +--------------+----------+ | Hookthrough | 10465 | | HookThrough3 | 8458 | | MonkeyDream | 6194 | | Monster | 5391 | | Coffee I | 4865 | | Cup of Tee | 3968 | | Baby Aim 2.0 | 3633 | | SimplePlay 3 | 3580 | | Baby Aim 1.0 | 3563 | | Coffee II | 3343 | +--------------+----------+ 10 rows in set (0.96 sec)