DDraceNetwork - showroom

DDraceNetwork

DDraceNetwork / showroom

Teeworlds/DDNet related media only

Between 2022-05-11 00:00:00Z and 2022-05-12 00:00:00Z

perfect stack or bad

c0d3d3v

keep it simple and stupid. Please no unnecessary settings. The font size is now the same as the chat, should be fine I think, but we could discuss about the size of the box.

no unnecessary settings? are custom colors for skins unnecessary? what about hookline colors? what about hookline width? why did we add those features then?

1

02:11

i think at least the color/alpha/visibility should be controlled

02:11

width should scale based on ui_scale

02:11

which is currently broken still...

i think having extra settings isnt a big issue at all

02:58

it doesnt have to even appear in any of the settings or anything but just as a few simple console commands

02:58

i cant really see much harm in adding some extra console commands

well unnecessary settings cause code maintenance to be a larger burden such as when something breaks

03:02

since there aren't any 'custom settings' for scoreboard ot other hud options i don't see why there should be some for that box

lynn

no unnecessary settings? are custom colors for skins unnecessary? what about hookline colors? what about hookline width? why did we add those features then?

I want the game added replay bot and aimbot as in my client, then I will finally move to ddnet.

5

lynn

width should scale based on ui_scale

a setting that is a big burden (edited)

Salmonιa

I want the game added replay bot and aimbot as in my client, then I will finally move to ddnet.

What is your ingame nickname

Salmonia (edited)

Bomb | DerpDEX | Ambit Finance

What is your ingame nickname

.

08:27

Ты не видел, наверное, я редко захожу: учёба, все дела, плюс сервера не работали

ui_scale fans crying in the club rn

09:10

just because the setting doesn't exist for scoreboard already doesn't mean we don't need to care about stuff like this

09:10

i guess we are only allowed to be as user-focused as we are historically lol

lynn

no unnecessary settings? are custom colors for skins unnecessary? what about hookline colors? what about hookline width? why did we add those features then?

so you would define a base color for all rounded rectangles and from that you would calculate all colors for rectangles around chat messages, all other round rectangles and mini score board?

09:24

there is a discussion about removing ui_scale, if you like it you should bring up arguments for it @lynn https://github.com/ddnet/ddnet/discussions/4214 and https://github.com/ddnet/ddnet/issues/5062

ui_scale · Discussion #4214 · ddnet/ddnet

What the hell do we do with this thing?!?! I personally use it but it scales certain UI (skins list, settings pages) in ways that make the content crowded or inaccessible. Could we fix things like ...

UI scale breaks start menu · Issue #5062 · ddnet/ddnet

With UI scale below 100: the aspect ratio of the images is incorrect buttons move further down size of buttons increases With UI scale above 100: text overlaps images buttons move further up size o...

The game does not need any changes at the moment I think, maybe some new mechanics (weapons), but this is from the realm of fantasy and will not be added, and everything that really somehow affects the game - has been added. The only thing I liked from the ideas is the tee list from tater

lynn

no unnecessary settings? are custom colors for skins unnecessary? what about hookline colors? what about hookline width? why did we add those features then?

I find the adjustments of hookline unnecessary, but well I don't have to decide that alone. Other players don't even see your colors and you can't even adjust the colors if you have hookline always active.

Salmonιa

The game does not need any changes at the moment I think, maybe some new mechanics (weapons), but this is from the realm of fantasy and will not be added, and everything that really somehow affects the game - has been added. The only thing I liked from the ideas is the tee list from tater

but this is from the realm of fantasy and will not be added

09:28

just go ahead and propose a new weapon

09:29

The only thing I liked from the ideas is the tee list from tater

what tee list?

I'll give you a screenshot when I get home

c0d3d3v

so you would define a base color for all rounded rectangles and from that you would calculate all colors for rectangles around chat messages, all other round rectangles and mini score board?

we could certainly talk about all ui when it comes to color/alpha but the very first response to the idea for just the position speed angle HUD was simply "no" which wasn't as constructive

13:57

there's UI color overall but idk what the rules are that apply and how it gets updated since it always tends to look darker

c0d3d3v

there is a discussion about removing ui_scale, if you like it you should bring up arguments for it @lynn https://github.com/ddnet/ddnet/discussions/4214 and https://github.com/ddnet/ddnet/issues/5062

I created that discussion. I posted my thoughts just now in the ui_scale issue though

14:08

This post was sponsored by the 105% UI Scale Gang

lets face it, we need html+css support, then our UI wouldnt suck anymore

15:34

that 500mb are worth it xd

cant believe ddnet will be half a gigabyte

with steams way to download stuff it would also be acceptable actually

15:39

updates wont be that huge

15:39

but anyway, in 10 seconds haters come and annoy me so i rq fast

oh, do I need to go buy a bigger hdd?

imagine still getting rank1 with this choke

justatest

6

Lumpy ◐ω◑

so recently I've discovered DDNet sql base and decided to do some queries idk if it's interesting for anyone else, but here is what I've got note: players means unique player names, and I'm not completely sure if the data is 100% correct coz of chicken brain 10100 players finished only tutorial map once 18541 players have their first finish on tutorial map 5756 players have their first finish on tutorial map and have finish on any other map 2685 players have first finish on tutorial map and finished only tutorial map several times

most finishes among them
+----+-----------------+--------------------+
|    | Name            |   NumberOfFinishes |
|----+-----------------+--------------------|
|  0 | 刘家华          |                 32 |
|  1 | 3550361057      |                 31 |
|  2 | juniorerik1604  |                 30 |
|  3 | zpss            |                 28 |
|  4 | Nekio           |                 27 |
|  5 | augusto-fbeier  |                 27 |
|  6 | Jujubinha Doce  |                 24 |
|  7 | cocnrolla       |                 24 |
|  8 | Гашиш оп        |                 24 |
|  9 | dockj           |                 22 |
| 10 | CenturyBoomm    |                 21 |
| 11 | 3623745005      |                 20 |
| 12 | Chatty dydy     |                 18 |
| 13 | RyzeTodoUnHacke |                 18 |
| 14 | relampagomarkin |                 18 |
| 15 | santosnickzin   |                 18 |
| 16 | 𝕂𝕒𝕫Ё            |                 18 |
| 17 | ARIZA           |                 17 |
| 18 | cwldsb          |                 17 |
| 19 | jevgeniya11.12  |                 17 |
+----+-----------------+--------------------+

do they even know there are other maps? thonk

thonk

edit: there is a mistake in the table, I'll redo this another table with the longest break (in days)

+----+-----------------+---------------------+---------------------+--------+
|    | name            | timestamp           | timestampNext       |   diff |
|----+-----------------+---------------------+---------------------+--------|
|  0 | Org             | 2019-06-17 18:48:33 | 2022-03-13 17:13:36 | 999.93 |
|  1 | Fame Frêêze     | 2016-09-06 15:08:57 | 2019-06-03 10:06:09 | 999.79 |
|  2 | China           | 2017-03-18 11:53:39 | 2019-12-13 03:33:16 | 999.65 |
|  3 | xBoy~           | 2018-11-16 23:49:34 | 2021-08-12 09:59:16 | 999.42 |
|  4 | Soft & Wet      | 2017-12-24 12:29:51 | 2020-09-18 22:16:41 | 999.41 |
|  5 | Adrenaline      | 2014-05-22 21:19:11 | 2017-02-15 05:37:22 | 999.35 |
|  6 | FDP             | 2019-05-21 07:26:02 | 2022-02-13 15:16:31 | 999.33 |
|  7 | Hubenej         | 2019-02-13 10:27:40 | 2021-11-08 17:14:43 | 999.28 |
|  8 | Tomo:3          | 2016-06-01 16:00:54 | 2019-02-25 19:44:08 | 999.16 |
|  9 | Kill3rk4ninch3n | 2019-04-22 14:12:14 | 2022-01-15 13:38:38 | 998.98 |
| 10 | Hammer Jones    | 2013-10-30 16:24:33 | 2016-07-25 14:25:06 | 998.92 |
| 11 | [D]ragere       | 2017-06-06 18:55:50 | 2020-03-01 16:50:31 | 998.91 |
| 12 | Sato            | 2018-08-14 00:39:01 | 2021-05-08 22:28:04 | 998.91 |
| 13 | §§IUDEX§§       | 2019-06-03 16:15:35 | 2022-02-26 13:28:47 | 998.88 |
| 14 | what's my name  | 2013-11-17 14:15:17 | 2016-08-12 09:01:59 | 998.78 |

(edited)

16:36

| 15 | Trax            | 2016-08-13 16:44:19 | 2019-05-09 11:22:19 | 998.78 |
| 16 | Gomba           | 2018-06-23 17:00:59 | 2021-03-18 10:42:28 | 998.74 |
| 17 | NigglePiglet    | 2016-03-16 03:28:27 | 2018-12-09 19:36:22 | 998.67 |
| 18 | GoldenMuhi      | 2018-08-17 19:28:45 | 2021-05-12 11:23:46 | 998.66 |
| 19 | Lis             | 2018-01-09 21:23:09 | 2020-10-04 10:27:49 | 998.54 |
| 20 | MateMT          | 2017-10-20 17:50:55 | 2020-07-15 05:20:31 | 998.48 |
| 21 | Pilotaraflo     | 2019-04-07 02:28:45 | 2021-12-30 12:35:18 | 998.42 |
| 22 | katarina        | 2016-01-22 21:10:37 | 2018-10-17 06:46:37 | 998.40 |
| 23 | BabyRage        | 2017-04-10 07:54:34 | 2020-01-03 17:26:06 | 998.40 |
| 24 | li              | 2017-09-05 21:58:07 | 2020-05-31 07:14:24 | 998.39 |
| 25 | DeathFist       | 2017-12-21 07:56:12 | 2020-09-14 15:53:56 | 998.33 |
| 26 | Will            | 2015-09-15 14:36:21 | 2018-06-09 22:15:34 | 998.32 |
| 27 | Kael            | 2017-11-05 22:30:02 | 2020-07-31 05:44:11 | 998.30 |
| 28 | freddy          | 2014-11-24 18:08:17 | 2017-08-19 00:34:25 | 998.27 |
| 29 | baum            | 2019-08-06 08:43:36 | 2022-04-30 13:36:40 | 998.20 |
+----+-----------------+---------------------+---------------------+--------+

Im 'corneum

imagine still getting rank1 with this choke

Spook:

trollet

mega troller

@Lumpy ◐ω◑ it seems suspicious that the longest breaks are all so close to 1000 days, are you sure this is correct? (edited)

ye, it was suspicious for me too, but if it was a limit it would be 999.99, no?

no, why?

16:49

what is the query?

you think it's suspicious because it doesn't get more than 1000? or other reason?

Where is Ante? His break lasts like 6 years already

deen

what is the query?

I created new table with timestamps, previous and next

yes, should be over 1000, there is no reason they should all be so close to 1000

ᶰ°Konͧsti

Where is Ante? His break lasts like 6 years already

so it doesn't count those who still doesn't play, I should have mention that (edited)

pepe

16:53

Then where is Tsin

16:53

He didnt join DDNet for years

16:53

troll

deen

yes, should be over 1000, there is no reason they should all be so close to 1000

there is a chance I might have done something wrong, but idk really how to check it

16:56

ok, I've checked Tsin, he got more than 1000

Image attachment

16:57

hm, why doesn't it sort correctly (edited)

I think now I've got it right (this is without those who still doesn't play)

+----+------------+---------------------+---------------------+----------+
|    | name       | timestamp           | timestampNext       |     diff |
|----+------------+---------------------+---------------------+----------|
|  0 | lain       | 2013-09-02 23:42:47 | 2022-04-21 16:29:45 | 3,152.00 |
|  1 | kobra      | 2013-09-22 08:04:08 | 2022-04-23 08:58:32 | 3,135.00 |
|  2 | Emma Stone | 2013-09-16 22:03:36 | 2022-04-05 03:41:09 | 3,122.00 |
|  3 | darling    | 2013-08-30 20:13:46 | 2022-02-12 06:16:05 | 3,087.00 |
|  4 | Tymek      | 2013-11-04 16:52:38 | 2022-04-16 13:27:47 | 3,084.00 |
|  5 | Jacqui     | 2013-11-12 17:00:48 | 2022-04-17 18:40:04 | 3,078.00 |
|  6 | More       | 2013-11-09 20:13:31 | 2022-04-09 18:07:57 | 3,072.00 |
|  7 | hi<3       | 2013-10-18 23:13:07 | 2022-03-16 17:29:26 | 3,070.00 |
|  8 | Moz        | 2013-11-16 01:08:37 | 2022-03-24 23:47:57 | 3,050.00 |
|  9 | наташа     | 2013-11-08 20:19:51 | 2022-03-15 11:46:01 | 3,048.00 |
| 10 | Thabu      | 2013-09-25 21:50:58 | 2022-01-24 22:47:16 | 3,043.00 |
| 11 | GamerKing  | 2013-09-26 00:38:27 | 2022-01-05 17:24:07 | 3,023.00 |
| 12 | gorden     | 2014-01-05 19:40:00 | 2022-04-15 17:49:08 | 3,021.00 |
| 13 | Kirk       | 2014-01-27 10:17:03 | 2022-04-21 21:03:44 | 3,006.00 |
| 14 | Marie ♥    | 2013-08-26 22:08:35 | 2021-11-18 21:36:54 | 3,005.00 |

(edited)

17:10

| 15 | Fàłłéñ     | 2014-01-24 18:17:35 | 2022-04-15 08:50:33 | 3,002.00 |
| 16 | Beary      | 2013-08-09 17:40:56 | 2021-10-19 14:21:14 | 2,992.00 |
| 17 | Bananin    | 2013-11-17 04:11:35 | 2022-01-14 04:58:46 | 2,980.00 |
| 18 | Koksi      | 2013-12-07 16:47:23 | 2022-02-01 22:53:08 | 2,978.00 |
| 19 | >.>        | 2013-08-13 16:06:45 | 2021-10-04 21:47:21 | 2,974.00 |
| 20 | BO$$       | 2014-03-01 07:46:24 | 2022-04-19 10:53:47 | 2,971.00 |
| 21 | Lumpen     | 2014-02-13 18:18:54 | 2022-03-29 03:21:41 | 2,965.00 |
| 22 | Krabe      | 2013-09-22 21:13:43 | 2021-10-31 10:37:28 | 2,960.00 |
| 23 | FireCat    | 2013-09-25 18:11:11 | 2021-11-03 13:55:33 | 2,960.00 |
| 24 | анюта      | 2013-10-27 17:21:18 | 2021-12-03 15:36:14 | 2,958.00 |
| 25 | Водка      | 2014-03-29 12:17:33 | 2022-04-30 05:47:14 | 2,953.00 |
| 26 | Zdzisiu    | 2014-02-13 08:32:29 | 2022-03-05 10:18:22 | 2,942.00 |
| 27 | Trop       | 2014-04-13 15:23:16 | 2022-05-03 20:51:27 | 2,942.00 |
| 28 | xxl        | 2014-02-19 17:13:01 | 2022-03-04 19:49:59 | 2,935.00 |
| 29 | Sugus      | 2013-11-17 15:03:39 | 2021-11-30 09:20:36 | 2,934.00 |
+----+------------+---------------------+---------------------+----------+

nonames

pepe

most of these are prob not even the same players tbh

Lumpy ◐ω◑

I think now I've got it right (this is without those who still doesn't play)

+----+------------+---------------------+---------------------+----------+
|    | name       | timestamp           | timestampNext       |     diff |
|----+------------+---------------------+---------------------+----------|
|  0 | lain       | 2013-09-02 23:42:47 | 2022-04-21 16:29:45 | 3,152.00 |
|  1 | kobra      | 2013-09-22 08:04:08 | 2022-04-23 08:58:32 | 3,135.00 |
|  2 | Emma Stone | 2013-09-16 22:03:36 | 2022-04-05 03:41:09 | 3,122.00 |
|  3 | darling    | 2013-08-30 20:13:46 | 2022-02-12 06:16:05 | 3,087.00 |
|  4 | Tymek      | 2013-11-04 16:52:38 | 2022-04-16 13:27:47 | 3,084.00 |
|  5 | Jacqui     | 2013-11-12 17:00:48 | 2022-04-17 18:40:04 | 3,078.00 |
|  6 | More       | 2013-11-09 20:13:31 | 2022-04-09 18:07:57 | 3,072.00 |
|  7 | hi<3       | 2013-10-18 23:13:07 | 2022-03-16 17:29:26 | 3,070.00 |
|  8 | Moz        | 2013-11-16 01:08:37 | 2022-03-24 23:47:57 | 3,050.00 |
|  9 | наташа     | 2013-11-08 20:19:51 | 2022-03-15 11:46:01 | 3,048.00 |
| 10 | Thabu      | 2013-09-25 21:50:58 | 2022-01-24 22:47:16 | 3,043.00 |
| 11 | GamerKing  | 2013-09-26 00:38:27 | 2022-01-05 17:24:07 | 3,023.00 |
| 12 | gorden     | 2014-01-05 19:40:00 | 2022-04-15 17:49:08 | 3,021.00 |
| 13 | Kirk       | 2014-01-27 10:17:03 | 2022-04-21 21:03:44 | 3,006.00 |
| 14 | Marie ♥    | 2013-08-26 22:08:35 | 2021-11-18 21:36:54 | 3,005.00 |

(edited)

give sql xd

make the query with >1000 points

Jupstar ✪

give sql xd

https://ddnet.tw/stats/ddnet.sqlite.zip

the SQL not the database

the sql statement you used to query the results xD

i have to learn SQLite anyway, its a bit different to mariasql apparently xd

as I said before, I just made a separate table to count the difference

^^

ez

c0d3d3v

make the query with >1000 points

ye, I think I should, need to add points to the table

Jupstar ✪

i have to learn SQLite anyway, its a bit different to mariasql apparently xd

nah it isnt

17:44

it maps BIGINT for example to INT

17:45

its like the python of sql

but the SQL is different?

most queries will work

most™️

depends if u use custom stuff

17:45

if u use standard sql it will work

like i know wtf standard is xD

17:45

i worked with mariadb, sql server(microsoft) and mysql

u know when u deal with 2 or more dabatases i guess

17:45

xd

17:46

mysql is pretty standard ngl

ok

17:46

well i liked mariadb most tbh

17:46

it wasnt so strict

lol

it allowed stuff

postgresql is the best

17:46

mariadb is outdated

postgress is op

17:46

i mean for basic stuff

17:46

i dont need OOP xd

for basic stuff you use sqlite

yes

17:47

i need it for client stuff

Susge

ok, ryozoozki

17:48

i have a test for u

17:50

ok i have no more test for u xd

xd

this chat in showroom looks like ban to me

banhammer

1

wtf so sqlite has no timediff

18:02

see thats already annoying

18:02

or datediff

18:02

@Ryozuki

select maps.Map, julianday(CURRENT_TIMESTAMP) - JULIANDAY( MAX(race.Timestamp)) as days from race, maps where race.Map = maps.Map group by maps.Map ORDER BY 2 DESC LIMIT 15

correctl SQL to query longest "inactive" maps?

18:03

Map    days
Memento mori    456.364282407332
Exanimus    377.860821759328
pedeuliar    323.910081018694
Not Adrenaline 6    317.77736111125
Wonderfully    242.602118055336
Commandont    239.871620370541
Bullseye    239.735266203526
Wonderfully2    239.000590277836
Namida    214.212812500075
run_world_war_zero    214.022442129441
Ghoul    210.018900462892
Heartcore    157.389247685205
Tatooine 2    145.837094907183
DoomWorld II    137.826574074104
Sooth    133.126817129552

18:03

oh

18:03

rip

Lumpy ◐ω◑

ye, I think I should, need to add points to the table

would be much more interesting with a points threshold idd (1k might be too high tho)

Damm

Jupstar ✪

Map    days
Memento mori    456.364282407332
Exanimus    377.860821759328
pedeuliar    323.910081018694
Not Adrenaline 6    317.77736111125
Wonderfully    242.602118055336
Commandont    239.871620370541
Bullseye    239.735266203526
Wonderfully2    239.000590277836
Namida    214.212812500075
run_world_war_zero    214.022442129441
Ghoul    210.018900462892
Heartcore    157.389247685205
Tatooine 2    145.837094907183
DoomWorld II    137.826574074104
Sooth    133.126817129552

result looks inaccurate

18:08

you forgot to take into account release to first rank

no no

ah sorry, misunderstood the query (edited)

i mean currently longest non active

lumpy how do you even find these

Sooth, by best french mapper ever, i named |Michel

snail

would be much more interesting with a points threshold idd (1k might be too high tho)

so these are without those who sill don't play (points > 1000)

+----+------------+---------------------+---------------------+----------+
|    | name       | timestamp           | timestampNext       |     diff |
|----+------------+---------------------+---------------------+----------|
|  0 | No problem | 2013-09-24 02:01:31 | 2021-09-20 12:46:19 | 2,918.00 |
|  1 | Lisa.      | 2014-02-17 03:03:43 | 2021-07-04 12:21:45 | 2,694.00 |
|  2 | Dimа       | 2013-11-24 17:44:54 | 2021-01-08 11:06:35 | 2,601.00 |
|  3 | foo        | 2013-08-02 14:11:21 | 2020-09-11 15:25:32 | 2,597.00 |
|  4 | meow..     | 2013-12-25 17:30:45 | 2021-01-11 15:40:53 | 2,573.00 |
|  5 | Knoerkel   | 2014-06-07 03:01:32 | 2021-06-03 23:00:57 | 2,553.00 |
|  6 | Apollo     | 2013-09-16 20:29:41 | 2020-08-27 02:01:01 | 2,536.00 |
|  7 | Kack       | 2014-06-14 22:58:19 | 2021-04-13 23:28:51 | 2,495.00 |
|  8 | Татар      | 2013-11-14 09:01:37 | 2020-09-13 14:34:43 | 2,495.00 |
|  9 | Minor      | 2014-07-09 01:12:46 | 2021-01-28 09:14:20 | 2,395.00 |
| 10 | Veers      | 2014-11-30 23:07:07 | 2021-06-03 21:20:28 | 2,376.00 |
| 11 | Moker      | 2014-11-25 13:02:58 | 2021-05-23 04:41:22 | 2,370.00 |
| 12 | xb         | 2014-08-03 05:36:55 | 2021-01-28 08:54:10 | 2,370.00 |
| 13 | BoBoX'     | 2014-05-11 11:19:30 | 2020-10-10 13:32:50 | 2,344.00 |
| 14 | patrick    | 2014-07-21 19:32:37 | 2020-12-12 21:41:37 | 2,336.00 |

18:09

| 15 | archer     | 2014-06-08 07:55:57 | 2020-10-06 10:11:00 | 2,312.00 |
| 16 | Kugelblitz | 2014-11-05 15:39:31 | 2021-02-02 13:05:15 | 2,280.00 |
| 17 | Pocoyo     | 2014-07-20 12:56:42 | 2020-09-25 16:19:01 | 2,259.00 |
| 18 | Shining    | 2014-08-26 11:23:45 | 2020-10-24 19:18:44 | 2,251.00 |
| 19 | Infi       | 2014-06-29 07:26:14 | 2020-08-22 04:10:24 | 2,245.00 |
| 20 | Cecilia    | 2015-05-29 15:54:06 | 2021-07-15 11:22:11 | 2,238.00 |
| 21 | Over       | 2014-07-26 02:45:16 | 2020-09-08 02:24:31 | 2,235.00 |
| 22 | maksim     | 2015-10-08 16:40:47 | 2021-11-09 07:22:09 | 2,223.00 |
| 23 | Jo         | 2015-01-19 14:59:36 | 2021-02-07 12:14:14 | 2,210.00 |
| 24 | Pierdolich | 2015-08-30 00:34:06 | 2021-08-19 10:24:58 | 2,181.00 |
| 25 | Mimic      | 2015-05-17 19:16:47 | 2021-05-04 12:40:01 | 2,178.00 |
| 26 | lalalalala | 2015-09-06 12:03:40 | 2021-08-20 08:39:35 | 2,174.00 |
| 27 | L O S T    | 2016-05-19 17:31:48 | 2022-05-01 12:20:10 | 2,172.00 |
| 28 | caiden     | 2014-09-26 04:19:03 | 2020-09-06 03:54:44 | 2,171.00 |
| 29 | ussi:)     | 2015-04-02 19:30:05 | 2021-03-03 19:27:55 | 2,161.00 |
+----+------------+---------------------+---------------------+----------+

pog

ussi?

18:09

doesn't he still play

i don't know any of them

veers

gigachad

18:10

u know veers

and these are with them (points > 1000)

+----+----------------+---------------------+---------------------+----------+
|    | name           | timestamp           | timestampNext       |     diff |
|----+----------------+---------------------+---------------------+----------|
|  0 | No problem     | 2013-09-24 02:01:31 | 2021-09-20 12:46:19 | 2,918.00 |
|  1 | MeTRoX         | 2014-07-30 18:22:48 | 2022-05-11          | 2,841.00 |
|  2 | gB. | Ante.    | 2014-09-30 18:03:59 | 2022-05-11          | 2,779.00 |
|  3 | TURK           | 2014-12-06 06:30:29 | 2022-05-11          | 2,712.00 |
|  4 | ÐæR            | 2014-12-17 09:05:23 | 2022-05-11          | 2,701.00 |
|  5 | Lisa.          | 2014-02-17 03:03:43 | 2021-07-04 12:21:45 | 2,694.00 |
|  6 | Purlax         | 2015-02-26 14:31:05 | 2022-05-11          | 2,630.00 |
|  7 | Moini          | 2015-03-03 17:56:54 | 2022-05-11          | 2,625.00 |
|  8 | Dimа           | 2013-11-24 17:44:54 | 2021-01-08 11:06:35 | 2,601.00 |
|  9 | foo            | 2013-08-02 14:11:21 | 2020-09-11 15:25:32 | 2,597.00 |
| 10 | meow..         | 2013-12-25 17:30:45 | 2021-01-11 15:40:53 | 2,573.00 |
| 11 | Knoerkel       | 2014-06-07 03:01:32 | 2021-06-03 23:00:57 | 2,553.00 |
| 12 | gB. I *WuDL*   | 2015-05-24 22:34:47 | 2022-05-11          | 2,543.00 |
| 13 | Apollo         | 2013-09-16 20:29:41 | 2020-08-27 02:01:01 | 2,536.00 |
| 14 | ENIAC          | 2015-05-31 18:18:04 | 2022-05-11          | 2,536.00 |

Veers is DDMaX staff no?

| 15 | RoyalPain☺     | 2015-06-07 07:36:38 | 2022-05-11          | 2,529.00 |
| 16 | Zadaxs         | 2015-06-10 18:24:43 | 2022-05-11          | 2,526.00 |
| 17 | Softcake       | 2015-06-12 15:02:35 | 2022-05-11          | 2,524.00 |
| 18 | Rhyszk         | 2015-06-13 22:18:10 | 2022-05-11          | 2,523.00 |
| 19 | Kack           | 2014-06-14 22:58:19 | 2021-04-13 23:28:51 | 2,495.00 |
| 20 | Татар          | 2013-11-14 09:01:37 | 2020-09-13 14:34:43 | 2,495.00 |
| 21 | Fledermausmann | 2015-07-15 12:24:00 | 2022-05-11          | 2,491.00 |
| 22 | gB. | Kintaro* | 2015-08-02 19:12:18 | 2022-05-11          | 2,473.00 |
| 23 | BFBlMrAD       | 2015-08-12 16:38:19 | 2022-05-11          | 2,463.00 |
| 24 | TheProxD       | 2015-08-22 23:46:10 | 2022-05-11          | 2,453.00 |
| 25 | Scorpik        | 2015-08-25 06:33:23 | 2022-05-11          | 2,450.00 |
| 26 | Minor          | 2014-07-09 01:12:46 | 2021-01-28 09:14:20 | 2,395.00 |
| 27 | mB. | mikey12  | 2015-10-24 01:39:58 | 2022-05-11          | 2,390.00 |
| 28 | Lance Butters  | 2015-10-25 19:52:52 | 2022-05-11          | 2,389.00 |
| 29 | NĕĕÞ           | 2015-11-07 05:43:27 | 2022-05-11          | 2,376.00 |
+----+----------------+---------------------+---------------------+----------+

i dont thikn he was staff

18:10

but he was rly active on ddmax yes

Lumpy ◐ω◑

and these are with them (points > 1000)

+----+----------------+---------------------+---------------------+----------+
|    | name           | timestamp           | timestampNext       |     diff |
|----+----------------+---------------------+---------------------+----------|
|  0 | No problem     | 2013-09-24 02:01:31 | 2021-09-20 12:46:19 | 2,918.00 |
|  1 | MeTRoX         | 2014-07-30 18:22:48 | 2022-05-11          | 2,841.00 |
|  2 | gB. | Ante.    | 2014-09-30 18:03:59 | 2022-05-11          | 2,779.00 |
|  3 | TURK           | 2014-12-06 06:30:29 | 2022-05-11          | 2,712.00 |
|  4 | ÐæR            | 2014-12-17 09:05:23 | 2022-05-11          | 2,701.00 |
|  5 | Lisa.          | 2014-02-17 03:03:43 | 2021-07-04 12:21:45 | 2,694.00 |
|  6 | Purlax         | 2015-02-26 14:31:05 | 2022-05-11          | 2,630.00 |
|  7 | Moini          | 2015-03-03 17:56:54 | 2022-05-11          | 2,625.00 |
|  8 | Dimа           | 2013-11-24 17:44:54 | 2021-01-08 11:06:35 | 2,601.00 |
|  9 | foo            | 2013-08-02 14:11:21 | 2020-09-11 15:25:32 | 2,597.00 |
| 10 | meow..         | 2013-12-25 17:30:45 | 2021-01-11 15:40:53 | 2,573.00 |
| 11 | Knoerkel       | 2014-06-07 03:01:32 | 2021-06-03 23:00:57 | 2,553.00 |
| 12 | gB. I *WuDL*   | 2015-05-24 22:34:47 | 2022-05-11          | 2,543.00 |
| 13 | Apollo         | 2013-09-16 20:29:41 | 2020-08-27 02:01:01 | 2,536.00 |
| 14 | ENIAC          | 2015-05-31 18:18:04 | 2022-05-11          | 2,536.00 |

how can No problem be both <1k and >1k points

spur

lumpy how do you even find these

in the database justatest

justatest

the first one isnt <1k points right its just no point filter

maybe he has 1k point exactly

Lisa is there twice too

snail

how can No problem be both <1k and >1k points

both are > 1000

13 million races uff

18:11

the sqlite database is really slow

i have a name with 1 single finish in like 2014

the difference is in first table people have a finish after the break, and the second is not

feelsbadman

ah ok

18:12

the 2nd one is bugged isnt it

18:12

90% of the players are "seen on 2022-05-11"' aka today

snail

90% of the players are "seen on 2022-05-11"' aka today

that means they don't have a finish (still don't play), it's there for the dates difference (edited)

so its like the oldest >1k point inactive players?

snail

so its like the oldest >1k point inactive players?

yes

bluekitty

18:14

interesting

still can't find the database

18:14

im retarded

snailx3 was last active on 2022-04-12 10:54:46

18:14

or finished a map

justatest

spur

still can't find the database

https://ddnet.tw/stats/sql.js/

legend (edited)

goofball

this chat in showroom looks like ban to me

still better than the discussion to remove dummy troll

troll

Lumpy ◐ω◑

https://ddnet.tw/stats/sql.js/

I wouldn't use it in browser anymore. Our database has gotten huge since the Steam release

deen

I wouldn't use it in browser anymore. Our database has gotten huge since the Steam release

ye, I use it just for download

Ah, I'll add a link here tomorrow: https://ddnet.tw/stats/

why tomorrow

because the page is generated automatically nightly

good reason, can't judge

have a nice evening people

heartw

2

DDNet now has more finishes on CHN than on EUR

Image attachment

wtf

7

uff

18:19

its kind of sad how split the community is due to speech barrier now. i dont know anything about CHN ddnet culture

more familiar names with > 5k points, didn't know they had such a long break (tho they can be still playing)

+----+------------+---------------------+---------------------+----------+
|    | name       | timestamp           | timestampNext       |     diff |
|----+------------+---------------------+---------------------+----------|
|  0 | Veers      | 2014-11-30 23:07:07 | 2021-06-03 21:20:28 | 2,376.00 |
|  1 | BoBoX'     | 2014-05-11 11:19:30 | 2020-10-10 13:32:50 | 2,344.00 |
|  2 | Over       | 2014-07-26 02:45:16 | 2020-09-08 02:24:31 | 2,235.00 |
|  3 | ussi:)     | 2015-04-02 19:30:05 | 2021-03-03 19:27:55 | 2,161.00 |
|  4 | Nutcracker | 2015-04-04 16:23:18 | 2020-08-19 21:02:09 | 1,964.00 |
|  5 | lis        | 2015-05-19 07:14:46 | 2020-08-19 02:16:29 | 1,918.00 |
|  6 | Myszoluk   | 2014-10-25 11:20:37 | 2019-11-30 16:55:04 | 1,862.00 |
|  7 | Lollipop   | 2015-10-05 08:23:53 | 2020-09-28 17:30:39 | 1,820.00 |
|  8 | By         | 2015-11-12 12:03:13 | 2020-09-27 09:35:36 | 1,780.00 |
|  9 | MONSTERCAT | 2016-02-23 16:40:19 | 2020-12-03 01:52:50 | 1,744.00 |
| 10 | summer     | 2014-09-17 15:34:23 | 2019-06-16 15:31:41 | 1,732.00 |
| 11 | ʏʙ™        | 2016-08-14 09:22:09 | 2021-03-17 11:51:20 | 1,676.00 |
| 12 | lost       | 2014-08-05 18:19:15 | 2019-02-16 10:49:52 | 1,655.00 |
| 13 | him        | 2016-02-09 18:05:21 | 2020-08-18 08:25:28 | 1,651.00 |
| 14 | Nishi      | 2016-03-23 22:38:23 | 2020-08-19 09:26:08 | 1,609.00 |

18:19

| 15 | Dum        | 2015-07-03 12:11:50 | 2019-09-27 08:01:04 | 1,546.00 |
| 16 | SvechAS    | 2014-08-19 21:02:25 | 2018-10-29 18:37:32 | 1,531.00 |
| 17 | Yumiko     | 2015-07-14 22:52:44 | 2019-09-17 11:45:20 | 1,525.00 |
| 18 | QWQ        | 2016-07-20 06:07:47 | 2020-08-20 12:34:24 | 1,492.00 |
| 19 | KiRA       | 2016-01-12 12:24:54 | 2020-02-03 19:11:52 | 1,483.00 |
| 20 | Fireball   | 2016-02-19 19:39:44 | 2020-02-26 21:53:34 | 1,468.00 |
| 21 | Beni       | 2015-08-19 01:03:07 | 2019-08-16 01:30:17 | 1,458.00 |
| 22 | Broso56    | 2016-12-03 03:07:58 | 2020-10-10 16:32:41 | 1,407.00 |
| 23 | Frr :3     | 2017-05-31 12:31:30 | 2021-04-04 22:14:45 | 1,404.00 |
| 24 | XX         | 2017-02-16 15:51:56 | 2020-12-21 03:27:53 | 1,403.00 |
| 25 | xiaocan    | 2016-05-14 23:57:47 | 2020-02-13 15:00:26 | 1,369.00 |
| 26 | Shisui.    | 2016-09-25 16:40:14 | 2020-06-07 20:45:10 | 1,351.00 |
| 27 | Kati       | 2014-11-17 15:39:07 | 2018-06-27 13:36:01 | 1,317.00 |
| 28 | Volvicc    | 2014-07-16 14:39:39 | 2018-01-29 02:35:39 | 1,292.00 |
| 29 | timi       | 2014-06-12 21:54:50 | 2017-12-26 00:38:06 | 1,292.00 |
+----+------------+---------------------+---------------------+----------+

deen

DDNet now has more finishes on CHN than on EUR

ye, CHN is wild

Too bad the community is so split, with Discord being banned in China

i feel like Crytikal should be on that list but it seems he played a little here and there. can you exlude time periods where players came back for less than a month @Lumpy ◐ω◑

you're making it complicated

idk how to use the database

ye, it's kinda complicated

deen

Too bad the community is so split, with Discord being banned in China

any chance we can get a chat traslator in ddnet? i remember there was a client that did that

Im 'corneum

any chance we can get a chat traslator in ddnet? i remember there was a client that did that

there is no good free translator we could use. deepl API is not free

Google translate and let everyone get their own api key?

I thought you would say 'and let everyone misunderstand each other' justatest

justatest

Im 'corneum

its kind of sad how split the community is due to speech barrier now. i dont know anything about CHN ddnet culture

honestly language barrier really doesnt matter lol

19:00

theres no game in which chinese and western communities are mixed

19:01

different play time, huge ping

19:01

its simply not realistic

yeah but i feel really close to the CHL community

19:01

even tho i never play with them

19:02

what if CHN have something like WENA and i dont know about it D:

kek

9

for @RonIn :3

Image attachment

18

27

poggers

19

8

zerolove

5

i wish i had the money to comm you

nice watermark

omg the eyelashes

wow

20:07

that hammer

20:07

rly well done

goofball

nice watermark

thanks

xD

xd

Lumpy ◐ω◑

| 15 | Dum        | 2015-07-03 12:11:50 | 2019-09-27 08:01:04 | 1,546.00 |
| 16 | SvechAS    | 2014-08-19 21:02:25 | 2018-10-29 18:37:32 | 1,531.00 |
| 17 | Yumiko     | 2015-07-14 22:52:44 | 2019-09-17 11:45:20 | 1,525.00 |
| 18 | QWQ        | 2016-07-20 06:07:47 | 2020-08-20 12:34:24 | 1,492.00 |
| 19 | KiRA       | 2016-01-12 12:24:54 | 2020-02-03 19:11:52 | 1,483.00 |
| 20 | Fireball   | 2016-02-19 19:39:44 | 2020-02-26 21:53:34 | 1,468.00 |
| 21 | Beni       | 2015-08-19 01:03:07 | 2019-08-16 01:30:17 | 1,458.00 |
| 22 | Broso56    | 2016-12-03 03:07:58 | 2020-10-10 16:32:41 | 1,407.00 |
| 23 | Frr :3     | 2017-05-31 12:31:30 | 2021-04-04 22:14:45 | 1,404.00 |
| 24 | XX         | 2017-02-16 15:51:56 | 2020-12-21 03:27:53 | 1,403.00 |
| 25 | xiaocan    | 2016-05-14 23:57:47 | 2020-02-13 15:00:26 | 1,369.00 |
| 26 | Shisui.    | 2016-09-25 16:40:14 | 2020-06-07 20:45:10 | 1,351.00 |
| 27 | Kati       | 2014-11-17 15:39:07 | 2018-06-27 13:36:01 | 1,317.00 |
| 28 | Volvicc    | 2014-07-16 14:39:39 | 2018-01-29 02:35:39 | 1,292.00 |
| 29 | timi       | 2014-06-12 21:54:50 | 2017-12-26 00:38:06 | 1,292.00 |
+----+------------+---------------------+---------------------+----------+

didnt expect my name on this lmao

20:41

i got like 40 points and then changed name to sW|Broso56 and played a little til 2018 and then rqed for 2y

kek

1

Insanity

for @RonIn :3

art

gigachad

skin

justatest

Voxel

i wish i had the money to comm you

u can do it better or no :D

if voxel and insanity collab the world will end (edited)

yes

1

xD

im up for it if insanity is

sure

feelsamazingman

ayo

22:01

whats a good bitrate for stream

22:01

720p

22:01

my stream lookin garbage

140p

ez

22:07

https://www.twitch.tv/cactus17_

22:08

watch some garbage quality stream pogu

Voxel

feelsamazingman

welp, was nice knowing everyone. guess ill have to go to some nice hill or something and watch the sunset for the last time ever. (edited)

feelsbadman

6

Exported 218 message(s)