Serious Query Problem

I have a serious Problem with the Querries in showthread.php. Everytime I post in an Thread, next time I open the thread it needs exactly 2 Querries more. As I have 25 Threads / Page this means 50 additional Querries on a full Page! As I already have about 25 Querries as default, i got between 30-80 Querries in a Thread

Can anybody explain to my why this happens and why other users on my board don't seem to add so many querries per post? I have access-masks enabled and Quick-Reply + Lesanes Award-System + Quick Delete installed.

[TheSaint-AeD]

wtf, this is getting weird... ok, here we are:


Thread has 1 Post, User is Moderator:

Seite generiert in 0.20259094 Sekunden (74.67% PHP - 25.33% MySQL) mit 33 queries.

Same Thread, User is no Mod:

Seite generiert in 0.18163002 Sekunden (71.52% PHP - 28.48% MySQL) mit 35 queries.

Now we are 10 Posts later...

User is Moderator:

Seite generiert in 0.38245904 Sekunden (84.50% PHP - 15.50% MySQL) mit 42 queries.

In Comparison to that, same Thread, no Mod:

Seite generiert in 0.36550105 Sekunden (82.41% PHP - 17.59% MySQL) mit 53 queries.

Moderators get +1 Query / Post, Non-Moderators even +2! There was I time I was running the Award-Hack aswell as the Quick-Delete-Post Hack and had 40 Posts / Page. This means, my Users must have been at 150+ Querries!!! I'm wondering how my Server got through this, with my Board having ~150 highly active Users in average / day.

[Xenon]

yes, that's really a problem

somewhere in your whileloop ther is one or two queries too much.

carefully recheck the getpostbit function and the loop in showthread.php where getpostbit is called

[TheSaint-AeD]

k, removing the hack cleared it out. I got no more query-loops and I'm back at unbelievable 32 querries performed in Showthread. Here is the wrong Code:

PHP Code:

if ($action=="deletethispost") {
  $firstpost=$DB_site->query_first("SELECT postid,dateline FROM post WHERE threadid='$threadid' ORDER BY dateline LIMIT 1");
  if ($postid==$firstpost[postid]) {
    if ($getperms[candeletethread]) {
      deletethread($threadinfo[threadid],$foruminfo[countposts]);
      updateforumcount($threadinfo[forumid]);

      $url="forumdisplay.php?s=$session[sessionhash]&forumid=$threadinfo[forumid]";
      eval("standardredirect(\"".gettemplate("redirect_deletethread")."\",\"$url\");");
    } else {
      show_nopermission();
    }

  } else {
    $foruminfo=getforuminfo($threadinfo[forumid]);
    deletepost($postid,$foruminfo[countposts],$threadinfo[threadid]);

    updatethreadcount($threadinfo[threadid]);
    updateforumcount($threadinfo[forumid]);

    $url="showthread.php?s=$session[sessionhash]&threadid=$threadinfo[threadid]";
    eval("standardredirect(\"".gettemplate("redirect_deletepost")."\",\"$url\");");
  }
} 


I'm wondering why I was the first User noticing this, as neither the award-hack nor the quick-delete-post hack are that unpopulare. I sent Teck a PN with a Link to this Thread.

[TheSaint-AeD]

ok, TECK posted a Code which doesn't use Mod or no-Mod but Usergroup-ID's. Not as comfortable as the first Version, but 50 Querries less leave no Choice Does anybody has an Idea for a fully working Code?

@ Xenon: Die Foren mal besucht? Wenn Dir was davon gef?llt (z. B. einer der Styles) einfach PN, dann schick ich Ihn Dir, ist das Wenigste was ich Dir anbieten kann. Danke nochmal f?r die Hilfe.

[Xenon]

i think TECK will come up with a comfortable and fully working code, i know him

just have to wait

Hmm, nur wenns wirklich keine umst?nde macht, der Galaktic Blue Style w?rde nach kleinen ?nderungen gut zu meinem Master of Orion3 unterforum passen
Meine Addy Xenon@ und dann die url von meinem Forum
btw. dein Stylish green erinnert mich an was

[TheSaint-AeD]

@ Xenon: Hab mich mal in Deinem Forum registriert, werde so schnell wie möglich daran arbeiten.