File Source for stats.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');
$tw = new TeraWurfl();
$db = $tw->db;
$missing_tables = false;
if($db->connected === true){
$required_tables = array(TeraWurflConfig::$TABLE_PREFIX.'Cache',TeraWurflConfig::$TABLE_PREFIX.'Index',TeraWurflConfig::$TABLE_PREFIX.'Merge');
$tables = $db->getTableList();
// See what tables are in the DB
//die(var_export($tables,true));
foreach($required_tables as $req_table){
if(!in_array($req_table,$tables)){
$missing_tables = true;
}
}
}
$mergestats = $db->getTableStats(TeraWurflConfig::$TABLE_PREFIX.'Merge');
$indexstats = $db->getTableStats(TeraWurflConfig::$TABLE_PREFIX.'Index');
$cachestats = $db->getTableStats(TeraWurflConfig::$TABLE_PREFIX.'Cache');
$matcherList = $db->getMatcherTableList();
$matchers = array();
foreach($matcherList as $name){
$matchers[] = array('name'=>$name,'stats'=>$db->getTableStats($name));
}
$logfile = $tw->rootdir.TeraWurflConfig::$DATADIR.TeraWurflConfig::$LOG_FILE;
if(!is_readable($logfile) || filesize($logfile) < 5){
$lastloglines = "Empty";
}else{
$logarr = file($logfile);
$loglines = 30;
if(count($logarr)<$loglines)$loglines=count($logarr);
$end = count($logarr)-1;
$lastloglines = '';
for($i=$end;$i>=($end-$loglines);$i--){
$lastloglines .= @htmlspecialchars($logarr[$i])." ";
}
}
?>
<!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 Administration</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
Loaded WURFL: <?php echo $tw->getSetting(TeraWurfl::$SETTING_WURFL_VERSION); ?>
</div>
</td></tr><tr><td>
<h3>
<a href="index.php"><< Back to main page </a></h3>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<th scope="col">Database Table </th>
<th scope="col">Statistics</th>
</tr>
<tr>
<td width="145" class="darkrow">MERGE
<?php echo TeraWurflConfig::$TABLE_PREFIX.'Merge'?></td>
<td width="655" class="darkrow">Rows: <?php echo $mergestats['rows']?>
Actual Devices: <?php echo $mergestats['actual_devices']?>
Table Size: <?php echo WurflSupport::formatBytes($mergestats['bytesize'])?>
Purpose:
The MERGE table holds all the data from the WURFL file, whether it be local, remote or remote CVS, whenever a new WURFL is loaded, it is loaded into this table first, then it is filtered through all the UserAgentMatchers and split into many different tables specific to each matching technique. This MERGE table is retained for a last chance lookup if the UserAgentMatchers and INDEX table are unable to provide a conclusive match.</td>
</tr>
<?php if(!empty($indexstats)){ ?>
<tr>
<td class="lightrow">INDEX
<?php echo TeraWurflConfig::$TABLE_PREFIX.'Index'?></td>
<td class="lightrow">Rows: <?php echo $indexstats['rows']?>
Table Size: <?php echo WurflSupport::formatBytes($indexstats['bytesize'])?>
Purpose:
The INDEX table acts as a lookup table for WURFL IDs and their respective UserAgentMatchers. </td>
</tr>
<?php } ?>
<tr>
<td class="darkrow">CACHE
<?php echo TeraWurflConfig::$TABLE_PREFIX.'Cache'?></td>
<td class="darkrow">Rows: <?php echo $cachestats['rows']?>
Table Size: <?php echo WurflSupport::formatBytes($cachestats['bytesize'])?>
Purpose:
The CACHE table stores unique user agents and the complete capabilities and device root that were determined when the device was first identified. Unlike version 1.x, the CACHE table stores every device that is detected permanently. When the device database is updated, the cached devices are also redetected and recached. This behavior is configurable.</td>
</tr>
<?php if(!empty($matchers)){ ?>
<tr>
<td class="lightrow" style="vertical-align:top;">User Agent Matchers
Purpose:
The User Agent Matchers store similar user agents. Tera-WURFL sorts all the devices into the most appropriate UserAgentMatcher table to make lookups faster and perform different matching hueristics on certain groups of devices.</td><td>
<table>
<?php
$i=0;
foreach($matchers as $matcher){
$class = ($i % 2 == 0)? "lightrow": "darkrow";
?>
<tr><td class="<?php echo $class;?>">UserAgentMatcher: <?php echo $matcher['name']?>
Rows: <?php echo $matcher['stats']['rows']?>
Table Size: <?php echo WurflSupport::formatBytes($matcher['stats']['bytesize'])?></td></tr>
<?php
$i++;
}
?></table></td>
</tr>
<?php } ?>
</table>
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<th scope="col">Tera-WURFL Settings</th>
</tr>
<tr><td>Installation Directory: <?php echo dirname(dirname(__FILE__)); ?></td></tr>
<tr>
<td class="lightrow">-- Database options --
DB_HOST
<?php echo TeraWurflConfig::$DB_HOST?>
, database server hostname or IP
DB_USER
<?php echo TeraWurflConfig::$DB_USER?>
, database username (needs SELECT,INSERT,DELETE,DROP,CREATE)
DB_PASS ********, database password
DB_SCHEMA
<?php echo TeraWurflConfig::$DB_SCHEMA?>
, database schema (database name)
DB_CONNECTOR
<?php echo TeraWurflConfig::$DB_CONNECTOR?>
, database type (MySQL4, MySQL5, MSSQL2005, etc...);
TABLE_PREFIX
<?php echo TeraWurflConfig::$TABLE_PREFIX?>
, prefix to be used for all table names
-- General options --
WURFL_DL_URL
<?php echo TeraWurflConfig::$WURFL_DL_URL?>
, full URL to the current WURFL
WURFL_CVS_URL
<?php echo TeraWurflConfig::$WURFL_CVS_URL?>
, full URL to development (CVS) WURFL
DATADIR
<?php echo TeraWurflConfig::$DATADIR?>
, where all data is stored (wurfl.xml, temp files, logs)
CACHE_ENABLE <?php echo WurflSupport::showBool(TeraWurflConfig::$CACHE_ENABLE)?>, enables or disables the cache
PATCH_ENABLE
<?php echo WurflSupport::showBool(TeraWurflConfig::$PATCH_ENABLE)?>
, enables or disables the patch
PATCH_FILE
<?php echo TeraWurflConfig::$PATCH_FILE?>
, optional patch file for WURFL. To use more than one, separate them with semicolons
WURFL_FILE
<?php echo TeraWurflConfig::$WURFL_FILE?>
, path and filename of wurfl.xml
WURFL_LOG_FILE
<?php echo TeraWurflConfig::$LOG_FILE?>
, defines full path and filename for logging
LOG_LEVEL
<?php echo WurflSupport::showLogLevel(TeraWurflConfig::$LOG_LEVEL)?>
, desired logging level. Use the same constants as for PHP logging
OVERRIDE_MEMORY_LIMIT
<?php echo WurflSupport::showBool(TeraWurflConfig::$OVERRIDE_MEMORY_LIMIT)?>
, override PHP's default memory limit
MEMORY_LIMIT
<?php echo TeraWurflConfig::$MEMORY_LIMIT?>
, the amount of memory to allocate to PHP if OVERRIDE_MEMORY_LIMIT is enabled
SIMPLE_DESKTOP_ENGINE_ENABLE
<?php echo WurflSupport::showBool(TeraWurflConfig::$SIMPLE_DESKTOP_ENGINE_ENABLE)?>
, enable the SimpleDesktop Detection Engine to increase performance
CAPABILITY_FILTER:
<?php echo "<pre class=\"setting\">".var_export(TeraWurflConfig::$CAPABILITY_FILTER,true)."</pre>";?>
the capability filter that is used to determine which capabilities are available
</td>
</tr>
</table>
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<th scope="col">Log File (last 30 lines) </th>
</tr>
<tr>
<td class="lightrow"><div class="logfile"><?php echo $lastloglines?></div>
</td>
</tr>
</table>   </td>
</tr></table>
</body>
</html>

Source for file stats.php