adding users with mysql

Discussion and education for beginner / novice programmers interested in embarking on the development process to take advantage of the extensible nature of the Joomla! CMS.

Moderators: tjay, seadap, Rogue4ngel, matthewhayashida

Forum rules
Post Reply
Danielite
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Wed Sep 26, 2007 8:41 am

adding users with mysql

Post by Danielite » Fri Oct 05, 2007 10:18 am

I have a problem, i need to be able to add users to the joomla mysql database, without the sign up component in joomla, so i made a php script to do it, and it works fine, the user is added to the mysql database, in jos_users.
but i cant see them in the admin panel?

User avatar
RussW
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 173
Joined: Sun Oct 22, 2006 4:42 am
Location: Melbourne, Australia
Contact:

Re: adding users with mysql

Post by RussW » Fri Oct 05, 2007 10:34 am

You also need to update all of the following tables for users to be properly registered;

jos_users
jos_core_acl_aro
jos_core_acl_groups_aro_map

There are several threads in the forums describing the relationships and I do seem to remember quite some time ago a script being supllied by someone to assist.
Checkout the Joomla! Administrators Security Checklist in the Security Forum...
Installation or Configuration Problems? Joomla! Tools Suite? viewtopic.php?t=136328l

Danielite
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Wed Sep 26, 2007 8:41 am

Re: adding users with mysql

Post by Danielite » Fri Oct 05, 2007 1:31 pm

o okay:) thanks


Post Reply