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:
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! :)
bring up from the past :D
This works today in any version... 1.1.X or 2.0...
I still use it on a regular basis.
I stuck a note to make something like this for v2.1 as it would be helpful to have.
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
To integrate it to the left nav bar you can add the following code to index.php:
You made a link to mysqlstatus.php!
Can you give the source of this file?
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