18 Jul
2007
18 Jul
'07
1:39 p.m.
Author: cfinck
Date: Wed Jul 18 17:39:05 2007
New Revision: 27719
URL: http://svn.reactos.org/svn/reactos?rev=27719&view=rev
Log:
Some changes to the RosCMS Installation script:
- Add a correct function for importing SQL dumps (taken from MediaWiki 1.10.0 and
modified)
- Add more status information to step 3 of the installation process
- Add the main HTML headers
- Put the text boxes from step 2 into a table
- Show a message in step 1, when the PHP installation is configured correctly
Modified:
trunk/web/reactos.org/htdocs/roscms/install.php
Modified: trunk/web/reactos.org/htdocs/roscms/install.php
URL:
http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/htdocs/roscms/inst…
==============================================================================
--- trunk/web/reactos.org/htdocs/roscms/install.php (original)
+++ trunk/web/reactos.org/htdocs/roscms/install.php Wed Jul 18 17:39:05 2007
@@ -1,43 +1,94 @@
<?php
-
/* RosCMS install script */
- /* @TODO: fix this script */
+ // This function was taken from the sourceStream() function of "Database.php"
of MediaWiki 1.10.0 and modified
+ function import_sql_dump( $file )
+ {
+ $ret = TRUE;
+ $fp = fopen( $file, "r" );
+
+ while( !feof( $fp ) )
+ {
+ $line = trim( fgets( $fp, 1024 ) );
+ $sl = strlen( $line ) - 1;
+
+ // Skip empty and comment lines
+ if( $sl < 0 || ( $line{0} == "-" && $line{1} == "-" )
)
+ continue;
+
+ // If this lines ends with a semicolon, it terminates the command
+ if( $line{$sl} == ";" )
+ {
+ $done = true;
+ $line = substr( $line, 0, $sl );
+ }
+
+ $cmd .= "$line\n";
+
+ if( $done )
+ {
+ if( !mysql_query( $cmd ) )
+ {
+ $ret = FALSE;
+ echo "<br>" . mysql_errno() . ": " . mysql_error();
+ }
+
+ $done = false;
+ $cmd = "";
+ }
+ }
+
+ fclose( $fp );
+
+ if( $ret )
+ echo "OK";
+
+ return $ret;
+ }
$rpm_ready = "";
if (array_key_exists("ready", $_GET))
$rpm_ready=htmlspecialchars($_GET["ready"]);
-
-
+?>
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd">
+<html>
+<head>
+ <title>RosCMS Install Script</title>
+</head>
+<body>
+<?php
if ($rpm_ready == "step2") {
?>
<h1>RosCMS - Install Script - Step2</h1>
<form id="form1" method="post"
action="install.php?ready=step3">
- <h3>Database Information </h3>
- <p>Database Host Name:
- <input name="dbHost" type="text" id="dbHost"
value="localhost" />
- </p>
- <p>Database User Name:
- <input name="dbUser" type="text" id="dbUser"
value="root" />
-</p>
- <p>Database User Password:
- <input name="dbPass" type="text" id="dbPass"
/>
-</p>
- <p>Database Name:
- <input name="dbName" type="text" id="dbName"
value="domainname" />
-</p>
- <h3>Server Information </h3>
- <p>Complete Server Path:
- <input name="path_server" type="text"
id="path_server" value="http://localhost/domain.com/"
size="50" />
- </p>
- <p> </p>
- <p>
- <label>
- <input type="submit" name="Submit" value="Install
RosCMS ..." />
- </label>
- </p>
+ <h3>Database Information</h3>
+
+ <table>
+ <tr>
+ <td>Database Host Name:</td>
+ <td><input name="dbHost" type="text"
id="dbHost" value="localhost" /></td>
+ </tr>
+ <tr>
+ <td>Database User Name:</td>
+ <td><input name="dbUser" type="text"
id="dbUser" value="root" /></td>
+ </tr>
+ <tr>
+ <td>Database User Password:</td>
+ <td><input name="dbPass" type="text"
id="dbPass" /></td>
+ </tr>
+ <tr>
+ <td>Database Name:</td>
+ <td><input name="dbName" type="text"
id="dbName" value="domainname" /></td>
+ </tr>
+ </table>
+
+ <h3>Server Information</h3>
+ <p>Complete Server Path: <input name="path_server"
type="text" id="path_server"
value="http://localhost/domain.com/" size="50" /></p>
+
+ <p> </p>
+
+ <input type="submit" name="Submit" value="Install RosCMS
..." />
</form>
-
-<?php
+<?php
}
else if ($rpm_ready == "step3") {
echo "<h1>RosCMS - Install Script - Step3</h1>";
@@ -54,19 +105,27 @@
if (array_key_exists("dbName", $_POST))
$dbName=htmlspecialchars($_POST["dbName"]);
if (array_key_exists("path_server", $_POST))
$path_server=htmlspecialchars($_POST["path_server"]);
-
- $connect = @mysql_connect($dbHost, $dbUser, $dbPass) or die("ERROR: Cannot connect
to the database!");
- $query_temp1 = mysql_query("CREATE DATABASE `".
mysql_real_escape_string($dbName) ."` ;") ;
+ echo "Connecting to the MySQL Server... ";
+ $connect = mysql_connect($dbHost, $dbUser, $dbPass) or die("Cannot connect to the
MySQL Server!");
+ echo "OK<br>";
- $selectDB = @mysql_select_db($dbName, $connect) or die("Cannot find and select
<b>". $dbName ."</b>!");
+ echo "Creating the Database... ";
+ mysql_query("CREATE DATABASE `". mysql_real_escape_string($dbName)
."`") or die( mysql_errno() . ": " . mysql_error() );
+ echo "OK<br>";
- $query_temp2 = mysql_query(file_get_contents("install_sql.txt")) ;
+ echo "Selecting the Database... ";
+ mysql_select_db($dbName, $connect) or die("Cannot find and select
<b>$dbName</b>!");
+ echo "OK<br>";
- echo "<p>".$query_temp2."</p>";
+ echo "Importing the SQL Data... ";
+ if( !import_sql_dump( "roscms.sql" ) )
+ exit;
+ /* TODO: The complete server path has to be saved somewhere */
-
+ echo "<p> </p>";
+ echo "<p><b>RosCMS was set up
successfully!</b></p>";
}
else {
?>
@@ -77,11 +136,12 @@
if (get_magic_quotes_gpc()) {
die("<p>ERROR: Disable 'magic quotes' in php.ini
(=Off)</p>");
}
- else {
?>
- <p><a href="install.php?ready=step2"><b>Next
></b></a></p>
- <p> </p>
+ <p>Your PHP installation is configured correctly. Click <i>Next</i>
to continue!</p>
+
+ <p><a href="install.php?ready=step2"><b>Next
></b></a></p>
<?php
- }
}
-?>
+?>
+</body>
+</html>