[nnjj.net]

Hi,


I want to add big bulk of users into the VB Forum. I've tried to add one using this query:

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')

The user is added successfully, and I logged in using the new created User ID with no password. The issue is that the User ID is not working correctly.

Kindly provide me with the steps that I can add new users using SQL statements, either in the database directly or from a PHP script.

Thanks & Regards,