Page 1 of 62

[2.0.15] Latest active topics on index

Posted: Mon Oct 20, 2003 11:12 am
by Extensions Robot
MOD Name: Latest active topics on index
Author: zparta
MOD Description: Show the latest active topics on index and the amout of topics to show is ACP changeable

MOD Version: 1.1.9 (Updated 06/12/05)

Download File:
mods overview page: View
File Size: 3972 Bytes

Security Score: 0

Posted: Mon Oct 20, 2003 11:52 am
by AbelaJohnB
MOD Validated/Released :mrgreen:

Personal Notes:
Works as advertized. Welcome to the MOD Author Community!! <smile>

Posted: Mon Oct 20, 2003 12:02 pm
by zparta
thanks this is the first mod i made and is released in the moddb :D


Posted: Mon Oct 20, 2003 11:16 pm
by poncho1973
I have a quick question... I have users in three different groups on my board... will this show THEIR 10 latest posts (the three groups have common areas and group specific areas that the other two groups DON'T see).

Will Group A see Group B's posts in their list?

Posted: Tue Oct 21, 2003 9:40 am
by zparta
group A can only see the topics they are allowed to
same goes for group b and c and d and so on and so forth

Posted: Tue Oct 21, 2003 4:33 pm
by poncho1973
Thank you!

Posted: Tue Oct 21, 2003 4:57 pm
by zparta
no problem

Include more info in marquee, like Category and Forum Name

Posted: Wed Oct 22, 2003 1:35 am
by riesgo

I think this mod is neat. I modified it a bit to include more information in the marquee. Namely, to include the Category->Forum Name->Topic instead of just the Topic. It helps the user determine where it came from.

Just wanted to share in case anyone was interested. This is my first post, so hope it's okay. :D

Changes to index.php

Changed sql to query Category table and return the cat_title from the cat table and the forum_name fromm the forums table.
$sql = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_
id, t.topic_type, t.topic_status, p.post_id, p.poster_id,
p.post_time, u.user_id, u.username, u.user_lastvisit,

FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . POSTS_T
ABLE . " p, " . USERS_TABLE . " u, " . CATEGORIES_TABLE . " c
WHERE t.forum_id IN " . $auth_view_forum_sql . " AND t.topic_id = p.topic_id
AND f.forum_id = t.forum_id
AND t.topic_status <> 2
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u.user_id
AND f.cat_id = c.cat_id
ORDER BY t.topic_last_post_id DESC";

Changed the marqueerow variable to include the cat_title and forum_name.
$template->assign_block_vars('marqueerow', array(
'FOLD_URL' => $pic,
'TOPIC_TITLE' => $row[$i]["topic_title"],
'FORUM_NAME' => $row[$i]["forum_name"],
'FORUM_CAT' => $row[$i]["cat_title"],

Modified templates/subSilver/index_body.tpl

Also changed the sizes of the Category and Forum name displayed to be different so the users eyes focus on the topic first and the rest if they care about it.
<td class="row2" width="352">
<span class="forumlink"><a href="{marqueerow.TOPIC_URL}" onMouseOver="do
cument.all.recent_topics.stop()" onMouseOut="document.all.recent_topics.start()"
><span class="gensmall">{marqueerow.FORUM_CAT}</span>-><span class="genmed">{marqueerow.FORUM_NAME}</span>->{marqueerow.TOPIC_TITLE}</a></span>


Posted: Wed Oct 22, 2003 3:16 am
by zparta
hey thanks for the info do you got a demo i can look at for the changes to the looks you have done ? i am curently working on a new version maybe i will implement it :)

ohh and Welcome to phpBB :mrgreen:

Posted: Wed Oct 22, 2003 3:27 am
by riesgo
Unfortunately, it's an intranet forum, so there's no external access. I took a snapshot of the window, but I have no way of getting it to you easily.

Wish this site had the attachment mod, that'd be cool to show people how the mod might look. :)


Posted: Wed Oct 22, 2003 3:52 am
by zparta put it in the upload dir :D

thats an easy way of doing it

Posted: Wed Oct 22, 2003 4:09 am
by zparta
i just set up a test forum on my server and i think that the rows becomes to long when added that to it if the forum name is long :/ but there is probably someone that want that to so its good you posted it here anyways :)
well i uploaded a new version 1.1.0 where the number of topics to be displayed is editable in the ACP

Posted: Wed Oct 22, 2003 5:41 am
by riesgo
D'oh, I uploaded the image before I read the next post. Anyways, yeah, it could become pretty long, but most of the users here have pretty high resolutions, so they can fit it all on their screen realstate pretty easily.

I'll check out the new version.

Posted: Wed Oct 22, 2003 5:48 am
by zparta
well the new version isn't validated yet so you will have to wait until they validate it

Posted: Fri Oct 24, 2003 4:16 pm
by quentin
nice mod, and easy to adapt so that the topics are displayed on other pages than just the index.
Unfortunately, it's an intranet forum, so there's no external access.

hey cool another intranet phpbb :) (we use it too in my company).