Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 More Spam ideas
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Mr Pink
Junior Member

United Kingdom
387 Posts

Posted - 22 July 2011 :  04:00:57  Show Profile  Visit Mr Pink's Homepage  Send Mr Pink an AOL message  Reply with Quote
Most of the pointless spammers that register on my forum don't bother posting anything. Instead they have lots of links in thier profiles which I believe doesn't benefit them.

One common link between them all is that they put their country down as "Congo, Democratic Republic of"

Is there a way that I can get the forum to ignore registrations that select Congo as thier country?

I don't want to display an error, I'd rather the forum just did nothing with these.


Martin
Leyland Forum Leyland Lancashire UK

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 22 July 2011 :  11:01:35  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
You can add a check constraint to avoid any registrations with that country:


ALTER TABLE forum_members
  WITH NOCHECK ADD  CONSTRAINT CK_NO_CONGO_MEMBERS CHECK  (M_COUNTRY<>'Congo, Democratic Republic of')


This is for SQL Server and should be run in SQL Server Management Studio. With this, all such registrations will fail.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Mr Pink
Junior Member

United Kingdom
387 Posts

Posted - 23 July 2011 :  14:16:57  Show Profile  Visit Mr Pink's Homepage  Send Mr Pink an AOL message  Reply with Quote
Thanks Ruirib, I see you have found my weak spot

Martin
Leyland Forum Leyland Lancashire UK
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07