phpBB 5 latest posts - Page 3

thierrybo · 13.02.2005, 03:07

Quote:

Originally Posted by Athlon_2o0o

I cant try it though as the "Module Class Suffix" shown at your place it's even present at mine. It just doesn't exist..

ah sorry, as I read this, just remember I had to make changes to the downloaded module to add the module class suffix parameter. Just add

Code:

<param name="moduleclass_sfx" type="text" default="" label="Module Class Suffix"
description="A suffix to be applied to the module css class" />

to the xml file to add this parameter and edit your css file exactly as you did it. In the php file, add

PHP Code:

  $moduleclass_sfx = @$params->moduleclass_sfx;

Thierry B.

thierrybo · 13.02.2005, 04:15

Quote:

Originally Posted by chrisho

I've got this installed fine BUT it doesn't pick up the forum ID correctly - I've set the parameter to 1, but it pulls out info from both of my active forums. Any ideas?

Hi,

just realized I have the same problem. Looking at the code of phpbbtopics_08.zip, it simply appears that the forum parameter is not used in the code

Here is the sql :

PHP Code:

  $result=mysql_query("SELECT topic_title, topic_id 

FROM phpbb_topics ORDER BY $PHPBB2_ORDER DESC LIMIT 0, $PHPBB2_AMOUNT");

but it should read

PHP Code:

  $result=mysql_query("SELECT topic_title, topic_id 

FROM phpbb_topics WHERE forum_id=$PHPBB2_FORUM_ID ORDER BY $PHPBB2_ORDER DESC LIMIT 0, $PHPBB2_AMOUNT");

Alternatelty, I modified the code to use '0' meaning ALL forums, the default. Then I added to php file :

PHP Code:

  $forum_sql = '';

if ('0' != $PHPBB2_FORUM_ID)

{   

    $forum_sql = "WHERE forum_id=" . $PHPBB2_FORUM_ID;

}

$result become:

PHP Code:

  $result=mysql_query("SELECT topic_title, topic_id 

FROM phpbb_topics $forum_sql ORDER BY $PHPBB2_ORDER DESC LIMIT 0, $PHPBB2_AMOUNT");

However, I have always the same problem you said. It comes from the use of the LIMIT clause in sql statement. This is not appropriate here because mysql return the X first rows it founds, but these rows does not contain necessarily the latest topics

Then the code should be modified to get ALL rows (remove the LIMIT statement), then we have to find the last X posts using pure PHP, not SQL.

Thierry B.

chrisho · 13.02.2005, 14:18

Thanks Thierry! That's perfect.

swole · 21.04.2005, 18:17

Pretty sweet hack - question though, where it says...

// ID of the Forum you want the topics from
$PHPBB2_FORUM_ID = @$params->forumID ? $params->forumID : '2';

can you change this to have more than one forumID? Like '1,2 and 3'?

Thanks!

thecaretaker · 23.04.2005, 14:31

Quote:

Originally Posted by swole

can you change this to have more than one forumID? Like '1,2 and 3'?

Thanks!

Yes please... I would like to include several forum IDs but not those that have moderator only rights. This would make this mod perfect for me

swole · 25.04.2005, 21:07

***bump***