=' : '<=' );
$where = " AND clicks $link_moreless $link_limit";
} else {
$link_filter = '';
}
$base_page = 'admin/index.php';
### Searching
if(!empty($search) && !empty($_GET['s_in'])) {
switch($_GET['s_in']) {
case 'id':
$search_in_text = 'ID';
$search_in_sql = 'id';
break;
case 'url':
$search_in_text = 'URL';
$search_in_sql = 'url';
break;
case 'ip':
$search_in_text = 'IP Address';
$search_in_sql = 'ip';
break;
}
$search_text = stripslashes($search);
$search_display = "Searching for $search_text in $search_in_text. ";
$search_url = "&s_search=$search_text &s_in=$search_in_sql";
$search = str_replace('*', '%', '*'.$search.'*');
$where .= " AND $search_in_sql LIKE ('$search')";
}
### Sorting
if(!empty($_GET['s_by']) || !empty($_GET['s_order'])) {
switch($_GET['s_by']) {
case 'id':
$sort_by_text = 'ID';
$sort_by_sql = 'id';
break;
case 'url':
$sort_by_text = 'URL';
$sort_by_sql = 'url';
break;
case 'timestamp':
$sort_by_text = 'Date';
$sort_by_sql = 'timestamp';
break;
case 'ip':
$sort_by_text = 'IP Address';
$sort_by_sql = 'ip';
break;
case 'clicks':
$sort_by_text = 'Clicks';
$sort_by_sql = 'clicks';
break;
}
switch($_GET['s_order']) {
case 'asc':
$sort_order_text = 'Ascending Order';
$sort_order_sql = 'asc';
break;
case 'desc':
$sort_order_text = 'Descending Order';
$sort_order_sql = 'desc';
break;
}
}
## Get URLs Count for current filter, total links in DB & total clicks
$total_items = $db->get_var("SELECT COUNT(id) FROM url WHERE 1=1 $where");
$totals = $db->get_row("SELECT COUNT(id) as c, SUM(clicks) as s FROM url WHERE 1=1");
### Checking $page, $offset, $perpage
if(empty($page) || $page == 0) { $page = 1; }
if(empty($offset)) { $offset = 0; }
if(empty($perpage) || $perpage == 0) { $perpage = 50; }
### Determine $offset
$offset = ($page-1) * $perpage;
### Determine Max Number Of Items To Display On Page
if(($offset + $perpage) > $total_items) {
$max_on_page = $total_items;
} else {
$max_on_page = ($offset + $perpage);
}
### Determine Number Of Items To Display On Page
if (($offset + 1) > ($total_items)) {
$display_on_page = $total_items;
} else {
$display_on_page = ($offset + 1);
}
### Determing Total Amount Of Pages
$total_pages = ceil($total_items / $perpage);
?>
Insert URL « YOURLS » Your Own URL Shortener | <?php echo YOURLS_SITE; ?>
Your are logged in as: . Logout
Display to of URLs.
Overall, tracking c); ?> links, s); ?> clicks, and counting!
| Link ID |
Original URL |
Short URL |
Date |
IP |
Clicks |
Actions |
|
|
Pages ():
= 4) {
echo '« First ... ';
}
if($page > 1) {
echo ' « ';
}
for($i = $page - 2 ; $i <= $page +2; $i++) {
if ($i >= 1 && $i <= $total_pages) {
if($i == $page) {
echo "[$i] ";
} else {
echo ''.$i.' ';
}
}
}
if($page < $total_pages) {
echo ' » ';
}
if (($page+2) < $total_pages) {
echo ' ... Last »';
}
?>
|
get_results("SELECT * FROM url WHERE 1=1 $where ORDER BY $sort_by_sql $sort_order_sql LIMIT $offset, $perpage;");
if($url_results) {
foreach( $url_results as $url_result ) {
$base36 = yourls_int2string($url_result->id);
$timestamp = strtotime($url_result->timestamp);
$id = ($url_result->id);
$url = stripslashes($url_result->url);
$ip = $url_result->ip;
$clicks = $url_result->clicks;
echo yourls_table_add_row($id, $base36, $url, $ip, $clicks, $timestamp );
}
} else {
echo '| No URL Found |
';
}
?>
