Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Global to Display Category Properties on add.html

Nov 28, 2005, 3:27 AM

SWDevil.Com

Enthusiast (974 posts)

Nov 28, 2005, 3:27 AM

Post #1 of 24

Shortcut

Global to Display Category Properties on add.html

I was wondering if anyone knows how to write a global that will display category properties (for example, there is a seperate category field such as category_add_listing_description that will be shown on add.html so users can better understand the defination of the category) on add.html & add_success.html & detailed.html page?

Thank you very much.

Vishal

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------

Nov 28, 2005, 6:12 AM

tandat

Enthusiast (764 posts)

Nov 28, 2005, 6:12 AM

Post #2 of 24

Shortcut

Re: [SWDevil.Com] Global to Display Category Properties on add.html In reply to

Hi,

Something below should work

sub {

my $cols = $DB->table('Category')->cols;
my $output = qq|<table border=1><tr><th>Fields</th><th>Type</th><td>Default value</td></tr>|;
foreach (sort{$cols->{$a}->{pos} <=> $cols->{$b}->{pos}} keys %$cols){

my $f = $cols->{$_};

my $n = $f->{form_display} || $_;
$output .= qq|<tr><td>$n</td><td>$f->{form_type}</td><td>$f->{default}</td></tr>|;
}

$output .= "</table>";
return $output;

}

Cheers,

Dat

Scripts installation and plugin creation
Plugins

Nov 28, 2005, 8:14 AM

SWDevil.Com

Enthusiast (974 posts)

Nov 28, 2005, 8:14 AM

Post #3 of 24

Shortcut

Re: [tandat] Global to Display Category Properties on add.html In reply to

Hello Dat,

Thank you for the quick reply and help.

Yes the global above works, however what it does is displays all the category property in a table format where the sub is inserted.

I was wondering if you knew how to display only certain selected field when and where required, for example

(a) Category add link description:
So like where I want the description to appear I can add <%category_add_link_description%> (or whatever the global would be)

(b) Category Type:
I have this as enum field in category property. So based on the type of category, it will have different include_link_addition_form.html

...

--------------------------

When I use gt:template:dump tag in the template, I can see the fields in category loop as below:

category_loop [
{
'CatDepth' => '0',
'CatRoot' => '0',
'Category_Template' => '',
'Category_Type' => 'glossary',
'Description' => '',
'Direct_Links' => '2',
'FatherID' => '0',
'Footer' => '',
'Full_Name' => 'glossary',
'Has_Changed_Links' => 'No',
'Has_New_Links' => 'Yes',
'Header' => '',
'ID' => '10',
'Link_Add_Description' => 'This is link add description. This is link add description. This is link add description. ',
'Meta_Description' => '',
'Meta_Keywords' => '',
'Name' => 'glossary',
'Newest_Link' => '2005-11-26',
'Number_of_Links' => '2',
'Payment_Description' => '',
'Payment_Mode' => '0',
'Timestmp' => '2005-11-28 10:10:57',
'category_display_name' => 'Glossary',
}
];

Thank you for the help.

Vishal

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------

Nov 28, 2005, 10:40 AM

tandat

Enthusiast (764 posts)

Nov 28, 2005, 10:40 AM

Post #4 of 24

Shortcut

Re: [SWDevil.Com] Global to Display Category Properties on add.html In reply to

It's simple to print out all the fields. You can limit some by adding the next command within the foreach loop as below

next if(/ID|Timestamp/);

Cheers,

Cheers,

Dat

Scripts installation and plugin creation
Plugins

Nov 28, 2005, 11:57 PM

Andy

Veteran / Moderator (17366 posts)

Nov 28, 2005, 11:57 PM

Post #5 of 24

Shortcut

Re: [tandat] Global to Display Category Properties on add.html In reply to

Hi,

You could try something like this (untested). It should return new tags such as;

<%category_add_help_Description%>

Code:
sub { 

   my $cols = $DB->table('Category')->cols; 

   my $return; 
   foreach (sort{$cols->{$a}->{pos} <=> $cols->{$b}->{pos}} keys %$cols){ 
     my $f = $cols->{$_}; 
     my $n = $f->{form_display} || $_; 
     my $field = "category_add_help_" . $f; 
     $return->{$field} = qq|$n - Example, $f->{default}|; 
   } 

   return $return; 

}

Hope that helps.

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

Nov 29, 2005, 2:34 AM

Hargreaves

User (107 posts)

Nov 29, 2005, 2:34 AM

Post #6 of 24

Shortcut

Re: [Andy] Global to Display Category Properties on add.html In reply to

Using sort() is redundant in that case.

Nov 29, 2005, 4:52 AM

SWDevil.Com

Enthusiast (974 posts)

Nov 29, 2005, 4:52 AM

Post #7 of 24

Shortcut

Re: [Andy] Global to Display Category Properties on add.html In reply to

Hello Andy,

The global does not seem to work.

This is what I did.

Created a new global & named it cat_field1
Now in add.html above Title field, I wanted to display the Category Description, so in the template I inserted <%cat_field1%> however the output was Unknown Tag: 'catfield1'

I have created a table Link_Add_Description in category properties in GLinks Admin & while adding category, I also write 2-3 lines of description for the category. So when end users are adding the listing, within the template I can display this Link_Add_Description in proper formatted manner.

Thank you for the the help.

Vishal

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------

Nov 29, 2005, 6:37 AM

Andy

Veteran / Moderator (17366 posts)

Nov 29, 2005, 6:37 AM

Post #8 of 24

Shortcut

Re: [SWDevil.Com] Global to Display Category Properties on add.html In reply to

Hi,

erm, so in fact you don't want the value from the table.. but instead the "Description" of the categories from the table "Link_Add_Description" field in lsql_Category?

Kinda different things Tongue

Cheers

Andy (mod)
andy@ultranerds.co.uk

Nov 29, 2005, 6:45 AM

SWDevil.Com

Enthusiast (974 posts)

Nov 29, 2005, 6:45 AM

Post #9 of 24

Shortcut

Re: [Andy] Global to Display Category Properties on add.html In reply to

In Reply To:

Cheers

Right on target....

So any idea, how would this work?

Vishal

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------

Nov 29, 2005, 7:09 AM

Andy

Veteran / Moderator (17366 posts)

Nov 29, 2005, 7:09 AM

Post #10 of 24

Shortcut

Re: [SWDevil.Com] Global to Display Category Properties on add.html In reply to

...well, assuming they are passing in ?ID=xxxx (where xxx is the Id of the category they want to add), you could use something like;

Code:
sub { 
   my $ID = $IN->param('ID') || return ''; 
   my $catdesc = $DB->table('Category')->select( ['Link_Add_Description'], { ID => $ID } )->fetchrow; 
   return $catdesc; 
}

Cheers

Andy (mod)
andy@ultranerds.co.uk

Nov 29, 2005, 11:04 AM

SWDevil.Com

Enthusiast (974 posts)

Nov 29, 2005, 11:04 AM

Post #11 of 24

Shortcut

Re: [Andy] Global to Display Category Properties on add.html In reply to

Dude !!!!!

you are genius.... it worked perfectly Smile

Thanks again for the help.

Vishal

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------

Nov 29, 2005, 11:23 AM

Andy

Veteran / Moderator (17366 posts)

Nov 29, 2005, 11:23 AM

Post #12 of 24

Shortcut

Re: [SWDevil.Com] Global to Display Category Properties on add.html In reply to

LOL no problem Blush

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 2, 2006, 3:11 PM

SWDevil.Com

Enthusiast (974 posts)

Jan 2, 2006, 3:11 PM

Post #13 of 24

Shortcut

Re: [Andy] Global to Display Category Properties on add.html In reply to

Hello Andy,

Above global works great with text fields, however when I try to use it along with ENUM (Select or Radio) options, it fails to work. Any ideas?

Vishal

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------

Jan 2, 2006, 5:34 PM

webmaster33

Veteran (2312 posts)

Jan 2, 2006, 5:34 PM

Post #14 of 24

Shortcut

Re: [SWDevil.Com] Global to Display Category Properties on add.html In reply to

Likely they produce an array result, so you need to handle array at input:
my @ID = ($IN->param('ID')) || return '';

Just a quick idea. Not tested.

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

Jan 3, 2006, 1:51 AM

Andy

Veteran / Moderator (17366 posts)

Jan 3, 2006, 1:51 AM

Post #15 of 24

Shortcut

Re: [SWDevil.Com] Global to Display Category Properties on add.html In reply to

When you say "fails to work", what do you mean by that? Doesn't print anything, or its all on one line?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 3, 2006, 4:40 AM

SWDevil.Com

Enthusiast (974 posts)

Jan 3, 2006, 4:40 AM

Post #16 of 24

Shortcut

Re: [Andy] Global to Display Category Properties on add.html In reply to

Hello Andy,

Thanks for the reply. Sorry for the false alarm, as a matter of fact it is working perfectly for both text area fields & also select/radio fields too.

P.S. I was working on 3 sets of template & by mistake was updating one set & uploading another :( & hence the error.

Thank you again for the help.

Vishal

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------

Jan 3, 2006, 4:44 AM

Andy

Veteran / Moderator (17366 posts)

Jan 3, 2006, 4:44 AM

Post #17 of 24

Shortcut

Re: [SWDevil.Com] Global to Display Category Properties on add.html In reply to

In Reply To:

heheh.. np =)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jul 6, 2006, 9:35 AM

incik

User (246 posts)

Jul 6, 2006, 9:35 AM

Post #18 of 24

Shortcut

Re: [Andy] Global to Display Category Properties on add.html In reply to

How would you modify this global to display category properties on detailed pages

for example I want to display ID, Name or FatherID of a link belonging to whatever category its located in on its detailed page

Thanks

Jul 6, 2006, 6:08 PM

Andy

Veteran / Moderator (17366 posts)

Jul 6, 2006, 6:08 PM

Post #19 of 24

Shortcut

Re: [incik] Global to Display Category Properties on add.html In reply to

In Reply To:

Hi,

Something like this would do it;

Code:
sub {  
   my $ID = $IN->param('ID') || return '';  
   my $cat = $DB->table('Category')->select( { ID => $ID } )->fetchrow_hashref;  
   return $cat;  
}

Then you should have access to all the category properties :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jul 7, 2006, 12:29 PM

incik

User (246 posts)

Jul 7, 2006, 12:29 PM

Post #20 of 24

Shortcut

Re: [Andy] Global to Display Category Properties on add.html In reply to

Thanks for the assist

but it didnt work

Jul 25, 2006, 3:19 AM

incik

User (246 posts)

Jul 25, 2006, 3:19 AM

Post #21 of 24

Shortcut

Re: [incik] Global to Display Category Properties on add.html In reply to

it didnt work

unless I did it wrong

any examples you could show?

Jul 28, 2006, 3:48 PM

afinlr

Veteran (1921 posts)

Jul 28, 2006, 3:48 PM

Post #22 of 24

Shortcut

Re: [incik] Global to Display Category Properties on add.html In reply to

This is a bit more complicated because a link can be in multiple categories. Something like this:

Code:

sub {    
   my $ID = $IN->param('ID') || return '';    
   my $sth = $DB->table('Category','CatLinks')->select( { LinkID => $ID });
   my @cats;
  while (my $cat=$sth->fetchrow_hashref){
     push @cats, $cat;
  }  
   return {Cat_Loop=>\@cats};    
}

Last edited by:

afinlr: Jul 28, 2006, 3:52 PM

Jul 29, 2006, 1:10 AM

afinlr

Veteran (1921 posts)

Jul 29, 2006, 1:10 AM

Post #23 of 24

Shortcut

Re: [incik] Global to Display Category Properties on add.html In reply to

This global returns a loop so you need something like this in your template:

<%loop Cat_Loop%>
<%Name%>
<%endloop%>

Jul 29, 2006, 2:23 PM

pugdog

Veteran / Moderator (6956 posts)

Jul 29, 2006, 2:23 PM

Post #24 of 24

Shortcut

Re: [afinlr] Global to Display Category Properties on add.html In reply to

>> This is a bit more complicated because a link can be in multiple categories.

It may be the one piece of logic GT hasn't addressed. Brewt had started to, but said there was probably a reason why it wasn't carried through.

This causes problems on "browse" and prev|next ... really weird stuff until you realize what is happening.

Category_ID needs to be preserved in detail page display, and passed on for the next|prev linking too.

In general, there is no way to know what category a link is being displayed for, unless you limit links to being in only one category (which sort of cripples the features of allowing it to exist in multiple categories).

This is a real weakness and hole in the GLinks logic. One of the few I've hit that has been really, really an issue in working through/around.

I hadn't hit it until GL3, since all my sites were using the detail_page.cgi (or modified version) which did preserve the Category_ID somewhat accidentally. next|prev was still affected eventually, but the detail pages at one-level off a category.html knew where they came from.

It probably should be built into the page-spanning code, since that is where it starts to break down fastest. If it's there, it can (or should be allowed to be) accessed as a simple tag such as span_cat_id.

PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.