PLEASE HELP.. I'm trying to add pagination to my script that already works. But it seems that all I get is a blank white page when I call this. Can anyone please help me with this? I would appreciate it...
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'referrals');
// ################### PRE-CACHE TEMPLATES AND DATA ######################
$globaltemplates = array('refer','referbit','navbar');
// ######################### REQUIRE BACK-END ############################
chdir('/home/mine/public_html/forum/');//path to your vbulletin directory
require('./global.php');
// ######################### NAVIGATION ############################
$navbits = array();
$navbits[$parent] = 'Referral Statistics';
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
////////////start pagination section//////////////////////
///////////////////////////////////////////////////////////////
do {
if ($pageNum_Recordset1 > 0) { // Show if not first page
echo"<a href=\"printf(\"%s?pageNum_Recordset1=%d%s\", $currentPage, 0, $queryString_Recordset1);\">First</a>";
} // Show if not first page
if ($pageNum_Recordset1 > 0) { // Show if not first page
echo"<a href=\"printf(\"%s?pageNum_Recordset1=%d%s\", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1);\">Previous</a>";
} // Show if not first page
if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page
echo"<a href=\"printf(\"%s?pageNum_Recordset1=%d%s\", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1);\">Next</a>";
} // Show if not last page
if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page
echo"<a href=\"printf(\"%s?pageNum_Recordset1=%d%s\", $currentPage, $totalPages_Recordset1, $queryString_Recordset1);\">Last</a>";
} // Show if not last page
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
mysql_free_result($Recordset1);
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$maxRows_Recordset1 = 2;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
$query_Recordset1 ="SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
$queryString_Recordset1 = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . implode("&", $newParams);
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
///////////////end pagination section//////////////////
////////////// working section below///////////////////
$max=10; //This number decides how many results to display
$referrers = $DB_site->query("SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT $max");
while ($referrer=$DB_site->fetch_array($referrers)) {
$referreds = $DB_site->query("SELECT username FROM user WHERE referrerid = '$referrer[userid]' AND referrerid > 0");
while ($referred = $DB_site->fetch_array($referreds)){
$enc_username = urlencode($referred[username]);
if ($referrerlist) {
$referrerlist .= ", <A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>";
} else {
$referrerlist .= "<A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>";
}
}
eval("\$referbits .= \"".fetch_template("referbit")."\";");
$referrerlist="";
}
eval('print_output("' . fetch_template('refer') . '");');
//////////////////////end working section////////////////////
