how about this ?
Code:
<?php
error_reporting(7);
if (function_exists("set_time_limit")==1 and get_cfg_var("safe_mode")==0) {
@set_time_limit(1200);
}
//suppress gzipping
$nozip=1;
require("./global.php");
require("./config.php");
adminlog();
cpheader();
// ##################################################################
if (isset($perpage)==0 or $perpage=="") {
$perpage=1000;
}
if (isset($startat)==0 or $startat=="") {
$startat=0;
}
$finishat=$startat+$perpage;
echo "<p>User ids:</p>";
$users=$DB_site->query("SELECT userid,usertitle,usergroupid,customtitle,posts FROM user WHERE userid>=$startat AND userid<$finishat ORDER BY userid DESC");
while ($user=$DB_site->fetch_array($users)) {
unset($sql);
$userid=$user[userid];
// update user stuff
if ($user[cookieuser]==0)
$DB_site->query("UPDATE user SET cookieuser='1' WHERE userid='$user[userid]'");
echo "Processing user <b>$user[userid]</b><br>\n";
flush();
}
if ($checkmore=$DB_site->query_first("SELECT userid FROM user WHERE userid>=$finishat")) {
cpredirect("cookies.php?s=$session[sessionhash]&startat=$finishat&perpage=$perpage");
echo "<p><a href=\"cookies.php?s=$session[sessionhash]&startat=$finishat&perpage=$perpage\">Click here to continue updating users</a></p>";
} else {
echo "<p>User cookies updated!</p>";
}
cpfooter();
?>