Hi, I'm working on a component which will allow Site registration for CBSub Plans via a separate Front End Component.
(Companies who purchase a site license to our content would be able to register numerous users via a separate log-in page free of charge since it's already paid for)
I've worked out the primary registration Joomla insert process(query1, query2, and query3), however I'm looking to also add these users to the "jos_comprofiler" table as well as any other required table entries. Can someone help me out with this? Thanks
[code:1]
function Insert_User($fname, $lname, $email, $username, $password, $plan_id)
{
jimport('joomla.user.helper');
$name = $fname.$lname;
$params = "";
$ip_addr = $_SERVER;
$salt = JUserHelper::genRandomPassword(32);
$crypt = JUserHelper::getCryptedPassword($password, $salt);
$password = $crypt.':'.$salt;
$date = date('Y-m-d H:i:«»s');
$query = "INSERT INTO jos_users
(name, usertype, username, email, password, registerDate, gid, sendEmail, block, params, lastvisitDate)
VALUES
('".$name."', 'Registered', '".$username."', '".$email."', '".$password."', '".$date."', '18', '0', '0', '".$params."', '".$date."')";
$query2 = "INSERT INTO jos_core_acl_aro (id, section_value, value, order_value, name, hidden)
VALUES (NULL, 'users', LAST_INSERT_ID(), '0', '".$name."', '0')";
$query3 = "INSERT INTO jos_core_acl_groups_aro_map VALUES (18, '', LAST_INSERT_ID())";
$query4 = "INSERT INTO jos_comprofiler
(id, user_id, firstname, lastname, hits, message_number_sent, avatar, avatarapproved, approved, confirmed, registeripaddr, banned)
VALUES (NULL, LAST_INSERT_ID(), '".$fname."', '".$lname."', '0', '0', NULL, '1', '1', '1', '".$ip_addr."', '0')";
$query = mysql_query($query);
$query2 = mysql_query($query2);
$query3 = mysql_query($query3);
$query4 = mysql_query($query4);
}
[/code:1]
Oh right, and $query4 is returning false for some reason. Thanks again for the assist.
Post edited by: Schweppesale, at: 2009/11/10 19:42
Post edited by: krileon, at: 2009/11/10 21:55