iframe-proxy | Sunbelt Computer Software

265 lines (211 loc) · 6.8 KB
<head></head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Installation Processor</title>
ini_set('display_errors', 'On');
error_reporting(E_ALL | E_STRICT);
require_once __DIR__.'/sql_parse.php';
//Process and load form data
$servername = $_POST["servername"];
$rootpass = $_POST["rootpass"];
$dbuser = $_POST["dbuser"];
$dbpass1 = $_POST["dbpass1"];
$dbpass2 = $_POST["dbpass2"];
$adminuser = $_POST["adminuser"];
$adminpass1 = $_POST["adminpass1"];
$adminpass2 = $_POST["adminpass2"];
$action = $_POST["selectaction"];
$adminname = $_POST["adminname"];
$adminemail = $_POST["adminemail"];
//Create the MD5 hash value for the admin password
$adminhash = md5($adminpass1);
//-----------------Do some validation---------
$validerror ='';
//Validate DB password
echo "Validating Entries...";
if ($dbpass1 != $dbpass2)
		$validerror .= "<br><strong>Your Database passwords do not match.</strong>";
//Validate admin password
if ($adminpass1 != $adminpass2) {
		$validerror .= "<br><strong>Your Administrator account passwords do not match.</strong>";
echo "Success!<br>";
//Validate DB connectivity
echo "Checking DB connectivity...";
$con=mysqli_connect($servername,"root",$rootpass);
if (mysqli_connect_errno())
$validerror .= "<br><strong>Cannot connect the the database using the supplied information.</strong>";
echo "Success!<br>";
//Validate that the config directories are writable
echo "Checking config folder permissions...";
if (!is_writable(dirname('../../includes/functions.php')))
$validerror .= "<br><strong>Cannot write the configuration files. Please check the /includes/ folder permissions. See the RPints Installation page on www.raspberrypints.com.</strong>";
if (!is_writable(dirname('../../admin/includes/checklogin.php')))
$validerror .= "<br><strong>Cannot write the configuration files. Please check the /admin/includes/ folder permissions. See the RPints Installation page on www.raspberrypints.com.</strong>";
echo "Success!<br>";
//##TODO## Check if administrator account already exists
//Display errors and die
if ($validerror !='') 
		echo "<html><body>";
		echo $validerror;
		echo "<br /><br />Please press the back button on your browser to fix these errors";
		echo "</body></html>";
// CLEAR INSTALLATION DATA ROUTINES
if ($action == 'remove')
	echo "Deleting raspberrypints database...";
	$con=mysqli_connect($servername,"root",$rootpass);
	// Check connection
	if (mysqli_connect_errno())
	echo "Failed to connect to MySQL: " . mysqli_connect_error();
	$sql = "DROP database raspberrypints;";
	$result = mysqli_query($con,$sql);
	mysqli_close($con);
	echo "Success!<br>";
	echo "Removing configuration files...";
	unlink('../../includes/config.php');
	unlink('../../admin/includes/conn.php');
	unlink('../../admin/includes/configp.php');
	} catch (Exception $e) {
		echo 'Caught exception: ',  $e->getMessage(), "\n";
	//unlink('../../includes/config.php');
	//unlink('../../admin/includes/conn.php');
	//unlink('../../admin/includes/configp.php');
	echo "Success!<br>";
if ($action == 'install')
require_once __DIR__.'/config_files.php';
	//-----------------Create the main config file-----------------
	echo "Update config files...";
	file_put_contents('../../includes/config.php', $mainconfigstring);
	echo "Success!<br>";
	// -----------------Create the admin files----------------------
	echo "Update admin config files...";
	file_put_contents('../../admin/includes/conn.php', $adminconfig1);
	file_put_contents('../../admin/includes/configp.php', $adminconfig2);
	echo "Success!<br>";
	//-----------------Create RPints User--------------------------
	echo "Creating RPints database user...";
	$con=mysqli_connect($servername,"root",$rootpass);
	// Check connection
	if (mysqli_connect_errno())
	echo "Failed to connect to MySQL: " . mysqli_connect_error();
	$sql = "GRANT ALL ON *.* TO '" . $dbuser . "'@'" . $servername . "' IDENTIFIED BY '" . $dbpass1 . "' WITH GRANT OPTION;";
	$result = mysqli_query($con,$sql);
	mysqli_close($con);
	echo "Success!<br>";
	//-----------------Run The Schema File-------------------------
	echo "Running Database Script...";
	$dbms_schema = "../../sql/schema.sql";
	$sql_query = @fread(@fopen($dbms_schema, 'r'), @filesize($dbms_schema)) or die('Cannot find SQL schema file. ');
	$sql_query = remove_remarks($sql_query);
	$sql_query = remove_comments($sql_query);
	$sql_query = split_sql_file($sql_query, ';');
	mysql_connect($servername,'root',$rootpass) or die('error connection');
	foreach($sql_query as $sql){
	//echo $i++;
	//echo "	";
	//echo $sql;
	//echo "<br>";
	mysql_query($sql) or die('error in query');
	echo "Success!<br>";
	//-----------------Add the admin user to the Users DB----------
	echo "Adding new admin user...";
	$con=mysqli_connect($servername,"root",$rootpass,"raspberrypints");
	// Check connection
	if (mysqli_connect_errno())
	echo "Failed to connect to MySQL: " . mysqli_connect_error();
	$currentdate = Date('Y-m-d H:i:s');
	$sql = "INSERT INTO users (username, password, name, email, createdDate, modifiedDate) VALUES ('" . $adminuser . "','" . $adminhash . "','" . $adminname . "','" . $adminemail . "','" . $currentdate . "','" . $currentdate . "');";
	$result = mysqli_query($con,$sql);
	mysqli_close($con);
	echo "Success!<br>";
	//-----------------Delete the index.html page-----------------
	echo "Deleting default index.html page...";
	if (!unlink("../../index.html"))
	  echo ("File already deleted");
	  echo ("Success!");
	//-----------------Load the sample data if requested-----------
		if(!empty($_POST['sampledata'])) 
			echo "Adding sample data...";
			flush();
			$dbms_schema = "../../sql/test_data.sql";
			$sql_query = @fread(@fopen($dbms_schema, 'r'), @filesize($dbms_schema)) or die('Cannot find SQL schema file. ');
			$sql_query = remove_remarks($sql_query);
			$sql_query = remove_comments($sql_query);
			$sql_query = split_sql_file($sql_query, ';');
			mysql_connect($servername,'root',$rootpass) or die('error connection');
			foreach($sql_query as $sql){
			//echo $i++;
			//echo "	";
			mysql_query($sql) or die('error in query');
			echo "Success!<br>";
			flush();
if ($action != 'remove')
	##TODO## Add better error handling before showing the Success message
	echo '<br /><br /><br /><h3> Congratulations! Your Raspberry Pints has been setup successfully.<br />';
	echo 'Click for - <a href="../../index.php">Tap List</a><br />';
	echo 'Click for - <a href="../../admin/index.php">Administration </a><br />';
Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Sunbelt Computer Software

PL/B Language Development and Support

FilesExpand file tree

configprocessor.php

Latest commit

History

configprocessor.php

File metadata and controls
