Please Log in to join the conversation.
INSERT INTO `#__users` ( `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params` ) VALUES ( '[name]', '[username]', '[email]', '[cb:userdata field="password" /]', '[usertype]', 0, 0, [gid], '[registerDate]', '[lastvisitDate]', '', '\n' );
INSERT INTO `#__core_acl_aro` ( `section_value`, `value`, `order_value`, `name`, `hidden` ) VALUES ( 'users', ( SELECT `id` FROM `#__users` WHERE `username` = '[username]' ), 0, '[name]', 0 );
INSERT INTO `#__core_acl_groups_aro_map` ( `group_id`, `section_value`, `aro_id` ) VALUES ( [gid], '', ( SELECT `id` FROM `#__core_acl_aro` WHERE `value` = ( SELECT `id` FROM `#__users` WHERE `username` = '[username]' ) ) );
Please Log in to join the conversation.