Free Republic
Browse · Search
General/Chat
Topics · Post Article

To: smith288
Not bad, really.

There is a comment table, a comment_user table with the comment-to-user associations, and a killfile table.


create table killfile (
    kf_rule_id int unsigned not null auto_increment primary key,
    kf_owner_uid mediumint unsigned not null,
    kf_action enum('ignore', 'deny', 'dissuade', 'allow', 'promote') not null,
    kf_what enum('all', 'from', 'to', 'replied', 'cc', bcc') not null,
    kf_context enum('user', 'forum', 'thread', 'comment') not null,
    kf_context_id int unsigned not null,

    index owner (kf_owner_uid, kf_context, kf_context_id)
);
When a post is made, and the program is writing the comment-to-user table, it will consult the kf_rule table where kf_owner_uid = the target user, and kf_context will be, in turn, the current thread, the current forum, the current user, etc.

Mind you none of this lives as real code just yet. It's still on my scratch book for the most part.

13 posted on 06/19/2002 5:15:42 PM PDT by John Robinson
[ Post Reply | Private Reply | To 7 | View Replies ]


To: John Robinson
That is perl code?
14 posted on 06/19/2002 5:18:41 PM PDT by Ernest_at_the_Beach
[ Post Reply | Private Reply | To 13 | View Replies ]

To: John Robinson
Oops. kf_rule table == killfile in the example.
18 posted on 06/19/2002 5:31:23 PM PDT by John Robinson
[ Post Reply | Private Reply | To 13 | View Replies ]

To: John Robinson
Im the kind of guy who will just make it with access and tinker until it is the way i want it. Is that your type of scratch pad or is it physical paper?
20 posted on 06/19/2002 5:35:38 PM PDT by smith288
[ Post Reply | Private Reply | To 13 | View Replies ]

Free Republic
Browse · Search
General/Chat
Topics · Post Article


FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson