ef6282d
Replace remaining int64_t by int64 for the sake of consistency - Kaffeine
a9bc619
CGameControllerDDRace: Add Score() getter - Kaffeine
a6bdda6
GameController: Add OnPlayerConnect() like in the upstream - Kaffeine
b0c0fb3
Get rid of gamemode.h with confusing definitions - Kaffeine
688f11e
Move DDRace-specific player initialization code to the Controller - Kaffeine
dfc7580
CGameContext::SendVoteStatus: Hide the trick for 64 clients - Kaffeine
2790270
Adopt upstream refactoring: Mark several functions as 'const' - Kaffeine
6b49bf1
Make spectators stay specs on map changed - Kaffeine
908646e
Merge #3605 - bors[bot](void)Uninitialized; // We need a reference for the next line.
why is this needed?select distinct r.Name, r.ID, r.Time, r.Timestamp, n.Server from (select distinct ID from record_teamrace where Map = 'Multeasymap' ORDER BY Time limit 20) as l left join (select * from record_teamrace where Map = 'Multeasymap') as r on l.ID = r.ID inner join ((select distinct Map, Name, Time, SUBSTRING(Server, 1, 3) as Server from record_race) as n) on r.Map = n.Map and r.Name = n.Name and r.Time = n.Time order by r.Time, r.ID, r.Name;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-----------------+------+------------------------------------+--------------+---------+---------------------------------------------------------------+--------+-----------------------------------------------------------+
| 1 | PRIMARY | <derived2> | ALL | NULL | NULL | NULL | NULL | 20 | Using temporary; Using filesort |
| 1 | PRIMARY | record_teamrace | ref | PRIMARY,Name,Map,ID,MapID | ID | 532 | l.ID,const | 1 | Using where; Using index |
| 1 | PRIMARY | <derived4> | ref | key0 | key0 | 70 | teeworlds.record_teamrace.Name,teeworlds.record_teamrace.Time | 10 | Using where |
| 4 | DERIVED | record_race | ref | Map,Map_2,MapTimestamp,MapNameTime | MapTimestamp | 514 | const | 161796 | Using where; Using index; Using temporary |
| 2 | DERIVED | record_teamrace | ref | PRIMARY,Map,MapID | PRIMARY | 514 | const | 20044 | Using where; Using index; Using temporary; Using filesort |
select distinct r.Name, r.ID, r.Time, r.Timestamp, SUBSTRING(n.Server, 1, 3) from (select distinct ID from record_teamrace where Map = 'Multeasymap' ORDER BY Time limit 20) as l left join record_teamrace as r on l.ID = r.ID inner join record_race as n on r.Map = n.Map and r.Name = n.Name and r.Time = n.Time order by r.Time, r.ID, r.Name;