DDraceNetwork - developer

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-27 00:00:00Z and 2023-01-28 00:00:00Z

Graphql

poggers

poggers2

(edited)

ssl handshake fails if i try to download the irc logs using wget

Could you send the full command output? Also btw I upload them to GitHub on a unregular basis maybe that works too for u (@Simon)

ssl handshake fails if i try to download the irc logs using wget

OpenSSL: error:14077410:SSL routines:SSL23_GET_SERVER_HELLO:sslv3 alert handshake failure Unable to establish SSL connection.

https://github.com/TeeworldsDB/irclogs

GitHub - TeeworldsDB/irclogs: Mirror of https://ddnet.tw/irclogs/

Mirror of https://ddnet.tw/irclogs/. Contribute to TeeworldsDB/irclogs development by creating an account on GitHub.

07:33

And what command do you run?

i tried:

07:34

wget https://ddnet.org/irclogs/

07:34

wget -r https://ddnet.org/irclogs/

07:34

wget --mirror --convert-links --adjust-extension --page-requisites --no-parent https://ddnet.org/irclogs/

07:35

failed every time

07:35

theres only 1000 files on github

07:36

1k for tw and 1k for ddnet

Time to reinstall your hacked os

1 mil viruses on my pc for sure

07:48

can someone give me a folder with all of the downloaded logs as textfiles please

07:48

justatest

07:48

np

thank you, big help

you're welcome

07:49

have a good day

fuck wget bruh, just downloaded it, stackoverflow say its to old version

Simon

ssl handshake fails if i try to download the irc logs using wget

That's weird. Does --no-check-certificate --secure-protocol=TLSv1.2 work? See https://stackoverflow.com/questions/30817876/wget-ssl-alert-handshake-failure

wget ssl alert handshake failure

I am trying to download files from an https site and keep getting the following error: OpenSSL: error:14077410:SSL routines:SSL23_GET_SERVER_HELLO:sslv3 alert handshake failure Unable to establish...

[ddnet:master] 6 new commits

2587282 Fix division by zero when joystick deadzone is at maximum - Robyt3 c2e8f67 Use bool instead of int for m_InputGrabbed - Robyt3 f25ffd9 Remove unused IInput::VideoRestartNeeded - Robyt3 35c863b Disable relative joystick when console is open or window not focused - Robyt3 25216bf Increase relative joystick movement based on input update time - Robyt3 7ca5dcd Merge #6312 - bors[bot]

08:19

[ddnet/ddnet] Issue closed: #6296 Gamecontrollers move slower when `cl_refresh_rate` is set

08:19

[ddnet/ddnet] Pull request closed: #6312 Increase relative joystick movement based on input update time, disable relative joystick when console is open or window not focused

Don’t wget from GitHub just git clone and there is more than 1k

08:23

I use this command btw not that it helps with ssl errorswget -r -np -nH --cut-dirs=1 -R index.html https://ddnet.org/irclogs/

08:25

If you want a folder you can also download the git repo I send as a zip archive

deen

That's weird. Does --no-check-certificate --secure-protocol=TLSv1.2 work? See https://stackoverflow.com/questions/30817876/wget-ssl-alert-handshake-failure

wget: --secure-protocol: Invalid value `TLSv1.2'.

chillerdragon

If you want a folder you can also download the git repo I send as a zip archive

where did u sent it?

08:36

i got wget v1.11

08:37

i downloaded it from GnuWin

08:37

they made it

08:37

why do they do this

08:37

why do they bully me

08:38

why are we still here

08:38

just to suffer

08:39

is the openssl package preinstalled on windows?

You can click on download archive here https://github.com/TeeworldsDB/irclogs

GitHub - TeeworldsDB/irclogs: Mirror of https://ddnet.tw/irclogs/

Mirror of https://ddnet.tw/irclogs/. Contribute to TeeworldsDB/irclogs development by creating an account on GitHub.

08:39

It’s 2 days old

where download button

got it

08:53

alright. now i need a script that gives me all of the files which contain the word ddos

08:53

i would know how to code that

08:53

but not how to actually

08:55

should be something like:

08:55

for i in <filename>: if "DDos" in i or if "Ddos" in i: print(i)

08:55

look at my beautiful code

08:55

im a hackerman

08:57

it better be a function which gets the filename as parameter and returns a textfile

u want all messages that contain ddos from the irc logs?

yeah, all the conversations about ddos

09:00

not just the messages

https://zillyhuhn.com/tmp/ddos.txt

09:01

u got file names and line numbers in here

Researching the ddos market

then you can look them up

ah more than i thought

if any line peeks your interest go here and type the date https://github.com/TeeworldsDB/irclogs/find/master

File Finder · TeeworldsDB/irclogs

Mirror of https://ddnet.tw/irclogs/. Contribute to TeeworldsDB/irclogs development by creating an account on GitHub.

09:03

i assume there is nothing interesting in public chats about ddos depending on what you are looking for

feed the ddos

ReiTW

feed the ddos

yeah u gotta say that

hollande

2

@ChillerDragon it doesnt work. the first line on the list of ddos messages is from 2016 8 28. but if i go to the log of that day, theres no such message

09:12

ah wait, i got it

ChillerDragon

https://zillyhuhn.com/tmp/ddos.txt

i'm surprised i'm not that much in that file lol, thought i've used more that word

09:34

did u just dump all of that rn ?

Simon

wget https://ddnet.org/irclogs/

strange this works fine for me

ReiTW

strange this works fine for me

i got wrong version

shouldn't even be an issue

09:42

(of wget)

Simon

i got wrong version

did u install ca-certificates

i got ca certificates for university vpn

I meant the package ca-certificates

i dont think so

then install it and it'll probably fix the issue

yea

09:44

wanna see something i found in the logs @ReiTW ?

if u want

ddos.txt:1778:ddnet/2022-09-05.log:59:12:29 <+bridge> [ddnet] <ReiTW> I've stopped since lmao, lot of people knows I'm an old ddoser

yes and?

yes

what's the point of that lmao

ddos.txt:1781:ddnet/2022-09-05.log:90:14:58 <+bridge> [ddnet] <ReiTWbut yeah, being tagged as an old ddoser is nothing to me, I completly acknowledge it and I've changed since (edited)

09:45

thats honourable tho

yes I know already as I've written all of that here

rei ddossa

justatest

sus

https://ddnet.org/irclogs/2014-10-07.log

09:49

what is this

09:50

are u cia or some shit

Do u want to ddos ddnet? xd

09:53

Why do all randoms asking how to do x coming to #developer look extremely sus to me

and then theres two days missing there

Deal with it

they were deleted

09:55

it was actually vali chatting there, there must be chats with vali in the deleted files

Nah

what are you actually searching lol

Vali uses diferent names

09:56

@ReiTW probs a script kiddie

na look at what he is chatting

09:56

exactly the same as he does when i tried to talk to him

Ryozuki

Why do all randoms asking how to do x coming to #developer look extremely sus to me

How to do python program which asks width and height of rectangle and returns a square

gimme the deleted files

toptri

alright, now can u please do the same thing, but instead of ddos can u search for "feetpick" please? @ChillerDragon

HUHH

tf

What

10:19

Its for school research

2

Am i can earn money with my server

https://youtube.com/shorts/zq-a-k5RspM?feature=share

David Villa - Teeworlds

If DDNet was pay2win

10:28

Do smth like this

Another change

https://ddstats.org/ddnet-0587c26?sql=select%0D%0A++date%28r.Timestamp%2C+%27start+of+month%27%29+as+Month%2C%0D%0A++SUM%28Points%29+OVER+%28ORDER+BY+date%28r.Timestamp%2C+%27start+of+month%27%29%29+as+Points%0D%0Afrom%0D%0A++race+r%0D%0ALEFT+JOIN+maps+m+ON+m.Map+%3D+r.Map%0D%0Awhere%0D%0A++r.Name+%3D+%3Ap0%0D%0Agroup+by+date%28r.Timestamp%2C+%27start+of+month%27%29%0D%0Aorder+by%0D%0A++date%28r.Timestamp%2C+%27start+of+month%27%29+ASC&p0=Ryozuki#g.mark=line&g.x_column=Month&g.x_type=temporal&g.y_column=Points&g.y_type=quantitative

11:26

change it to ur name to see ur points over time

11:27

(the link is large cuz it encodes the query in the link)

can i run custom sql in that?

default

can i run custom sql in that?

ye

epic

i think my query is wrong tho xd

11:28

it says 791 points but i have 7k

11:28

hmm

default

epic

and u can make graphs, show the output in json,csv, or fancy tables

11:29

and graphql

11:29

the only limit is that the query must complete in 10s xD

11:29

which is quite generous

11:29

the default is 1s

11:29

(i added indexes to improve perf)

Ryozuki

it says 791 points but i have 7k

could it be that you did the rest of the points in the last 6 months?

11:30

seems to only check until 2022-04-01

11:32

if not, your sql is wrong, or data is not present

default

could it be that you did the rest of the points in the last 6 months?

lol no

11:33

in the last months i did nothing xD

ah this isn't mysql

Image attachment

11:35

guess I use limit then

the syntax is sqlite

11:35

i use the sqlite export cuz importing the mysql dump takes ages

11:35

and sqlite is instant

11:35

so i just add some indexes to it

trying to figure out how the tables are structured

11:36

maybe I can fix the query then

go to the home page

11:36

and then ddnet

11:36

there it lists all the tables

11:36

https://ddstats.org/ddnet-0587c26

11:37

mapinfo, maps, race, teamrace

11:37

@default on each db

11:37

table

11:37

if you scroll to bottom

11:37

you see the create table

11:37

so u know the details

11:37

Image attachment

19 million entries in race table

11:37

woah

ye

aight

11:40

i broke it already

11:41

SELECT COUNT(*) FROM race
GROUP BY Name, Map
ORDER BY COUNT(*) DESC
LIMIT 10

11:41

guess I will never know who played a single map the most

by broke u mean the query lasted 10s and timed out?

11:45

i dont think thats breaking it, cuz its builtin xD

yea

ill reduce it to 5s tho

did it spike cpu usage

let me check

11:46

it runs on 3 threads out of 12 cores it has tho

or what did change your mind

11:46

to change it from 10 secs to 5

Image attachment

default

to change it from 10 secs to 5

my change is that there is probs no useful query that takes 10s xD

11:47

idk if the query is that bump tho

it shouldn't be

11:47

i did fire the query 5 minutes before that

i think there is no spike

11:48

@default the query is only rly executed once and cached

11:48

unless u change params

i change the whole query if i add map to the group by

11:48

which timed out

11:48

if i grouped by name only, that worked still

idk xd

Image attachment

11:49

this is last 30 mins

but that basically just told me that there is someone who finished maps 37k times

nice

Simon

https://ddnet.org/irclogs/2014-10-07.log

I actually don't remember those were redacted

thats just what the server returns non authorized people

11:50

the file probably is there, non censored

or maybe not

11:51

maybe someone posted CP

11:51

idk

default

ah this isn't mysql

Isn't TOP mssql?

the internet is wild

default

thats just what the server returns non authorized people

Eh, I doubt it, given I'm not aware of any authorization

oh lol nah

11:52

it returns 304 Not Modified

Learath2

Isn't TOP mssql?

yea which returns a syntax error

11:52

for the browser database it's limit that you have to use

You said mysql. TOP isn't mysql either was my point

ah

11:53

no clue. we get the database provided for our application they want to run. (edited)

11:53

i just use it often in management studio

11:53

i can check what database they run

11:56

Microsoft SQL Server 2016 (SP2-GDR) (KB4583460) - 13.0.5108.50 (X64) 
May 20 2022 20:28:29 
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor)

11:56

So it's mssql then? (if that's a thing) (edited)

yep

the " browser database" is sqlite

12:29

and its not run on the browser

12:29

xd

does it return only 1000 rows?

Ryozuki

and its not run on the browser

its run for the browser

12:33

or do you use it for production or something else

idk what u mean for the browser

for the web application

but the queries are executed on a read-only sqlite database

12:35

the app is this btw https://datasette.io/

Datasette is a tool for exploring and publishing data. It helps people take data of any shape, analyze and explore it, and publish it as an interactive website and accompanying API.

MilkeeyCat

does it return only 1000 rows?

ye thats the limit

sadge

if u want to know more u can OFFSET 1000

12:35

aka make ur own pagination

12:35

offset 1000 shows u the 1000-2000 records

12:35

and so on

does graphiql work? 0_o

ye

13:07

i think

thonk

13:09

can you write me the easiest request xD

idk why it doesnt work :o

13:25

Image attachment

13:25

this should work lol

13:25

idk much graphql

that's what i was getting xD

Ryozuki

idk xd

grafana is so beautiful

yea we use it for our screeps bots

14:06

fancy stuff

14:08

http://pieterbrandsen.nl/d/YaauKSo4z/stats?orgId=1&refresh=30m

oh u played screep

14:12

@default did u play hackmud

14:12

Image attachment

14:12

was such a great game

14:12

i played it from 2016-2020

14:12

its a MUD with js scripting

14:12

in risk we trust

14:12

https://store.steampowered.com/app/469920/hackmud/

14:14

u made scripts to automatically unlock "locks"

14:14

its actually p good

14:14

the high lvl locks are quite hard

14:17

thep roblem with these games tho is if someone publishes a script its done

$20

monkaS

cuz everyone has access to it

14:17

i dont recommend hackmud as is now

14:17

it was better pre 2.0

14:17

its kind of abandoned by community

Anyway im greedy fuck to spend $20 xD

xd

14:18

thats nuthing

14:18

it gave me 600 hours so

14:18

its was worth

14:18

i actually bought it 2 times

Deadge

cuz the meta-meta that time was to bot it outside

14:18

and 2 clients gave an edge

14:18

everybody botted a game about botting

14:19

but 2.0 killed it kinda

14:19

so the fun went

14:19

and everybody who played this game was hardcore hackers, in the programming sense

14:19

ppl dissected the protocol etc xd

14:19

kinda hilarious

Ryozuki

oh u played screep

i still play

I spent only 195 uah on games ;)

gotta use that lifetime sub

5 eur? xd

Yep

14:20

I bought only cup head

let me find my value

14:20

its in USD but i pay euro

Image attachment

14:21

this is since 2013 xd

At school

14:21

Image attachment

@Ryozuki for datasette is it possible to provide some nice queries like from my queries in https://ddnet.org/news/ddnet-year-2021-in-review/ as defaults? Then I'd post it in #announcements and on ddnet.org/news

7k

deen

@Ryozuki for datasette is it possible to provide some nice queries like from my queries in https://ddnet.org/news/ddnet-year-2021-in-review/ as defaults? Then I'd post it in #announcements and on ddnet.org/news

yes, i think its called canned queries, i can also show a dashboard from these queries

14:21

altho the dashboard requires some effort

Would be nice to have some way to show the queries and so people can edit them

If you want to bundle some pre-written SQL queries with your Datasette-hosted database you can do so in two ways. The first is to include SQL views in your database - Datasette will then list those views on your database index page.

14:22

yeah

Did you not fix Graphiql? :p

deen

Would be nice to have some way to show the queries and so people can edit them

can u send me some nice queries u got?

14:23

ill try to put em

14:23

https://docs.datasette.io/en/stable/sql_queries.html#canned-queries

deen

Would be nice to have some way to show the queries and so people can edit them

ppl can always edit the query

Ryozuki

everybody botted a game about botting

thats my whole life man

14:24

creating bots for games to profit off of it

14:24

either in experience or financially

eh idk about profit

14:24

but we did for fun

14:24

and cuz everybody did

yea it's fun to create bots for games

Ryozuki

can u send me some nice queries u got?

I sent a link that contains queries

oh

14:26

missed it xD

14:26

thanks

like I even enjoyed automating hvh in csgo. i did play hvh but only on servers dedicated to players hacking against each other. hacking in normal matchmaking is not cool. don't know how some get joy out of cheating against legit players. https://youtu.be/sLk28j9oxXs (edited)

Is there a 100% how to protect public servers feom ddos?

whitelist ips from friends only

@deen

Image attachment

14:34

it shows like this

14:34

ill add them all now

14:36

╒══════════════╤════════════════╤═════════════════════╤═════════╕
│ map          │ Name           │ Timestamp           │    Time │
╞══════════════╪════════════════╪═════════════════════╪═════════╡
│ Adrenaline 3 │ Cireme         │ 2015-07-30 04:05:44 │ 2289.46 │
│ Adrenaline 3 │ aaa            │ 2015-07-30 04:05:44 │ 2289.46 │
│ Xabier       │ <BµmM>         │ 2015-09-05 22:40:05 │  398.62 │
│ Xabier       │ hi_leute_gll   │ 2015-09-05 22:40:05 │  398.62 │
│ Gedan        │ EryX           │ 2016-02-02 13:11:32 │   65.92 │
│ Impossible 2 │ Shocker        │ 2016-02-04 04:07:29 │  121.9  │
│ Reality      │ Shocker        │ 2016-02-24 04:38:42 │  270.54 │
│ Reality      │ Pwner          │ 2016-02-24 04:38:47 │  270.54 │
│ Careless     │ =Pipou=        │ 2016-06-10 02:24:25 │   30.34 │
│ Teleport     │ Soapy Sandwich │ 2016-09-23 22:58:34 │   76.44 │
│ Skillz 6     │ Soapy Sandwich │ 2016-09-24 15:34:35 │   88.3  │
│ xyz_ddrace2  │ Soapy Sandwich │ 2016-09-24 16:53:59 │  148.88 │
│ Core         │ sloppydog      │ 2016-09-24 21:01:42 │   69.18 │
│ GlassBox 9   │ Soapy Sandwich │ 2016-09-24 23:20:15 │   91.98 │
│ Pale 2       │ ^b[Bro] flummi │ 2016-09-27 22:53:01 │  253.26 │
│ Pale 2       │ meter'.        │ 2016-09-27 22:53:01 │  253.26 │
│ bBzZ!!       │ Colo-Colo      │ 2016-10-01 15:14:05 │  354.36 │
│ Deria        │ Soapy Sandwich │ 2016-10-15 19:04:05 │   63.52 │
│ Vizur        │ 2_Ta6LeTki_LSD │ 2016-12-05 15:16:59 │  119.56 │
│ Cuboid       │ stompie        │ 2016-12-25 21:08:28 │   98.76 │
╘══════════════╧════════════════╧═════════════════════╧═════════╛

14:36

xD

14:36

oldest ranks

14:37

still standing

@bencie wtf

14:49

ur the most addicted to ddnet

14:50

https://ddstats.org/ddnet-69b4e14/Most+Addicted+to+DDNet

14:51

some queries take some time xD

I figured, no caching?

there is some

14:51

by cloudflare

14:52

but since im restarting a lot it doesnt

14:52

cuz im adding the queries xD

Ryozuki

by cloudflare

and cuz a plugin,

14:52

https://datasette.io/plugins/datasette-hashed-urls

14:57

@deen i added all the queries from the link

14:57

https://ddstats.org/ddnet

14:57

if u dont see them do a hard refresh

Ryozuki

ur the most addicted to ddnet

Totally legitimately justatest

justatest

╒════════════════╤═════════════════════════════════════╕
│ Name           │   Time spent in all ranks (in days) │
╞════════════════╪═════════════════════════════════════╡
│ bencie         │                           10451.6   │
│ Hav            │                            5003.24  │
│ Skystrife      │                            4494.22  │
│ [D] Nugget     │                             998.499 │
│ :b             │                             994.549 │
│ nameless tee   │                             547.594 │
│ Cipy29         │                             523.311 │
│ kiwq           │                             511.303 │
│ Naka!          │                             499.596 │
│ widepeepoHappy │                             497.454 │
│ furo           │                             497.126 │
│ bencie.        │                             497.109 │
│ bencie^^       │                             497.103 │
│ Steinchen1     │                             497.083 │
│ bencie!        │                             497.083 │
│ Steinchen99UwU │                             497     │
│ BaumWollesax   │                             428.177 │
│ kiwi           │                             399.245 │
│ brainless tee  │                             394.936 │
│ Shinoa         │                             382.387 │
╘════════════════╧═════════════════════════════════════╛

monkalaugh

1

15:02

@bencie smh

[ddnet-web:master] 1 new commit

7d4f84d DDNet Statistics with Datasette - def-

Ryozuki

╒════════════════╤═════════════════════════════════════╕
│ Name           │   Time spent in all ranks (in days) │
╞════════════════╪═════════════════════════════════════╡
│ bencie         │                           10451.6   │
│ Hav            │                            5003.24  │
│ Skystrife      │                            4494.22  │
│ [D] Nugget     │                             998.499 │
│ :b             │                             994.549 │
│ nameless tee   │                             547.594 │
│ Cipy29         │                             523.311 │
│ kiwq           │                             511.303 │
│ Naka!          │                             499.596 │
│ widepeepoHappy │                             497.454 │
│ furo           │                             497.126 │
│ bencie.        │                             497.109 │
│ bencie^^       │                             497.103 │
│ Steinchen1     │                             497.083 │
│ bencie!        │                             497.083 │
│ Steinchen99UwU │                             497     │
│ BaumWollesax   │                             428.177 │
│ kiwi           │                             399.245 │
│ brainless tee  │                             394.936 │
│ Shinoa         │                             382.387 │
╘════════════════╧═════════════════════════════════════╛

select Name, sum(Time) / 3600 / 24 as "Time spent in all ranks (in days)" from race where Map not IN ("Time Shop", "Care for your Time", "Puzzle Partners", "Flappy Bird", "Avoid", "TeeInvader", "Just Every Fly", "Just Pseudo Fly", "Penalty") group by Name order by sum(Time) desc limit 20;

yields better results imo (edited)

17:01

or just exclude all maps with Time Bonus tile

oh ye

17:02

the query used is probs before the map existed

Bad service, cant insert new ranks feelsbadman

feelsbadman

Image attachment

justatest

sql, my worst nightmare

is ddnet website ok?

@Ryozuki

Image attachment

Image attachment

17:58

deadge

Chairn

@Ryozuki

hmm works for me

doesn't for me

@Chairn that query in specific is quite complex

18:00

it takes 50s to complete xd

18:00

but with luck its cached by cloudflare

18:00

but odd

18:00

it worked again for me with a hard refresh

i cant find a link to other prewritten queries

Image attachment

18:00

u dont see this?

nah

try ctrl f5

18:01

cache

Image attachment

18:01

Image attachment

Chairn

Click to see attachment 🖼️

xd

18:01

click on ddnet

18:01

not race

man, do better ui please

its meant to support more databases

18:02

so ddnet represents the ddnet db xD

18:02

with those tables

but there are 4 dbs, so i went to the race one

18:04

https://ddstats.org/ddnet-69b4e14/Longest+Ranks Gotta remove Just Every Fly from the map list too

18:04

do same for sum of all finish time, bencie dies of old age on this map

18:05

same for Most Time Spent on Map

18:05

or just cross information with maps db

Chairn

but there are 4 dbs, so i went to the race one

there is 1 db

18:07

and 4 tables

then cross information from race table and maps table to auto remove time penalties map

you can do it!

18:08

:D

i can do it ez in python panda

u dont know sql?

i can't do it in SQL cammostripes

cammostripes

18:08

no

18:08

only the basics

18:08

i never used it anyway

which tile is the time thing

18:09

DEATH, THROUGH, JUMP, DFREEZE, EHOOK_START, HIT_END, SOLO_START, TELE_GUN, TELE_GRENADE, TELE_LASER, NPC_START, SUPER_START, JETPACK_START, WALLJUMP, NPH_START, WEAPON_SHOTGUN, WEAPON_GRENADE, POWERUP_NINJA, WEAPON_RIFLE, LASER_STOP, CRAZY_SHOTGUN, DRAGGER, DOOR, SWITCH_TIMED, SWITCH, STOP, THROUGH_ALL, TUNE, OLDLASER, TELEINEVIL, TELEIN, TELECHECK, TELEINWEAPON, TELEINHOOK, CHECKPOINT_FIRST, BONUS, BOOST, PLASMAF, PLASMAE, PLASMAU

ah, tiles are not in table anyway

i think tis BONUS

18:10

Avoid Bullseye Care for your Time

18:10

ye

18:11

ima do it

how? that information is not in db?

it is

18:11

BOOST

18:11

in mapinfo

18:12

if its 1 the map has the tile

18:12

check the mapinfo table

18:13

oh its quite ez actually

lel, mapinfo has one more row than maps

18:14

13 maps with bonus tile https://ddstats.org/ddnet-69b4e14/mapinfo?_facet=BONUS&BONUS=1#facet-BONUS

ye

18:14

select
  race.Map,
  sum(Time) /(3600 * 24 * 365) as Years,
  maps.Timestamp as "Map Release Date"
from
  race
  inner join maps on race.Map = maps.Map
  inner join mapinfo on race.Map = mapinfo.Map
  and mapinfo.BOOST = 0
group by
  maps.Map
order by
  Years desc
limit
  20;

18:14

https://ddstats.org/ddnet-69b4e14?sql=select%0D%0A++race.Map%2C%0D%0A++sum%28Time%29+%2F%283600+*+24+*+365%29+as+Years%2C%0D%0A++maps.Timestamp+as+%22Map+Release+Date%22%0D%0Afrom%0D%0A++race%0D%0A++inner+join+maps+on+race.Map+%3D+maps.Map%0D%0A++inner+join+mapinfo+on+race.Map+%3D+mapinfo.Map%0D%0A++and+mapinfo.BOOST+%3D+0%0D%0Agroup+by%0D%0A++maps.Map%0D%0Aorder+by%0D%0A++Years+desc%0D%0Alimit%0D%0A++20%3B

18:15

curious

18:15

this removes multeasymap

18:15

maybe it has the tile somewhere?

CREATE TABLE `mapinfo` (
  `Map` varchar(128) NOT NULL
,  `Width` integer DEFAULT 0
,  `Height` integer DEFAULT 0
,  `DEATH` integer DEFAULT 0
,  `THROUGH` integer DEFAULT 0
,  `JUMP` integer DEFAULT 0
,  `DFREEZE` integer DEFAULT 0
,  `EHOOK_START` integer DEFAULT 0
,  `HIT_END` integer DEFAULT 0
,  `SOLO_START` integer DEFAULT 0
,  `TELE_GUN` integer DEFAULT 0
,  `TELE_GRENADE` integer DEFAULT 0
,  `TELE_LASER` integer DEFAULT 0
,  `NPC_START` integer DEFAULT 0
,  `SUPER_START` integer DEFAULT 0
,  `JETPACK_START` integer DEFAULT 0
,  `WALLJUMP` integer DEFAULT 0
,  `NPH_START` integer DEFAULT 0
,  `WEAPON_SHOTGUN` integer DEFAULT 0
,  `WEAPON_GRENADE` integer DEFAULT 0
,  `POWERUP_NINJA` integer DEFAULT 0
,  `WEAPON_RIFLE` integer DEFAULT 0
,  `LASER_STOP` integer DEFAULT 0
,  `CRAZY_SHOTGUN` integer DEFAULT 0
,  `DRAGGER` integer DEFAULT 0
,  `DOOR` integer DEFAULT 0
,  `SWITCH_TIMED` integer DEFAULT 0
,  `SWITCH` integer DEFAULT 0
,  `STOP` integer DEFAULT 0
,  `THROUGH_ALL` integer DEFAULT 0
,  `TUNE` integer DEFAULT 0
,  `OLDLASER` integer DEFAULT 0
,  `TELEINEVIL` integer DEFAULT 0
,  `TELEIN` integer DEFAULT 0
,  `TELECHECK` integer DEFAULT 0
,  `TELEINWEAPON` integer DEFAULT 0
,  `TELEINHOOK` integer DEFAULT 0
,  `CHECKPOINT_FIRST` integer DEFAULT 0
,  `BONUS` integer DEFAULT 0
,  `BOOST` integer DEFAULT 0
,  `PLASMAF` integer DEFAULT 0
,  `PLASMAE` integer DEFAULT 0
,  `PLASMAU` integer DEFAULT 0
);

No boolean in sql?

spam xd

18:15

hmm there is but its redundant

18:15

bool in sql is usually int with 1 digit

18:15

or smth

18:15

sql is archaic

nah, multeasymap doesn't have bonus tile

oh

18:16

im stpid

18:16

i used BOOST

18:16

instead of bonus

18:16

XD

it also removes Kobra

https://ddstats.org/ddnet-69b4e14?sql=select%0D%0A++race.Map%2C%0D%0A++sum%28Time%29+%2F%283600+*+24+*+365%29+as+Years%2C%0D%0A++maps.Timestamp+as+%22Map+Release+Date%22%0D%0Afrom%0D%0A++race%0D%0A++inner+join+maps+on+race.Map+%3D+maps.Map%0D%0A++left+join+mapinfo+on+race.Map+%3D+mapinfo.Map%0D%0A++and+mapinfo.BONUS+%3D+0%0D%0Agroup+by%0D%0A++maps.Map%0D%0Aorder+by%0D%0A++Years+desc%0D%0Alimit%0D%0A++20%3B

18:16

here

18:16

fixed

ah ez mistake on friday evening

ill add it to premade queries

nah

18:17

you failed again, there's Just Every Fly in there

18:18

and flappy bird, and Time Shop

lul

@Ryozuki abort mission

ah

18:18

i used a left join

18:18

instead of inner

18:18

xd

18:18

truly friday

18:19

someone request me to do the addict maps on a per map basis

18:19

so no repeated multeasymap

18:19

too

18:19

ohh

18:19

i need to increase the nginx timeout xd

18:20

thats why long running queries give cloudflare err

well, i gotta go, raclette awaits me

Good luck

whats that?

18:20

but good luck too

Ryozuki

whats that?

https://en.wikipedia.org/wiki/Raclette

Raclette (, French: [ʁaklɛt]) is a Swiss dish, also popular in the other Alpine countries, based on heating cheese and scraping off the melted part, then typically served with boiled potatoes. Raclette cheese is historically a dish originating from the canton of Valais in Switzerland. This cheese from Valais benefits from an AOP. Raclette cheese...

ohh yum

what's the flag to compile ddnet so I can debug a segfault with gdb?

just compile in debug mode

18:28

which is the default

cmake -DCMAKE_BUILD_TYPE=Debug (@Mr.Gh0s7)

what's the flag to compile ddnet so I can debug a segfault with gdb?

18:38

And then run it withgdb ./DDNet

18:38

It’s a system configuration that determines wether a core file gets created that you can inspect with gdb. But if you run ddnet with gdb you always get into the debug mode

yeah I did so

18:40

I wrote it already in #bugs but when my lil bro joins fokkonaut's playground he gets the seg fault

https://ddstats.org/ddnet-69b4e14/Most+Addicted+to+DDNet

18:44

updated the query

18:44

if u see old results ctlr f5

18:44

chillerdragon iss back on the top on most addicted

18:45

tldr: changed 3 saved queries to use mapinfo tile data to avoid bonus time tiles

Is it normal that the web loads awfully slow? or is it just my connexion

Devinci

Is it normal that the web loads awfully slow? or is it just my connexion

its normal cuz i just purged the cache

18:49

most queries listed there are quite expensive xd

18:50

and there is 19M rows in race

Oh okok, makes sense thanks x)

ima try something

Chairn

https://en.wikipedia.org/wiki/Raclette

poggers2

Ryozuki

whats that?

you're definetly missing smth, raclette is damn amazing

@heinrich5991 you've talked about the usage of quic proto for ddnet, do you have any PoC ?

20:37

or maybe master servers, forgot

help vulkan

ichliebesyrix.

help vulkan

what are u trying

ReiTW

@heinrich5991 you've talked about the usage of quic proto for ddnet, do you have any PoC ?

I'm building the poc

Jupstar ✪

what are u trying

help rust

21:46

xdd

Ryozuki

help rust

what do you need to know

Jupstar ✪

what do you need to know

how entropy can be reversed (edited)

21:48

https://astronomy.org/moravian/C00-Last%20Question.pdf

Jupstar ✪

what are u trying

i cant use vulkan for some reason

ichliebesyrix.

i cant use vulkan for some reason

whats ur GPU

everytime i select vulkan and restart its back to opengl

21:48

oof idk

21:48

let me look

ichliebesyrix.

oof idk

start client, press f1, see purple text "gfx ..."

21:49

there it should tell u

Ryozuki

how entropy can be reversed (edited)

.unwrap()

Intel(R) HD Graphics 3000

21:50

and if u say it doesnt support

21:50

i used to use it

well that GPU doesnt support vulkan xd

im pretty sure

21:50

not 100% tho

nah no way bro

21:50

thats like ivybridge or smth

Jupstar ✪

.unwrap()

epic

wha

21:50

bruh

21:51

do u atleast know what do to against fps drops

21:51

like after time

21:51

they drop lower and lower

21:51

its stupid

i dunno, if its not a memory leak, i'd say better cooling

21:51

try linux with old hardware

21:51

u might have a better time, sometimes also not ^^

im on windows

yeah time to switch

not a useful hint

?

I wouldn't switch my OS to play some game, I'd expect most people don't

well if ms makes the game lagg

21:53

why not

21:53

i gave him multiple solutions

21:53

u just want to provocate again

21:53

pls just stop

He has a laptop btw

21:56

So did ddnets older versions support vulkan or did it just show that he used vulkan but didnt actually

Alexander

So did ddnets older versions support vulkan or did it just show that he used vulkan but didnt actually

i guess none of both

maybe it supported vulkan 1.0 but not vulkan 1.1?

wikipedia says it doesnt support vk

^?

only chance is that he has a second GPU

I mean I know the guy and he says that he used vulkan before

Mr.Gh0s7

maybe it supported vulkan 1.0 but not vulkan 1.1?

afaik no windows GPU exists that wasnt upgraded to 1.1 too

21:57

but anyway why should wikipedia lie

ah ok

Alright guess it's a mystery then

21:57

Thanks for the help

ichliebesyrix.

im on windows

u could simply try all renderers in settings -> graphics else if this is a new issue, try old client, if that also doesnt help its most likely either a software regression on your system or a hardware regression (e.g. dust in your cooling system etc.)

Mr.Gh0s7

maybe it supported vulkan 1.0 but not vulkan 1.1?

i have vulkan 1.0 not 1.1

Jupstar ✪

afaik no windows GPU exists that wasnt upgraded to 1.1 too

mine does

try older version of ddnet I use 16.5

22:02

which is vulkan 1.0

i still have 1.0 tho

ichliebesyrix.

i still have 1.0 tho

how do u think so

22:03

Image attachment

22:04

no intel hd 3000 in the database

Image attachment

ichliebesyrix.

Click to see attachment 🖼️

thats just an options bcs it doesnt check if your GPU supports it on fly

22:04

after restart it checks it and if it failes it goes back to opengl

i also used to have opengl 4.0

22:05

its gone too

22:05

what about that one

nah bro xD

bro i literally had it

even on linux u only have opengl 3.1 support

i am 100% sure on this

3.3*

i had it

Image attachment

well ok

22:05

i still had it

ichliebesyrix.

i am 100% sure on this

then u have a second GPU?

22:06

else no way

laptop doenst fit 2gpus xd

there are many laptops with dual gpu

how do i know if i have 2

anyway if you are so sure about it gfx_gl_major 4; gfx_gl_minor 5 it will start to try all opengl renderers. 3.0 might work, but other intel users had crashes with it

22:07

on windows

22:07

staying with 2.0 is the safest bet

Jupstar ✪

anyway if you are so sure about it gfx_gl_major 4; gfx_gl_minor 5 it will start to try all opengl renderers. 3.0 might work, but other intel users had crashes with it

restart after typing it

bro

22:12

i have 4.5 now

22:12

what do you mean

22:12

XDDD

ichliebesyrix.

i have 4.5 now

no way bro, then its showing it incorrectly for some reason.. maybe it shows it until u restarted

22:12

bcs then the options are unchecked

22:12

(from backend view)

lemme try

22:14

after restarting i have 1,5 instead of 4.5 or 2.0

22:14

:D

that sounds more realistic

22:15

i dunno rn if it switches to 2.0 back at all, it does the bug list thing only once i guess, just use: gfx_gl_major 2; gfx_gl_minor 0

Conclusion: upgrade ur pc

[ddnet:master] 2 new commits

ccc6cd5 Only use pthread_attr_set_qos_class_np if it's available - def- 936ff4a Merge #5913 - bors[bot]

22:42

[ddnet/ddnet] Pull request closed: #5913 Only use pthread_attr_set_qos_class_np if it's available

Alexander

Conclusion: upgrade ur pc

Cleaning Ur PC properly can do magic. Most ppl underestimate that

22:49

But it takes 1-2 h for a laptop

22:50

BCS of disassemble

Jupstar ✪

Cleaning Ur PC properly can do magic. Most ppl underestimate that

True

22:50

At work i install windows, clean and upgrade pcs if they are old

22:50

Cleaning does do wonders

Epic moment

Jupstar ✪

Epic moment

No u

22:51

are epic

All of the homo

poggers

1

!all of the homo

https://youtu.be/cGJMbEzbgQk

All of the Homo

Jupstar ✪

i dunno rn if it switches to 2.0 back at all, it does the bug list thing only once i guess, just use: gfx_gl_major 2; gfx_gl_minor 0

ty for ur help btw <3

22:59

its back at 2.0

Jupstar ✪

https://youtu.be/cGJMbEzbgQk

LMFAO

Exported 585 message(s)