list($fname, $lname) = explode(" ", $name); } else { $fname = $name; $lname = ""; } $password = encode($name, $encode_key); $db->query("INSERT INTO users (group_id,first_name,last_name,email,password,active,created) VALUES(2,'{$fname}','{$lname}','{$email}','{$password}',0,NOW())"); $new_u_id = $db->lastInsertedId(); // put message into the database $db->query("INSERT INTO messages (parent_id,listing_id,from_id,to_id,message,timestamp) VALUES(0,'{$listing_id}','{$new_u_id}','{$listing_info->id}','{$message}',NOW())"); $inquiry_id = $db->lastInsertedId(); // send activation email to new user $code = encode($email, "businessfieds"); // encrypt email to make code // set template fields $emailTemplate->SetParameter("activation_url", '<a href="http://www.businessfieds.com/activation&x=' . $code . '">http://www.businessfieds.com/activation&x=' . $code . '</a>'); $emailTemplate->SetParamter("inquirer_name", $name); $emailTemplate->SetTemplate($settings['new_user_contact_et']); $sendNewUEmail = sendMail($email, $email->Subject(), $email->CreateBody()); // send email // send message notifications to inquirer and seller $emailTemplate->SetParameter("seller_name", $listing_info->first_name . " " . $listing_info->last_name); $emailTemplate->SetParameter("listing_headline", $listing_info->headline); $emailTemplate->SetParameter("inquiry_message", $message); $emailTemplate->SetParameter("inquiry_url", '<a href="http://www.businessfieds.com/inquiries/' . $inquiry_id . '">http://www.businessfieds.com/inquiry/' . $inquiry_id . '</a>'); $emailTemplate->SetTemplate($settings['new_inquiry_buyer_et']); $sendBuyerEmail = sendMail($email, $email->Subject(), $email->CreateBody()); // send buyer email $emailTemplate->SetTemplate($settings['new_inquiry_seller_et']); $sendSellerEmail = sendMail($listing_info->email, $email->Subject(), $email->CreateBody()); // send seller email
require "../includes/config.inc.php"; if (empty($db)) { require_once "../classes/class.Database.php"; $db = new DB($db_name, $db_host, $db_user, $db_password); } require "../includes/functions.php"; require "../includes/session.php"; require_once "../classes/class.Template.php"; $emailTemplate = new EmailTemplate(); // Create an instance for new user from contact form $thread_id = mysql_real_escape_string($_REQUEST['id']); $listing_id = mysql_real_escape_string($_REQUEST['listing_id']); $reply_content = mysql_real_escape_string($_REQUEST['replyContent']); $to_id = mysql_real_escape_string($_REQUEST['to_id']); $seller_id = $db->queryUniqueValue("SELECT to_id FROM messages WHERE id = '{$thread_id}'"); $listing_headline = $db->queryUniqueValue("SELECT headline FROM listings WHERE id = '{$listing_id}'"); $to = $db->queryUniqueObject("SELECT first_name, last_name, email FROM users WHERE id= '{$to_id}'"); if ($thread_id) { $result = $db->query("INSERT INTO messages (parent_id, from_id, to_id, listing_id, message, timestamp) VALUES ('{$thread_id}','{$u_id}','{$to_id}','{$listing_id}','{$reply_content}', NOW())"); // send emails! $emailTemplate->SetParameter("user_name", $to->first_name . ' ' . $to->last_name); $emailTemplate->SetParameter("listing_headline", $listing_headline); if ($to_id == $seller_id) { $emailTemplate->SetParameter("inquiry_url", '<a href="http://businessfieds.com/myListing/' . $listing_id . '&inquiry_id=' . $thread_id . '#inquiry">http://www.businessfieds.com/myListing/' . $listing_id . '&inquiry_id=' . $thread_id . '#inquiry</a>'); } else { $emailTemplate->SetParameter("inquiry_url", '<a href="http://businessfieds.com/myAccount&inquiry_id=' . $thread_id . '#inquiry">http://www.businessfieds.com/myAccount&inquiry_id=' . $thread_id . '#inquiry</a>'); } $emailTemplate->SetTemplate($settings['inquiry_message_et']); $sendBuyerEmail = sendMail($to->email, $emailTemplate->Subject(), $emailTemplate->CreateBody()); // send other party an email }