tags you see in the second link [16:37:09] ah. the divs are what make the fancy boxes? [16:37:43] yes [16:37:49] combined with some CSS rules [16:37:51] https://www.mediawiki.org/wiki/Special:ExpandTemplates?wpContextTitle=MediaWiki&wpInput={{:MediaWiki}} [16:38:05] hitting submit on that page will expand all of the templates so you can view the full wikitext for the main page [16:39:16] as for CSS, see

-- that will apply the CSS rule at section 4 of https://www.mediawiki.org/wiki/MediaWiki:Gadget-site.css [16:39:28] specifically the one starting with #mainpage_topbox [16:40:20] if you want to put custom CSS on your own wiki, you can either do what mediawiki.org does (install the Gadgets extension, make a "site" gadget then enable it by default) [16:40:36] or you can put the CSS rules on MediaWiki:Common.css, which automatically applies to every user without needing an extension [16:40:56] hope that helps :) [17:24:09] is there any way to know how many files were modified between REL1_28 and REL1_29? [17:24:37] https://github.com/wikimedia/mediawiki/compare/REL1_28...REL1_29 [17:24:52] That seems an arbitary thing to want to measure [17:24:59] 2772 commits [17:27:07] ok, thanks [17:27:38] git diff --name-only origin/REL1_28 origin/REL1_29 | wc -l [17:27:45] 3454 [17:27:54] a lot [17:28:02] Skizzerz: thanks for the help! ill give it a go today! [17:41:56] Hi [17:42:08] Are watchllist contents stored in table? [17:42:23] I was needing to give someone else a list of titles on it... [17:42:40] ShakespeareFan00: The list of things on your watchlist are stored in the watchlist table [17:42:46] This table is not available on tool labs [17:42:50] Bother [17:43:05] Sorry, but its considered secret what pages you watch [17:43:12] bawollff [17:43:14] Thanks [17:43:24] But you can get the list from the api [17:43:32] or the "raw" edit watchlist [17:49:19] And how would someone other than myself do that in API, provided an admin had permission to do so? [17:50:38] People, I have a question about a table. [17:52:44] I had already asked it several days ago, but because my English isn't so good they couldn't answer it. [17:53:53] bawolff: Also is there a way in Quarry to group these ? https://quarry.wmflabs.org/query/16654 [17:54:22] So that I can collapse the list into a list of Index:'s to re-examine based on coincident page names... [17:54:25] ViChyavIn: Ask again, perhaps someone is here now who knows the answer who didn't previously [17:54:32] Probably would need a specalist script [17:54:41] ShakespeareFan00: You can only look up your own watchlist via the api [17:54:53] Okay that answers question 1 [17:55:06] Question 2 was about post processing a Queery [17:55:08] For question 2, how do you want to group them [17:55:08] *query [17:55:18] bawollf: By title [17:55:38] (i.e page name) and then collapse it to everything prior to the / [17:55:48] oh, by base page name [17:55:54] Yep [17:57:06] Also page quality on English Wikisource is stored inside the page text, which makes it a LOT harder to match on a query... [17:57:18] Can I erase a certain confine of the wikitable cell? [17:57:24] Greping the whole of 23000 pages would take a VERY long time... [17:57:51] And I will be filing a phab ticket on this issue shortly [17:59:35] ShakespeareFan00: is https://quarry.wmflabs.org/query/20671 what you are looking for [18:00:07] ShakespeareFan00: I thought there was a patch that added page_quality to the page_props table, but I could be mistaken [18:00:59] bawollf: Nearly exzactly :) [18:01:09] Just need a concat streing to add the index: [18:02:44] How does concat work on WMF LABS SQL? [18:05:18] It should work the same as any mysql server [18:05:45] CONCAT( "foo", page_title ) [18:05:49] https://dev.mysql.com/doc/refman/5.7/en/string-functions.html [18:05:53] Thanks : - https://quarry.wmflabs.org/query/20672 [18:06:06] That helps me improve some other queries [18:07:36] btw, I changed the table revision to revision_userindex as its faster when matching against a username (MySql is very stupid when optimizing things involving revision deletion. revision_userindex doesn't include revisions where the username has been rev deleted, which can make things much faster if you're joining on user name or id) [18:07:52] bawollf : Thanks [18:07:57] Does anybody have any thoughts concerning my question? [18:08:36] ViChyavIn: I'm not certain I understand it, perhaps an example would help [18:10:01] I'm user of the Russian Minecraft Wiki: https://minecraft-ru.gamepedia.com/%D0%A3%D1%87%D0%B0%D1%81%D1%82%D0%BD%D0%B8%D0%BA:ViChyavIn/%D0%9F%D0%B5%D1%81%D0%BE%D1%87%D0%BD%D0%B8%D1%86%D0%B0_5 [18:10:08] Do you mean you want to get rid of the border? [18:10:22] bawollf: My niave CONCAT doesn't fully account for .jpg ended items... [18:10:55] Not entirely sure how to solve the query so it does Index: concat for djvu/pdf and Page: for jpg [18:11:02] ShakespeareFan00: MySQL also has IF( some condition, do something, do something else) [18:11:05] Probably not something that's easy to do [18:11:25] Okay time to do some reading... [18:11:36] Looking like what might be need longer to termm is a stored procedure... [18:11:43] Thanks so far [18:12:03] bawolff: I want to get rid of the "border" that is located between two cells. [18:13:12] ShakespeareFan00: so you can probably use IF( instr( , "jpg" ), "page:", "index:" ) [18:13:50] Doing logic in mysql can get very complicated very quickly, you may want to consider post processing in a scripting language, or awk or something [18:13:56] bawolff: I think it's impossible since I didn't find any information about it on MediaWiki Help Wiki. [18:14:10] ViChyavIn: I think you might be looking for the rowspan attribute [18:15:12] ViChyavIn: Are you looking for a table like the one at https://www.mediawiki.org/wiki/Manual:Database_layout#Version_history where some of the cells go across multiple columns [18:15:31] err, i mean colspan not rowspan [18:16:00] err, https://www.mediawiki.org/wiki/Help:Tables#HTML_colspan_and_rowspan is a better example [18:16:03] baawollf: Didint like the qay I did it [18:16:09] https://quarry.wmflabs.org/query/20672 [18:16:14] Probbaly have a typo [18:16:58] you have an extra comma in the concat [18:18:53] Yeah [18:18:56] That was it [18:19:31] But still nto colear why this is Page: page:Broadcasting_Act_19810068_en.pdf [18:19:37] When it should be index [18:21:15] Time to rethink it [18:22:00] As it seems to NOT be yet fully working as intended [18:22:44] oh, you can't use OR like that [18:23:24] Figuired.. [18:23:25] You would have to do INSTR( ) OR INSTR( ) [18:23:32] Ah.. OK [18:23:40] This is going to be a very long query [18:23:53] And Thank you for your exceptional patientce [18:24:11] yeah, sql is a miserable language to implement complex logic in [18:25:07] when you do something like ("jpg" OR "png") sql will treat that as false (aka 0) since "jpg" is a false value and "png" is a false value [18:27:02] bawolff: I tried that attribute but it didn't suit me. All I want is to remove horizontal lines of the table, if it's possible. [18:27:14] just fyi skizzerz I dug into the anon sessions thing a bit more and anons aren't given a session until they actually make an edit it appears [18:27:34] even then the session doesn't do anything meaningful, but you can store sessiondata in it i guess [18:27:45] ah, thanks for the info [18:27:57] ViChyavIn: If its all the horizontal lines, you could try the style="border-top: none; border-bottom: none" css attribute [18:28:27] bawolff: Let me check it. [18:28:58] does anyone know if anything ever came out of the global CheckUser discussion? https://www.mediawiki.org/wiki/Admin_tools_development/Global_CheckUser [18:30:18] I know the global Abuse Filter was deployed/published, but it doesn't seem like global Checkuser went anywhere [18:30:22] bawolff: {| class="wikitable" style="border-top: none; border-bottom: none" [18:31:46] bawolff: Have I put style onto the right place? [18:33:39] No, you need to put it in the individual cell attributes [18:33:59] Okay... [18:40:01] ViChyavIn: like https://www.mediawiki.org/w/index.php?title=Project:Sandbox&oldid=2529998 [18:41:10] looks like it might need !important for some weird reason [18:43:01] bawolff: The reason is weird :) [18:43:28] It works! Oh, thank you a lot! [18:53:24] bawollf: I am going to scream in a minutye [18:53:33] I can't get this query working :( [18:59:15] https://quarry.wmflabs.org/query/20672 is as far as I got [19:00:54] ShakespeareFan00: https://www.xkcd.com/859/ :P [19:01:11] Indeed [19:01:12] ;) [19:01:22] It also one small tiny hunt the bracket [19:01:33] that makes you tear you hair out [19:01:48] code style helps [19:02:27] If you use vi, you can use the % key to find the corresponding bracket, which can help too [19:02:51] I took out what I thought was the mismatched bracket [19:02:59] It still doesn't work :( [19:03:39] you're still missing the closing bracket for concat [19:04:11] Well then I don't understand [19:04:46] .. how other people can code complex queries [19:05:15] I found the glitch eventually [19:05:30] later [19:05:32] people [19:05:34] :) [19:05:43] automatically matching delimiters in one's head is a skill honed with practise :) [19:05:53] you should see the people who like lisp [21:04:20] RFC meeting starting now in #wikimedia-office: IPv6 contributions and talk pages [21:55:30] I mediawiki but I don't manage it (I can't install new extensions). I have a bunch of variables like {{#var:myVar}} that I use on many different pages. Is there some way I can define them in a single place and use them on every page? [21:55:34] use* [21:59:29] https://stackoverflow.com/questions/18528856/site-wide-global-variables-on-mediawiki#18531125 [22:00:57] shalok: the #var: means you're probably using Extension:Variables [22:01:27] if that is the case, those are page-scoped (just like normal templates), so your only option would be to define all of your global variables in a template, and then include that template on every page [22:09:28] Okay whats the parser failing to recognise this time? [22:09:41] https://en.wikisource.org/wiki/Page:The_Cutter%27s_Practical_Guide_1898_Edition_Part_1.djvu/21 [22:09:55] Should be a 2 Column layout embeded inside a 2 column layout [22:09:59] It doesn't work [22:10:02] Suggestions? [22:22:42] Yes it displays [22:22:48] but it needs a lot of overhead [22:23:36] Would a MediaWik.org bureaucrat be able to review my URR? [22:24:23] Sorry but it seems that no one watch’s Project:Requests these days. [22:25:22] MacFan4000: checking [22:25:44] Thanks :) [22:35:05] MacFan4000: given that the request is only 2 days old, I'm not going to outright accept or reject it. I added the request to my watchlist so I will be notified on subsequent changes to it, and will take a look in a week or so once other people have had enough time to weigh in [23:49:43] Skizzerz: Thanks, I never used templates before but it worked nicely.