End-User Options - Second Level Login by liamwli

THIS MOD IS FOR VBULLETIN 4.1.0+

This modification provides a feature for users of your forum to request a code via email on login, which is then needed to complete the login process.

This mod is similar to the Infinity: Dual Authentication LITE modification.

This mod differs in a few aspects however:

1. You have the ability to force usergroups to use this mod
2. This mod only has the second code option
3. This mod doesn't stop people accessing the usercp if you don't want them to use this mod

Like I said, you have the ability to force usergroups to use this mod. If a user is in a usergroup you have forced, then they will get an error when they view the forumhome if they have't enabled this mod on their account.

As well as that, there is an option for Admin's to specify their own custom code algorithm. This will allow Admin's to choose how the random second code is generated, if they so wish.

Screenshots below. Please mark as installed for more support.

Changelog:
1.1.0
Added hooks to allow further development
Removed unused plugin

1.0.1
Fixed mutiple SQL Injection vulnerabilities.

1.0
Initial Release

[liamwli]

Reserved

I shall be adding some hooks to this mod in a later version, incase people would like to expand its capability.

[Nirjonadda]

Not working get database error ?

Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT authon FROM vbliam_sll WHERE userid='3';

MySQL Error : Table 'user_forumdata.vbliam_sll' doesn't exist
Error Number : 1146
Request Date : Sunday, October 21st 2012 @ 11:14:12 PM
Error Date : Sunday, October 21st 2012 @ 11:14:13 PM
Classname : vB_Database
MySQL Version : 5.1.65-cll

[liamwli]

Originally Posted by Nirjonadda

Not working get database error ?

Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT authon FROM vbliam_sll WHERE userid='3';

MySQL Error : Table 'user_forumdata.vbliam_sll' doesn't exist
Error Number : 1146
Request Date : Sunday, October 21st 2012 @ 11:14:12 PM
Error Date : Sunday, October 21st 2012 @ 11:14:13 PM
Classname : vB_Database
MySQL Version : 5.1.65-cll

Hmm. I shall look into this.

It looks like the table has been made without the prefix. Should be an easy fix.

Please could you open phpmyadmin and do a table search for liam_sll and tell me what it is actually called, and then execute this SQL query, then try using the mod again?

RENAME TABLE `liam_sll` TO `vbliam_sll`

[Nirjonadda]

So you can not fix with Manual execute this SQL query ? please try to fix database create table when while installing this mod !

[liamwli]

Originally Posted by Nirjonadda

So you can not fix with Manual execute this SQL query ? please try to fix database create table when while installing this mod !

I just fixed it, but you probably already have a table, so there is not much point in making a new one

[Nirjonadda]

Its bug on main login ,when Enabled this mod my main login password not work,cannot login my site, how to fix?

[YOODA230]

Brilliant idea

[liamwli]

Originally Posted by Nirjonadda

Its bug on main login ,when Enabled this mod my main login password not work,cannot login my site, how to fix?

What actually happens in detail?

Does it give you the vbulletin incorrect password page?

[Nirjonadda]

Yes ! I think when login with 1st password we get Second Level Login page but cannot 1st login with main password !