function htmlstats()
{
global $db;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<title>AutoWikiBrowser Usage Stats</title>
<meta name="generator" content="AWB UsageStats PHP app v<?php
echo MAJOR . '.' . MINOR;
?>
" />
<meta name="copyright" content="<?php
echo "©";
?>
2008 Stephen Kennedy, Sam Reed" />
<style type="text/css">
BODY, .default {
font-size : 12pt;
font-family : Arial, Courier, Helvetica;
color : Black;
}
a:link {
color : blue;
text-decoration : none;
}
A:visited {
color : purple;
text-decoration : none;
}
a:hover {
color : #D79C02;
text-decoration : underline;
}
table, caption {
width : 700px;
}
table, caption, th, td {
border-width : 1px;
border-style : solid;
}
caption {
border-bottom-width : 0px;
font-weight : bold;
}
TH.sortable {
cursor : pointer;
}
</style>
<script src="/res/sorttable.js" type="text/javascript"></script>
</head>
<body>
<h2><a href="http://en.wikipedia.org/wiki/WP:AWB">AutoWikiBrowser</a> Usage Stats</h2>
<p>Statistics on AWB usage since 20 May 2009.</p>
<p>For more information about the AutoWikiBrowser wiki editor, please see our <a href="http://en.wikipedia.org/wiki/WP:AWB">Wikipedia page</a>.</p>
<p>For statistics between 3 March 2008 and 19 May 2009, please see <a href="./archive/May2009.html">here</a></p>
<table>
<caption>Overview</caption>
<?php
//Number of sessions, Number of saves,
$row = $db->no_of_sessions_and_saves();
PrintTableRow('Number of Sessions', FormatNumber($row['nosessions']));
PrintTableRow('Total Number of Saves', FormatNumber($row['totalsaves']));
// Number of wikis
$row = $db->wiki_count();
PrintTableRow('Number of Wiki Sites', FormatNumber($row['Wikis']));
// Username count
$row = $db->username_count();
PrintTableRow('Number of Usernames Known', FormatNumber($row['usercount']));
//Unique users count (username/wiki)
$row = $db->unique_username_count();
PrintTableRowNoHeaderEncoding('Number of Unique Users<sup><a href="#1">1</a></sup>', FormatNumber($row['UniqueUsersCount']));
$row = $db->language_count();
PrintTableRow('Number of Unique Languages', FormatNumber($row['langcount']));
//Number of plugins known
$row = $db->plugin_count();
PrintTableRow('Number of Plugins Known', FormatNumber($row['Plugins']));
// Number of log entries
$row = $db->db_mysql_query_single_row('SELECT COUNT(DISTINCT LogID) as LogIDCount FROM log', 'htmlstats', 'Stats');
// note: we'll only display this on this web page, hence doing it here
PrintTableRow('Number of Log Entries', FormatNumber($row['LogIDCount']));
// Record count
$row = $db->record_count();
PrintTableRow('Total Number of Records in Database', FormatNumber($row['RecordCount']));
//Sessions & Saves per sites
echo '
</table>
<p/>
<table class="sortable">
<caption><a name="sites"></a>Sessions, users & saves per site<sup><a href="#2">2</a></sup></caption>
<thead>
<tr>
<th scope="col" class="sortable">Site</th>
<th scope="col" class="sortable">Number of Unique Users</th>
<th scope="col" class="sortable">Number of Sessions</th>
<th scope="col" class="sortable">Number of Saves</th>
</tr>
</thead>
';
$result = $db->sites();
while ($row = $result->fetch_assoc()) {
$site = BuildWikiHostname($row['LangCode'], $row['Site']);
echo '
<tr>
<td>' . $site . '</td>
<td>' . FormatNumber($row['UniqueUsers']) . '</td>
<td>' . FormatNumber($row['CountOfSessionID']) . '</td>
<td>' . FormatNumber($row['SumOfSaves']) . '</td>
</tr>
';
}
$result->close();
//OS Stats
OS_XHTML($db->OSs(), '');
OS_XHTML($db->OSs(true), ' (last 30 days)');
//Number of saves by language (culture)
echo '
</table>
<p/>
<table class="sortable">
<caption>UI Cultures</caption>
<thead>
<tr>
<th scope="col" class="sortable">Language</th>
<th scope="col" class="sortable">Country</th>
<th scope="col" class="sortable">Number of Saves</th>
</tr>
</thead>
';
$result = $db->cultures();
while ($row = $result->fetch_assoc()) {
echo '
<tr>
<td>' . htmlspecialchars($row['Language']) . '</td>
<td>' . htmlspecialchars($row['Country']) . '</td>
<td>' . FormatNumber($row['SumOfSaves']) . '</td>
</tr>
';
}
$result->close();
//User with the most saves
$row = $db->busiest_user();
$site = BuildWikiHostname($row['LangCode'], $row['Site']);
echo '
</table>
<p/>
<table>
<caption>User with the most saves<sup><a href="#3">3</a></sup></caption>
<thead>
<tr>
<th scope="col">Site</th>
<th scope="col">LangCode</th>
<th scope="col">Number of Saves</th>
</tr>
</thead>
<tr>
<td>' . $site . '</td>
<td>' . FormatNumber($row['LangCode']) . '</td>
<td>' . FormatNumber($row['SumOfSaves']) . '</td>
</tr>
';
// List of plugins
echo '
</table>
<p/>
<table class="sortable">
<caption>Known Plugins</caption>
<thead>
<tr>
<th colspan="2" scope="col" class="sortable">Plugin</th>
<th colspan="1" scope="col" class="sortable">Plugin Type</th>
</tr>
</thead>
';
$result = $db->plugins();
while ($row = $result->fetch_assoc()) {
$plugintype = PluginType($row['PluginType']);
echo '
<tr>
<td colspan="2" align="left">' . $row['Plugin'] . '</td>
<td colspan="2" align="left">' . PluginType($row['PluginType']) . '</td>
</tr>
';
}
$result->close();
?>
</table>
<p/>
<table>
<caption><a name="Diagnostics"></a>Diagnostics</caption>
<tr>
<th align="left" scope="row">Script version</th><td><?php
echo MAJOR . '.' . MINOR;
?>
</td>
</tr>
<?php
// Script errors
$row = $db->errors();
PrintTableRow('Submission errors', $row['Errors']);
$row = $db->errors_fixed();
PrintTableRow('Submission errors (not fixed)', $row['Errors']);
// Username not recorded
$row = $db->missing_usernames_count();
PrintTableRow('Number of sessions where username not recorded', $row['MissingUsernames']);
echo '<!-- kingboyk: Not sure what\'s happening here, seems to be RU wiki only possibly just one user... do we still have a bug in username gathering or did he perhaps alter the AWB source code? Hmm... -->';
?>
</table>
<p>Note: These statistics are designed to help AWB developers better understand how the program is being used and to prioritise
development tasks. They are <i>indicative only</i> - for example, we don't currently take any account of a user changing
their username or switching to a different wiki mid-session.</p>
<div><small>
<sup><a name="1">1</a></sup>Unique username/wiki/language code<br/>
<sup><a name="2">2</a></sup>Only sites at which AWB has logged 50 or more saves are shown<br/>
<sup><a name="3">3</a></sup>Anonymous (usernames are not revealed)
</small>
<br/></div>
<hr/>
<p>
<a href="http://validator.w3.org/check?uri=referer"><img
src="http://www.w3.org/Icons/valid-xhtml10"
alt="Valid XHTML 1.0 Transitional" height="31" width="88" /></a>
<a href="http://www.php.net/"><img src="./res/php5-power-micro.png" alt="Powered by PHP 5" height="15" width="80" /></a>
</p>
</body>
</html>
<?php
}
// Number of never checked out articles
$query = "SELECT COUNT(articleid) AS nonevercheckedout FROM articles WHERE (checkedout = '0000-00-00 00:00:00')";
$result = mysql_fetch_array(mysql_query($query));
PrintTableRow("Number of Never Checked Out Articles", FormatNumber($result['notevercheckedout']));
// Number of ever checked out articles
$query = 'SELECT COUNT(articleid) AS noevercheckedout FROM articles WHERE (checkedout > "0000-00-00 00:00:00")';
$result = mysql_fetch_array(mysql_query($query));
PrintTableRow('Number of Ever Checked Out Articles', FormatNumber($result['noevercheckedout']));
// Number of users
$query = 'SELECT COUNT(userid) AS nousers FROM users';
$result = mysql_fetch_array(mysql_query($query));
PrintTableRow('Number of Users', FormatNumber($result['nousers']));
// Number of sites
$query = 'SELECT COUNT(siteid) AS nosites FROM site';
$result = mysql_fetch_array(mysql_query($query));
PrintTableRow('Number of Sites', FormatNumber($result['nosites']));
echo '</table>
<p/>';
// Site stats
echo '<table class="sortable">
<caption>Site Stats</caption>
<thead>
<tr>
<th scope="col" class="sortable">Site</th>
<th scope="col" class="sortable">Number of Saved Articles</th>
<th scope="col" class="sortable">Number of Skipped Articles</th>
<th scope="col" class="sortable">Number of Currently Checked-Out Articles</th>
<th scope="col" class="sortable">Number of Unfinished Articles</th>
<th scope="col" class="sortable">Total Number of Articles</th>
</tr>
</thead>';
