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 2020-04-29 00:00:00Z and 2020-04-30 00:00:00Z
Avatar
Trafalgar Law 2020-04-29 08:25:22Z
Hey, could someone tell me how I can split in the sql database(record_points) that I get only the top 50-100 players?
Avatar
ORDER BY points DESCENDING LIMIT 100
Avatar
Trafalgar Law 2020-04-29 08:47:15Z
But thats shows 1-100?
08:47
I want to skip the first 49
Avatar
OFFSET 50
Avatar
LIMIT 50 OFFSET 50
Avatar
I love how mysql queries sound like you are shouting
Avatar
maybe I am shouting 😛 it's not case sensitive
Avatar
@heinrich5991 do you happen to know whether interval BSTs are optimal for collision lookups?
Avatar
BST?
09:26
no, I don't
09:27
Bangladesh Standard Time
Avatar
binary search tree 😛
Avatar
sounds pretty good
09:27
how do you do 2d bsts though?
Avatar
collision lookups was ambiguous there
09:28
this is not for 2d collision
09:28
I'm upgrading a ghidra script so the largest match takes precedence
09:29
I need to keep track of the matches which are intervals and need to know whether they overlap(collide)
Avatar
largest match?
09:33
do you do binary diffing?
09:34
sorry, in a lecture right now, brain capacity severely reduce
09:34
d
Avatar
Trafalgar Law 2020-04-29 09:35:49Z
sql full shouting
Avatar
Do you know findcrypt? the guy who ported it to ghidra really half assed it, it looks for crypto constants in the code, but sometimes there are constants in other constants, in that case I want the largest match to be the one used
Avatar
Trafalgar Law 2020-04-29 09:35:52Z
no joke
09:37
btw. thanks @heinrich5991 :)
Avatar
e.g. blowfish_p_init contains a constant from HAVAL
Avatar
@Learath2 binary search trees definitely works well
09:38
not sure why you'd want optimal here
09:38
*definitely work well
Avatar
hm, a linear lookup wouldn't hurt too much, I don't want the script to choke if someone pads their executable with dozens of copies of blowfish_p_init e.g. 😄
Avatar
[quakenet] ChillerDragon BOT 2020-04-29 09:43:38Z
KoG kicks for a lot of random reasons. I get a 10 min ban for chaning my config on kog or clicking a lill faster.
09:43
oh woops forgot to scroll responded to a super old context :D
Avatar
binary lookup is log(n), should be fine @Learath2
Avatar
nice
10:15
Order or ORDER or Orders may refer to: Orderliness, a desire for organization Categorization, the process in which ideas and objects are recognized, differentiated, and understood Heterarchy, a system of organization wherein the elements have the potential to be ranked a numb...
Order in mathematics may refer to:
11:59
:O
11:59
golang also implements regexp in linear time
Avatar
didn't know backreferences were an np complete problem
Avatar
Trafalgar Law 2020-04-29 13:27:16Z
Is it possible to resume to text? Like if I write smth and I go out of text and I want to resume? (edited)
Avatar
chat messages? I don't think so
Avatar
Trafalgar Law 2020-04-29 13:28:21Z
yea
13:28
Maybe add it to ddnet :3
13:28
In tw 0.7 is it already
Avatar
what happens there?
13:30
can you still clear your chat line easily?
Avatar
Trafalgar Law 2020-04-29 13:30:20Z
If you press right click and you are in chat, you are out of the chat
13:30
And you can resume with the text which you wrote already
13:32
Sec
Avatar
nice
Avatar
eh, is it really worth it?
yes 1
no 1
Avatar
Trafalgar Law 2020-04-29 13:48:18Z
Well, if you write while you play and someone try to save you
13:48
you have to write everything again
13:59
u press enter
14:00
then finish
14:00
i do that between hammerhits
Avatar
hm, I guess it could be useful, I'll take a look at the patch, if it isn't too large I'll do it tonight
Avatar
check out the map city_fce8eca0.map, that one is quite fun
Avatar
@Learath2 one more thing that would be cool is patching the dummy hammerfly so that the "is currently holding" flag is always 1
14:15
would make deepfly with dummy possible without any annoying binds
Avatar
what do you think about adding vulkan support to ddnet
14:51
maybe ill try it as a fun project
Avatar
cl_text_entities_size doesn't work with opengl3.0 rendering?
14:53
turns all teles black for me
Avatar
@louis it does work, but requires client restart
Avatar
eh, vulkan might be overkill for teeworlds, not like opengl is missing anything we need or isn't portable
15:07
Does anyone here know how quad positioning works? as in how the quad coordinates mapped to the screen
Avatar
@heinrich5991 what about players-cache python3
Avatar
How have you people even been mapping if you don't know where the quads go?...
Avatar
@Learath2 to the background troll
Avatar
well duh
Avatar
@jao true, still not done 😦
Avatar
just tell me if you stop working on it
Avatar
@Learath2
18:27
how hide chat im demo?
Avatar
@Deleted User cl_showchat 0 ?
Avatar
ty
Avatar
btw, any idea why changing the value of cl_text_entities_size makes any entities with text pure black until client restart?
Avatar
no its dont need
18:40
ur first bind its good
18:40
its what me need
Avatar
@Deleted User I know, that one is question to devs ^^
Exported 87 message(s)