Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: link by number of day

May 7, 2009, 6:17 AM

nir

User (391 posts)

May 7, 2009, 6:17 AM

Post #1 of 6

Shortcut

link by number of day

Is there a way to get list of links in the last 2 days that it return link from the 48 last hours
$sth = $search_db->select (['Links.*'], GT::SQL::Condition->new(['CategoryID', 'IN', $all_ids], ['isValidated', '=', 'Yes']) );

May 7, 2009, 6:35 AM

Andy

Veteran / Moderator (17297 posts)

May 7, 2009, 6:35 AM

Post #2 of 6

Shortcut

Re: [nir] link by number of day In reply to

Are you asking for a way to get a list of links that were added in the last 2 days?

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

May 7, 2009, 6:36 AM

nir

User (391 posts)

May 7, 2009, 6:36 AM

Post #3 of 6

Shortcut

Re: [Andy] link by number of day In reply to

Yes

May 7, 2009, 6:39 AM

Andy

Veteran / Moderator (17297 posts)

May 7, 2009, 6:39 AM

Post #4 of 6

Shortcut

Re: [nir] link by number of day In reply to

Try this (untested)

get_links_from_last_48_hours

Code:
sub { 
	my $today = GT::Date::date_get(); 
	my $yesterday = GT::Date::date_sub($today,1); 

	my $sth = $DB->table('Links')->select( GT::SQL::Condition->new('Add_Date','>=',$yesterday) ) || die $GT::SQL::error; 

	 my @links; 
	 while (my $hit = $sth->fetchrow_hashref) { 

	   if ($CFG->{build_detailed}) { $hit->{detailed_url} = $CFG->{build_detail_url} . "/" . $DB->table('Links')->detailed_url( $hit->{ID} ); } 

	   if ($hit->{isNew} eq "Yes")     { $hit->{isNew} = 1;     } else { $hit->{isNew} = 0;     } 
	   if ($hit->{isPopular} eq "Yes") { $hit->{isPopular} = 1; } else { $hit->{isPopular} = 0; } 
	   if ($hit->{isChanged} eq "Yes") { $hit->{isChanged} = 1; } else { $hit->{isChanged} = 0; } 

	   push @links, $hit; 
	 } 

	return { last_48_hour_loop => \@links } 

}

..and call with:

Code:
<%get_links_from_last_48_hours%> 
<%if last_48_hour_loop.length%> 
    <%loop last_48_hour_loop%> 
       <%include link.html%> 
    <%endif%> 
<%endif%>

Cheers

Andy (mod)
andy@ultranerds.co.uk