adding statements to the database
 

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.

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.

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]

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?

Yes...

Satan

And hit enter. :)

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

Jeez :p

cool it worked...thanks for the help.