[00:41:33] hello, what would the best way be to query the database in order to get the revisions of a page including the size differences? [00:42:27] I see rev_parent_id gives you the ID of the previous revision, but maybe I'm not SQL-savvy enough to figure this out. Would I do a JOIN against the same table? [00:45:32] Betacommand you around? [00:46:36] my hope is do this all in one query [00:49:50] MusikAnimal: a better way is to just order the revisions by timstamp and ignore rev_parent_id entirely. [00:50:18] i'm pretty sure it doesn't get set correctly in case of imports, history merges, and such. [00:50:54] ah yes, how very simple. I just fetch rev_len and can compare between each revision [00:51:24] I knew there had to have been an easy way to do it [00:51:27] thanks! [00:57:18] MusikAnimal: yeah [01:57:36] MatmaRex: actually, I'm querying revisions_userindex to get a user's contributions, and want the size of diffs [01:57:51] so not so easy, right? [01:58:51] no idea, sorry. [01:59:30] no worries, thanks anyway [04:56:35] [[Tech]]; 1.4.164.56; [none]; https://meta.wikimedia.org/w/index.php?diff=13286687&oldid=13172252&rcid=6720436 [07:25:46] [[Tech]]; Nemo bis; Undo revision 13286687 by [[Special:Contributions/1.4.164.56|1.4.164.56]] ([[User talk:1.4.164.56|talk]]); https://meta.wikimedia.org/w/index.php?diff=13288113&oldid=13286687&rcid=6720752 [07:46:06] Phabricator admin needed to delete/disable spam account. https://phabricator.wikimedia.org/p/WP.NICKNAME.22/ [07:46:47] <_joe_> Nemo_bis: I think you're asking that in the wrong TZ :( [07:47:05] <_joe_> I mean I could go around pillaging the database, but that's not a good idea [12:23:26] Hmm, clueless question: I got an email from a hoster who cannot reach 91.198.174.192 (esams IP) anymore from their net (traceroute gets stuck) but it works from another net. So they wonder if "they are blocked". Now what to answer and how to help investigate? [12:35:54] andre__: If they're blocked at the Wikimedia level, they'll get an error code of some kind, I'm pretty sure. [12:36:01] Like an HTTP 503 or something. [12:36:20] They're welcome to join this channel and pastebin their traceroute results to debug. [12:56:10] Katie, ah thanks [12:56:11] I even have their traceroute here, I'm just reluctant to expose their IP address [14:09:21] Would any sysadmin here be willing to reset a Wikimedia account? More details at https://meta.wikimedia.org/wiki/Meta:Requests_for_help_from_a_sysop_or_bureaucrat#Forgot_password.2C_no_email.2C_requesting_account_access [14:09:44] I have always self-identified with my own account. https://en.wikipedia.org/wiki/User:Bluerasberry [14:10:44] in summary, I know User:Ejecutivo, and would like his email assigned to be neil@vbgardens.org and for him to have a password reset [14:11:00] he has no email address associated with his account [15:04:58] bluerasberry, total editcount 53? [15:08:15] @krenair yes, it is a new account. If this is a burden then I would like to not request this, because it is not too important, but there are some image uploads that I want to associate with the person's organization [15:09:13] @krenair I was thinking also - do you think that meta and Wikipedias should say that account resets are not possible? [15:09:30] this seems like an extraordinary request, but I see no policy anywhere directing people to not make it [15:10:03] There is no policy against performing these [15:10:08] It is indeed an extraordinary request [15:10:28] If you can convince one of us that it's the same actual person behind the account, the email can be changed [15:28:22] @krenair - on meta I listed the rationales. First, my identity is verified. The connection to make is user:Ejecutivo to Neil Gerlowski, neil@vbgardens.org. First, that person is executive director of the vbgardens.org and it says so on the org's page. https://www.vbgardens.org/about-us/board-directors/ I met this person in person at that organization, where he had an office and the other senior staff knew him. [15:29:05] on wiki, the proof is that the user:Ejecutivo uploaded photos listing the creator as Neil Gerlowski, and the photos were of places at vbgardens.org [15:29:49] so the wiki connection is in Commons - presenting his real name, then the off-wiki confirmation is that I met him in person when we discussed them making media donations to Wikimedia Commons [15:30:19] jere is an example upload which names him as "Neil Gerlowski" https://commons.wikimedia.org/wiki/File:Vallarta_Botanical_Gardens.jpg [15:31:35] @Krenair if that is sufficient, then nice. It is not proof with a SHA function. I have no other evidence to submit, and am happy with your judgment either way. [15:32:27] is it ok to ask for help here? i tried the "wikimedia-help" channel but there hasn't been any activity on there since i logged on and stated my question (that was more than 1 hour ago). [15:33:16] iiiiiii: depends on what you ask [15:33:24] I don't think there's a "wikimedia-help" channel [15:33:26] always okay to ask [15:33:41] hmm [15:33:46] no one is there [15:33:50] except you and me [15:33:55] (and chanserv) [15:37:50] Ok. here goes. I'm trying to get the cite-functionality to my edit-toolbar. I've been trying to use the instructions here https://en.wikipedia.org/wiki/Wikipedia:RefToolbar/2.0#Porting_to_another_wiki but I don't understand if MediaWiki:Gadget-refToolbar.js; is a code that I should add to the page "MediaWiki:Common.js" or if it's a page in itself. Maybe someone could explain the instructions if it's not too much work [15:40:51] iiiiiii: Do you have Gadget extension installed on your wiki? [15:41:09] yes. [15:41:50] ok, then create a MediaWiki:Gadget-refToolbar.js page locally on your wiki with the contents from English Wikipedia page [15:42:03] and then add an entry to MediaWiki:Gadgets-definition [15:43:53] i've done the first step. "MediaWiki:Gadgets-definition" is another page i should create? (thanks a lot for walking me through this) [15:45:34] yes [15:45:46] See https://www.mediawiki.org/wiki/Extension:Gadgets#Usage [15:54:45] bluerasberry, so I've been looking through some of the contributions [15:54:53] yes [15:54:58] certainly has a very strong tie to the gardens [15:55:12] yes, I see the same [15:55:48] I'm not completely convinced about the link to the person from just that commons file description [15:55:57] ah, Ejecutivo = executive in Spanish? [15:56:02] yes [15:56:29] I cannot say you should be convinced - SHA confirmation is what is recommended [15:57:01] Glashier: ok. I've created that page. I'm reading the page you sent me [15:59:27] Glashier: I added the follwing: refToolbar[ResourceLoader|dependencies=user.options,mediawiki.legacy.wikibits]|refToolbar.js to the page MediaWiki:Gadgets-definition [16:35:14] MaxSem, hi. [16:35:22] yo [19:09:57] Uh. Look that page "Old", it's actually [[Search/Old]]. https://www.mediawiki.org/wiki/Category:Search [19:10:38] And it's not even the keysort. O_o [19:13:59] Ah there is a FOUC, JavaScript trick somewhere? [19:15:48] www.mediawiki.org/wiki/Snippets/Hide_prefix_in_category in https://www.mediawiki.org/wiki/MediaWiki:Gadget-site.js , never noticed though [19:20:03] https://www.mediawiki.org/wiki/MediaWiki_talk:Gadget-site.js#Category_prefix_hiding [20:52:25] jdlrobson: there used to be a Wikipulse site for "most edited articles in a timeperiod" but that was back in 2005. I think you have to do a database query, but anomie might know