mod install

[Nabeshin]

alright i'm trying to install a mod on my forum, which is powered by phpBB, and i cant understand the first few lines of it. Someone wanna help me out please.

Quote:

#-----[ SQL ]------------------------------------------
# Change the prefix 'phpbb_' accordingly. 'phpbb_' is the default prefix
#
ALTER TABLE phpbb_forums ADD forum_postcount TINYINT( 1 ) DEFAULT '1' NOT NULL;

I have no idea whats its asking me to do.

Thanks

[rdrake]

When you install phpBB, it gives you the option of changing the prefix of the tables which it uses. The default is phpbb_, however you can change it if you have multiple installs of phpBB using the same database. If you kept the default phpbb_, then you don't need to change anything, but if you changed it, then you need to change

code:

ALTER TABLE phpbb_forums ADD forum_postcount TINYINT( 1 ) DEFAULT '1' NOT NULL;

to

code:

ALTER TABLE <yourprefix>_forums ADD forum_postcount TINYINT( 1 ) DEFAULT '1' NOT NULL;

where <yourprefix> is the prefix which you used when installing the database.

Chances are pretty good that you don't need to change that line.

[octopi]

It is also telling you to run that SQL command.

You can use a program like Mysql-Front to do this, or PHPMyAdmin if you have that installed.

[CyberGeek]

Greetings,

Many of simple mods you can use EasyMOD. I do not recommend using it, but, many of people do.