Hi,
I lately built a calendar extension for mediawiki 1.5+. The sql request was easy to create, thanks to the re-architecting of the database. Nevertheless, as nobody could yet help me transpose the captcha system for 1.5, I still have to stay with my oldish version of mediawiki 1.3 : I hear Rob Church gasping again:-) So, in contradiction to evolution, I now need to adapt the easy version of the calendar for mediawiki 1.3
Here is the question:
I ask for all the pages title having a link to a page whose title has an [[Dec/%/2005]] pattern.
The first difficulties is that if the page [[Dec/%/2005]] exists, it is in the LINKS table, and if it is not created it is in the BROKENLINKS
The BROKENLINKS situation seems easy to deal with: SELECT * FROM cur, brokenlinks, categorylinks WHERE ( bl_to LIKE 'Dec/%/2005' AND cur_id = bl_from AND cl_to='Blog' AND cl_from=cur_id )
The LINKS situation presents a difficulty surely overcomed by the use of aliases: I need to ask the title of a page in cur_title and at the same time the title of another page (the [[Dec/%/2005]]) in cur_title
Has anyone here any cognition of an sql / mysql syntax for this? Or better, any adaptation of the captcha system for mediawiki 1.5 :-)
Thanks for any help
wikitech-l@lists.wikimedia.org