How to change email field?

[Basil]

Chuck, as you know, the pp-clasified pulls the email from USER_REGISTRATION_EMAIL in the USER table in Threads7, which is great as long as the member never changes their email. However, I am having tons of undeliveralbe emails being sent back (like when someone uses "Contact Seller" or I approve an ad and the notification gets sent).

I have been running my forum for 6 years and have many users who have changed email addresses since they registered, often years ago. Is there a way for me to alter something so that the pp-classified will pull the email address from "USER_REAL_EMAIL" field in the ubbt_USER_PROFILE table instead? Right now my workaround is to go into the USER_REGISTRATION_EMAIL field when I see the problem and change the persons email there to the current "USER_REAL_EMAIL" value. This is really a bit of a pain. Can I do anything in the scripts to alleviate this issue?

Many thanks for a great product and Happy New Year,

Basil

[Chuck S]

Edit your threads7.php file and replace the field in the get_userinfo query up top of that file.

[Basil]

Hmm, but that is pulling info from the "USER" table, and the USER_REAL_EMAIL is from the USER_PROFILE table. So wouldn't just changing the field break the query since the needed field is oin a different table?

[Chuck S]

Which is probally why I coded it the way I did and did not see any other email field