Administrative and Maintenance Tools - Nexia's ImpEx fix for IP.Boards users passwords

Essential to everybody who moved from IP.Board to vBulletin lately.

You always complain that the IP.Board ImpEx is uncomplete because it does not import passwords... here is the fix!

... the guys at vB.System say they can't because the password is coded different from vB... false affirmation... it is really easy to fix when we do a little research as coders!

ok, there you go, you simply have to install this product after you used ImpEx, and your users will be able to use their original password to login.

this tool does not edit any file, no manipulation of data, etc...

i tested it on a board with 25 000 users, it taked less than 5 seconds to install. the rest is like 0.000065s to do the transfer when someone try to login!

the engine will convert the old password into a new vBulletin format when someone with an IP.Board password is detected. it will not mess up your board for other systems, as it is checking the right details.



content of the readme...

################################################## #############################
# PRODUCT NAME: Nexia's ImpEx fix for IP.Boards users passwords
# DESCRIPTION: Import and manage old IP.Board passwords inside vBulletin
# CONCEPT: Missing feature in ImpEx for ages!
# AUTHOR: Jean-Pierre Michaud, aka nexialys the vbenhancer
# CONTACT: nexialys@yahoo.com
# COMPATIBILITY: Source: IP.Board 2.x and 3.x all versions
# Target: vBulletin 3.7.x and newer and 4.x all versions

################################################## #############################
# NOTICES BEFORE INSTALLATION:

# 1: This product is completely useless for you if you did not merge a IP.Board forum within your vBulletin lately...

# 2: You need to still have your ImpEx installation in place to do the install of the product. Once installed, you do what you want with ImpEx, as it is not required anymore.

# 3: You can uninstall this product without risks. But when you do, wait until all your users have logged-in at least once to update their password, or they will have to do the old way, reset their password via email.

# 4: The tool will convert users password when they try to login, and update it in the database, so there is no event afterward. Users NEED to login to make it work... when resetting their password, the system clean the data anyway, so it is safe.

# 5: Salt was hashed during the install process, that does not mean you can't season your board to your own taste...

################################################## #############################
# INSTALLATION:

... simply use the products manager to import the product file included in the "IMPORT_THIS_PRODUCT" folder.

there is no setup, no configuration to make.
everything is based on your existing board.

################################################## #############################
# UN-INSTALLATION:

... simply uninstall. the users who did not log-in since the install will need to reset their password.

[vbenhancer]

i release it as BETA, not because it is not complete, but because a lot of IP.Boards and vBulletin versions are involved so there may be bugs in some versions... if you install the product and it fails delivering a password more than 3 times, post your situation here...

[vbenhancer]

no echoes? so i suppose the 9 guys who downloaded it are happy with the solution?!

[Merenguista]

Merci bcq même si je ne sais pas trop à quoi ça sert ..

[vbenhancer]

y a des fois, les gens... misère...

... next time, in english, thanks!

[fahl]

Thanks vbenhancer,much appreciated

Getting this error,
vBulletin 4.1.12 Patch Level 1
From
Ipn 3.3.1.

ImpEx Database error

mysql error: Invalid SQL: 
		SELECT id, members_pass_hash, members_pass_salt
		FROM members
	

mysql error: Unknown column 'id' in 'field list'

mysql error number: 1054

Date: Saturday 28th 2012f April 2012 03:09:05 AM
Database: trikersu_trikersuk
MySQL error: Unknown column 'id' in 'field list'

[alasiri]

thanks

[Acers]

Originally Posted by fahl

Thanks vbenhancer,much appreciated

Getting this error,
vBulletin 4.1.12 Patch Level 1
From
Ipn 3.3.1.

ImpEx Database error

mysql error: Invalid SQL: 
		SELECT id, members_pass_hash, members_pass_salt
		FROM members
	

mysql error: Unknown column 'id' in 'field list'

mysql error number: 1054

Date: Saturday 28th 2012f April 2012 03:09:05 AM
Database: trikersu_trikersuk
MySQL error: Unknown column 'id' in 'field list'

To fix this (as the database has changed in the latest IPB version, open the product file attached by nexia and change (Line 87)

PHP Code:

        SELECT id, members_pass_hash, members_pass_salt 


to

PHP Code:

        SELECT member_id as id, members_pass_hash, members_pass_salt 


That will fix it

[ripley]

Downloaded, performed Acers' modification, and receive this error when registering a new user:

Fatal error:

    A required field called import_ipbpass is missing or has an invalid value.

Unable to proceed with save while $errors array is not empty in class vB_DataManager_User in [path]/includes/class_dm.php on line 849

[ripley]

Whoops, just noticed author sig. Guess members will have to go through password reset.