Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Global Request for If Paid link then

Jan 22, 2005, 9:49 AM

SSmeredith

User (254 posts)

Jan 22, 2005, 9:49 AM

Post #1 of 4

Shortcut

Global Request for If Paid link then

Hi All!

I'm looking for a global that will let users who have a paid link view pages non-paid linkowners can't.

Just for a simple tag placement, not really any integration deeper than that.

<% if linkowner paid see this text%>
Text here
<%else>
all the rest of the stuff here
<%endif%>

Thanks in advance for your help!

Jan 24, 2005, 2:22 PM

jdgamble

Enthusiast (700 posts)

Jan 24, 2005, 2:22 PM

Post #2 of 4

Shortcut

Re: [SSmeredith] Global Request for If Paid link then In reply to

Just thinking in text, but...

sub {
my $tag = shift;
my ($table, $sth);
$table = $DB->table ('Links');
$sth = $table->select ( { LinkOwner => $tag->{Username}, isValidated => 'Yes' }, ['ExpiryDate', 'ExpiryCounted', 'ExpiryNotify'] );

.......... something like that depending on your setup
}

Maybe you could find a way to open the links db, search for the links submitted by the user, and check if the link has been paid (although if the link is free or if is paid for life, it will not expire). It really depends on the exact setup you have.

Another option is to add a field in the user database call isPaid. Write a global that updates the field to yes when a user actually pays.

Just ideas,

(My dentist says think with trident, so I do... or do I?... What?)

- Jonathan

Jun 23, 2007, 10:30 PM

netnow777

Novice (12 posts)

Jun 23, 2007, 10:30 PM

Post #3 of 4

Shortcut

Re: [SSmeredith] Global Request for If Paid link then In reply to

Do you ever figure this out? I amtrying to do the same thing

Jun 24, 2007, 5:02 AM

Andy

Veteran / Moderator (18441 posts)

Jun 24, 2007, 5:02 AM

Post #4 of 4

Shortcut

Re: [netnow777] Global Request for If Paid link then In reply to

Hi,

Depending on how you want to invoke it, you could do something like:

Code:
sub { 
   if ($USER->{Username}) { 

      my $count = $DB->table('Links')->count( GT::SQL::Condition->new('isValidated','=','Yes','ExpiryDate','>','2147483647') ) || 0; 
      if ($count) { 
         return { can_view => 1  } 
      } 
  } 
}

Then, if you are trying to show a page called test.html (i.e a template called that), you would need this at the top:

Code:
<%global_name%> 

  <%if can_view%> 
    ...show page here 
  <%endif%>

..and then when calling via page.cgi?p=test ... it would look for the username (based on their login), and see if any links are paid for (and active).

TOTALLY untested, but should hopefully do the trick :)

Cheers

Andy (mod)
andy@ultranerds.co.uk