[stoppy]

Originally Posted by Eikinskjaldi

vbulletin uses datamanager classes for manipulating complex objects (such as users, threads, forums) in the database. They can be found in the includes directory, with names like class_dm_user.php.

If you look inside this file you will see how VB adds users, and even if you are bypassing the vb login page you could still use the vb system for user addition.

I will take a look.

Right now I wrote a code that could solve the problem.

I will post, we can talk about it if you want.



--------------- Added [DATE]1196031048[/DATE] at [TIME]1196031048[/TIME] ---------------

I wrote this. I looked the database trying to add a testuser and seeing what appens inside...

What do you think about?

PHP Code:

<?php

/* Here there is a code I wrote for test and to discuss with you*/

$usergroupid = 2;
$username = *USERNAME*;
$password = *PASSWORD* //md5(md5(inputpassword).*SALTCODE*)
$passworddate = YYYY-MM-DD; //of today
$email= *EMAIL*;
$usertitle = *"Junior Member"*;
$joindate = $lastvisit = $lastactivity = time();
$timezoneoffset = 1; //CET +1
$options = 159; // what is it??? I copyed it from my user regular registered by vb
$languageid = 2; //for me is Italian
$autosubscribe = 1; // I want it, -1 value to disable.
$salt = *SALTCODE*;

$location = *MYLOCATION*;

$tabprefix = "vb_";

//BEGIN

$query_insert_user="INSERT INTO `".$tabprefix."user` (`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `importuserid`) VALUES (NULL, '2', '', '0', '$username', '$password', '$passworddate', '$email', '0', '', '', '', '', '', '', '', '1', '2', '$usertitle', '0', '$joindate', '0', '$lastvisit', '$lastactivity', '0', '0', '0', '10', '5', '1', '1', '0', '0', '0', '0', '$option', '', '0000-00-00', '-1', '-1', '', '0', '$languageid', '0', '0', '$autosubscribe', '0', '0', '$salt', '0', '0', '0', '', '0', '0', '0')";

mysql_query($query_insert_user);

$lastid=mysql_insert_id();

$query_insert_user_field = "INSERT INTO `".$tabprefix."user_field` VALUES ('$lastid','NULL','$location','','')";

mysql_query($query_insert_user_field);

$query_insert_user_textfield = "INSERT INTO `".$tabprefix."user_textfield` VALUES('$lastid','NULL','NULL','NULL','NULL','','NULL','NULL')";

mysql_query($query_insert_user_textfield);

//END

?>

:up::down:???

--------------- Added [DATE]1196031963[/DATE] at [TIME]1196031963[/TIME] ---------------

Originally Posted by Opserty

Add new Users (automatically)

For an exact SQL you'll probably have to look through the User Datamanger

Sorry I had not seen the link you gave me!!!