[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.

[Mathiau]

and i am one of those people who has no idea, appreciated m8!

[UltimaKing]

great hack firefly *installed*

[Matt]

FANTASTIC hack! Just what I need. Thanks

[Mathiau]

Hello m8

Does this work in version 2.2.5

When i did a search for

PHP:

<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>

i could not locat e it at all in admin/ index.php
i tried various pieces from it , but could not locate any of it...?

Frankly cause i used vbhacker, and got a error that told me to run a qeury, but i can not locate phpMyAdmin or whatever u need to run a mysql query (amm reading up now to find the answer)

WHAT AM I MISSING!!

[TECK]

VB225 Update

In admin/index.php find:

makenavoption("vBulletin Options","options.php?t=0","<br>");

BELOW this, add:

makenavoption("MySQL Query","query.php?action=enter","<br>");

Make sure you download the latest hack, located here.

[Mathiau]

wicked, thnx m8!!!!!!!!

[TECK]

you are more then welcome.

[bandersen]

Thank you for this hack!
Installed it with no problem... on 2.2.5

[pHAZE_1]

<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>

i dont have anything like that in my index.php in my admin folder.

[TECK]

did you read the update i published 5 posts above? is alot easier to read first the thread to make sure there are no updates published.
https://vborg.vbsupport.ru/showthrea...576#post241576

[pHAZE_1]

sorry i am pretty damn tired. i read the thread but must have missed that one

[erdem]

tnx for this great hack...
but i cant run this query :

INSERT INTO template (templateid,templatesetid,title,template) VALUES (NULL,-2,'memberoftheday','0||vb||0||vb||0');

is this too complex? this is for stats panel hack..

:classic:

[TECK]

try this:
https://vborg.vbsupport.ru/showthrea...threadid=37726

let us know if it helped... also try running the query without the ";" at the end, it should work on firefly's hack.

[Dean C]

Tried running the fifth query in the store hack which is this:

INSERT INTO store VALUES (1, 'username', 'Change Username', '500', '0', 'username.gif', 'With this action you can change your username', 'Y');
INSERT INTO store VALUES (2, 'customtitle', 'Change Custom Title', '300', '0', 'title.gif', 'With this action you can get a custom title and if you dont have one already then get one', 'Y');
INSERT INTO store VALUES (3, 'customavatar', 'Change Custom Avatar', '700', '0', 'avatar.gif', 'With this action you can get a custom avatar or if you already one you can change it...', 'Y');
INSERT INTO store VALUES (4, 'givetitle', 'Give an other user a custom title', '700', '0', 'givetitle.gif', 'With this action you can give an other user a custom title. The title that you give will be showed on every post of that user. <br><b>Tip:</b> Do it when that user dont have enough money to restore his custom title ', 'Y');
INSERT INTO store VALUES (5, 'donate', 'Donate money to an other user', '0', '0', 'donate.gif', 'With this "free" action you can donate money to other members.', 'Y');
INSERT INTO store VALUES (6, 'scrap', 'Scrap your yellow/red card', '700', '0', 'card.gif', 'With this action you can scrap your yellow/red card. Want to become a mod but have a yellow/red card? Do this action to begin with a new veb life ', 'Y');
INSERT INTO store VALUES (7, 'calendar', 'Add Calendar Event', '500', '0', 'calendar.gif', 'With this action you can add a public calendar event on the calendar', 'Y');
INSERT INTO store VALUES (8, 'glowusername', 'Add Glow To Username', '2000', '0', 'glow.gif', 'With this action you can add an attractive glowing color to your username wich you can define yourself. If you have already a glow then you can change it here aswell.', 'Y');


and now every time i try to run a query i get a database error...

i don't kno what to do ...

[pHAZE_1]

i have the same problem as Mist, it worked fine until the same point, now no queries work at all.. im stumped