Which tables change and how when I add a new user, course, category

Which tables change and how when I add a new user, course, category

Alejandro Berrocal -
Number of replies: 3
Hello everybody
I'm new in moodle, I found this program very useful and interesting for making other programs

Well I want to develop a small program which load a xml file(which contain the data) and automatically load all the data from the file and insert the data in the database
I've been trying to understand how exactly moodle works, I want to know what happen when I add a new user, a new course, a new category. I want to know wich tables change and how they change when I add a user, course, category

Coud you help me?

thanks for your answers
Ngā whakawākanga toharite: -
In reply to Alejandro Berrocal

Re: Which tables change and how when I add a new user, course, category

Tim Hunt -
Pikitia o Core developers Pikitia o Documentation writers Pikitia o Particularly helpful Moodlers Pikitia o Peer reviewers Pikitia o Plugin developers
Turn on logging of every query in your database, then perform those actions in the Moodle UI and watch what happens.

Either that, or read the code carefully.

Also look at the upload users script in the admin screens.
Ngā whakawākanga toharite: -
In reply to Alejandro Berrocal

Re: Which tables change and how when I add a new user, course, category

Peter Lai -
Is there a reason why you cannot use the API to load your data from XML?
Ngā whakawākanga toharite: -
In reply to Alejandro Berrocal

Re: Which tables change and how when I add a new user, course, category

Alejandro Berrocal -
Well I want to know exactly which tables modify because I want my program can read xls files too, no just xml

thanks
Ngā whakawākanga toharite: -