[MODDB] NV recent topics 1.0.4

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Scam Warning
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [Beta] recent topics 0.0.2

Post by nickvergessen »

nto yet, sorry but I'm not at home this 3weeks just on saturday and sunday...
No Support via PM
LkM
Registered User
Posts: 28
Joined: Thu Dec 07, 2006 5:52 pm
Location: São Paulo - SP / Brazil
Contact:

Re: [Beta] recent topics 0.0.2

Post by LkM »

nickvergessen wrote:nto yet, sorry but I'm not at home this 3weeks just on saturday and sunday...
Ah, okay, no problem ;)

thanks
User avatar
DBM
Registered User
Posts: 159
Joined: Tue Oct 25, 2005 10:29 pm
Contact:

Re: [Beta] recent topics 0.0.2

Post by 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
Registered User
Posts: 6
Joined: Mon Jul 23, 2007 2:22 pm

Re: [Beta] recent topics 0.0.2

Post by sansara »

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

Thanks!
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [Beta] recent topics 0.0.2

Post by nickvergessen »

DBM wrote: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
sansara wrote: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"?
No Support via PM
sansara
Registered User
Posts: 6
Joined: Mon Jul 23, 2007 2:22 pm

Re: [Beta] recent topics 0.0.2

Post by 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
Registered User
Posts: 445
Joined: Wed Sep 14, 2005 7:34 pm
Contact:

Re: [Beta] recent topics 0.0.2

Post by 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
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [Beta] recent topics 0.0.2

Post by nickvergessen »

Yes, it's from my MOD, thanks for the hint...
How many topics does your forum have?
No Support via PM
cotp
Registered User
Posts: 445
Joined: Wed Sep 14, 2005 7:34 pm
Contact:

Re: [Beta] recent topics 0.0.2

Post by cotp »

nickvergessen wrote: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
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [Beta] recent topics 0.0.2

Post by 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
No Support via PM
cotp
Registered User
Posts: 445
Joined: Wed Sep 14, 2005 7:34 pm
Contact:

Re: [Beta] recent topics 0.0.2

Post by 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);
:P

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
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [Beta] recent topics 0.0.2

Post by 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.
No Support via PM
Geisthund
Registered User
Posts: 352
Joined: Fri Jul 01, 2005 1:23 pm

Re: [Beta] recent topics 0.0.2

Post by 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
Last edited by Geisthund on Thu Sep 13, 2007 6:13 pm, edited 1 time in total.
User avatar
TriskaidekaPiT
Registered User
Posts: 24
Joined: Sat Jun 30, 2007 12:51 pm

Thank you!

Post by 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 ? :(
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [Beta] recent topics 0.0.2

Post by nickvergessen »

What SQL version do you have?
No Support via PM
Locked

Return to “[3.0.x] MODs in Development”