"SELECT Name, Time, Rank, TeamSize "
"FROM (" // limit to 5
"SELECT TeamSize, Rank, ID "
"FROM (" // teamrank score board
"SELECT RANK() OVER w AS Rank, ID, COUNT(*) AS Teamsize "
"FROM %s_teamrace "
"WHERE Map = ? "
"GROUP BY Id "
"WINDOW w AS (ORDER BY Time)"
") as l1 "
"ORDER BY Rank %s "
"LIMIT %d, 5"
") as l2 "
"INNER JOIN %s_teamrace as r ON l2.ID = r.ID "
"ORDER BY Rank %s, r.ID, Name ASC;",
SELECT ID, Name, Time, rank FROM (SELECT r.ID, Name, rank, l.Time FROM ((SELECT ID, rank, Time FROM (SELECT ID, (@pos := IF(@previd = ID,@pos,@pos+1)) pos, (@previd := ID), (@rank := IF(@prev = Time,@rank,@pos)) rank, (@prev := Time) Time FROM (SELECT ID, MIN(Time) as Time FROM %s_teamrace WHERE Map = '%s' GROUP BY ID ORDER BY `Time` ASC) as all_top_times) as a LIMIT %d, 5) as l) LEFT JOIN %s_teamrace as r ON l.ID = r.ID ORDER BY Time ASC, r.ID, Name ASC) as a;
steam_appid.txt
next to the executable containing just the number 412220
. Then the real libsteam_api.so
(or similar for other platforms) will recognize your built executable as DDNet.SDL_WINDOWEVENT_SIZE_CHANGED
) properly to set the size of the viewport correctly after start.
Something similar to https://github.com/Learath2/teeworlds/commit/7f594afc9be9b402263f18f866a8b59abb08cbe189e32ba
Reduce OVH costs for this year (and hopefully don't forget to add them for 2021) - def-