at my map i always had around 45 seconds. ans sometimes some miliseconds more or less. i think the time counter in teeworlds goes a couple of digits more down but we dont see this.stompie wrote:how do people get different times on this map i got 12 secs bunch of times then got 1 min O.o
and how doesthe top5 work for a map like this why does it show the people on /top5 that it does any specific order?
Code: Select all
SET @prev := NULL;
SET @rank := 1;
SET @pos := 0;
SELECT Rank, Name, Time FROM (SELECT Name, (@pos := @pos+1) pos, (@rank := IF(@prev = Time,@rank, @pos)) rank, (@prev := Time) Time FROM (SELECT Name, min(Time) as Time FROM record_race WHERE Map = '%s' GROUP BY Name ORDER BY `Time` ASC) as a) as b WHERE Name = '%s';so the latest time that was put in get the top spot?deen wrote: So there is no ordering by Name defined, only by Time, which means the order of names depends on the database implementation when multiple players have the same time.
you can make a little move the the left on start and u will get 12 secsstompie wrote:how do people get different times on this map i got 12 secs bunch of times then got 1 min O.o
and how doesthe top5 work for a map like this why does it show the people on /top5 that it does any specific order?