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:
underneath, add:
[/list]This hack copyright James Ussher-Smith © 2001 - 2002

This is VERY useful, thanks!

I did exactly what it sais but....

whats with the gap?

GREAT hack, thanks.

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

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

thanks

very nice :)

no more firing up phpmyadmin :)

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

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?

Thank you, I really need this!

I get this error...

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/public_html/forums/admin/query.php on line 27
Query Result - ALTER TABLE post ADD COLUMN nuked smallint(6) not null;

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/public_html/forums/admin/query.php on line 29

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/public_html/forums/admin/query.php on line 33

Great hack JamesUS

will this work with 2.2.9?

I'd also like to know if this is compatible with 2.2.9. Thanks!

cool hack.

im getting the error

im using 2.2.9

anyone?

i get the same thing
using 2.3.0

is JamesUS still around?

"The hacker cannot guarantee to provide support for this hack."

can someone add a upgrade to it so we can run sql files as well, cuz i get really ++++ed of these type of things, i'm sure its not a hard thing to do.

/me clicks Install. Thx for the hack.

I am not at all a programmer but I did notice some spaces in very unusual places. I changed the query file and everything seemd to be working now try this copy here. BTW I am using 2.3.0 and it did work for me.

To remove this gap change the code from the first post to this

makenavselect("Database Maintanence", );

Try

to really correct the gap

Yeah, I upgraded to the new query.php file, but I still get this error whenever trying to run a query...

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: Array
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array' at line 1

mysql error number: 1064

Date: Friday 25th of April 2003 01:13:12 AM
Script: harrypotter/harrypotter/admin/query.php[/url]
Referer: harrypotter/admin/query.php[/url]

Anyone know what the problem could be? :$ Plus, there goes the whole double directory thing again. i don't know why it's doing that. :$

i uploaded the new query.php file also and i'm still getting errors!

anyone?

Thankyou very much!

I'm getting errors too. :\ Although I'm not getting the double directory thing but I got the same error otherwise.

Can anyone confirm that this works correctly?

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

Very nice, thanks.

*Installed*

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.