SQL Query

I know there are more feature packed MySQL administrators available and you can do a lot with them. These serve their place in managing and maintaining a database. Often times though the overhead associated with them is too much when you want to run a quick query or add a field from within vBulletin.

What I did is simply edit the Query TEST script in "Professional PHP Programming" to work with vBulletin.

At the bottom and before the </BODY> tag of index.php in your admin directory add:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Then create a file called query.php and add the following code:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



The second link connects to J. Eng's Extended Status Script which is available in this forum.. Just do a search for it or look for Eva2000's signature.:)

LOL, my sig is really getting more attention that I am :) ... what does the query test php file do ?

Originally posted by eva2000
LOL, my sig is really getting more attention that I am :) ... what does the query test php file do ?

Sorry for taking so long.. I missed your reply.

It creates a form with a text box and an execute button. It will allow you to run SQL queries directly from the vBulletin Control Panel.

This makes it easy to add fields to tables quickly when installing hacks or creating your own. Also allows you to create on the fly queries when your checking stats or anything else for that matter.

cool I will try it after 2.0 is out! :)

[eva2000]

bring up from the past :D

[Wayne Luke]

This works today in any version... 1.1.X or 2.0...

I still use it on a regular basis.

[Freddie Bingham]

I stuck a note to make something like this for v2.1 as it would be helpful to have.

[eva2000]

Originally posted by freddie
I stuck a note to make something like this for v2.1 as it would be helpful to have. yup very helpful :D

[Christian]

To integrate it to the left nav bar you can add the following code to index.php:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



I put it between Custom BB codes and Backup database

That the query page is then in your cpl look (css works) create query.php with the following code:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------




But now I have a question:

You made a link to mysqlstatus.php!
Can you give the source of this file?

[SirSteve]

I get this when I click on Query:

Warning: Cannot add header information - headers already sent by (output started at /usr/www/users/gandalf/starwarsguide.com/forums/admin/query.php:6) in /usr/www/users/gandalf/starwarsguide.com/forums/admin/global.php on line 95

Warning: Cannot add header information - headers already sent by (output started at /usr/www/users/gandalf/starwarsguide.com/forums/admin/query.php:6) in /usr/www/users/gandalf/starwarsguide.com/forums/admin/global.php on line 96

Warning: Cannot add header information - headers already sent by (output started at /usr/www/users/gandalf/starwarsguide.com/forums/admin/query.php:6) in /usr/www/users/gandalf/starwarsguide.com/forums/admin/global.php on line 97

Warning: Cannot add header information - headers already sent by (output started at /usr/www/users/gandalf/starwarsguide.com/forums/admin/query.php:6) in /usr/www/users/gandalf/starwarsguide.com/forums/admin/global.php on line 98

then the query box.

[Razzie]

Remove any spaces before <? and after ?>