File Source for stats.php

<?php
require_once('../tera_wurfl_config.php');
require_once(WURFL_PARSER_FILE);
// connect to DB
$dbcon = mysql_connect(DB_HOST,DB_USER,DB_PASS) or die("Could not connect to MySQL Server (".DB_HOST."): ".mysql_error());
// select DB
mysql_select_db(DB_SCHEMA,$dbcon) or die("Connected to MySQL Server but could not select database (".DB_SCHEMA."): ".mysql_error($dbcon));
// check tables
$tablesres = mysql_query("SHOW TABLES");
$required_tables = array(DB_DEVICE_TABLE,DB_PATCH_TABLE,DB_HYBRID_TABLE);
$tables = array();
while($table = mysql_fetch_row($tablesres))$tables[]=$table[0];
foreach($required_tables as $req_table){
if(!in_array($req_table,$tables)){
echo "Required table '$req_table' was missing in database (".print_r($tables,true)."), creating... ";
emptyWurflDevTable($req_table);
}
}
function showBool($var){
if($var === true)return("true");
if($var === false)return("false");
return($var);
}
function showLogLevel($num){
$log_arr = array("LOG_EMERG","LOG_ALERT","LOG_CRIT","LOG_ERR","LOG_WARNING","LOG_NOTICE","LOG_INFO","LOG_DEBUG");
return($log_arr[$num]);
}
function tableStats($table){
$stats = array();
$fields = array();
$fieldnames = array();
$fieldsres = mysql_query("SHOW COLUMNS FROM ".$table);
while($row = mysql_fetch_assoc($fieldsres)){
$fields[] = 'CHAR_LENGTH(`'.$row['Field'].'`)';
$fieldnames[]=$row['Field'];
}
mysql_free_result($fieldsres);
$bytesizequery = "SUM(".implode('+',$fields).") AS `bytesize`";
$query = "SELECT COUNT(*) AS `rowcount`, $bytesizequery FROM `$table`";
$res = mysql_query($query);
$stats['rows'] = mysql_result($res,0,'rowcount');
$stats['bytesize'] = mysql_result($res,0,'bytesize');
mysql_free_result($res);
if(in_array("actual_device_root",$fieldnames)){
$res = mysql_query("SELECT COUNT(*) AS `devcount` FROM `$table` WHERE actual_device_root=1");
$stats['actual_devices'] = mysql_result($res,0,'devcount');
mysql_free_result($res);
}
return($stats);
}
function filesize_format($bytes){
$bytes=(float)$bytes;
if ($bytes<1024){
$numero=number_format($bytes, 0, '.', ',')." Bytes";
return $numero;
}
if ($bytes<1048576){
$numero=number_format($bytes/1024, 2, '.', ',')." KB";
return $numero;
}
if ($bytes>=1048576){
$numero=number_format($bytes/1048576, 2, '.', ',')." MB";
return $numero;
}
}
$devicestats = tableStats(DB_DEVICE_TABLE);
$patchstats = tableStats(DB_PATCH_TABLE);
$hybridstats = tableStats(DB_HYBRID_TABLE);
$cachestats = tableStats(DB_CACHE_TABLE);
if(!is_readable(WURFL_LOG_FILE)){
$lastloglines = "Empty";
}else{
$logarr = file(WURFL_LOG_FILE);
$loglines = 30;
$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 Administration
Version <?php echo "$branch $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">DB_DEVICE_TABLE
<?=DB_DEVICE_TABLE?></td>
<td width="655" class="darkrow">Rows: <?=$devicestats['rows']?>
Actual Devices: <?=$devicestats['actual_devices']?>
Table Size: <?=filesize_format($devicestats['bytesize'])?>
Purpose:
The device table holds the data from the WURFL file, whether it be local, remote or remote CVS, the whenever a new WURFL is loaded, it is loaded into this table first. The data in this table is never modified, and if patching is disabled, this table is queried for the device in question. </td>
</tr>
<tr>
<td class="lightrow">DB_PATCH_TABLE
<?=DB_PATCH_TABLE?></td>
<td class="lightrow">Rows: <?=$patchstats['rows']?>
Actual Devices: <?=$patchstats['actual_devices']?>
Table Size: <?=filesize_format($patchstats['bytesize'])?>
Purpose:
The patch table holds the data from the patch file, much like the device table, this data is not modified unless a new patch is loaded. When patching is enabled, this data is merged with the device table to create the hybrid table. </td>
</tr>
<tr>
<td class="darkrow">DB_HYBRID_TABLE
<?=DB_HYBRID_TABLE?></td>
<td class="darkrow">Rows: <?=$hybridstats['rows']?>
Actual Devices: <?=$hybridstats['actual_devices']?>
Table Size: <?=filesize_format($hybridstats['bytesize'])?>
Purpose:
The hybrid table is a combination of the device table and the patch table. People ask about this all the time so pay attention :) When you apply a patch to the main WURFL database, Tera-WURFL has to resolve conflicts between the main WURFL (the device table) and the patch table. Let's say you know that a Motorola RAZR has MP3 capability but the WURFL says it doesn't. You would figure out what WURFL DEVICE_ID the RAZR has, and you would add an entry in your patch file with that capability set correctly. Now, when you apply the patch, the script realizes that the RAZR exists in both the device table and the patch table - so it takes all the capabilities from the device table and puts them in the hybrid table, then it takes all your changes in the patch table and overwrites the existing ones in the hybrid table, effectively merging the conflicting items. Whenever your change the device or patch data you force Tera-WURFL to rebuild the hybrid table and you are presented with some stats about how many devices from your patch file are added and how many are merged. If you have patching enabled, this table is queried for the device in question. </td>
</tr>
<tr>
<td class="lightrow">DB_CACHE_TABLE
<?=DB_CACHE_TABLE?></td>
<td class="lightrow">Rows: <?=$cachestats['rows']?>
Table Size: <?=filesize_format($cachestats['bytesize'])?>
Purpose:
The cache table stores unique user agents and the complete capabilities and device root that were determined the last time it was processed. Any time the patch or devices table is updated, the cache table is cleared since the underlying data may have been modified - leaving the cache tainted. </td>
</tr>
</table>
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<th scope="col">Tera-WURFL Settings</th>
</tr>
<tr>
<td class="lightrow">-- Database options --
DB_HOST
<?=DB_HOST?>
, database server hostname or IP
DB_USER
<?=DB_USER?>
, database username (needs SELECT,INSERT,DELETE,DROP,CREATE)
DB_PASS ********, database password
DB_SCHEMA
<?=DB_SCHEMA?>
, database schema (database name)
DB_TYPE
<?=DB_TYPE?>
, database table type (MyISAM, InnoDB, HEAP, etc...);
DB_DEVICE_TABLE
<?=DB_DEVICE_TABLE?>
, database table name for the WURFL
DB_PATCH_TABLE
<?=DB_PATCH_TABLE?>
, database table name for the patch
DB_HYBRID_TABLE <?=DB_HYBRID_TABLE?>, database table name for the Hybrid of the WURFL and the patch
DB_CACHE_TABLE <?=DB_CACHE_TABLE?>, database table name for the cache
DB_MULTI_INSERT
<?=showBool(DB_MULTI_INSERT)?>
, use multiple inserts to speed DB updating
DB_MAX_INSERTS
<?=DB_MAX_INSERTS?>
, number of inserts per query
DB_EMPTY_METHOD
<?=DB_EMPTY_METHOD?>
, either DROP_CREATE or EMPTY; method for emptying tables.
DB_TEMP_EXT
<?=DB_TEMP_EXT?>
, extension that will be used for temporary tables like "mytablename_TEMP"
-- General options --
WURFL_DL_URL
<?=WURFL_DL_URL?>
, full URL to the current WURFL
WURFL_CVS_URL
<?=WURFL_CVS_URL?>
, full URL to development (CVS) WURFL
WURFL_CONFIG
<?=showBool(WURFL_CONFIG)?>
,lets other file know the config is loaded
DATADIR
<?=DATADIR?>
, where all data is stored (wurfl.xml, temp files, logs)
IMAGE_CHECKING
<?=showBool(IMAGE_CHECKING)?>
,checks the IMAGE_DIR for an image that matches the device
IMAGE_DIR
<?=IMAGE_DIR?>
, relative path to the device images with trailing slash
WURFL_CACHE_ENABLE <?=showBool(WURFL_CACHE_ENABLE)?>, enables or disables the cache
WURFL_PATCH_ENABLE
<?=showBool(WURFL_PATCH_ENABLE)?>
, enables or disables the patch
WURFL_PATCH_FILE
<?=WURFL_PATCH_FILE?>
, optional patch file for WURFL
WURFL_PARSER_FILE
<?=WURFL_PARSER_FILE?>
, path and filename of wurfl_parser.php
WURFL_CLASS_FILE
<?=WURFL_CLASS_FILE?>
, path and filename of wurfl_class.php
WURFL_FILE
<?=WURFL_FILE?>
, path and filename of wurfl.xml
WURFL_LOG_FILE
<?=WURFL_LOG_FILE?>
, defines full path and filename for logging
LOG_LEVEL
<?=showLogLevel(LOG_LEVEL)?>
, desired logging level. Use the same constants as for PHP logging
</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"><?=$lastloglines?></div>
</td>
</tr>
</table>   </td>
</tr></table>
</body>
</html>

Source for file stats.php