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

François http://www.fxparlant.net/Mediawiki_Calendar