Web Wiz Forums - Bulk User Insert

Print Page | Close Window

Bulk User Insert

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20542
Printed Date: 09 April 2026 at 2:10pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Bulk User Insert

Posted By: melihme
Subject: Bulk User Insert
Date 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...