SQL Query from Control Panel

This hack allows you to execute custom SQL queries from the control panel.

I know there are one or two other hacks that do this but this one is different in that it can also cope with 'SELECT' queries. Results are displayed in a table for select queries. Inspired by wluke's older version of this hack for vB 1.1.x, I have been using this succesfully for a few days now on my own forums.

Instructions[list type=1][*]Upload attached 'query.php' file to the admin folder.[*]In admin/index.php, find:

PHP Code:

makenavselect("Options","<hr>"); 


underneath, add:

PHP Code:

makenavoption("Run Query", "query.php?t=0");
makenavselect("Database Maintanence", "<br>"); 


[/list]This hack copyright James Ussher-Smith © 2001 - 2002

[lasto]

this one in this post works fine on 2.3

also read the full posts as it tells you info you need to know

https://vborg.vbsupport.ru/showthrea...atabse+queries

[StrykerContact]

Very nice, thanks.

*Installed*

[StrykerContact]

I am having problems, none of the queries I have ran work, I am going to uninstall this and replace it with fireflys. Sorry.

[lasto]

Today at 01:02 AM StrykerContact said this in Post #33
I am having problems, none of the queries I have ran work, I am going to uninstall this and replace it with fireflys. Sorry.

nothing to install ! just delete it from the admin folder thats all as its a stand alone and its runs every query ive thrown at it.