Microsoft.AspNetCore.Mvc.Localization.LocalizedHtmlStringMore Spam ideas

More Spam ideas

Printed from: Snitz™ Forums 2000
URL: https://forum.snitz.com/forumTopic/Posts/69968?pagenum=1
Printed on: 05 November 2025, 02:11

Topic

Author : Mr Pink
Subject : More Spam ideas
Posted : 22 July 2011, 04:00
Message :

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.

Replies ...

Reply Author: ruirib
Replied on: 22 July 2011, 11:01
Message:

You can add a check constraint to avoid any registrations with that country:

Code:


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.

Reply Author: Mr Pink
Replied on: 23 July 2011, 14:16
Message:

Thanks Ruirib, I see you have found my weak spot