[Done 1.4.x & 1.3.x] Speedup your Boardindex NEW Version 2!

[Wiziwig]

That seems to be the fix! Thank you for your innovation and inventivness!

[Compuart]

Great! I'll make it a version 0.92

[Compuart]

I guess it's time to release the final version. Have phun!

[Mach8]

Phantastic!

[Keng]

download link don't work
http://www.kyrandia.nl/test/SpeedUpBoardIndex-1.0.zip

[Compuart]

it should work now  
(sorry for the inconvenience)

[Keng]

why page boardindex don't show guest name in last post

[Compuart]

should work if you replace:

Code Select Expand

      SELECT DISTINCT c.name AS catName,c.ID_CAT,b.ID_BOARD,b.name AS boardName,b.description,b.moderators,b.numPosts,b.numTopics,c.memberGroups,m.posterName,m.posterTime,m.subject,t.ID_TOPIC,t.numReplies,mem.realName,IFNULL(lb.logTime,0) AS boardTime,IFNULL(lmr.logTime,0) AS markReadTime
by:

Code Select Expand

      SELECT DISTINCT c.name AS catName,c.ID_CAT,b.ID_BOARD,b.name AS boardName,b.description,b.moderators,b.numPosts,b.numTopics,c.memberGroups,m.posterName,m.posterTime,m.subject,t.ID_TOPIC,t.numReplies,IFNULL(mem.realName,m.posterName) AS realName,IFNULL(lb.logTime,0) AS boardTime,IFNULL(lmr.logTime,0) AS markReadTime

[Eloya]

Great work - I've taken o major overhaul to the database tables, including converting some DB types and applying your mod to my YaBB SE 1.40. With a little bit creativity this is not a prob. What? AH - its very very fast - like a ferrari *g*. Now I've times of 3 seconds for a collapsed forum with over 27 different forums on one engine fpr building up the boardindex. Great work!!!

Regards,

Nico

[phark]

Nice work, Compuart!  The difference is amazing!  Zoom!!!  

[Eloya]

Just one question - everything is fine but when I post in a board and go back correctly to the index then my post willl show up to me as new. Anybody an idea about this? I think it has to do with this lines:

$latestPostName = $txt[470];
$latestPostTime = $txt[470];
$latestPostID = '-1';
$latestModTime = $subject = $topicID = '';
$numReplies = 0;
$latestPostName = $row_board['posterName'];
      $latestPostID = $row_board['ID_MEMBER'];
      $latestPostTime = $row_board['posterTime'] > 0 ? $row_board['posterTime'] : 0;
      $subject = $row_board['subject'];
      $topicID = $row_board['ID_TOPIC'];
      $numReplies = $row_board['numReplies'];
      $latestPostRealName = $row_board['realName'];
      $log1 = ($row_board['boardTime'] > $latestPostTime) ? 1 : 0;
      $log2 = ($row_board['markReadTime'] > $latestPostTime) ? 1 : 0;
$latestEditTime = $latestModTime = $latestPostTime;


         $themoderators = explode(",",$row_board['moderators']);
         for ($i = 0; $i < sizeof($themoderators); $i++){
            $themoderators[$i] = trim($themoderators[$i]);
            if ($themoderators[$i]!=''){
            LoadRealName($themoderators[$i]);
            $euser=urlencode($themoderators[$i]);
            $themoderators[$i] = "<a href=\"$scripturl?action=viewprofile;user=$euser\"><acronym         title=\"$txt[62]\">{$realNames[$themoderators[$i]]}</acronym></a>";
            }
         }

         $showmods = implode (", ",$themoderators);
         if ($showmods!='')
         {
                 if (sizeof($themoderators)>1)
                  $showmods = "<BR><font size=\"1\"><i>$txt[299]: $showmods</i></font>";
                 else
                  $showmods = "<BR><font size=\"1\"><i>$txt[298]: $showmods</i></font>";
         }else{
            $showmods = "";}

         // set it to off, only turn it on if there are posts and they are new.
         $new = "<img src=\"$imagesdir/off.gif\" alt=\"$txt[334]\">";
         if ($latestPostTime != $txt[470] && $log1=='' && $log2=='' && $username != 'Guest')
               $new = "<img src=\"$imagesdir/on.gif\" alt=\"$txt[333]\">";

         if ($latestPostName != $txt[470] && $latestPostID != '-1') {
            $euser=urlencode($latestPostName);
            $latestPostName = "<a href=\"$scripturl?action=viewprofile;user=$euser\">$latestPostRealName</a>";
         }
         if ($latestPostTime != $txt[470])
            $latestPostTime = timeformat($latestPostTime);

[Compuart]

it has to do with the fact ur using a 1.4.1 mod for 1.4.0

replace:

Code Select Expand

if ($latestPostTime != $txt[470] && $log1=='' && $log2=='' && $username != 'Guest')

by:

Code Select Expand

if ($latestPostTime != $txt[470] && $log1==0 && $log2==0 && $username != 'Guest')

btw: this only applies to 1.4.0
I might release a special 1.4.0 version of this mod (if there's enough people interested)

[PioneeR]

Am still using 1.31 (mainly because I am too chicken to upgrade!!)

[Compuart]

hmmm, 1.3.1, 1.4.0...
are there more people using these versions that want to use this mod?

[Eloya]

Grin.... yes, yes I know *g*

OK I tried your change compuart but the same thing - topics startet by myself or answers to existing threads are still marked as new if I return back to the boardindex.

Any idea? I looked at tbe topic - table but it seems alright then...

URL: http://www.travar.de/koops/edxzine

Strange and weird....

Nico