Gossamer Forum: Products: Gossamer Forum: Development, Plugins and Globals: Re: [bgkhoo] Scripts for last 10 posting: Edit Log

Gossamer Threads

Home : Products : Gossamer Forum : Development, Plugins and Globals :

Products: Gossamer Forum: Development, Plugins and Globals: Re: [bgkhoo] Scripts for last 10 posting: Edit Log

Here is the list of edits for this post

Dec 3, 2001, 8:14 AM

Paul

Veteran (19537 posts)

Dec 3, 2001, 8:14 AM

Re: [bgkhoo] Scripts for last 10 posting

Code:
use strict; 
use GForum qw/$DB/; 

my @posts; 
my $db = $DB->table('Post'); 

$db->select_options("ORDER BY post_time DESC", "LIMIT 10"); 

my $sth = $db->select('post_id', 'post_subject'); 

while (my ($tags) = $sth->fetchrow_hashref) { 
       push @posts, qq|<a href="gforum.cgi?post=| . $tags->{post_id} . qq|;sb=post_latest_reply;so=ASC;forum_view=forum_view_collapsed;">| . $tags->{post_subject} . qq|</a>|; 
} 

return join '<br>', @posts;

I'm not in the mood to test it but hope it puts you on the right track.

Last edited by:

PaulW: Dec 3, 2001, 8:18 AM

Edit Log:

Post edited by Paul Post edited by Paul (Veteran) on Dec 3, 2001, 8:15 AM
Post edited by Paul Post edited by Paul (Veteran) on Dec 3, 2001, 8:16 AM
Post edited by Paul Post edited by Paul (Veteran) on Dec 3, 2001, 8:16 AM
Post edited by Paul Post edited by Paul (Veteran) on Dec 3, 2001, 8:17 AM
Post edited by Paul Post edited by Paul (Veteran) on Dec 3, 2001, 8:17 AM
Post edited by Paul Post edited by Paul (Veteran) on Dec 3, 2001, 8:18 AM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676