adding statements to the database

[Marty McFly]

im trying to add on to karatekid's banner hack, and in the instructions it tells me:

----------------------------------
####
a) # Do the following statement on your vb-database:
####

ALTER TABLE forum ADD banner_id int(11) not null AFTER styleoverride
----------------------------------

how do i add statements to my database? thx in advance.

[filburt1]

One of the three:

1. Use (IIRC Chen's) hack that lets you execute MySQL statements from the admin CP
2. SSH/Telnet into your site, and type mysql -uusername -ppassword dbname where username, password, and dbname are their respective values in vB's config.php
3. Install PMA (http://phpmyadmin.sourceforge.net/) and use it.

[filburt1]

Also if you typed your query surrounded by [sql] tags, you'd see this :

[sql]ALTER TABLE forum ADD banner_id int(11) not null AFTER styleoverride[/sql]

[Marty McFly]

ok, i have the CP sql hack installed....but i dont really know how to use it. do i just put that statement into the The Query You Want To Run window?

[Chris M]

Yes...

Satan

[Boofo]

And hit enter.

[filburt1]

Then get a hot dog and pat yourself on the back.

Jeez

[Marty McFly]

cool it worked...thanks for the help.