The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Well, not really a true forum mod, it is msSQL server trigger. I find it cleaner and faster solution then asp forum mod.
This trigger is a result as constant PM abuse on my forum. One group of members did constantly sending link to their warez and XXX sites. I lock/deleted them, but they registered again, and start sending PM with links to all members immediately. They gave me a big problem, and I didn’t have a true solution for them until this trigger.
installation Before creating this trigger, you have to add a new column "spam" to forum_members table
int DEFAULT (0) DEFAULT (0) is very important
sorry, you have to do it manually.
customization look at lines 28, 42, 44, it is simple
also look at 33, you have to write message in your language :)
download download<
This trigger is a result as constant PM abuse on my forum. One group of members did constantly sending link to their warez and XXX sites. I lock/deleted them, but they registered again, and start sending PM with links to all members immediately. They gave me a big problem, and I didn’t have a true solution for them until this trigger.
installation Before creating this trigger, you have to add a new column "spam" to forum_members table
int DEFAULT (0) DEFAULT (0) is very important
sorry, you have to do it manually.
customization look at lines 28, 42, 44, it is simple
also look at 33, you have to write message in your language :)
download download<
Posted
It looks cool and I'd love to try it. Unfortunately I don't have MS SQL server. How hard would it be to duplicate that functionality with some ASP? I realize that its not as clean and fast as a SQL Server Trigger, but its all a lot of us have available... 
<
<
Posted
Oh, I totally forgot. What does this trigger do:
1. It finds PM (m_id) with content given in WHERE m_message conditions (line 10)
2. Then, trigger find PM sender, PM receiver, PM subject, PM text for given m_id
3. Send that data as new PM to admins (mods possible)
4. delete that PM from forum_PM
5. update member (sender) spam status (+1)
6. a) if member (sender) have less then XX forum posts (“new member” (set XX as you like)) - set status 0 + “bad” title
b) if member (sender) have more then XX spam attempts (set XX as you like) - set status 0 + “bad” title
<
1. It finds PM (m_id) with content given in WHERE m_message conditions (line 10)
2. Then, trigger find PM sender, PM receiver, PM subject, PM text for given m_id
3. Send that data as new PM to admins (mods possible)
4. delete that PM from forum_PM
5. update member (sender) spam status (+1)
6. a) if member (sender) have less then XX forum posts (“new member” (set XX as you like)) - set status 0 + “bad” title
b) if member (sender) have more then XX spam attempts (set XX as you like) - set status 0 + “bad” title
<
Posted
Originally posted by AnonJrI guess it isn’t hard to do some mysql(?) fix ?!?<
It looks cool and I'd love to try it. Unfortunately I don't have MS SQL server. How hard would it be to duplicate that functionality with some ASP? I realize that its not as clean and fast as a SQL Server Trigger, but its all a lot of us have available...
Posted
Actually, I'm using Access for my two public forums. I haven't had the traffic to justify anything else.... yet. 
<
<
Posted
Would this work with MySQL also? =)
<
<