'.$title.'
';
}
function do_footer()
{
echo '
';
}
session_start();
$step = (isset($_GET['step']) ? (int)$_GET['step'] : 0);
switch ($step) {
case 4:
if (checkSession()) {
do_header(__('Thank you for using Jisko'));
if ($_SESSION['type'] == 'new') {
$fd = fopen('config.php', 'w+');
if ($fd) {
fwrite($fd, "");
echo ''.__('The file config.php was created without any problems').'
';
}
else echo ''.__('There was a problem while creating the config.php file, please rename config.sample.php to config.php, and then edit it with your database credentials').'
';
echo ''.__('Congratulations! You have now installed Jisko in your host.').'
'.__('Now please remove the install.php file in order to test your Jisko installation').'
'.sprintf(__('Remember to visit %s to see the latest updates'), 'http://jisko.org').'
';
}
else {
echo ''.__('Now please remove the install.php file in order to test your Jisko installation').'
'.sprintf(__('Remember to visit %s to see the latest updates'), 'http://jisko.org').'
'.sprintf(__('Congratulations! You have now updated to Jisko %s.'), JISKO_VERSION).'
'.__('Now please remove the install.php file in order to test your new version of Jisko').'
'.sprintf(__('Remember to visit %s to see the latest updates'), 'http://jisko.org').'
';
}
do_footer();
}
break;
case 3:
if ($_POST) {
if (checkSession()) {
$mysqlfd = mysql_connect($_SESSION['host'].':'.$_SESSION['port'], $_SESSION['username'], $_SESSION['password']);
if ($mysqlfd) {
$db = mysql_select_db($_SESSION['name']);
if ($db) {
if (empty($_POST['username']) && empty($_POST['password']) && empty($_POST['email'])) header('Location: install.php?step=3&error=empty');
else {
$check = validUsername($_POST['username']);
if ($check != 'valid') {
if ($check == 'busy') header('Location: install.php?step=3&error=forbid');
elseif ($check == 'invalid') header('Location: install.php?step=3&error=user');
}
else {
$query = mysql_query('SELECT `ID` FROM `users` WHERE `username`=\''.mysql_real_escape_string($_POST['username']).'\'');
if (mysql_num_rows($query)) {
$id = mysql_insert_id();
$query = mysql_query('INSERT INTO `permissions` SET `userid`=\''.$id.'\', `can_panel`=\'1\'');
if ($query) header('Location: install.php?step=4');
else header('Location: install.php?step=3&error=query');
}
else {
if (!mkdir(PATH."users_files/".$_POST['username'], 0777) || (!mkdir(PATH."users_files/".$_POST['username']."/img", 0777) || (!mkdir(PATH."users_files/".$_POST['username']."/img/avatar", 0777) || (!mkdir(PATH."users_files/".$_POST['username']."/img/background", 0777) || (!mkdir(PATH."users_files/".$_POST['username']."/files", 0777)))))) header('Location: install.php?step=3&error=dir');
else {
$salt = substr(md5(rand()), 0, 5);
$query = mysql_query("INSERT INTO `users` (`username`, `password`, `api`, `salt`, `language`, `theme`, `email`, `status`, `since`, `last_seen`, `ip`, `notification_level`) values ('".$_POST['username']."', '".md5(md5($_POST['password']).md5($salt))."', '".substr(md5($_POST['username'].rand()), 0, 16)."', '".$salt."', 'def', 'transparency', '".$_POST['email']."', 'ok', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '".$_SERVER['REMOTE_ADDR']."', 4)");
$id = mysql_insert_id();
$query = mysql_query('INSERT INTO `permissions` SET `userid`=\''.$id.'\', `can_panel`=\'1\'');
if ($query) header('Location: install.php?step=4');
else header('Location: install.php?step=3&error=query');
}
}
}
}
}
else header('Location: install.php?step=3&error=db');
}
else header('Location: install.php?step=3&error=mysql');
}
else header('Location: install.php?step=1');
}
else {
if (checkSession()) {
if ($_SESSION['type'] == 'new') do_header(__('Installing Jisko (step 3/3)'));
else do_header(__('Updating Jisko (step 3/3)'));
$error = (isset($_GET['error']) ? $_GET['error'] : '');
switch ($error) {
case 'mysql':
$error = "Couldn't connect to the mysql database";
break;
case 'db':
$error = "Couldn't select the database";
break;
case 'query':
$error = 'There was a problem while trying to execute a query';
break;
case 'forbid':
$error = "The username you entered cannot be used";
break;
case 'user':
$error = 'Username not valid. It has to be less than 20 characters';
break;
case 'empty':
$error = 'There are empty fields. Fill them and try again';
break;
case 'dir':
$error = "Couldn't create the upload folders for the admin user";
}
if ($error) echo ''.__('Now please remove the install.php file in order to test your new version of Jisko').'
'.sprintf(__('Remember to visit %s to see the latest updates'), 'http://jisko.org').'
'.__($error).'
';
echo '
';
do_footer();
}
else header('Location: install.php?step=1');
}
break;
case 2:
if ($_POST) {
if (checkSession()) {
$mysqlfd = mysql_connect($_SESSION['host'].':'.$_SESSION['port'], $_SESSION['username'], $_SESSION['password']);
if ($mysqlfd) {
$db = mysql_select_db($_SESSION['name']);
if ($db) {
if (get_magic_quotes_gpc()) {
$_POST['base_url'] = stripslashes($_POST['base_url']);
$_POST['name'] = stripslashes($_POST['name']);
$_POST['admin_mail'] = stripslashes($_POST['admin_mail']);
$_POST['abuse_mail'] = $_POST['admin_mail'];
}
$queries = array(
'base_url' => mysql_real_escape_string($_POST['base_url']),
'name' => mysql_real_escape_string($_POST['name']),
'admin_mail' => mysql_real_escape_string($_POST['admin_mail']),
'abuse_mail' => mysql_real_escape_string($_POST['admin_mail'])
);
foreach ($queries as $cat=>$val) {
$query = mysql_query('UPDATE `settings` SET `value`=\''.$val.'\' WHERE `category`=\''.$cat.'\'');
if (!$query) header('Location: install.php?step=2&error=query');
}
header('Location: install.php?step=3');
}
else header('Location: install.php?step=2&error=db');
}
else header('Location: install.php?step=2&error=mysql');
}
else header('Location: install.php?step=1');
}
else {
if (checkSession()) {
if ($_SESSION['type'] == 'new') do_header(__('Installing Jisko (step 2/3)'));
else do_header(__('Updating Jisko (step 2/3)'));
$error = (isset($_GET['error']) ? $_GET['error'] : '');
switch ($error) {
case 'mysql':
$error = "Couldn't connect to the mysql database";
break;
case 'db':
$error = "Couldn't select the database";
break;
case 'query':
$error = 'There was a problem while trying to execute a query';
}
if ($error) echo ''.__($error).'
';
echo '
';
do_footer();
}
else header('Location: install.php?step=1');
}
break;
case 0:
if ($_POST) {
$val = array('new', '2.0', '3.0beta1', '3.0beta2');
if (in_array($_POST['opt'], $val)) {
$_SESSION['type'] = $_POST['opt'];
header('Location: install.php?step=1');
}
else header('Location: install.php?step=0');
}
else {
do_header('Updating/Installing Jisko');
echo '
'.__('If you have a previous version of Jisko installed on your server, then you may upgrade your existing installation. Otherwise you can do a clean installation.').'
'; do_footer(); } break; case 1: if ($_POST) { $mysqlfd = mysql_connect($_POST['host'].':'.(int)$_POST['port'], $_POST['username'], $_POST['password']); if ($mysqlfd) { $_SESSION['host'] = $_POST['host']; $_SESSION['port'] = (int) $_POST['port']; $_SESSION['username'] = $_POST['username']; $_SESSION['password'] = $_POST['password']; $_SESSION['name'] = $_POST['name']; mysql_close($mysqlfd); if ($_SESSION['type'] == '3.0beta2') { require dirname(__FILE__).'/sql/upgrade3.0beta2.php'; $upd = new Upgrade30beta2($_POST['host'], $_POST['port'], $_POST['username'], $_POST['password'], $_POST['name']); if ($upd == 'mysql') header('Location: install.php?step=1&error=mysql'); else { $status = $upd->upgrade(); if ($status == 'query') header('Location: install.php?step=1&error=query'); else header('Location: install.php?step=4'); } } if ($_SESSION['type'] == '3.0beta1') { require dirname(__FILE__).'/sql/upgrade3.0beta1.php'; $upd = new Upgrade30beta1($_POST['host'], $_POST['port'], $_POST['username'], $_POST['password'], $_POST['name']); if ($upd == 'mysql') header('Location: install.php?step=1&error=mysql'); else { $status = $upd->upgrade(); if ($status == 'query') header('Location: install.php?step=1&error=query'); else header('Location: install.php?step=4'); } } elseif ($_SESSION['type'] == '2.0') { require dirname(__FILE__).'/sql/upgrade2.0.php'; $upd = new Upgrade20($_POST['host'], $_POST['port'], $_POST['username'], $_POST['password'], $_POST['name']); if ($upd == 'mysql') header('Location: install.php?step=1&error=mysql'); else { $status = $upd->upgrade(); if ($status == 'query') header('Location: install.php?step=1&error=query'); else header('Location: install.php?step=3'); } } elseif ($_SESSION['type'] == 'new') { require dirname(__FILE__).'/sql/install.php'; $upd = new Install($_POST['host'], $_POST['port'], $_POST['username'], $_POST['password'], $_POST['name']); if ($upd == 'mysql') header('Location: install.php?step=1&error=mysql'); else { $status = $upd->upgrade(); if ($status == 'query') header('Location: install.php?step=1&error=query'); else header('Location: install.php?step=2'); } } } else header('Location: install.php?step=1&error=mysql'); } else { if ($_SESSION['type'] == 'new') do_header(__('Installing Jisko (step 1/3)')); else do_header(__('Updating Jisko (step 1/3)')); $error = (isset($_GET['error']) ? $_GET['error'] : ''); switch ($error) { case 'mysql': $error = "Couldn't connect to the mysql database"; break; case 'db': $error = "Couldn't select the database"; break; case 'query': $error = 'There was a problem while trying to execute a query'; } if ($error) echo ''.__($error).'
';
echo '
';
do_footer();
}
break;
}
?>