Joomla Users Table,How to create joomla user by using other component/table,How many tables are related with users?

How to make a new user registration form for other component?

Note :
- The users.id means “id” filed of “users” table

There are 3 tables are realted with each other when creating a new user are :
1.  jos_users
2.  jos_core_acl_aro
3.  jos_core_acl_groups_aro_map

The relation between each tables and when creating a new user then insert some values in following tables:
1. insert into jos_users
-fields are :   id( = autoincrement field), username, name, email, password, gid (18=registered user)
-these are compulsory fields to fillup.
2.  insert into jos_core_acl_aro
-fields are :   aro_id ( = autoincrement field), section_value(=”users” string), value(=jos_users.id), name=(=jos_users.name)
3.  insert into jos_core_acl_groups_aro_map
-fields are :   group_id ( =jos_users.gid), aro_id( =jos_core_acl_aro.aro_id)

If you want your own component for registation then make a table like this:
4.  insert into your_table.
-fields are :   id ( = autoincrement field), user_id ( =jos_users.id), other fields ( =username,name,email,password are stored in users table , so no need to add here)

This information will helpfull for developer to create and make their own component for registration and login.
If possible then don’t modify any joommla core file.

if you want the login form is in your  page/component/module  then you can copy the conent from mod_login page and modify it in your page and make this type of queries :
- select from users and your_table where your_table.user_id=users.id (=joomla.php->login())

if we have new registration page then see the com_registration folder and files.

2 Responses to “Joomla Users Table,How to create joomla user by using other component/table,How many tables are related with users?”

  1. Mario Garcia Says:

    Hi.

    Excellent Job.

    :D

    Mario Garcia

  2. Rafael Castillo Says:

    Thanks a lot. This information was really helpful to me.

Leave a Reply