How to add user into the VB Forum using SQL Statement?

[miz]

ok i tested it and its works hmm nnjj.net here is your answer :


after

Insert Into vbdatabase.user
(usergroupid, membergroupids, displaygroupid, username, password, passworddate,
email, styleid, parentemail, homepage, icq, aim, yahoo, showvbcode, usertitle,
customtitle, joindate, daysprune, lastvisit, lastactivity, lastpost, posts, reputation,
reputationlevelid, timezoneoffset, pmpopup, avatarid, avatarrevision, options,
birthday, birthday_search, maxposts, startofweek, ipaddress, referrerid, languageid,
msn, emailstamp, threadedmode, autosubscribe, pmtotal, pmunread, salt) values
(3, '', 0, 'bukharia', '', '2004-09-12',
'bukhari00@yahoo.com', 1, '', '', '', '', '', 1,
'Junior Member', 0, 1094990400, 0, 1094996400,
1094996400, 0, 0, 10, 5, 3, 0, 0, 0, 7255, '',
'0000-00-00', -0, 1, '', 0, 0, '', 0, 0, -1, 0, 0, '<%Z')

add :

$newuserid = $DB_site->insert_id();

$DB_site->query("INSERT INTO " . TABLE_PREFIX . "usertextfield (userid)VALUES ('$newuserid') ");
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "userfield (userid)VALUES ('$newuserid') ");



and its should work (working for me)

btw how the salt system working ? do you know colin ?

im doing same thing only from other php page
so i need to answer correct password
and im sure its not md5(password);

any idea ?