00:04 < bridge> wait why community filter is not filter menu only entry 00:04 < bridge> i don't want to see it while checking the server info :/ 03:17 < bridge> when bring back 2007 cursor? 03:17 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213671609932447784/image.png?ex=65f652c4&is=65e3ddc4&hm=0652fac7425df681e5f760fb04f39e936c0ad54e81f137f7c585e667212ce3f3& 03:18 < bridge> (nvm i also just saw the current cursor is from 2007 aswell) 06:57 < bridge> is this a good idea to make a table everything as text in sqlite3 ? 06:57 < bridge> 06:57 < bridge> ```sql 06:57 < bridge> create table Accounts(Name text not null, Password text not null, Money text not null, xp text not null, Creation text not null, LastUsed text not null) 06:57 < bridge> ``` 06:58 < bridge> is this a good idea to make everything as text in a table in sqlite3 ? 06:58 < bridge> 06:58 < bridge> ```sql 06:58 < bridge> create table Accounts(Name text not null, Password text not null, Money text not null, xp text not null, Creation text not null, LastUsed text not null) 06:58 < bridge> ``` 07:24 < bridge> No 08:19 < bridge> why would you want xp, creation, and lastused to be text? 08:19 < bridge> 08:19 < bridge> why not use `INTEGER` for Money and XP, and `DATETIME` for LastUsed and Creation ? 08:28 < bridge> be more helpful next time! 08:35 < bridge> I'm not google to be helpful :gigachad: 08:35 < bridge> :kek: 09:43 < bridge> it doesn't really matter in sqlite, but you'd usually use integer for most of these 09:47 < bridge> i was looking for RenderTools()->MapScreenToGroup :kek: 10:31 < bridge> cus i don't know how to work with them, but i can easily convert any text from sqlite to anything i need in c, what is the downsides ? 10:33 < bridge> a lot of downsides actually - data integrity, type safety, storage efficiency 10:34 < bridge> ok i will change it 10:37 < bridge> is blob datatype more storage efficient than others ? 10:37 < bridge> storage efficiency is critical for me 10:37 < bridge> Hello, looking for best way or tools to convert mp3 file to wv file for DDNet 10:38 < bridge> BLOB is efficient when you're working with binary data (images, audio files) 10:38 < bridge> i made a whole soundpack back in the days https://forum.ddnet.org/viewtopic.php?t=7472 10:39 < bridge> i wouldnt use BLOB if you're just working with plain text data 10:40 < bridge> tnx ❤️ 10:40 < bridge> another thing 10:41 < bridge> I think all these don't apply to sqlite. all fields can store all data types. the data type is just a hint 10:41 < bridge> is there anyway to change the map dynamically ? like making a terraria like server based on it ? 10:42 < bridge> people break and create blocks on the server's map 10:43 < bridge> no, currently not possible 10:43 < bridge> i see some crazy stuff in infclass mod/maps 10:44 < bridge> i remember chiller posting something that does what you described, cant find it tho 10:44 < bridge> they change tiles based on player input/ or hide and showing the tiles 10:46 < bridge> thats what i had in mind, just double-checked - MB - you're right, it "could" be an issue using text since it saves it as a variable-length instead of a fixed-length, but doesnt seem like you'd bother on something as small as a timestamp 10:46 < bridge> minecraft mod for teeworlds 10:46 < bridge> bdw my final goal is to make terarial + ddnet + cobalt(mojang) and publish it opensource 10:46 < bridge> https://www.youtube.com/watch?v=zHLDV2lvEX4 10:51 < bridge> 11 years ago 10:52 < bridge> why there isn't something like this nowadays ? the idea is old 10:53 < bridge> bcs if u want minecraft... play minecraft xd 10:53 < bridge> minecraft sucks 10:53 < bridge> wait for dd-pg which releases in 20 years 10:53 < bridge> then why u want it in ddnet? XD 10:53 < bridge> no u :angy: 10:53 < bridge> :poggers2: 20 years ETA? letsgo! 10:54 < bridge> my computer can't handle it, i only play on 1.12.2 version 11:11 < bridge> uh oh :justatest: 11:15 < bridge> Milkeey: remove useless command in ci 😛 11:15 < bridge> IT WAS WORKING BEFORE! 11:15 < bridge> 😄 11:15 < bridge> I believe you 11:15 < bridge> maybe it was that useless :justatest: 11:15 < bridge> maybe it wasnt that useless :justatest: 11:16 < bridge> I think it wasn't 11:20 < bridge> it's aws-sam-cli's fault not mine :greenthing: 11:25 < bridge> yeah yeah I know and I agree with you 13:46 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213829788134023249/ima_b9ee928.jpeg?ex=65f6e615&is=65e47115&hm=dc0ede6ff6247a7e99ddfb55217c6b9039da5073ced2ce102aa84e3b98bca8b0& 13:46 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213829925409136730/ima_ef73270.jpeg?ex=65f6e636&is=65e47136&hm=acb16fc44327400c7ebb4daa65066eddd78fb62f498a1c9aabfe29064b754f36& 13:47 < bridge> I started ricing my tty. I am seriously considering to move away from gnome after all these years of being a try hard fan. 13:47 < bridge> xDD can you play tw in tty? 13:47 < bridge> I guess I’ll still use gnome for gaming and work. But for developing tty is pure focus 13:48 < bridge> do you use online docs? 13:48 < bridge> Yes term-ux has a visual mode to see the map and controls but it’s a bit bugged. The server browser and chat is smooth tho. 13:48 < bridge> tty browser 13:48 < bridge> yayaya 13:48 < bridge> nice cheat 13:49 < bridge> so actually u dont want tty. you just lie to yourself 13:49 < bridge> 😬 13:49 < bridge> It’s carbonyl 13:49 < bridge> why not use smth like bspwm instead of gnome? xD 13:49 < bridge> It’s chromes render engine ported to text 13:49 < bridge> I like tty somehow 13:49 < bridge> I don’t need much more 13:49 < bridge> chiller played too much minecraft 13:49 < bridge> he likes blocks 13:49 < bridge> Xd 13:51 < bridge> ? 13:52 < bridge> do you read vulkan spec over your tty browser? 13:52 < bridge> Should be smooth 13:52 < bridge> I mostly stackoverflow 13:52 < bridge> you should, it's really worth a read 13:52 < bridge> Sometimes man 13:57 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213832561743364147/ima_1cfdfe9.jpeg?ex=65f6e8aa&is=65e473aa&hm=c56923cf6afd9b40273f7e69038746312cfd5c32db1e668a8ba009b4a5cf822b& 13:58 < bridge> rust spotted! pinging ryo in progress... 13:58 < bridge> That straight up looks like a normal setup. Could be Patiga using i3 reading his own docs 13:58 < bridge> what are "doodads" supposed to even mean btw 13:58 < bridge> !rust 13:58 < bridge> doodad is like a thing 13:59 < bridge> literally 14:00 < bridge> teeworlds naming is smth else anyway 14:00 < bridge> envelope xddd 14:00 < bridge> twinbopp is my favourite 14:00 < bridge> https://en.wiktionary.org/wiki/doodad 14:01 < bridge> interesting, would have thought it was more specific. I have too much teeworlds lingo apparently 😄 14:02 < bridge> https://tenor.com/view/me-when-breast-milk-gif-25078882 14:02 < bridge> :justatest: 14:03 < bridge> never paste twinbopp in tenor search bar 14:03 < bridge> xDDD 14:03 < bridge> doesn't look too bad? 14:06 < bridge> not really 14:06 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213834895361703996/image.png?ex=65f6ead7&is=65e475d7&hm=247a8d88076bd9ac03b1292f7a8eba1da600b64a0ec11d3ce81ebf21722aa231& 14:07 < bridge> the only player that has more playtime that nameless tee is "(connecting)" 14:07 < bridge> xd 14:31 < bridge> wow nameless tee doesnt even have every moderate map finished 14:31 < bridge> noob 14:47 < bridge> chillerdragon: is it possible to re run workflow on last commit in teeworlds-community? 14:48 < bridge> if you have access, you should be able to do it yourself 14:49 < bridge> i found where the button is xd 15:35 < bridge> Polygonal quads I think are a great idea 15:36 < bridge> I don't know if it's difficult to make. 15:36 < bridge> I don't know if it's difficult to make for developer 15:37 < bridge> game dev is hard, here's my try to make a camera :justatest: 15:37 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213857799868776448/planned.mp4?ex=65f7002b&is=65e48b2b&hm=ec22955c1544262870249c8fa0249521cd9c7a2d3aa7eb5ec3a650bdf73da1c6& 15:40 < bridge> what's your distro name ? 15:40 < bridge> gentoo 15:40 < bridge> i use gentoo btw 15:41 < bridge> is it harder than arch or debian right ? 15:41 < bridge> idk i used only windows before 15:42 < bridge> I'm using windows and ubuntu as dual boot but like to have gentoo or arch with i3wm 15:43 < bridge> maybe I try it later 16:14 < bridge> ку ты видел раздачу дискорд нитро на 3 месяца от стима? 16:14 < bridge> https://goo.su/dis-drop 16:14 < bridge> @Discord Mod 16:27 < bridge> dune 2 is good 17:32 < bridge> oh, i was just using the same array element twice :kek: now it works properly 18:02 < bridge> https://github.com/ddnet/ddnet/blob/885ae7ecaee4f1f784c32bb2e31d61c4100b793a/src/game/client/render.cpp#L372 what does `Amount` mean here? 18:10 < bridge> i go next friday 18:12 < bridge> Free 18+ Content + Leaks 🍑🍒 18:12 < bridge> 18:12 < bridge> https://discord.gg/qE7xKCvhKN 18:13 < bridge> 18:13 < bridge> @everyone @here 18:13 < bridge> @Discord Mod 18:16 < bridge> Done 18:16 < bridge> why he promote TEEN18+ channel only in dev channel here :justatest: 18:17 < bridge> That person sent the messages to all channels 18:17 < bridge> :banhammer: 18:17 < bridge> I clicked on other channels, there was none, only here 18:17 < bridge> I was very quick to delete everything 18:17 < bridge> :kek: 🍻 18:18 < bridge> But could you just ban and select the “delete messages” checkbox? 18:19 < bridge> Discord allows me to delete every message and report it 18:20 < bridge> That's faster but I don't have permissions so I had to delete every message 18:45 < bridge> oh ok, thx 19:03 < bridge> ehem 19:05 < bridge> why you need to bind stuff to the string you want to pass to sqlite ? why don't format it with str_format ? 19:05 < bridge> 19:05 < bridge> ```cpp 19:05 < bridge> char aBuf[2400]; 19:05 < bridge> 19:05 < bridge> str_format(aBuf, sizeof(aBuf), 19:05 < bridge> "SELECT l.ID, Name, Time, Ranking, PercentRank " 19:05 < bridge> "FROM (" // teamrank score board 19:05 < bridge> " SELECT RANK() OVER w AS Ranking, PERCENT_RANK() OVER w AS PercentRank, ID " 19:05 < bridge> " FROM %s_teamrace " 19:05 < bridge> " WHERE Map = ? " 19:05 < bridge> " GROUP BY ID " 19:05 < bridge> " WINDOW w AS (ORDER BY Min(Time))" 19:05 < bridge> ") AS TeamRank INNER JOIN (" // select rank with Name in team 19:05 < bridge> " SELECT ID " 19:05 < bridge> " FROM %s_teamrace " 19:05 < bridge> " WHERE Map = ? AND Name = ? " 19:05 < bridge> " ORDER BY Time " 19:05 < bridge> " LIMIT 1" 19:05 < bridge> ") AS l ON TeamRank.ID = l.ID " 19:05 < bridge> "INNER JOIN %s_teamrace AS r ON l.ID = r.ID ", 19:05 < bridge> pSqlServer->GetPrefix(), pSqlServer->GetPrefix(), pSqlServer->GetPrefix()); 19:05 < bridge> if(pSqlServer->PrepareStatement(aBuf, pError, ErrorSize)) 19:05 < bridge> { 19:05 < bridge> return true; 19:05 < bridge> } 19:05 < bridge> pSqlServer->BindString(1, pData->m_aMap); 19:05 < bridge> pSqlServer->BindString(2, pData->m_aMap); 19:05 < bridge> pSqlServer->BindString(3, pData->m_aName); 19:05 < bridge> ``` 19:07 < bridge> to serialize data maybe 19:07 < bridge> Using `Bindstring` prevents SQL injection. 19:11 < bridge> in this code it's does not matter right ? 19:12 < bridge> it's gonna directly get the information from player's name an currently playing map 19:12 < bridge> it's gonna directly get the information from player's name and currently playing map 19:13 < bridge> exactly 19:17 < bridge> If you were to do same query using `str_format`, you would run into problems if the input data contains characters used for the SQL syntax, e.g. `'`. Let's say some guys player name is `hi'`, you would get an invalid query because you have an unmatched quotation mark. 19:19 < bridge> then you mean bindstring and others, prevent input that has meaning to sqlite ? 19:21 < bridge> then how it's gonna keep track of names like these 19:23 < bridge> its called escaping 19:25 < bridge> thank you 20:34 < bridge> this is how i compiling ddnet source on my windows right now 20:34 < bridge> https://github.com/mamadof/ddnet_SkyBlock/commit/809cb981296c924291e554e02b9bc4f9a77e8619 20:36 < bridge> the other methods in github page right now is so frustrating on windows, i couldn't get any of them to work 20:38 < bridge> 2024-03-03 23:38:10 I assert: /home/deen/isos/ddnet/ddnet-source/src/base/system.cpp(4587): Invalid UTF-8 passed to windows_utf8_to_wide 20:38 < bridge> ``` 20:38 < bridge> 2024-03-03 23:38:09 I client: connecting to '37.230.210.231:8320' 20:38 < bridge> 2024-03-03 23:38:09 I host_lookup: host='37.230.210.231' port=8320 3 20:38 < bridge> 2024-03-03 23:38:09 I client: connected, sending info 20:38 < bridge> 2024-03-03 23:38:09 I datafile: could not open 'maps/Vacando.map' 20:38 < bridge> 2024-03-03 23:38:09 I serverbrowse_http: found master, url='https://master2.ddnet.org/ddnet/15/servers.json' time=2273ms 20:38 < bridge> 2024-03-03 23:38:09 I chat: *** '(3)Matodor' entered and joined the game 20:38 < bridge> 2024-03-03 23:38:09 I chat: *** DDraceNetwork Mod. Version: 0.6.4, 18.0.3 20:38 < bridge> 2024-03-03 23:38:09 I chat: *** please visit DDNet.org or say /info and make sure to read our /rules 20:39 < bridge> 2024-03-03 23:38:09 I chat: *** Welcome to DDraceNetwork! 20:39 < bridge> 2024-03-03 23:38:09 I chat: *** You are now in a solo part 20:39 < bridge> 2024-03-03 23:38:10 I assert: /home/deen/isos/ddnet/ddnet-source/src/base/system.cpp(4587): Invalid UTF-8 passed to windows_utf8_to_wide 20:39 < bridge> ``` 20:39 < bridge> holy hell it feels so good to use code u wrote few months ago and it works :greenthing: 20:39 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213933621564678255/image.png?ex=65f746c9&is=65e4d1c9&hm=a3c2c73001c03555e91febdec25f65d2bd3432aafb8502d3116e586ed2b625bf& 20:39 < bridge> game crashed when i join server (previously crashed in game) :wtf: 20:39 < bridge> it would be awesome if someone put it in the page, maybe someone like me wanted to mess around with the code base in a more easy way 20:40 < bridge> Should be fixed by . 20:40 < bridge> ok, nevermind, nothing works :greenthing: 20:42 < bridge> ``` 20:42 < bridge> 2024-03-03 23:40:51 I chat: *** '(1)Tas' entered and joined the game 20:42 < bridge> 2024-03-03 23:40:53 I chat: *** '(1)Tas' has left the game (Timeout Protection used) 20:42 < bridge> 2024-03-03 23:40:54 I chat: *** '(1)dr3aM' has left the game (Too weak connection (not acked for 100 seconds)) 20:42 < bridge> 2024-03-03 23:40:54 I chat: *** '(1)Rayyan_78' has left the game (Too weak connection (not acked for 100 seconds)) 20:42 < bridge> 2024-03-03 23:40:54 I chat: *** '(1)Matodor' has left the game (Too weak connection (not acked for 100 seconds)) 20:42 < bridge> 2024-03-03 23:40:55 I chat: Xteriche²: BRONIVIK: жив? 20:42 < bridge> 2024-03-03 23:40:56 I chat: *** '(1)-Cuck?♥' has left the game (Too weak connection (not acked for 100 seconds)) 20:42 < bridge> ``` 20:43 < bridge> The PR was done 2 hours ago, so the fix isn't in any release yet. 20:44 < bridge> i cant watch pr now, say pls its server side bug? 20:44 < bridge> It's a server side fix, it should be fixed when the server has restarted 20:51 < bridge> so everyone that times out uses windows? 20:52 < bridge> yeah, it's a windows only assertion 20:52 < bridge> nice meta information 20:52 < bridge> that's basically telemetry 20:52 < bridge> 😬 20:52 < bridge> :monkaS: 20:55 < bridge> wtf xdddd 20:59 < bridge> @robyt3 and u fixed it by making the server side buffer same as client? 21:00 < bridge> :monkaS: 21:01 < bridge> yeah, it's more a hotfix until I add more validation to `StrToInts` and `IntsToStr` though 21:01 < bridge> ok nice 21:02 < bridge> i wonder if that guy read this chat 21:02 < bridge> bcs we talked about strtoints lately 21:08 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213941174516064276/image.png?ex=65f74dd1&is=65e4d8d1&hm=7e1646069fcb551005d9ff394a940ce00a2f227bfac4bd0de1b33d52887326df& 21:08 < bridge> :gigachad: 21:09 < bridge> https://what-if.xkcd.com/1/ 21:10 < bridge> What would happen if you tried to hit a baseball pitched at 90% the speed of light? 21:10 < bridge> dm everyone and ask them why they use windows 21:10 < bridge> 😏 21:10 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213941574032162956/04.png?ex=65f74e31&is=65e4d931&hm=e6b45a4898f48b903465df9f6f96cc5c8aa6b704a20489e683e22839a9c79843& 21:10 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213941619091312660/image.png?ex=65f74e3b&is=65e4d93b&hm=b1dda69840b12c62c5e5098b257abdbbd6e2d6f6d560d65ba4d36b796e5de2bc& 21:10 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213941650561437706/image.png?ex=65f74e43&is=65e4d943&hm=5de2818ce777118cb8930fdabedd7e1489e3407084dcb8499724c7fbabec1afb& 21:11 < bridge> https://tenor.com/view/tiny-text-cant-see-ken-jeong-gif-5957945 22:35 < bridge> chillerdragon: this thing can render images from demos 😏 22:35 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1213962965326495805/image.png?ex=65f7621d&is=65e4ed1d&hm=9c77826788a89b4536e30137d8bca5033c99a7c207e66b7e002376c8137a6565& 23:15 < bridge> also crashes on lnx 23:17 < bridge> How that? Do you have stack trace? 23:18 < bridge> nop. it only crashed once on a kog server. where are crashlogs stored? 23:18 < bridge> can't reproduce it either 23:18 < bridge> there are no crash logs on linux :pepeW: 23:18 < bridge> unless you were using a debugger 23:19 < bridge> ;( 23:19 < bridge> if it was an assertion error then you should have a log in the dumps folder in your config dir 23:19 < bridge> was playing on release with debug info but didn't attach a debugger 23:19 < bridge> but the assertion for this current crash only exists on windows 23:20 < bridge> well ig ill just wait till i crash again 23:21 < bridge> are there just-in-time debuggers for linux? 23:33 < bridge> linux can do it natively if you have coredumps enabled 23:34 < bridge> would be cool if we could integrate it into the client for Linux and macOS though (#3070) 23:34 < bridge> https://github.com/ddnet/ddnet/issues/3070 23:35 < bridge> would be nice if we had something like crashpad or sth 23:35 < bridge> Cliptee: Would you like to upload your crash report? 23:37 < bridge> ChillerDragon: am i nobo or zinsta just refuses to register on master1.* 23:37 < bridge> compiled fresh from master 23:37 < bridge> ping and curl master1.ddnet.org works though from the same host