Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Allow users to submit/modify in multiple categorys?

Quote Reply
Allow users to submit/modify in multiple categorys?
Hello People! Thought it was time to consult the resident LinksSQL gurus once again...

I've found a few threads on this topic but can't seem to find a solution suitable for my needs. Here's all I hope to accomplish:

- Users could submit / modify listings to multiple categorys via a multi select form in the include_form.html ( addition to 3 categorys only )
- Have Users somehow aware of what Categories they are currently listed in for modification purposes.
- To hopefully use some sort of global instead of code hacks for future updating ease.

Here's a thread and global I found on this topic:
http://www.gossamer-threads.com/perl/gforum/gforum.cgi?post=196090;#196090

Warwick from Humorlinks.com was nice enough to offer this global except it doesn't seen to work for me. It did show a few top categorys in which I was using SUB1 as a Description for use with the YahooSubcats Plugin. It didn't display as a multiselect form either. I removed those SUB1 in the Category Descriptions and no Categories would show at all.

I'm still trying to finish up my first LinksSQL project and I don't know enough to fix this global myself...

----------------------------------------------------------
From Humorlinks:

Hi.

This can be done by using a global.

Call it something like <%selected_cats%>

It will replace <%Category%> in include_form.html

sub {
my ($rec) = @_;
my $id = $rec->{ID};
my $db = $DB->table('CatLinks');
my @sids = $db->select ( ['CategoryID'], { 'LinkID' => $id } )->fetchall_list;
my $cat_db = $DB->table('Category');
$cat_db->select_options ('ORDER BY Full_Name ASC');
my $sth = $cat_db->select ( { 'Description' => 'SUB1' }, ['ID', 'Full_Name'] );
my $output;
$output .= "<SELECT MULTIPLE SIZE='5' name='CatLinks.CategoryID'>";
$output .= "<option value=''>-------</option>";
while (my ($cid,$name) = $sth->fetchrow_array) {
$output .= "<option value='$cid'";
foreach my $sid (@sids) {
if ($sid eq $cid) {
$output .= " selected";
}
}
$output .= ">$name</option>";
}
$output .= "</SELECT>";
return $output;
}

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

Many Many Many Thanks for any help getting some sort of multi select category option working in my include_form.html.

Ryan Wink
Subject Author Views Date
Thread Allow users to submit/modify in multiple categorys? Jonze 1373 Aug 8, 2002, 4:19 PM
Post Re: [Jonze] Allow users to submit/modify in multiple categorys?
Jonze 1295 Aug 8, 2002, 8:43 PM
Post Re: [Jonze] Allow users to submit/modify in multiple categorys?
webmaster33 1273 Aug 17, 2002, 1:09 AM