Home : Products : Gossamer Links : Discussions :

Products: Gossamer Links: Discussions: Re: [NeedScripts.Com] User Info on Detailed Page: Edit Log

Here is the list of edits for this post
Re: [NeedScripts.Com] User Info on Detailed Page
Ok, heres a simple idea. Create a new global, say 'linkowner_name'. Add the following code into it;

Code:
sub {

my $User= shift;

my $table = $DB->table('Users');
my $sth = $table->select( { Username => $User } );

my $Name;
while (my $hit = $sth->fetchrow_hashref) {
$Name = $hit->{Name};
}

$Name ? return $Name : return "None";

}

Ten call it with something like;

<%linkowner_name($LinkOwner)%>

Untested, but it should work (only problems may be the field names). This should work for all the field names. Simply replace the parts in red with the new field name.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Last edited by:

Andy: Aug 5, 2003, 2:14 AM

Edit Log: