function daily_lookups_stats($date)
{
global $dict_db;
echo '<a href="stats.php">Summary</a> | ';
echo "<a href=\"stats.php?daily={$date}\">Daily per user stats for {$date}</a> | ";
echo "<b>Daily lookup stats for {$date} </b>";
echo "<p>";
$today_lookups_q = "SELECT word,cookie,TO_DAYS(query_time) as today_day_no FROM request_log WHERE DATE_FORMAT(query_time, '%Y-%m-%d')='{$date}';";
$today_lookups_rows = $dict_db->get_results($today_lookups_q);
?>
<table id="stats" cellspacing="0">
<tr class="header">
<td>Word requested</td>
<td>Word found</td>
<td>User</td>
<td>Total requests</td>
<td>Days registered
<td>Lookups per day</td>
</tr>
<?php
$selected = false;
foreach ($today_lookups_rows as $row) {
$word_requested = $row->word;
$today_day_no = $row->today_day_no;
$cookie = $row->cookie;
$dev_info_q = "SELECT dev_info,TO_DAYS(when_created) AS reg_day_no FROM cookies WHERE cookie='{$cookie}';";
$rows = $dict_db->get_results($dev_info_q);
$reg_day_no = $rows[0]->reg_day_no;
$days_registered = $today_day_no - $reg_day_no + 1;
$dev_info = $rows[0]->dev_info;
$dev_info_decoded = decode_di($dev_info);
$device_name = $dev_info_decoded['device_name'];
$hotsync_name = 'Unavailable';
if (isset($dev_info_decoded['HS'])) {
$hotsync_name = $dev_info_decoded['HS'];
}
$word_found = "";
$word_row = get_word_row_try_stemming($word_requested);
if ($word_row) {
if ($word_row->word != $word_requested) {
$word_requested = $word_row->word;
}
}
$total_lookups_q = "SELECT COUNT(*) FROM request_log WHERE cookie='{$cookie}'";
$total_lookups_count = $dict_db->get_var($total_lookups_q);
$lookups_per_day = aveg_txt($total_lookups_count, $days_registered);
if ($selected) {
echo "<tr class=\"selected\">\n";
} else {
echo "<tr>\n";
}
if ($selected) {
echo "<tr class=\"selected\">\n";
} else {
echo "<tr>\n";
}
if ($word_row) {
echo " <td>{$word_requested}</td>\n";
} else {
echo " <td><font color=\"red\">{$word_requested}</font></td>\n";
}
echo " <td>{$word_found}</td>\n";
echo " <td><a href=\"stats.php?user={$cookie}\">{$hotsync_name}</a></td>\n";
echo " <td>{$total_lookups_count}</td>\n";
echo " <td>{$days_registered}</td>\n";
echo " <td>{$lookups_per_day}</td>\n";
echo "</tr>\n";
if ($selected) {
$selected = false;
} else {
$selected = true;
}
}
exit;
}
function serve_get_word($cookie, $word, $reg_code)
{
global $f_check_limits;
/*
if ( $word=='wl' )
{
write_WORDLIST( "word one\nand another\nand even more\nword three\ntest\nsample\n" );
exit;
}
if ( $word=='tm' )
{
write_MSG( "This is a test message. Do you hear me now?" );
exit;
}
*/
$requests_left = -1;
if (!$reg_code && $f_check_limits) {
$total_requests = get_total_requests_for_cookie($cookie);
$requests_left = TOTAL_REQUESTS_LIMIT - $total_requests + DAILY_REQUESTS_LIMIT;
if ($requests_left <= 0) {
$today_requests = get_today_requests_for_cookie($cookie);
$requests_left = DAILY_REQUESTS_LIMIT - $today_requests;
if ($requests_left <= 0) {
report_no_lookups_left();
}
} else {
$requests_left = TOTAL_REQUESTS_LIMIT - $total_requests + DAILY_REQUESTS_LIMIT;
}
}
log_get_word_request($cookie, $word, $reg_code);
$word_row = get_word_row_try_stemming($word);
if ($word_row) {
write_DEF($word_row->word, $word_row->pron, $word_row->def, $requests_left);
} else {
write_MSG("Definition of word '{$word}' has not been found");
}
exit;
}
