Ragazzi, vi prego aiuto! Ho scaricato SEO_BOARD, un buon forum che necessita di MySQL. Ho creato un normalissimo database. Ho impostato le variabili come richiesto dagli script, ma niente. Quando apro il file install.php (che installa il forum) mi esce scritto "Database Error". Io uso EasyPHP.

Vi supplico aiutatemi! Ecco il file della configurazione:

codice:
<?php

$dbhost = 'localhost';
$dbname = 'forum';
$dbuser = 'root';
$dbpass = '********';
$dbpref = 'seo_board_';

$adminfile = 'admin.php';
$adminuser = 'staff';
$adminpass = '********';
$adminemail = 'mondomgs@katamail.com';

//don't change this AFTER installing the board. You can change it before installing.
$shaprefix = 'This is the default sha hashing prefix.';

$forumhome = 'http://mondomgs.altervista.org/forum/index.php'; //link to forum home
$forumdir = 'http://mondomgs.altervista.org/forum/'; //forum dir without the script file, must end with a '/'
$forumscript = 'http://mondomgs.altervista.org/forum/index.php'; //forum dir + script file

$cookiedomain = '';
$cookiename = 'seo-board';
$cookiepath = '';
$cookiesecure = FALSE;

$enablegzip = 0; // 0 - no; 1 - yes

$visittimeout = 600;
$usereditposttimeout = 1200;

$forumtimezone = 2; // default forum zone

$registermode = 1; // 1 - register user immediately; 0 - send an e-mail with generated password

$forumtitle = 'Mondomgs Forum';

$lang = 'eng';

$invalidusernames = array('Anonymous', 'Guest');

$maxwordlength = 60;
$maxpostlength = 20000;

$postsperpage = 30;
$topicsperpage = 20;
$searchresultsperpage = 30;

$searchexpiretime = 600;

$showforumstats = 1; //0 - no; 1 - yes
$showlastposts = 1;  //0 - no; 1 - yes
$shownumlastposts = 30;
//exclude forums from showing their topics in last discussions
//array(forumexcludeid1, forumexcludeid2..); or empty -> array();
$lastpostsexclude = array();

$datetimeformat = 'd M Y H:i';
$dateformat = 'd M Y';
$shortdateformat = 'M Y';
//if you use long months (January), then change $engmonths to long English months for multi-lang support
$engmonths = array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');

$antispam = 60;

$modrewrite = 0; // 0- no mod_rewrite; 1- search engine friendly urls, requires .htaccess ...

//special forum options
//private forums, only for a selected subset of users
// = array(private_forum_id => array(allowuserid1, allowuserid2..));
$privateforums = array();
//only admin can post in read only forums
// = array(readonly_forum_id, readonly_forum_id2);
$readonlyforums = array();
//do everything except creating NEW topics (only admin can do it!)
// = array(postonly_forum_id, postonly_forum_id2..);
$postonlyforums = array();
// by default guests cannot post
// = array(guestcanpost_forum_id1, guestcanpost_forum_id2..);
$guestscanpostforums = array();
// allow posting of HTML tags in messages in these forums
// = array(allowedhtmlforumid1,...);
$allowhtmlforums = array();
// forums that are sorted by topic creation time (newest on top)
// = array(forumid1, forumid2..);
$articleforums = array ();

//forum moderators
// = array(forum => array(moderatorID => 'ModeratorName', moderatorID2 => 'ModeratorName2'));
$moderators = array();

$showmoderators = 0; //0-no 1-yes
?>
ed ecco invece il file per l' installazione:

codice:
 <?php

require ('seo-board_options.php');
include ('./lang/eng.php');

error_reporting(E_ALL);
set_magic_quotes_runtime(0);

header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
header("Expires: Mon,26 Jul 1997 05:00:00 GMT");

@mysql_connect($dbhost, $dbuser, $dbpass) or die ($lang['db_error']);
@mysql_select_db($dbname) or die ($lang['db_error']);

$q = array();

// forums ain't too many, so we can use char instead of varchar for this table
$q[] = "DROP TABLE IF EXISTS {$dbpref}forums";
$q[] = "CREATE TABLE {$dbpref}forums (
forum_id int(10) unsigned NOT NULL auto_increment,
forum_parent int(10) unsigned NOT NULL DEFAULT '0',
forum_order int(10) unsigned NOT NULL DEFAULT '0',
forum_name char(100) NOT NULL DEFAULT '',
forum_desc char(255) NOT NULL DEFAULT '',
forum_numtopics int(10) unsigned NOT NULL DEFAULT '0',
forum_numreplies int(10) unsigned NOT NULL DEFAULT '0',
forum_lastpost_time int(10) unsigned NOT NULL DEFAULT '0',
forum_lastposter char(30) NOT NULL DEFAULT '',
PRIMARY KEY (forum_id)
) TYPE=MyISAM;";


$q[] = "DROP TABLE IF EXISTS {$dbpref}users";
$q[] = "CREATE TABLE {$dbpref}users (
user_id int(10) unsigned NOT NULL auto_increment,
user_name varchar(20) NOT NULL DEFAULT '',
user_pass char(40) NOT NULL DEFAULT '',
user_regdate int(10) unsigned NOT NULL DEFAULT '0',
user_bio text NOT NULL DEFAULT '',
user_bio_status tinyint(2) unsigned NOT NULL DEFAULT '5',
user_timezone float(3,1) NOT NULL DEFAULT '0.0',
user_email varchar(100) NOT NULL DEFAULT '',
user_email_public tinyint(1) unsigned NOT NULL DEFAULT '0',
user_allowviewonline tinyint(1) unsigned NOT NULL DEFAULT '1',
user_numposts int(10) unsigned NOT NULL DEFAULT '0',
user_lasttimereadpost int(10) unsigned NOT NULL DEFAULT '0',
user_lastsession int(10) unsigned NOT NULL DEFAULT '0',
user_banned tinyint(1) unsigned NOT NULL DEFAULT '0',
user_newpassword char(40) NOT NULL DEFAULT '',
PRIMARY KEY (user_id)
) TYPE=MyISAM;";


$q[] = "DROP TABLE IF EXISTS {$dbpref}topics";
$q[] = "CREATE TABLE {$dbpref}topics(
topic_id int(10) unsigned NOT NULL auto_increment,
topic_title varchar(100) NOT NULL,
topic_poster_id int(10) unsigned NOT NULL DEFAULT '0',
topic_poster_name varchar(30) DEFAULT 'Anonymous' NOT NULL,
topic_lastposter_id int(10) unsigned NOT NULL DEFAULT '0',
topic_lastposter_name varchar(30) DEFAULT 'Anonymous' NOT NULL,
topic_created_time int(10) unsigned NOT NULL DEFAULT '0',
topic_lastpost_time int(10) unsigned NOT NULL DEFAULT '0',
topic_numreplies int(10) unsigned NOT NULL DEFAULT '0',
topic_numviews int(10) unsigned NOT NULL DEFAULT '0',
topic_sticky tinyint(1) unsigned DEFAULT '0',
topic_locked tinyint(1) unsigned DEFAULT '0',
topic_moved tinyint(1) unsigned DEFAULT '0',
forum_id int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (topic_id),
KEY (forum_id),
KEY (topic_lastpost_time)
) TYPE=MyISAM;";

$q[] = "DROP TABLE IF EXISTS {$dbpref}posts";
$q[] = "CREATE TABLE {$dbpref}posts(
post_id int(10) unsigned NOT NULL auto_increment,
topic_id int(10) unsigned NOT NULL DEFAULT '0',
post_author varchar(30) DEFAULT 'Anonymous' NOT NULL,
post_author_id int(10) unsigned NOT NULL DEFAULT '0',
post_author_ip varchar(15) NOT NULL default 'Unknown',
post_text text NOT NULL DEFAULT '',
post_text_status tinyint(2) unsigned NOT NULL DEFAULT '5',
post_time int(10) unsigned NOT NULL DEFAULT '0',
post_edited tinyint(1) unsigned DEFAULT '0',
post_edited_by varchar(30) DEFAULT '' NOT NULL,
post_edited_time int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (post_id),
KEY (topic_id),
KEY (post_time),
FULLTEXT (post_text)
) TYPE=MyISAM;";

$q[] = "DROP TABLE IF EXISTS {$dbpref}search";
$q[] = "CREATE TABLE {$dbpref}search(
search_id int(10) unsigned NOT NULL auto_increment,
search_user_id int(10) unsigned NOT NULL DEFAULT '0',
search_time int(10) unsigned NOT NULL DEFAULT '0',
search_results text NOT NULL DEFAULT '',
PRIMARY KEY(search_id)
) TYPE=MyISAM;";

$q[] = "DROP TABLE IF EXISTS {$dbpref}bans";
$q[] = "CREATE TABLE {$dbpref}bans(
ban_id int(10) unsigned NOT NULL auto_increment,
ban_data char(20) NOT NULL DEFAULT '',
PRIMARY KEY(ban_id),
UNIQUE KEY(ban_data)
) TYPE=MyISAM;";

//create tables
foreach ($q as $query)
{
  mysql_query($query) or die (mysql_error());
}

//insert admin account
$now = time();
mysql_query("INSERT INTO {$dbpref}users (user_id, user_name, user_pass, user_email, user_regdate, user_timezone) VALUES (1, '".addslashes($adminuser)."', '".sha1($shaprefix.$adminpass)."','$adminemail','$now','$forumtimezone')") or die (mysql_error());;

echo 'Forum Installed Successfully!';
?>