where's location row in the db?

[Naytheet]

Hello, Can anyone tell me if geographic location is in the members table? I can't see it and I wonder how it can find it, because it is showed in the profile view.

[Diego Andrés]

Do you mean location? That's a custom field and it would be stored in the custom_fields table.

[Naytheet]

Ok but where are stored the values of the locations?

[Diego Andrés]

I believe it's the smf_themes table.

[Kindred]

Let's ask the important question....

WHY are you looking for the information? WHAT are you looking to accomplish?
Once you tell us that, we can give you better instructions on what to do and how.

[Naytheet]

I'm moving members data from a forum to another, the source forum is quite old and not SMF.

[Kindred]

What is the old forum system?

It becomes complicated, Because those fields are only created when a user enters data.   The blank fields do not exisr

[Naytheet]

it's a forum made through a course, without any PHP guider like SMF. I searched some entered value in the files locally with the GREP instr and didn't find anything lol.

[Kindred]

Right,  nothing is stored in files.

The extended profile information is stored as individual rows in the smf_themes table in the database. 
The exact value set will be different based on what theme you are using as well as what the field is...

[Naytheet]

You mean the user has to enter his location in each theme? I haven't looked into this table yet.

[Diego Andrés]

No, it uses theme_id = 1 when it stores the custom_field.
Check the function makeCustomFieldChanges

[Naytheet]

Ok I could find it there indeed, thank you so much everyone for clear and concise explanations and guidance.