[2.0.15] Latest active topics on index

The cleanup is complete. This forum is now read only.
Post Reply

Rating:

Excellent!
80
54%
Very Good
41
28%
Good
14
10%
Fair
7
5%
Poor
5
3%
 
Total votes: 147

Extensions Robot
Extensions Robot
Extensions Robot
Posts: 29216
Joined: Sat Aug 16, 2003 7:36 am

[2.0.15] Latest active topics on index

Post 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: latest_topic_on_index_1-1-9.zip
mods overview page: View
File Size: 3972 Bytes

Security Score: 0
Last edited by Extensions Robot on Mon Apr 30, 2007 12:31 am, edited 1 time in total.
(this is a non-active account manager for the phpBB Extension Customisations Team)
AbelaJohnB
Former Team Member
Posts: 5674
Joined: Fri Jul 06, 2001 11:56 pm

Post by AbelaJohnB »

MOD Validated/Released :mrgreen:




Personal Notes:
Works as advertized. Welcome to the MOD Author Community!! <smile>
zparta
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post by zparta »

thanks this is the first mod i made and is released in the moddb :D

screenshot
Last edited by zparta on Wed Dec 03, 2003 10:20 am, edited 1 time in total.
User avatar
poncho1973
Registered User
Posts: 57
Joined: Thu Sep 25, 2003 2:20 pm

Post 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?
zparta
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post 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
User avatar
poncho1973
Registered User
Posts: 57
Joined: Thu Sep 25, 2003 2:20 pm

Post by poncho1973 »

Thank you!
zparta
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post by zparta »

no problem
riesgo
Registered User
Posts: 3
Joined: Wed Oct 22, 2003 1:02 am
Location: California, USA

Include more info in marquee, like Category and Forum Name

Post by riesgo »

Hello,

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,
c.cat_title,f.forum_name

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>

thanks,
--Eli
zparta
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post 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:
riesgo
Registered User
Posts: 3
Joined: Wed Oct 22, 2003 1:02 am
Location: California, USA

Post 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. :)

thanks,
--Eli
zparta
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post by zparta »

http://zparta.upnorth.se/pics/ put it in the upload dir :D

thats an easy way of doing it
zparta
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post 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
riesgo
Registered User
Posts: 3
Joined: Wed Oct 22, 2003 1:02 am
Location: California, USA

Post 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.
zparta
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post by zparta »

well the new version isn't validated yet so you will have to wait until they validate it
quentin
Registered User
Posts: 197
Joined: Tue May 20, 2003 7:30 am
Location: Geneva, Switzerland
Contact:

Post 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).

Quentin
The largest message boards on the web !
Web Design Library (coming soon)
Friends sites: Heroes of might and magic - Biometric security
Post Reply

Return to “[2.0.x] MOD Database Cleanup”