[00:02:03] Simetrical, that gives the same as the original query.. Though, i suspect its in the right direction [00:02:22] Reedy, it's not the same as the original query. [00:02:53] I know, but it gives the same result set [00:03:08] Maybe you didn't state your desired result clearly enough. [00:03:22] 03(mod) Encapsulate wgCanonicalNamespaceNames - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=9982 (10chinchi29) [00:03:25] 03(mod) Code quality issues (tracking) - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=700 (10chinchi29) [00:03:26] Hmm [00:04:19] Ok, for all the rows in the site table, where it hasnt got a cocount, i want 0/null (as this query is being used in a subquery) [00:05:52] http://pastebin.com/d53c1a5c1 is the required result (using a shit union duplicating the query) [00:05:53] Simetrical: How often does Wikipedia update their code trunk? [00:06:12] svip, it varies. It's been about a month and half since the last time. [00:06:17] Simetrical: Will it also be added to WatchList? [00:06:27] Sometimes it's weekly, more often lately it's been like once every couple of months. [00:06:40] The ChangesList change (adding the tooltips) will naturally apply to the watchlist too. [00:06:41] so i can use it to get http://pastebin.com/d688c9713, rather than http://pastebin.com/d4269f319 [00:06:54] Simetrical: But the legend? [00:07:11] svip, seems not. [00:07:19] Hm hm. [00:07:23] Well, that be a problem. [00:07:24] I can fix it. [00:07:30] I'll even give you diff [00:11:56] Simetrical: http://pastebin.ca/1516169 [00:12:16] *Simetrical brbs [00:12:19] 03shinjiman * r54247 10/trunk/phase3/ (103 files in 2 dirs): [00:12:19] Added back 'right-editusercssjs' message for backward compatibility, for r54194. [00:12:19] Updated messages 'right-editusercss' and 'right-edituserjs' for other languages, per Code Review on r54153. [00:16:12] 03(mod) Names given to system messages do not follow a single format - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=12131 normal->high (10chinchi29) [00:17:04] Simetrical, the left join should be what i want (from googling and looking at examples). Thanks... Have to try and work out why its not giving me the results i want [00:21:18] 03simetrical * r54248 10/trunk/phase3/includes/specials/SpecialWatchlist.php: [00:21:18] Add legend to watchlist as well [00:21:18] Patch by svip. Follow-up to r54242. [00:23:47] Simetrical: Now onward to the next challenge. [00:23:53] Paging for for Recentchanges. [00:28:20] You're going to want to look into IndexPager for that. [00:28:38] hey... when using special:import or export... [00:28:51] How do I export the TEMPLATES for cite on an article, but not the articles themselves? [00:29:15] I'm trying to grab the pretty cite web, etc. templates from the en.wikipedia fish oil page. [00:29:30] AHA! [00:29:44] Simetrical, SELECT site.siteid, COUNT(articleid) AS cocount FROM site LEFT JOIN articles ON (articles.siteid = site.siteid AND checkedout >= DATE_SUB(NOW(), INTERVAL 3 HOUR)) GROUP BY site.siteid ORDER BY site.siteid DESC; [00:29:48] Does what i wanted :) [00:30:00] Thanks [00:32:50] Simetrical: Except, IndexPager uses article names for paging. RecentChanges is gonna use dates for paging. [00:32:54] *svip puts on sunglasses. [00:33:01] svip, IndexName uses anything for paging. [00:33:08] And you should use rcid for paging here, probably, since it's unique. [00:33:11] Er. [00:33:14] IndexPager uses anything for paging. [00:33:18] Are you drunk? [00:33:34] Hm. You don't do a mean drunk. [00:33:47] Anyway, I dunno. I realise that date may not be unique as well. [00:34:04] But would the overlap really kill people? [00:34:16] I mean, it's not like you can keep on Wikipedia anyway? [00:34:31] 03(mod) mainpagetext message uses deprecated markup - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=19858 normal->high; +easy (10chinchi29) [00:35:13] <^demon> svip: It's really easy to have duplicate timestamps on places like wikipedia. Bad way to page :-\ [00:35:37] Using any non-duplicate key is a bad way to page. [00:35:38] Everyone is against my creative thinking. [00:35:41] It risks failing in some cases. [00:35:56] Simetrical: What [00:36:01] Don't you mean the other way around? [00:36:03] Creativity is a liability with a beast like the pedia [00:36:05] . . . [00:36:05] hehehehe [00:36:07] Yes. [00:36:10] I'm clearly not very awake tonight. [00:36:12] <^demon> Rc_id is pretty sane here for paging. [00:36:12] 03shinjiman * r54249 10/trunk/phase3/languages/messages/ (5 files): Localisation updates Cantonese, Chinese and Literary Chinese [00:36:29] and if you want to rewrite something else to use Pager, whatlinkshere has been partially broken since pretty much forever [00:36:45] 03(mod) mainpagetext message uses deprecated markup - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=19858 high->normal; +comment (10innocentkiller) [00:36:52] <^demon> MrZ-man: ++ [00:37:11] Can I request a "whatdoesntlinkherebutshould" page? [00:37:29] Or "whatlinksherebutprobablyshouldnt"? [00:37:31] https://bugzilla.wikimedia.org/show_bug.cgi?id=9487 [00:39:02] MrZ-man: That's a silly bug. [00:39:17] <^demon> Simetrical: What does HTML5 say we should use instead of ? [00:39:27] [00:39:38] Seriously, ticket systems like this needs a level called "this bug has been here too long, someone better fix it NOW" [00:39:45] Simetrical: CSS. [00:39:54] ^demon, you would normally use something like

, , or , depending on why you want it to be big. [00:39:58] [00:40:02] Same as any other presentational element. [00:40:07] <^demon> Hm. [00:40:10] everything works except the "previous" links. The "previous" links work once, then break [00:40:19] *Simetrical realizes he didn't set his watch for the dryer, and therefore has no idea when he should go down to get his clothes. Drat. [00:40:31] Simetrical: Code naked instead. [00:44:54] ok [00:54:29] 14(INVALID) Math.php problem -- > Failed to parse (PNG conversion failed; check for correct installation of latex, dvips, gs, and convert) - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=4705 +comment (10innocentkiller) [00:56:13] Simetrical: Just so I know, if I *ever* get a commit account or whatever, will it be a problem if my prefered name there is not my Wiki account? [00:56:24] svip, nobody cares if you even have a wiki account. [00:56:29] Woo! [00:56:31] svip, have you requested commit access? [00:56:35] I have not. [00:56:41] k. [00:56:46] And I am not going to until I feel it is necessary. [00:57:01] I am the kind of guy who prepares himself. [00:57:03] Unless I do not. [00:58:11] Simetrical: If this work continues, you know, I might request it. [00:58:18] But right now, I am requesting to go to bed. [00:58:29] *Simetrical grants permission for svip to go to bed [00:59:17] *^demon !votes no. Not enough time logged in #mediawiki today. [01:00:01] Well, I defying the vote and going to bed. [01:00:11] *GreenReaper invokes WP:!VOTE and sends svip to bed. [01:00:22] There, we have consensus! [01:00:29] no we don't [01:00:47] *GreenReaper edits cirwin's and ^demon's statements so that we do. [01:01:06] <|sock3> blahalblababahlah and your face [01:01:19] This channel is turning into #wikipedia [01:01:22] O_O Hot damn [01:01:33] 03(mod) Patch for OggHandler to output