[sabret00the]

ok let me find an example of the code you need.

taken straight from some code i'm working on.

you'd need to set your pagenav variables i.e.

PHP Code:

    // ###################### pagenav
    $page = iif($page < 1, "1", intval($page));
    $totalposts = $grps_showgroup['totalposts'];
    $currentlocation = "viewthread.php?$session[sessionurl]g=$groupid";
    $perpage = intval($vboptions['grpspostsperpage']);
    $pagenumber = $page;
    $upperlimit = ($page * $perpage);
    $final_calculations = ($upperlimit - $perpage); 


then you'd need to make sure that the query realises the code (based on the code of the hack you're using)

PHP Code:

    $inusers = $DB_site->query("
                                    SELECT user.username, user.userid, usertextfield." . $whichlist . "
                                    FROM " . TABLE_PREFIX . "user AS user, " . TABLE_PREFIX . "usertextfield AS usertextfield
                                    WHERE user.userid = usertextfield.userid AND FIND_IN_SET('" . $userinfo[userid] . "', 
                                    REPLACE(usertextfield." . $whichlist . ", ' ', ',')) > 0
                                    ORDER BY user.username
                                    LIMIT $final_calculations, $perpage
                                ");