| Author |
 Topic  |
|
|
alienscg
Starting Member
5 Posts |
 Posted - 16 December 2005 : 15:11:07
|
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
[SPAM] 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< |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 16 December 2005 : 15:24:11
|
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...  < |
 |
|
|
alienscg
Starting Member
5 Posts |
Posted - 16 December 2005 : 15:44:47
|
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
< |
|
|
|
alienscg
Starting Member
5 Posts |
Posted - 16 December 2005 : 15:47:09
|
quote:
Originally posted by AnonJr
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...
I guess it isn’t hard to do some mysql(?) fix ?!?< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 16 December 2005 : 16:37:38
|
Actually, I'm using Access for my two public forums. I haven't had the traffic to justify anything else.... yet.  < |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 19 December 2005 : 03:16:50
|
Would this work with MySQL also? =)
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 08 March 2006 : 04:01:58
|
Does anyone know if this would cause trouble with MySQL?
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 08 March 2006 : 12:31:30
|
| If it's converted to ASP I don't see why it shouldn't but the clue is in "SQL Server Trigger"...< |
|
|
| |
Topic |
|
PM abuse MOD
