$country = $row['country'];
//echo '<div class="flags"><img src="../flags/png/' . strtolower($iso[$country]) . '.png"> ' . $country . ' ' . $row['count'] . ' click(s) </div>';
}
echo "</div>";
echo "<img src=\"http://chart.apis.google.com/chart?chf=bg,t,bebebe&chco=233a4b%2C5ba1d2&cht=p3&chd=t:" . mb_substr($numbers, 0, -1) . "&chs=500x200&chl=" . mb_substr($countries, 0, -1) . "\" />";
$result = mysql_query("SELECT country, clicks FROM " . DB_PREFIX . "stats WHERE BINARY alias='{$alias}' GROUP BY country ORDER BY clicks DESC");
$countries = "";
$numbers = "";
while ($row = mysql_fetch_assoc($result)) {
$country = $row['country'];
$countries .= $row['country'] . "|";
$numbers .= $row['clicks'] . ",";
//echo $iso['$country'];
}
echo "<img src=\"http://chart.apis.google.com/chart?chf=bg,lc,bebsbe&cht=t&chs=440x220&chd=t:" . mb_substr($numbers, 0, -1) . "&chtm=world&chld=" . mb_substr($countries, 0, -1) . "\" float=\"right\" />";
$result = mysql_query("SELECT * FROM " . DB_PREFIX . "urls WHERE BINARY code = '{$alias}'");
$row = mysql_fetch_array($result);
?>
<br/>
<b>Top 5 countries for this URL:</b><br/>
<?php
$db_result = mysql_query("SELECT * FROM " . DB_PREFIX . "stats WHERE BINARY alias='{$alias}' ORDER BY clicks DESC LIMIT 0, 5") or db_die(__FILE__, __LINE__, mysql_error());
echo "<table style=\"padding: 3px;\" align=\"center\" id=\"url_list\">\n";
while ($db_row = mysql_fetch_assoc($db_result)) {
$db_row = array_filter($db_row, "stripslashes");
extract($db_row, EXTR_OVERWRITE | EXTR_PREFIX_ALL, "u");
$lowercountry = strtolower($u_country);
echo "<td><img src=\"images/flags/{$lowercountry}.png\" /> <b>{$u_country}</b> {$u_clicks}</td>\n";
unset($u_country, $u_alias, $u_clicks);
}
echo "</table>\n";
$db_query = "1 AND ";
$search_alias = mysql_real_escape_string(@$_GET['search_alias']);
$search_url = mysql_real_escape_string(@$_GET['search_url']);
if (!empty($search_alias)) {
$db_query .= "(code = '{$search_alias}' OR alias = '{$search_alias}') AND ";
}
if (!empty($search_url)) {
$db_query .= "url LIKE '%{$search_url}%' AND ";
}
$db_query = substr($db_query, 0, -5);
$db_result = mysql_query("SELECT COUNT(id) FROM " . DB_PREFIX . "urls WHERE {$db_query}") or db_die(__FILE__, __LINE__, mysql_error());
$db_row = mysql_fetch_row($db_result);
$db_count = (int) $db_row[0];
$db_start = ($page - 1) * 25;
$db_pages = ceil($db_count / 25);
$db_result = mysql_query("SELECT * FROM " . DB_PREFIX . "urls WHERE {$db_query} ORDER BY date_added DESC LIMIT {$db_start}, 25") or db_die(__FILE__, __LINE__, mysql_error());
echo "<table id=\"url_list\">\n";
echo "<tr>\n" . "<td><u>ID</td></u>\n" . "<td><u>Code</u></td>\n" . "<td><u>Alias</u></td>\n" . "<td><u>Long URL</u></td>\n" . "<td><u>Date Added</u></td>\n" . "<td><u>Delete</u></td>\n" . "</tr>\n";
while ($db_row = mysql_fetch_assoc($db_result)) {
$db_row = array_filter($db_row, "stripslashes");
extract($db_row, EXTR_OVERWRITE | EXTR_PREFIX_ALL, "u");
if (empty($u_alias)) {
$u_alias = "";
}
echo "<tr>\n" . "<td>{$u_id}</td>\n" . "<td>{$u_code}</td>\n" . "<td>" . htmlentities($u_alias) . "</td>\n" . "<td>" . htmlentities($u_url) . "</td>\n" . "<td>{$u_date_added}</td>\n" . "<td><a href=\"javascript:delete_url({$u_id});\">Delete</a></td>\n" . "</tr>\n";
unset($u_id, $u_code, $u_alias, $u_url, $u_date_added);
}
echo "</table>\n";
if ($db_count > 25) {
echo "<p>\n";
if ($page > 1) {
function get_url($alias)
{
$db_result = mysql_query("SELECT url FROM " . DB_PREFIX . "urls WHERE BINARY code = '{$alias}' OR alias = '{$alias}'") or db_die(__FILE__, __LINE__, mysql_error());
if (mysql_num_rows($db_result) > 0) {
$db_row = mysql_fetch_row($db_result);
return $db_row[0];
}
return false;
}
