Error: The directory electrifiedForum is installed into needs to be CHMOD 777 so it is writable by the PHP process. When you have made this change, reload this page to continue the install process. Once you are done creating realms you should CHMOD 755 this directory.";
if (!$realm)
$realm = "default";
$config[dbhost]=$dbhost;
$config[dbuser]=$dbuser;
$config[dbpass]=$dbpass;
$config[dbname]=$dbname;
include 'funcs.mysql.php';
htmlstart();
if (!is_writable(getcwd()))
die($unwritable_message);
if (file_exists("realm.$realm.php"))
$realm_exists = TRUE;
function check_table_existence($table)
{
global $config;
if (db_select("SHOW FIELDS FROM $table"))
{
return TRUE;
}
else
{
return FALSE;
}
}
function lang_array(){
$handle=opendir("lang");
while ($file = readdir($handle)){
if($file=='.'||$file=='..') continue;
$files[]=$file;
}
closedir($handle);
for($i=0;$iInstalling electrifiedForum $version
";
print "System Information ";
print "PHP Version: $phpver ";
if (floor($phpver)<4)
print "PHP Version Not 4.0 or Greater You may have problems ";
if ($conn_error)
print "Unable to connect to MySQL host at $dbhost Please check hostname and permissions for the MySQL database. ";
print "MySQL Version: $mysql[version] ";
if (!strstr($mysql[version],"3.23"))
print "MySQL Version Not 3.23.x You may have problems ";
print "Server OS: $server[os] ";
print "Web Server Daemon: $server[web] ";
print "Server Hostname: $server[host] ";
print " ";
if ($ext[mysql])
print "MySQL Extension Loaded ";
if ($ext[ldap])
print "LDAP Extension Loaded (Not yet used) ";
print " ";
print "Building MySQL Tables in database $config[dbname]...
";
if ($ext[mysql] && !$conn_error)
{
print "Creating forums table...";
if (!check_table_existence("forums"))
{
if (mysql_query("CREATE TABLE forums (
fname varchar(20) NOT NULL,
ftitle varchar(30) NOT NULL,
fdesc varchar(200) NOT NULL,
cat varchar(40) NOT NULL,
owner varchar(100) NOT NULL,
icon varchar(100) NOT NULL,
options smallint(6) DEFAULT '1' NOT NULL,
forumpassword varchar(100) NOT NULL,
PRIMARY KEY (fname),
UNIQUE fname (fname),
KEY fname_2 (fname));"))
{
print "Success ";
}
else
{
print "Error: ".mysql_error()." ";
$errors++;
}
mysql_query("INSERT INTO forums VALUES ('chat','Chat','A forum to talk about anything and everything!','General','$adminuser','','1');");
}
else
{
print "Warning! Forums table Already Exists! ";
$warnings++;
}
print "Creating users table...";
if (!check_table_existence("fusers")){
if (mysql_query("CREATE TABLE fusers (
username varchar(20) NOT NULL,
password varchar(20) NOT NULL,
level smallint(6) DEFAULT '0' NOT NULL,
options tinyint(4) DEFAULT '0' NOT NULL,
location varchar(100) NOT NULL,
email varchar(100) NOT NULL,
homepage varchar(200) NOT NULL,
showemail tinyint(4) DEFAULT '0' NOT NULL,
icq varchar(20) NOT NULL,
showicq tinyint(4) DEFAULT '0' NOT NULL,
aim varchar(40) NOT NULL,
showaim tinyint(1) DEFAULT '0' NOT NULL,
yahoo varchar(80) NOT NULL,
showyahoo tinyint(1) DEFAULT '0' NOT NULL,
realname varchar(100) NOT NULL,
age smallint(6) DEFAULT '0' NOT NULL,
birthday varchar(8) NOT NULL,
showbirthday tinyint(4) DEFAULT '0' NOT NULL,
gender varchar(10) NOT NULL,
avatar varchar(60) NOT NULL,
sig text NOT NULL,
disabled tinyint(1) DEFAULT '0' NOT NULL,
rank smallint(6) DEFAULT '0' NOT NULL,
votes smallint(6) DEFAULT '0' NOT NULL,
PRIMARY KEY (username),
UNIQUE username (username),
KEY username_2 (username));"))
{
print "Success ";
}
else
{
print "Error: ".mysql_error()." ";
$errors++;
}
if ($pass_encrypt == "mysql")
mysql_query("INSERT INTO fusers VALUES ( '$adminuser', PASSWORD('$adminpass'), '10', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '', '', '0', '', '', '', '0', '', '');");
else
mysql_query("INSERT INTO fusers VALUES ( '$adminuser', '$adminpass', '10', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '', '', '0', '', '', '', '0', '', '');");
}
else
{
print "Warning! Users table Already Exists! ";
$warnings++;
}
print "Creating messages table...";
if (!check_table_existence("messages")){
if (mysql_query("CREATE TABLE messages (
id smallint(6) NOT NULL auto_increment,
fname varchar(20) NOT NULL,
threadid smallint(6) DEFAULT '0' NOT NULL,
threadindex smallint(6) DEFAULT '0' NOT NULL,
poster varchar(100) NOT NULL,
title varchar(120) NOT NULL,
content text NOT NULL,
icon varchar(60) NOT NULL,
ip varchar(60) NOT NULL,
posttime timestamp(14),
options smallint(6) DEFAULT '1' NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id),
KEY forumname (fname));"))
{
print "Success ";
}
else
{
print "Error: ".mysql_error()." ";
$errors++;
}
mysql_query("INSERT INTO messages VALUES ('1','chat','0','0','$adminuser','Welcome to electrifiedForum', 'If you see this message, electrifiedForum is properly installed and configured!!', '', '', now(), '1')");
}
else
{
print "Warning! Messages table Already Exists! ";
$warnings++;
}
print "Creating private messages table...";
if (!check_table_existence("pmessages")){
if (mysql_query("CREATE TABLE pmessages (
id smallint(6) NOT NULL auto_increment,
mto varchar(20) NOT NULL,
mfrom varchar(20) NOT NULL,
status smallint(6) DEFAULT '0' NOT NULL,
subject varchar(120) NOT NULL,
message text NOT NULL,
senttime timestamp(14),
PRIMARY KEY (id),
UNIQUE id (id));"))
{
print "Success ";
}
else
{
print "Error: ".mysql_error()." ";
$errors++;
}
}
else
{
print "Warning! Private Messages table Already Exists! ";
$warnings++;
}
print "Creating Anonymous User...";
if (!$config[utable])
$config[utable] = 'fusers';
if (mysql_db_query($config[dbname],"INSERT INTO $config[utable] (username, password, level, options, location, email, homepage, showemail, icq, showicq, aim, showaim, yahoo, showyahoo, realname, age, birthday, showbirthday, gender, avatar, sig, disabled, rank, votes) VALUES ('Anonymous', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '', '')"))
print "Success ";
else
{
print "Error: ".mysql_error()." ";
$errors++;
}
}
else
{
if (!$ext[mysql])
print "FATAL ERROR: Unable to build MySQL tables: MySQL Support Not Enabled in this version of PHP ";
else
print "FATAL ERROR: Unable to build MySQL tables: Unable to connect to MySQL host. Please check username/password. ";
$errors++;
}
/* Now to open up the template file, parse the vars, and writeout the realm file */
if ($ext[mysql] && !$conn_error)
{
$tf = fopen('realmtemplate.txt','r');
$templa = fread($tf, filesize('realmtemplate.txt'));
$replacees = array("[%REALM-TITLE%]", "[%DB-HOST%]", "[%DB-USER%]", "[%DB-PASS%]", "[%DB-NAME%]", "[%DESCRIPTION%]", "[%KEYWORDS%]", "[%BGCOLOR%]", "[%TTCOLOR%]", "[%TTTEXTCOLOR%]", "[%TEXTCOLOR%]", "[%LINKCOLOR%]", "[%TBGCOLOR%]", "[%TRCOLORA%]", "[%TRCOLORB%]", "[%SEC_PASS_ENCRYPT%]", "[%LANGUAGE%]", "[%ANON%]", "[%TOPICSPERPAGE%]", "[%POSTSPERPAGE%]");
$replacers = array($title, $dbhost, $dbuser, $dbpass, $dbname, $description, $keywords, $bgcolor, $ttcolor, $tttcolor, $textcolor, $linkcolor, $tbgcolor, "#e5e5e5", "#d7d7d7", $pass_encrypt, $language, $anon, $topics, $posts);
$data = str_replace($replacees,$replacers,$templa);
fclose($tf);
print "Creating realm file realm.$realm.php...";
if ($rf = @fopen("realm.$realm.php",'w'))
{
print "Success ";
}
else
{
print "Error ";
$errors++;
}
print "Writing to realm file realm.$realm.php...";
if (@fwrite($rf,$data)){
print "Success ";
} else {
print "Error ";
$errors++;
}
@fclose($rf);
@chmod("realm.$realm.php", 0777);
}
print " ";
if (!$errors && !$warnings)
print "Install successful, No errors or warnings ";
elseif (!$errors)
print "Install complete but with warnings ";
else
print "Errors occurred during Installation.
To recieve help, please copy this entire page into the support forums at www.electrifiedpenguin.com or email to support@electrifiedpenguin.com ";
if (substr(str_replace(".","",phpversion()),0,3)>=402)
if (strstr("Windows",php_uname()) || getenv("WINDIR"))
if (ini_get("session.save_path")=="/tmp")
{
print "You appear to be running this installer on a windows host. eF uses PHP sessions, and the session.save_path in php.ini is currently incorrect. ";
print "Please resolve this by editing php.ini and setting session.save_path to a valid temporary directory on your system, such as c:\\temp. ";
}
}
}
else
{
/* Installation Options Form */
$langs =lang_array();
?>
electrifiedForum Installer