The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
How to add user into the VB Forum using SQL Statement?
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, |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|