Pablo,
I'm doing this against our MySQL and MS SQL servers via custom php
extensions. It works well & is easily incorporated within the MediaWiki
interface so none of my users is the wiser.
Regarding your specific request - the comment at the top of the
specialasksql.php code suggests that it would only work for queries against
the cur table.
" * If enabled through $wgAllowSysopQueries = true, this class
* let users with sysop right the possibility to make sql queries
* against the cur table.
* Heavy queries could slow down the database specially for the
* biggest wikis."
Al.
-----Original Message-----
From: Pablo Chamorro C. [mailto:pchamorro@ingeominas.gov.co]
Sent: Wednesday, 18 May 2005 12:44 p.m.
To: mediawiki-l(a)wikimedia.org
Subject: [Mediawiki-l] direct SQL Queries example
Could somebody please give me some details of how to do a direct SQL query?
I mean, can I use Media Wiki as a frontend for my MySQL databases?
That would be great! My wiki is on my intranet and for me a read only
access is ok. If not, how could it be managed?
thanks,
Pablo Chamorro C.
---
"Direct SQL Queries
To allow SQL queries through the wiki's Special:Asksql page, you can enable
direct SQL queries via the web interface. ..."
--
Tel: +57 (2) 7314752/3222/2595 - Fax: +57 (2) 7310514 Carrera 31 #18-07
Parque Infantil - PO Box 1795 - Pasto
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l