HABTM Hell.

I am setting up a site for a game and need to have a rumors section. Each User can setup rumors about different aspects of certain Characters on the site. For example, I have a Character that is rumored to work at a certain Job. I setup a HABTM model for both the Character and the Job. A User makes a link between to Character and the Job. This creates a record in the characters_jobs table.

Problem 1: Now I can get that new record to have the character_id and the job_id, but I am not able to get it to have the user_id that made the link in the first place.

Problem 2: Once the links are created, I don't want to allow them to be deleted. Even if the User deselects them from the selection form. How do I stop that from happening? Each time the user deselects a job on the list, it deletes the record, even if if was created by another user.

Problem 3: I want each user who makes that link to have their own record but only once. ie, the whole record needs to be unique, not just the character_id and the job_id. user_id needs to be condidered too.

I have been banging my head against the wall for a while now. Any help would be greatly apprecated.


~Michael

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---