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

[Eloya]

I've zipped my boardindex and post.php - don't get dizzy with the new global $view - I split up the categories table in order to offer many views of my forum to now over 27 partner pages

You can get the ZIP from http://www.travar.de/Post.zip - hey, I own you a beer if you could solve this *g*

Nico

[Webby]

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

Heavely modded 1.3.1  

[Compuart]

hmmm, your boardindex.php seems alright now. Can you check your messageindex (there's where the logs are being changed). It should contains something like this:

Code Select Expand

   $request = mysql_query("SELECT logTime FROM {$db_prefix}log_boards WHERE (memberName='$username' AND ID_BOARD=$currentboard) LIMIT 1");
   if (mysql_num_rows($request)==0)
      $request = mysql_query("INSERT INTO {$db_prefix}log_boards (logTime,memberName,ID_BOARD) VALUES (".time().",'$username',$currentboard)");
   else
      $request = mysql_query("UPDATE {$db_prefix}log_boards SET logTime=".time()." WHERE (memberName='$username' AND ID_BOARD=$currentboard)");


I own you a beer if you could solve this *g*

I like it * * * C O L D * * *

[iamdamnsam]

I also have a heavily modded 1.31, that is why I haven't upgraded to 1.41.  I (and my members) would love to have this mod!

[Eloya]

Okay, cold beer   Two if it works *g*

I have this code in my messageindex:

// mark current board as seen
   $request = mysql_query("SELECT logTime FROM {$db_prefix}log_boards WHERE (memberName='$username' AND ID_BOARD=$currentboard) LIMIT 1");
   if (mysql_num_rows($request)==0)
      $request = mysql_query("INSERT INTO {$db_prefix}log_boards (logTime,memberName,ID_BOARD) VALUES (".time().",'$username',$currentboard)");
   else
      $request = mysql_query("UPDATE {$db_prefix}log_boards SET logTime=".time()." WHERE (memberName='$username' AND ID_BOARD=$currentboard)");

Seems to be alright....

I've zipped the file also and you can get it at http://www.travar.de/Message.zip

[Eloya]

And one more.... Polls are not shown in the BoardIndex....

Nico

[PioneeR]

I also have a heavily modded 1.31, that is why I haven't upgraded to 1.41.  I (and my members) would love to have this mod!

same here. Still on 1.31 (mainly due to the mods my members really like not being available as yet for 1.41)... also.. am a bit chicken to upgrade  

Would love to see this for 1.31 though.. am sure there are loads of people out there who would love you for it  

[Gobalopper]

Compuart I think the problem with it not updating could be in the part where it updates the log saying you've read the thread which woud be in Post.php, which has been changed to call updateLastMessage().
Also I installed this on a 1.4.1 board and have the same problem.

[Compuart]

So far I haven't been able to find the bug anywhere, but it looks like the bug only appears in older versions of boardindex. Therefor I'll have a look at it again tomorrow and maybe (if I have time) write a 1.4.0 and 1.3.1 version

[Spaceman-Spiff]

thx Compuart, great mod

[Compuart]

yw

OK, I found the posted-a-message-board-is-still-new-bug. To fix:
replace (boardindex):

Code Select Expand

      $log1 = ($row_board['boardTime'] > $latestPostTime) ? 1 : 0;
      $log2 = ($row_board['markReadTime'] > $latestPostTime) ? 1 : 0;

by:

Code Select Expand

      $log1 = ($row_board['boardTime'] >= $latestPostTime) ? 1 : 0;
      $log2 = ($row_board['markReadTime'] >= $latestPostTime) ? 1 : 0;

A new version is available fixing this issue and including added support for 1.4.0(!)

I'll start writing a 1.3.1 version now

[Compuart]

woops, forgot to fix the poll issue  

replace (poll.php):

Code Select Expand

         }
         updateLastMessage($board);
      }

by:

Code Select Expand

         }
      }
      updateLastMessage($board);

...or download version 1.11

[Compuart]

1.4.0 BETA has been revised and changed (just make sure you're using 1.4.0 BETA revision 1)

[Compuart]

OK, now 1.3.x is also out as a BETA  

[PioneeR]

Does anyone know if this mod works ok with the Allowed Users mod??