Guild icon
DDraceNetwork
DDraceNetwork / general
This channel is for all Teeworlds/DDNet and related chat. Gameplay questions can be asked here as well rather than in #questions. Ingame screenshots and any other Teeworlds related media goes to #showroom.
Between 2023-01-30 00:00:00Z and 2023-01-31 00:00:00Z
Avatar
@Headshot
01:36
go private pls
Avatar
i ate kebab
01:37
again not hotdog this time
01:38
i think im going insane
Avatar
Lumpy ◐ω◑ 2023-01-30 05:19:27Z
wait did Meek leave? what happened? got banned by one of the new moderators?
Avatar
Mods can't ban
Avatar
Avatar
Skeith
Mods can't ban
Lumpy ◐ω◑ 2023-01-30 06:59:02Z
oh we're safe then greenthing
Avatar
@Skeith i hate you
07:50
but i love you a bit more
Avatar
mekrioz left like a fart
08:31
(no reverb)
Avatar
(vine boom)
Avatar
quiz: which new mod will get demoted first
greenthing 3
Avatar
Can I bet money on that?
Avatar
@deen do you think the game would handle 100k concurrent players? if the game does have that much at 1 point how would you prevent ddos?
Avatar
Avatar
spur
@deen do you think the game would handle 100k concurrent players? if the game does have that much at 1 point how would you prevent ddos?
nope
Avatar
how do you know
09:36
bruh i asked the owner if he can pull something off to prevent that xd
Avatar
where would all the 98k players go
Avatar
he probably can pay a lot of money or smth to open up a lot of servers
09:36
upping the player cap from 63 to 100 or more would be a disaster
Avatar
How many servers will he need? 🤔
Avatar
probably a lot? at one point a famous youtuber might come across this game and upload a video on it
09:37
it already happened with a small chinese youtuber and now 80% of the playerbase is chinese
Avatar
1562 and a half
09:40
We need more ddnetubers
Avatar
Avatar
spur
@deen do you think the game would handle 100k concurrent players? if the game does have that much at 1 point how would you prevent ddos?
If they appear in 1 second, no. If they come in slower, I can start up more servers
Avatar
ah thats good to know
Avatar
We'd get more dedicated servers then, those are also better at withstanding attacks
10:11
compared to the cheap VPSes we use in most locations now
Avatar
Avatar
MilkeeyCat
How many servers will he need? 🤔
In general you can say 1 CPU core per 100 players
10:13
so that would be 1000 cores to handle 100k players, if we get fancy dedicated servers with 64 cores each, 16 dedicated servers would be enough, but you'd want some buffer, so better get 20-30 (edited)
Avatar
Avatar
deen
so that would be 1000 cores to handle 100k players, if we get fancy dedicated servers with 64 cores each, 16 dedicated servers would be enough, but you'd want some buffer, so better get 20-30 (edited)
how much will that cost?
Avatar
Sounds like few kidneys
Avatar
Depends on the location of servers. Europe and USA would be cheapest. I'd get something like this: https://www.hetzner.com/de/dedicated-rootserver/ax161/configurator#/ I'm not exactly sure how well the smp threads would work under high load, so maybe need double the number? So about 160-320 € / server / month. Makes 3200-6400 € per month for 20-40 servers
Avatar
Avatar
cyberFighter
nope
also why would you respond instantly on a subject you're clearly wrong on
10:21
ah that's not as expensive i though it would be
Avatar
Yeah, that's totally fine for 100k players concurrently
10:22
Right now many of our servers are sitting around idly for most of the day, so that makes them less efficient
10:22
So if you know a famous youtuber, tell them to try out DDNet 😄
justatest 4
Avatar
ah good to know the game can actually be stable if a sudden rush happens
Avatar
Lumpy ◐ω◑ 2023-01-30 10:29:04Z
imagine 1000 full multeasy servers justatest
Avatar
We can ask shroud to play ddnet
10:35
Or ninja
Avatar
Or xqc monkalaugh monkalaugh
10:38
He have probably the most trollish fanbase, they will ddos all servers nouis (edited)
Avatar
works for me
Avatar
ah ok, with vpn it works, so bad to be russian in this days troll
Avatar
When nerf all russian times
10:47
Add +10% to their time
Avatar
Avatar
Alexander
Add +10% to their time
fuck no feelsbadman
Avatar
Gotta give others a chance for speedrunning
10:57
Just be 10% faster than others
Avatar
what russians
11:06
there's only 1 xd
11:06
that has rank 1s*
Avatar
i mean with 100k players this discord would grow a lot too
11:15
and hopefully donations lol
Avatar
Avatar
RonIn
must be bad routing, I don't slow down connections
Avatar
Avatar
Ryozuki
i mean with 100k players this discord would grow a lot too
Sad we didn't get 2nd season cuz of baby criers ehhhh, we could have accounts, clan points and etc feelsbadman
feelsbadman 2
Avatar
it wasnt cuz baby criers, but because people expected too much
Avatar
imagine if ddnet coummunity would have 100k players
11:23
that will be impossible to make 2nd season then (edited)
11:23
and when we still can
11:23
people reject it
11:23
stupid
Avatar
Avatar
Ryozuki
it wasnt cuz baby criers, but because people expected too much
Better admins don't even ask what this community wants
11:24
justatest
11:25
Ok, i just believe deen will does it this summer and no one knew he was working on it troll
Avatar
Avatar
RonIn
Better admins don't even ask what this community wants
Then we get so much hate. It's mentally taxing
Avatar
Avatar
Learath2
Then we get so much hate. It's mentally taxing
i will love u
Avatar
How did you remove stars
Avatar
Avatar
MilkeeyCat
How did you remove stars
they will return
11:32
tsss
Avatar
Avatar
MilkeeyCat
How did you remove stars
see here for example 😉
Avatar
Avatar
heinrich5991
see here for example 😉
bad example, cuz i didn't remember u asked people about removing stars xDD
Avatar
I think nobody would hate accounts
11:33
:)
Avatar
Avatar
RonIn
bad example, cuz i didn't remember u asked people about removing stars xDD
didn't you suggest not asking people and just doing?
Avatar
Avatar
MilkeeyCat
I think nobody would hate accounts
I like your optimism, but you're wrong
Avatar
Avatar
RonIn
bad example, cuz i didn't remember u asked people about removing stars xDD
I think we had the pr open for months and there was even a beta. But anyway, the patch was written before asking, I've actually been called a demon over it and I havent even written that patch 😛
Avatar
Avatar
heinrich5991
didn't you suggest not asking people and just doing?
yes i did, don't listen those...
Avatar
Avatar
Learath2
I think we had the pr open for months and there was even a beta. But anyway, the patch was written before asking, I've actually been called a demon over it and I havent even written that patch 😛
Why people think be a demon is bad?
11:37
tee_thinking
Avatar
demon (plural demons) 1. An evil supernatural spirit.
(emphasis mine)
Avatar
Avatar
heinrich5991
demon (plural demons) 1. An evil supernatural spirit.
(emphasis mine)
definition was invented by believers kek
Avatar
hey im new in this game anyone want to help me a bit out and play together?
Avatar
#looking-for-group
Avatar
I ALMOST GET TOP ON MODERATE
12:15
And my electricity died (edited)
12:15
Hell nah
Avatar
Original message was deleted or could not be loaded.
Wrong person bro
12:16
Im so bad
12:16
wrong chat
Avatar
Ah ok
Avatar
@Lumpy ◐ω◑ when carry
Avatar
@Kei anyway i saw that and have proof in logs
12:18
Waiting u in my room
Avatar
Avatar
-StormAx
@Kei anyway i saw that and have proof in logs
justatest
Avatar
Lumpy ◐ω◑ 2023-01-30 12:18:56Z
maybe there is some misunderstanding, why ppl think it would take away 'thousands of hours of peoples Playtime' and destroy the soul? can't we just add the accounts to current system without changing it? so you can play without the account, but as an addition you can create an account and play with old name, and if you log in ppl will see that it's you coz it's your account, similar with finishes, we will see if it was made with account or without
Avatar
Avatar
Kei
@Lumpy ◐ω◑ when carry
Lumpy ◐ω◑ 2023-01-30 12:19:01Z
you me when
Avatar
Avatar
Lumpy ◐ω◑
maybe there is some misunderstanding, why ppl think it would take away 'thousands of hours of peoples Playtime' and destroy the soul? can't we just add the accounts to current system without changing it? so you can play without the account, but as an addition you can create an account and play with old name, and if you log in ppl will see that it's you coz it's your account, similar with finishes, we will see if it was made with account or without
The problem really is that it's hard to determine who the owner of a usename would be (edited)
Avatar
Avatar
default
The problem really is that it's hard to determine who the owner of a usename would be (edited)
Lumpy ◐ω◑ 2023-01-30 12:19:47Z
why do we even need to do that?
Avatar
For most users
12:20
So you keep your points/ranks
12:20
We could start from 0 for everyone, sure
12:20
But I would F4 that shit then
12:20
f4
Avatar
I don't see why
12:22
Having everything restart means that I have more motivation to play maps
Avatar
Lumpy ◐ω◑ 2023-01-30 12:22:17Z
I think you just didn't get my point, you have an account or dont, you play with some name points tied to a name, but you can see finishes by accounts on the same name
Avatar
Yes it's satisfying to see everything completed but I think it's nice to play through all the maps again with some motivation
12:22
Idk just me
Avatar
Lumpy ◐ω◑ 2023-01-30 12:23:24Z
and I think it's not hard to keep the statistics how many points were gained with each account and without
12:24
if it's just that big of a deal with points and ability to play without accounts, why not force it and just make an addition for those who want accounts?
Avatar
Avatar
Lumpy ◐ω◑
I think you just didn't get my point, you have an account or dont, you play with some name points tied to a name, but you can see finishes by accounts on the same name
This is about what we had in mind before it got cancelled again
12:28
There were some internal conflicting opinions too. E.g. deen and heinrich's iteration on it had literally no difficulty to creating an account. So it wouldn't help with moderation at all. Which made mods not the biggest fan of it
Avatar
waaah That's the start of the end. Can't pay for boosting anymore.
Avatar
Avatar
Learath2
There were some internal conflicting opinions too. E.g. deen and heinrich's iteration on it had literally no difficulty to creating an account. So it wouldn't help with moderation at all. Which made mods not the biggest fan of it
Creating accounts pretty much never will be a challenge
12:29
And if you dont need an account. What's the point. (Lumpies idea) (edited)
Avatar
Avatar
Learath2
There were some internal conflicting opinions too. E.g. deen and heinrich's iteration on it had literally no difficulty to creating an account. So it wouldn't help with moderation at all. Which made mods not the biggest fan of it
even if it's easy to create an account, it will hugely reduce the amount of daily malicous players just because of the fact that it is not as accessible as just changing name or ip
Avatar
Avatar
Learath2
There were some internal conflicting opinions too. E.g. deen and heinrich's iteration on it had literally no difficulty to creating an account. So it wouldn't help with moderation at all. Which made mods not the biggest fan of it
Lumpy ◐ω◑ 2023-01-30 12:30:11Z
I think at this point devs and users want different from accounts, or maybe there is some misunderstanding
Avatar
Avatar
default
Creating accounts pretty much never will be a challenge
Email verification slows it down a fair bit. What the last proposal was allowed instant creation of accounts with some bolted on rate limiting using heuristics
Avatar
Avatar
Lumpy ◐ω◑
I think at this point devs and users want different from accounts, or maybe there is some misunderstanding
Lots of parties all want different things. So we can just never push ahead with it
Avatar
Politics in a nutshell
Avatar
Avatar
default
And if you dont need an account. What's the point. (Lumpies idea) (edited)
We could set servers to account only for a while when trolls get too annoying
Avatar
Avatar
Learath2
Email verification slows it down a fair bit. What the last proposal was allowed instant creation of accounts with some bolted on rate limiting using heuristics
I bet I could automate anything you throw at me
Avatar
Avatar
Learath2
Lots of parties all want different things. So we can just never push ahead with it
Lumpy ◐ω◑ 2023-01-30 12:31:57Z
why mods are against this implementation? can you explain a bit?
Avatar
Avatar
Lumpy ◐ω◑
why mods are against this implementation? can you explain a bit?
Against is a strong word, they just didn't like it very much simply because it didn't help them at all when moderating
Avatar
Avatar
Lumpy ◐ω◑
why mods are against this implementation? can you explain a bit?
it would make mods less valuable if there's less work trollet
Avatar
If you can instantly create an account AND play without accounts, it doesn't stop or slow down anyone
Avatar
Which was the whole point behind the accounts idea*
Avatar
Avatar
default
Which was the whole point behind the accounts idea*
u wont be able to play with Aoe name?
Avatar
If they go with Lumpies idea, you can
Avatar
Avatar
Learath2
If you can instantly create an account AND play without accounts, it doesn't stop or slow down anyone
Lumpy ◐ω◑ 2023-01-30 12:36:37Z
so if players want the accounts and it's easy for the devs to implement and mods get nothing good and nothing bad from this, why no just add this, because at least users will have what they ask for? and maybe make it not so easy to create an account (because it's only for those who wants to create it)?
Avatar
i didnt read anything above
Avatar
But Aoe will have an account on which you can see that he did a lot of finishes using the name
12:36
Thats how I understood Lumpies idea
Avatar
seems like before writing some shit i have to read first :\ (edited)
Avatar
Avatar
default
But Aoe will have an account on which you can see that he did a lot of finishes using the name
Lumpy ◐ω◑ 2023-01-30 12:37:21Z
yes
12:38
and in the game you'll be able to see if it's Aoe with his account or without
12:38
troll
Avatar
or just start everything from 0
Avatar
That would basically kill the last 8 years of progress that people connected with a name
12:39
Which I would be against
Avatar
Avatar
default
That would basically kill the last 8 years of progress that people connected with a name
so you are playing for numbers?
Avatar
Avatar
Lumpy ◐ω◑
so if players want the accounts and it's easy for the devs to implement and mods get nothing good and nothing bad from this, why no just add this, because at least users will have what they ask for? and maybe make it not so easy to create an account (because it's only for those who wants to create it)?
But then what is the point of accounts even? Can't moderate with them. Can't associate the old ranks to them
Avatar
Avatar
MilkeeyCat
so you are playing for numbers?
Sure you learned all the skills. But if you have to refinish 3000 maps again. Fuck it.
Avatar
if you wont have your huge number you wont play the game? (edited)
Avatar
Avatar
default
That would basically kill the last 8 years of progress that people connected with a name
Lumpy ◐ω◑ 2023-01-30 12:40:20Z
are you even reading? they will still play with that name, how it will kill the progress
Avatar
Are you reading chicken?
Avatar
Avatar
Lumpy ◐ω◑
are you even reading? they will still play with that name, how it will kill the progress
he's talking about my IDEA xD (edited)
Avatar
Avatar
MilkeeyCat
he's talking about my IDEA xD (edited)
Lumpy ◐ω◑ 2023-01-30 12:41:00Z
oh my bad, sry
Avatar
wheres instagib with stats
Avatar
And yes. It would destroy a huge part of the game for me. @MilkeeyCat
12:42
I probably wont quit. But I won't be interested to play old maps again.
Avatar
Avatar
default
And yes. It would destroy a huge part of the game for me. @MilkeeyCat
so all the possible adittions dont worth losing numbers?
Avatar
What additions
Avatar
Avatar
default
I probably wont quit. But I won't be interested to play old maps again.
dont play? xD
Avatar
No one knows what accounts would bring
12:43
All the features you could have, you can do without accounts
Avatar
Avatar
Learath2
But then what is the point of accounts even? Can't moderate with them. Can't associate the old ranks to them
Lumpy ◐ω◑ 2023-01-30 12:43:08Z
to start with something? ppl will create an account and maybe start from scratch or continue with the name they had and have their own statistics? or for new ppl who can start their journey with account
12:45
afk a bit
Avatar
Avatar
default
All the features you could have, you can do without accounts
gigachad 1
Avatar
I didn't say it won't be fun anymore. I am just against destroying legacies connected to a name that were built up for a decade.
Avatar
then how much money starkiller will have to pay to get back those points 🫢
Avatar
You basically are okay with deleting records people did set up. That might never get broken again. (edited)
12:49
I am against that. Thats why I am against an account system thats gets rid of map finishes and your times on those. You basically spit in the face of everyone who hunted a map. And since you can't precisely tell who owns the records and finishes of a name, accounts probably never will be like I want them. (edited)
Avatar
Avatar
MilkeeyCat
then how much money starkiller will have to pay to get back those points 🫢
50$ per each map
12:50
2000 maps
12:50
only 100000$
Avatar
i love how he actually did pay someone 50 dollars to finish his own solo map
12:51
kek
Avatar
does he have to try to finish his own map? hell nah
Avatar
thats my new todo list
12:52
make 5 star solo and pay someone to finish it in my name
Avatar
Who sells map finishes?
12:53
I think DefaultO misses some brutal finishes
Avatar
Avatar
default
Who sells map finishes?
Tokly XD
12:54
Also @Draggory and @Kao
12:54
:)
Avatar
Well if u want to get all stronghold times
12:55
Call him
Avatar
I might consider it
12:57
nouis
Avatar
Avatar
MilkeeyCat
banhammer bluestripe
Name Boosting isn't against the rules
12:59
But I thought it's obvious that we are all joking here (or do we not >:)
Avatar
remove sting from boosting
12:59
scariest shit ive ever seen
Avatar
Avatar
default
Name Boosting isn't against the rules
fair enough
Avatar
Avatar
MilkeeyCat
fair enough
I think people handle it like. If the player behind the name plays worse than what the stats show. Then he probably isn't the original player behind the name or was boosted. (edited)
Avatar
i cant even do hammer hit rn
13:05
feelsbadman
Avatar
6k whale ^
13:11
more like boosted whale
Avatar
ive never had 6k
Avatar
What was it then
13:12
4/5?
13:12
5.4 max
Avatar
High prices only
13:24
For finishes
13:25
Also can't even do 3star solo
Avatar
Avatar
Learath2
But then what is the point of accounts even? Can't moderate with them. Can't associate the old ranks to them
For me a rank reset would be fine (reset as in ranks are not mapped to accounts but left floating account-less), also alongside easy account creation. For me the benefits of accounts are 1. Only I can do ranks on my account 2. I know that people aren't faked 3. Accountability: people who build up reputation can be held accountable for cheating and also blocking. People actually have something to lose and can only do rule-breaking stuff on alts that few people care about
f3 7
Avatar
Avatar
Patiga
For me a rank reset would be fine (reset as in ranks are not mapped to accounts but left floating account-less), also alongside easy account creation. For me the benefits of accounts are 1. Only I can do ranks on my account 2. I know that people aren't faked 3. Accountability: people who build up reputation can be held accountable for cheating and also blocking. People actually have something to lose and can only do rule-breaking stuff on alts that few people care about
f3
Avatar
I prefer payment in twinbop r34 pics
Avatar
I am an Artist
13:33
I can do r34 art
Avatar
Avatar
Patiga
For me a rank reset would be fine (reset as in ranks are not mapped to accounts but left floating account-less), also alongside easy account creation. For me the benefits of accounts are 1. Only I can do ranks on my account 2. I know that people aren't faked 3. Accountability: people who build up reputation can be held accountable for cheating and also blocking. People actually have something to lose and can only do rule-breaking stuff on alts that few people care about
Lumpy ◐ω◑ 2023-01-30 13:37:14Z
luv you pepega heartw been trying to convince ppl since 2020 on this implementation https://discord.com/channels/252358080522747904/342454474117218334/746852003744841858
heartw 1
Avatar
You didn't convince anyone
what 1
13:38
Nor will accounts be a thing if the staff team doesn't want it (edited)
Avatar
Avatar
default
Nor will accounts be a thing if the staff team doesn't want it (edited)
the team might not agree on which kind of accounts are best, but account in general appear to be seen as a good thing
Avatar
Avatar
default
You didn't convince anyone
Lumpy ◐ω◑ 2023-01-30 13:43:47Z
I didn't say I did thonk
13:50
So many pings
Avatar
Avatar
Lumpy ◐ω◑
I didn't say I did thonk
what if i remove accounts on website and everyone can use any name they want kek
Avatar
@Learath2 easy to create accounts doesnt matter, a chat filter can be put in place by using account stats such as longevity of the account + playtime + points
13:51
an make some kind of heuristic function
13:51
better than not having anything xd
Avatar
Avatar
MilkeeyCat
what if i remove accounts on website and everyone can use any name they want kek
Lumpy ◐ω◑ 2023-01-30 13:56:33Z
justatest
Avatar
Avatar
-StormAx
Also @Draggory and @Kao
Hey I'm too bad to sell finishes
Avatar
Avatar
default
You basically are okay with deleting records people did set up. That might never get broken again. (edited)
Not getting deleted though, just archived iirc
Avatar
@Draggory ok ok as u say
Avatar
Avatar
Lumpy ◐ω◑
so about accounts, why can't we do it more like discord? You can have whatever nickname you want, but you can also have an account. If you have an account in the scoreboard you'll have like 4 digits number (or more) next to your nickname. So if I made an account my friends will know my ID and can check in the scoreboard if its me or other person with the same nickname
I'd like to have that system for names, too
Avatar
Avatar
Lumpy ◐ω◑
luv you pepega heartw been trying to convince ppl since 2020 on this implementation https://discord.com/channels/252358080522747904/342454474117218334/746852003744841858
Connecting discord to the game is a good idea yep, we don’t even need wipe then 🤷‍♂️
14:27
A lot of websites do the same
Avatar
And what about china?
Avatar
Chinese discord gigachad
Avatar
Good luck with that kek
Avatar
Let people get verification with their passport id
14:29
Good idea?
Avatar
And while we’re at it, they also have to provide a photo of themselves
Avatar
Avatar
RonIn
Connecting discord to the game is a good idea yep, we don’t even need wipe then 🤷‍♂️
this is entirely unrelated to wipe or not
14:30
AFAICT
Avatar
Avatar
Iza
And while we’re at it, they also have to provide a photo of themselves
biometric data, fingers print and etc
Avatar
Yes so we can pursue the plan of making a ddnet social credit system jaouis
Avatar
When ddcoins
14:35
Or teecoin
Avatar
Avatar
MilkeeyCat
When ddcoins
I believe it won’t be a scam kek
Avatar
hi
👋 2
Avatar
Avatar
heinrich5991
I'd like to have that system for names, too
Lumpy ◐ω◑ 2023-01-30 15:37:16Z
I wish we could have this system for a start, I think when it comes to the discussion about the accounts ppl think their points will get deleted and they will have to create an account, but that's not the only way, if they want things to stay as it is then they don't even need to do anything, only those who want an account will create it and use
Avatar
Avatar
RonIn
Let people get verification with their passport id
Great minds think alike
Avatar
Avatar
MilkeeyCat
When ddcoins
when in-game bitcoin wallet
Avatar
guys maybe you want to invеst in my cryptozoo project :) (edited)
Avatar
Avatar
Patiga
For me a rank reset would be fine (reset as in ranks are not mapped to accounts but left floating account-less), also alongside easy account creation. For me the benefits of accounts are 1. Only I can do ranks on my account 2. I know that people aren't faked 3. Accountability: people who build up reputation can be held accountable for cheating and also blocking. People actually have something to lose and can only do rule-breaking stuff on alts that few people care about
only no skill nobos wouldnt want accounts
Avatar
Avatar
I.K.U
only no skill nobos wouldnt want accounts
true
16:41
except for me
16:41
of course
16:41
im the exception
Avatar
ᴿᵉˣᵉᴺ 2023-01-30 16:44:08Z
Hello, I have a problem with ddnet and where can I raise that problem?
Avatar
Avatar
ᴿᵉˣᵉᴺ
Hello, I have a problem with ddnet and where can I raise that problem?
Post it in #questions (edited)
Avatar
i am
17:12
passed geomenrty
17:12
for 5
Avatar
Avatar
Learath2
Great minds think alike
gigachad
Avatar
Avatar
фуфлик
for 5
Lumpy ◐ω◑ 2023-01-30 17:13:29Z
5 out of ?
Avatar
5
Avatar
Lumpy ◐ω◑ 2023-01-30 17:14:10Z
gigachad
Avatar
recomendate maps?
17:25
europ
17:25
poggers2
Avatar
Avatar
фуфлик
for 5
nice i am passed relational databases 4.5 out of 5
Avatar
@Voxel goat
17:40
🪨 4
Avatar
Avatar
dope
nice i am passed relational databases 4.5 out of 5
Lumpy ◐ω◑ 2023-01-30 17:41:38Z
so proud of you heartw
Avatar
Avatar
Lumpy ◐ω◑
so proud of you heartw
thank u chimken
17:43
1 subject left to pass
Avatar
Avatar
dope
1 subject left to pass
Lumpy ◐ω◑ 2023-01-30 17:44:08Z
I believe in you, you'll crash it greenthing
Avatar
Avatar
dope
nice i am passed relational databases 4.5 out of 5
prove it
17:48
post a interesting query from https://ddstats.org/ (edited)
kek 1
Avatar
nobody beating my querys
Avatar
select * from ddnet where noone = ask
kek 1
17:48
im in bus rn
17:50
just got out of uni
Avatar
@dope use a window function
17:50
and 1 group by
17:50
with a join
17:50
and tell me what is the 3rd normal form in a db
Avatar
3rd form is about not having duplicates in db
17:52
i dont have english word in my mind for it
Avatar
Third normal form (3NF) is a database schema design approach for relational databases which uses normalizing principles to reduce the duplication of data, avoid data anomalies, ensure referential integrity, and simplify data management. It was defined in 1971 by Edgar F. Codd, an English computer scientist who invented the relational model for d...
Avatar
thats what i meant
17:53
😎
Avatar
A database relation (e.g. a database table) is said to meet third normal form standards if all the attributes (e.g. database columns) are functionally dependent on solely the primary key
17:54
Requiring existence of "the key" ensures that the table is in 1NF; requiring that non-key attributes be dependent on "the whole key" ensures 2NF; further requiring that non-key attributes be dependent on "nothing but the key" ensures 3NF
Avatar
i dont remember it, why would i if i project dbs correctly in 1 2 3 nf
17:54
it got to my common sense
Avatar
3nf is the minimum for a good db xd
17:55
Fifth normal form (5NF), also known as projection–join normal form (PJ/NF), is a level of database normalization designed to remove redundancy in relational databases recording multi-valued facts by isolating semantically related multiple relationships. A table is said to be in the 5NF if and only if every non-trivial join dependency in that table is implied by the candidate keys. It is the final normal form as far as removing redundancy is concerned.
>
A 6NF also exists, but its purpose is not to remove redundancy and it is therefore only adopted by a few data warehouses, where it can be useful to make tables irreducible.
17:55
interesting facts bro
Avatar
Avatar
Ryozuki
3nf is the minimum for a good db xd
and thats enough for me, im not going to be projecting complex dbs
Avatar
dont limit ur learning to what u will do
Avatar
just glancing over it is better
Avatar
i just dont like much that topic
17:58
so didnt dig
Avatar
well yeah its just theory
Avatar
did enough to do my project n pass
Avatar
what was ur project
Avatar
Lumpy ◐ω◑ 2023-01-30 17:58:52Z
dope is in trouble justatest
Avatar
i didnt go to uni, he should know more and better
17:59
according to society
Avatar
had to do a db made min of 10 entitys(?) and create 2 procedures, 2 triggers in tsql and plsql
17:59
nah uni is just for contacts and easier internships
17:59
imo
18:00
u can easily learn faster and more effectively on ur own
Avatar
never used tsql or plsql
18:00
i think they are propietary
18:00
u should learn postgresql
18:00
if u really need to, then mariadb
Avatar
what about mongo
Avatar
sucks ass
18:00
watch this video about what i think about mongo
Avatar
was thinking about webdev python
18:01
@dope u know what ACID means right?
18:01
and why its important for databases?
18:01
guess what mongo doesnt have
Avatar
had to google it coz im studying in pl
18:01
but yeah ik
Avatar
I've always admired the write performance of the /dev/null schema-less database, the read performance however is a little lacking, but this is offset by /dev/null's data compression ... totally unmatched!
🤔 1
18:02
xdd
Avatar
have u heard about image steganography?
Avatar
the vid is satire
18:02
its gold
18:03
ye
Avatar
had to implement it in cpp last semester
18:03
was fun
18:03
for bmp and png
Avatar
MongoDB is webscale, change my mind
Avatar
classic
Avatar
justice for coach
Avatar
сын Dekm'ы 2023-01-30 18:59:41Z
Дайте пожалуйста бинд чтоб в чат сообщения писать
18:59
Одной кнопкой
Avatar
fixed
Avatar
AFAIK he regrets renaming to Coach 😄
Avatar
@nothing rly? lmao
Avatar
i sadly regret
19:04
but i like to use both ngl
Avatar
I can rename to Twinbop420 to make your choice seem better by comparison
Avatar
I'll rename to cipy29 after to make sure he doesn't get his name back
Avatar
I'll rename to bencie after to make sure he doesn't get his name back
Avatar
pencie
santatrollet 4
Avatar
im Knuski
🥹 4
Avatar
im coach
think_bot 3
Avatar
im gay
justatest 10
twintri 3
ddnet_lgbt 12
gigachad 3
greenthing 3
f3 3
Avatar
im nothing
flag_unk 5
Avatar
Avatar
nothing
im nothing
David*°Villa 2023-01-30 19:45:56Z
Hello nothing I'm David
Avatar
guys somebody here know why i got lagget on BW gamemode
19:46
only on blmapv3royal (edited)
19:46
microlags
Avatar
Im furry
troll 1
Avatar
hi are there any way to make a server to play a map what we want
20:04
like i wanna play baby aim but there is no room with 0 player so i can'T change it
Avatar
Avatar
Deleted User
hi are there any way to make a server to play a map what we want
#questions
Avatar
Avatar
Deleted User
hi are there any way to make a server to play a map what we want
Avatar
Avatar
Deleted User
hi are there any way to make a server to play a map what we want
There are also plenty of empty servers you can join, just join and type /map baby aim
20:08
You can do that on all of these servers, the server type doesn't matter (except tutorial servers)
Avatar
Avatar
MilkeeyCat
Im furry
no, @Lyn / Micha is
Avatar
@murpi can you pass me the rcon
Avatar
Avatar
Skeith
You can do that on all of these servers, the server type doesn't matter (except tutorial servers)
oh thank u i didn't think about that i can change the server type
👍 1
Avatar
Avatar
cyberFighter
@murpi can you pass me the rcon
test server or.?
Avatar
Avatar
Skeith
im gay
skeith you give off the straightest vibes ive ever seen ever
justatest 6
Avatar
Avatar
Steinchen
no, @Lyn / Micha is
UwU fuck me UwU woof woof meow meow (edited)
21:02
hello
Avatar
gello
Avatar
i was playing ddnet without doing anything i got banned how can i reach admin?
21:04
i was waiting for my friend in the game i got banned then
Avatar
sometimes they spin wheel and ban ppl
troll 3
21:04
you are unlucky
Avatar
why then?
Avatar
why what (edited)
Avatar
Avatar
!Rewlyy
i was playing ddnet without doing anything i got banned how can i reach admin?
you can DM me
Avatar
why are they banning
21:05
ok
Avatar
he is trolling u
Avatar
Avatar
!Rewlyy
why are they banning
for fun
21:05
i would do so if i could
21:05
🤔
Avatar
That's probably one of the reasons you can't 😎
kek 1
Avatar
Avatar
Devinci
That's probably one of the reasons you can't 😎
Wdym
21:07
Im not troll
Avatar
Avatar
bobo
hi
Are you also get banned "accidentaly"
Avatar
how r u guys
Avatar
Avatar
MilkeeyCat
Are you also get banned "accidentaly"
no
21:07
i didnt
Avatar
sad
Avatar
you play multyeasy
21:07
?
Avatar
i had so many ideas
21:07
how to respond
21:08
:(
Avatar
I can rolplay for you if you want
Avatar
yey
21:08
i was playing ddnet without doing anything i got banned how can i reach admin?
Avatar
wait
21:08
i have to prepare something
Avatar
You disappoint me, I though you had ideas
Avatar
Avatar
Devinci
You disappoint me, I though you had ideas
WAIT
Avatar
i can
21:09
dude pls
21:09
trust
Avatar
you got me confused with that last sentence thonk
Avatar
ye, i also dont know what that work means
Avatar
Avatar
Devinci
i was playing ddnet without doing anything i got banned how can i reach admin?
It's very easy, all what you have to do is just to ping @jhjkhjkhjhjk 3 times (edited)
21:16
get your 3 trollface well deserved
Avatar
out of how many?
21:16
3/3 or 3/5
Avatar
joins the game and immediately runs to this area and doing this
banhammer 1
Avatar
or 3/12
Avatar
idk, just gave you one for every ping I was supposed to do 😎
Avatar
Avatar
noby
joins the game and immediately runs to this area and doing this
is that a 0.5 client? looks really old
Avatar
Avatar
Devinci
idk, just gave you one for every ping I was supposed to do 😎
and i had to restore password just for 3 trollfaces :(
Avatar
ddnet 16. 4
Avatar
Avatar
MilkeeyCat
and i had to restore password just for 3 trollfaces :(
get a 4th one troll
Avatar
Avatar
noby
joins the game and immediately runs to this area and doing this
my enemie 😂🤣
21:18
!ban 10y
f3 3
Avatar
my wall is covered in this trollfaces
21:19
but i want to be part of the community and help new ppl
Avatar
Avatar
noby
joins the game and immediately runs to this area and doing this
every single time bruh
21:19
i dont block btw
kek 1
Avatar
"i wasnt doing anything just waiting for my friend"
Avatar
it was my brother
Avatar
Avatar
noby
"i wasnt doing anything just waiting for my friend"
he was playing with his afk brother (edited)
Avatar
Avatar
bobo
you play multyeasy
yea, it's my favorite map.
👍 2
Avatar
Yeah idk, the tee is afk + a dummy. that's 1 place taken (or 2 if main was also afk). that guy should have been the one to get banned greenthing
Avatar
my favorite map farlands+ (edited)
Avatar
Avatar
Devinci
Yeah idk, the tee is afk + a dummy. that's 1 place taken (or 2 if main was also afk). that guy should have been the one to get banned greenthing
would agree normally but i think he had timed out
Avatar
yeah... that's what happends when you afk for a while... withouth the need to desconned iirc
Avatar
was also getting in the way of people trying to pass and not helping them when they fall into freeze lol
Avatar
thats why afking on the platform is also looked down upon or even punished at times. its a NOVICE server for noobs, you are in the path of new players.
Avatar
you know you have achieved happiness when you hold hotdog in your hands
Avatar
Avatar
Souly
you know you have achieved happiness when you hold hotdog in your hands
hold my hotdog
Avatar
no thats gay
Avatar
you can have it after
Avatar
Tadeusz Kościuszko 2023-01-30 21:29:46Z
@nothing
Avatar
hi cagih
Avatar
Tadeusz Kościuszko 2023-01-30 21:30:34Z
who is cagih
Avatar
wtf this hotdog sauce is so fucking spicy
21:37
my belly is making weird sounds rn
Avatar
Tadeusz Kościuszko 2023-01-30 21:40:46Z
ur gathering gas in ur stomach and u will fart smelly farts a lot soon
Avatar
@Souly pls send hotdog here
21:42
i need food
Avatar
Avatar
Tadeusz Kościuszko
ur gathering gas in ur stomach and u will fart smelly farts a lot soon
or i will just get a internal bleeding because of how destroy my stomach is by constant drug abuse
Avatar
@I.K.U i need you
Avatar
@I.K.U i need you
Avatar
i don’t
Avatar
Avatar
Ryu
@I.K.U i need you
for what? 🥹
Avatar
@Ryu i need u
Avatar
Avatar
I.K.U
for what? 🥹
your presence gives me the hots
Avatar
Avatar
cankick
@Ryu i need u
idk u sorry
Avatar
i was told not to speak to strangers
Avatar
@Ryu please hit the gridy
Avatar
guys somebody here know why i got lagget on BW gamemode only on blmapv3royal microlags
Avatar
ask on blockworlds discord
23:37
try restarting your game
Avatar
#questions
Avatar
@nero press f1 ingame
23:59
type in cl_dummy_resetonswitch 0
Exported 491 message(s)