{

global $phpc_config_file;

if(is_writable($phpc_config_file))

return true;

// Check if we can create the file

if($file = @fopen($phpc_config_file, 'a')) {

fclose($file);

return true;

}

return false;

{

echo '<p>Your configuration file could not be written to. This file '

.'probably does not yet exist. If that is the case, youneed to '

.'create it. You need to make sure this script can write to '

.'it. We suggest logging in with a shell and typing:</p>

<p><pre>

touch config.php

chmod 666 config.php

</pre></p>

<p>or if you only have ftp access, upload a blank file named '

.'config.php to your php-calendar directory then use the chmod '

.'command to change the permissions of config.php to 666.</p>

<input type="submit" value="Retry"/>';

{

if(!check_config())

return report_config();

echo '

<h3>Step 1: Database</h3>

<table class="display">

<tr>

<td>SQL Server Hostname:</td>

<td><input type="text" name="my_hostname" value="localhost"></td>

</tr>

<tr>

<td>SQL Database name:</td>

<td><input type="text" name="my_database" value="calendar"></td>

</tr>

<tr>

<td>SQL Table prefix:</td>

<td><input type="text" name="my_prefix" value="phpc_"></td>

</tr>

<tr>

<td>SQL Username:</td>

<td><input type="text" name="my_username" value="calendar"></td>

</tr>

<tr>

<td>SQL Password:</td>

<td><input type="password" name="my_passwd"></td>

</tr>

<tr>

<td colspan="2">

<input type="checkbox" name="create_db" value="yes"/>

Create the database (don\'t check this if it already exists)

</td>

</tr>

<tr>

<td colspan="2">

<input type="checkbox" name="drop_tables" value="yes">

Drop tables before creating them

</td>

</tr>

<tr><td colspan="2">

<span style="font-weight:bold;">Optional: user creation on database</span>

</td></tr>

<tr><td colspan="2">

If the credentials supplied above are new, you have to be the database administrator.

</td></tr>

<tr><td colspan="2">

<input type="checkbox" name="create_user" value="yes">

Check this if you want to do it and provide admin user and password.

</td></tr>

<tr>

<td>SQL Admin name:</td>

<td><input type="text" name="my_adminname"></td>

</tr>

<tr>

<td>SQL Admin Password:</td>

<td><input type="password" name="my_adminpasswd"></td>

</tr>

<tr>

<td colspan="2">

<input name="action" type="submit" value="Install">

</td>

</tr>

</table>';

{

$my_hostname = $_POST['my_hostname'];

$my_username = $_POST['my_username'];

$my_passwd = $_POST['my_passwd'];

$my_prefix = $_POST['my_prefix'];

$my_database = $_POST['my_database'];

$my_adminname = $_POST['my_adminname'];

$my_adminpasswd = $_POST['my_adminpasswd'];

$create_user = isset($_POST['create_user'])

&& $_POST['create_user'] == 'yes';

$create_db = isset($_POST['create_db']) && $_POST['create_db'] == 'yes';

// Make the database connection.

if($create_user) {

$dbh = connect_db($my_hostname, $my_adminname, $my_adminpasswd);

} else {

$dbh = connect_db($my_hostname, $my_username, $my_passwd);

}

$string = "<h3>Step 2: Database Setup</h3>";

if($create_db) {

$query = "CREATE DATABASE $my_database";

$dbh->query($query)

or install_db_error($dbh, 'error creating db', $query);

$string .= "<p>Successfully created database</p>";

}

if($create_user) {

$query = "GRANT ALL ON accounts.* TO $my_username@$my_hostname identified by '$my_passwd'";

$dbh->query($query)

or install_db_error($dbh, 'Could not grant:', $query);

$query = "GRANT ALL ON $my_database.*\n"

."TO $my_username IDENTIFIED BY '$my_passwd'";

$dbh->query($query)

or install_db_error($dbh, 'Could not grant:', $query);

$query = "FLUSH PRIVILEGES";

$dbh->query($query)

or install_db_error($dbh, "Could not flush privileges", $query);

$string .= "<p>Successfully added user</p>";

}

echo "$string\n"

."<div><input type=\"submit\" name=\"done_user_db\" value=\"continue\"/>"

."</div>\n";

$sql_prefix, $sql_type)

{

return "<?php\n"

."define('SQL_HOST', '$sql_hostname');\n"

."define('SQL_USER', '$sql_username');\n"

."define('SQL_PASSWD', '$sql_passwd');\n"

."define('SQL_DATABASE', '$sql_database');\n"

."define('SQL_PREFIX', '$sql_prefix');\n"

."define('SQL_TYPE', '$sql_type');\n"

."?".">\n"; // Break this up to fix syntax HL in vim

{

global $phpc_config_file;

$sql_type = "mysqli";

$my_hostname = $_POST['my_hostname'];

$my_username = $_POST['my_username'];

$my_passwd = $_POST['my_passwd'];

$my_prefix = $_POST['my_prefix'];

$my_database = $_POST['my_database'];

$fp = fopen($phpc_config_file, 'w')

or soft_error('Couldn\'t open config file.');

fwrite($fp, create_config($my_hostname, $my_username, $my_passwd,

$my_database, $my_prefix, $sql_type))

or soft_error("Could not write to file");

fclose($fp);

// Make the database connection.

include($phpc_config_file);

$dbh = connect_db(SQL_HOST, SQL_USER, SQL_PASSWD, SQL_DATABASE);

create_tables($dbh);

$query = "REPLACE INTO `" . SQL_PREFIX . "config`\n"

."(`name`, `value`)\n"

."VALUES ('version', '".PHPC_DB_VERSION."')";

$dbh->query($query)

or install_db_error($dbh, 'Error creating version row.', $query);

echo "<p>Config file created at \"". realpath($phpc_config_file) ."\"</p>"

."<p>Calendars database created</p>\n"

."<div><input type=\"submit\" name=\"base\" value=\"continue\">"

."</div>\n";

{

global $drop_tables, $phpc_includes_path;

require_once("$phpc_includes_path/schema.php");

foreach(phpc_table_schemas() as $table) {

$table->create($dbh, $drop_tables);

}

{

echo '<h3>Step 4: Administration account</h3>';

echo "<table>\n"

."<tr><td colspan=\"2\">Now you must create the calendar administrative "

."account.</td></tr>\n"

."<tr><td>\n"

."Admin name:\n"

."</td><td>\n"

."<input type=\"text\" name=\"admin_user\" />\n"

."</td></tr><tr><td>\n"

."Admin password:"

."</td><td>\n"

."<input type=\"password\" name=\"admin_pass\" />\n"

."</td></tr><tr><td colspan=\"2\">"

."<input type=\"submit\" value=\"Create Admin Account\" />\n"

."</td></tr></table>\n";

{

global $phpc_config_file;

require_once($phpc_config_file);

$calendar_title = 'PHP-Calendar';

// Make the database connection.

$dbh = connect_db(SQL_HOST, SQL_USER, SQL_PASSWD, SQL_DATABASE);

$query = "INSERT INTO ".SQL_PREFIX."calendars\n"

."(`cid`) VALUE (1)";

$dbh->query($query)

or install_db_error($dbh, 'Error reading options', $query);

$cid = $dbh->insert_id;

echo "<h3>Final Step</h3>\n";

echo "<p>Saved default configuration</p>\n";

$passwd = md5($_POST['admin_pass']);

$query = "INSERT INTO `" . SQL_PREFIX . "users`\n"

."(`username`, `password`, `admin`) VALUES\n"

."('$_POST[admin_user]', '$passwd', 1)";

$dbh->query($query)

or install_db_error($dbh, 'Error adding admin.', $query);

echo "<p>Admin account created.</p>";

echo "<p>Now you should delete install.php file from root directory (for security reasons).</p>";

echo "<p>You should also change the permissions on config.php so only your webserver can read it.</p>";

echo "<p><a href=\"index.php\">View calendar</a></p>";

{

$string = "$str<br />" . $dbh->error;

if($query != "")

$string .= "<br />SQL query: $query";

soft_error($string);

{

$dbh = new mysqli($hostname, $username, $passwd);

if(mysqli_connect_errno()) {

soft_error("Database connect failed (" . mysqli_connect_errno()

. "): " . mysqli_connect_error());

}

if($database)

$dbh->select_db($database);

$dbh->query("SET NAMES 'utf8'");

return $dbh;