Register Members List Search Today's Posts Mark Forums Read

Closed Thread
 
Mod Options
[RELEASE v2] Run a SQL query directly from your admin contorl panel Details »
[RELEASE v2] Run a SQL query directly from your admin contorl panel
Mod Version: 1.00, by Chen (Member) Chen is offline
Developer Last Online: Mar 2009 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: 56
Released: 24 Aug 2001 Last Update: Never Downloads: 3
Not Supported  

Description:
I see a lot of people here who are trying to fix a problem or install a hack, sometimes requires them to run a SQL query on their database, and just don't know quite how.
I know you can use Telnet, but not everyone has access, and I know there's phpMyAdmin, but who needs all that when you just need to update a table or add a field.
Of course running select queries with this is not very useful, but I'm working on changing that.


Main Features:
- Run a single query
- Run multiple queries
- Option to show / not show query after execution
- Confirmation page


Demo:
1.

2.

3.

4.



Installation:
1. Unzip query.php from the attached zip file and upload to your admin folder.

2. In index.php (under your admin folder), replace

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

with

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


That's it - can it get any more simple?
Feedback, requests, future ideas and anything else is more than welcome.

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.
Comments
  #2  
Old 24 Aug 2001, 10:08
joecrow
Guest
 
kool thanks for the hack m8 keep up the good work.
  #3  
Old 24 Aug 2001, 10:08
Bane's Avatar
Bane Bane is offline
 
Join Date: Oct 2001
Great Idea FireFly! Off to install this one Great thinking.
__________________
Bane
talkloud Network - Forums never smelled this good.
el coolo hacko - vbStats


vBORG Chat - Hang with the price of poop flinging *monkey sound* (irc.devcore.co.uk port 6667 - channel: #vBorg)
  #4  
Old 24 Aug 2001, 11:20
orca's Avatar
orca orca is offline
 
Join Date: Oct 2001
Agree with Bane

/me is off installing...
__________________
Ueli von Ah
  #5  
Old 24 Aug 2001, 11:32
orca's Avatar
orca orca is offline
 
Join Date: Oct 2001
Worked like a charm. But I have a suggestion:

If I want to run a query which gives a result, e.g. the example query from mySQL

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

it should display the result. Now it only repeats the query again since I set this option to yes.
__________________
Ueli von Ah
  #6  
Old 24 Aug 2001, 12:34
Chen's Avatar
Chen Chen is offline
 
Join Date: Sep 2001
Thanks all for the comments.

Originally posted by FireFly
Of course running select queries with this is not very useful, but I'm working on changing that.
Orca, I'll see what I can do.
(btw, are you a female or a male? I've been wondering for days now )
__________________
Chen Avinadav
Formerly vBulletin.org Owner and Founder

[email protected]
  #7  
Old 24 Aug 2001, 16:15
Thomas P's Avatar
Thomas P Thomas P is offline
 
Join Date: Oct 2001
As far as I know he's male (right?)
Great hack btw
-Tom
__________________
www.MCSEboard.de
MCP / MCSA / MCSE Board
dedicated to Windows 2000 / XP / 2003 Server & Windows Vista.
German Windows Server & Backoffice Community, Microsoft Community Partner (CLIP), MVPs inside.
  #8  
Old 24 Aug 2001, 16:15
eva2000's Avatar
eva2000 eva2000 is offline
 
Join Date: Oct 2001
interesting hack..
__________________
  #9  
Old 24 Aug 2001, 16:51
butty butty is offline
 
Join Date: Nov 2001
great hack, so easy 2 install even me gran could have installed it!!
  #10  
Old 24 Aug 2001, 22:16
Chen's Avatar
Chen Chen is offline
 
Join Date: Sep 2001
I've been working on this alot today.
I wanna go to sleep, and I don't have time to create new screen shots, edit posts and such, so I'm just going to post this new file here and when I wake up I'll sort everything.

This has support for basic queries, such as

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

Basically almost everything, except for AS. Don't try using AS, it will not work.

To install this simply upload the new file and overwrite the old one.

A basic screen shot is available in the zip file. *yawn*

Please post any feedback and suggestions about this, so I could fix / add anything to the new re-release! Thanks!
Attached Files
File Type: zip newqueryhack.zip (6.8 KB, 498 views)
__________________
Chen Avinadav
Formerly vBulletin.org Owner and Founder

[email protected]
  #11  
Old 24 Aug 2001, 23:19
Wayne Luke's Avatar
Wayne Luke Wayne Luke is offline
 
Join Date: Jan 2002
Real name: Wayne
This isn't as fancy but it can run every query MySQL can process. It gives columnized results and it works on all versions of vBulletin. This is probably my first hack ever for vBulletin and I have been using it successfully for the last year.

Just rename it query.php and put a link for it in index.php.
Attached Files
File Type: txt query.txt (1.3 KB, 371 views)
__________________
Wayne Luke
Get started with your own social network. Purchase and download vBulletin today.
  #12  
Old 25 Aug 2001, 08:26
Chen's Avatar
Chen Chen is offline
 
Join Date: Sep 2001
So you're saying I wasted a day of my life?
Thanks Wayne.
__________________
Chen Avinadav
Formerly vBulletin.org Owner and Founder

[email protected]
  #13  
Old 25 Aug 2001, 09:18
orca's Avatar
orca orca is offline
 
Join Date: Oct 2001
Originally posted by FireFly
Orca, I'll see what I can do.
(btw, are you a female or a male? I've been wondering for days now )
Just checked: Still all male.
__________________
Ueli von Ah
  #14  
Old 25 Aug 2001, 12:50
Pie'oh'pah
Guest
 
Thumbs up

Thumbs up dude

This is some serious hack! Small, easy to do and running fine!

Thnx

-Alex
  #15  
Old 25 Aug 2001, 17:51
webhost's Avatar
webhost webhost is offline
 
Join Date: Oct 2001
Thanks For the hack Firefly, This will make things alot easier.
__________________
Real Web Host
RWH Forums
Email Us Here
Closed Thread


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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 05:34.

Layout Options | Width: Wide Color: