00:08 < bridge> i set it to that, its relative to the count 00:08 < bridge> by default it isnt xD 00:09 < bridge> so the area is proportional to countΒ²? 00:09 < bridge> i guess 00:09 < bridge> that's a bit misleading 00:09 < bridge> hmm idk 00:10 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068306909339332698/image.png 00:10 < bridge> https://ddstats.org/ddnet-0587c26?sql=select%0D%0A++Map%2C%0D%0A++count%28*%29+as+Count%0D%0Afrom%0D%0A++race%0D%0Agroup+by%0D%0A++Map%0D%0Aorder+by+Count+DESC%0D%0Alimit%0D%0A++100#dataExplorer.metadata=%7B%22dx%22%3A%7B%22view%22%3A%22bar%22%2C%22lineType%22%3A%22line%22%2C%22areaType%22%3A%22hexbin%22%2C%22selectedDimensions%22%3A%5B%22Map%22%5D%2C%22selectedMetrics%22%3A%5B%5D%2C%22pieceType%22%3A%22bar%22%2C%22summaryType%22%3A%22violin%22%2C% 00:10 < bridge> xd 00:10 < bridge> (you can click the view 100 rows in explorer) 00:11 < bridge> ah there is also a graphql api 00:11 < bridge> https://ddstats.org/graphql 00:12 < bridge> dont ask me how it works idk graphql 00:12 < bridge> fancy 00:12 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068307520189370409/image.png 06:59 < bridge> Graphql :poggers: 07:01 < bridge> Graphql :poggers: :poggers2: 08:27 < bridge> ssl handshake fails if i try to download the irc logs using wget 08:31 < bridge> Could you send the full command output? Also btw I upload them to GitHub on a unregular basis maybe that works too for u 08:31 < bridge> (@Simon') 08:32 < bridge> OpenSSL: error:14077410:SSL routines:SSL23_GET_SERVER_HELLO:sslv3 alert handshake failure 08:32 < bridge> Unable to establish SSL connection. 08:32 < bridge> https://github.com/TeeworldsDB/irclogs 08:33 < bridge> And what command do you run? 08:33 < bridge> i tried: 08:34 < bridge> wget https://ddnet.org/irclogs/ 08:34 < bridge> wget -r https://ddnet.org/irclogs/ 08:34 < bridge> wget --mirror --convert-links --adjust-extension --page-requisites --no-parent https://ddnet.org/irclogs/ 08:35 < bridge> failed every time 08:35 < bridge> theres only 1000 files on github 08:36 < bridge> 1k for tw and 1k for ddnet 08:40 < bridge> Time to reinstall your hacked os 08:41 < bridge> 1 mil viruses on my pc for sure 08:48 < bridge> can someone give me a folder with all of the downloaded logs as textfiles please 08:48 < bridge> :justatest: 08:48 < bridge> πŸ“ 08:48 < bridge> np 08:48 < bridge> thank you, big help 08:48 < bridge> you're welcome 08:49 < bridge> have a good day 08:49 < bridge> fuck wget bruh, just downloaded it, stackoverflow say its to old version 09:19 < bridge> That's weird. Does `--no-check-certificate --secure-protocol=TLSv1.2` work? See https://stackoverflow.com/questions/30817876/wget-ssl-alert-handshake-failure 09:22 < bridge> Don’t wget from GitHub just git clone and there is more than 1k 09:23 < bridge> I use this command btw not that it helps with ssl errors``` 09:23 < bridge> wget -r -np -nH --cut-dirs=1 -R index.html https://ddnet.org/irclogs/ 09:23 < bridge> ``` 09:25 < bridge> If you want a folder you can also download the git repo I send as a zip archive 09:32 < bridge> wget: --secure-protocol: Invalid value `TLSv1.2'. 09:33 < bridge> where did u sent it? 09:36 < bridge> i got wget v1.11 09:37 < bridge> i downloaded it from GnuWin 09:37 < bridge> they made it 09:37 < bridge> why do they do this 09:37 < bridge> why do they bully me 09:38 < bridge> why are we still here 09:38 < bridge> just to suffer 09:39 < bridge> is the openssl package preinstalled on windows? 09:39 < bridge> You can click on download archive here https://github.com/TeeworldsDB/irclogs 09:39 < bridge> It’s 2 days old 09:40 < bridge> where download button 09:48 < bridge> got it 09:53 < bridge> alright. now i need a script that gives me all of the files which contain the word ddos 09:53 < bridge> i would know how to code that 09:53 < bridge> but not how to actually 09:55 < bridge> should be something like: 09:55 < bridge> for i in : 09:55 < bridge> if "DDos" in i or if "Ddos" in i: 09:55 < bridge> print(i) 09:55 < bridge> look at my beautiful code 09:55 < bridge> im a hackerman 09:57 < bridge> it better be a function which gets the filename as parameter and returns a textfile 10:00 <+ChillerDragon> u want all messages that contain ddos from the irc logs? 10:00 < bridge> yeah, all the conversations about ddos 10:00 < bridge> not just the messages 10:01 <+ChillerDragon> https://zillyhuhn.com/tmp/ddos.txt 10:01 <+ChillerDragon> u got file names and line numbers in here 10:01 < bridge> Researching the ddos market 10:01 <+ChillerDragon> then you can look them up 10:01 < bridge> ah more than i thought 10:02 <+ChillerDragon> if any line peeks your interest go here and type the date https://github.com/TeeworldsDB/irclogs/find/master 10:03 <+ChillerDragon> i assume there is nothing interesting in public chats about ddos depending on what you are looking for 10:03 < bridge> feed the ddos 10:03 < bridge> yeah u gotta say that 10:11 < bridge> @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 10:12 < bridge> ah wait, i got it 10:31 < bridge> i'm surprised i'm not that much in that file lol, thought i've used more that word 10:34 < bridge> did u just dump all of that rn ? 10:39 < bridge> strange this works fine for me 10:40 < bridge> i got wrong version 10:42 < bridge> shouldn't even be an issue 10:42 < bridge> (of wget) 10:43 < bridge> did u install ca-certificates 10:44 < bridge> i got ca certificates for university vpn 10:44 < bridge> I meant the package ca-certificates 10:44 < bridge> i dont think so 10:44 < bridge> then install it and it'll probably fix the issue 10:44 < bridge> yea 10:44 < bridge> wanna see something i found in the logs @ReiTW ? 10:44 < bridge> if u want 10:45 < bridge> ddos.txt:1778:ddnet/2022-09-05.log:59:12:29 <+bridge> [ddnet] I've stopped since lmao, lot of people knows I'm an old ddoser 10:45 < bridge> yes and? 10:45 < bridge> yes 10:45 < bridge> what's the point of that lmao 10:45 < bridge> ddos.txt:1781:ddnet/2022-09-05.log:90:14:58 <+bridge> [ddnet] @Ravie Senpai but yeah, being tagged as an old ddoser is nothing to me, I completly acknowledge it and I've changed since 10:45 < bridge> thats honourable tho 10:46 < bridge> ddos.txt:1781:ddnet/2022-09-05.log:90:14:58 <+bridge> [ddnet] yes I know already as I've written all of that here 10:46 <+ChillerDragon> rei ddossa 10:46 < bridge> :justatest: 10:46 <+ChillerDragon> sus 10:49 < bridge> https://ddnet.org/irclogs/2014-10-07.log 10:49 < bridge> what is this 10:50 < bridge> are u cia or some shit 10:51 < bridge> Do u want to ddos ddnet? xd 10:53 < bridge> Why do all randoms asking how to do x coming to #developer look extremely sus to me 10:54 < bridge> and then theres two days missing there 10:54 < bridge> Deal with it 10:55 < bridge> they were deleted 10:55 < bridge> it was actually vali chatting there, there must be chats with vali in the deleted files 10:55 < bridge> Nah 10:55 < bridge> what are you actually searching lol 10:55 < bridge> Vali uses diferent names 10:56 < bridge> @ReiTW probs a script kiddie 10:56 < bridge> na look at what he is chatting 10:56 < bridge> exactly the same as he does when i tried to talk to him 10:57 < bridge> How to do python program which asks width and height of rectangle and returns a square 10:58 < bridge> gimme the deleted files 11:02 < bridge> :toptri: 11:14 < bridge> alright, now can u please do the same thing, but instead of ddos can u search for "feetpick" please? @ChillerDragon 11:15 < bridge> HUHH 11:19 < bridge> tf 11:19 < bridge> What 11:19 < bridge> Its for school research 11:26 < bridge> Am i can earn money with my server 11:28 < bridge> https://youtube.com/shorts/zq-a-k5RspM?feature=share 11:28 < bridge> Do smth like this 11:29 < bridge> Another change 12:26 < bridge> 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 12:26 < bridge> change it to ur name to see ur points over time 12:27 < bridge> (the link is large cuz it encodes the query in the link) 12:28 < bridge> can i run custom sql in that? 12:28 < bridge> ye 12:28 < bridge> epic 12:28 < bridge> i think my query is wrong tho xd 12:28 < bridge> it says 791 points but i have 7k 12:28 < bridge> hmm 12:28 < bridge> and u can make graphs, show the output in json,csv, or fancy tables 12:29 < bridge> and graphql 12:29 < bridge> the only limit is that the query must complete in 10s xD 12:29 < bridge> which is quite generous 12:29 < bridge> the default is 1s 12:29 < bridge> (i added indexes to improve perf) 12:30 < bridge> could it be that you did the rest of the points in the last 6 months? 12:30 < bridge> seems to only check until 2022-04-01 12:32 < bridge> if not, your sql is wrong, or data is not present 12:33 < bridge> lol no 12:33 < bridge> in the last months i did nothing xD 12:35 < bridge> ah this isn't mysql 12:35 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068494367557439509/image.png 12:35 < bridge> guess I use limit then 12:35 < bridge> the syntax is sqlite 12:35 < bridge> i use the sqlite export cuz importing the mysql dump takes ages 12:35 < bridge> and sqlite is instant 12:35 < bridge> so i just add some indexes to it 12:36 < bridge> trying to figure out how the tables are structured 12:36 < bridge> maybe I can fix the query then 12:36 < bridge> go to the home page 12:36 < bridge> and then ddnet 12:36 < bridge> there it lists all the tables 12:36 < bridge> https://ddstats.org/ddnet-0587c26 12:37 < bridge> mapinfo, maps, race, teamrace 12:37 < bridge> @DefaultO on each db 12:37 < bridge> table 12:37 < bridge> if you scroll to bottom 12:37 < bridge> you see the create table 12:37 < bridge> so u know the details 12:37 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068494978747215882/image.png 12:37 < bridge> 19 million entries in race table 12:37 < bridge> woah 12:37 < bridge> ye 12:40 < bridge> aight 12:40 < bridge> i broke it already 12:41 < bridge> ```sql 12:41 < bridge> SELECT COUNT(*) FROM race 12:41 < bridge> GROUP BY Name, Map 12:41 < bridge> ORDER BY COUNT(*) DESC 12:41 < bridge> LIMIT 10 12:41 < bridge> ``` 12:41 < bridge> guess I will never know who played a single map the most 12:45 < bridge> by broke u mean the query lasted 10s and timed out? 12:45 < bridge> i dont think thats breaking it, cuz its builtin xD 12:45 < bridge> yea 12:45 < bridge> ill reduce it to 5s tho 12:45 < bridge> did it spike cpu usage 12:46 < bridge> let me check 12:46 < bridge> it runs on 3 threads out of 12 cores it has tho 12:46 < bridge> or what did change your mind 12:46 < bridge> to change it from 10 secs to 5 12:46 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068497320045457459/image.png 12:47 < bridge> my change is that there is probs no useful query that takes 10s xD 12:47 < bridge> idk if the query is that bump tho 12:47 < bridge> it shouldn't be 12:47 < bridge> i did fire the query 5 minutes before that 12:47 < bridge> i think there is no spike 12:48 < bridge> @DefaultO the query is only rly executed once and cached 12:48 < bridge> unless u change params 12:48 < bridge> i change the whole query if i add map to the group by 12:48 < bridge> which timed out 12:48 < bridge> if i grouped by name only, that worked still 12:49 < bridge> idk xd 12:49 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068497879116820541/image.png 12:49 < bridge> this is last 30 mins 12:49 < bridge> but that basically just told me that there is someone who finished maps 37k times 12:49 < bridge> nice 12:49 < bridge> I actually don't remember those were redacted 12:50 < bridge> thats just what the server returns non authorized people 12:50 < bridge> the file probably is there, non censored 12:50 < bridge> or maybe not 12:51 < bridge> maybe someone posted CP 12:51 < bridge> idk 12:51 < bridge> Isn't TOP mssql? 12:51 < bridge> the internet is wild 12:51 < bridge> Eh, I doubt it, given I'm not aware of any authorization πŸ˜„ 12:51 < bridge> oh lol nah 12:52 < bridge> it returns 304 Not Modified 12:52 < bridge> yea which returns a syntax error 12:52 < bridge> for the browser database it's limit that you have to use 12:53 < bridge> You said mysql. TOP isn't mysql either was my point πŸ™ƒ 12:53 < bridge> ah 12:53 < bridge> no clue 12:53 < bridge> i just use it often in management studio 12:53 < bridge> i can check what database they run 12:56 < bridge> ```Microsoft SQL Server 2016 (SP2-GDR) (KB4583460) - 13.0.5108.50 (X64) 12:56 < bridge> May 20 2022 20:28:29 12:56 < bridge> Copyright (c) Microsoft Corporation 12:56 < bridge> Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor)``` 12:56 < bridge> So it's mssql then? 12:56 < bridge> So it's mssql then? (if that's a thing) 12:56 < bridge> yep 12:58 < bridge> no clue. we get the database provided for our application they want to run. 13:29 < bridge> the " browser database" is sqlite 13:29 < bridge> and its not run on the browser 13:29 < bridge> xd 13:31 < bridge> does it return only 1000 rows? 13:33 < bridge> its run for the browser 13:33 < bridge> or do you use it for production or something else 13:34 < bridge> idk what u mean for the browser 13:34 < bridge> for the web application 13:34 < bridge> but the queries are executed on a read-only sqlite database 13:35 < bridge> the app is this btw https://datasette.io/ 13:35 < bridge> ye thats the limit 13:35 < bridge> sadge 13:35 < bridge> if u want to know more u can OFFSET 1000 13:35 < bridge> aka make ur own pagination 13:35 < bridge> offset 1000 shows u the 1000-2000 records 13:35 < bridge> and so on 14:01 < bridge> does graphiql work? 0_o 14:07 < bridge> ye 14:07 < bridge> i think 14:09 < bridge> :thonk: 14:09 < bridge> can you write me the easiest request xD 14:25 < bridge> idk why it doesnt work :o 14:25 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068522133631795250/image.png 14:25 < bridge> this should work lol 14:25 < bridge> that 14:25 < bridge> idk much graphql 14:25 < bridge> that's what i was getting xD 14:28 < bridge> grafana is so beautiful 15:06 < bridge> yea we use it for our screeps bots 15:06 < bridge> fancy stuff 15:08 < bridge> http://pieterbrandsen.nl/d/YaauKSo4z/stats?orgId=1&refresh=30m 15:11 < bridge> oh u played screep 15:12 < bridge> @DefaultO did u play hackmud 15:12 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068533896783867934/image.png 15:12 < bridge> was such a great game 15:12 < bridge> i played it from 2016-2020 15:12 < bridge> its a MUD with js scripting 15:12 < bridge> in risk we trust 15:12 < bridge> https://store.steampowered.com/app/469920/hackmud/ 15:14 < bridge> u made scripts to automatically unlock "locks" 15:14 < bridge> its actually p good 15:14 < bridge> the high lvl locks are quite hard 15:17 < bridge> thep roblem with these games tho is if someone publishes a script its done 15:17 < bridge> $20 :monkaS: 15:17 < bridge> cuz everyone has access to it 15:17 < bridge> i dont recommend hackmud as is now 15:17 < bridge> it was better pre 2.0 15:17 < bridge> its kind of abandoned by community 15:18 < bridge> Anyway im greedy fuck to spend $20 xD 15:18 < bridge> xd 15:18 < bridge> thats nuthing 15:18 < bridge> it gave me 600 hours so 15:18 < bridge> its was worth 15:18 < bridge> i actually bought it 2 times 15:18 < bridge> Deadge 15:18 < bridge> cuz the meta-meta that time was to bot it outside 15:18 < bridge> and 2 clients gave an edge 15:18 < bridge> everybody botted a game about botting 15:19 < bridge> but 2.0 killed it kinda 15:19 < bridge> so the fun went 15:19 < bridge> and everybody who played this game was hardcore hackers, in the programming sense 15:19 < bridge> ppl dissected the protocol etc xd 15:19 < bridge> kinda hilarious 15:19 < bridge> i still play 15:19 < bridge> I spent only 195 uah on games ;) 15:19 < bridge> gotta use that lifetime sub 15:19 < bridge> 5 eur? xd 15:20 < bridge> Yep 15:20 < bridge> I bought only cup head 15:20 < bridge> let me find my value 15:20 < bridge> its in USD but i pay euro 15:20 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068536090128031855/image.png 15:21 < bridge> this is since 2013 xd 15:21 < bridge> At school 15:21 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068536197623848991/20230127_152020.jpg 15:21 < bridge> @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 15:21 < bridge> 7k 😭 15:21 < bridge> yes, i think its called canned queries, i can also show a dashboard from these queries 15:21 < bridge> altho the dashboard requires some effort 15:22 < bridge> Would be nice to have some way to show the queries and so people can edit them 15:22 < bridge> > 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. 15:22 < bridge> yeah 15:22 < bridge> Did you not fix Graphiql? :p 15:22 < bridge> can u send me some nice queries u got? 15:23 < bridge> ill try to put em 15:23 < bridge> https://docs.datasette.io/en/stable/sql_queries.html#canned-queries 15:24 < bridge> ppl can always edit the query 15:24 < bridge> thats my whole life man 15:24 < bridge> creating bots for games to profit off of it 15:24 < bridge> either in experience or financially 15:24 < bridge> eh idk about profit 15:24 < bridge> but we did for fun 15:24 < bridge> and cuz everybody did 15:25 < bridge> yea it's fun to create bots for games 15:26 < bridge> I sent a link that contains queries 15:26 < bridge> oh 15:26 < bridge> missed it xD 15:26 < bridge> thanks 15:28 < bridge> like I even enjoyed automating hvh in csgo, but only on servers dedicated to players hacking against each other 15:29 < bridge> like I even enjoyed automating hvh in csgo. i did play hvh but only on servers dedicated to players hacking against each other 15:29 < bridge> Is there a 100% how to protect public servers feom ddos? 15:29 < bridge> whitelist ips from friends only 15:31 < bridge> 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. 15:32 < bridge> 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 15:32 < bridge> 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 15:34 < bridge> @deen 15:34 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068539602425614416/image.png 15:34 < bridge> it shows like this 15:34 < bridge> ill add them all now 15:36 < bridge> ``` 15:36 < bridge> ╒══════════════╀════════════════╀═════════════════════╀═════════╕ 15:36 < bridge> β”‚ map β”‚ Name β”‚ Timestamp β”‚ Time β”‚ 15:36 < bridge> β•žβ•β•β•β•β•β•β•β•β•β•β•β•β•β•β•ͺ════════════════β•ͺ═════════════════════β•ͺ═════════║ 15:36 < bridge> β”‚ Adrenaline 3 β”‚ Cireme β”‚ 2015-07-30 04:05:44 β”‚ 2289.46 β”‚ 15:37 < bridge> β”‚ Adrenaline 3 β”‚ aaa β”‚ 2015-07-30 04:05:44 β”‚ 2289.46 β”‚ 15:37 < bridge> β”‚ Xabier β”‚ β”‚ 2015-09-05 22:40:05 β”‚ 398.62 β”‚ 15:37 < bridge> β”‚ Xabier β”‚ hi_leute_gll β”‚ 2015-09-05 22:40:05 β”‚ 398.62 β”‚ 15:37 < bridge> β”‚ Gedan β”‚ EryX β”‚ 2016-02-02 13:11:32 β”‚ 65.92 β”‚ 15:37 < bridge> β”‚ Impossible 2 β”‚ Shocker β”‚ 2016-02-04 04:07:29 β”‚ 121.9 β”‚ 15:37 < bridge> β”‚ Reality β”‚ Shocker β”‚ 2016-02-24 04:38:42 β”‚ 270.54 β”‚ 15:37 < bridge> β”‚ Reality β”‚ Pwner β”‚ 2016-02-24 04:38:47 β”‚ 270.54 β”‚ 15:37 < bridge> β”‚ Careless β”‚ =Pipou= β”‚ 2016-06-10 02:24:25 β”‚ 30.34 β”‚ 15:37 < bridge> β”‚ Teleport β”‚ Soapy Sandwich β”‚ 2016-09-23 22:58:34 β”‚ 76.44 β”‚ 15:37 < bridge> β”‚ Skillz 6 β”‚ Soapy Sandwich β”‚ 2016-09-24 15:34:35 β”‚ 88.3 β”‚ 15:37 < bridge> β”‚ xyz_ddrace2 β”‚ Soapy Sandwich β”‚ 2016-09-24 16:53:59 β”‚ 148.88 β”‚ 15:37 < bridge> β”‚ Core β”‚ sloppydog β”‚ 2016-09-24 21:01:42 β”‚ 69.18 β”‚ 15:37 < bridge> β”‚ GlassBox 9 β”‚ Soapy Sandwich β”‚ 2016-09-24 23:20:15 β”‚ 91.98 β”‚ 15:37 < bridge> β”‚ Pale 2 β”‚ ^b[Bro] flummi β”‚ 2016-09-27 22:53:01 β”‚ 253.26 β”‚ 15:37 < bridge> β”‚ Pale 2 β”‚ meter'. β”‚ 2016-09-27 22:53:01 β”‚ 253.26 β”‚ 15:37 < bridge> β”‚ bBzZ!! β”‚ Colo-Colo β”‚ 2016-10-01 15:14:05 β”‚ 354.36 β”‚ 15:37 < bridge> β”‚ Deria β”‚ Soapy Sandwich β”‚ 2016-10-15 19:04:05 β”‚ 63.52 β”‚ 15:37 < bridge> β”‚ Vizur β”‚ 2_Ta6LeTki_LSD β”‚ 2016-12-05 15:16:59 β”‚ 119.56 β”‚ 15:37 < bridge> β”‚ Cuboid β”‚ stompie β”‚ 2016-12-25 21:08:28 β”‚ 98.76 β”‚ 15:37 < bridge> β•˜β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•§β•β•β•β•β•β•β•β•β•β•› 15:37 < bridge> ``` 15:37 < bridge> xD 15:37 < bridge> oldest ranks 15:37 < bridge> still standing 15:49 < bridge> @bencie wtf 15:49 < bridge> ur the most addicted to ddnet 15:50 < bridge> https://ddstats.org/ddnet-69b4e14/Most+Addicted+to+DDNet 15:51 < bridge> some queries take some time xD 15:51 < bridge> I figured, no caching? 15:51 < bridge> there is some 15:51 < bridge> by cloudflare 15:52 < bridge> but since im restarting a lot it doesnt 15:52 < bridge> cuz im adding the queries xD 15:52 < bridge> and cuz a plugin, 15:52 < bridge> https://datasette.io/plugins/datasette-hashed-urls 15:57 < bridge> @deen i added all the queries from the link 15:57 < bridge> https://ddstats.org/ddnet 15:57 < bridge> if u dont see them do a hard refresh 16:01 < bridge> Totally legitimately :justatest: 16:02 < bridge> ``` 16:02 < bridge> ╒════════════════╀═════════════════════════════════════╕ 16:02 < bridge> β”‚ Name β”‚ Time spent in all ranks (in days) β”‚ 16:02 < bridge> β•žβ•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•ͺ═════════════════════════════════════║ 16:02 < bridge> β”‚ bencie β”‚ 10451.6 β”‚ 16:02 < bridge> β”‚ Hav β”‚ 5003.24 β”‚ 16:02 < bridge> β”‚ Skystrife β”‚ 4494.22 β”‚ 16:02 < bridge> β”‚ [D] Nugget β”‚ 998.499 β”‚ 16:02 < bridge> β”‚ :b β”‚ 994.549 β”‚ 16:02 < bridge> β”‚ nameless tee β”‚ 547.594 β”‚ 16:02 < bridge> β”‚ Cipy29 β”‚ 523.311 β”‚ 16:02 < bridge> β”‚ kiwq β”‚ 511.303 β”‚ 16:02 < bridge> β”‚ Naka! β”‚ 499.596 β”‚ 16:02 < bridge> β”‚ widepeepoHappy β”‚ 497.454 β”‚ 16:02 < bridge> β”‚ furo β”‚ 497.126 β”‚ 16:02 < bridge> β”‚ bencie. β”‚ 497.109 β”‚ 16:02 < bridge> β”‚ bencie^^ β”‚ 497.103 β”‚ 16:02 < bridge> β”‚ Steinchen1 β”‚ 497.083 β”‚ 16:02 < bridge> β”‚ bencie! β”‚ 497.083 β”‚ 16:02 < bridge> β”‚ Steinchen99UwU β”‚ 497 β”‚ 16:02 < bridge> β”‚ BaumWollesax β”‚ 428.177 β”‚ 16:02 < bridge> β”‚ kiwi β”‚ 399.245 β”‚ 16:02 < bridge> β”‚ brainless tee β”‚ 394.936 β”‚ 16:02 < bridge> β”‚ Shinoa β”‚ 382.387 β”‚ 16:02 < bridge> β•˜β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•› 16:03 < bridge> ``` 16:03 < bridge> @bencie smh 18:00 < bridge> ```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 18:01 < bridge> ```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 18:01 < bridge> or just exclude all maps with Time Bonus tile πŸ˜„ 18:02 < bridge> oh ye 18:02 < bridge> the query used is probs before the map existed 18:17 < bridge> Bad service, cant insert new ranks :feelsbadman: 18:17 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068580438735585320/Screenshot_2023-01-27-19-16-18-082-edit_org.mozilla.firefox.jpg 18:17 < bridge> :justatest: 18:35 < bridge> sql, my worst nightmare 18:57 < bridge> is ddnet website ok? 18:58 < bridge> @Ryozuki 18:58 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068590807747137546/image.png 18:58 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068590940278759524/image.png 18:58 < bridge> deadge 18:59 < bridge> hmm works for me 18:59 < bridge> doesn't for me 19:00 < bridge> @Chairn that query in specific is quite complex 19:00 < bridge> it takes 50s to complete xd 19:00 < bridge> but with luck its cached by cloudflare 19:00 < bridge> but odd 19:00 < bridge> it worked again for me with a hard refresh 19:00 < bridge> i cant find a link to other prewritten queries 19:00 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068591444559925299/image.png 19:00 < bridge> u dont see this? 19:01 < bridge> nah 19:01 < bridge> try ctrl f5 19:01 < bridge> cache 19:01 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068591554010300446/image.png 19:01 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068591601577889913/image.png 19:01 < bridge> xd 19:01 < bridge> click on ddnet 19:01 < bridge> not race 19:02 < bridge> man, do better ui please πŸ˜„ 19:02 < bridge> its meant to support more databases 19:02 < bridge> so ddnet represents the ddnet db xD 19:02 < bridge> with those tables 19:03 < bridge> but there are 4 dbs, so i went to the race one 19:04 < bridge> https://ddstats.org/ddnet-69b4e14/Longest+Ranks 19:04 < bridge> Gotta remove Just Every Fly from the map list too 19:04 < bridge> do same for sum of all finish time, bencie dies of old age on this map 19:05 < bridge> same for Most Time Spent on Map 19:05 < bridge> or just cross information with maps db πŸ™‚ 19:07 < bridge> there is 1 db 19:07 < bridge> and 4 tables 19:08 < bridge> then cross information from race table and maps table to auto remove time penalties map 19:08 < bridge> you can do it! 19:08 < bridge> :D 19:08 < bridge> i can do it ez in python panda 19:08 < bridge> u dont know sql? 19:08 < bridge> i can't do it in SQL :cammostripes: 19:08 < bridge> no 19:08 < bridge> only the basics 19:08 < bridge> i never used it anyway 19:08 < bridge> which tile is the time thing 19:09 < bridge> ``` 19:09 < bridge> 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 19:09 < bridge> ``` 19:10 < bridge> ah, tiles are not in table anyway 19:10 < bridge> i think tis BONUS 19:10 < bridge> Avoid Bullseye Care for your Time 19:10 < bridge> ye 19:11 < bridge> ima do it 19:11 < bridge> how? that information is not in db? 19:11 < bridge> it is 19:11 < bridge> BOOST 19:11 < bridge> in mapinfo 19:12 < bridge> if its 1 the map has the tile 19:12 < bridge> check the mapinfo table 19:13 < bridge> oh its quite ez actually 19:13 < bridge> lel, mapinfo has one more row than maps 19:14 < bridge> 13 maps with bonus tile 19:14 < bridge> https://ddstats.org/ddnet-69b4e14/mapinfo?_facet=BONUS&BONUS=1#facet-BONUS 19:14 < bridge> ye 19:14 < bridge> ```sql 19:14 < bridge> select 19:14 < bridge> race.Map, 19:14 < bridge> sum(Time) /(3600 * 24 * 365) as Years, 19:14 < bridge> maps.Timestamp as "Map Release Date" 19:14 < bridge> from 19:14 < bridge> race 19:14 < bridge> inner join maps on race.Map = maps.Map 19:14 < bridge> inner join mapinfo on race.Map = mapinfo.Map 19:14 < bridge> and mapinfo.BOOST = 0 19:14 < bridge> group by 19:14 < bridge> maps.Map 19:14 < bridge> order by 19:14 < bridge> Years desc 19:14 < bridge> limit 19:14 < bridge> 20; 19:14 < bridge> ``` 19:14 < bridge> 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 19:15 < bridge> curious 19:15 < bridge> this removes multeasymap 19:15 < bridge> maybe it has the tile somewhere? 19:15 < bridge> ```SQL 19:15 < bridge> CREATE TABLE `mapinfo` ( 19:15 < bridge> `Map` varchar(128) NOT NULL 19:15 < bridge> , `Width` integer DEFAULT 0 19:15 < bridge> , `Height` integer DEFAULT 0 19:15 < bridge> , `DEATH` integer DEFAULT 0 19:15 < bridge> , `THROUGH` integer DEFAULT 0 19:15 < bridge> , `JUMP` integer DEFAULT 0 19:15 < bridge> , `DFREEZE` integer DEFAULT 0 19:15 < bridge> , `EHOOK_START` integer DEFAULT 0 19:15 < bridge> , `HIT_END` integer DEFAULT 0 19:15 < bridge> , `SOLO_START` integer DEFAULT 0 19:15 < bridge> , `TELE_GUN` integer DEFAULT 0 19:15 < bridge> , `TELE_GRENADE` integer DEFAULT 0 19:15 < bridge> , `TELE_LASER` integer DEFAULT 0 19:15 < bridge> , `NPC_START` integer DEFAULT 0 19:15 < bridge> , `SUPER_START` integer DEFAULT 0 19:15 < bridge> , `JETPACK_START` integer DEFAULT 0 19:15 < bridge> , `WALLJUMP` integer DEFAULT 0 19:15 < bridge> , `NPH_START` integer DEFAULT 0 19:15 < bridge> , `WEAPON_SHOTGUN` integer DEFAULT 0 19:15 < bridge> , `WEAPON_GRENADE` integer DEFAULT 0 19:15 < bridge> , `POWERUP_NINJA` integer DEFAULT 0 19:15 < bridge> , `WEAPON_RIFLE` integer DEFAULT 0 19:15 < bridge> , `LASER_STOP` integer DEFAULT 0 19:15 < bridge> , `CRAZY_SHOTGUN` integer DEFAULT 0 19:15 < bridge> , `DRAGGER` integer DEFAULT 0 19:16 < bridge> , `DOOR` integer DEFAULT 0 19:16 < bridge> , `SWITCH_TIMED` integer DEFAULT 0 19:16 < bridge> , `SWITCH` integer DEFAULT 0 19:16 < bridge> , `STOP` integer DEFAULT 0 19:16 < bridge> spam xd 19:16 < bridge> hmm there is but its redundant 19:16 < bridge> bool in sql is usually int with 1 digit 19:16 < bridge> or smth 19:16 < bridge> sql is archaic 19:16 < bridge> nah, multeasymap doesn't have bonus tile 19:16 < bridge> oh 19:16 < bridge> im stpid 19:16 < bridge> i used BOOST 19:16 < bridge> instead of bonus 19:16 < bridge> XD 19:16 < bridge> it also removes Kobra πŸ™‚ 19:16 < bridge> 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 19:16 < bridge> here 19:16 < bridge> fixed 19:16 < bridge> ah ez mistake on friday evening 19:16 < bridge> ill add it to premade queries 19:17 < bridge> nah 19:17 < bridge> you failed again, there's Just Every Fly in there 19:18 < bridge> and flappy bird, and Time Shop 19:18 < bridge> lul 19:18 < bridge> @Ryozuki abort mission 19:18 < bridge> ah 19:18 < bridge> i used a left join 19:18 < bridge> instead of inner 19:18 < bridge> xd 19:18 < bridge> truly friday 19:19 < bridge> someone request me to do the addict maps on a per map basis 19:19 < bridge> so no repeated multeasymap 19:19 < bridge> too 19:19 < bridge> ohh 19:19 < bridge> i need to increase the nginx timeout xd 19:20 < bridge> thats why long running queries give cloudflare err 19:20 < bridge> well, i gotta go, raclette awaits me πŸ™‚ 19:20 < bridge> Good luck πŸ˜› 19:20 < bridge> whats that? 19:20 < bridge> but good luck too 19:20 < bridge> https://en.wikipedia.org/wiki/Raclette 19:22 < bridge> ohh yum 19:27 < bridge> what's the flag to compile ddnet so I can debug a segfault with gdb? 19:28 < bridge> just compile in debug mode 19:28 < bridge> which is the default 19:35 < bridge> cmake -DCMAKE\_BUILD\_TYPE=Debug 19:35 < bridge> (@Reteah) 19:38 < bridge> And then run it withgdb ./DDNet 19:38 < bridge> 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 19:39 < bridge> yeah I did so 19:40 < bridge> I wrote it already in #bugs but when my lil bro joins fokkonaut's playground he gets the seg fault 19:44 < bridge> https://ddstats.org/ddnet-69b4e14/Most+Addicted+to+DDNet 19:44 < bridge> updated the query 19:44 < bridge> if u see old results ctlr f5 19:44 < bridge> chillerdragon iss back on the top on most addicted 19:45 < bridge> tldr: changed 3 saved queries to use mapinfo tile data to avoid bonus time tiles 19:49 < bridge> Is it normal that the web loads awfully slow? or is it just my connexion 19:49 < bridge> its normal cuz i just purged the cache 19:49 < bridge> most queries listed there are quite expensive xd 19:50 < bridge> and there is 19M rows in race 19:50 < bridge> Oh okok, makes sense thanks x) 19:55 < bridge> ima try something 20:01 < bridge> :poggers2: 20:02 < bridge> you're definetly missing smth, raclette is damn amazing 21:37 < bridge> @heinrich5991 you've talked about the usage of quic proto for ddnet, do you have any PoC ? 21:37 < bridge> or maybe master servers, forgot 22:39 < bridge> help vulkan 22:40 < bridge> what are u trying 22:42 < bridge> I'm building the poc 22:46 < bridge> help rust 22:46 < bridge> xdd 22:46 < bridge> what do you need to know 22:47 < bridge> how entropy can be reverse 22:47 < bridge> how entropy can be reversed 22:48 < bridge> https://astronomy.org/moravian/C00-Last%20Question.pdf 22:48 < bridge> i cant use vulkan for some reason 22:48 < bridge> whats ur GPU 22:48 < bridge> everytime i select vulkan and restart its back to opengl 22:48 < bridge> oof idk 22:48 < bridge> let me look 22:49 < bridge> start client, press f1, see purple text "gfx ..." 22:49 < bridge> there it should tell u 22:49 < bridge> .unwrap() 22:49 < bridge> Intel(R) HD Graphics 3000 22:50 < bridge> and if u say it doesnt support 22:50 < bridge> i used to use it 22:50 < bridge> well that GPU doesnt support vulkan xd 22:50 < bridge> im pretty sure 22:50 < bridge> not 100% tho 22:50 < bridge> nah no way bro 22:50 < bridge> thats like ivybridge or smth 22:50 < bridge> epic 22:50 < bridge> wha 22:50 < bridge> bruh 22:51 < bridge> do u atleast know what do to against fps drops 22:51 < bridge> like after time 22:51 < bridge> they drop lower and lower 22:51 < bridge> its stupid 22:51 < bridge> i dunno, if its not a memory leak, i'd say better cooling 22:51 < bridge> try linux with old hardware 22:51 < bridge> u might have a better time, sometimes also not ^^ 22:52 < bridge> im on windows 22:52 < bridge> yeah time to switch 22:52 < bridge> not a useful hint 22:52 < bridge> ? 22:52 < bridge> I wouldn't switch my OS to play some game, I'd expect most people don't 22:53 < bridge> well if ms makes the game lagg 22:53 < bridge> why not 22:53 < bridge> i gave him multiple solutions 22:53 < bridge> u just want to provocate again 22:53 < bridge> pls just stop 22:55 < bridge> He has a laptop btw 22:56 < bridge> So did ddnets older versions support vulkan or did it just show that he used vulkan but didnt actually 22:56 < bridge> i guess none of both 22:56 < bridge> maybe it supported vulkan 1.0 but not vulkan 1.1? 22:56 < bridge> wikipedia says it doesnt support vk 22:57 < bridge> ^? 22:57 < bridge> only chance is that he has a second GPU 22:57 < bridge> I mean I know the guy and he says that he used vulkan before 22:57 < bridge> afaik no windows GPU exists that wasnt upgraded to 1.1 too 22:57 < bridge> but anyway why should wikipedia lie 22:57 < bridge> ah ok 22:57 < bridge> Alright guess it's a mystery then 22:57 < bridge> Thanks for the help 22:59 < bridge> u could simply try all renderers in settings -> graphics 22:59 < bridge> 22:59 < bridge> 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.) 23:02 < bridge> i have vulkan 1.0 not 1.1 23:02 < bridge> mine does 23:02 < bridge> try older version of ddnet I use 16.5 23:02 < bridge> which is vulkan 1.0 23:03 < bridge> i still have 1.0 tho 23:03 < bridge> how do u think so 23:03 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068652594353950891/image.png 23:04 < bridge> no intel hd 3000 in the database 23:04 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068652693725388830/image.png 23:04 < bridge> thats just an options bcs it doesnt check if your GPU supports it on fly 23:04 < bridge> after restart it checks it and if it failes it goes back to opengl 23:05 < bridge> i also used to have opengl 4.0 23:05 < bridge> its gone too 23:05 < bridge> what about that one 23:05 < bridge> nah bro xD 23:05 < bridge> bro i literally had it 23:05 < bridge> even on linux u only have opengl 3.1 support 23:05 < bridge> i am 100% sure on this 23:05 < bridge> 3.3* 23:05 < bridge> i had it 23:05 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1068653087352434778/image.png 23:05 < bridge> well ok 23:06 < bridge> i still had it 23:06 < bridge> then u have a second GPU? 23:06 < bridge> else no way 23:06 < bridge> laptop doenst fit 2gpus xd 23:06 < bridge> there are many laptops with dual gpu 23:06 < bridge> how do i know if i have 2 23:07 < bridge> anyway if you are so sure about it 23:07 < bridge> 23:07 < bridge> `gfx_gl_major 4; gfx_gl_minor 5` 23:07 < bridge> 23:07 < bridge> it will start to try all opengl renderers. 3.0 might work, but other intel users had crashes with it 23:07 < bridge> on windows 23:07 < bridge> staying with 2.0 is the safest bet 23:07 < bridge> restart after typing it 23:12 < bridge> bro 23:12 < bridge> i have 4.5 now 23:12 < bridge> what do you mean 23:12 < bridge> XDDD 23:12 < bridge> no way bro, then its showing it incorrectly for some reason.. maybe it shows it until u restarted πŸ˜„ 23:12 < bridge> bcs then the options are unchecked 23:12 < bridge> (from backend view) 23:13 < bridge> lemme try 23:14 < bridge> after restarting i have 1,5 instead of 4.5 or 2.0 23:14 < bridge> :D 23:14 < bridge> that sounds more realistic πŸ˜„ 23:15 < bridge> i dunno rn if it switches to 2.0 back at all, it does the bug list thing only once i guess, just use: 23:15 < bridge> `gfx_gl_major 2; gfx_gl_minor 0` 23:40 < bridge> Conclusion: upgrade ur pc 23:49 < bridge> Cleaning Ur PC properly can do magic. Most ppl underestimate that 23:49 < bridge> But it takes 1-2 h for a laptop 23:50 < bridge> BCS of disassemble 23:50 < bridge> True 23:50 < bridge> At work i install windows, clean and upgrade pcs if they are old 23:50 < bridge> Cleaning does do wonders 23:51 < bridge> Epic moment 23:51 < bridge> No u 23:51 < bridge> are epic 23:51 < bridge> All of the homo 23:52 < bridge> !all of the homo 23:52 < bridge> https://youtu.be/cGJMbEzbgQk 23:59 < bridge> ty for ur help btw <3 23:59 < bridge> its back at 2.0