Code:
$usergroupid = "1";
$reputation = "10";
$reputationlevelid = "5";
$username = ""; # Need to generate username based on clients name or email address probably
$password = ""; # Use same password as is used in WHMCS?
$signupdate = date("Y-m-d");
$joindate = mktime(date("H"),date("i"),date("s"),date("m"),date("d"),date("Y"));
INSERT INTO `vb3user` (`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`, `profilepicrevision`, `showbirthday`, `importuserid`, `skype`) VALUES ('$usergroupid', '', 0, '$username', '$password', '$signupdate', '$email', 0, '', '', '', '', '', 2, 'Junior Member', 0, '$joindate', 0, '$joindate', '$joindate', 0, 0, '$reputation', '$reputationlevelid', '0', 0, 0, 0, 343, '', '0000-00-00', -1, -1, '', 0, 0, '', 0, 0, 1, 3, 2, 'v2?', 0, 0, 0, '');