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

[Dalius]

This is VERY useful, thanks!

[Dalius]

I did exactly what it sais but....

whats with the gap?

[Lesane]

GREAT hack, thanks.

[FWC]

Originally posted by Dalius
I did exactly what it sais but....

whats with the gap?

Remove the <br> after Database Maintenance if you want that gap to go away.

[FWC]

Originally posted by JamesUS
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.

Very nice, James! I've been using Wayne's hack for months. This version looks much more vB like.

[Dalius]

Originally posted by FWC
Remove the <br> after Database Maintenance if you want that gap to go away.

thanks

[DelusionalMind]

very nice

no more firing up phpmyadmin

[Stretchr]

Nice job but unless I'm missing something, Chen already wrote and posted a similar hack to this with a little more functionality:
https://vborg.vbsupport.ru/showthrea...threadid=26272

[Ph0eniX]

I'm getting this when I click on "Run Query":

"CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:"

...any ideas?