Zikula Community

I am so stumped and need some help please. I added a couple of fields to the Dynamic User Data on my site - fields: _FIRSTNAME & _LASTNAME.

I then went to mySQL database viewing it with phpMyAdmin. I noticed that the two fields I created in DUD didn't create in mySQL. So I added the fields pn_FIRSTNAME and pn_LASTNAME within mySQL.

After that, I imported my users with a csv file via phpMyAdmin to the mySQL database. Back at my site, I viewed a user's account. All the fields populated fine except for _FIRSTNAME and _LASTNAME.

I have to have these two fields populated by this weekend (it will be viewed by the new registered users by Monday), but I don't how to do it. The firstname & lastname fields in mySQL are populated with the correct data but how can I get that data into my site under the user's account?

If anyone can help me, I really appreciate it. Right now, I'm afraid I may have to log in to each user's account, click on "My Account" and populate the firstname & lastname fields one by one. I have over 250 users!

Thanks,
Sue

Ok, I figured out that when I added the new fields in DUD that it's not linking to the database. I added a couple of test users then viewed my database and the firstname & lastname fields are not being populated in mySQL. Does anyone know where these values are being stored?

When I added the fields, all it said was to define the fields in language/eng/global.php, which I did. But there must be another file that needs to modified to get the fields into the database.

I found the file admin.php in modules/User that appears to be the place to add the fields, but I'm a little nervous hacking that file since I know nothing about PHP.

Has anyone added fields to the dynamic user data and successfully got the fields to connect to the database?