https://bugzilla.wikimedia.org/show_bug.cgi?id=14971





--- Comment #16 from Ramac <[email protected]>  2009-01-19 15:13:22 UTC ---
This extension executes only a query.

These queries are exectued as now (without patch):

Wikitext:
<dynamicpagelist>
category=Test
</dynamicpagelist>

Executed query:
SELECT page_namespace, page_title, c1.cl_timestamp FROM `mw_page` INNER JOIN
`mw_categorylinks` AS c1 ON page_id = c1.cl_from AND c1.cl_to='Test' WHERE 1=1
AND page_is_redirect = 0 ORDER BY c1.cl_timestamp DESC

Wikitext:
<dynamicpagelist>
category=Test
ordermethod=lastedit
</dynamicpagelist>

Executed query:
SELECT page_namespace, page_title, c1.cl_timestamp FROM `mw_page` INNER JOIN
`mw_categorylinks` AS c1 ON page_id = c1.cl_from AND c1.cl_to='Test' WHERE 1=1
AND page_is_redirect = 0 ORDER BY page_touched DESC

The new code (with the patch) would execute this query:

Wikitext:
<dynamicpagelist>
category=Test
</dynamicpagelist>

Executed query:
SELECT page_namespace, page_title, c1.cl_timestamp FROM `mw_page` INNER JOIN
`mw_categorylinks` AS c1 ON page_id = c1.cl_from AND c1.cl_to='Test' WHERE 1=1
AND page_is_redirect = 0 ORDER BY page_title DESC

Hope this is what you need!


-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to