/
channels.php
87 lines (74 loc) · 1.85 KB
/
channels.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
<?php
/*
***************************************************************
| Copyright (c) 2007-2010 Clip-Bucket.com. All rights reserved.
| @ Author : ArslanHassan
| @ Software : ClipBucket , © PHPBucket.com
****************************************************************
*/
define("THIS_PAGE",'channels');
define("PARENT_PAGE",'channels');
require 'includes/config.inc.php';
$userquery->perm_check('view_channels',true);
//Setting Sort
$sort = $_GET['sort'];
//$u_cond = array('category'=>mysql_clean($_GET['cat']),'date_span'=>$_GET['time']);
//Thanks to florin.mandache
$u_cond = array('category'=>mysql_clean($_GET['cat']),'date_span'=>mysql_clean($_GET['time']));
switch($sort)
{
case "most_recent":
default:
{
$u_cond['order'] = " doj DESC ";
}
break;
case "most_viewed":
{
$u_cond['order'] = " profile_hits DESC ";
}
break;
case "featured":
{
$u_cond['featured'] = "yes";
}
break;
case "top_rated":
{
$u_cond['order'] = " rating DESC";
}
break;
case "most_commented":
{
$u_cond['order'] = " total_comments DESC";
}
break;
}
//Getting User List
$page = mysql_clean($_GET['page']);
$get_limit = create_query_limit($page,CLISTPP);
$count_query = $ulist = $u_cond;
$ulist['limit'] = $get_limit;
$users = get_users($ulist);
Assign('users', $users);
$counter = get_counter('channel',$count_query);
if(!$counter)
{
//Collecting Data for Pagination
$ucount = $u_cond;
$ucount['count_only'] = true;
$total_rows = get_users($ucount);
$counter = $total_rows;
update_counter('channel',$count_query,$counter);
}
$total_pages = count_pages($counter,CLISTPP);
//Pagination
$link==NULL;
$extra_params=NULL;
$tag='<li><a #params#>#page#</a><li>';
$pages->paginate($total_pages,$page,$link,$extra_params,$tag);
//$pages->paginate($total_pages,$page);
subtitle(lang('channels'));
template_files('channels.html');
display_it();
?>