[09:38:42] <ankry>	 Hi. Anybody here knows new wiki creation procedures?
[09:39:52] <ankry>	 is it much complicated to reqiest adding 2-side importing permission mul <--> new_wiki for all newly created Wikisources?
[09:41:39] <p858snake>	 ankry: for the second question, there just needs to be tasks submitted for each wiki that shows community consenus for those import oprtions
[09:42:36] <p858snake>	 i'm not sure thats a option for global imports eg all wikisources to have a vertain import source by default
[09:45:09] <ankry>	 revi: p858snake community decission is another issue
[09:45:27] <ankry>	 p858snake: at the moment I am asking about technicals
[09:45:54] <revi>	 ankry: https://wikitech.wikimedia.org/wiki/Add_a_wiki
[09:47:52] <ankry>	 phuzion: as all new wikisources originate from mul.ws I think, decission of mul.ws community would be enough here, *if* such request is technically possible and acceptable?
[09:48:35] <ankry>	 AFAIK, the import mul -> new wikisource was enabled by default
[09:48:45] <ankry>	 revi: ^^^^ am I right here?
[09:48:53] <revi>	 I dunno about that one
[09:48:58] <ankry>	 or should this go to meta?
[09:49:37] <ankry>	 revi: 2 lines higher, about where a decission is required
[09:50:05] <revi>	 haven't used import @ wikisources
[09:51:04] <revi>	 and the discussion.... what does langcom say? I think they do the initial imports
[09:52:03] <ankry>	 yes
[09:52:39] <ankry>	 leter imports are needed for forgotten/misplaced pages and/or local copyright related issues
[09:53:04] <ankry>	 *later
[09:53:40] <ankry>	 So, I will as langcom first 
[15:11:33] <Gopa>	 Hello,
[15:11:33] <Gopa>	 Any node.js application on wikimedia toolforge (tools.wmflabs.org/<application>) has the OAuth facility ?
[15:15:39] <Gopa>	 I referred this https://www.npmjs.com/package/passport-mediawiki-oauth but I need any live application which is already has OAuth for reference.  
[15:22:08] <bd808>	 Gopa: Have you seen https://wikitech.wikimedia.org/wiki/Help:Toolforge/My_first_NodeJS_OAuth_tool ?
[15:23:37] <Gopa>	 Oo I'm checking through this.
[15:25:27] <Gopa>	 yeah I already saw this,  Any tools which are live with  OAuth ?
[15:26:53] <bd808>	 Gopa: the code from that tutorial is live at https://tools.wmflabs.org/nodejs-mw-oauth-tool
[15:28:35] <Gopa>	 Woow Nice, Thank you bd808 
[16:01:00] <basiclaser>	 im finding that wikidata ( graphql endpoint ) very frequently goes offline. is it usual or just me ? in a script im firing ~180 requests from which i receive in the same quantity `"request to https://wikidata.notimportant.org/graphql failed, reason: connect ETIMEDOUT 35.180.5.16:443","type":"system","errno":"ETIMEDOUT","code":"ETIMEDOUT"` 
[17:22:15] <RhinosF1>	 Anyone know why https://quarry.wmflabs.org/query/35140 returns nothing
[17:23:09] <Krenair>	 RhinosF1, shouldn't that be sysop?
[17:23:24] <RhinosF1>	 that's why
[17:23:37] <Krenair>	 also I'm not sure that's the format of the log_params field..
[17:24:06] <RhinosF1>	 I copied it from something else - let me check again
[17:25:43] <RhinosF1>	 Krenair, Still nothing so I could be completely out
[17:28:12] <Krenair>	 you've got 200904130000 but I don't think that's right
[17:28:36] <Krenair>	 yyyymmddhhmmss
[17:28:43] <RhinosF1>	 Oh, You can tell I don't do SQL can't you
[17:28:48] <Krenair>	 you're missing the second field
[17:30:48] <RhinosF1>	 Krenair, Now what would make it only show ones that are still sysops
[17:33:05] <Krenair>	 join users on log_title = user_name
[17:33:13] <Krenair>	 join user_groups on ug_user = user_id
[17:33:17] <Krenair>	 where ug_group = 'sysop'
[17:33:29] <Krenair>	 so something like this
[17:33:32] <Krenair>	 select user_name from logging join user on (log_title = user_name) join user_groups on (ug_user = user_id) WHERE ug_group = 'sysop' and log_type = "rights" AND log_params like "%sysop" and log_timestamp < 20090413000000;
[17:33:42] <Krenair>	 areas I'd be cautious of however
[17:33:44] <Krenair>	 log_params format
[17:33:57] <Krenair>	 users who lost their sysop rights and then regained them
[17:35:22] <RhinosF1>	 Okay, That showed more than I thought it would
[17:36:14] <Krenair>	 yes well as I said some of those may be dupes due to loosing and regaining rights
[17:37:18] <RhinosF1>	 Okay, Anyway to remove the dupes
[17:37:46] <Krenair>	 are you looking for people who held admin continuously for 10 years?
[17:38:22] <Krenair>	 or are you looking for people who held admin for an hour over 10 years ago and got it again last week?
[17:38:37] <RhinosF1>	 No, Who were promoted more than 10 years ago and are still a sysop now
[17:39:07] <RhinosF1>	 Doesn't matter if they've lost it during that time
[17:40:12] <Krenair>	 they could've lost it before that time too
[17:41:13] <RhinosF1>	 They could have as long as they were promoted more than 10 years ago and are an admin currently.