$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; }