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

av Alejandro Berrocal -
Antall svar: 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
Gjennomsnittlig vurdering: -
Som svar til Alejandro Berrocal

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

av Tim Hunt -
Bilde av Core developers Bilde av Documentation writers Bilde av Particularly helpful Moodlers Bilde av Peer reviewers Bilde av 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.
Gjennomsnittlig vurdering: -
Som svar til Alejandro Berrocal

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

av Peter Lai -
Is there a reason why you cannot use the API to load your data from XML?
Gjennomsnittlig vurdering: -
Som svar til Alejandro Berrocal

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

av 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
Gjennomsnittlig vurdering: -