Adding user via PHP script causes strange problem: Name isn't clickable in threads

[steve.k]

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.

PHP Code:

            $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!