steve.k
02-22-2008, 12:43 PM
Hi,
I'm new to vbulletin and attempting to write a PHP script that adds a user to the vbulletin database manually. I'm using the SQL comment below to do this.
$sql = "INSERT INTO $db_tablename (userid, usergroupid, displaygroupid, username, password,
passworddate, email, styleid, showvbcode, usertitle, joindate, daysprune, lastvisit,
lastactivity, lastpost, posts, reputation, reputationlevelid, timezoneoffset, pmpopup,
avatarid, avatarrevision,
options, birthday, birthday_search, maxposts,
autosubscribe, salt)
VALUES ('', '2', '0', "
. "'" . $user_username. "', "
. "'$hashedpassword', '2008-02-21', "
. "'" . $user_email . "', "
. "'0', '1', 'Junior Member', '1187356935', '0', '1187356935',
'1187356935', '0', '0', '10', '5', '0', '1',
'0', '0',
'3143', '', '0000-00-00', '-1', '-1', '')";
I can login with users generated using this code. But, for some reason they don't have a clickable, big username in posts. See attached image for details (I uploaded it as a gif, I'm not sure why vbulletin converted it to a jpg).
Does anyone have any idea as to why this would happen? Do I have to add any other info to the database when adding a user? Or could it have to do with any of the data for the fields I used? I'll play around with it a bit more but I was curious as to if anyone has had a similiar problem.
Thanks!
I'm new to vbulletin and attempting to write a PHP script that adds a user to the vbulletin database manually. I'm using the SQL comment below to do this.
$sql = "INSERT INTO $db_tablename (userid, usergroupid, displaygroupid, username, password,
passworddate, email, styleid, showvbcode, usertitle, joindate, daysprune, lastvisit,
lastactivity, lastpost, posts, reputation, reputationlevelid, timezoneoffset, pmpopup,
avatarid, avatarrevision,
options, birthday, birthday_search, maxposts,
autosubscribe, salt)
VALUES ('', '2', '0', "
. "'" . $user_username. "', "
. "'$hashedpassword', '2008-02-21', "
. "'" . $user_email . "', "
. "'0', '1', 'Junior Member', '1187356935', '0', '1187356935',
'1187356935', '0', '0', '10', '5', '0', '1',
'0', '0',
'3143', '', '0000-00-00', '-1', '-1', '')";
I can login with users generated using this code. But, for some reason they don't have a clickable, big username in posts. See attached image for details (I uploaded it as a gif, I'm not sure why vbulletin converted it to a jpg).
Does anyone have any idea as to why this would happen? Do I have to add any other info to the database when adding a user? Or could it have to do with any of the data for the fields I used? I'll play around with it a bit more but I was curious as to if anyone has had a similiar problem.
Thanks!