Submitting to multiple categories

[springdot]

To quote delevinson from another post : (and thanks)

Also, I have a mod suggestion: I'd like to list a link in multiple categories. Thanks!

I think this is a really good idea, as often a site is relevant for more than 1 category and I'm sure users would prefer to submit their details once than many times for the same url!


I'll have a think, but would it be difficult to implement??


Cheers
James

[minstrel]

This option worked in the previous release.

I noticed yesterday that it doesn't any more -- it tells me the URL is already in the index.

[springdot]

I actually meant the ability to select more than 1 category when submitting, so as to prevent having to submit the same link multiple times....

[mgiroir]

What about creating another table which would hold:

id
link_id
category_id

like this:

link #256 and #257 would have the following entries in said table
1,256,300
2,256,450
3,256,475
4, 257,15
5,257,36
6,257,229

300, 450, and 475 are the category ids where link #256 needs to be displayed and 15, 36 and 229 are the category ids where link #257 should appear.

and then when the script needs to list the links in a particular category it would then query this table WHERE CATEGORY_ID = 'CATEGORY_ID', take the results and query the PLD_LINK table for the link information for only the listings needed.

This would eliminate the need for all the redundant information created by adding the link to multiple categories.

[Ap0s7le]

I agree that it's a good idea but I believe that is a quick way to get a lot of spam.
Imagine someone coming to the site, submitting a link to 20 cats. Now in the admin, if we don't want it in one cat but will allow in some others, does that means each will be handled as seperate entries, or one rejection means all are rejected?

I think if a link is worth it, and a person believes in it enough to submit to multiple cats than so be it. I on the other hand wouldn't want 20 of the same link added at a time by anyone but an admin. Even DMOZ doesn't allow for that, they see the possible problems with it.

That's just my personal thoughts on the matter though.

later

[mgiroir]

Exactly... didn't mean for it to be done during the submission process, but on the admin side through a seperate script or an adjustment to the current script when editing. Then a script to update the table to add and/or remove a link from certain categories. This way, if you have a link showing up in multiple cats, and the link needs to be deleted all together, there would not be a reason to go looking around to make sure you deleted all the links. Simply editing the record in the PLD_LINK table would update the listing in all cats, and deleting a listing could be done where the record in the PLD_LINK table is removed as well as all records containing the link id # could be deleted from the smaller table. Again all from the admnin side, definitely.

[Ap0s7le]

Right on

I like that idea quite a bit.

I've got to get some sleep

later!

[springdot]

Some good points here.... I think you're right actually - certainly I value sites under my control enough to submit them more than once if needed, so I guess other people should as well!

[Ap0s7le]

To make something easy like that would almost be like getting violated. Haha