[MODDB] Security Question
Posted: Sun Jan 21, 2007 9:30 am
MOD Title: Security Question
MOD Description: This mod asks a question during registration needs some rational thought put in to the answer, thus stopping a spambot. In addition it hides the profile fields during registration. So a human spammer who never intends to confirm his membership can not leave a spam URL in any of the fields. Also, a wrong answer re directs you to the index page.
The question and answer are configerable in the ACP to any you choose
MOD Version: 1.0.0
MOD Download: http://www.photosbyjames.net/security_q ... _1.0.0.zip
Thanks to the author of the VIP MOD, which inspired me to come up with this idea, and to CoC who helped me with the SQL coding and making it MOD compliant.
I have been running the non ACP configerable version on my forum for 4+ months and not had one spambot join the forum. Having the question and answer configerable from the ACP means that the answer need never appears on the forum. The answer can be numerical or text, although it is case sensitive.
It will install with easymod
I am afraid I am unable to have a demo board for you to try, but the screenshots below show how it looks.
EDIT:- I have changed the position of the switch to make it look a lot neater. Latest version is downloadable from the above link
FAQ
~~~~~
Q How do I read the MOD file?
A Right click, and open it in any text editor
~~~~~
Q What files do I edit to do this?
A Go to your php myadmin. Most likely http://www.yoursitename.com/forum/phpmyadmin
Enter your SQL user name and password.
Select your database from the drop down menu on the left. Then just click the SQL tab. Then you will get an empty SQL query window.
Cut and paste
in to the window,
press go.
If you click on phpbb_config and browse through it, on the last page you will see the new rows in alphabetical order. Then just log out.
~~~~~
Q The question and answer fields are empty in the ACP. What do I do?
A See answer above
~~~~~
Q Will this MOD work with styles other than subSilver?
A Yes, just do the same edits to admin/board_config_body.tpl and profile_add_body.tpl in the style(s) you want as are listed to edit in the subSilver files.
~~~~~
Q What versions of phpBB will it work on?
A I have only tested it on 2.0.21 and later. It should work on earlier versions, but you are better off up dating your forum first, then install this MOD
edit reason:- FAQ added
edit reason:- Correction
MOD Description: This mod asks a question during registration needs some rational thought put in to the answer, thus stopping a spambot. In addition it hides the profile fields during registration. So a human spammer who never intends to confirm his membership can not leave a spam URL in any of the fields. Also, a wrong answer re directs you to the index page.
The question and answer are configerable in the ACP to any you choose
MOD Version: 1.0.0
MOD Download: http://www.photosbyjames.net/security_q ... _1.0.0.zip
Thanks to the author of the VIP MOD, which inspired me to come up with this idea, and to CoC who helped me with the SQL coding and making it MOD compliant.
I have been running the non ACP configerable version on my forum for 4+ months and not had one spambot join the forum. Having the question and answer configerable from the ACP means that the answer need never appears on the forum. The answer can be numerical or text, although it is case sensitive.
It will install with easymod
I am afraid I am unable to have a demo board for you to try, but the screenshots below show how it looks.
EDIT:- I have changed the position of the switch to make it look a lot neater. Latest version is downloadable from the above link
FAQ
~~~~~
Q How do I read the MOD file?
A Right click, and open it in any text editor
~~~~~
Q What files do I edit to do this?
Code: Select all
INSERT INTO phpbb_config (config_name, config_value) VALUES ('securityquestion','How many days in a year?');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('securityanswer','365');
Enter your SQL user name and password.
Select your database from the drop down menu on the left. Then just click the SQL tab. Then you will get an empty SQL query window.
Cut and paste
Code: Select all
INSERT INTO phpbb_config (config_name, config_value) VALUES ('securityquestion','How many days in a year?');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('securityanswer','365');
press go.
If you click on phpbb_config and browse through it, on the last page you will see the new rows in alphabetical order. Then just log out.
~~~~~
Q The question and answer fields are empty in the ACP. What do I do?
A See answer above
~~~~~
Q Will this MOD work with styles other than subSilver?
A Yes, just do the same edits to admin/board_config_body.tpl and profile_add_body.tpl in the style(s) you want as are listed to edit in the subSilver files.
~~~~~
Q What versions of phpBB will it work on?
A I have only tested it on 2.0.21 and later. It should work on earlier versions, but you are better off up dating your forum first, then install this MOD
edit reason:- FAQ added
edit reason:- Correction