File Source for install.php

<?php
/**
* Tera_WURFL - PHP MySQL driven WURFL
*
* Tera-WURFL was written by Steve Kamerman, and is based on the
* Java WURFL Evolution package by Luca Passani and WURFL PHP Tools by Andrea Trassati.
* This version uses a MySQL database to store the entire WURFL file, multiple patch
* files, and a persistent caching mechanism to provide extreme performance increases.
*
* @package TeraWurflAdmin
* @author Steve Kamerman <stevekamerman AT gmail.com>
* @version Stable 2.1.3 $Date: 2010/09/18 15:43:21
* @license http://www.mozilla.org/MPL/ MPL Vesion 1.1
*/
require_once realpath(dirname(__FILE__).'/../TeraWurfl.php');
error_reporting(E_ERROR);
@$tw = new TeraWurfl();
$dir = $tw->rootdir.TeraWurflConfig::$DATADIR;
$logfile = TeraWurflConfig::$LOG_FILE;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Tera-WURFL Installation</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="800">
<tr><td>
<div align="center" class="titlediv">
Tera-WURFL <?php echo $tw->release_version; ?> Administration
</div>
</td></tr><tr><td>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<th colspan="2" scope="col">Checking Installation </th>
</tr>
<tr>
<td colspan="2" valign="bottom" class="darkrow">PHP Configuration
</td>
</tr>
<tr>
<td width="17" class="lightrow"><img src="triangle.gif" width="10" height="11" /></td>
<td width="783" class="lightrow">PHP Version:
<?php
if(version_compare(PHP_VERSION,TeraWurfl::$required_php_version) === 1){
echo PHP_VERSION."... OK";
}else{
echo "ERROR: PHP ".TeraWurfl::$required_php_version." is required but you have ".PHP_VERSION;
}
?></td>
</tr>
<tr>
<td class="darkrow"><img src="triangle.gif" width="10" height="11" /></td>
<td class="darkrow">ZipArchive Support <?php
if(class_exists("ZipArchive")){
echo "... OK";
}else{
echo "... WARNING In order to update the WURFL File from the Internet, you must have support for the ZipArchive module.
This module is included with PHP since 5.2.0. You can get the ZipArchive class from the <a href=\"http://pecl.php.net/package/zip\" target=\"_blank\">PECL Zip package</a>.
Note: you can still use Tera-WURFL without ZipArchive, Tera-WURFL will attempt to call the gunzip program from your system to unzip the compressed WURFL archive.
If this fails, you must download the archive manually and extract wurfl.xml to your data/ directory.";
}
?></td>
</tr>
<tr>
<td class="lightrow"><img src="triangle.gif" width="10" height="11" /></td>
<td class="lightrow">MySQLi Support <?php
if(class_exists("MySQLi")){ // SQL Driver for PHP: function_exists("sqlsrv_connect")
echo "... OK";
}else{
echo "... WARNING Since version 2.0, Tera-WURFL requires the MySQLi module to use MySQL. More information about obtaining MySQLi is available at <a href=\"http://www.php.net/manual/en/book.mysqli.php\" target=\"_blank\">www.php.net</a>.
If you are using the EXPERIMENTAL Microsoft SQL Server DatabaseConnector you can ignore this error message, however, you will need the <a href=\"http://msdn.microsoft.com/en-us/library/ms131321.aspx\" target=\"_blank\">SQL Server Native Client</a> and <a href=\"http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ccdf728b-1ea0-48a8-a84a-5052214caad9\" target=\"_blank\">SQL Server Driver for PHP 1.1</a> installed.";
}
?></td>
</tr>
<tr>
<td class="darkrow"><img src="triangle.gif" width="10" height="11" /></td>
<td class="darkrow">PHP Memory Limit:
<?php
if(TeraWurflConfig::$OVERRIDE_MEMORY_LIMIT){
echo TeraWurflConfig::$MEMORY_LIMIT." (via TeraWurflConfig::\$MEMORY_LIMIT)";
}else{
echo ini_get("memory_limit")." (via php.ini)";
}
?> When you update the WURFL, PHP may consume over 200MB of RAM while parsing, sorting and indexing the data.</td>
</tr>
<tr>
<td colspan="2" valign="bottom" class="darkrow">File Permissions
</td>
</tr>
<tr>
<td class="darkrow"><img src="triangle.gif" width="10" height="11" /></td>
<td class="darkrow">WURFL File: <?php echo $dir.TeraWurflConfig::$WURFL_FILE?>...
<?php
if(is_file($dir.TeraWurflConfig::$WURFL_FILE) && is_readable($dir.TeraWurflConfig::$WURFL_FILE))
echo "OK";
else
echo "WARNING: File doesn't exist or isn't readable. You can continue like this, you just can't update the database from your local wurfl.xml.";
?></td>
</tr>
<tr>
<td class="lightrow"><img src="triangle.gif" width="10" height="11" /></td>
<td class="lightrow">PATCH Files:
<?php
$files = explode(';',TeraWurflConfig::$PATCH_FILE);
foreach($files as $thisfile){
echo "$dir$thisfile...";
if(is_file($dir.$thisfile) && is_readable($dir.$thisfile))
echo "OK ";
else
echo "WARNING: File doesn't exist or isn't readable. You may ignore this error if patching is disabled. ";
}
?></td>
</tr>
<tr>
<td class="darkrow"><img src="triangle.gif" width="10" height="11" /></td>
<td class="darkrow">DATA Directory: <?php echo $dir?>...
<?php
if(is_dir($dir) && is_readable($dir) && is_writable($dir))
echo "OK";
else
echo "ERROR: Directory doesn't exist or isn't writeable. This directory should be owned by the webserver user or chmoded to 777 for the log file and the online updates to work. Here's the best way to do it in Ubuntu: <pre>sudo chgrp -R www-data data/
sudo chmod -R g+rw data/</pre>";
?></td>
</tr>
<tr>
<td colspan="2" valign="bottom" class="darkrow">Database Settings</td>
</tr>
<tr>
<td class="lightrow"><img src="triangle.gif" width="10" height="11" /></td>
<td class="lightrow">Host: <?php echo TeraWurflConfig::$DB_HOST?></td>
</tr>
<tr>
<td class="darkrow"><img src="triangle.gif" width="10" height="11" /></td>
<td class="darkrow">Username: <?php echo TeraWurflConfig::$DB_USER?></td>
</tr>
<tr>
<td class="lightrow"><img src="triangle.gif" width="10" height="11" /></td>
<td class="lightrow">Connecting to DB server...
<?php
if(!class_exists('MySQLi')){
echo "ERROR: MySQLi is not installed or enabled, see errors above.";
}elseif(function_exists('mysqli_connect_errno') && mysqli_connect_errno()){
echo "ERROR: ".mysqli_connect_error();
}else{
echo "OK";
}
$errors = $tw->db->verifyConfig();
if(!empty($errors)){
foreach($errors as $error){
echo " ERROR: $error";
}
}
?></td>
</tr>
<tr>
<td class="darkrow"><img src="triangle.gif" width="10" height="11" /></td>
<td class="darkrow">DB Server Version:
<?php
if(!$tw->db->connected){
echo "ERROR: The version number cannot be determined because you are not connected.";
}else{
$mysql_raw_version = $tw->db->getServerVersion();
if($mysql_raw_version !== false){
$mysql_version = (int)$mysql_raw_version[0];
echo $mysql_raw_version." ";
if(TeraWurflConfig::$DB_CONNECTOR == "MySQL4" && $mysql_version > 4){
echo "NOTICE: You are using the MySQL4 connector with MySQL5. Although this will work, the MySQL5 connector provides much better performance.
Since the MySQL4 connector does not use Stored Procedures, you can also use it if you want to use MySQL5 without Stored Procedures.";
}elseif(TeraWurflConfig::$DB_CONNECTOR == "MySQL5" && $mysql_version < 5){
echo "ERROR: You are using the MySQL5 connector with MySQL4. Please change the DatabaseConnector to MySQL4.";
}
}
}
?>
</td>
</tr>
<tr>
<td class="lightrow"><img src="triangle.gif" width="10" height="11" /></td>
<td class="lightrow">DB Name (schema): <?php echo TeraWurflConfig::$DB_SCHEMA?></td>
</tr>
<tr>
<td> </td>
<td><div align="left" style="padding-left:15px;">
If everything looks ok, delete <?php echo $tw->rootdir; ?>admin/install.php, then update your database from one of the following sources:
<ul><li><a href="updatedb.php?source=local">Your local WURFL file</a> (<?php echo TeraWurflConfig::$WURFL_FILE?>)</li>
<li><a href="updatedb.php?source=remote">The current released WURFL</a> (<?php echo TeraWurflConfig::$WURFL_DL_URL?>)</li>
</ul>
</div></td>
</tr>
</table>
</td>
</tr></table>
</body>
</html>

Source for file install.php