Guild icon
DDraceNetwork
DDraceNetwork / questions
For newcomers to ask questions and get help. Also check https://wiki.ddnet.org/wiki/FAQ
Between 2023-08-19 00:00:00Z and 2023-08-20 00:00:00Z
Avatar
Avatar
Bomf
🇪🇸 🇪🇸 🇪🇸 🇪🇸 🇪🇸
Vappy 2023-08-19 06:39:31Z
Lol
Avatar
Avatar
cyberFighter
by the way is it possible to save replays without ending the replay recorder
MilkeeyCat 2023-08-19 07:49:23Z
save_replay command in f1?
Avatar
Avatar
xKox
is there a way to see my overall hours on ddnet not only past 365 days?
deen 2023-08-19 08:22:25Z
The json goes back all the way since we started tracking this in May 2021: https://ddnet.org/players/?json2=xKox+%5BPL%5D
Avatar
Avatar
Bomf
https://www.youtube.com/watch?v=LmO9xmLnPXc
PopCorn181 2023-08-19 19:34:23Z
It's done on the forum
19:34
Yearly best maps for each category, plus best mapper
19:35
Video would be cool though
Avatar
Bomf 2023-08-19 19:42:13Z
a gg
Avatar
Anxton 2023-08-19 20:17:01Z
uhh where do rendered demos go please (edited)
20:19
ok found: AppData\Roaming\Teeworlds\videos
20:20
is it said anywhere in-game ?
Avatar
Jupstar ✪ 2023-08-19 20:21:43Z
not directly, there is a config directory button in settings -> general the config dir is basically the dir where everything is saved/downloaded to
Avatar
Anxton 2023-08-19 20:22:51Z
i see, thanks!
Avatar
Destin 2023-08-19 21:35:09Z
is there any statistic on whats the longest standing rank1 to this day? which is still rank1 i mean
Avatar
Avatar
Destin
is there any statistic on whats the longest standing rank1 to this day? which is still rank1 i mean
ScReeNy 2023-08-19 21:47:09Z
this is refreshed weekly https://db.ddstats.org/ddnet-7636929/Oldest+Top+Ranks+Still+Standing (edited)
Avatar
Destin 2023-08-19 21:49:15Z
oh cool thx
Avatar
Avatar
ScReeNy
this is refreshed weekly https://db.ddstats.org/ddnet-7636929/Oldest+Top+Ranks+Still+Standing (edited)
Ryozuki 2023-08-19 22:21:18Z
every 2 days now
👍 1
22:22
lately i addehd this https://db.ddstats.org/ddnet-7636929/Maps+with+most+finishes+in+last+7+days
Avatar
Avatar
Ryozuki
lately i addehd this https://db.ddstats.org/ddnet-7636929/Maps+with+most+finishes+in+last+7+days
<BµmM> 2023-08-19 23:51:05Z
your query is wrong
Avatar
Avatar
<BµmM>
your query is wrong
<BµmM> 2023-08-19 23:51:46Z
idk what it shows but not the maps with the most finishes in the last 7 days
23:51
https://db.ddstats.org/ddnet-7636929?sql=SELECT+race.Map%2C+maps.Server%2C+COUNT%28*%29+as+finishes+FROM+race+JOIN+maps+ON+race.Map+%3D+maps.Map+WHERE+race.Timestamp+>+DATETIME%28%27now%27%2C+%27-7+day%27%29+GROUP+BY+race.Map%2C+maps.Server+ORDER+BY+finishes+DESC+LIMIT+20%3B%0D%0A
23:52
here is a fixed version
Avatar
Ryozuki 2023-08-19 23:53:34Z
u know
23:53
ur select makes no sense
23:53
but ye i guess i should use having
23:53
this is the good one https://db.ddstats.org/ddnet-7636929?sql=SELECT+race.Map%2C+maps.Server%2C+COUNT%28*%29+as+finishes+FROM+race+JOIN+maps+ON+race.Map+%3D+maps.Map+GROUP+BY+race.Map%2C+maps.Server+having+race.Timestamp+%3E+DATETIME%28%27now%27%2C+%27-7+day%27%29+ORDER+BY+finishes+DESC+LIMIT+20%3B%0D%0A
23:54
actually im not sure about having
Avatar
<BµmM> 2023-08-19 23:56:02Z
yours its wrong xd
Avatar
Ryozuki 2023-08-19 23:56:12Z
wait ur link changed
23:56
maybe i shouldntr check this drunk xd
23:57
lol
Avatar
<BµmM> 2023-08-19 23:57:46Z
your link shows the total amount of finishes on these maps
Avatar
Ryozuki 2023-08-19 23:57:48Z
why in my query did i add that select
Avatar
<BµmM> 2023-08-19 23:58:29Z
i just checked ingame
23:58
mirror has 13021 finishes now
23:58
yesterday 3 less
Avatar
Ryozuki 2023-08-19 23:59:02Z
i see
23:59
ill change tomorrow
Avatar
<BµmM> 2023-08-19 23:59:12Z
ye
23:59
nice website
Avatar
Ryozuki 2023-08-19 23:59:21Z
thanks xD
23:59
feel free to suggest more query ideas
Avatar
<BµmM> 2023-08-19 23:59:38Z
ye
23:59
when i got something ill let you know
Exported 43 message(s)