</td> </tr> </table> </td> </tr> </table> </body> </html>'; $mailsent = mail($to, $subject, $mail_send_details, $headers); // **********************************************************************Send Mail To Administrator $subject_admin = "New Seller Registration with " . SITE_NAME; /*-------Email Template Reading Fuction Call--------*/ $mailcontent_admin = readEmailTemplate('seller_registration_admin', 'artists'); $mailcontent_admin = str_replace('[user_name]', $txtUserName, $mailcontent_admin); $mailcontent_admin = str_replace('[password]', $txtPassword, $mailcontent_admin); $mailcontent_admin = str_replace('[firstname]', $txtFirstName, $mailcontent_admin); $mailcontent_admin = str_replace('[lastname]', $txtLastName, $mailcontent_admin); /*---------------User Login Url-------------------*/ $mailcontent_admin .= "\r\n"; $mailcontent_admin .= "\r\n" . "Click <a href=" . SITE_URL . "/admin/login.php>Here</a> to Login to view details of Seller\r\n\n"; /*---------------User Login Url-------------------*/ $from = "From: " . SITE_EMAIL . "\n"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Reply-To: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Return-Path: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Organization: " . SITE_NAME . "\r\n";
// read file if (checkOrgan($_GET['organ'])) { if (checkFilename($_GET['file']) && checkReadPerms($_GET['organ'])) { //input validation: get organ $text = readFromFile($_GET['organ'], $_GET['file']); $smarty->assign('text', $text); $smarty->assign('organ', $_GET['organ']); $smarty->assign('file', $_GET['file']); } else { if ($_GET['file'] == 'template' && checkReadPerms($_GET['organ'])) { $smarty->assign('text', readTemplate($_GET['organ'])); $smarty->assign('organ', $_GET['organ']); $smarty->assign('file', $_GET['file']); } else { if ($_GET['file'] == 'email' && checkReadPerms($_GET['organ'])) { $smarty->assign('text', readEmailTemplate($_GET['organ'])); $smarty->assign('organ', $_GET['organ']); $smarty->assign('file', $_GET['file']); } else { if ($_GET['file'] == 'resolutions.txt' && checkReadPerms($_GET['organ'])) { $smarty->assign('text', readResolutions($_GET['organ'])); $smarty->assign('organ', $_GET['organ']); $smarty->assign('file', $_GET['file']); } } } } } } if (isset($_POST['text']) and isset($_GET['organ']) and isset($_GET['file'])) { //save changes
if ($changeto == "Y") { // Check if ststus for activation $sql = "select * from " . $tableprefix . "artists where artist_id ={$id} "; $rs = mysql_query($sql) or die(mysql_error()); if (mysql_num_rows($rs) > 0) { $rr = mysql_fetch_array($rs); $status = $rr['vapproved']; $first_name = $rr['first_name']; $last_name = $rr['last_name']; if ($status == "NN") { // ststus check $to = $rr['email']; /*---------Multicart Seller Account Acivation Email Confirmation to seller------------*/ $subject = "Your vendor account activated with " . stripslashes(SITE_NAME); /*-------Email Template Reading Fuction Call--------*/ $mailcontent = readEmailTemplate('seller_registration_approval', 'artists'); $link = SITE_URL . "/sellers/"; $mailcontent = str_replace('[first_name]', $first_name, $mailcontent); $mailcontent = str_replace('[last_name]', $last_name, $mailcontent); $mailcontent = str_replace('[link]', $link, $mailcontent); $mailcontent = str_replace('[site_name]', SITE_NAME, $mailcontent); $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $mailcontent = nl2br($mailcontent); $mail_send_details = "<html><head><link href='" . SITE_URL . "/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=" . $logofolder . "/" . $logoimage . " width='125' height='39'/></div></div><div>" . $mailcontent . "</div></div><div align='left' class='clear_float'><img src=" . $imagefolder . "/clear.gif width=1 height=1/></div></div></div></center></body></html>"; $mailsent = mail($to, $subject, $mail_send_details, $headers); /*---------Multicart Seller Account Acivation End Email Confirmation to seller------------*/ } // end if sttus check }
$result = mysql_query($sql); if (mysql_num_rows($result) != 0) { $row = mysql_fetch_array($result); $email = $row["email"]; $firstname = $row["first_name"]; $lastname = $row["last_name"]; $username = $row["user_name"]; } $userfullname = $firstname; if ($lastname != "") { $userfullname .= " " . $lastname; } $to = $email; $subject = "Your account information with " . stripslashes(SITE_NAME) . " updated by Administrator"; /*----------Multicart 2.0 Upgradation---------------*/ $mailmessage = readEmailTemplate('change_userpassword'); $mailmessage = str_replace('[name]', $userfullname, $mailmessage); $mailmessage = str_replace('[user_name]', $username, $mailmessage); $mailmessage = str_replace('[password]', $txtNewPassword, $mailmessage); $mailmessage = nl2br($mailmessage); $mail_send_details = "<html><head><link href='" . SITE_URL . "/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=" . $logofolder . "/" . $logoimage . " width='125' height='39'/></div></div><div>" . $mailmessage . "</div></div><div align='left' class='clear_float'><img src=" . $imagefolder . "/clear.gif width=1 height=1/></div></div></div></center></body></html>"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $mailsent = @mail($to, $subject, $mail_send_details, $headers); /*----------Multicart 2.0 Upgradation---------------*/ $updatepass = true; } else { $updatepass = true; } if ($updatepass) {
</table> </td> </tr> </table> </body> </html>'; $mailsent = mail($to_admin, $subject, $mail_send_details, $headers); // End Send Mail Message To Administrator if ($row['rma_confirm_message'] == 'Y') { // check send mail confirmation $subject = "Your return payment information with " . SITE_NAME; /*-------Email Template Reading Fuction Call--------*/ $mailcontent = readEmailTemplate('refund_registration'); $mailcontent = str_replace('[p_name]', stripslashes($productname), $mailcontent); $mailcontent = str_replace('[return_reason]', $reason, $mailcontent); $mailcontent = str_replace('[quantity]', $quanity, $mailcontent); $mailcontent = str_replace('[date]', date('m-d-Y'), $mailcontent); if ($buyer_comments != '') { $mailcontent = str_replace('[comments]', $buyer_comments, $mailcontent); } $mailcontent = str_replace('[order_id]', $orderid, $mailcontent); $mailcontent = str_replace('[refund_id]', $refundid, $mailcontent); $mailcontent = str_replace('[seller_first_name]', $sellerfname, $mailcontent); $mailcontent = str_replace('[seller_last_name]', $sellerlname, $mailcontent); $mailcontent = str_replace('[first_name]', $buyerfname, $mailcontent); $mailcontent = str_replace('[last_name]', $buyerlname, $mailcontent); $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
/************* Get Product details *************/ $p_sql = "select * from " . $tableprefix . "products where product_id = \"" . $_POST["pid"] . "\""; $p_rs = mysql_query($p_sql) or die(mysql_error()); $p_row = mysql_fetch_array($p_rs); /************* Get email of the seller ***********************/ if ($reviewapproval == "vendors") { $seller_sql = "select email from " . $tableprefix . "artists where artist_id = " . $p_row["product_artist_id"]; $seller_rs = mysql_query($seller_sql); $seller_rw = mysql_fetch_array($seller_rs); $seller_email = $seller_rw["email"]; } /***************** End fetching product details **********/ // Send mail to admin /*---------Multicart 2.0 Upgradation------------*/ $subject = "New review is posted in " . stripslashes(SITE_NAME); $mailcontent = readEmailTemplate('product_review'); if ($reviewapproval == "admin") { $to = SITE_EMAIL; } elseif ($reviewapproval == "vendors") { $to = $seller_email; $mailcontent = str_replace('Administrator', "Seller", $mailcontent); } $link = "<a href='" . generalMethods::getProductdetailNavigationURL($_POST["pid"]) . "' target='_blank'>Click here</a>"; /*-------Email Template Reading Fuction Call--------*/ $mailcontent = str_replace('[site_name]', SITE_NAME, $mailcontent); $mailcontent = str_replace('[product_name]', $p_row["product_name"], $mailcontent); $mailcontent = str_replace('[link]', $link, $mailcontent); /*--------------- End email template section-------------------*/ /******* Send Email ************************************************/ $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
</tr> </table> </td> </tr> </table> </body> </html>'; //$mail_send_details = "<html><head><link href='".SITE_URL."/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=".$logofolder."/".$logoimage." width='125' height='39'/></div></div><div>".$mailcontent."</div></div><div align='left' class='clear_float'><img src=".$imagefolder."/clear.gif width=1 height=1/></div></div></div></center></body></html>"; $mailsent = mail($to, $subject, $mail_send_details, $headers); // **********************************************************************Send Mail To Administrator $subject_admin = "New Member Registration with " . SITE_NAME; /*-------Email Template Reading Fuction Call--------*/ $mailcontent_admin = readEmailTemplate('member_registration_admin'); $mailcontent_admin = str_replace('[user_name]', $txtUserName, $mailcontent_admin); $mailcontent_admin = str_replace('[password]', $txtPassword, $mailcontent_admin); $mailcontent_admin = str_replace('[first_name]', $txtFirstName, $mailcontent_admin); $mailcontent_admin = str_replace('[last_name]', $txtLastName, $mailcontent_admin); /*---------------User Login Url-------------------*/ $mailcontent_admin .= "\r\n" . "Click <a href=" . SITE_URL . "/admin/login.php>Here</a> to Login to view details of Member\r\n\n"; /*---------------User Login Url-------------------*/ $from = "From: " . SITE_EMAIL . "\n"; /* $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: ".SITE_EMAIL."<".SITE_EMAIL.">" . "\r\n"; $headers .= "Reply-To: ".SITE_NAME."<".SITE_EMAIL.">" . "\r\n"; $headers .= "Return-Path: ".SITE_NAME."<".SITE_EMAIL.">"."\r\n"; $headers .= "Organization: ".SITE_NAME."\r\n";*/ $headers = "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\n";
$result = mysql_query($sql); if (mysql_num_rows($result) != 0) { $row = mysql_fetch_array($result); $email = $row["email"]; $firstname = $row["first_name"]; $lastname = $row["last_name"]; $affiliatename = $row["affiliate_name"]; } $affiliatefullname = $firstname; if ($lastname != "") { $affiliatefullname .= " " . $lastname; } $to = $email; $subject = "Your affiliate account information with " . stripslashes(SITE_NAME) . " updated by Administrator"; /*----------Multicart 2.0 Upgradation---------------*/ $mailmessage = readEmailTemplate('change_affiliatepassword'); $mailmessage = str_replace('[name]', $affiliatefullname, $mailmessage); $mailmessage = str_replace('[user_name]', $affiliatename, $mailmessage); $mailmessage = str_replace('[password]', $txtNewPassword, $mailmessage); $mailmessage = nl2br($mailmessage); $mail_send_details = "<html><head><link href='" . SITE_URL . "/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=" . $logofolder . "/" . $logoimage . " width='125' height='39'/></div></div><div>" . $mailmessage . "</div></div><div align='left' class='clear_float'><img src=" . $imagefolder . "/clear.gif width=1 height=1/></div></div></div></center></body></html>"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $mailsent = @mail($to, $subject, $mail_send_details, $headers); /*----------Multicart 2.0 Upgradation---------------*/ $updatepass = true; } else { $updatepass = true; } if ($updatepass) {
if (mysql_num_rows($result) != 0) { $row = mysql_fetch_array($result); $email = $row["email"]; $firstname = $row["first_name"]; $lastname = $row["last_name"]; $artistname = $row["artist_name"]; } $artistfullname = $firstname; if ($lastname != "") { $artistfullname .= " " . $lastname; } $to = $email; $link = '<a href=' . SITE_URL . '/sellers/login.php> Click here to Login </a>'; $subject = "Your Vendor account information with " . stripslashes(SITE_NAME) . " has been added by Administrator"; /*----------Multicart 2.0 Upgradation---------------*/ $mailmessage = readEmailTemplate('admin_seller_registration'); $mailmessage = str_replace('[first_name]', $firstname, $mailmessage); $mailmessage = str_replace('[last_name]', $lastname, $mailmessage); $mailmessage = str_replace('[user_name]', $artistname, $mailmessage); $mailmessage = str_replace('[password]', $txtPassword, $mailmessage); $mailmessage = str_replace('[site_name]', SITE_NAME, $mailmessage); $mailmessage = str_replace('[link]', $link, $mailmessage); $mailmessage = nl2br($mailmessage); $mail_send_details = "<html><head><link href='" . SITE_URL . "/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=" . $logofolder . "/" . $logoimage . " width='125' height='39'/></div></div><div>" . $mailmessage . "</div></div><div align='left' class='clear_float'><img src=" . $imagefolder . "/clear.gif width=1 height=1/></div></div></div></center></body></html>"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $mailsent = @mail($to, $subject, $mail_send_details, $headers); $message = "Vendor Added successfully!"; header("Location:editartist.php?msg=" . $message . "&artistid=" . $lastInsertedId . "&rghtMenu=rghtMenu4&displayDiv=Members"); }
</td> </tr> </table> </body> </html>'; $mailsent = mail($to_buyer, $subject, $mail_send_details, $headers); } // end email status check // Send Mail for Administraor $subject = "Return Payment Status Change Confirmation with " . SITE_NAME; $to_admin = SITE_EMAIL; /*-------Email Template Reading Fuction Call--------*/ $mailcontent = readEmailTemplate('refund_request_adminstatus'); $mailcontent = str_replace('[user_name]', $buyer, $mailcontent); $mailcontent = str_replace('[p_name]', $productname, $mailcontent); $mailcontent = str_replace('[seller_name]', $sellername, $mailcontent); $mailcontent = str_replace('[status]', $status, $mailcontent); $mailcontent = str_replace('[quantity]', $quanity, $mailcontent); $mailcontent = str_replace('[order_id]', $orderid, $mailcontent); $mailcontent = str_replace('[refund_id]', $refundid, $mailcontent); $mailcontent = str_replace('[date]', $date, $mailcontent); $mailcontent = str_replace('[comments]', $comments, $mailcontent); if ($status == "Refund") { $mailcontent = str_replace('[rmode]', $mode, $mailcontent); $mailcontent = str_replace('[rno]', $rno, $mailcontent); } else { $mailcontent = str_replace('[rmode]', 'nil', $mailcontent); $mailcontent = str_replace('[rno]', 'nil', $mailcontent);
// end if } // end if $to = SITE_EMAIL; $date = date("F d,Y"); $product_code = stripslashes($txtProductCode); $product_name = stripslashes($txtProductName); $product_price = $adminCurrency['currency_symbol'] . " " . number_format($txtPrice, 2, ".", ""); $stock_available = $txtStock; $shipping_weight = $txtShippingWeight . " lbs"; $imageurl = '<img src="' . $product_image . '" width="120" height="150" border="0" >'; //==================================End display product image=============================== $link = "<a href=" . SITE_URL . "/admin/editproduct.php?productid={$productid}>Click here to view the product</a>"; $subject = "A product has been edited in - " . stripslashes(SITE_NAME); /*---------Email Template Reading Fuction Call----------------------------------------*/ $mailcontent = readEmailTemplate('email_product_edit', 'products'); $mailcontent = str_replace('[seller_username]', $seller_username, $mailcontent); $mailcontent = str_replace('[seller_name]', $seller_name, $mailcontent); $mailcontent = str_replace('[date]', $date, $mailcontent); $mailcontent = str_replace('[product_name]', stripslashes($txtProductName), $mailcontent); $mailcontent = str_replace('[product_code]', $txtProductCode, $mailcontent); $mailcontent = str_replace('[product_price]', $txtPrice, $mailcontent); $mailcontent = str_replace('[product_discount]', $txtDiscount, $mailcontent); $mailcontent = str_replace('[product_image]', $imageurl, $mailcontent); $mailcontent = str_replace('[shipping_weight]', $shipping_weight, $mailcontent); $mailcontent = str_replace('[link]', $link, $mailcontent); $mailcontent = str_replace('[stock_available]', $stock_available, $mailcontent); $mailcontent = str_replace('[category_name]', $category_name, $mailcontent); $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n";
} else { // no error so insert user details $sql = "UPDATE " . $tableprefix . "artists SET\n\t\t\tpassword = '******'\n\t\t\tWHERE artist_id = '" . addslashes($artistid) . "'\n\t\t\t"; mysql_query($sql); $updatedRows = mysql_affected_rows(); //send mail to admin if this feature is enabled for this seller $vendorSettings = getVendorEnabledSettings($artistid, 'enableSendMailChangePassword'); if ($vendorSettings == 'Y') { if ($updatedRows > 0) { $to = SITE_EMAIL; $sellerName = getSellerFullname($artistid); //$link = "<a target= '_blank' href='".SITE_URL."/admin/editartist.php?artistid=".$artistid."&rghtMenu=rghtMenu4&displayDiv=Members'> Click here to view the details</a>"; $date = date('m/d/Y'); $subject = "Password of a seller has been changed in - " . stripslashes(SITE_NAME); /*---------Email Template Reading Fuction Call----------------------------------------*/ $mailcontent = readEmailTemplate('seller_change_password'); $mailcontent = str_replace('[seller_name]', $sellerName, $mailcontent); $mailcontent = str_replace('[date_change]', $date, $mailcontent); $mailcontent = str_replace('[site_name]', SITE_NAME, $mailcontent); $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Reply-To: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Return-Path: " . SITE_NAME . "<noreply@" . SITE_NAME . ">" . "\r\n"; $headers .= "Organization: " . SITE_NAME . "\r\n"; $mailcontent = nl2br($mailcontent); //$mail_send_details = "<html><head><link href='".SITE_URL."/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=".$logofolder."/".$logoimage." width='125' height='39'/></div></div><div>".$mailcontent."</div></div><div align='left' class='clear_float'><img src=".$imagefolder."/clear.gif width=1 height=1/></div></div></div></center></body></html>"; $mail_send_details = '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Pure Catskills MarketPlace</title>
$headers .= "Reply-To: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Return-Path: " . SITE_NAME . "<noreply@" . SITE_EMAIL . ">" . "\r\n"; $mailsent = mail($sellerObj->email, $subject, $mail_send_details_seller, $headers); // **********************************************************************Send Mail To Administrator } } // Update Expiry Of Seller if Seller Expired $sql_date_check_expiry = "SELECT ar . * , am . *\n\t\t\t\t\t\tFROM " . $tableprefix . "artists_membershipDetails am\n\t\t\t\t\t\tINNER JOIN " . $tableprefix . "artists ar ON ar.artist_id = am.artist_id\n\t\t\t\t\t\tINNER JOIN " . $tableprefix . "sellerPlans s ON s.plan_Id = ar.sellerPlanID AND s.plan_Id = am.plan_Id \n\t\t\t\t\t\tWHERE am.artist_memEndDate <= CURDATE() AND s.plan_Period IN ('Y','M') "; $rs_date_check_expiry = mysql_query($sql_date_check_expiry) or die(mysql_error()); mysql_num_rows($rs_date_check_expiry); if (mysql_num_rows($rs_date_check_expiry) > 0) { while ($sellerObj = mysql_fetch_object($rs_date_check_expiry)) { $seller_expiry = "UPDATE " . $tableprefix . "artists SET plan_expired='Y' where artist_id='" . $sellerObj->artist_id . "' "; $rs_expiry = mysql_query($seller_expiry) or die(mysql_error()); $subject_expiry = "Seller Plan Expiry With " . SITE_NAME; $mailcontent_seller_expiry = readEmailTemplate('seller_plan_expiry'); $mailcontent_seller_expiry = str_replace('[seller_fname]', $sellerObj->first_name, $mailcontent_seller_expiry); $mailcontent_seller_expiry = str_replace('[seller_lname]', $sellerObj->last_name, $mailcontent_seller_expiry); $mailcontent_seller_expiry = str_replace('[site_name]', $site_name, $mailcontent_seller_expiry); $mailcontent_seller_expiry = str_replace('[date_expiry]', dateFormat($sellerObj->artist_memEndDate, "Y-m-d", "m/d/Y"), $mailcontent_seller_expiry); $link = '<br><br><a href=' . $site_URL . "/sellers/seller_plan_upgrade.php?sellerid=" . $sellerObj->artist_id . ' target="_blank">Click here to make payment</a><br><br>'; $mailcontent_seller_expiry = str_replace('[LINK]', $link, $mailcontent_seller_expiry); $mail_send_details_seller_expiry = '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Online reservation</title> <link href="./themes/' . $active_template[4] . ' rel="stylesheet" type="text/css"> </head> <body> <table width="103%" cellspacing="10" cellpadding="0" bgcolor="#EAEAEA">
$vacationmode = $_POST['vacationmode'] == 'on' ? 'Y' : 'N'; $sql = "UPDATE " . $tableprefix . "artists SET\n\t\t\tfirst_name = '" . addslashes($txtFirstName) . "',\n\t\t\tlast_name = '" . addslashes($txtLastName) . "',\n\t\t\taddress1 = '" . addslashes($txtAddress1) . "',\n\t\t\taddress2 = '" . addslashes($txtAddress2) . "',\n\t\t\tcity = '" . addslashes($txtCity) . "',\n\t\t\tstate = '" . addslashes($txtState) . "',\n\t\t\tcountry = '" . addslashes($ddlCountry) . "',\n\t\t\tphone = '" . addslashes($txtPhone) . "',\n\t\t\tfax = '" . addslashes($txtFAX) . "',\n\t\t\tzip = '" . addslashes($txtZIP) . "',\n\t\t\temail = '" . addslashes($txtEmail) . "',\n\t\t\tcompany='" . addslashes($txtCompany) . "',\n\t\t\twebsite='" . addslashes($txtWeb) . "',\n\t\t\tpaypalemail='" . addslashes($txtPaypalEmail) . "',\n vacationmode= '" . addslashes($vacationmode) . "'\n\t\t\tWHERE artist_id = '" . addslashes($artistid) . "'\n\t\t\t"; mysql_query($sql) or die(mysql_error()); $updatedRows = mysql_affected_rows(); //send mail to admin if this feature is enabled for this seller $vendorSettings = getVendorEnabledSettings($artistid, 'enableSendMailProfileEdit'); if ($vendorSettings == 'Y') { if ($updatedRows > 0) { $to = SITE_EMAIL; $sellerName = getSellerFullname($artistid); $link = "<a target= '_blank' href='" . SITE_URL . "/admin/editartist.php?artistid=" . $artistid . "&rghtMenu=rghtMenu4&displayDiv=Members'> Click here to view the details</a>"; $date = date('m/d/Y'); /*---------Multicart Seller Account Acivation Email Confirmation to seller------------*/ $subject = "Profile of a vendor has been edited in - " . stripslashes(SITE_NAME); /*---------Email Template Reading Fuction Call----------------------------------------*/ $mailcontent = readEmailTemplate('seller_profile_edit'); $mailcontent = str_replace('[seller_name]', $sellerName, $mailcontent); $mailcontent = str_replace('[date_change]', $date, $mailcontent); $mailcontent = str_replace('[seller_link]', $link, $mailcontent); $mailcontent = str_replace('[site_name]', SITE_NAME, $mailcontent); $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Reply-To: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Return-Path: " . SITE_NAME . "<noreply@" . SITE_NAME . ">" . "\r\n"; $headers .= "Organization: " . SITE_NAME . "\r\n"; $mailcontent = nl2br($mailcontent); //$mail_send_details = "<html><head><link href='".SITE_URL."/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=".$logofolder."/".$logoimage." width='125' height='39'/></div></div><div>".$mailcontent."</div></div><div align='left' class='clear_float'><img src=".$imagefolder."/clear.gif width=1 height=1/></div></div></div></center></body></html>"; $mail_send_details = '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
$txtEmail = $gift_row['email']; $gift_coupon_flag = 1; $gift_coupon_product_id = $gift_row['product_id']; $gift_coupon_link .= "Coupon Code :- " . $gift_code_row['vgift_coupon_code'] . "\r\n"; $gift_coupon_link .= "Coupon Amount :- " . $certificate_amount . "\r\n\n"; /*--------Updating the order status to 'delivered' if the product purchased is gift coupon------------*/ $update_order_details = "UPDATE " . $tableprefix . "order_details\n\t\t\t\t\t\t\t\t\t \t SET item_status = 4 \n\t\t\t\t\t\t\t\t\t \t WHERE order_id = " . $orderid . " AND product_id = " . $gift_coupon_product_id; mysql_query($update_order_details) or die(mysql_error()); /*--------Updating the order status to 'delivered' if the product purchased is gift coupon------------*/ } /*---------mail sending gift coupon code ends-----------*/ } } if ($gift_coupon_flag == 1) { /*-------Email Template Reading Fuction Call--------*/ $mailcontent = readEmailTemplate('gift_coupon', '', $txtEmail); $mailcontent = str_replace('[coupon_code]', $gift_code_row['vgift_coupon_code'], $mailcontent); $mailcontent = str_replace('[coupon_amount]', $certificate_amount, $mailcontent); $subject = "Gift Certificate Order placed at " . SITE_NAME; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; /*------------Seller Store Url---------------------*/ // send the friendly url in mail based on config settings if ($enable_seller_friendly == "Y") { $select_seller_name = "SELECT artist_name FROM " . $tableprefix . "artists WHERE artist_id = " . $artistid; $result_seller_name = mysql_query($select_seller_name) or die(mysql_error()); if (mysql_num_rows($result_seller_name) > 0) { $seller_name_row = mysql_fetch_assoc($result_seller_name); $txtSellerName = $seller_name_row['artist_name']; }
$art_rw = mysql_fetch_array($art_rs); $seller_name = $art_rw["first_name"] . " " . $art_rw["last_name"]; /*************** End get seller name ******************************/ foreach ($chkorders as $rp) { /********************* [START]Send requesy payment to the administrator **********************/ $subject = "A request payment has been placed in " . stripslashes(SITE_NAME) . " by a seller"; $b_sql = "select billing_first_name,billing_last_name,order_total_price,vorder_currency from " . $tableprefix . "orders where order_id={$rp}"; $b_rs = mysql_query($b_sql) or die(mysql_error()); $b_rw = mysql_fetch_array($b_rs); $bfname = $b_rw["billing_first_name"]; $blname = $b_rw["billing_last_name"]; $p_sql = "SELECT sum((product_price-(product_price*product_discount/100)) *product_quantity) as total FROM " . $tableprefix . "order_details\n\t\t WHERE artist_id = '" . $artistid . "' AND item_status = '4' AND artist_payment_status = '1' \n\t\t\t\t\tand order_id IN (" . addslashes($orderlist) . ") GROUP BY artist_id"; $p_rs = mysql_query($p_sql); $p_rw = mysql_fetch_array($p_rs); /*-------Email Template Reading Fuction Call--------*/ $mailcontent = readEmailTemplate('request_payment_seller'); //echo $mailcontent;exit; $mailcontent = str_replace('[seller_name]', $seller_name, $mailcontent); $orderdetails = "<p>Order Id : {$rp}</p>"; $orderdetails .= "<p>Buyer Name : " . $bfname . " " . $blname . "</p>"; $orderdetails .= "<p>Total Purchase : " . $b_rw["vorder_currency"] . " " . $p_rw["total"] . "</p>"; $mailcontent = str_replace('[order_details]', $orderdetails, $mailcontent); $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Reply-To: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Return-Path: " . SITE_NAME . "<noreply@" . SITE_EMAIL . ">" . "\r\n"; $mailcontent = nl2br($mailcontent); $mail_send_details = '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
if (isset($_GET['mode']) && $_GET['mode'] == 'da') { mysql_query("UPDATE " . $tableprefix . "Review SET vActive='0' WHERE nRId='" . $_GET['rid'] . "'") or die(mysql_error()); $message = 'Review disapproved successfully.'; $status = "not approved"; } //end if if ($_GET['mode']) { // Send Mails to Seller $subject = "Your product review on " . SITE_NAME . " has been {$status}"; $link = "<a href='" . generalMethods::getProductdetailNavigationURL($_GET["pid"]) . "' target='_blank'>Click here</a>"; $user_sql = "select first_name,last_name,email from " . $tableprefix . "users where user_id=(select nUserId from " . $tableprefix . "Review where nRId = " . $_GET['rid'] . ")"; $user_rs = mysql_query($user_sql); $user_rw = mysql_fetch_array($user_rs); $to = $user_rw["email"]; /*-------Email Template Reading Fuction Call--------*/ $mailcontent = readEmailTemplate('product_review_approved'); $mailcontent = stripslashes($mailcontent); $mailcontent = str_replace('[user_name]', $user_rw["first_name"] . " " . $user_rw["last_name"], $mailcontent); $mailcontent = str_replace('[approved_by]', "Seller", $mailcontent); $mailcontent = str_replace('[status]', $status, $mailcontent); $mailcontent = str_replace('[product_name]', urldecode($_GET["name"]), $mailcontent); $mailcontent = str_replace('[link]', $link, $mailcontent); $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $mailcontent = nl2br($mailcontent); $mail_send_details = '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Online reservation</title> <link href="./themes/' . $active_template[4] . ' rel="stylesheet" type="text/css">
if ($status == "NN") { // ststus check $txtUserName = $rr['affiliate_name']; $txtFirstName = $rr['first_name']; $txtPassword = $rr['password']; $randvalues = rand(0, 1000); $newpassword = $txtUserName . $randvalues; $password = md5($newpassword); $_SESSION["sess_affiliateid_new"] = "1"; /*$sql_update="UPDATE ".$tableprefix."affiliates SET password = '******' where affiliate_id =$id "; $rs_update=mysql_query($sql_update) or die(mysql_error());*/ $to = $rr['email']; /*---------Multicart Seller Account Acivation Email Confirmation to seller------------*/ $subject = "Your Affiliate account activated with " . stripslashes(SITE_NAME); /*-------Email Template Reading Fuction Call--------*/ $mailcontent = readEmailTemplate('affiliate_registration_status', 'affiliates'); $mailcontent .= "\r\n\n" . "<b>Click <a href=" . SITE_URL . "/affiliates/login.php>Here</a> to Login </b>\r\n\n"; $mailcontent .= "\r\n" . "<a href=" . SITE_URL . "/index.php>" . SITE_URL . "</a>\r\n\n"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $mailcontent = nl2br($mailcontent); $mail_send_details = '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Online reservation</title> <link href="./themes/' . $active_template[4] . ' rel="stylesheet" type="text/css"> </head> <body> <table width="103%" cellspacing="10" cellpadding="0" bgcolor="#EAEAEA">
} } $mailcontent_details = $productlist; $mailcontent_details .= $billingaddress; /* ---------Shipping details not available if gift coupon/digital product is purchased--------- */ if ($gift_coupon_flag != 1 && $product_download_flag != 1) { $mailcontent_details .= $shippingaddress; } $mailcontent_seller = str_replace('[order_details]', $mailcontent_details, $mailcontent_seller); $mailcontent_seller = nl2br($mailcontent_seller); $mail_send_details = " <html><head><link href='" . SITE_URL . "/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=" . $logofolder . "/" . $logoimage . " width='125' height='39'/></div></div><div>" . $mailcontent_seller . "</div></div><div align='left' class='clear_float'><img src=" . $imagefolder . "/clear.gif width=1 height=1/></div></div><div align='center' class='copyright'>Powered by <a href='http://www.iscripts.com/multicart' target='_blank'><font color='#F4700E'><b>iScripts Multicart</b></font></a> © 2007 iScripts.com. All Rights Reserved </div><div align='left' class='clear_float'><img src='" . SITE_URL . "/images/clear_admin.gif' alt='' width='1' height='1' /></div></div></center></body></html>"; $mailsent = mail($artistemail, $ordersubject, $mail_send_details, $headers); $mailcontent_reorder = ""; if ($productlist_fillstock != "") { /* -------Email Template reading function call------------ */ $mailcontent_reorder = readEmailTemplate('stock_reorder'); $mailcontent_reorder = str_replace('[product_details]', $productlist_fillstock, $mailcontent_reorder); $mailcontent_reorder = nl2br($mailcontent_reorder); $mail_send_details_reorder = "<html><head><link href='" . SITE_URL . "/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=" . $logofolder . "/" . $logoimage . " width='125' height='39'/></div></div><div>" . $mailcontent_reorder . "</div></div><div align='left' class='clear_float'><img src=" . $imagefolder . "/clear.gif width=1 height=1/></div></div></div></center></body></html>"; $ordersubject_fillstock = "Stock Reorder at " . SITE_NAME; $mailsent = mail($artistemail, $ordersubject_fillstock, $mail_send_details_reorder, $headers); /* -------Email Template reading function call------------ */ } } emptyCart($_SESSION["sess_userid"]); $_SESSION["sess_addresses_collected"] = false; $_SESSION["sess_stock_adjusted"] = false; } } if ($_POST["btnCancelOrder"] == "Cancel Order") { $message = "";
$userid = $row["user_id"]; $randnum1 = mt_rand(); if (strlen($randnum1) > 6) { $randnum1 = substr($randnum1, 0, 6); } $newpass = $randnum1; $pass = md5($newpass); $sqlreset = "UPDATE " . $tableprefix . "users SET password = '******' WHERE user_id = '" . addslashes($userid) . "' "; $userfullname = $firstname; if ($lastname != "") { $userfullname .= " " . $lastname; } $to = $txtEmail; $subject = "Your password with " . htmlentities(stripslashes(SITE_NAME)) . " reset on request!"; /*----------Multicart 2.0 Upgradation---------------*/ $mailmessage = readEmailTemplate('user_forgotpassword'); $mailmessage = str_replace('[name]', $userfullname, $mailmessage); $mailmessage = str_replace('[user_name]', $username, $mailmessage); $mailmessage = str_replace('[password]', $newpass, $mailmessage); $mailmessage = nl2br($mailmessage); $mail_send_details = "<html><head><link href='" . SITE_URL . "/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=" . $logofolder . "/" . $logoimage . " width='125' height='39'/></div></div><div>" . $mailmessage . "</div></div><div align='left' class='clear_float'><img src=" . $imagefolder . "/clear.gif width=1 height=1/></div></div></div></center></body></html>"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $mailsent = @mail($to, $subject, $mail_send_details, $headers); /*----------Multicart 2.0 Upgradation---------------*/ $successmessage = ""; if ($mailsent) { mysql_query($sqlreset); $successmessage .= "Your updated password has been successfully sent to {$to}"; } else {
$sellerordertotal = number_format($rw4["order_total_price"], 2, ".", ""); $adminCommissionamount = number_format($rw4["commission"], 2, ".", ""); $totalpaid = number_format($totalpaid, 2, ".", ""); //$commissiontaken = ($total * $artistcommission)/100; //$totalpaid = $total - $commissiontaken; $sqlpayment = "INSERT INTO " . $tableprefix . "artist_payments\n\t\t\t(\n\t\t\tartist_id,\n\t\t\torder_id,\n\t\t\tcommission_percentage,\n\t\t\ttotal_amount,\n\t\t\tamount_paid,\n\t\t\tdate_marked_for_payment,\n seller_order_total_amount,\n admin_commision_amount\n\t\t\t)\n\t\t\tVALUES\n\t\t\t(\n\t\t\t'" . addslashes($artist) . "',\n\t\t\t'" . addslashes($orderid) . "',\n\t\t\t'" . addslashes($artistcommission) . "',\n\t\t\t'" . addslashes($total) . "',\n\t\t\t'" . addslashes($totalpaid) . "',\n\t\t\tnow(),\n '" . $sellerordertotal . "',\n '" . $adminCommissionamount . "'\n\t\t\t) "; mysql_query($sqlpayment); $paymentid = mysql_insert_id(); $sql = "UPDATE " . $tableprefix . "order_details SET artist_payment_status = '3', artist_payment_id = '" . addslashes($paymentid) . "' WHERE order_id = '" . addslashes($orderid) . "' AND artist_id = '" . addslashes($artist) . "' "; mysql_query($sql); /********************** Send email to seller ****************************/ $to = $rw4["email"]; $subject = "Your payment is settled by the administrator in " . stripslashes(SITE_NAME); /*-------Email Template Reading Fuction Call--------*/ $adminCurrency = GetAdminCurrency(); $mailcontent = readEmailTemplate('settle_artist_payment'); $mailcontent = str_replace('[amount]', $adminCurrency['currency_symbol'] . " " . $totalpaid, $mailcontent); $mailcontent = str_replace('[site_name]', SITE_NAME, $mailcontent); $mailcontent = str_replace('[seller_name]', $rw4["first_name"] . " " . $rw4["last_name"], $mailcontent); /*---------------Seller Login Url-------------------*/ //********************HEADERS************************* $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Reply-To: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Return-Path: " . SITE_NAME . "<noreply@" . SITE_EMAIL . ">" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Organization: " . SITE_NAME . "\r\n"; $headers .= "Content-Type: text/html\r\n"; //**************************************************** $mailcontent = nl2br($mailcontent); $mail_send_details = '<html> <head>
} // end if }else { $product_image=SITE_URL."/products/$small_image_name_after_upload"; }*/ //send mail to admin if this feature is enabled for this seller $vendorSettings = getVendorEnabledSettings($artistid, 'enableSendMailProductAdd'); if ($vendorSettings == 'Y') { $imageurl = '<img src="' . $product_image . '" width="120" height="150" border="0" >'; //==================================End display product image=============================== $link = "<a href=" . SITE_URL . "/admin/editproduct.php?productid={$product_insert_id}>Click here to view the product</a>"; /*---------Multicart Seller Account Acivation Email Confirmation to seller------------*/ $subject = "A new product has been added in - " . stripslashes(SITE_NAME); /*---------Email Template Reading Fuction Call----------------------------------------*/ $mailcontent = readEmailTemplate('new_product_approval', 'products'); $mailcontent = str_replace('[seller_username]', $seller_username, $mailcontent); $mailcontent = str_replace('[seller_name]', $seller_name, $mailcontent); $mailcontent = str_replace('[date]', $date, $mailcontent); $mailcontent = str_replace('[product_name]', $product_name, $mailcontent); $mailcontent = str_replace('[product_code]', $txtProductCode, $mailcontent); $mailcontent = str_replace('[product_price]', $product_price, $mailcontent); $mailcontent = str_replace('[product_discount]', $txtDiscount, $mailcontent); $mailcontent = str_replace('[product_image]', $imageurl, $mailcontent); $mailcontent = str_replace('[shipping_weight]', $shipping_weight, $mailcontent); $mailcontent = str_replace('[link]', $link, $mailcontent); $mailcontent = str_replace('[stock_available]', $stock_available, $mailcontent); $mailcontent = str_replace('[category_name]', $category_name, $mailcontent); $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n";
$orderstatus_new = getArtistOrderStatus($orderid, $artistid); // Send Order Satus Change Mail To Buyer if (isset($_POST['chkStatus']) && $_POST['chkStatus'] == 'Y') { $subject = "Your order status in " . stripslashes(SITE_NAME) . " has been changed"; $_SESSION["orderid_new"] = $orderid; $_SESSION["artist_new"] = $artistid; $art_sql = "select billing_first_name,billing_last_name,billing_email from " . $tableprefix . "orders where order_id={$orderid}"; $art_rs = mysql_query($art_sql) or die(mysql_error()); $art_rw = mysql_fetch_array($art_rs); $to = $art_rw["billing_email"]; $seller_sql = "select concat(first_name,' ',last_name) AS name from " . $tableprefix . "artists where artist_id={$artistid}"; $seller_rs = mysql_query($seller_sql) or die(mysql_error()); $seller_rw = mysql_fetch_array($seller_rs); $seller_name = ucwords($seller_rw["name"]); /*-------Email Template Reading Fuction Call--------*/ $mailcontent = readEmailTemplate('order_statuschange_buyer_seller', 'orders'); //echo $mailcontent;exit; $mailcontent = str_replace('[first_name]', $art_rw["billing_first_name"], $mailcontent); $mailcontent = str_replace('[last_name]', $art_rw["billing_last_name"], $mailcontent); $mailcontent = str_replace('[order_status]', $orderstatus_new, $mailcontent); $mailcontent = str_replace('[seller_name]', $seller_name, $mailcontent); $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Reply-To: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Return-Path: " . SITE_NAME . "<noreply@" . SITE_EMAIL . ">" . "\r\n"; $mailcontent = nl2br($mailcontent); //$mail_send_details = "<html><head><link href='".SITE_URL."/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=".$logofolder."/".$logoimage." width='125' height='39'/></div></div><div>".$mailcontent."</div></div><div align='left' class='clear_float'><img src=".$imagefolder."/clear.gif width=1 height=1/></div></div></div></center></body></html>"; $mail_send_details = '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
function sendDigitalCertificateMail_Admin($order_id, $user_id) { global $tableprefix; $adminCurrency = GetAdminCurrency(); $currency_attributes[0] = $adminCurrency['currency_symbol']; $queryOrder = "SELECT o.* ,DATE_FORMAT(o.order_date,'%m-%d-%Y') as order_dateF from " . $tableprefix . "orders o where order_id=" . $order_id . " "; $orderQ = mysql_query($queryOrder); $orderObj = mysql_fetch_object($orderQ); $mailContent = ' <table width="100%" cellpadding="0" cellspacing="0" border="0" style="background-color:#F5F5F5;font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#000000; "> <tr> <td style="font-weight:bold; color:#CE0221; font-size:14px; padding:15px 15px 5px 15px;" align="left" valign="top"> Order Details: </td> </tr> <tr> <td align="left" valign="top" style="padding:5px 15px 15px 15px; "> <table width="100%" cellpadding="5" cellspacing="0" border="0" style="background-color:#FFFFFF; border:#D5D5D5 solid 1px;font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#000000; "> <tr> <td width="40%">Store Name</td> <td width="60%" style="font-size:13px; color:#991818; font-weight:bold; ">' . SITE_NAME . '(' . SITE_URL . ')</td> </tr>'; $mailContent .= '<tr> <td >Order ID</td> <td style="font-size:13px; color:#991818; font-weight:bold; ">' . $orderObj->order_id . '</td> </tr> <tr> <tr> <td >Order Date</td> <td style="font-size:13px; color:#991818; font-weight:bold; ">' . $orderObj->order_dateF . '</td> </tr> </table> </td> </tr> <tr> <td style="font-weight:bold; color:#CE0221; font-size:14px; padding:15px 15px 5px 15px;" align="left" valign="top"> Products: </td> </tr> <tr> <td align="left" valign="top" style="padding:5px 15px 15px 15px; "> <table width="100%" cellpadding="5" cellspacing="0" border="0" style="background-color:#FFFFFF; border:#D5D5D5 solid 1px;font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#000000; "> <tr style="background-color:#D2D2D2; font-weight:bold; "> <td align="left" valign="top">Sl No.</td> <td align="left" valign="top">Digital Product Name</td> <td align="left" valign="top">Product Code</td> <td align="left" valign="top">Rate</td> <td align="left" valign="top">Quantity</td> <td align="left" valign="top">Price</td> </tr>'; $queryOrderDetail = "SELECT od.*,gc.vdigital_product_code,gc.ndownload_try,gc.ndownload_expiry,gc.ndownload_expiry_days\n \t\t\t\t\t\tFROM " . $tableprefix . "order_details od\n\t\t\t\t\t\tINNER JOIN " . $tableprefix . "digital_product gc ON gc.ndigital_productid=od.product_id AND gc.ndigital_orderid='" . addslashes($order_id) . "'\n\t\t\t\t\t\tWHERE od.order_id =" . $order_id . " GROUP BY gc.ndigital_productid "; $orderDetailQ = mysql_query($queryOrderDetail); $itemTotal = 0; $inc = 1; while ($orderDetailObj = mysql_fetch_object($orderDetailQ)) { $optionStr = ""; $productname = stripslashes($orderDetailObj->product_name); $productRate = $orderDetailObj->product_price; $productPrice = $productRate * $orderDetailObj->product_quantity; $discountstr = ""; if ($orderDetailObj->product_discount != 0) { $productPrice = $productPrice - $productPrice * $orderDetailObj->product_discount / 100; $discountstr = "<br>discount(" . $orderDetailObj->product_discount . "%)"; } $converted_price = $productPrice; $productPrice = number_format($converted_price, 2, ".", ""); $itemTotal += $productPrice; $mailContent .= '<tr> <td align="left" valign="top">' . $inc . '</td> <td align="left" valign="top">' . stripslashes($productname) . '</td> <td align="left" valign="top">' . $orderDetailObj->product_code . '</td> <td align="left" valign="top"> ' . $currency_attributes[0] . ' ' . number_format($productRate, 2, ".", "") . '</td> <td align="left" valign="top"> ' . $orderDetailObj->product_quantity . '</td> <td align="left" valign="top">' . $currency_attributes[0] . ' ' . number_format($productPrice, 2, ".", "") . ' ' . $discountstr . '</td> </tr>'; $inc++; } $mailContent .= '</table></td></tr>'; $ItemTotalPrice = 0; //Modified ON 03-12-2010 // Remove Set Price Total from Total Price $ItemTotalPrice = $itemTotal; $mailContent .= '<tr> <td style="font-weight:bold; color:#CE0221; font-size:14px; padding:15px 15px 5px 15px;" align="left" valign="top"> Charges: </td> </tr> <tr> <td align="left" valign="top" style="padding:5px 15px 15px 15px; " width="100%"> <table width="100%" cellpadding="5" cellspacing="0" border="0" style="background-color:#FFFFFF; border:#D5D5D5 solid 1px;font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#000000; ">'; $mailContent .= '<tr> <td>Tax Rate:</td> <td style="font-size:13px; color:#991818; font-weight:bold; ">' . $currency_attributes[0] . ' ' . $orderObj->taxrate . '</td> </tr>'; $mailContent .= '<tr> <td>Order Total :</td> <td style="font-size:16px; color:#FF0000; font-weight:bold; ">' . $currency_attributes[0] . ' ' . number_format($ItemTotalPrice, 2, ".", "") . '</td> </tr>'; $mailContent .= '<tr> <td>Amount Paid:</td> <td style="font-size:16px; color:#FF0000; font-weight:bold; ">' . $currency_attributes[0] . ' ' . number_format($orderObj->namount_paid, 2, ".", "") . '</td> </tr>'; $mailContent .= '<tr> <td colspan="2"> </td> </tr></table></td></tr>'; if ($orderObj->billing_address2) { $mailContent .= '<tr></table> </td> </tr> <tr> <td style="font-weight:bold; color:#CE0221; font-size:14px; padding:15px 15px 5px 15px;" align="left" valign="top"> Billing Address: </td> </tr> <tr> <td align="left" valign="top" style="padding:5px 15px 15px 15px; "> <table width="100%" cellpadding="5" cellspacing="0" border="0" style="background-color:#FFFFFF; border:#D5D5D5 solid 1px;font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#000000; "> <tr> <td align="left" valign="top"> ' . $orderObj->billing_first_name . ' ' . $orderObj->billing_last_name . '<br> ' . $orderObj->billing_address1 . ',<br> ' . $orderObj->billing_address2 . ',<br> ' . $orderObj->billing_city . ', ' . $orderObj->billing_state . ', ' . $orderObj->billing_country . ' ' . $orderObj->billing_zip . '<br> Phone: ' . $orderObj->billing_phone . '<br> ' . $orderObj->billing_email . ' </td> </tr> </table> </td> </tr>'; } else { $mailContent .= '<tr></table> </td> </tr> <tr> <td style="font-weight:bold; color:#CE0221; font-size:14px; padding:15px 15px 5px 15px;" align="left" valign="top"> Billing Address: </td> </tr> <tr> <td align="left" valign="top" style="padding:5px 15px 15px 15px; "> <table width="100%" cellpadding="5" cellspacing="0" border="0" style="background-color:#FFFFFF; border:#D5D5D5 solid 1px;font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#000000; "> <tr> <td align="left" valign="top"> ' . $orderObj->billing_first_name . ' ' . $orderObj->billing_last_name . '<br> ' . $orderObj->billing_address1 . ',<br> ' . $orderObj->billing_city . ', ' . $orderObj->billing_state . ', ' . $orderObj->billing_country . ' ' . $orderObj->billing_zip . '<br> Phone: ' . $orderObj->billing_phone . '<br> ' . $orderObj->billing_email . ' </td> </tr> </table> </td> </tr>'; } $mailContent .= '</table>'; $mailcontent_admin = readEmailTemplate('digital_product_admin'); $mailcontent_admin = str_replace('[first_name]', $orderObj->billing_first_name, $mailcontent_admin); $mailcontent_admin = str_replace('[last_name]', $orderObj->billing_last_name, $mailcontent_admin); $mailcontent_admin = str_replace('[order_details]', $mailContent, $mailcontent_admin); $mail_send_details_admin = '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Online reservation</title> <link href="' . SITE_URL . '/style/template1-admin.css" rel="stylesheet" type="text/css"> </head> <body> <table width="103%" cellspacing="10" cellpadding="0" bgcolor="#EAEAEA"> <tr> <td align="center" valign="top"> <table width="600" border="0" cellpadding="0" cellspacing="0" bordercolor="#EAEAEA" bgcolor="#FFFFFF" class="manage_table"> <tr> <td align="right" > </td> </tr> <tr> <td valign="middle" align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#EAEAEA" > <img src=' . SITE_URL . '/banners/' . getSettingsValue('site_logo') . ' width="125" height="60"/></td> </tr> </table></td> </tr> <tr> <td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="10"> <tr> <td align="left"><p>' . $mailcontent_admin . '</p> </td> </tr> </table></td> </tr> <tr> <td align="center" bgcolor="#EAEAEA" class="footer"> <p> </p> </td> </tr> </table> </td> </tr> </table> </body> </html>'; //echo $mail_send_details_buyer; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Reply-To: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Return-Path: " . SITE_NAME . "<noreply@" . SITE_NAME . ">" . "\r\n"; $headers .= "Organization: " . SITE_NAME . "\r\n"; $ordersubject = "Digital Product Order placed at " . SITE_NAME; $adminemail = getSettingsValue('site_email'); $mailsent = mail($adminemail, $ordersubject, $mail_send_details_admin, $headers); }
/*-----------------Digital Product Mail Sending Starts----------------*/ if ($product_download_flag == 1) { isset($_SESSION['SESS_digital_product']) ? session_unregister('SESS_digital_product') : session_register('SESS_digital_product'); $_SESSION['SESS_digital_product'] = 1; $select_user_email = "SELECT user_name,email FROM " . $tableprefix . "users WHERE user_id = " . $CustomArray[0]; $result_user_email = mysql_query($select_user_email) or die(mysql_error()); $user_email_row = mysql_fetch_assoc($result_user_email); $user_name = $user_email_row['user_name']; $product_download_details .= "User Name - {$user_name}\r\n\n"; $txtEmailDownload = $user_email_row['email']; $subjectDownload = "Digital Product Order placed at " . SITE_NAME; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; /*-------Email Template reading function call------------*/ $mailcontent_digital_product = readEmailTemplate('digital_product'); $product_download_details .= "\n\n*-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------*\r\n"; $product_download_details .= "<font color='#FF0000'>Note: If you do not have pop-ups enabled on your browser, the product download many not work properly.So please enable pop-ups before downloading !!</font>"; $mailcontent_digital_product = str_replace('[product_details]', $product_download_details, $mailcontent_digital_product); $mailcontent_digital_product = nl2br($mailcontent_digital_product); $mail_send_details = "<html><head><link href='" . SITE_URL . "/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=" . $logofolder . "/" . $logoimage . " width='125' height='39'/></div></div><div>" . $mailcontent_digital_product . "</div></div><div align='left' class='clear_float'><img src=" . $imagefolder . "/clear.gif width=1 height=1/></div></div></div></center></body></html>"; //$mailsent = mail($txtEmailDownload,$subjectDownload,$mail_send_details,$headers); } /*-----------------Digital Product Mail Sending Ends----------------*/ // Send Giftcertificate Mails if ($gift_coupon_flag == 1) { sendgiftCertificateMail_Buyer($orderid, $CustomArray[0]); } else { sendBuyerEmail($orderid, $CustomArray[0]); sendSellerEmail($orderid, $CustomArray[0]); sendAdminEmail($orderid, $CustomArray[0]);
$sql = "SELECT admin_name FROM " . $tableprefix . "settings WHERE site_email = '" . addslashes($txtEmail) . "' "; $res = mysql_query($sql); if (mysql_num_rows($res) != 0) { $row = mysql_fetch_array($res); $firstname = $row["admin_name"]; $randnum1 = mt_rand(); if (strlen($randnum1) > 6) { $randnum1 = substr($randnum1, 0, 6); } $newpass = $randnum1; $pass = md5($newpass); $sqlreset = "UPDATE " . $tableprefix . "settings SET admin_password = '******'"; $to = $txtEmail; $subject = "Your password with " . stripslashes(SITE_NAME) . " reset on request!"; /*----------Multicart 2.0 Upgradation---------------*/ $mailmessage = readEmailTemplate('admin_forgotpassword'); $mailmessage = str_replace('[name]', $firstname, $mailmessage); $mailmessage = str_replace('[user_name]', $firstname, $mailmessage); $mailmessage = str_replace('[password]', $newpass, $mailmessage); $mailmessage = nl2br($mailmessage); $mail_send_details = "<html><head><link href='" . SITE_URL . "/style/template1-admin.css' rel='stylesheet' type='text/css'></head><body><center><div align='left' id='layout'><div align='left' class='header'><div align='left' class='logo'><img src=" . $logofolder . "/" . $logoimage . " width='125' height='39'/></div></div><div>" . $mailmessage . "</div></div><div align='left' class='clear_float'><img src=" . $imagefolder . "/clear.gif width=1 height=1/></div></div></div></center></body></html>"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $mailsent = @mail($to, $subject, $mail_send_details, $headers); /*----------Multicart 2.0 Upgradation---------------*/ $successmessage = ""; if ($mailsent) { mysql_query($sqlreset); $successmessage .= "Your updated password has been successfully sent to {$to}"; } else {
$product_image = SITE_URL . "/products/{$final_image_big}"; } else { // if images not in the table $product_image = SITE_URL . "/products/noimage.jpg"; } // end if } else { $product_image = SITE_URL . "/products/{$final_image_small}"; } $imageurl = '<img src="' . $product_image . '" width="120" height="150" border="0" >'; //==================================End display product image=============================== $link = "<a href=" . SITE_URL . "/admin/editproduct.php?productid={$insert_product_id}>Click here to view the details</a>"; /*---------Multicart Seller Account Acivation Email Confirmation to seller------------*/ $subject = "A New Gift Certificate been added in - " . stripslashes(SITE_NAME); /*-------Email Template Reading Fuction Call--------*/ $mailcontent = readEmailTemplate('new_gift_certificate_seller', 'products'); $mailcontent = str_replace('[seller_username]', $seller_username, $mailcontent); $mailcontent = str_replace('[seller_name]', $seller_name, $mailcontent); $mailcontent = str_replace('[date]', $date, $mailcontent); $mailcontent = str_replace('[certificate_name]', stripslashes($_POST["txtGiftCouponName"]), $mailcontent); $mailcontent = str_replace('[certificate_code]', stripslashes($_POST["txtGiftCouponCode"]), $mailcontent); $mailcontent = str_replace('[certificate_amount]', $product_price, $mailcontent); $mailcontent = str_replace('[stock_reorder]', stripslashes($_POST["txtStockReorder"]), $mailcontent); $mailcontent = str_replace('[imglink]', $link, $mailcontent); $mailcontent = str_replace('[stock_available]', stripslashes($_POST["txtCouponStock"]), $mailcontent); $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $mailcontent = nl2br($mailcontent); $mail_send_details = '<html> <head>
} */ /*if(isset( $_SESSION["sess_userid"]) and $_SESSION["sess_userid"]!= "") { $userid = $_SESSION["sess_userid"]; }else { header("Location:login.php"); exit; }*/ $name = $_POST['name']; $email = $_POST['email']; $product_id = $_POST['product_id']; $product_url = '<a target="_blank" href="' . generalMethods::getProductdetailNavigationURL($product_id) . '">' . generalMethods::getProductdetailNavigationURL($product_id) . '</a>'; //$userName = getLoggedInUserName($_SESSION["sess_userid"]); $to = $email; $subject = "Product Information by " . SITE_NAME; $mailcontent = readEmailTemplate('mail_friend'); $mailcontent = str_replace('[name]', $name, $mailcontent); $mailcontent = str_replace('[product_url]', $product_url, $mailcontent); //$mailcontent = str_replace('[user_name]',$userName,$mailcontent); $from = "From: " . SITE_EMAIL . "\n"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: " . SITE_EMAIL . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Reply-To: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Return-Path: " . SITE_NAME . "<" . SITE_EMAIL . ">" . "\r\n"; $headers .= "Organization: " . SITE_NAME . "\r\n"; $mailcontent = nl2br($mailcontent); $mail_send_details = '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Email Friend</title>