Passing Listing ID to notification emails

[abkeller]

I have modified our 68 Classifieds installation so that notification emails get sent to the user after posting an ad, instead of to the admin. I commented out the admin link so the user only gets the first link to view their listing detail page.

What I'd also like to pass in the email is the listing id, sort of like this;

Your listing has successfully been added to GunMountain.com.

Here are the details of your new listing;
Listing ID#: ##listingid##
Title: Sample Ad Title
Price: $0.00

Click to view your ad:
http://www.mydomain.com/classifieds/...g.php?view=427

How can I get the listing ID passed to the email? It's already at the end of the URL string, it should be really simple to call it out separately. What do I add to the functions.php file that formats the notification email to make this happen?

Thanks!

[abkeller]

Figured this one out myself, as well. Insert the following lines of code (in red) into the functions.php file;

$result=$db->query($sSQL);
$rs=$result->fetch();
$subject=$rs['eSubject'];
$htmlContent=$rs['eHTML'];
$sSQL="SELECT title,price FROM ".PREFIX."products WHERE id=".$orderid;
$result=$db->query($sSQL);
$rs=$result->fetch();
$emailmessage.= $htmlContent.'<br>'. LANG_TITLE.": ".safeStripSlashes($rs['title'])."<br>\n";
$emailmessage.= LANG_PRICE .": ".FormatCurrency($rs['price'])."<br>\n";
$emailmessage.= "Listing ID: ".$orderid."<br>\n";
$emailmessage.= "Click to view your ad: <br>\n";
$emailmessage.= "<a href='".URL."/viewlisting.php?view=".$orderid."'>".URL."/viewlisting.php?view=".$orderid."</a><br>\n";
//$emailmessage.= "<a href='".URL."/administration/listinginfo.php?view=".trim($orderid)."'>".URL."/administration/listinginfo.php?view=".trim($orderid)."</a>";

[Mike-N-Tosh]

abkeller,

Thanks for posting that code. I never understood why the new listing email went to the admin and not the seller to begin with. I always thought it would be a much better solution to have that as an admin setting that you could choose who gets the notification.

Where and how did you change the code to send the mail to the seller instead? I would like to do that and BCC: the admin.

Thanks,
Mike

[abkeller]

To change the email from admin to the user for MODIFYING a listing open modifylisting.php and insert the code below


$sSQL="SELECT eID, eName, eSubject, eHTML, eText FROM ".PREFIX."email_templates WHERE eID=7";
$result=$db->query($sSQL);
$rs=$result->fetch();
$subject=$rs['eSubject'];
$htmlContent=$rs['eHTML'];
$textContent=$rs['eText'];
$sSQL="SELECT title,price FROM ".PREFIX."products WHERE id=".$productid;
$result=$db->query($sSQL);
$rs=$result->fetch();
$emailmessage.= $htmlContent.'<br>'. LANG_TITLE.": ".safeStripSlashes($rs['title'])."<br>\n";
$emailmessage.= LANG_PRICE .": ".FormatCurrency($rs['price'])."<br>\n";
$emailmessage.= "<a href='".URL."/viewlisting.php?view=".$productid."'>".URL."/viewlisting.php?view=".$productid."</a><br>\n";


//my inserted code
$sSQL="SELECT email FROM ".PREFIX."users WHERE id=".$userid;
$result=$db->query($sSQL);
$rs=$result->fetch();
$email=$rs['email'];


// Instantiate mail class
$mail = new Mailer();
$mail->AddAddress ($email);
$mail->Subject = $subject;
$mail->Body = $emailmessage;
$mail->AltBody = strip_tags($emailmessage);

To change the email notification for new listing open functions.php (in your includes folders) and do the following:

By commenting out the second line of code for the admin link we can remove the embedded URL that goes to the admin link, which users don't need to see;

//should we email?
if($notification=="Y")
{
$sSQL="SELECT eID, eName, eSubject, eHTML, eText FROM ".PREFIX."email_templates WHERE eID=6";
$result=$db->query($sSQL);
$rs=$result->fetch();
$subject=$rs['eSubject'];
$htmlContent=$rs['eHTML'];

$sSQL="SELECT title,price FROM ".PREFIX."products WHERE id=".$orderid;
$result=$db->query($sSQL);
$rs=$result->fetch();
$emailmessage.= $htmlContent.'<br>'. LANG_TITLE.": ".safeStripSlashes($rs['title'])."<br>\n";
$emailmessage.= LANG_PRICE .": ".FormatCurrency($rs['price'])."<br>\n";
$emailmessage.= "Listing ID: ".$orderid."<br>\n";
$emailmessage.= "Click to view your ad: <br>\n";
$emailmessage.= "<a href='".URL."/viewlisting.php?view=".$orderid."'>".URL."/viewlisting.php?view=".$orderid."</a><br>\n";
// Commented out
//$emailmessage.= "<a href='".URL."/administration/listinginfo.php?view=".trim($orderid)."'>".URL."/administration/listinginfo.php?view=".trim($orderid)."</a>";

Then, change the sendmail script to call the user ID and associated email from the dB and use it to populate the "To" field of the email;

$mail = new Mailer();
$mail->Subject = $subject;
$mail->Body = $emailmessage;
$mail->AltBody = strip_tags($emailmessage);

// Comment out the call to ADMIN_EMAIL
// $mail->AddAddress($Core->settings['email']);


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

$mail->AddAddress("$xemail");
if(!$mail->Send())

Now this sends an email to the user each time an ad is completed.

Unfortunately, I'm still trying to get someone to get back to me on why the email notify is NOT working whenever a registered user uses part of his membership package to post an ad. In this case, an email is not automatically being sent to either the admin or the user. I've looked at the code (until I was cross-eyed) and I don't see anything during the checkout process for members that sends an email after an ad is completed.

I'll keep trying - maybe someone will respond!

[CHRD]

I always like to validate the new listings before making them live, cos most of them need editing, so I think this hack might just make more dumb ass emails to support, asking where is my advert.

But it would be great to make the system send the email out when its been validated by admin.

Iv put "It can take upto 2-3 days to validate your listing" in the checkout 6 step

[abkeller]

With ads automatically posting to the site after creation you don't have the option, as the admin, to edit or screen out the ads that shouldn't be posted.

If you have opted to manually approve all incoming ads this hack won't work for automatically sending an email to the user after the ad has been approved by the admin.

I've seen several people ask for that option on other threads, but I don't have a solution for that here.

[Mike-N-Tosh]

Elizabeth,

Thanks for posting that code. That is very helpful and will resolve complaints that I've been getting about not getting a notification about the new ad listings and modifications.

-Mike