Guild icon
DDraceNetwork
Development / developer
Development discussion. Logged to https://ddnet.tw/irclogs/ Connected with DDNet's IRC channel, Matrix room and GitHub repositories — IRC: #ddnet on Quakenet | Matrix: #ddnet-developer:matrix.org GitHub: https://github.com/ddnet
Between 2023-01-28 00:00:00Z and 2023-01-29 00:00:00Z
Avatar
how to convert rgba to teeworlds color format?
03:12
and lol it's already 5AM
Avatar
I see now the trick was to use colorHSLA.Pack()
Avatar
Is it possible to send different ColorBody to diffent clients?
06:04
For example I would like TeeA to see themselves with A color, TeeB with B and TeeC with C. I would also like TeeB to see themselves with A color, TeeA with B and TeeC with C. Finally, TeeC with A, TeeA with C and TeeB with B.
Avatar
im now using varnish with ddstats
10:10
so better caching
Avatar
for me it always loads very slow
Avatar
well nothing is cached yet
10:20
but ye queries can be slow
10:20
i cant do anything for that xd
Avatar
is it client side?
Avatar
varnish is like a client-side caching but on the server
10:22
so its like all clients are 1 client for the cachig
10:22
xd
10:22
but u overestimate the amount of traffic ddstats get (edited)
10:22
so almost nothing is cached rn
10:23
xd
10:23
Avatar
if i overestimate it, how can it be so slow xD
Avatar
Avatar
Jupstar ✪
if i overestimate it, how can it be so slow xD
no requests = not cached before
Avatar
ok
Avatar
i mean i have low traffic so ur probs doing the first requests
10:24
and well, queries that run against race table can be slow
10:24
specially if u order by
10:24
i would love to put more indexes but idk which
10:25
CREATE INDEX IF NOT EXISTS idx_mapinfo_map ON mapinfo(Map); CREATE INDEX IF NOT EXISTS idx_maps_map ON maps(Map); CREATE INDEX IF NOT EXISTS idx_maps_server ON maps(Server); CREATE INDEX IF NOT EXISTS idx_maps_points ON maps(Points); CREATE INDEX IF NOT EXISTS idx_maps_stars ON maps(Stars); CREATE INDEX IF NOT EXISTS idx_maps_timestamp ON maps(Timestamp); CREATE INDEX IF NOT EXISTS idx_race_map ON race(Map); CREATE INDEX IF NOT EXISTS idx_race_name ON race(Name); CREATE INDEX IF NOT EXISTS idx_race_time ON race(Time); CREATE INDEX IF NOT EXISTS idx_race_timestamp ON race(Timestamp); CREATE INDEX IF NOT EXISTS idx_teamrace_map ON teamrace(Map); CREATE INDEX IF NOT EXISTS idx_teamrace_name ON teamrace(Name); CREATE INDEX IF NOT EXISTS idx_teamrace_time ON teamrace(Time); CREATE INDEX IF NOT EXISTS idx_teamrace_timestamp ON teamrace(Timestamp); vacuum;
10:25
rn i run this
10:25
after fetching the db
Avatar
i clicked on a query from start site xd
10:25
if u click it again
10:25
does it go fast
Avatar
true
10:26
is the cache reseted every day?
10:26
well
Avatar
Avatar
Ryozuki
i would love to put more indexes but idk which
i dunno with sql3 u can put so many
Avatar
i changed the fetching of db to 1 week
10:26
instead of daily
Avatar
even for multiple fields
Avatar
otherwise its a cache nightmare xd
10:26
so cache should last 1 week now
Avatar
Avatar
Jupstar ✪
i dunno with sql3 u can put so many
yeah but they need to be useful xd
10:27
im sure we do smth wrong
10:27
cuz 19M rows is nothing
10:27
i need indexes
Avatar
yeah i guess so, bcs if i run sqlite locally its pretty fast xd
Avatar
Avatar
Mr.Gh0s7
Is it possible to send different ColorBody to diffent clients?
only server side
Avatar
Yeah I am modifying the server but I want them to appear clientside
Avatar
yeah you can send different info to different client
11:08
just specify client id
Avatar
ok ty
11:08
will look into it further
Avatar
@Ryozuki I'm really loving the custom queries ideas! But do you know if ddnet keeps how many retries/ death per map does a player have? Just to see how much have I grinded certain maps ^^ Or total time spent in X map (not the rank time)?
Avatar
thats not stored on the db
Avatar
ahh rip
Avatar
u may be able to know total time spent in x map by parsing the masterserver data tho
Avatar
ehh, where could I find that?
Avatar
u need to program it
Avatar
I mean the masterserver data
12:09
beware uncompressing 1 day is like 7gb?
12:09
it goes from 8m compressed to 7gb xd
Avatar
ahh yes.... well thanks a lot anyways
Avatar
if u know how to code tho
12:09
u can parse it in a streaming way
12:09
Command line tool to parse and analyze data from https://ddnet.tw/stats/master/ - GitHub - edg-l/teemasterparser: Command line tool to parse and analyze data from https://ddnet.tw/stats/master/
Avatar
does that mean I could parse withouth getting my computer out of memory 😄
Avatar
I may look into it, thanks
Avatar
i also got a blog about it
12:11
xd
Avatar
I am trying to re-add flag functionality in ddnet codebase for a new gamemod idea. Is it better/more compatible to look it up from 0.6.5 source or from 0.7.5?
Avatar
0.6.5 is worse. 0.7 has a lot of refactoring changes which are mostly good.
Avatar
But you'll have to keep those changes in mind while backporting. So I'd refer to the 0.7 implementation but keep the 0.6 one open on the side in case things need translating
Avatar
ok thanks :)
Avatar
ChillerDragon BOT 2023-01-28 14:00:13Z
btw ddnet++ is ddnet with flags
14:01
but the code is super messy so vanilla might be easier to look at
14:01
DDraceNetwork + city + block! Based on ddnet (www.ddnet.tw) which is based on teeworlds (www.teeworlds.com). - DDNetPP/flag.cpp at master · DDNetPP/DDNetPP
14:01
DDraceNetwork + city + block! Based on ddnet (www.ddnet.tw) which is based on teeworlds (www.teeworlds.com). - DDNetPP/DDRace.cpp at master · DDNetPP/DDNetPP
14:01
DDraceNetwork + city + block! Based on ddnet (www.ddnet.tw) which is based on teeworlds (www.teeworlds.com). - DDNetPP/DDRace_ddpp.cpp at master · DDNetPP/DDNetPP
14:03
A teeworlds instagib (grenade capture the flag) mod based on DDRaceNetwork - ddnet-insta/flag.cpp at insta · ZillyInsta/ddnet-insta
14:03
A teeworlds instagib (grenade capture the flag) mod based on DDRaceNetwork - ddnet-insta/DDRace.cpp at insta · ZillyInsta/ddnet-insta
14:03
supporting 0.6 and 0.7
Avatar

Checklist

  • [ ] Tested the change ingame
  • [ ] Provided screenshots if it is a visual change
  • [ ] Tested in combination with possibly related configuration options
  • [ ] Written a unit test (especially base/) or added coverage to integration test
  • [ ] Considered possible null pointers and out of bounds array indexing
  • [ ] Changed no physics that affect existing maps
  • [ ] Tested the change with [ASan+UBSan or valgrind's memcheck](https://github.com/ddnet/ddnet/#using-addres...
Avatar
854dc47 Replace unnecessary char buffers with pointers - Robyt3 31bcc59 Print database connection error that was previously unused - Robyt3 34ef28c Fix empty chat message being sent when using moderate - Robyt3 52aa8ac Use str_copy instead of str_format - Robyt3 e0315f5 Merge #6313 - bors[bot]
Avatar
hi sorry i have a problem with ddnet servers everytime i wanna join a kog server it dosent let me go in
Avatar
maybe ask on kog then?
17:57
3rd sentences says ddnet, 4th says kog...
17:58
wheres the kog?
Avatar
thanks
Avatar
Avatar
ChillerDragon
btw ddnet++ is ddnet with flags
And accounts and bots and levels and everything that was done before but in one place, which is kinda cool, but just too much for most mods
Avatar

Checklist

  • [ ] Tested the change ingame
  • [ ] Provided screenshots if it is a visual change
  • [ ] Tested in combination with possibly related configuration options
  • [ ] Written a unit test (especially base/) or added coverage to integration test
  • [ ] Considered possible null pointers and out of bounds array indexing
  • [ ] Changed no physics that affect existing maps
  • [ ] Tested the change with [ASan+UBSan or valgrind's memcheck](https://github.com/ddnet/ddnet/#using-ad...
Avatar
hey does datasette caches the database or does it really opens db connection? I am just wondering (edited)
Avatar
Avatar
OguzKK
hey does datasette caches the database or does it really opens db connection? I am just wondering (edited)
it sounds so funny i swear
Avatar
Avatar
GitHub
Click to see attachment 🖼️
oy vey this can be used xd
Avatar
2023-01-28 21:39:07 I chat: *** �L+ �
2023-01-28 21:39:07 I chat: Active moderator mode enabled for you. 2023-01-28 21:39:08 I chat: Vy0x2.': yes that too 2023-01-28 21:39:10 I chat: �L+ � 2023-01-28 21:39:10 I chat: Active moderator mode disabled for you. 2023-01-28 21:39:12 I chat: Lagar: :P 2023-01-28 21:39:23 I chat: P��ޫU
Exported 107 message(s)