Inserting a User into VB no longer working

[candeos]

Hello

I have an application that when you insert a user into it, it automatically used to insert that user into the vBulletin user table

When we updated to 3.0 , it stopped working. Here is the old code

$iUs = mysql_insert_id($objConn);
$time = time();
$md5Pass = md5($txtPassword);
$sSql = "INSERT INTO user (username, password, email, referrerid, nosessionhash, styleid, ";
$sSql .= "adminemail, cookieuser, daysprune, emailnotification, usertitle, joindate, usergroupid)";
$sSql .=" VALUES ('$txtUsername', '$md5Pass', '$txtUsername', '$iCusID', 1, 1, 1, 1, -1, 1, ";
$sSql .= "'Captain','$time', '$groupid')";

I know that the password changed to using salt. What changes do I need to make to get this to work?

Thanks

Dave

[Opserty]

You should not edit the database directly.

See this: Add new Users (automatically) (https://vborg.vbsupport.ru/showthread.php?t=82836)

[candeos]

Thanks...I'll pass this on.
Dave