| noonespecial |
08-13-2006 07:02 AM |
Pagination Help
Here's what I have:
PHP Code:
// Likes
/////////////////////////////
$vBFriends_dis_likes = array();
$vBFriends_dis_likes_ids = array();
$vBFriends_dis_likes_ids = explode(' ', trim($userinfo[$whichlist]));
if (trim($userinfo[$whichlist]) != "") {
$vBFriends_dis_likes_query = $vbulletin->db->query(
"SELECT ".TABLE_PREFIX."user.username,".TABLE_PREFIX."user.userid,".TABLE_PREFIX."usertextfield.".$whichlist." FROM
".TABLE_PREFIX."user,".TABLE_PREFIX."usertextfield WHERE
".TABLE_PREFIX."user.userid = ".TABLE_PREFIX."usertextfield.userid AND
".TABLE_PREFIX."user.userid IN (".implode(',',$vBFriends_dis_likes_ids).")
ORDER BY username"
);
if ($vbulletin->db->affected_rows() > 0) {
while ($vBFriends_dis_likes_entry = $vbulletin->db->fetch_array($vBFriends_dis_likes_query)) {
$vBFriends_dis_likes[$vBFriends_dis_likes_entry['userid']] = $vBFriends_dis_likes_entry['username'];
}
}
}
// Liked by
/////////////////////////////
$vBFriends_dis_liked = array();
$vBFriends_dis_liked_query = $vbulletin->db->query(
"SELECT ".TABLE_PREFIX."user.username,".TABLE_PREFIX."user.userid,".TABLE_PREFIX."usertextfield.".$whichlist." FROM
".TABLE_PREFIX."user,".TABLE_PREFIX."usertextfield WHERE
".TABLE_PREFIX."user.userid = ".TABLE_PREFIX."usertextfield.userid AND
FIND_IN_SET('".$userinfo['userid']."', REPLACE(".TABLE_PREFIX."usertextfield.".$whichlist.", ' ', ',')) > 0
ORDER BY ".TABLE_PREFIX."user.username"
);
if ($vbulletin->db->affected_rows() > 0) {
while ($vBFriends_dis_liked_entry = $vbulletin->db->fetch_array($vBFriends_dis_liked_query)) {
$vBFriends_dis_liked[$vBFriends_dis_liked_entry['userid']] = $vBFriends_dis_liked_entry['username'];
}
}
// Friends
/////////////////////////////
$vBFriends_list = array();
foreach($vBFriends_dis_likes as $key => $value) {
if (array_key_exists($key, $vBFriends_dis_liked)) $vBFriends_list[$key] = $value;
}
And I'm trying to then take the $vBFriends_list and make that what I pass through the pagnav - however, it's not working. I've searched this forum - but found no real help for this problem.
This is what I've been building off of:
PHP Code:
$vbulletin->input->clean_array_gpc('r', array(
'page' => TYPE_INT,
'pp' => TYPE_INT,
'order' => TYPE_NOHTML,
'sort' => TYPE_NOHTML
));
$page =& $vbulletin->GPC['page'];
$pp =& $vbulletin->GPC['pp'];
$order =& $vbulletin->GPC['order'];
$sort =& $vbulletin->GPC['sort'];
$countj= $db->query_first("SELECT COUNT(*) FROM".TABLE_PREFIX."user.username,".TABLE_PREFIX."user.userid,".TABLE_PREFIX."usertextfield.".$whichlist." FROM
".TABLE_PREFIX."user,".TABLE_PREFIX."usertextfield WHERE
".TABLE_PREFIX."user.userid = ".TABLE_PREFIX."usertextfield.userid AND
FIND_IN_SET('".$userinfo['userid']."', REPLACE(".TABLE_PREFIX."usertextfield.".$whichlist.", ' ', ',')) > 0
ORDER BY ".TABLE_PREFIX."user.username"
);
if (empty($perpage)) $perpage = 15;
if (empty($page))
{
$page= 1;
}
$start= (($page * $perpage) - $perpage);
$pagenumber = $page++;
if ($pagenumber < 1)
{
$pagenumber = 1;
}
else if ($pagenumber > $countj['entries'])
{
$pagenumber = $countj['entries'];
}
$pgnav= construct_page_nav($pagenumber, $perpage, $countj['entries'], "journal.php?" . $vbulletin->session->vars['sessionurl'] . (!empty($vbulletin->GPC['pp']) ? "&pp=$perpage" : ""));
require_once(DIR . '/includes/functions_bigthree.php');
$datecut = TIMENOW - $vbulletin->options['cookietimeout'];
$browsers = '';
$comma = '';
But It's not going as smoothly as I thought. Grrrr.
Anyone?!
No one helps around here anymore - it kinda sucks. |
More Information