[01:29:28] Hello! I would like some help on how to change the default comment when using MsUpload [01:42:40] Anyone here? [01:49:54] Sorry, yes, but not entirely sure so not a ton of help unfortunately [02:02:56] All right, thank you [03:01:43] <.labster> MannysMyName: if you're still there, try loading the page using `?uselang=qqx`, you can then edit the page in the Mediawiki namespace to change the message [03:02:11] <.labster> See https://www.mediawiki.org/wiki/Help:System_message [03:31:00] .labster: they disconnected before your message [03:31:28] <.labster> yeah, why I prefixed with "if you're still there" [03:31:37] I missed that lol [03:32:00] I am tired and my head hurts and it's 4:30 AM [03:32:12] <.labster> go to sleep lol [12:20:25] TIL CreateWiki has doesn't really check if a request ID exists in the database [12:21:17] The `WikiRequest` class kind of does check this in its constructor, but it doesn't pass this information down [15:52:23] https://github.com/miraheze/CreateWiki/pull/489 kind of a POC still, but it's coming along nicely [15:53:31] I have to implement the error responses (https://www.mediawiki.org/wiki/API:REST_API/Status_codes) though [16:03:35] as well as to allow the appropriate users to query suppressed requests, but that can wait [18:04:09] https://github.com/miraheze/CreateWiki/pull/489 is now ready [20:13:42] @originalauthority garda Is MSQL ja? [20:34:37] Yurrr [20:45:21] https://meta.mirabeta.org/w/rest.php/createwiki/v0/query_wiki_request/1 nice [20:45:37] more APIs to follow soon [20:46:31] ™️ [21:46:29] do env take just the db name or a URI with IP [21:47:12] just db name [21:47:19] oki! [21:47:28] grabed my token [21:47:33] PHP CLI to start? [21:48:28] yup you need to invite it to whatever server you're testing at, though. [21:48:36] i forgot how to generate the invite link :hmmm: [21:48:57] Oh I have a test bot [21:49:04] side note [21:49:04] oh use that then yeah [21:49:13] whats you dev server name? [21:49:20] TP-Bot [21:49:24] L [21:49:26] https://cdn.discordapp.com/attachments/1006789349498699827/1221939024256700547/gL3g4jg.png?ex=66146665&is=6601f165&hm=36d571cd5ee79d6997b174451c49670bc7fa80325fd1fc34b70688611b1d48d6& [21:49:31] [[Malebolge]] [21:49:32]

[21:49:47] interesting [21:49:54] 🗑️ [21:49:58] guh [21:50:12] [[w:Malebolge]] [21:50:13]

[21:50:33] sounds reasonable [21:50:42] [1/2] First bot account I ever made [21:50:42] [2/2] https://cdn.discordapp.com/attachments/1006789349498699827/1221939342654570526/Y7ogCxv.png?ex=661466b1&is=6601f1b1&hm=883842aa6b5a1ee455b677efffb8e764769e9413747b38c323825df63d468f93& [21:50:46] now my test bot [21:51:14] i def am not googling all the mariadb setup commands [21:53:12] https://cdn.discordapp.com/attachments/1006789349498699827/1221939970793668759/XrrZSzj.png?ex=66146747&is=6601f247&hm=60a96ed949870efd128fa3071e62c2c75e885957abc0dcbf2249669f95363950& [21:53:22] breaths deeply [21:54:26] wait it did work? [21:54:27] isn't it so annoying [21:54:27] but [21:54:29] yes [21:54:31] why 0 rows [21:54:32] the last one did [21:54:37] 😭 [21:54:42] WHY 0 ROWS THEN [21:54:44] i assume your table is empty? [21:54:48] ja [21:54:52] actually [21:54:54] there is no table [21:54:57] logically then there are 0 rows [21:55:00] derp [21:55:17] garda auto make tables? [21:55:19] That operation doesn't touch any rows, so it affects 0 rows [21:55:34] nah I'm not that skilled [21:55:40] cris in pixl [21:55:40] the sql is in the repo somewhere [21:55:59] [1/9] ```sql [21:55:59] [2/9] CREATE TABLE guild_settings ( [21:55:59] [3/9] id INT AUTO_INCREMENT PRIMARY KEY, [21:56:00] [4/9] guild_id VARCHAR(255) NOT NULL, [21:56:00] [5/9] language VARCHAR(4), [21:56:00] [6/9] wiki VARCHAR(255), [21:56:00] [7/9] wikifarm VARCHAR(255) [21:56:01] [8/9] ); [21:56:01] [9/9] ``` [21:56:07] just realised there's no user table [21:56:11] for the verifications [21:56:37] oh I haven't pushed it to git [21:57:04] sobs in pixl [21:58:16] [1/11] ```sql [21:58:16] [2/11] +-----------------+---------------+------+-----+---------------------+----------------+ [21:58:16] [3/11] | Field | Type | Null | Key | Default | Extra | [21:58:17] [4/11] +-----------------+---------------+------+-----+---------------------+----------------+ [21:58:17] [5/11] | id | int(11) | NO | PRI | NULL | auto_increment | [21:58:17] [6/11] | discord_user_id | varchar(20) | NO | | NULL | | [21:58:18] [7/11] | token | varchar(1000) | YES | | NULL | | [21:58:18] [8/11] | received_at | timestamp | YES | | current_timestamp() | | [21:58:18] [9/11] +-----------------+---------------+------+-----+---------------------+----------------+ [21:58:19] [10/11] ``` [21:58:19] [11/11] is the table you need but I've lost the sql command to make it [21:58:23] (don't ask why its varchar(1000) [21:58:55] you can `mysqldump` it and just remove the data and you'll get the commant to make the table [21:59:16] HEH [21:59:19] pls explain [21:59:25] https://dev.mysql.com/doc/refman/8.3/en/show-create-table.html? [21:59:43] that also works [21:59:55] [1/10] oh hey yeah [21:59:56] [2/10] ```sql [21:59:56] [3/10] CREATE TABLE `oauth_tokens` ( [21:59:56] [4/10] `id` int(11) NOT NULL AUTO_INCREMENT, [21:59:57] [5/10] `discord_user_id` varchar(20) NOT NULL, [21:59:57] [6/10] `token` varchar(1000) DEFAULT NULL, [21:59:57] [7/10] `received_at` timestamp NULL DEFAULT current_timestamp(), [21:59:58] [8/10] PRIMARY KEY (`id`) [21:59:58] [9/10] ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci [21:59:58] [10/10] ``` [21:59:58] https://cdn.discordapp.com/attachments/1006789349498699827/1221941672384925716/dHX9ztq.png?ex=661468dd&is=6601f3dd&hm=7ab745400e92915f8bfa652661e64a72b698b28f0f4da6b43fc0842b9f6a8cff& [22:00:12] yay [22:00:21] innoDB? [22:00:41] that's the only storage engine you should ever need nowadays tbh [22:01:13] latin1_swedish_ci [22:01:13] wtf [22:01:43] [1/11] whys your table in swedish collate: [22:01:43] [2/11] ``` [22:01:44] [3/11] | guild_settings | CREATE TABLE `guild_settings` ( [22:01:44] [4/11] `id` int(11) NOT NULL AUTO_INCREMENT, [22:01:44] [5/11] `guild_id` varchar(255) NOT NULL, [22:01:45] [6/11] `language` varchar(50) DEFAULT NULL, [22:01:45] [7/11] `wiki` varchar(255) DEFAULT NULL, [22:01:45] [8/11] `wikifarm` varchar(255) DEFAULT NULL, [22:01:45] [9/11] PRIMARY KEY (`id`) [22:01:46] [10/11] ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci | [22:01:46] [11/11] ``` [22:03:37] ? [22:05:03] welp tables done [22:05:09] whats the command to kick it up? [22:05:26] `startBitch` [22:05:28] joke [22:05:29] erm [22:05:44] also uh shouldnt a OAuth app ask for like oauth creds [22:06:02] `php init.php` from the /includes/util photo [22:06:06] direcotry even not photo [22:06:31] aren't they in .env.example? [22:06:40] [1/13] ```php [22:06:41] [2/13] DISCORD_TOKEN= [22:06:41] [3/13] GUILD_DATABASE= [22:06:41] [4/13] GUILD_USERNAME= [22:06:41] [5/13] GUILDPASSWORD= [22:06:42] [6/13] OAUTH_MW_TOKEN= [22:06:42] [7/13] OAUTH_MW_SECRET= [22:06:42] [8/13] OAUTH_MW_TEST_TOKEN= [22:06:43] [9/13] OAUTH_MW_TEST_SECRET= [22:06:43] [10/13] MIRAHEZE_CLIENT= [22:06:43] [11/13] MIRAHEZE_SECRET= [22:06:44] [12/13] ``` [22:06:44] [13/13] is what I have on my version [22:06:47] maybe I have a lot that I haven't pushed yet [22:07:32] I just pushed my version to gitlab [22:08:14] of course I just pushed my client id too [22:09:15] n [22:09:37] [1/4] DISCORD_TOKEN=fuhewufi [22:09:38] [2/4] GUILD_DATABASE=gardadev [22:09:38] [3/4] GUILD_DATABASE_USER=gardadev [22:09:38] [4/4] GUILD_DATABASE_PASSWORD=bwaap [22:10:16] I need to remove that last commit from the history cba [22:10:16] I love how I got to censor my basic ass db password and almost entirely forget to actually like remove my token [22:10:28] well i just pushed my to gitlab [22:10:32] and my database credentials [22:10:35] did the values change names? [22:10:35] _crying_ [22:10:41] PFT [22:10:42] huh? [22:11:06] GUILDPASSWORD vs GUILD_DATABASE_PASSWORD [22:12:05] can I just leave the test values [22:12:28] [1/13] this is my live .evn my heads hurting: [22:12:28] [2/13] ``` [22:12:29] [3/13] DISCORD_TOKEN= [22:12:29] [4/13] GUILD_DATABASE= [22:12:29] [5/13] GUILD_USERNAME= [22:12:29] [6/13] GUILD_PASSWORD= [22:12:30] [7/13] OAUTH_MW_TOKEN= [22:12:30] [8/13] OAUTH_MW_SECRET= [22:12:30] [9/13] OAUTH_MW_TEST_TOKEN= [22:12:31] [10/13] OAUTH_MW_TEST_SECRET= [22:12:31] [11/13] MIRAHEZE_CLIENT= [22:12:32] [12/13] MIRAHEZE_SECRET= [22:12:32] [13/13] ``` [22:12:33] yes [22:13:00] oof [22:13:18] whats the diff between OAUTH and Miraheze cli/secr [22:13:31] OAUTH ones are telepedia [22:13:33] oh [22:13:49] miraheze ones aren't anywhere in the code yet, [22:14:00] (in hindsight this is not as complete as I thought it was) [22:15:24] But I don’t have a telepedia account :( [22:15:37] booooooo [22:15:44] you can create a consumer on miraheze [22:15:49] I have one [22:15:56] Actually wait no it’s on Mirabeta [22:16:02] So I’ll need to adjust the URL [22:16:42] <3 dev [22:17:09] [1/5] for testing, it needs to be a callback to: [22:17:10] [2/5] ``` [22:17:10] [3/5] http://localhost:8080/oauth/mw [22:17:10] [4/5] ``` [22:17:11] [5/5] which I have a php script I can share that inserts the verification into the database. [22:17:17] I need to move it to the actual garda repo [22:17:24] when I figure out how to remove this sensitive info :eyes [22:17:42] Did you private the whole repo [22:17:47] YES [22:17:51]