[RELEASE v2] Run a SQL query directly from your admin contorl panel

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

PHP Code:

<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("Options"); ?>
</table>
<a href="options.php?s=<?php echo $session[sessionhash]; ?>&action=options"> Change options </a>
</td></tr>

with

PHP Code:

<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("Options"); ?>
</table>
<a href="options.php?s=<?php echo $session[sessionhash]; ?>&action=options"> Change options </a>
</td></tr>

<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("SQL Queries"); ?>
</table>
<a href="query.php?s=<?php echo $session[sessionhash]; ?>"> Run a SQL query </a>
</td></tr>

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

[Wayne Luke]

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.

[Admin]

So you're saying I wasted a day of my life?
Thanks Wayne.

[orca]

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.

Thumbs up dude

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

Thnx

-Alex

[webhost]

Thanks For the hack Firefly, This will make things alot easier.

Got a weird error. I did what you said, then when I clicked on the link on the side to add a query. It went to the page, and above it all had this:

Fatal error: Call to undefined function: getrowbg() in /usr/accountname/forum/admin/query.php on line 66

It's looking to work but what horible look (wluke file)
One small problem ... If there is HTML in table, there is not keep caracter and translate in HTML in the page ...

Sorry about my bad english

Simple, and a all around Great Feature!

Thanks...

God Bless,

[Mike Gaidin]

Great hack FireFly!!!!

I love this one. Good job!

[JJR512]

This is a good idea, but it definitely needs some way to view the output. For example, I'd like to be able to run this query and see the list it gives me:
SELECT username FROM user WHERE dct='X' ORDER BY username ASC
(Which involves a custom field in my user table.)