Extension:Asksql

From MediaWiki.org

Jump to: navigation, search

           

Manual on MediaWiki Extensions
List of MediaWiki Extensions
Crystal Clear action run.png
Asksql

Release status: stable
Implementation  Special page, Database
Description Allows SQL queries through a special page in the wiki, without opening phpMyAdmin etc.
Author(s)  Brion Vibber
Last Version  2008-01-31 (2008-01-31)
MediaWiki  1.12 and above
License GPL
Download Download snapshot

Subversion [Help]
Browse source code

check usage (experimental)

Asksql extension allows you to do SQL queries through a special page in the wiki, without opening phpMyAdmin etc.

Warning Warning: Dangerous if not configured properly!

[edit] Installation

  1. Download the latest snapshot, extract the files, and place them under extensions/Asksql
  2. Make sure you have ExtensionFunctions.php in your extensions/ folder
  3. Add $wgGroupPermissions['sysop' ]['asksql'] = true; to LocalSettings.php
  4. Add require_once('extensions/Asksql/Asksql.php'); to LocalSettings.php
  5. Go to Special:Asksql to test the extension out

This extension sets $wgAllowSysopQueries = true;, so keep that in mind. You must configure $wgDBsqluser and $wgDBsqlpassword in your LocalSettings.php though.

Retrieved from "http://www.mediawiki.org/wiki/Extension:Asksql"