Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
SQL Query from Control Panel Details »»
SQL Query from Control Panel
Mod Version: 1.00, by JamesUS (Coder) JamesUS is offline
Developer Last Online: Mar 2003 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (0 vote - 0 average) Installs: 71
Released: 02 Jan 2002 Last Update: Never Downloads: 3
Not Supported  

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

underneath, add:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Members Online in Admin Control Panel and Mod Control Panel Michael Biddle vBulletin 3.6 Add-ons 25 25 Feb 2012 21:12

Comments
  #2  
Old 02 Jan 2002, 17:13
Dalius Dalius is offline
 
Join Date: Oct 2001
This is VERY useful, thanks!
Reply With Quote
  #3  
Old 02 Jan 2002, 17:42
Dalius Dalius is offline
 
Join Date: Oct 2001
I did exactly what it sais but....

whats with the gap?
Attached Images
File Type: jpg gap.jpg (13.3 KB, 510 views)
Reply With Quote
  #4  
Old 02 Jan 2002, 17:52
Lesane's Avatar
Lesane Lesane is offline
 
Join Date: Oct 2001
Real name: Maurice
Thumbs up

GREAT hack, thanks.
Reply With Quote
  #5  
Old 02 Jan 2002, 18:22
FWC's Avatar
FWC FWC is offline
 
Join Date: Oct 2001
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
F5 Hosting
White Sox Interactive Forums
Reply With Quote
  #6  
Old 02 Jan 2002, 18:24
FWC's Avatar
FWC FWC is offline
 
Join Date: Oct 2001
Re: SQL Query from Control Panel

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.
__________________
FWC
F5 Hosting
White Sox Interactive Forums
Reply With Quote
  #7  
Old 02 Jan 2002, 19:18
Dalius Dalius is offline
 
Join Date: Oct 2001
Originally posted by FWC
Remove the <br> after Database Maintenance if you want that gap to go away.
thanks
Reply With Quote
  #8  
Old 06 Jan 2002, 23:57
DelusionalMind's Avatar
DelusionalMind DelusionalMind is offline
 
Join Date: Dec 2001
very nice

no more firing up phpmyadmin
Reply With Quote
  #9  
Old 16 Jan 2002, 16:19
Stretchr's Avatar
Stretchr Stretchr is offline
 
Join Date: Jan 2002
Nice job but unless I'm missing something, Chen already wrote and posted a similar hack to this with a little more functionality:
http://www.vbulletin.org/forum/showt...threadid=26272
__________________
Web-DJºNET Forums
www.web-dj.net/forums/
Powered by: vBulletin Version 2.2.2


It's a small world.....
But I wouldn't want to paint it!
Stephen Wright

Last edited by Stretchr : 16 Jan 2002 at 16:24.
Reply With Quote
  #10  
Old 21 Aug 2002, 02:53
Ph0eniX Ph0eniX is offline
 
Join Date: Aug 2002
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?
Reply With Quote
  #11  
Old 02 Sep 2002, 01:01
ExAvIoUr ExAvIoUr is offline
 
Join Date: Jan 2002
Thank you, I really need this!
Reply With Quote
  #12  
Old 10 Sep 2002, 16:38
410 410 is offline
 
Join Date: Jul 2002
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
Reply With Quote
  #13  
Old 09 Jan 2003, 15:29
Brahm Brahm is offline
 
Join Date: Jan 2002
Great hack JamesUS
__________________
Brahm -- nothing fancy
Reply With Quote
  #14  
Old 13 Feb 2003, 02:42
S1R1US S1R1US is offline
 
Join Date: Nov 2002
will this work with 2.2.9?
Reply With Quote
  #15  
Old 25 Mar 2003, 19:54
animi12 animi12 is offline
 
Join Date: Mar 2003
02-12-03 at 09:42 PM S1R1US said this in Post #14
will this work with 2.2.9?
I'd also like to know if this is compatible with 2.2.9. Thanks!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 09:17.

Layout Options | Width: Wide Color: