i figured out what was the error.  I was selecting an extra space character from the displayed table. Glad i found that stupid mistake, 'cos i was going nuts.

Thanks again borg. If anyone wants a script to merge their existing user DB to a WWForum DB, PM me and ill send you exacly what to do.

hi Borg:

i'm desperate with this problem because all my site development is stalled because of this. Can you give me any hint?

Thanks in advance

ok i created a code to convert my existing DB to new format like wwforum.mdb

here it is.

wrote: <% @ Language=VBScript %> <!--#include file="common.asp" --> <!--#include file="functions/functions_hash1way.asp" --> <!--#include file="functions/functions_filters.asp" --> <% strDatabaseDateFunction = "Now()" Set adoCon = Server.CreateObject("ADODB.Connection") strDbPathAndName = Server.MapPath("admin/database/login.mdb") strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDbPathAndName adoCon.connectionstring = strCon adoCon.Open query = "SELECT TOP 10 * FROM tblAuthor" Set rsLogin = Server.CreateObject("ADODB.Recordset") rsLogin.CursorType = 0 rsLogin.CursorLocation = 2 rsLogin.LockType = 1 rsLogin.Open query, adoCon %> <% '****************************************** '***    Create Usercode       ***** '****************************************** Private Function userCode(ByVal strUsername)  'Randomise the system timer  Randomize Timer  'Calculate a code for the user  strUserCode = strUsername & hexValue(15)  'Make the usercode SQL safe  strUserCode = formatSQLInput(strUserCode)  'Replace double quote with single in this intance  strUserCode = Replace(strUserCode, "''", "'", 1, -1, 1)  'Return the function  userCode = strUserCode End Function %> <style type="text/css"> <!-- .style8 {font-family: Arial, Helvetica, sans-serif; font-weight: bold; font-size: 10px; } .style10 {font-family: Arial, Helvetica, sans-serif; font-size: 10px; } --> </style> <table border=1 width=50%> <tr align="center">  <td>    <span class="style8">Username    </span></td>  <td>    <span class="style8">Usercode    </span></td>  <td>    <span class="style8">Password    </span></td>  <td>    <span class="style8">prev. Password    </span>  </td>  <td>    <span class="style8">Salt    </span></td> </tr> <% while not rsLogin.eof %> <% Dim strUsername Dim strPassword Dim strSalt strUsername = rsLogin("Username") strPassword = rsLogin("Password") 'strSalt = rsLogin("Salt")  '******************************************  '***       Create a usercode   ***  '******************************************   'Calculate a code for the user   strUserCode = userCode(strUsername)  '******************************************  '***   Encrypt password ***  '******************************************   strSalt = getSalt(Len(strPassword))   'Concatenate salt value to the password   strEncryptedPassword = strPassword & strSalt   'Encrypt the password   strEncryptedPassword = HashEncode(strEncryptedPassword)  '******************************************  '***       Create usercode cookie ***  '******************************************           'Write the cookie with the name Forum containing the value UserID number   Response.Cookies(strCookieName)("UID") = strUserCode    'Set the expiry date for 1 year (365 days)   'If no expiry date is set the cookie is deleted from the users system 20 minutes after they leave the forum   Response.Cookies(strCookieName).Expires = Now() + 365 %> <tr>  <td>    <span class="style10"><%= rsLogin("Username")%>    </span></td>  <td>    <span class="style10"><%= strUserCode %>    </span></td>  <td>    <span class="style10"><%= strEncryptedPassword %>    </span></td>  <td>    <span class="style8"><%= rsLogin("Password")%>    </span>  </td>  <td>    <span class="style10"><%= strSalt %>    </span></td> </tr> <% rsLogin.movenext wend%> </table> <%   rsLogin.Close   Set rsLogin = Nothing   adoCon.Close   Set adoCon = Nothing %>

The result is:

Username	Usercode	Password	prev. Password	Salt
llima	llimaE2Z21CA43BDB442	72780F0C4EECE6B3CDCC586A2205096B90FDADE7	llima	AFE38
palmeida	palmeidaZZ6E434C16DA1C9	14EB10BA6A949DC82FE36C6DBFE5531DBA9B9C27	2799	899C
nsousa	nsousa7EZ9CAF5893Z9A7	818F23F25051974CE0DE563127C4B8767EBB2732	nsousa	AE4A30
nlopes	nlopesE8DFBF3BBZ4B5C4	E78A0470CF3C1445BD24578B95BAA56ABF658119	nlopes	F3AF23
olivcapt	olivcapt2126DD79FZEE168	1FAEE817E]]> Mon, 16 Aug 2004 13:36:11 +0000 https://forums.webwiz.net/salt-description_topic11336_post63824.html#63824 https://forums.webwiz.net/salt-description_topic11336_post62682.html#62682 Author: Phat Subject: 11336 Posted: 29 July 2004 at 9:22pm Make you do Lcase(password) as well. I got caught by not doing this before encrypting.]]> Thu, 29 Jul 2004 21:22:29 +0000 https://forums.webwiz.net/salt-description_topic11336_post62682.html#62682 https://forums.webwiz.net/salt-description_topic11336_post62676.html#62676 Author: WebWiz-Bruce Subject: 11336 Posted: 29 July 2004 at 6:55pm The username field can be copied straight over. The user code field can be any unique value you want. (something not easy to guess would be best) The salt and encrypted passwords are done by functions in the file function/function_hash1way.asp Call the function getSalt(7), '7' being the length of the generated salt value. Store the salt value in the database. Then place the salt value on the end of the password and using theHashEncode() pass it your password with the salt value added to getyour encrypted password. ]]> Thu, 29 Jul 2004 18:55:25 +0000 https://forums.webwiz.net/salt-description_topic11336_post62676.html#62676 https://forums.webwiz.net/salt-description_topic11336_post62664.html#62664 Author: cbr600 Subject: 11336 Posted: 29 July 2004 at 2:48pm i know. What i want to do is create a .asp that reads all records from my old DB and converts them to be like tblAuthor. I showed you my tblLOGIN table, so what i need is what would that page be like? 1 - open Old database 2 - for each record, use a code to get U_PASSWORD and  U_NAME and convert it to Password, User_Code, and Salt, (can be displayed on monitor or can be directly replaced on the old DB) so that it can be compatible with the forum DB.   ]]> Thu, 29 Jul 2004 14:48:38 +0000 https://forums.webwiz.net/salt-description_topic11336_post62664.html#62664 https://forums.webwiz.net/salt-description_topic11336_post62640.html#62640 Author: WebWiz-Bruce Subject: 11336 Posted: 29 July 2004 at 1:21pm Not sure what you mean , but the register.asp page handles theregistration of new users and creates the salt value, encrypts thepassword, and creates the user code for the user.]]> Thu, 29 Jul 2004 13:21:02 +0000 https://forums.webwiz.net/salt-description_topic11336_post62640.html#62640 https://forums.webwiz.net/salt-description_topic11336_post62635.html#62635 Author: cbr600 Subject: 11336 Posted: 29 July 2004 at 12:56pm My question is, if i wanted to create a page that receives the inputed (from a form) username and passord, and displays me the SALT, Username, Usercode, and Password, How would i do that? Using of course the same method as the webwiz forum does. Simply tell me: get this code from line x to y from file this.asp and include file that.asp, etc it would be a lot easier for me. Thanks in advance. ]]> Thu, 29 Jul 2004 12:56:40 +0000 https://forums.webwiz.net/salt-description_topic11336_post62635.html#62635