Time  Nick             Message
00:19 cheapie          Heh, spotted on a sign next to a road in... rather poor condition in Neustadt on VE-C: "This is what happens when you spend your municipal budget on anime"
00:21 user2_           how is that even MT-related :PPP
00:22 cheapie          Because it's in-game
00:22 MTDiscord        <wsor4035> its a luanti server
00:22 MTDiscord        <wsor4035> ....so was it lminus or user11? 🤔
00:22 MTDiscord        <wsor4035> im going with the first
00:22 user2_           is this chat bridged to a MT server?
00:22 * cheapie        checks rollback
00:23 MTDiscord        <wsor4035> server implodes cause rollback is ass
00:23 cheapie          Rollback works fine on VE-C :D
00:23 cheapie          Was just doing a rollback_check anyway, too old though, no longer in the lgos
00:23 cheapie          logs*
00:23 MTDiscord        <wsor4035> let me guess, because you keep it at one day of history or an external process?
00:24 cheapie          There's a nightly cleanup script, I can't remember what the retention period is but I can check
00:25 cheapie          Looks like it's set for 90 days for most players, 1 day (all actions deleted nightly) for players with the "daily_rollback_cleanup" priv
00:26 cheapie          I appear to be the only player with said priv
00:30 cheapie          VE-S has the same setup but with a retention period of 45 days for players not marked for daily cleanup, 5 players (me, MOZ, Eloria, Flitzpiepe, and BakerPrime) are marked for daily cleanup
00:31 cheapie          FWIW the line I'm using to list players with a given priv is (and there might be a cleaner way, but this works): SELECT name FROM user_privileges LEFT JOIN auth ON auth.id = user_privileges.id WHERE privilege = "daily_rollback_cleanup";
00:31 MTDiscord        <wsor4035> iirc rollback schema is decent in storing x/y/z columns, its just querying it that is terrible
00:31 MTDiscord        <wsor4035> probably wrong somehow
00:31 cheapie          The index improvements fixed that
00:32 MTDiscord        <wsor4035> yeah, talking about stock
00:32 cheapie          Stock contains the improvements now
00:33 cheapie          https://github.com/luanti-org/luanti/commit/7c6ade0fc5d4fccb3af190f54ca869a799fc3782
00:33 MTDiscord        <wsor4035> yeah, was looking at the pr version of that
00:34 cheapie          VE-C (and probably also VE-S) also has another index in there to make the cleanup faster, but that doesn't affect much in-game
00:34 cheapie          (that being said, the order of parameters in the new index probably makes it unnecessary)
00:35 cheapie          sqlite> EXPLAIN QUERY PLAN DELETE FROM action WHERE timestamp < strftime("%s","now","-45 days"); [snip] `--SEARCH TABLE action USING INDEX cleanupIndex (timestamp<?)
00:35 cheapie          I guess it's using it *shrug*
00:37 user2_           what tool do you use to read sqlite databases? the only thing i have is some random tool i found on flatpak
00:37 cheapie          I just use the sqlite3 CLI itself
00:37 user2_           yeah, i cant figure it out :P
00:37 user2_           i do prefer CLI tho-
00:37 cheapie          I've used a few GUIs to browse data before too, but I've found them nearly useless for editing
00:38 user2_           i'l have to figure out the CLI then- il do that rn
00:42 cheapie          wsor4035: [19:41:39] <lmisu> cheapie, re: budget on anime sign, actuallyt it's AlcesAlce [sic] :D
00:50 MTDiscord        <wsor4035> Yeah, they dm'd me
01:01 cheapie          meanwhile https://cheapiesystems.com/media/images/screenshot_20250914_195846.png
01:16 MTDiscord        <wsor4035> something broken?
01:17 cheapie          wsor4035: Meant to look that way (just briefly for the screenshot) yes :P
01:18 user2_           that screenshot looked like a BSOD happened to a node-
02:44 crazylad         totally not stars on the main menu... :) -> https://filebin.net/08himy6oczky81op/menu_stars_redo.png
02:45 MTDiscord        <wsor4035> not sketch at all
02:46 crazylad         you mean filebin?
02:46 crazylad         filebin is an open-source file hosting site - seems much safer than the alternative "catbox.moe" which is banned iirc in a few countries
02:47 [MatrxMT]        <Blockhead256> banned in entire countries? wow, I thought it was just banned by some sysadmins
02:47 MTDiscord        <wsor4035> to view a png i shouldnt need to download a file, this isnt 1998
02:48 [MatrxMT]        <Blockhead256> it's just a warning screen, then it sends you on to the real file page
02:48 [MatrxMT]        <Blockhead256> reminder you can't tell that an "open source" website is running the published version of the software
02:48 user2_           yeah, me and crazylad use filebin a lot, it's fine
02:49 user2_           you dont need to download it, you can still view it from the site, just press 'proceed to download'
02:50 MTDiscord        <nathan4220776> It is silly that discord doesn't show previews of some files.
02:50 [MatrxMT]        <Blockhead256> re above: crowdstriked
02:51 MTDiscord        <nathan4220776>
02:51 MTDiscord        https://s3.filebin.net/filebin/4b2351ff82833a0fc3ff7f9e9678e5ea6034e97b68e43498ba4f775154c6a1cf/c4b48baff6e966177b79ec0bf282937b126af3786e1ef602c0b0b0d31ae7ec7d?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=7pMj6hGeoKewqmMQILjm%2F20250915%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250915T025127Z&X-Amz-Expires=60&X-Amz-SignedHeaders=host&response-cache-control=max-age%3D60&response-content-disposition=inline%3B%20filename%3D%22menu_stars_redo.png
02:51 MTDiscord        %22&response-content-type=image%2Fpng&X-Amz-Signature=4611eed1d5a14d37925a6582b8e22c37358878b18c6603e7c6df0a6de73db52a
02:52 [MatrxMT]        <Blockhead256> lol
02:52 [MatrxMT]        <Blockhead256> that URL is too long to fit in a single IRC message
02:52 MTDiscord        <nathan4220776> It works fine for me.
02:52 crazylad         yes, there's the actual file URL
02:53 MTDiscord        <nathan4220776> Is that an actual limitation of irc, or just a limitation of whatever client you're using?
02:53 MTDiscord        <wsor4035> lol, so if you never accept the warning, and then revisit the url, it shows you the content without ever accepting
02:53 [MatrxMT]        <Blockhead256> of IRC https://irc.luanti.org/luanti/2025-09-15
02:55 user2_           ive used filebin for like 8 months, the only issue is there's a limit to how much storage can be used at once
02:55 MTDiscord        <nathan4220776> Wdym at once?
02:55 MTDiscord        <nathan4220776> A maximum file size?
02:55 user2_           basically, yeah
02:56 MTDiscord        <nathan4220776> As long as you can upload as many files as you want, that's not an issue.
02:56 user2_           yeah it doesnt happen often for me
02:56 MTDiscord        <nathan4220776> The trick is, you put all the files you want to send into a tar file, and optionally compress it. Then, you do   split -b MAX_SIZE_BYTES archive.tar archive.tar.part_
02:57 MTDiscord        <nathan4220776> And you upload the parts separately.
02:57 MTDiscord        <nathan4220776> Then, to recombine them, you do    cat archive.tar.part* > archive.tar
02:57 user2_           i use 7zip- it was able to shrink a 1.9 GB archive with generic zip to 1.2 GB
02:58 MTDiscord        <nathan4220776> The difference is that my trick allows files of any size to be sent, as long as you have the patience to do so.
02:58 MTDiscord        <nathan4220776> You can transfer gigabytes of files over email this way. ;)
02:58 user2_           i have a giant 1.2 GB archive with every MT version (minetest-c55 to 5.13.0, src code and builds) thanks to 7zip-
03:00 [MatrxMT]        <Blockhead256> ..you made multiple copies of the source code? I guess that's something you can do. You could just use git... Well, if it's out-of-the-box ready to build with IrrlichtMt you may have a  purpose for that at least
03:01 user2_           no- just src code i downloaded manually- i really should fix that ;-;
03:01 user2_           but i have the src code for the minetest-c55 builds, im never going to risk losing that :)
03:02 user2_           i do write a ton of bash scripts to automate installing each version tho
03:04 user2_           also, is there a way to download a specific commit with git? say i wanted 5.13.0-dev-66aa5f3fa's src code, what would i run?
03:11 MTDiscord        <nathan4220776> You could do    git clone https://minetest ; cd minetest ; git checkout <commit_id>
03:11 user2_           alr, il try that rn
03:17 user2_           my network doesnt like me on the IRC, github, inagme, and cloning a repository at the same time-
03:18 user2_           *ingame
03:28 mrcheese         hmm... how did 1 filebin link start all that... ;-;
03:28 user2_           idk- someone thought it was sketchy or smth-
03:29 mrcheese         huh
03:30 [MatrxMT]        <Blockhead256> how about reading the scrollback instead of doing a big conversation circle?
03:34 user2_           mrcheese, were you here when crazylad posted that URL?
03:34 mrcheese         nope
03:34 user2_           if so, you should know how it happened-
03:34 user2_           nvm then-
03:34 mrcheese         well
03:35 mrcheese         was afk if that counts .-.
03:39 mrcheese         uhh... any reason im constantly getting a HTTP error with the forums if i try to upload a image? cant upload anything due to a HTTP error-
08:10 [MatrxMT]        <Blockhead256> mrcheese: the forums have a 1 MB file size limit. Above that, and you will get that obtuse error
08:10 [MatrxMT]        <Blockhead256> ah, I see you got an answer on the forums
15:44 repetitivestrain can i request a zipgrep for core.get_biome_data?
18:39 [MatrxMT]        <birdlover32767> i found a new error
18:39 [MatrxMT]        <birdlover32767> `ambiguous syntax (function call x new statement) near '('`
18:39 [MatrxMT]        <birdlover32767> yay...?
18:40 [MatrxMT]        <birdlover32767> context: (...):format(...)
18:40 [MatrxMT]        <birdlover32767> it was in a table without a comma