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

modified(required file with cbhashpassword() was missing):
[code:1]
function registerUser( $fname, $lname, $email, $username, $password, $plan_id ) {
global $_CB_framework, $_CB_database;
jimport('joomla.user.helper');
$salt = JUserHelper::genRandomPassword(32);
$crypt = JUserHelper::getCryptedPassword($password, $salt);
$password = $crypt.':'.$salt;


$row = new moscomprofilerUser( $_CB_database );
$row->usertype = $_CB_framework->getCfg( 'new_usertype' );
$row->gid = $_CB_framework->acl->get_group_id( $row->usertype, 'ARO' );
$row->confirmed = 1;
$row->approved = 1;
$row->block = 0;
$row->sendEmail = 0;
$row->registerDate = date( 'Y-m-d H:i:«»s', $_CB_framework->now() );
$row->first_name = $fname;
$row->last_name = $lname;
$row->username = $username;
$row->email = $email;
$row->password = $password;

if ( ! $row->store() ) {
trigger_error( 'Add User SQL error: ' . $row->getError(), E_USER_ERROR );
}
}
[/code:1]

returns the following error msg:
Fatal error: Add User SQL error: Please enter your name

Am I missing something obvious?

Post edited by: Schweppesale, at: 2009/11/10 20:14

Had to rename the following two lines:
[code:1]
$row->firstname = $fname;
$row->lastname = $lname;
[/code:1]

looks like it's working though, thanks man.

One last step, I need to be able to subscribe these users to a specific plan id within CBSubs.

Is this type of functionality provided within the API?

Post edited by: Schweppesale, at: 2009/11/10 20:59