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.
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.
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.
Posted
You can add a check constraint to avoid any registrations with that country:
This is for SQL Server and should be run in SQL Server Management Studio. With this, all such registrations will fail.
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.
Posted
Thanks Ruirib, I see you have found my weak spot 