$email_to = $_POST['email_to']; $message = $_POST['message']; /// Получаем название товара $sql = "SELECT `name` FROM `" . PRODUCTS_TABLE . "` WHERE productID = '{$offer_id}'"; $result = db_query($sql); $offer = db_fetch_assoc($result); /// init Smarty require_once "core/smarty/smarty.class.php"; $smarty = new Smarty(); /// for e-mails $smarty->template_dir = "core/tpl/email"; $smarty->assign('offer_id', $offer_id); $smarty->assign('offer_name', $offer['name']); $smarty->assign('name_from', $name_from); $smarty->assign('name_to', $name_to); $smarty->assign('email_from', $email_from); $smarty->assign('message', $message); $subject = "{$name_from} хочет получить от Вас подарок"; $body = mysql_escape_string($smarty->fetch('gift_mail.tpl')); /// Заносим данные в таблицу разсылки $sql = "INSERT INTO `" . SUBSCIBE_QUEUE_TABLE . "` SET\n `email_to` = '{$email_to}' ,\n `email_from` = '{$email_from}' ,\n `subject` = '{$subject}',\n `body` = '{$body}'"; // die($sql); $res = db_query($sql); /// Заносим данные в таблицу намеков $sql = "INSERT INTO `" . GIFT_HINTS_TABLE . "` SET\n `email_to` = '" . mysql_escape_string($email_to) . "' ,\n `email_from` = '" . mysql_escape_string($email_from) . "' ,\n `name_to` = '" . mysql_escape_string($name_to) . "' ,\n `name_from` = '" . mysql_escape_string($name_from) . "' ,\n `message` = '" . mysql_escape_string($message) . "',\n `offer_id` = '{$offer_id}',\n `created` = NOW()"; // die($sql); $res = db_query($sql); /// Подписываем человека на новости subscrAddUnRegisteredCustomerEmail($email_from); exit((string) $res["resource"]); }
} if (!file_exists($_FILES['fSubscribersListFile']['tmp_name'])) { $UploadError = true; break; } } while (0); if ($UploadError) { $_SESSION['SUBSCRIBE_MESSAGE'] = array('Message' => ADMIN_SUBSCRIPTIONS_ERROR_UPLOAD_SUBSCRLIST, 'MessageCode' => 2); break; } $FileContents = file($_FILES['fSubscribersListFile']['tmp_name']); $emailCounter = 0; foreach ($FileContents as $_email) { $_email = trim($_email); if (subscrVerifyEmailAddress($_email)) { subscrAddUnRegisteredCustomerEmail($_email); $emailCounter++; } } if (!$emailCounter) { $_SESSION['SUBSCRIBE_MESSAGE'] = array('Message' => ADMIN_SUBSCRIPTIONS_ERROR_UPLOAD_NO_EMAILS, 'MessageCode' => 2); break; } else { $_SESSION['SUBSCRIBE_MESSAGE'] = array('Message' => str_replace('{*EMAILS_NUMBER*}', $emailCounter, ADMIN_SUBSCRIPTIONS_OK_UPLOAD_SUBSCRLIST), 'MessageCode' => 1); } break; case 'fEraseSubscribersList': $CountRow = 0; $Subscriptions = subscrGetAllSubscriber('', $CountRow); foreach ($Subscriptions as $_Subscription) { subscrUnsubscribeSubscriberByEmail(base64_encode($_Subscription['Email']));