Database moderation and web forms security

You can block spammers using Ban IP feature as well as require records approve before your users input will be shown on the database widget.

Database moderation

We are happy to tell you that your database application can be more secure now, because in addition to Captcha you can add database moderation or even block spammers IP's forever.

You should use this feature if you use both Form and Database widgets on your site, because users can submit everything to your web form. And you should be aware of it.

For enabling database moderation, please, go to Customize & integrate and find a new Database moderation option.

Ban spammers IP to protect your database application

Even if you have enabled both database moderation and Captcha on your form you can't be sure that your data will always be valid, because spammers always can add bad entries to it. So you may need another way to block them. That is why we added the IP ban feature.

Please, notice that at the right side of each record you have the More link. Click on it and you can see IP of every user who entered the data of your data base. Also below this IP you have a Ban this IP link. Click on it and this user will not be able to fill your form any more.

Of course you may want to unban some users, because some of them can be banned by mistake or maybe they have changed their behaviour for the better :) In the same More section you should see All banned IP's link. Click on it and you will see the list of all IP's blocked in your application. Near each of IP you can see the Unban IP link. Use it if you want to unblock this user again.

Find this feature in Customize & integrate module.

In Customize & integrate module you can find the option Banned Ip's. Click on this link to ban (unban) IP's and see the whole ban list.

To ban Ip you need to enter it into this field. See the screenshot below:

When next time you login to see your new records they will be highlighted. To approve the record click on it. Then find the link Approve and click on it. See the screenshot below.

Protecting web forms with the help of Captcha is another great way to validate users' input. Make sure you choose right security options for your database application!

25.01.2010 Igor Petrushenko