Help wanted

spietreser · Sep 30, 2002

Hi,

I'd like to have some help with a forum I am starting. I am having troubles with setting up the forum so if anyone can help that would be GREATLY appreciated! The forum I want to use for this website is phpBB and a MySQL databse.

Specifically I need to do the following:
- installing the database
- installing the forum (i may be able to do this myself)
- customizing the forum to the design of the website

Ok, let me explain the idea. This forum will not be taking dnforum users away, but it will (!!) attract webmasters. I have the design ready (some dnforum users have already seen and really liked it

). The domain name I have for it is perfect and it is really going to be great once I get the forum going (with YOUR help)...

Thanks!

..spietreser..

Bob · Sep 30, 2002

Originally posted by spietreser
Hi,

The forum I want to use for this website is phpBB and a MySQL databse.

Specifically I need to do the following:
- installing the database
- installing the foru..spietreser..

Make sure mySQL is installed on your server.

You will need to conenct to the databse and issue the SQL to create the table structure.

Here is how to do it in PERL:

-------------------------> Start script

#!/usr/bin/perl
use DBI;
$dbh = DBI->connect("DBI:mysql:<database name here>:<database server here>","<database login name here>", "<database password here>") || die "Cannot open $DBI::errstr\n" unless $dbh;

$sql = "CREATE TABLE <TABLE NAME HERE> (
COLUMN NAME 1 DATA TYPE CONSTRAINTS,
COLUMN NAME 2 DATA TYPE CONSTRAINTS,
COLUMN NAME 3 DATA TYPE CONSTRAINTS )";

$sth=$dbh->prepare($sql);
$sth->execute;

my @tables = $dbh->Tables();

foreach (@tables) {
print qq($_\n);
}

$dbh->disconnect;

--------------------------------> End of script

As a working example, let say you have a database named "domains" and the user name is "domainuser" and password of "domains123". The database is on the same server as your website. Also assume you need to create a table called "FORUM" with the following attributes:

username - up to 50 characters
message - unlimited length
date and time posted

Your PERL script would look like this:

-------------------> start script

#!/usr/bin/perl
use DBI;
$dbh = DBI->connect("DBI:mysql:domains:localhost","domainuser", "domains123") || die "Cannot open $DBI::errstr\n" unless $dbh;

$sql = "CREATE TABLE FORUM (
USERNAME VARCHAR(50),
MESSAGE LONGBLOB,
DATE TIMESTAMP)";

$sth=$dbh->prepare($sql);
$sth->execute;

my @tables = $dbh->Tables();

foreach (@tables) {
print qq($_\n);
}

$dbh->disconnect;

-------------------> end script

Chances are that the forumscript will have all of this stuff in place already.

Hope I helped and not confsed :laugh:

-Bob