SQL Query from Control Panel

[JamesUS]

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

Upload attached 'query.php' file to the admin folder.
In admin/index.php, find:

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

underneath, add:

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


This hack copyright James Ussher-Smith &copy; 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 (https://vborg.vbsupport.ru/member.php?s=&action=getinfo&userid=1) already wrote and posted a similar hack to this with a little more functionality:
https://vborg.vbsupport.ru/showthread.php?s=&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?

[ExAvIoUr]

Thank you, I really need this!

[410]

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

[Brahm]

Great hack JamesUS

[S1R1US]

will this work with 2.2.9?

[animi12]

02-12-03 at 09:42 PM S1R1US said this in Post #14 (https://vborg.vbsupport.ru/showthread.php?postid=353569#post353569)
will this work with 2.2.9?

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

[user360]

cool hack.

im getting the error

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site34/fst/var/www/html/iforum/admin/query.php on line 27
Query Result - ALTER TABLE bbcode CHANGE bbcodereplacement bbcodereplacement TEXT;

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site34/fst/var/www/html/iforum/admin/query.php on line 29

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site34/fst/var/www/html/iforum/admin/query.php on line 33


im using 2.2.9

[user360]

anyone?

[monstergamer]

i get the same thing
using 2.3.0

[user360]

is JamesUS still around?

[TECK]

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

[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 (https://vborg.vbsupport.ru/showthread.php?postid=374713#post374713)
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 (https://vborg.vbsupport.ru/showthread.php?postid=210580#post210580)
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 (https://vborg.vbsupport.ru/showthread.php?postid=380438#post380438)
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?

[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/showthread.php?s=&threadid=50896&highlight=databse+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 (https://vborg.vbsupport.ru/showthread.php?postid=431653#post431653)
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.