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

[Marzas]

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.

[Intex]

/me clicks Install. Thx for the hack.

[GZ_Tanis]

03-28-03 at 06:43 PM Marzas said this in Post #21
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.

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.

[GZ_Tanis]

01-02-02 at 01:36 PM Dalius said this in Post #3
I did exactly what it sais but....

whats with the gap?

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

makenavselect("Database Maintanence", );

[chavalo2]

04-11-03 at 03:28 AM GZ_Tanis said this in Post #24
To remove this gap change the code from the first post to this

makenavselect("Database Maintanence", );

Try

makenavselect("Database Maintanence");

to really correct the gap

[MarkL]

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. :$

[mmmender]

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

anyone?

[csidlernet]

Thankyou very much!

[WitchyT]

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

[MaDCaT75]

Can anyone confirm that this works correctly?