I'm trying to find the table or location of data that the /moodle/user/editadvanced.php?id=-1 page is using to find the Country and Timezone data which is then stored in mdl_user.
It's not mdl_timezone table - (I know you can update it, but if it's empty to begin with, where is Moodle getting the data in the first place?)
Basically I'm using SQL to enter users from my site via coding automatically and then Enrol them into various courses based on their information. Problem is that they are global users and the Timezone and Country codes in mdl_user are Not Null fields, and I want to get them right by presenting them to the user in the first place in the same way the page above does.
Can anyone help please?