I run version 2.6 of Photopost classifieds integrated with my Threads7. However, one issue I found is that they pull user info from the threads USER field. So, when someone clicks on Contact Seller on an ad, it pulls USER_REGISTRATION_EMAIL from the USER Table. This is fine as long as the person NEVER changes their email address after they register on your forum. SOLUTION: Until the folks at Photopost fix this, here is what you can do.

1. In the file Threads7.php (in the forums directory in your photopost classifieds install) Look for the function:

function get_userinfo( $authuser, $userid=0 )

Then find this query:

if ( $userid != 0 ) $query = "SELECT u.USER_ID,u.USER_DISPLAY_NAME,u.USER_REGISTRATION_EMAIL,u.USER_PASSWORD, u.USER_SESSION_ID,u.USER_LOGIN_NAME,p.USER_STYLE,p.USER_TIME_OFFSET,p.USER_TEMPORARY_PASSWORD
FROM {$Globals['dprefix']}USERS u LEFT JOIN {$Globals['dprefix']}USER_PROFILE p ON p.USER_ID=u.USER_ID
WHERE u.USER_ID=$userid";


Change u.USER_REGISTRATION_EMAIL to p.USER_REAL_EMAIL


Then also, find this query:

else {
$tuser = addslashes( $authuser );
$query = "SELECT u.USER_ID,u.USER_DISPLAY_NAME,u.USER_REGISTRATION_EMAIL,u.USER_PASSWORD,
u.USER_SESSION_ID,u.USER_LOGIN_NAME,p.USER_STYLE,p.USER_TIME_OFFSET,p.USER_TEMPORARY_PASSWORD FROM {$Globals['dprefix']}USERS u
LEFT JOIN {$Globals['dprefix']}USER_PROFILE p ON p.USER_ID=u.USER_ID
WHERE u.USER_LOGIN_NAME='$tuser'";
}

Again, change u.USER_REGISTRATION_EMAIL to p.USER_REAL_EMAIL

One last thing. Just below these queries, find:

$queryv = ppmysql_query($query,$db_link);
$results = mysql_fetch_array($queryv);

$username[0] = $results['USER_ID']; // userid
$username[1] = $results['USER_DISPLAY_NAME']; // username
$username[2] = $results['USER_REGISTRATION_EMAIL']; // set email

set $usernam[2] = $results['USER_REAL_EMAIL'];

That's it. Now, when a member clicks the Contact Seller link in an ad, two things will happen: First, their "real" email address will fill into the "From field" and then when they send their email it will go to the seller's current "REAL" email address and not the email they registered with (in case thay have changed it)

Hope you find this useful,

Basil

Lol that's just great.. thanks for the fix though

My pleasure. I had asked about it on the PP forum, but I never got a good answer. I kept getting bounced emails from people trying to "contact seller" for members who had changed their email address. Luckily it was an easy fix.