The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 08-23-2001

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 · #32 03-27-2002, 06:34 AM

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

UltimaKing · #33 03-27-2002, 03:24 PM

great hack firefly *installed*

Matt · #34 03-30-2002, 01:30 PM

FANTASTIC hack! Just what I need. Thanks

Mathiau · #35 04-17-2002, 02:37 AM

Hello m8

Does this work in version 2.2.5

When i did a search for

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>

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 · #36 04-17-2002, 07:23 AM

VB225 Update

In admin/index.php find:

Code:

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

BELOW this, add:

Code:

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

Make sure you download the latest hack, located here.

Mathiau · #37 04-17-2002, 07:44 AM

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

TECK · #38 04-17-2002, 07:57 AM

you are more then welcome.

bandersen · #39 04-21-2002, 02:26 PM

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

pHAZE_1 · #40 04-21-2002, 10:47 PM

Quote:

<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 · #41 04-21-2002, 10:50 PM

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05041 seconds Memory Usage 2,314KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_code (2)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!