Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 More Spam ideas

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
Mr Pink Posted - 22 July 2011 : 04:00:57
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.
2   L A T E S T    R E P L I E S    (Newest First)
Mr Pink Posted - 23 July 2011 : 14:16:57
Thanks Ruirib, I see you have found my weak spot
ruirib Posted - 22 July 2011 : 11:01:35
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 Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000 Version 3.4.07