Computer Science Canada

mod install
Author:  Nabeshin [ Fri Jul 01, 2005 5:37 pm ]
Post subject:  mod install
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
Author:  rdrake [ Fri Jul 01, 2005 9:28 pm ]
Post subject: 
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.
Author:  octopi [ Sun Jul 03, 2005 9:21 pm ]
Post subject: 
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.
Author:  CyberGeek [ Fri Sep 29, 2006 8:25 pm ]
Post subject: 
Greetings,

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

:


You can syndicate this boards posts using the file backend.php or view the topic map using sitemap.php.

Terms of Use | Privacy Policy