Web Wiz Support and Community Forums : Importing users into tblAuthor https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 17:41:05 +0000 Mon, 27 Mar 2006 12:22:15 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18969 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Importing users into tblAuthor : Sorry the database schema is not...]]> https://forums.webwiz.net/importing-users-into-tblauthor_topic18969_post102488.html#102488 Author: WebWiz-Bruce
Subject: 18969
Posted: 27 March 2006 at 12:22pm

Sorry the database schema is not written down anywhere, apart from a few scraps of paper that probably ended up in the bin years ago.

The password field holds a 160bit encrypted password and the Salt field holds a unique value that is appended to the users password before being encrypted to make password hacking more difficult.

The starting group is set to whatever the forum admin sets the strating group to in the admin area.
]]> Mon, 27 Mar 2006 12:22:15 +0000 https://forums.webwiz.net/importing-users-into-tblauthor_topic18969_post102488.html#102488 <![CDATA[Importing users into tblAuthor : Hey all... Nearing completion...]]> https://forums.webwiz.net/importing-users-into-tblauthor_topic18969_post102431.html#102431 Author: Ravage
Subject: 18969
Posted: 27 March 2006 at 1:01am

Hey all...
 
Nearing completion on this yahoo egroups to web wiz import... emails sorted and stuff, but the last job is to import the user accounts (hopefully)
 
Is there documentation around for the schemas? If i import into the table I'm not going to have a couple of fields that I dont know the format, specifically user_code and salt. These obviously look unique, but anyone have a suggestion how i could mimic the data in SQL Server, or hell, the datas in a spreadsheet at the moment! Would it work if I just put a serial number in it for instance?
 
I take it that Group_id is '4' for a normal newbie user account tooand ties up with tblgroup yur?
 
Thanks for the help in advance!
Rav


Edited by Ravage - 27 March 2006 at 1:02am]]> Mon, 27 Mar 2006 01:01:01 +0000 https://forums.webwiz.net/importing-users-into-tblauthor_topic18969_post102431.html#102431