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

von Alejandro Berrocal -
Anzahl Antworten: 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
Als Antwort auf Alejandro Berrocal

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

von Tim Hunt -
Nutzerbild von Core developers Nutzerbild von Documentation writers Nutzerbild von Particularly helpful Moodlers Nutzerbild von Peer reviewers Nutzerbild von 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.
Als Antwort auf Alejandro Berrocal

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

von Peter Lai -
Is there a reason why you cannot use the API to load your data from XML?
Als Antwort auf Alejandro Berrocal

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

von 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