[MODDB] NV recent topics 1.0.4

[nickvergessen]

nto yet, sorry but I'm not at home this 3weeks just on saturday and sunday...

[LkM]

nto yet, sorry but I'm not at home this 3weeks just on saturday and sunday...

Ah, okay, no problem

thanks

[DBM]

Nick, any chance of adding a scrolling marquee as on the old "last topics on index" mod?

There's an example here.

I had that mod on my 2.0.22 board and lots of my present users miss it. Also, you could set the number of topics in the ACP.

[sansara]

Is it possible to exclude specific forums from the list of the recent topics?
Which file should I modify?

Thanks!

[nickvergessen]

I had that mod on my 2.0.22 board and lots of my present users miss it. Also, you could set the number of topics in the ACP.

Just have a look @ ACP > General > Board-Settings

Is it possible to exclude specific forums from the list of the recent topics?
Which file should I modify?

You don't have to modify, just look at @ ACP > General > Board-Settings to exclude some topics and look at Forums > manage Forums > *select* and *edit*

view on "recent topics":
Shall topics of this forum be displayed on the index in "recent topics"?

[sansara]

Many thanks for the response!

One more question... I have a board with two categories of forums, each category having a different point of interest. Is it possible, with some changes, to display two different lists of recent topics, each one including the recent topics from the corresponding forums/categories? This would be perfect!

[cotp]

Hello,

Since recently I keep having this error on index page:

Code: Select all

SQL ERROR [ mysqli ]

Lost connection to MySQL server during query [2013]

SQL

SELECT t.*, i.icons_url, i.icons_width, i.icons_height, tp.topic_posted, f.forum_name, f.forum_type, f.forum_flags FROM phpbb3_topics t LEFT JOIN phpbb3_topics_posted tp ON (t.topic_id = tp.topic_id AND tp.user_id = 2) LEFT JOIN phpbb3_forums f ON f.forum_id = t.forum_id LEFT JOIN phpbb3_icons i ON t.icon_id = i.icons_id WHERE f.forum_recent_topics = 1 ORDER BY t.topic_last_post_time DESC

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: recent_topics.php
LINE: 31
CALL: dbal_mysqli->sql_query()

FILE: index.php
LINE: 134
CALL: include('recent_topics.php')

It is solved by restarting services on wamp... but comes again quickly

Do you think it has to do with the mode code or not

Cotp

[nickvergessen]

Yes, it's from my MOD, thanks for the hint...
How many topics does your forum have?

[cotp]

Yes, it's from my MOD, thanks for the hint...
How many topics does your forum have?

5834 topics.

But it does it only local and not online so i think could be a problem of wamp maybe ?

Let me know, anyway I don't know why but I think it doesn't come from your mod but another one so I uninstalled Prime Birthdate Require 1.0.RC1 and Custom Profile Fields For Admin 1.0.0 to see what happens...

Cotp

[nickvergessen]

no, maybe you have different settings on the server,
its just i row all topics so far, but i look for a better way to stop that

[cotp]

A friend of mine (dcz) pointed this out to me:

In recenttopics file:

Replace

Code: Select all

	ORDER BY t.topic_last_post_time DESC';

by

Code: Select all

	ORDER BY t.topic_last_post_time DESC LIMIT ' . intval($limit);

I thought of something too:

You seem to look the "n" last messages and see if you have permissions to display them whereas I think you should query the last "n" messages that a user has permissions to display...

Does that makes sense ?

Cotp

[nickvergessen]

The fix you suggested is not right,
if you have 5 recent topics but are only allowed to read 3 of them you'll get only 3 displayed, but i already fixed it on CVS. update will be added this week, i have on more thing in progress.

[Geisthund]

Hi

Thank you for this mod it appears to works fine on my site.

I wanted to show 10 post but this messed up the appearance of the forum (Making it appear to long) so I changed the Recent topic to only display when clicked. You can see it working on http://www.weimaraner.tv/ just click the Latest Post block to get it to appear.

The code required to do this on my forum is below and is added to recent_topics_body.html
Sorry not sure if this code works without phpBB3 Portal XL 4.0 but thought the idea might help

Code: Select all

<div class="navbar">
   <div class="inner">
      <span class="corners-top"><span></span></span>
         <a href="#" onclick="Effect.toggle('recent_topics','BLIND'); return false;">
          <h5><img src="./portal/images/icons/layout.png" height="11" width="11" />&nbsp;{Header description}</h5></a>
          <div id="recent_topics" style="display: block;">
	       <hr align="left" />

Code from recent_topics_body.html goes here and then Save As recent_topics_body.html
         </div>
      <span class="corners-bottom"><span></span></span>
   </div>
</div>

Different option for Effect.toggle('recent_topics','BLIND');
http://wiki.script.aculo.us/scriptaculo ... ect.toggle
Cheers
Gareth

[TriskaidekaPiT]

Ok, so first, I would like to thank you very much nick, because I asked you some time ago to made this mod, and you said you were so busy at this time etc, etc, and now, what a surprise, I can see you finally did it.
I really waited for this mod, so thank you again.

Now, I have a little question.
I got my phpBB database on Postgresql.

So what about this :

Code: Select all

ALTER TABLE `phpbb_forums` ADD `forum_recent_topics` mediumint(1) unsigned DEFAULT "1" NOT NULL AFTER forum_topics_real;
INSERT INTO phpbb_config( config_name, config_value, is_dynamic )
VALUES ('recent_topics', '5', '1');
INSERT INTO phpbb_config( config_name, config_value, is_dynamic )
VALUES ('enabled_recent_topics', '0', '1');

SQL error :

ERROR: syntax error at or near "`"
LINE 1: ALTER TABLE `phpbb_forums` ADD `forum_recent_topics` mediumi...

Do I have to execute a different sql request for Postgresql ?

[nickvergessen]

What SQL version do you have?