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 ;):
ALTER TABLE forum ADD banner_id int(11) not null AFTER styleoverride
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. :)