User Account Pushed by Another Database (What are the tables?)

User Account Pushed by Another Database (What are the tables?)

由samudaya Nanayakkara發表於
Number of replies: 6

Dear Friends,

I have integrated Moodle with another database (MySQL) for authentication (auth=db). However I want to push the user profile from our Students Management System to Moodle. If Students Management System pushes the data, Which Tables it has to use? That mean what the Tables effected by Auto user account creation by external database based authentication?

 

Thanks and Best Regards

Samu

評比平均分數： -
In reply to samudaya Nanayakkara

Re: User Account Pushed by Another Database (What are the tables?)

由Tim Hunt發表於
Core developers的相片 Documentation writers的相片 Particularly helpful Moodlers的相片 Peer reviewers的相片 Plugin developers的相片

Most of the data is in the 'user' table. (That will normally have a prefix, and so be called mdl_user.)

Some other bits are stored as 'Custom user profile fields' which are in separate tables, but the name also begins user_ so it should be easy to work out what is going on.

評比平均分數： -
In reply to Tim Hunt

Re: User Account Pushed by Another Database (What are the tables?)

由samudaya Nanayakkara發表於

Hi Tim,

Thanks for your quick reply. When I examine the database when user account is creating, it will affect to the the following tables too;

mdl_context
mdl_user_preferences
mdl_cache_flags

What are the purpose of these tables and Do I have to push information to those tables?

 

Thanks and Best Regards

Samu

評比平均分數： -
In reply to samudaya Nanayakkara

Re: User Account Pushed by Another Database (What are the tables?)

由samudaya Nanayakkara發表於

Hi All, I am using Moodle Version is 2.5. I want to push user account from another system to my Moodle system. Is there any API for push? OR Is it enough to push the information on database level to only user (mdl_user) table?

 Thank you very much.

Samu

評比平均分數： -
In reply to samudaya Nanayakkara

Re: User Account Pushed by Another Database (What are the tables?)

由Itamar Tzadok發表於

Check out docs on authentication methods and the Authentication forum.

P.S. This forum is not related to DB issues but to an activity module that happens to be called database. Depending on the issue, other forums may be more useful for such queries.

微笑

評比平均分數： -