new posts doubling page queries?

Alright,

After I installed the store hack and such, I noticed that every time there is a post added in a thread, the queries jump drastically.

Example: http://www.echohype.com/forums/showt...=&threadid=307

My partner thought it may be a problem inside showthread, and he thinks that the postbit/posts are being told to do double.

Attached is the current showthread.php

Any help is greatly appreciated!

[mr e]

holy crap, 282 queries!

it looks like you have a block of code repeated at line 271, besides that i dunno

but, i dont think your allowed to post full php files

[EchoHype.com]

oh......hmm.........sorry about that, I will remove it and look at the repeated block!

thanks

EDIT: couldn't seem to find that duplicate block your talking about?

[mr e]

@line 271 there's some code, and below that it looks like it repeats...maybe it doesn't, but it sure looked close

[EchoHype.com]

hmm, after checking the instructions of the store hack, that block is supposed to be like that.

......hmm

[mr e]

is there any queries inside a while loop?

[EchoHype.com]

how do you mean?

here's what is from the instructions of the store hack

if ($noshutdownfunc) {
  $DB_site->query("UPDATE thread SET views=views+1 WHERE threadid='$threadid'");
  
  // Store hack by Lesane

  $storeview=$DB_site->query_first("select views, postuserid from thread WHERE threadid='$threadid'");
  $views=$storeview[views];
  $postuserid=$storeview[postuserid];

  $storeadmin = $DB_site->query_first("SELECT * FROM storeadmin");
  $view1=$storeadmin[view1];
  $view2=$storeadmin[view2];
  $view3=$storeadmin[view3];
  $view4=$storeadmin[view4];
  $view5=$storeadmin[view5];
  $viewpoint1=$storeadmin[vpoint1];
  $viewpoint2=$storeadmin[vpoint2];
  $viewpoint3=$storeadmin[vpoint3];
  $viewpoint4=$storeadmin[vpoint4];
  $viewpoint5=$storeadmin[vpoint5];

  if ($views == $view1) 
  {
	$DB_site->query("UPDATE user SET storep=storep+$viewpoint1 where userid='$postuserid'");
  }
  elseif ($views == $view2) 
  {
	$DB_site->query("UPDATE user SET storep=storep+$viewpoint2 where userid='$postuserid'");
  }
  elseif ($views == $view3) 
  {
	$DB_site->query("UPDATE user SET storep=storep+$viewpoint3 where userid='$postuserid'");
  }
  elseif ($views == $view4) 
  {
	$DB_site->query("UPDATE user SET storep=storep+$viewpoint4 where userid='$postuserid'");
  }
  elseif ($views == $view5) 
  {
	$DB_site->query("UPDATE user SET storep=storep+$viewpoint5 where userid='$postuserid'");
  }
  
} else {
  $shutdownqueries[]="UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='$threadid'";
  
  // Store hack by Lesane

  $storeview=$DB_site->query_first("select views, postuserid from thread WHERE threadid='$threadid'");
  $views=$storeview[views];
  $postuserid=$storeview[postuserid];

 $storeadmin = $DB_site->query_first("SELECT * FROM storeadmin");
  $view1=$storeadmin[view1];
  $view2=$storeadmin[view2];
  $view3=$storeadmin[view3];
  $view4=$storeadmin[view4];
  $view5=$storeadmin[view5];
  $viewpoint1=$storeadmin[vpoint1];
  $viewpoint2=$storeadmin[vpoint2];
  $viewpoint3=$storeadmin[vpoint3];
  $viewpoint4=$storeadmin[vpoint4];
  $viewpoint5=$storeadmin[vpoint5];
  

  if ($views == $view1) 
  {
	$DB_site->query("UPDATE user SET storep=storep+$viewpoint1 where userid='$postuserid'");
  }
  elseif ($views == $view2) 
  {
	$DB_site->query("UPDATE user SET storep=storep+$viewpoint2 where userid='$postuserid'");
  }
  elseif ($views == $view3) 
  {
	$DB_site->query("UPDATE user SET storep=storep+$viewpoint3 where userid='$postuserid'");
  }
  elseif ($views == $view4) 
  {
	$DB_site->query("UPDATE user SET storep=storep+$viewpoint4 where userid='$postuserid'");
  }
  elseif ($views == $view5) 
  {
	$DB_site->query("UPDATE user SET storep=storep+$viewpoint5 where userid='$postuserid'");
  }
}

[Erwin]

This will kill your server.

Page generated in 0.73848796 seconds (49.96% PHP - 50.04% MySQL) with 282 queries.

There is something wrong with how you've installed the Store Hack I'm sure. Uninstall it out of showthreads, and reinstall it and see if that fixes it.

[EchoHype.com]

ugh,

I reverted them, uploaded, was still there. then reinstalled the changes and still there........