Adding more details to "Contact The Seller" Email sent to Seller

[Greg H]

Is it possible to add some more info to the email sent to seller from the buyer ?

Currently it only says this ..

The following message was sent to you by USER who has been viewing your listing at the XXXXXXXX web site.
http://www.yoursite.com.au/viewlisting.php?view=1139
Comments
testing

Is it possible to include the email address and phone number of buyer in this email ?

Cheers

[Eric Barnes]

Greg,

The only way to do this would be to alter the contact.php file. You would need to add the fields to the users query then add new lines where it says:
//format the email//

[Greg H]

Thanks for the reply..


Coud you please advise a little more on how this is done...

I think you mean add to the users query here...but im not exactly sure what to add

PHP Code:

//now get the user information

            $sSQL="SELECT email FROM ".PREFIX."users WHERE id=".$id;

            $result = $db->query($sSQL);

            $rs = $result->fetch();

            $to=$rs['email']; 


I think I have the //format the email// part sorted..

Thanks

[Eric Barnes]

You should be able to do something like this:

PHP Code:

$sSQL="SELECT email,phone FROM ".PREFIX."users WHERE id=".$id;
$result = $db->query($sSQL);
$rs = $result->fetch();
$to=$rs['email'];
$phone = $rs['phone']; 


Then this would give you the $phone variable to use later in the str_replace.

[Greg H]

Ok, this IS working (sort of) BUT its placing the Sellers email address in the "Contact The Seller" email, which is not quite what I was trying to achieve. The seller already knows his own phone number! Its the buyers phone number I was trying to get in there.

In contact.php I now have this..

PHP Code:

            //now get the user information

        $sSQL="SELECT email,phone FROM ".PREFIX."users WHERE id=".$id;
        $result = $db->query($sSQL);
        $rs = $result->fetch();
        $to=$rs['email'];
        $phone = $rs['phone']; 


and I also have this ...

PHP Code:

            //format the email//

            $htmlContent = str_replace("##name##", $name, $htmlContent);

            $htmlContent = str_replace("##sitetitle##", $sitetitle, $htmlContent);

            $htmlContent = str_replace("##listingurl##", $htmlsiteurl, $htmlContent);
            
            $htmlContent = str_replace("##phone##", $phone, $htmlContent);

            $htmlContent = str_replace("##comments##", $comments, $htmlContent);



            $textContent = str_replace("##name##", $name, $textContent);

            $textContent = str_replace("##sitetitle##", $sitetitle, $textContent);

            $textContent = str_replace("##listingurl##", $siteurl, $textContent);
            
            $textContent = str_replace("##phone##", $phone, $textContent);

            $textContent = str_replace("##comments##", $comments, $textContent);

                $mail = new Mailer();

                $mail->AddAddress($to);

                $mail->From = $from;

                $mail->FromName = $name;

                $mail->Subject = $subject;

                $mail->IsHTML(true);

                $mail->Body    = $htmlContent;

                $mail->AltBody = $textContent; 


And In Admin email templates. contact seller template i have this for html...

PHP Code:

The following message was sent to you by ##name## who has been viewing your listing at the  ##sitetitle## web site.<br>
##listingurl##<br>
##phone##<br>
Comments<br>
##comments## 


and this for txt..

PHP Code:

The following message was sent to you by ##name## who has been viewing your listing at the  ##sitetitle## web site.<br>
##listingurl##<br>
##phone##<br>
Comments<br>
##comments## 


Thanks

[Eric Barnes]

In that case you need to create a phone form field and replace this line:
$htmlContent = str_replace("##phone##", $phone, $htmlContent);
with:
$htmlContent = str_replace("##phone##", $_POST['phone'], $htmlContent);

[Greg H]

Thanks Eric,

Do I need to change anything here too ?

PHP Code:

            //now get the user information

$sSQL="SELECT email,phone FROM ".PREFIX."users WHERE id=".$id;
$result = $db->query($sSQL);
$rs = $result->fetch();
$to=$rs['email'];
$phone = $rs['phone']; 


I tried adding the $_POST in here but gave me errors when sending the form.

[Eric Barnes]

From my understanding you want the phone number from the person contacting your user. In that case you would have to add a new field to the contact form and then get the data they entered and add it to the template. That is why I said use $_POST['phone']