Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Display last 5 submissions by logged in user

Aug 12, 2005, 6:15 AM

nt6

User (362 posts)

Aug 12, 2005, 6:15 AM

Post #1 of 7

Shortcut

Display last 5 submissions by logged in user

Hello GT community,

I would like if someone could possibly point out how to make a global that would allow to show the last 5 submissions a logged in user has made in our dbase on the home.html page.

I do not know how to write in Perl, although I can almost read it! Wink

Thanks in advance.

Aug 12, 2005, 8:36 AM

Andy

Veteran / Moderator (18436 posts)

Aug 12, 2005, 8:36 AM

Post #2 of 7

Shortcut

Re: [nt6] Display last 5 submissions by logged in user In reply to

Hi,

Something like this should work;

<%global_name%>

..with code;

Code:
sub { 
  my $table = $DB->table('Links'); 
       $table->select_options("ORDER BY TimeStmp","LIMIT 5"); 
  my $sth = $table->select( { LinkOwner => $USER->{Username} } ) || return $GT::SQL::error; 
  my @links; 
  while (my $hit = $sth->fetchrow_hashref) { 
   push @links, $hit; 
  } 
  return { latest_non_admin_links_loop => \@links }; 
}

...and access with (after the global call);

Code:
<%if latest_non_admin_links_loop%> 
  <%loop latest_non_admin_links_loop%> 
    <%include link.html%> 
  <%endloop%> 
<%endif%>

Hope that helps =)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Last edited by:

Andy: Aug 13, 2005, 1:02 AM

Aug 12, 2005, 11:34 AM

nt6

User (362 posts)

Aug 12, 2005, 11:34 AM

Post #3 of 7

Shortcut

Re: [Andy] Display last 5 submissions by logged in user In reply to

Wow thanks Andy,

but does that display the last submission by the user that has logged in or just by someone who is not the admin?

I would like to show the user when he goes to home.html the last submissions he has made to the site.

Aug 13, 2005, 1:04 AM

Andy

Veteran / Moderator (18436 posts)

Aug 13, 2005, 1:04 AM

Post #4 of 7

Shortcut

Re: [nt6] Display last 5 submissions by logged in user In reply to

Hi,

No problem =)

Give the above modified version a go. This will grab links based on $USER->{Username}, which should be the current user =:)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 13, 2005, 4:14 AM

nt6

User (362 posts)

Aug 13, 2005, 4:14 AM

Post #5 of 7

Shortcut

Re: [Andy] Display last 5 submissions by logged in user In reply to

Andy,

I am not able to have the result displayed Blush

, can you please tell me exactly how to call the global in home.html? I called the global like this:

<%if latest_non_admin_links_loop%>
<%loop latest_non_admin_links_loop%>
<%include link.html%>
<%endloop%>
<%endif%>

Aug 13, 2005, 6:20 AM

Andy

Veteran / Moderator (18436 posts)

Aug 13, 2005, 6:20 AM

Post #6 of 7

Shortcut

Re: [nt6] Display last 5 submissions by logged in user In reply to

You need to call the global first, or the loop won't exist Tongue

Code:
<%global_name%> 
<%if latest_non_admin_links_loop%> 
  <%loop latest_non_admin_links_loop%> 
     <%include link.html%> 
  <%endloop%> 
<%endif%>

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 13, 2005, 7:29 AM

nt6

User (362 posts)

Aug 13, 2005, 7:29 AM

Post #7 of 7

Shortcut

Re: [Andy] Display last 5 submissions by logged in user In reply to

Thank you Andy for your time Smile