DDraceNetwork - developer

It's just All current r1s ORDER BY Timestamp LIMIT 1

wip

1 thing I hate about SQL is how hard it is to group by then pick the row w.r.t aggregate

00:10

SELECT *, dense_rank() OVER (PARTITION BY Map ORDER BY TIME) as rank FROM record_race WHERE rank=1?

00:10

Something like that

Difficult 1.3 by !_Vergeboy_! and aaa on 2013-10-08, 17:55:04

Might need to be wrapped in a subquery

00:12

@heinrich5991 what query did you go with?

> SELECT r1s.map, name, timestamp, time FROM record_race AS ranks INNER JOIN (SELECT map, MIN(time) AS mintime FROM record_race GROUP BY map) AS r1s ON ranks.map = r1s.map AND ranks.time = r1s.mintime ORDER BY timestamp LIMIT 10;
+------------------+----------------+---------------------+---------+
| map              | name           | timestamp           | time    |
+------------------+----------------+---------------------+---------+
| Difficult 1.3    | !_Vergeboy_!   | 2013-10-08 17:55:04 |   738.3 |
| Difficult 1.3    | aaa            | 2013-10-08 17:55:04 |   738.3 |
| SpaceIsKey       | Shyr           | 2013-11-22 00:39:50 |  176.26 |
| The Cursed Night | (1)Ninja_Valik | 2014-04-09 20:55:25 | 2376.06 |
| The Cursed Night | Ninja_Valik    | 2014-04-09 20:55:25 | 2376.06 |
| DeathClaw        | - Jogginghose  | 2014-05-12 16:33:23 |  1623.2 |
| DeathClaw        | shoxX          | 2014-05-12 16:33:23 |  1623.2 |
| Orange 1         | artkis         | 2014-07-21 04:24:12 |  109.06 |
| The Problem      | Virus2k gay    | 2014-07-27 17:45:04 |  222.66 |
| WEEDS            | Cireme         | 2014-07-27 22:07:39 |   182.9 |
+------------------+----------------+---------------------+---------+

Yeah, it's either a self join or a window

@Eki how much better? Is there still lag?

@Learath2 no, I didn't feel lag now even when other players send message fulling with new CJK character

I still think they should simplify this somehow

@louis

neat, thanks

00:14

7 years lol

beginning of ddnet I think

00:15

first rank is on 2017-07-18

https://paste.pr0.tips/Tb lol that partition ends up being an awful idea

can you explain the EXPLAIN output?

Read it from the bottom to top

00:25

It tells you what tables will be used

00:26

Well I guess it makes more sense to read from top to bottom, I just have an easier time thinking the other way around

00:29

Anyway, type ref and type index are much cheaper then ALL which is just scanning the entire database

I don't get why yours uses an index while mine sucks dick

perhaps it can't optimize dense_rank() = 1

Yours takes 16 seconds, mine takes 5 minutes 16 seconds

00:54

I'll take a look tomorrow when I have more then 3 neurons firing

00:57

Another reason people like SQL Server is it's great query visualizer

00:57

The EXPLAIN output is hardly fun to interpret

that u cannot access demos without going into menu in the new client is a bit cancer imo, it should get an icon just like the editor

b3z binary is realively easy to find. But it's for windows afaik

def-

[ddnet/ddnet] Pull request opened: #2829 Add libsteam_api.a to gitignore

Damm those oldschool names. Good times :p

b3z binary is realively easy to find. But it's for windows afaik

@Deleted User i saw. But i got nothing running win and wont pay a win vm.

I've wanted to recreate the mod in distant future. Not because I want to play it much or want to do that, just it seems nobody else will do that. So if you will get the source and/or will host it this will be even better.

08:20

@Luca

08:21

Q: Is that possible to use domain name instead of IP address in Teeworlds/DDNet? Problem: I can have up to 3 instances of cloud server with infNext servers (DDNet-based). But mostly I run only 1 instance at a time to get all players on one server. It just makes more sense because mod is not yet so popular to up all 3. Currently I switch them once a month when one instance get's any stability/network issues. But I am losing players which use direct IP to connect or use favorites. (edited)

Favorite is always IP isnt it?

i think 0.7 supports domain name

I wanted to be sure and/or to propose adding DNS resolving to the client. RN I have another stability issue with Digital Ocean's FRA1 region that will be fixed next week only and it's time to switch instances again. My server will change IP and I will lose players who added FRA1 server to favorites. They're mostly 10 yo kids and I am not sure if they will find my new server, they will just go to some outdated infCroya server which I don't own.

08:24

Would be nice to hear that I am stupid and there is already DNS support and I am just making my life harder than I should.

dont think 0.6 supports it but it probably wouldnt be hard to add

def-

[ddnet/ddnet] Pull request opened: #2830 Version 15.0

Waiting for https://github.com/ddnet/ddnet/milestone/1

bors[bot]

[ddnet:master] 3 new commits

6782f93 support multiple modifiers for binds - plsplsplslol 4326d00 fix style and reomved repeated code - plsplsplslol 981d5d4 Merge #2675 - bors[bot]

08:45

bors[bot]

[ddnet/ddnet] Pull request closed: #2675 support multiple modifiers for binds

def-

[ddnet-web:pr-15] 1 new commit

92cc78b Version 15.0 - def-

08:53

def-

[ddnet/ddnet-web] New branch created: pr-15

08:53

def-

[ddnet/ddnet-web] Pull request opened: #98 Version 15.0

@Deleted User i guess the problem is that the master server gives the ip, not domain, so you'd have to do a reverse lookup and then store that

would be a fine workaround I guess

I'd accept a PR for that for DDNet client

1

I could make it in just 6 months I guess

09:50

but thanks

Tight deadline for 15.0

Worst case I can just submit all my own changes and release

09:59

I want to get the font-from-memory change out asap

10:00

since it can have huge impact with Windows on spinning rust hard disks

I was going to merge a couple yesterday, but I'm not sure what we want to do about the style thing

we'll stay with doing clang-formats for parts of files

10:01

but we should put the clang-formats in separate changes inside the same merge maybe

10:01

then we can have a list of all clang-format changes?

10:05

shouldn't block us from merging changes atm

https://gyazo.com/7c6c27e9da74249ec5f7be4def58ad08 still not showing

Gyazo

10:17

@deen

@Brokecdx- which team rank exactly?

Like we played all these 18 maps in team, no top ranks or something

10:18

and they only show t0 rank

oh, ok

10:25

I have attempted a fix, Let's see in 30-60 min if it worked

yes it worked showing now

QingGo

[ddnet/ddnet] Pull request opened: #2831 add windows websockets client support

In the last PR of websockets https://github.com/ddnet/ddnet/pull/2805 , It only support the websocket client in macOS and LinuxOS. And I add the Windows OS windows websockets client support in this PR. It seem that netinet/in.h isn't used by websocket code so I remove it. After removed it I can successfully compile and run DDNet client and server in Linux too. If netinet/in.h have something usage I don't know, please tell me.

bors[bot]

[ddnet/ddnet] Pull request closed: #2831 add windows websockets client support

13:13

bors[bot]

[ddnet:master] 2 new commits

d627b85 add windows websockets client support - QingGo c7b61ac Merge #2831 - bors[bot]

@deen thoughts about new icons?

13:19

so you dont have to access the menu all the time for e.g. demo watching

lgtm, but @BannZay might disagree. I think we wanted to remove all buttons at the top to force people to use the start menu

but why

13:20

its annoying to go back all time

not sure. maybe because it's a bit faster with the key binds

@BannZay why xd

anyway, i like your change @Deleted User

i'll just pr it, and if its unwanted, dont merge xd

Jupeyy

[ddnet/ddnet] Pull request opened: #2832 Add new icons for demo, home and server browser

!image

btw @deen the german translation says "Abspielen" in main menu, bcs its used for music or demo i dunno if it also affects other languages

it should say "Spielen" only xd

13:43

i mean, in this context

13:43

sure, for demos it should be Abspielen

probs need to replace Localize("Play") with Localize("Play back") or smth

I just tried out DDNet client again after long time, what happened to the opengl stuff? :( zooming out really laggs now, and the option is split into 3 config vars

u need to enable 3.3 again

13:47

the config names changed

also, the "Join Game" button in ESC is still there if paused or /specced. @deen

13:47

3.3, so 3 major and 3 minor?

yes or just enable it in graphic settings

and 0 for patch?

patch actually doesnt matter to much xd

ok

13:48

aha, thanks for the lagfree zoozing :D

but zooming with default opengl should be better than with old renderer too

13:49

just not as much

@deen on my own server the join game button does not do anything, is there a serverside thing to unpause when hitting that button or is it clientside sending /pause again?

==13035== 14 errors in context 4 of 203:
==13035== Conditional jump or move depends on uninitialised value(s)
==13035==    at 0x337F4D: void sort_bubble<plain_range_sorted<CMenus::CDemoItem> >(plain_range_sorted<CMenus::CDemoItem>) (algorithm.h:96)
==13035==    by 0x337D2D: void sort<plain_range_sorted<CMenus::CDemoItem> >(plain_range_sorted<CMenus::CDemoItem>) (algorithm.h:114)
==13035==    by 0x337A9F: sorted_array<CMenus::CDemoItem, allocator_default<CMenus::CDemoItem> >::sort_range() (sorted_array.h:33)
==13035==    by 0x333C79: CMenus::DemolistPopulate() (menus_demo.cpp:767)
==13035==    by 0x33408E: CMenus::RenderDemoList(CUIRect) (menus_demo.cpp:825)
==13035==    by 0x31EFFB: CMenus::Render() (menus.cpp:1174)
==13035==    by 0x32428B: CMenus::OnRender() (menus.cpp:2157)
==13035==    by 0x371CFC: CGameClient::OnRender() (gameclient.cpp:644)
==13035==    by 0x2742EA: CClient::Render() (client.cpp:1138)
==13035==    by 0x27CC24: CClient::Run() (client.cpp:3266)
==13035==    by 0x28269C: main (client.cpp:4305)
==13035==  Uninitialised value was created by a stack allocation
==13035==    at 0x3339D0: CMenus::DemolistFetchCallback(char const*, long, int, int, void*) (menus_demo.cpp:727)
==13035==

sometimes causes the demo page to break

13:54

(maybe, could also be smth different)

13:57

nvm we get invalid read or write in demo page

13:58

valgrind.txt

35.66 KB

13:59

reproducable by changing the lagnuage from german to english

[ddnet] <Jupstar ✪> ```

xd did this break the bridge?

@Deleted User i fixed that already in a PR

oh sry

the play/play back: https://github.com/ddnet/ddnet/pull/2816

Implement context for translations (largely taken from Teeworlds) b...

Missing: scripts/languages doesn't work yet, but the context can be added manually, see german.txt for an example.

ah, alright

@Deleted User best icons

@fokkonaut works for me in ddnet server

yes, but how does it work? serverside stuff?

14:05

because it doesnt work on my server

14:05

just says "join game" and nothing happens

Ah, probably because your server sends no ddnet playerinfo object

@deen can we adapt the 0.7 editor and menu cursor

14:06

looks better imo xd

@Deleted User go ahead

bors[bot]

[ddnet:master] 2 new commits

6a352b4 Add new icons for demo, home and server browser - Jupeyy a4edac3 Merge #2832 - bors[bot]

14:21

bors[bot]

[ddnet/ddnet] Pull request closed: #2832 Add new icons for demo, home and server browser

14:21

Jupeyy

[ddnet/ddnet] Pull request opened: #2833 Use 0.7 cursor

!image

but @BannZay might disagree. I think we wanted to remove all buttons at the top to force people to use the start menu

@deen nooo this is bad

make two modes like its done in 0.7

for beginners the menu is gold, but after a while it'd get really annoying

lol. After 10 years of tw just using f1 console

it would be epic to also skip the start menu

15:11

and go to browser directly

15:11

i think 0.7 has it

like it always was in 0.6?

we do too @Ryozuki , but would be nicer to have something like "Always show home screen" directly on home screen

cl_skip_start_menu or something exists in 0.7, yes

15:50

it also has a setting in the menus

BannZay

[ddnet/ddnet] Issue opened: #2834 Select game layer on map load in editor

Game layer is a core thing for any map for most game types. Can we have it selected after map loaded in editor ?

lgtm, but @BannZay might disagree. I think we wanted to remove all buttons at the top to force people to use the start menu

According to my personal usage I have no need to have super fast navigation between game and any other menu (i.e. settings, editor, etc) But the main problem is inconsistence, you can not even call it a Main menu. Thats why it sounds to me like half solution (edited)

its more like a home screen

I fear we might make wrong decision now just becase we use to have the old menu

16:30

and new is always inconvenient for some period of time

but how is removing the demo access better than keeping it as an icon?

16:31

or do u dislike the whole home screen at all

how often you need to switch between game and demo?

16:31

they arent even compatible

often

you cant play while watching demo

yes but i go there from server browser

yes, thats a reason for fear

currently i need to press esc then demo, then esc then server browser

16:32

sounds like a pain

you used to

nobody wants this, i garantuee it 100% xd

16:32

if we dont have a hotbar oĺd players complain

isnt ESC a common key for going back? I cant say for everyone but I have no any problem with this

yeah but its cancer to always press ESC

16:34

and then click the right thing in menu too

I see, but I feel like main menu is kinda makes no sense then

for new players it does

16:35

bcs they dont know what editor demos, etc are

16:35

or how to start a local server

a local server is new thing, but rest...

u cant imagine new ppl... they dont even get how to remove novice from their search bar

fells like we made second home page lmao

16:36

as our current start menu has everything we need

i'd say home screen is for nice overview

16:36

and the hotbar for ez access

def-

[ddnet-scripts:master] 1 new commit

708bf66 More ddnet-setup.sh fixes - def-

I see your point, but according to my gamer experience I would stil prefer it to be "main menu" but not "home page". I not persist, probably we might make some kind of poll or just keep it for convenience of old player, I dont care much (edited)

i'd just add "Always show home screen" as option on the home screen and call it an actually home screen, where u get alls discord links, news etc. (edited)

16:39

while the other thing is really just gameplay related things (edited)

as for me I will just disable it (in case it is just home page), just saying. (edited)

yes, me too

16:40

and new players after 2-3 weeks too

16:40

but for the first time its nice

yea, just sad about effort put inside of this feature

0.7 did the effort

16:41

and deen

def-

[ddnet-web:master] 1 new commit

cfffd41 New frontpage video - def-

Give it a chance maybe it'll grow on you

i think the simple fact that new players have a better start into the game is worth it enough

bors[bot]

[ddnet:master] 2 new commits

dc3580d 0.7 cursor - Jupeyy a2a2abb Merge #2833 - bors[bot]

16:47

bors[bot]

[ddnet/ddnet] Pull request closed: #2833 Use 0.7 cursor

16:50

def-

[ddnet/ddnet] Pull request opened: #2835 Make spacing in top menu buttons consistent, fit for 5:4

!screenshot-20200915@184840

@TsFreddie did you find out why GetChar is called twice?

bors[bot]

[ddnet:master] 4 new commits

7af5170 Implement context for translations (largely taken from Teeworlds) - def- 3daa798 Implement script/languages support for contexts - def- 887fa50 Update language files - def- 3b0bb7d Merge #2816 - bors[bot]

17:08

bors[bot]

[ddnet/ddnet] Pull request closed: #2816 Implement context for translations (largely taken from Teeworlds)

bors[bot]

[ddnet:master] 4 new commits

f9ec8c5 map_convert_07: Check for width/height 0 - def- ef1e6d4 Add libsteam_api.a to gitignore - def- 7a82779 Make spacing in top menu buttons consistent, fit for 5:4 - def- c1d54da Merge #2826 #2829 #2835 - bors[bot]

17:16

bors[bot]

[ddnet/ddnet] Pull request closed: #2835 Make spacing in top menu buttons consistent, fit for 5:4

17:16

bors[bot]

[ddnet/ddnet] Pull request closed: #2829 Add libsteam_api.a to gitignore

17:16

bors[bot]

[ddnet/ddnet] Pull request closed: #2826 map_convert_07: Check for width/height 0

@TsFreddie hm, I can confirm that it's called twice with the same character, same size, same font when I write something in chat:

104 10 0x564ca161fb60
105 10 0x564ca161fb60
104 10 0x564ca161fb60
105 10 0x564ca161fb60

17:18

Ah, from different places, we call GetChar() in two places in text.cpp

getchar isnt the problem

17:18

renderglyph is

@Deleted User what is?

17:18

oh

then it renders the glyph to the texture

bors[bot]

[ddnet/ddnet] Issue closed: #2810 significant lag when other player send chat inculding many CJK character

17:23

bors[bot]

[ddnet:master] 3 new commits

0f8d682 Remove saving to other servers - def- 77d47a8 Load fonts from memory (fixes #2810) - def- edb4462 Merge #2814 #2818 - bors[bot]

17:23

bors[bot]

[ddnet/ddnet] Pull request closed: #2818 Load fonts from memory (fixes #2810)

def-

[ddnet/ddnet] Pull request opened: #2836 Only make Esc key leave editor when no popup is open

looks all good to me with renderglyph. it gets called twice, but that's because the the text you enter is a bit bigger. with a bind only gets called once for me

Jupeyy

[ddnet/ddnet] Pull request opened: #2837 Don't allow zero/empty images(bcs malloc(0) and other things)

Would be nicer, if the map loader would check the map for such things, but since the backend works with the image data and assumes its valid, this prevents crashes.

20:30

bors[bot]

[ddnet:master] 2 new commits

75f604b Update simplified_chinese.txt - QingGo 6a06d1b Merge #2809 - bors[bot]

20:30

bors[bot]

[ddnet/ddnet] Pull request closed: #2809 Update simplified_chinese.txt

can we pls get csgo prediction to replace anti ping? :""""(

20:34

i always find myself teleporting into the freeze when im not near it on my screen

no

20:35

thats a cheat

bors[bot]

[ddnet:master] 2 new commits

2a713eb Don't allow malloc on empty images - Jupeyy 0bb2400 Merge #2837 - bors[bot]

20:38

bors[bot]

[ddnet/ddnet] Pull request closed: #2837 Don't allow zero/empty images(bcs malloc(0) and other things)

@Deleted User lmao like how many times do you open the demo folder thing. Not a big deal if it is removed and placed on the start page

quite often

21:01

every time i have a random moment

21:01

add demomarks

^ same

There is also this feature where u can cut the last 10-20-30-60 seconds of your gameplay without even leaving the server

21:06

Since that i only need to check the small demofiles

yeah but i'd cut it anyway

21:08

anyway, a direct demo access is QOL for me, not required but nice to have

(edited)

K i can understand

21:36

ddnet based server spitting these on 0.7 clients

21:36

don't know if it's a ddnet problem or 0.7 problem

only in debug mode

21:45

No way to stop it sadly, we removed that debug message, the proper fix would probably be to only throw out a warning once per unknown type

oh forgot i have debug mode on

21:50

probably need to patch it on vanilla i guess

@n000b wait what? how?

@Soreu replay

@Deleted User what texture size is safe to use in general, if i have to use a fixed size texture for text.

22:56

I mean GPU supports wise.

2048 is safe

i don't care about keeping all glyphs

only the windows software renderer cant handle it

so is 1024 pretty much good on everything?

1024 is safest

ok thanks

but 2048 is also safe

22:57

https://feedback.wildfiregames.com/report/opengl/feature/GL_MAX_TEXTURE_SIZE

GetIntegerv(GL_MAX_TEXTURE_SIZE,) ?

22:57

xd

only 200 GPU dont have it and if u click it

I'm currently using 1024, and it is pretty enough for my use case. dropping 1/4 of the 1024 texture isn't causing too much trouble for now.

u'll see some very early mesa and windows software renderer

22:58

and that report is 5years old too

maybe i can add a config

@Deleted User how does the font renderer work? do u save all glyphs in a atlas? do u pack them the easy way or do u use some kind of algorithm

https://feedback.wildfiregames.com/report/opengl/feature/GL_MAX_TEXTURE_SIZE

yeah, looks like 1024 is the safest, although idk if software render can really play teeworlds well anyway.

they are packed with buttom left skyline algorithm

23:00

its not directly an atlas

we packed the glyphs on the spot

23:01

if one shows up it get packed

https://github.com/edg-l/SimpleGame/blob/master/src/engine/graphics/renderer.c#L105 this is how i did it, i dont know shit tho xd

edg-l/SimpleGame

A game made in pure C using SDL2. Contribute to edg-l/SimpleGame development by creating an account on GitHub.

i'd say 2048 is safe too

i would use 2048

okay

we use 1024

23:02

but his approach is different

but you guys can resize the texture i suppose

yeah

23:03

it probs goes to 2048 on a chinese server quickly

what r u working on?

with 512 is page dropping city even when you just looking at the settings. doggo_lol

hes working on the text in vanilla

oh is he asking me

23:08

sorry didn't notice

23:08

yes. i'm working on text in vanilla

How ddnet servers fixed the following problem: when you are frozen on zcatch for example and hold hook it's rapidly flickering in and out with sounds. Same with movement keys, your tee gets in some direction a bit and then returns.

you can send tunning setting to clients to shorten their hook, so the client prediction can't try to kick in

But fng mode still shows very short hook flickering (better than zcatch) but DDrace does not at all!

i'm guessing fng is not completely 0'd it's hook length?