[00:01:57] is that a TLD [00:03:10] uh, yeah? [00:03:26] https://en.wikipedia.org/wiki/.gay [00:09:29] Unbelievable [00:09:31] https://social.coop/@cwebber/113488831220212999 [00:09:37] this country [00:10:10] U.S. what the fuck [00:10:24] trump isn't even inaugurated yet, and yet horrifying bullshit is already coming out? [00:14:01] It failed in the House [00:14:02] Miratrump [00:14:05] not sure about the senate [00:14:19] Get out [00:14:54] agent, yamete kudastop [00:16:19] someone wanna remove a misplace on [[SR]]? [00:16:19] https://meta.miraheze.org/wiki/SR [00:16:19]

[00:17:56] what misplace? [00:20:39] you can see on the bottom [00:20:49] also gonna repost some stuff for ya [00:21:07] Most importantly: https://cdn.discordapp.com/attachments/615786602454581249/1306994062783676517/image0.jpg?ex=6738b093&is=67375f13&hm=4fe00d53c31624b266effd1e87c049a58e7be91e7cf908654669110caac488dc& [00:22:06] also: https://www.latacora.com/blog/2019/07/16/the-pgp-problem/ [00:22:34] oh my god [00:24:10] I also have a post from 2014 on PGP bar [00:24:51] saying end to end email encryption gonna get a big kick because google and yahoo are supporting it [00:24:58] :cutebastian2: [00:25:24] also have a blog post on GPG alternatives. And a fedi threads where I learned about this [00:25:25] want? [00:34:24] https://cdn.discordapp.com/attachments/615786602454581249/1307141687788834917/IMG_5814.png?ex=67393a0f&is=6737e88f&hm=20e0aa74a3aac8b6fb2e1deaebf6e3df4dc8f2843466aba0be701a48808d4138& [00:34:25] comedy [00:48:35] John lewis sighting https://fox.nexus/@quips/113489774014632089 [00:48:43] someone prob forgot to post this [00:48:56] i wonder [00:49:01] is #cvt-feed public on the discord server [00:50:07] uuuuh [00:50:13] yes [00:50:20] https://cdn.discordapp.com/attachments/615786602454581249/1307145700298981427/aTZYTJ2.png?ex=67393dcc&is=6737ec4c&hm=50806b6f668c8b9cdfe2a4ee399b80389e3d769b09a9e242ffa6455b0b48f7b1& [00:50:31] okay cool [00:51:11] hey wait, i wonder [00:51:18] can i have you abuse your global admin rights for a sec? :3 [00:51:36] cartooncartoons64 is asking in #general about a page that i think he accidentally clobbered with redirects [00:51:43] and so the original page isn't there anymore [00:52:28] are there (non-redirect) diffs on https://loathsomecharacters.miraheze.org/wiki/Special:Undelete/Ladybird_Lu_(Lu_%26_the_Bally_Bunch)? [00:52:44] wait no, wrong link [00:53:01] okay, on https://loathsomecharacters.miraheze.org/wiki/Special:Undelete/User:CartoonCartoons64/sandbox/Ladybird_Lu_(Lu_%26_the_Bally_Bunch) [00:55:51] sure i love abuses of pwoer [00:56:17] let me get my phonr [00:56:21] i think this is one of the relevant diffs: https://loathsomecharacters.miraheze.org/wiki/?diff=187967 [00:56:21] no yubi yet [00:56:39] same :( [00:56:43] i got yubistyles tho [00:56:47] claire tech team when [00:56:52] the covers? [00:56:54] yeah [00:56:59] I'll have to place an order tmr [00:57:01] i already am on the tech team wdym [00:57:04] idk if ill get one or two [00:57:12] truuuu [00:57:13] uh [00:57:27] claire `tech-team` global group when [00:57:48] presumably when i sign a paper that sells my soul is the nda [00:58:36] https://loathsomecharacters.miraheze.org/wiki/Special:Undelete/User:CartoonCartoons64/sandbox/Ladybird_Lu_(Lu_%26_the_Bally_Bunch)?centralAuthAutologinTried=1¢ralAuthError=Not+centrally+logged+in only has one diff [00:58:48] same lol. we each have our own issues [00:58:55] jesus fuck okay damn [00:59:02] i assume that diff is a redirect diff? [00:59:12] yes [00:59:15] checking that page [00:59:24] i mean issues with being able to sign [00:59:39] is there even any user-facing option of revdelled rev id -> page? [00:59:57] what is this [01:00:01] this [01:00:04] redirect chain [01:00:07] yeah i know [01:00:08] that ends in a loop [01:00:10] i don't want to know [01:00:14] oh im gonna be sick [01:00:24] i don't think we should say that directly to them [01:00:31] ugh i think so [01:00:42] (which reply?) [01:00:42] (removed from discord sry) [01:00:50] revdel to page [01:00:54] okay so [01:01:01] idea [01:01:12] CosmicAlpha: do you mind if we can use you as sql.php so that i can figure out what happened to a diff? [01:01:39] i'm curious about what happened to this page [01:01:45] and also, it's a user request [01:06:00] gg, i'm looking up "sql left join" [01:07:18] wonder whos becoming MWe first, pixl or clair [01:13:02] well once the new NDA drops, why not both [01:15:19] Well claire has her own issues with signing I believe. With me ez shut the fuck up and take my soul :Heart: [01:15:37] skill issue [01:16:33] Random questions whats the database and table for user accounts and whats your account id [01:16:39] :cutebastian2: [01:16:56] mhglobal.globaluser and #114 [01:17:03] oh yea zenless exists [01:17:22] thank you agent :clueless: [01:17:35] now time to find the delete command for MSQL [01:18:41] :devious: [01:19:07] you can’t just delete the 114th Miraheze user like that a:waaa: [01:21:31] SELECT * FROM revision LEFT JOIN page ON page.page_id = revision.rev_page LEFT JOIN actor ON actor.actor_id = revision.rev_actor LEFT JOIN slots ON slots.slot_revision_id = revision.rev_id LEFT JOIN content ON content.content_id = slots.slot_content_id LEFT JOIN text ON text.old_id = CAST(SUBSTR(content.content_address, 4) AS INTEGER) WHERE rev_id = 187967; [01:21:42] can someone run that on loathsomecharacterswiki, thx [01:23:16] > [16/11/2024 12:19] you can’t just delete the 114th Miraheze user like that a:waaa: [01:23:23] agentisai: idk, CA has done it before like yesterday [01:25:08] he deleted lesser users [01:25:17] he deleted all the users [01:25:23] also [01:25:27] not me [01:25:27] u literally vanished wdym [01:25:38] oh yea [01:25:41] Vanishes are reversible if you have shell access [01:25:58] was it a gdpr vanish? idr [01:26:05] id say that depending on how GDPR dont like that but wlel [01:26:05] it was [01:26:18] most people dont care anyways... [01:26:24] if it's reversible with tons of user info stored, then it's not a very good vanish [01:26:27] cough wmf and twitter and like evryone [01:26:37] oh no, the account was a skeleton [01:26:45] basically just recycled the identifier in the database [01:26:53] i.e. the user number [01:26:54] spooky scary skeleto- [01:27:36] also [01:27:39] > [16/11/2024 12:21] can someone run that on loathsomecharacterswiki, thx [01:27:41] :3 [01:35:20] Now I am to get started on updating the IR for the absolutely shitstorm I started. [01:35:46] yippee [01:36:03] and then after that, i'll get you to run a sql query xD [01:36:12] totally will not be a repeat of previous events [01:36:35] Is it a real SELECT query and not an imaginary one? [01:36:41] yeah [01:36:52] tested locally on a test server (with rev 1) [01:37:17] Then it probably wont delete all users this time.. [01:37:21] https://files.catbox.moe/x5wwoh.png [01:37:33] I am much more conserved with SQL now lol [01:37:41] ignore the 50 instances of docker and mysql in htop [01:37:57] PTSD [01:38:07] transactions [01:38:13] something i have personal experience with :sunglasses: [01:38:28] in prod? [01:38:34] not yet [01:38:45] correct answer [01:39:07] Query looks sane I eill rub it [01:39:11] *will run it [01:39:11] we should predict what my IR will be [01:39:29] Do we have a tool engineers run queries through [01:39:29] "accidentally overwrote every page on a wiki with 'gay gay homosexual gay' due to forgotten where clause" [01:39:33] sql.php [01:39:41] if so make it do transactions [01:39:53] lol I guess I could rub it too... [01:41:20] If I can ssh in, SSHing in with termius now that I canceled premium is a bit challenging with bastion lol I set up a port forwording rule then ssh in with 127.0.0.1. [01:41:33] i use termux lol [01:41:39] tho idk if you use android or not [01:41:45] I do [01:41:49] oh okay cool [01:42:03] termux gives you a shell which is nice :3 [01:42:04] i use terminus on my iphone [01:42:06] no account [01:42:09] no issues [01:42:16] and once upon a time I used termux for everything then it started eating like 200GB on my phone so I deleted it and never reinstalled lol [01:42:20] oh i see [01:42:20] use it for my VPS [01:42:31] what does terminus premium do [01:42:53] okay, only 4.01 GB used by termux [01:43:02] logs? [01:43:04] i moved everything over from my old phone using rsync :3 [01:43:26] Yeah probably due to all the github repos I had cloned and packages installed it was 200GB lol [01:43:30] tried to use tar, but it was being an uncooperative bitch [01:43:35] okay but like [01:43:40] how did you even reach 200 GB [01:43:48] no clue lol [01:43:51] that wouldnt be on your phone though [01:43:56] wouldn't you have been deleting old stuff after you realize that you had no space? [01:44:03] unless on android it lets you shell to your own device [01:44:13] it does [01:44:23] I use iOS lol [01:44:30] so i ssh to my VPS [01:44:31] i have termux to call me a fucking weeb on a new session [01:44:39] I didn't I just deleted termux lol [01:44:44] Hm [01:44:52] It was when I wasn't using it as much so just cleared it completely [01:44:58] oh oki [01:45:00] fair [01:45:32] once your in bastion is there still checks on your devices SSH keys to enter the mw servers and such? Assuming yes just wondering if terminux would like it [01:45:38] well you used it [01:45:39] I really should get to work on IR before I loose all timestamps lol [01:45:44] what did pro do again [01:45:50] This is gonna be one long IR [01:45:55] and i should pack for my trip this weekend [01:45:57] hey [01:45:59] cos [01:46:04] if you’re feeing tired [01:46:15] claire and i can bring up cute cat photos [01:46:37] I also have people i can summon for seals and otters and bunnies [01:46:49] 😆 [01:46:50] hyfetch couldn't trans my neofetch :(( [01:48:18] https://files.catbox.moe/wipzdl.png [01:48:43] and i can use sshfs from my laptop to access my phone's filesystem lol [01:48:46] oh crap my Google Authenticator got reset... ugh [01:48:53] wait what [01:48:54] oofie [01:49:10] Cosmic [01:49:15] You have [01:49:16] 8 [01:49:18] yubikeyd [01:49:21] oh lol I was logged into a different account for some reason... and exit panic mode [01:49:25] ca [01:49:25] and rely on Google Authentication [01:49:27] how do you have 8 [01:49:32] he [01:49:35] loses them [01:49:37] like i [01:49:38] Well yeah I do lol [01:49:40] lose pencils [01:49:47] oh wow [01:49:55] sh [01:49:56] I have 2 I always save codes to of both A and C versions [01:49:59] should i be scared? [01:50:02] the rest are backups [01:50:19] Of how much that probably cost yes [01:50:21] meanwhile i'm considering tying my password manager to the yubikey [01:50:41] May also [01:50:54] debating moving to proton including pass or bitwarden [01:51:05] surprised you'd use pass [01:51:17] i dont, I should [01:51:21] why [01:51:25] :squint: [01:51:39] basically using a gpg keypair for your passwords feels kinda overkill to me lol [01:51:55] I don't use a password manager (for most important accounts) I use different passwords for each one that I actually manage to remember or that I reset everytime I access them. [01:52:06] ca [01:52:08] why are you like this [01:52:10] I use passphrases [01:52:14] wait no [01:52:16] That I can remember [01:52:17] how are you like this [01:52:21] but normally don’t [01:52:25] but yeah, i mainly have two passphrases i remember [01:52:28] actually i do have a password manager [01:52:34] keepass vault and password i daisy chain locally [01:52:36] i rely on icloud keychain [01:52:42] daisy chain? [01:52:48] basically use around [01:53:00] e.g. my ssh key passphrase = my gpg key passphrase = my laptop password = my phone password [01:53:16] ah [01:53:23] (i use password and passphrase interchangeably) [01:53:33] I need to standardize that [01:53:51] oh yeah, i set passphrases on my personal servers [01:53:53] i use different forms of the same phrase for a lot of shell stuff [01:53:56] i.e. 1 atm lol [01:54:04] Sleep [01:54:13]