[squawell]

FireFly the txt have someplace wrong??

PHP Code:

$getpostids=$DB_site->query("
    SELECT post.postid FROM post
    WHERE post.threadid='$threadid' AND post.visible=1
    ORDER BY dateline $postorder LIMIT ".($limitlower-1).",$perpage
");

if ($limitupper>$totalposts) {
  $limitupper=$totalposts;
  if ($limitlower>$totalposts) {
    $limitlower=$totalposts-$perpage;
  }
}
if ($limitlower<=0) {
  $limitlower=1;
}
$postids="post.postid IN (0";
while ($post=$DB_site->fetch_array($getpostids)) {
  $postids.=",".$post['postid'];
}

$postids.=")";
$hackuserids.=")";

$hacks=array();
$hackcounts=$DB_site->query("SELECT postuserid,COUNT(*) AS totalhacks FROM thread WHERE forumid IN (4,5) AND postuserid IN $hackuserids GROUP BY postuserid");
while ($hackcount=$DB_site->fetch_array($hackcounts)) {
  if (!isset($hackcount[totalhacks]))
    $hackcount[totalhacks]=0;
  $hacks["$hackcount[postuserid]"]=$hackcount[totalhacks];
}
$hacks[0]=0; 


*********************************
with this:
*********************************

PHP Code:

$getpostids=$DB_site->query("
    SELECT post.postid,post.userid AS postuserid FROM post
    WHERE post.threadid='$threadid' AND post.visible=1
    ORDER BY dateline $postorder LIMIT ".($limitlower-1).",$perpage
");

if ($limitupper>$totalposts) {
  $limitupper=$totalposts;
  if ($limitlower>$totalposts) {
    $limitlower=$totalposts-$perpage;
  }
}
if ($limitlower<=0) {
  $limitlower=1;
}
$postids="post.postid IN (0";
$hackuserids="(0";
while ($post=$DB_site->fetch_array($getpostids)) {
  $postids.=",".$post['postid'];
  $hackuserids.=",".$post['postuserid'];
}
$postids.=")";
$hackuserids.=")";

$hacks=array();
$hackcounts=$DB_site->query("SELECT postuserid,COUNT(*) AS totalhacks FROM thread WHERE forumid IN (x) AND postuserid IN $hackuserids GROUP BY postuserid");
while ($hackcount=$DB_site->fetch_array($hackcounts)) {
  if (!isset($hackcount[totalhacks]))
    $hackcount[totalhacks]=0;
  $hacks["$hackcount[postuserid]"]=$hackcount[totalhacks];
}
$hacks[0]=0; 


it's the same code~