Inserting registered users directly in mysql

[BernardoCR]

Hello,

I'm the owner of a IRC Network and I'm trying to "integrate" joomla with IRC Services. I use Services to provide user and channels registration with mysql database and I willing to make the following:

Every user that register a nickname on the IRC Network automatically have their nicknames registered as a user in my website. That can be done inserting some information directly on the joomla mysql database.

The problem is that before programming the IRC Services I tried to test to see if I could do that on the mysql and joomla recognize that as a user. Here is the answer:

Some functions on joomla accepted the new information as a user. For example, community builder showed on "Last registered user:" the one I inserted, but on the Users administration and I tried to Login with username and password on the site and it showed as Non-existant user. I also tried to go on "Forgot password" and typed my login and e-mail. It showed me "User information have been sent to your e-mail addess" but no e-mail was received.

Can someone try to help me with that? I want to know in wich tables of the mysql database I have to insert record, so the user can be totally recognized by Joomla.

Thanks,

Bernardo

[RussW]

Search for "aro" and "user tables" this will yield many results for similar if not the same transaction you are trying to acheive. It is most likely that you are not updating all the required tables.

I beleive these are the related tables;

  -  http://forum.joomla.org/index.php/topic,239162.0.html

[BernardoCR]

Thanks,

I'll try that.

[ianmac]

Another thing to try is to get Joomla! to pull the information from the IRC server.  You can do this with Joomla! 1.5 by using a User plugin.

Ian

[BernardoCR]

Yes, I though about that but I'm afraid of someone trying to phpinject codes into the IRC Servers and try to get passwords and stuff like that.

[BernardoCR]

By the way, I read the post RussW showed and it works!

I had to put information on the following tables:

jos_comprofile
jos_users
jos_core_acl_aro
jos_core_acl_groups_aro_map

[RussW]

Pleased to hear that, excellent news, good luck with your site....

If you are happy that the post is now resolved, could I ask if you could now go back to your FIRST post and update it to SOLVED in the Message Icon drop down box to allow other users to quickly find resolved issues. Thank you.