group_spam_removal_blurb

group_spam_removal_blurb   db   group_id

A blurb to append to group spam messages, telling users why they got the spam and how to avoid getting it in the future

Source code:

    set group_name [database_to_tcl_string $db "select group_name
    from user_groups
    where group_id=$group_id"]

    set short_name [database_to_tcl_string $db "select short_name
    from user_groups
    where group_id=$group_id"]

    return "

--------------
To stop receiving any future spam from the $group_name group :
click <a href=[ad_url]/groups/$short_name/edit-preference?dont_spam_me_p=t>here</a>"