Bulk User Insert : i want to move my users another...

Wed, 05 Jul 2006 00:13:32 +0000

Author: melihme
Subject: 20542
Posted: 05 July 2006 at 12:13am

i want to move my users another forum to webwiz,

old forum save password without any hash...

so..

i used webwiz's functions and create salt, usercode, password (i refered admin_add_member.asp) and save them a mdb file..

then i wrote sql like below...


sql = "INSERT INTO tblAuthor (Username, Password, Author_email, User_code, salt, location, PM_notify, Reply_notify, Rich_editor, Active, Attach_signature, Show_email, Time_offset_hours,Time_offset,Group_ID)"
    sql = sql & " VALUES('" & strUsername &"','" & kRS("hashed_pass") &"','" & kRS("email") &"','" & userCode(strUsername) &"','" & kRS("salt") &"','" & kRS("location") &"',1,0,1,1,1,1,7,'-',4);"

i puted the sql in a loop, its OK, insert users to webwiz db but users can not log-in due password error...

Edited by melihme - 05 July 2006 at 12:14am

Web Wiz Support and Community Forums : Bulk User Insert

Bulk User Insert : i want to move my users another...