I'm trying to add the title of the latest post in each forum to the main category view of GForum. So, where is displays the last post timestamp, it would display the title of it as well. Has anyone done this?
Sean
Sean
Dec 2, 2004, 2:14 AM
Veteran / Moderator (17366 posts)
Dec 2, 2004, 2:14 AM
Post #2 of 3
Views: 658
I just gave this a go, and it seems to work well :)
<%last_title_global($forum_last_id)%>
my $post_id = $_[0];
my $post_title = $DB->table('Post')->select( ['post_subject'], { post_id => $post_id } )->fetchrow;
return $post_title;
}
You need to put it in category_list.html, around;
<%nbsp forum_last_date%><br><nobr>by <a href="gforum.cgi?username=<%GT::CGI::escape($forum_last_poster)%>;<%hidden_query%>"><%nbsp forum_last_poster%></a> <a href="gforum.cgi?post=<%forum_last_id%>;<%hidden_query%>#<%forum_last_id%>"><img src="<%image_url%>/jump_last.gif" width="14" height="11" border="0" alt="Jump to post"></a></nobr>
<% else%>
Hope that helps
Cheers
Andy (mod)
andy@ultranerds.co.uk
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
<%last_title_global($forum_last_id)%>
Code:
sub { my $post_id = $_[0];
my $post_title = $DB->table('Post')->select( ['post_subject'], { post_id => $post_id } )->fetchrow;
return $post_title;
}
You need to put it in category_list.html, around;
Code:
<% if forum_total%> <%nbsp forum_last_date%><br><nobr>by <a href="gforum.cgi?username=<%GT::CGI::escape($forum_last_poster)%>;<%hidden_query%>"><%nbsp forum_last_poster%></a> <a href="gforum.cgi?post=<%forum_last_id%>;<%hidden_query%>#<%forum_last_id%>"><img src="<%image_url%>/jump_last.gif" width="14" height="11" border="0" alt="Jump to post"></a></nobr>
<% else%>
Hope that helps
Cheers
Andy (mod)
andy@ultranerds.co.uk
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates