[00:59:29] has anybody else had trouble uploading to Commons ? [02:33:10] Hi. This is a MediaWiki AND Wikipedia question... If I create a local MediaWiki installation is there any way to get a full extract of a single Wikipedia page/talkpage pair including all visible page versions and history ? [02:34:33] I am trying to do a detailed analysis of the history of a contentious page and would rather do so locally. [02:35:30] F6697: Yes [02:36:39] p858snake: :) ... would you elucidate ? [06:36:48] Is anyone up and about? Could you tell me the longest non-indef block currently enacted on en.wikipedia? [06:38:30] ToAruShiroiNeko: I saw one that was set at a million hours [06:38:34] to expire in the 22nd century [06:47:56] ToAruShiroiNeko: could you not do that query on labs? [06:49:13] I already have [06:49:33] but posted on both places anyways since that place seems inactive atm [06:49:51] errr? i mean sql query... [06:50:06] I dont know how the database looks to draft a query [06:50:21] you should connect and inspect it then [06:50:50] I doubt I have access [06:50:53] why? [06:51:00] I never requested it [06:51:13] I have dectected over 20,000 indefinite blocks on en.wikipeida which I compiled a list. I am curious about the long term blocks that are finite [06:51:28] a 60 year block is kind of indefinite [06:53:47] do you have access to the tools project? [06:54:52] I dont even know what that is [06:55:28] well you should go find out [06:55:31] I am currently running really complicated experiments and would really appriciate the information I requested [06:58:08] ToAruShiroiNeko: https://en.wikipedia.org/wiki/Wikipedia:Database_reports [07:00:20] ToAruShiroiNeko: You can use Special:BlockList or something, I think. [07:00:24] https://en.wikipedia.org/wiki/Wikipedia:Database_reports/Unusually_long_IP_blocks [07:00:35] ToAruShiroiNeko: Though the answer is obvious enough... it's indefinite. [07:00:49] I can but I cant sort the special page [07:00:53] Oh, non-indef. [07:00:59] Really? [07:00:59] oh. [07:01:02] https://en.wikipedia.org/wiki/Special:BlockList?wpTarget=&wpOptions%5B%5D=userblocks&wpOptions%5B%5D=rangeblocks&limit=500 [07:01:02] I think that field is indexed. [07:01:10] it is but not sotrable in the UI [07:01:16] Interesting. [07:01:20] File a bug? :-) [07:01:20] I already filed a bug on it like 6 months ago I think [07:01:21] Have you tried the API? [07:01:35] Do you have a link? [07:01:41] sure [07:01:42] one sec [07:03:05] well maybe more than one sec [07:05:21] cant find it [07:05:53] I file a lot of bugs that get forgotten [07:06:13] https://bugzilla.wikimedia.org/buglist.cgi?quicksearch=rep%3Ato.aru.shiroi.neko block [07:06:31] err, that is: https://bugzilla.wikimedia.org/buglist.cgi?quicksearch=rep%3Ato.aru.shiroi.neko%20block [07:07:13] it is probably closed or forgotten [07:07:21] Interesting. [07:07:33] or maybe I remember wrong [07:07:51] then, https://bugzilla.wikimedia.org/buglist.cgi?quicksearch=ALL%20rep%3Ato.aru.shiroi.neko%20block [07:09:35] https://bugzilla.wikimedia.org/show_bug.cgi?id=52825 [07:09:36] ah there [07:09:44] "Also, it may be worthwhile to covert the output to a table similar to [07:09:44] Special:BlockList. [07:09:49] wich is sorted [07:10:22] no it isnt [07:10:24] I am confised [07:10:35] can I just get the blocked IPs? [07:11:42] top 10 would do [07:12:37] i'm unsure how your question is unsatisfied by existing DB reports [07:13:18] I cant decipher it for starters [07:13:30] try harder [07:13:43] try ctrl-f + "block" [07:13:43] ohm... [07:14:14] and i expect you to already have tools access next time you ask for something. :-) [07:15:38] I dont see a length [07:16:16] I am still trying to picture it in my mind [07:16:37] is expiry really insufficient? [07:16:51] it gives me some fairly interesting numbers [07:17:04] but length depends on timestamp too [07:17:13] I suppose I can toss it to excel [07:17:18] ok, sounds like simple math... exactly [07:17:53] you are under the impression I am capable of simple math. I am dumb remember. [07:17:54] :p [07:18:48] $ ls -1A ~/public_html/.scratch | perl -lne 's|^|https://tools.wmflabs.org/jeremyb/.scratch/| && print if /^\.enwiki(_p)?\.mysqldump-nodata\./;' [07:18:51] https://tools.wmflabs.org/jeremyb/.scratch/.enwiki.mysqldump-nodata.1388300298.sql [07:18:54] https://tools.wmflabs.org/jeremyb/.scratch/.enwiki_p.mysqldump-nodata.1388300096.sql [07:19:06] ToAruShiroiNeko: $ which bc [07:19:06] /usr/bin/bc [07:19:15] bc can help you with the math [07:19:24] or as you say mysql [07:21:38] gah [07:21:43] as you say excel* [07:21:46] i must be sleepy [07:22:43] ToAruShiroiNeko: anyway, see links above, and go get yourself a damn tools acct [07:22:45] trying to format data on excel [07:23:12] source code is published (see "configuration" links). you can modify and run your own copy [07:23:16] * jeremyb runs away [07:28:35] still googling for it [07:28:45] its going to take me hours probably [07:31:52] Gloria would you know how to do this? [07:33:07] not even home one day and Gloria getting dragged bac into things,,, [07:34:57] I have no idea [07:35:14] I just need something probably simple for you would take my hours to figure out [07:39:43] ToAruShiroiNeko: What's wrong with the database report? [07:40:01] https://en.wikipedia.org/wiki/Wikipedia:DBR#Blocks [07:40:04] I need the length of the block [07:40:07] > Unusually long IP blocks [07:40:10] Isn't that what you want? [07:40:16] yes [07:40:21] but thats two blocks of timestamps [07:40:22] https://en.wikipedia.org/wiki/Wikipedia:Database_reports/Unusually_long_IP_blocks [07:40:27] So subtract the two, heh. [07:40:42] I cannot figure out a way to display it in years month and days [07:40:50] Learn to do that, then. [07:40:54] Do you know a programming language? [07:41:01] Nearly any can do this. [07:41:14] Python, Perl, etc. [07:41:17] I really have other issues to attend to. I am working on a very complicated learning algorithm and I really dont have the time [07:41:36] if you people dont want to help just say so. [07:41:36] You're working on na complicating learning algorithm and you can't write a ten-second script? [07:41:45] its not a ten seconds script [07:41:47] na --> a [07:41:54] I dont even know what that is [07:41:56] To do simple subtraction? [07:42:04] sure and I get a new time stamp [07:42:09] Right. [07:42:17] You don't have to do anything to the timestamps. [07:42:23] Because they're already integers. [07:42:32] divid it and such sure [07:42:49] forget it [07:42:52] clearly its not trivial [07:42:55] There's probably a wiki template to do this. [07:43:05] Did you look? [07:43:14] as I said I cant spend more time on this [07:43:16] sorry [07:43:18] just forget it [07:43:19] I forgive you. [07:43:31] The algorithm awaits. [07:43:33] arrogance knows no bounds here I see. [07:43:54] Nor helplessness. ;-) [07:46:38] http://stackoverflow.com/questions/6574329/how-can-i-produce-a-human-readable-difference-when-subtracting-two-unix-timestam?answertab=votes#tab-top [07:48:08] Though I'm not sure why you want human readable timestamps. [07:48:16] I'd think the second difference would be easier for sorting. [07:48:18] * Gloria shrugs. [07:48:54] If you just want to use that table, you can just copy and paste it into Excel or another spreadsheet program. [07:49:09] Any decent spreadsheet program can accept copied and pasted data like that. [07:49:15] Then you can do the subtraction. [07:49:26] Gloria: Go do something else. [07:51:43] Gloria: You're sure you don't want to keep shouting at the void? I find it to be therapeutic sometimes [11:46:16] Hi I have a few questions about Template protections and purging [11:46:26] Is there anyone who can answer me? [12:02:21] tos: Welcome to irc. Please don't ask if you can ask, just ask your question and see if someone answers it :-) [12:03:18] Thanks multichill. I knew that already, but I was waiting for someone to answer so I could just have a one-on-one chat to clear some things [12:03:39] multichill: Would you be knowing about these enough to do something? [12:04:02] I don't know nothing, I'm from Barcelona [12:04:38] Oh. Nevermind. [12:04:44] * tos waits for someone else to answer [12:15:21] tos: i'd be answering your question already if you bothered to ask [12:15:37] (no, i probably don't have time for "one-on-one chat") [12:15:49] it's sunday, don't expect crowds here [12:15:52] Alright, and sorry. [12:16:06] First, what is purging. [12:17:05] re-rendering the HTML of the page from its wikitext, as well as updating information like internal links, category contents, etc. [12:17:17] !purge [12:17:17] To purge a cached page, such as when making changes to the navigation bar, add &action=purge to the end of the page url, or ?action=purge if using Simple URLs. E.g: http://en.wikipedia.org/wiki/Main_Page?action=purge [12:17:43] So if I change a template, what do I need to purge to make sure any pages transcluding it have the updated version of the template? [12:17:50] the template or all the pages? [12:18:16] nothing, they'll be purged automatically [12:18:22] tos: that should be automatic, but if necessary, you can manually purge the pages that transclude the template [12:18:22] it just might take some time [12:18:56] I understand. I meant for immediate purging. THe one where one does not have to wait for the job queue [12:21:42] And when I purge a page, is it updated only for me, or for everyone else too? [12:22:26] everyone [12:24:37] Sorry I got dc [12:24:59] Does my purging a page updates it for everyone or just for me? [12:26:01] everyone [12:26:57] Okay. I remember a case where I was seeing one version of the page, and another reader saw a different one [12:27:15] Do you have any idea why that could be? Something to do with cache maybe? [17:57:31] [[Tech]]; Parallel ocean; /* Why can't the abuse filter log be viewed.... */ new section; https://meta.wikimedia.org/w/index.php?diff=6883328&oldid=6772422&rcid=4778591 [19:52:41] heads up on the bug request for a private AffCom mailing list - we have rather immediate use for it - so I am willing to bribe folks with free beer at WM14 :) [21:09:48] [[Tech]]; QuiteUnusual; /* Why can't the abuse filter log be viewed.... */; https://meta.wikimedia.org/w/index.php?diff=6885029&oldid=6883328&rcid=4779099 [21:40:39] [[Tech]]; Parallel ocean; /* Why can't the abuse filter log be viewed.... */; https://meta.wikimedia.org/w/index.php?diff=6885215&oldid=6885029&rcid=4779115 [21:52:16] [[Tech]]; Parallel ocean; [none]; https://meta.wikimedia.org/w/index.php?diff=6885287&oldid=6885215&rcid=4779125 [21:53:33] v_a_: your SSL connection seems to have some issues [21:53:47] lots of [21:53:49] 22:19 -!- v_a [~vigorous_@wikimedia/vigorous-action] has quit [Read error: error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number] [23:47:34] Has the WMF tried to get enwp.org transferred to them? [23:54:10] I doubt they'd tell around too much, but you can ask in private [23:54:27] IMHO using such shorteners is very inconsiderate