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

by 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
Average of ratings: -
In reply to Alejandro Berrocal

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

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of 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.
Average of ratings: -
In reply to Alejandro Berrocal

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

by Peter Lai -
Is there a reason why you cannot use the API to load your data from XML?
Average of ratings: -
In reply to Alejandro Berrocal

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

by 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
Average of ratings: -