Bulk User Insert

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

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