Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Cat description on Detailed Page

Dec 12, 2009, 11:38 AM
Robert
Enthusiast (718 posts)
Dec 12, 2009, 11:38 AM
Post #1 of 4
Views: 1217
Shortcut
Quote Reply
Cat description on Detailed Page
I know to bring the field Description from the category to a detailed page; but i dont understand why we have all other fields from the category automaticly there but not this one.

Maybe a problem of two times the name Description in category and links?

May someone tell my the rows in the scripts where i can find and resolve it?
It makes no sense for me to have an extra plugin, when there is a select * from cat somewhere.

Last edited by:

Robert: Dec 12, 2009, 11:38 AM
Dec 12, 2009, 12:02 PM
Robert
Enthusiast (718 posts)
Dec 12, 2009, 12:02 PM
Post #2 of 4
Views: 1181
Shortcut
Quote Reply
Re: [Robert] Cat description on Detailed Page In reply to
The problem is here (nph-build.cgi, line 553):

Code:
# Only select Category columns that don't conflict with Links columns.
my @cat_cols = grep !$links_cols{$_}, keys %{$DB->table('Category')->cols};
my $sth = $rel->select('Links.*', @cat_cols, 'CategoryID' => $cond);


May someone has an idea how to add:

category.Description as description?

Then everything should be done.

Last edited by:

Robert: Dec 12, 2009, 12:03 PM
Dec 12, 2009, 8:06 PM
Robert
Enthusiast (718 posts)
Dec 12, 2009, 8:06 PM
Post #3 of 4
Views: 1174
Shortcut
Quote Reply
Re: [Robert] Cat description on Detailed Page In reply to
sorry, have posted this in the wrong forum. it is a question for LSQL, maybe someone could moveit, please.
Dec 13, 2009, 4:53 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Dec 13, 2009, 4:53 AM
Post #4 of 4
Views: 1161
Shortcut
Quote Reply
Re: [Robert] Cat description on Detailed Page In reply to
Np - I've moved it for you.

So if I'm right, you wanna get the category description, on the detailed page? Should be pretty simple:

get_cat_desc_for_detailed
Code:
sub {
my $cat_id = $DB->table('CatLinks')->select( ['CategoryID'], { LinkID => $_[0] } )->fetchrow;
my $cat_desc = $DB->table('Category')->select( ['Description'], { ID => $cat_id } )->fetchrow;
return { Category_Description => $cat_desc };
}

Then call in detailed.html with:

Code:
<%get_cat_desc_for_detailed ($ID)%>
Cat Description is: <%Category_Description%>

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