[00:44:51] are possible violations of the privacy policy (by mediawiki) considered "security issues"? [00:45:55] Potentially, I'd err on the side of caution with that [00:46:27] It's a lot easier to unhide a non-security issue than it is to hide a security issue after other people have seen it [00:47:37] thanks AntiComposite, my other option would be a different group with limited access, not public [00:48:13] but I'll start with the security form until someone finds it a better project tag [07:12:26] Anyone know why substitution is failing on en-wiki? See https://en.wikipedia.org/wiki/Draft:Andre_Koo and https://en.wikipedia.org/wiki/User:Koodre/sandbox [07:36:14] ^ Fiked as T218387 as go to go [07:36:14] T218387: Template subst failing on enwiki - https://phabricator.wikimedia.org/T218387 [09:20:06] [[Tech]]; Hugo.arg; /* Bot script for demographic histograms at lt.wikipedia */ new section; https://meta.wikimedia.org/w/index.php?diff=18936042&oldid=18933950&rcid=13305794 [12:11:24] is there any way to specify a dependency in extension.json on an extension that is registered the old way (i.e. with a php file not with extension.json)? [15:48:43] mvolz: what do you mean exactly ? You should be able to use both of them just fine.. (i do believe you need to register via php using the correct hook however RLRegististerModules) [15:52:00] You can't check if an extension is loaded via the extensionregistry if it only has a PHP entry point.. [15:52:34] and as such, you can't do a depends on it either in extension.json [15:59:19] Is there a way to filter editors without edits in last 5 years from this page?https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Apple_Inc./Subscribe [17:26:54] 15:59:19 Is there a way to filter editors without edits in last 5 years from this page?https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Apple_Inc./Subscribe [17:26:54] Can someone advise?? [17:28:45] Manually... Or else via API calls or an sql query via quarry [17:30:15] A query to get the list - I don't mind manually removing them reedy. [17:35:19] reedy, any advice? [18:26:28] Any update?? https://www.irccloud.com/pastebin/f0Fraa8V/ [18:31:35] Update on what? [18:32:00] Is something unclear? [18:33:15] andre_ on how to proceed, I'm still unsure how to actually do it? [18:33:20] Not good at SQL [18:47:20] RhinosF1: You can proceed by either trying to use the API, or by waiting for someone to adjust the SQL query to add a "AND rev_user_text NOT IN (SQL ...)" part that queries for users with a rev_timestamp after 2014. [18:47:47] err, replace "SQL ..." by "SELECT ..." [18:48:05] you could try :) [19:25:41] andre_ never saw your ping, not good with SQL so I'll wait for someone. [19:28:05] Reedy, andre__: so how do we just make the list of each of those who have or haven't edited enwp in X time? [19:28:53] would someone be able to give the exact command to do it? i can refine a list using bash if i need to. [19:41:44] dtm: My guess would be to add something like and rev_user_text not in(select rev_user_text from [...all the stuff in the main query...] where rev_timestamp > [...whatever epoch date was five years ago...] [19:42:09] That's just from looking at the existing query. Dunno. Haven't tried and never played with SQL on the MW DB. [19:48:35] andre_ I want a new query that checks https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Apple_Inc./Subscribe for editors with no edits in last 5 years. [19:48:59] RhinosF1: and I already outlined how to do that in theory [19:49:19] not sure why you tell me again :) [19:50:24] I'm not sure how to get it to check against https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Apple_Inc./Subscribe though and pull their last contributions. [19:50:32] ^ andre_ [19:50:40] RhinosF1, what is "it"? [19:51:40] Oh, I did not realize that this is about a "Subscribe" sub page and not the category in general. I'm sorry! [19:51:52] <3 [19:52:07] Meh. Ignore my comment above, in that case :( sorry [19:52:09] andre__: yeah we're just trying to minimize spam or whatever :D [19:52:11] No problem, andre_ it was referring to quarry [19:52:23] if you wouldn't mind maybe testing the theory for some noobs here [19:52:37] we're just trying to restart a wikiproject. [19:54:09] i already did the sed, cut, sort, uniq, etc in bash but i dont know sql [20:19:39] andre__: also do you know how to get a list of the most recent editors of a list of articles? basically I'm wanting to expand that subscription list to people who are already editing in articles within Wikiproject Apple [20:20:05] they dont need to be the most prolific, just the most recent [20:25:46] i'd favor those who have edited recently on many articles [20:30:06] dtm: https://www.mediawiki.org/wiki/API:Revisions [20:31:34] dtm: combined with https://www.mediawiki.org/wiki/API:Categorymembers for Category:WikiProject_Apple_Inc. [20:34:41] For the amount of people... It'd almost be easier to just take the list, copy it elsewhere, turn it into a list of Special:Contributions/ links [20:34:45] And then open each in a tab [21:39:13] Your garden variety "open all in tabs" browser extension can do wonders :)