func.eMailing.php 30.1 KB

Edit Raw Blame History

<?

function sendMail ($to, $nameto, $from, $namefrom, $subject, $mailMessage, $files='')
{
    // Âàø êëþ÷ äîñòóïà ê API (èç Ëè÷íîãî Êàáèíåòà)
    $api_key = "5xaiqb1pnuu8jsun4rwxhow4shj11e55zdhjf5do";

    // Ïàðàìåòðû ñîîáùåíèÿ
    // Åñëè ñêðèïò â êîäèðîâêå UTF-8, íå èñïîëüçóéòå iconv
    $email_from_name = "ExtremStyle";
    $email_from_email = "extremstyle.ua@eltrade.com.ua";
    $email_to = $to;
    $email_body = urlencode (iconv ('cp1251', 'utf-8', $mailMessage));

    $subject = iconv ('cp1251', 'utf-8', $subject);

    $email_body = iconv ('cp1251', 'utf-8', $mailMessage);

    $email_subject = $subject;
    $list_id = "1774752";

    // Ñîçäà¸ì POST-çàïðîñ
    $POST = array (
        'api_key' => $api_key,
        'email' => $email_to,
        'sender_name' => $email_from_name,
        'sender_email' => $email_from_email,
        'subject' => $email_subject,
        'body' => $email_body,
        'list_id' => $list_id
    );

    // Óñòàíàâëèâàåì ñîåäèíåíèå
    $ch = curl_init ();
    curl_setopt ($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt ($ch, CURLOPT_POST, 1);
    curl_setopt ($ch, CURLOPT_POSTFIELDS, $POST);
    curl_setopt ($ch, CURLOPT_TIMEOUT, 10);
    curl_setopt ($ch, CURLOPT_URL, 'http://api.unisender.com/ru/api/sendEmail?format=json');
    $result = curl_exec ($ch);

    if ($result)
    {
        // Ðàñêîäèðóåì îòâåò API-ñåðâåðà
        $jsonObj = json_decode ($result);

        if (null === $jsonObj)
        {
            // Îøèáêà â ïîëó÷åííîì îòâåòå
            echo "Invalid JSON";
        }
        elseif (! empty ($jsonObj->error))
        {
            // Îøèáêà îòïðàâêè ñîîáùåíèÿ
            echo "An error occured: " . $jsonObj->error . "(code: " . $jsonObj->code . ")";
        }
        else
        {
            // Ñîîáùåíèå óñïåøíî îòïðàâëåíî
            echo "Email message is sent. Message id " . $jsonObj->result->email_id;
        }
    }
    else
    {
        // Îøèáêà ñîåäèíåíèÿ ñ API-ñåðâåðîì
        echo "API access error";
    }
}

function sendMailPhp ($to, $nameto, $from, $namefrom, $subject, $mailMessage, $files='') { // $files = array('archive.zip' => file_get_contents('archive.zip')
    if (is_array ($files) && (! empty ($files)))
    {
        $ContentType = "Content-Type: multipart/mixed;";
    }
    else
    {
        $ContentType = "Content-Type: multipart/alternative;";
    }

    $boundary = strtoupper(md5(uniqid(rand())))."";

    $headers  = "Date: ".date('Y-m-d H:i:s')." +0200 \r\n";
    $headers .= "From: ".MimeEncode($namefrom)." <$from> \r\n";
    $headers .= "Return-Path: ".MimeEncode($namefrom)." <$from>\r\n";
    $headers .= "MIME-Version: 1.0" . "\r\n";
	$ContentType = "Content-type: text/html;";
    $headers .= "$ContentType boundary=\"{$boundary}\"; \r\n";
    $headers.=  "Content-type: text/html; charset=\"windows-1251\";\r\n\r\n";
    $body =  "--{$boundary}\r\n";
    $body.=  "Content-type: text/html; charset=\"windows-1251\";\r\n\r\n";
    $body.=  $mailMessage."\r\n";
    $headers = "From: ".MimeEncode($namefrom)." <$from>\r\n X-Mailer: PHP/" . phpversion();

    // Äëÿ âëîæåíèõ ôàéëîâ
    if ((is_array ($files)) && (! empty ($files)))
    {
        foreach ($files as $filename => $filecontent)
        {
           $body .= "--{$boundary}\r\n";
           $body .= "Content-Type: application/octet-stream;name=\"".$filename."\" \r\n";
           $body .= "Content-Transfer-Encoding:base64 \r\n";
           $body .= "Content-Disposition:attachment;filename=\"".$filename."\" \r\n";
           $body .= chunk_split(base64_encode($filecontent));
        }
    }

    $body .= "\r\n--{$boundary}--\r\n";

	mail(" ".MimeEncode($nameto)." <$to>", MimeEncode($subject), $body, $headers);
}

function MimeEncode ($str, $data_charset = 'windows-1251', $send_charset = 'windows-1251')
{
    if (! empty ($str))
    {
        if ($data_charset != $send_charset)
        {
            $str = iconv ($data_charset, $send_charset, $str);
        }

        return '=?' . $send_charset . '?B?' . base64_encode ($str) . '?=';
    }
    else
    {
        return '';
    }
}

function eMailing ($action, $user_id='',$order_id='',$discont_id='')
{
    switch ($action)
    {
        // =====================
        // ==== ðåãèñòðàöèÿ ====
        // =====================
        case 'reg':

            global $_POST;

            $sql = "
                SELECT * 
                FROM zlo_users 
                WHERE email = '".$_POST['form']['email']."'
            ";

            $result = mysql_query ($sql) or die (mysql_error ());
            if (mysql_affected_rows () != 0)
            {
                $user = mysql_fetch_assoc ($result);
            }

            $subject = "Ðåãèñòðàöèÿ íà ñàéòå ïîëüçîâàòåëÿ : ".$user['username'];

            $mail = "

            Çäðàâñòâóéòå, ".$user['username']." ! <br/><br/>

            Âû óñïåøíî çàðåãèñòðèðîâàëèñü â íàøåì ìàãàçèíå <br/>
			äëÿ ïîäòâåðæäåíèÿ ðåãèñòðàöèè ïåðåéäèòå ïî ññûëêå: <a href='http://extremstyle.ua/account/active/?hash=".$user['hash']."'>http://extremstyle.ua/?hash=".$user['hash']."</a>
            <br/>Äëÿ âõîäà â <a href='http://extremstyle.ua/'>ëè÷íûé êàáèíåò</a> èñïîëüçóéòå ñëåäóþùèå äàííûå:
            <br/>
            <br/>
            <blockquote>
              <blockquote>
                            ËÎÃÈÍ: ".$user['email']." <br/>
                            ÏÀÐÎËÜ: ".$user['pass']."
              </blockquote>
            </blockquote>				
			<br/>
            <br/>";

            ///////////<b>Àêòèâàöèÿ äèñêîíòíîé êàðòû:</b> http://extremstyle.ua/account/activation/?uid=".$user['id']."&id=".$discont_id."
            $mail .= "
            Æåëàåì ïðèÿòíûõ ïîêóïîê!	<br/><br/>";

            if ($user['group'] != 1)
            {
                // ïèñüìî ðåãèñòðàöèè
                sendMail ($user['email'], $user['username'], 'registration@extremstyle.ua', 'extremstyle.ua', $subject, $mail);

                // ïèñüìî êóïîí
                eMailing ('kupon', $user['id']);
            }

            // Ðàññûëêà óâåäîìëåíèé àäìèíàì
            $sql = "SELECT * FROM zlo_admin WHERE email!='' ";
            $result = mysql_query ($sql) or die (mysql_error ());
            while ($admin = mysql_fetch_assoc ($result))
            {
                sendMail ($admin['email'], $admin['username'], 'registration@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
            }

            break;

        // ===============
        // ==== Êóïîí ====
        // ===============
        case 'kupon':

            // ïîëüçîâàòåëü
            $sql = '
                SELECT * 
                FROM zlo_users 
                WHERE `id` = '.(int)$user_id.' 
                LIMIT 1
            ';

            $result = mysql_query ($sql) or die (mysql_error ());
            if (mysql_affected_rows () != 0)
            {
                $user = mysql_fetch_assoc ($result);

                // êóïîí
                $sql = '
                    SELECT `card`, `active`, `id` 
                    FROM `card` 
                    WHERE `user_id` = '.$user['id'].' 
                    LIMIT 1
                ';

                $result = mysql_query ($sql) or die (mysql_error ());
                if (mysql_affected_rows () != 0)
                {
                    $card = mysql_fetch_assoc ($result);

                    $to      = $user['email'];
                    $subject = 'Êëóáíàÿ êàðòà "Ýêñòðåì Ñòàéë"';

                    // ïèñüìî
                    ob_start();
                    include_once $_SERVER['DOCUMENT_ROOT'].'/email/discont.php';
                    $message = ob_get_clean();

                    // îòñûëàåì
                    sendMail ($to, $to, "extremstyle.ua@eltrade.com.ua", "ExtremStyle", $subject, $message);
                }
            }

            break;

        // =====================
        // ==== Íîâûé çàêàç ====
        // =====================
        case 'order-new':

            global $lang;

            // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
            $sql = "SELECT * FROM zlo_users WHERE id=$user_id";
            $result = mysql_query($sql) or die(mysql_error());
            $user=mysql_fetch_assoc($result);

            // óçíàåì âñå äàííûå î çàêàçå
            $sql = "SELECT * FROM catalogs_orders WHERE `id`=$order_id";
            $result = mysql_query($sql) or die(mysql_error());
            $order=mysql_fetch_assoc($result);


            $tel = str_replace("+","",$order['phone']);

            if(trim($tel)=='') $tel = $user['tel'];

            //echo $tel;
            //exit;
            //$tel = "380969670748";
            sendSMS($tel,"Vash zakaz Prinyat. # zakaza:".$order_id.". V blijayshee vremya menedjer svyajetsya s Vami. (044) 428-65-38; (050) 382-03-00");


            $subject = "Íîâûé çàêàç íà ñàéòå extremstyle.ua - ïîëüçîâàòåëü : ". $user['username'];

            // Ïîäêëþ÷àåì ñòèëè
            $sql = "
            SELECT distinct s3.id, s5.name as fio, s4.translit as rub_name, s3 . *
            FROM catalogs_orders_products s1
                LEFT JOIN catalogs_modifications s2 ON s2.id = s1.product_id
                LEFT JOIN catalogs_products s3 ON s3.id = s2.product_id
                LEFT JOIN catalogs_rubrics s4 ON s4.id = s3.rubric_id 
                LEFT JOIN catalogs_orders s5 ON s5.id = s1.order_id 
            WHERE s1.order_id = '".$order_id."';";
            $result = mysql_query($sql) or die(mysql_error());
			$datas = "";
            while ($product2 = mysql_fetch_assoc($result)){
				$datas .= "<table width=\"300px\">
                <tr>
                <td>
                <a href=\"https://plus.google.com/share?url=http://extremstyle.ua/".$product2['rub_name']."-catalogs/".$product2['translit']."-".$product2['id']."/?title_as=".base64_encode($product2['fio']." êóïèë(à) ".$product2['name'])."\" onclick=\"javascript:window.open(this.href,
                  '', 'menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600');return false;\"><img
                  src=\"http://extremstyle.ua/img/32/googleplus_32.png\" alt=\"Share on Google+\" width=\"32px\" height=\"32px\"/></a>
                </td>
                <td>
                <a href=\"http://vkontakte.ru/share.php?url=http://extremstyle.ua/".$product2['rub_name']."-catalogs/".$product2['translit']."-".$product2['id']."/?title_as=".base64_encode($product2['fio']." êóïèë(à) ".$product2['name'])."\" onclick=\"javascript:window.open(this.href,
                  '', 'menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600');return false;\">
                <img
                  src=\"http://extremstyle.ua/img/32/vkontakte_32.png\" alt=\"Share on VK\" width=\"32px\" height=\"32px\"/>
                </a>
                
                </td>
                <td><a href=\"http://www.facebook.com/sharer.php?u=http://extremstyle.ua/".$product2['rub_name']."-catalogs/".$product2['translit']."-".$product2['id']."/?title_as=".base64_encode($product2['fio']." êóïèë(à) ".$product2['name'])."\" onclick=\"javascript:window.open(this.href,
                  '', 'menubar=no,toolbar=no,resizable=yes,scrollbars=yes,height=600,width=600');return false;\">
                <img
                  src=\"http://extremstyle.ua/img/32/facebook_32.png\" alt=\"Share on FB\" width=\"32px\" height=\"32px\"/>
                </a></td>
                </tr>
                </table>";
			}


            $mail= '

            <html>
            <meta content="text/html; charset=windows-1251" http-equiv="content-type" />
            <img src="http://extremstyle.ua/p301.png">
            <br/>
            <br/>            
			Çäðàâñòâóéòå,'. $user['username'].'!<br/><br/>
			<b>Âàøà çàÿâêà ïðèíÿòà.<br/>
            Äëÿ ïîäòâåðæäåíèÿ çàêàçà íàø ìåíåäæåð ñâÿæåòñÿ ñ Âàìè â áëèæàéøåå âðåìÿ.</b><br/><br/>';

            if(!@ShowOrder($user_id, $order_id, $mail)) return false;

            $mail= ShowOrder($user_id, $order_id, $mail);

			$mail.=" 
			Ñòîèìîñòü äîñòàâêè:<br />
            - åñëè ñóììà çàêàçà ìåíüøå 1000 ãðí. - äîñòàâêà ñòîèò 30 èëè 50 ãðí. â çàâèñèìîñòè îò ãàáàðèòîâ.<br />
            - åñëè ñóììà çàêàçà ðàâíà èëè áîëüøå 1000 ãðí. - äîñòàâêà ïî Êèåâó áåñïëàòíàÿ.<br />
            <br />
            Ïðè çàêàçå íà ñóììó áîëåå 1000 ãðí - äîñòàâêà ïî Óêðàèíå íà ñêëàä Íîâîé Ïî÷òû áåñïëàòíàÿ (êðîìå íàëîæåííîãî ïëàòåæà, àêöèîííûõ òîâàðîâ è òîâàðîâ ñî ñêèäêîé).
			<br /><br />
			Ïðèñîåäèíÿéòåñü ê íàì:
			".$datas."

			<br />
			Ñ óâàæåíèåì, êîìàíäà <font color='green'>Extremstyle.ua</font><br /><br />
			Äàííîå ïèñüìî ñîçäàíî àâòîìàòè÷åñêè, ïîæàëóéñòà íå îòâå÷àéòå íà íåãî.";

            if ($user['group']!=1) {
                sendMail ($user['email'], $user['username'], 'order@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
            }
            // Ðàññûëêà óâåäîìëåíèé àäìèíàì
            $sql = "SELECT * FROM zlo_admin WHERE email!='' ";
            $result = mysql_query($sql) or die(mysql_error());
            while ($admin=mysql_fetch_assoc($result)) {
                sendMail ($admin['email'], $admin['username'], 'order@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
            }

            eMailing('xml', $user_id, $order_id);

        break;

        // =======================
        // ==== Çàêàç èçìåíåí ====
        // =======================
        case 'order-changed':

            global $lang;

            // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
            $sql = "SELECT * FROM zlo_users WHERE id=$user_id";
            $result = mysql_query($sql) or die(mysql_error());
            $user=mysql_fetch_assoc($result);

            // óçíàåì âñå äàííûå î çàêàçå
            $sql = "SELECT * FROM catalogs_orders WHERE `id`=$order_id";
            $result = mysql_query($sql) or die(mysql_error());
            $order=mysql_fetch_assoc($result);

            $subject = "Îáíîâëåííûé çàêàç íà ñàéòå extremstyle.ua - ïîëüçîâàòåëü : ". $user['username'];

            $mail = "

            Çäðàâñòâóéòå,". $user['username']."!<br/><br/>

            Âàø Îáíîâëåííûé çàêàç";

            $mail=ShowOrder($user_id, $order_id, $mail);

            $mail.="Íàø ìåíåäæåð ñâÿæåòñÿ ñ Âàìè â áëèæàéøåå âðåìÿ.<br/>
            Äåòàëüíóþ èíôîðìàöèþ è ñîñòîÿíèå çàêàçà Âû ìîæåòå ïðîâåðèòü â http://extremstyle.ua/account/ <br/><br/>

            Ñïàñèáî, ÷òî âûáðàëè íàñ! <br/><br/>

            ";

            if ($user['group']!=1) {
                sendMail ($user['email'], $user['username'], 'order@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
            }
            // Ðàññûëêà óâåäîìëåíèé àäìèíàì
            $sql = "SELECT * FROM zlo_admin WHERE email!='' ";
            $result = mysql_query($sql) or die(mysql_error());
            while ($admin=mysql_fetch_assoc($result)) {
                sendMail ($admin['email'], $admin['username'], 'order@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
            }

            break;

        // =============
        // ==== xml ====
        // =============
        case 'xml':

            // Äàííûå î ïîëüçîâàòåëå
            $sql = "SELECT u.*, u.id as user_id FROM zlo_users as u 
                    WHERE u.id=$user_id";
            $result = mysql_query($sql) or die(mysql_error());
            $user=mysql_fetch_assoc($result);

            // Äàííûå î çàêàçå
            $sql = "SELECT o.*,o.id as order_id, o.adress as address, d.title as delivery_title FROM catalogs_orders as o
                    LEFT JOIN zlo_users as u on u.id=o.user_id
                    LEFT JOIN zlo_book_delivery as d ON o.delivery=d.id
                    WHERE o.id='$order_id'";
            $result = mysql_query($sql) or die(mysql_error());
            $order=mysql_fetch_assoc($result);

            // Äàííûå î òîâàðå
            $sql = "SELECT m.*, m.id as mod_id, p.* from catalogs_modifications as m
                    LEFT JOIN catalogs_products as p ON p.id=m.product_id 
                    LEFT JOIN catalogs_orders_products as op ON op.order_id=$order_id 
                    WHERE m.id= op.product_id ";
            $result = mysql_query($sql) or die(mysql_error());

                $xml  = "<?xml version='1.0' encoding='windows-1251' ?>\n";
                $xml .= "<Order orderNum='".$order['mktime']."'>\n";

                while ($item=mysql_fetch_assoc($result)) {

                $xml .= "   <OrderItem ID='".$item['code']."'>\n";
                $xml .= "       <ProductName>".$item['name']."</ProductName>\n";
                $xml .= "       <Size>".$item['size']."</Size>\n";
                $xml .= "       <Color>".$item['color']."</Color>\n";
                $xml .= "       <Price>".$item['cine']."</Price>\n";
                $xml .= "       <Count>".$item['count']."</Count>\n";
                $xml .= "   </OrderItem>\n";

                }
                $xml .= "   <CustomerInfo>\n";
                $xml .= "       <Name>".$user['username']."</Name>\n";
                $xml .= "       <Mobile>".$user['tel']."</Mobile>\n";
                $xml .= "       <Email>".$user['email']."</Email>\n";
                $xml .= "   </CustomerInfo>\n";
                $xml .= "   <DeliveryInfo>\n";
                $xml .= "       <City>Óêðàèíà</City>\n";
                $xml .= "       <Address>".$order['address']."</Address>\n";
                $xml .= "       <DeliveryType>".$order['delivery_title']."</DeliveryType>\n";
                $xml .= "   </DeliveryInfo>\n";
                $xml .= "   <Comment>".$order['comment']."</Comment>\n";
                $xml .= "</Order>\n";

                // ======== ñîçäàíèå xml-àðõèâà =======
                // Ðàçáèâàåì íà ãîä è ìåñÿö çàêàçà
                $dateFromDate=ExtractDate((date('Y-m-d H:i:s',$order['mktime'])));

                // Ñîáèðàåì ïóòü è ôàéë
                $filePath = "./xml/".$dateFromDate[0]."/".$dateFromDate[1]."/";
                $fileName = "order_".$order['order_id'].".xml";

                // Ñîçäàåì ïàïêó
                    $root=$_SERVER['DOCUMENT_ROOT'];

                if (!is_dir($root."/xml/".$dateFromDate[0])) {
                    mkdir($root."/xml/".$dateFromDate[0], 0777, true);
                    chmod($root."/xml/".$dateFromDate[0], 0777);
                }

                if (!is_dir($root."/xml/".$dateFromDate[0]."/".$dateFromDate[1])) {
                    mkdir($root."/xml/".$dateFromDate[0]."/".$dateFromDate[1], 0777, true);
                    chmod($root."/xml/".$dateFromDate[0]."/".$dateFromDate[1], 0777);
                }

                // Îòêðûòü ôàéë
                $fh = fopen($filePath.$fileName, "w+");

                // Çàïèñàòü ñîäåðæèìîå â ôàéë
                fwrite($fh, $xml);

                // Çàêðûòü ôàéë
                fclose($fh);

                $mail="<p>Çàêàç <b>¹ $order_id</b></p>
                       Ïîëüçîâàòåëÿ: {$user['username']}";
                
                $files = array($fileName => file_get_contents($filePath.$fileName));

            // Ðàññûëêà óâåäîìëåíèé àäìèíàì
            $sql = "SELECT * FROM zlo_admin WHERE email!='' ";
            $result = mysql_query($sql) or die(mysql_error());
            while ($admin=mysql_fetch_assoc($result)) {
                sendMail ($admin['email'], $admin['username'], 'order@extremstyle.ua', 'extremstyle.ua', "XML Çàêàç ¹ {$order_id} Ïîëüçîâàòåëÿ: {$user['username']}", $mail, $files);
            }
            
        break;
        
        // ============================
        // ==== Íàïîìèíàíèå ïàðîëÿ ====
        // ============================
        
        case 'remind': 

            // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
            $sql = "SELECT * FROM zlo_users as u WHERE u.id=$user_id";
            $result = mysql_query($sql) or die(mysql_error());
            $user=mysql_fetch_assoc($result);
            
            $subject = "Íàïîìèíàíèå ïàðîëÿ ïîëüçîâàòåëÿ : ".$user['username'];

            $mail = "

            Çäðàâñòâóéòå, ".$user['username']." !
            <br/>
            <br/>
            Äëÿ âõîäà â ëè÷íûé êàáèíåò èñïîëüçóéòå ñëåäóþùèå äàííûå:
            <br/>
            <br/>
            <blockquote>
              <blockquote>

                            ËÎÃÈÍ: ".$user['email']."<br/>
                            ÏÀÐÎËÜ: ".$user['pass']."
              </blockquote>
            </blockquote>
            <br/>
            <br/>
            <br/>
            Æåëàåì ïðèÿòíûõ ïîêóïîê!<br/>
            <br/>
            <br/>
            email:info@extremstyle.ua";	
            
            sendMail ($user['email'], $user['username'], 'remind@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
            
            break;

        // =======================
        // ==== MessageToUser ====
        // =======================

        case 'MessageToUser':

            // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
            $sql = "SELECT u.*, u.id as user_id FROM zlo_users as u
                    WHERE u.id=$user_id";
            $result = mysql_query($sql) or die(mysql_error());
            $user=mysql_fetch_assoc($result);
            
            $subject = "Óâåäîìëåíèå î ïîëó÷åíèè ïèñüìà îò àäìèíèñòðàöèè extremstyle.ua";

            $mail = "

            Çäðàâñòâóéòå, ".$user['username']." !
            <br/>
            <br/>
               <blockquote>
                  <blockquote>
                    Âû ïîëó÷èëè ïèñüìî îò àäìèíèñòðàöèè ñàéòà extremstyle.ua
                  </blockquote>
                </blockquote>
            <br/>
            <br/>

            Äëÿ ïðî÷åíèÿ ïåðåéäèòå â Âàø ëè÷íûé êàáèíåò ïî <a href='http://extremstyle.ua/'>ññûëêå</a>";	
            
            sendMail ($user['email'], $user['username'], 'mail-notify@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
            
            break;

        // ========================
        // ==== MessageToAdmin ====
        // ========================

        case 'MessageToAdmin':

            // óçíàåì âñå äàííûå î ïîëüçîâàòåëå
            $sql = "SELECT u.*, u.id as user_id FROM zlo_users as u
                    WHERE u.id=$user_id";
            $result = mysql_query($sql) or die(mysql_error());
            $user=mysql_fetch_assoc($result);
            
            // Âûâîä message
            $sql = "SELECT text FROM zlo_users_message WHERE `from` = '$user_id' ORDER BY `date` DESC LIMIT 1";
            $result = mysql_query($sql) or die(mysql_error());
            $message=mysql_fetch_assoc($result);	
            
            $subject = "Óâåäîìëåíèå î ïîëó÷åíèè ïèñüìà îò ïîëüçîâàòåëÿ ".$user['username']." ";

            $mail = "

            Çäðàâñòâóéòå !
            <br/>
            <br/>
               <blockquote>
                  <blockquote>
                    Âû ïîëó÷èëè ïèñüìî îò ".$user['username']."
                  </blockquote>
                </blockquote>
            <br/>
            ".$user['username']." íàïèñàë(à):
            <pre>
            ".$message['text']."
            </pre>";	
            
            // Ðàññûëêà óâåäîìëåíèé àäìèíàì
            $sql = "SELECT * FROM zlo_admin WHERE email!='' ";
            $result = mysql_query($sql) or die(mysql_error());
            while ($admin=mysql_fetch_assoc($result)) {
                sendMail ($admin['email'], $admin['username'], 'mail-notify@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
            }
            
            break;
            
    }
}

/////////////////////////////////////////////////////////////////////////////////

function ShowOrder($user_id, $order_id, $mail) {

            $sql = "SELECT o.*,u.*, o.id as order_id, o.`mktime` as order_date".((@$_SESSION['id'])?", o.address as address_o":"")." FROM catalogs_orders as o
                    RIGHT JOIN zlo_users as u on u.id=o.user_id
                    WHERE o.id='$order_id'";
            $result = mysql_query($sql) or die(mysql_error());	

//if(trim($order['total'])<=0) return false;

            if (mysql_affected_rows()!=0) {
                $order=mysql_fetch_assoc($result);

if(trim($order['address_o'])!='') $order['address'] = $order['address_o'];


            if(trim($order['total'])<=0) return false;
			
				$mail.="Çàÿâêå ïðèñâîåí íîìåð: ".$order['order_id']."<br />
						Áóäåì ðàäû îòâåòèòü íà âàøè âîïðîñû ïî òåëåôîíàì:<br /> (044) 428-65-38; (050) 382-03-00<br /><br />";
                /*
				$mail.="<div class='orders'>";
                
                $mail.="
                <fieldset id='order-info' style='width:500px;'>
                <legend>Çàêàç #".$order['order_id']." Cóììà: ".$order['total']." ãðí.</legend> 	
                <table class='order-info'>
                    <tr>
                        <td>Äàòà:</td>
                        <td class=info>".date('Y-m-d H:i:s',$order['order_date'])."</td>
                    </tr>
                    
                    <tr>
                        <td>Êëèåíò:</td>
                        <td class=info>".$order['username']."&nbsp;</td>
                    </tr>
                    
                    <tr>
                        <td>Òåë:</td>
                        <td class=info>".$order['tel']."&nbsp;</td>
                    </tr>

                    <tr>
                        <td>Ãîðîä:</td>
                        <td class=info>".$order['city']."&nbsp;</td>
                    </tr>
					
                    <tr>
                        <td>Àäðåñ:</td>
                        <td class=info>".$order['address']."&nbsp;</td>
                    </tr>
                    
                    <tr>
                        <td>Äîñòàâêà:</td>
                        <td class=info>".viewBook('zlo_book_delivery', $order['delivery'], 'id', 'title')."&nbsp;</td>
                    </tr>

                    <tr>
                        <td>Èíôî:</td>
                        <td class=info> ".$order['comment']."&nbsp;</td>
                    </tr>
                    "; 
                    
                $mail.="
                </fieldset>
                </table>
                
                <p></p><p></p>
                ";*/
                
                
                // Òàáëèöà òîâàðîâ

                $sql3 = "SELECT * FROM catalogs_orders_products
                         WHERE `order_id`='".$order['order_id']."' ";
                $result3 = mysql_query($sql3) or die(mysql_error());
                if (mysql_affected_rows()!=0) { $i=0;
                
                $mail.="<img src='http://extremstyle.ua/img/hr_m.jpg' border='0' />
                    <div class='order-details'>
                    <b>Âàø çàêàç:</b>";
                $mail.="<table>";
                      /*$mail.="<tr>
                        <td>¹</td>
                        <td>ôîòî</td>
						<td>Êîä</td>
                        <td>Áðåíä</td>
                        <td>Íàçâàíèå</td>
                        <td>Êîë.</td>
                        <td>Öåíà</td>
                        <td>Ñóììà</td>
                        <td></td>
                      </tr>";*/
                while ($item_id=mysql_fetch_assoc($result3)) { $i++;
                
                    $sql4 = "select *,catalogs_modifications.pic as m_pic from catalogs_modifications 
                            left join catalogs_products 
                            on catalogs_products.id=catalogs_modifications.product_id 
                            where catalogs_modifications.id='".$item_id['product_id']."' ";
                    $result4 = mysql_query($sql4) or die(mysql_error());
                    if (mysql_affected_rows()!=0) {	
                    while ($item=mysql_fetch_assoc($result4)) { 

                    /* $mail.="<tr>
                            <td>$i .</td> 
							<td><img src='http://extremstyle.ua/uploaded/pic/catalogs/modifications/".$item['m_pic']."' border='0' /></td>
                            <td>".$item['code']."</td>          
                            <td>".viewBook('catalogs_brends', $item['brend_id'], 'id', 'name')."</td>
                            <td><a href='http://extremstyle.ua/catalogs/".$item['rubric_id'].'/t'.$item['id']."/' target='_new'>".$item['name']."</a></td>
                            <td>".$item_id['count']."</td>
                            <td>".$item['cine']."</td>  
                            <td>".($item['cine']*$item_id['count'])."</td>
                            <td>";

                       $mail.="</td>
                          </tr>";*/
						  $mail.="<tr>
						  <td><img src='http://extremstyle.ua/uploaded/pic/catalogs/modifications/".$item['m_pic']."' border='0' /></td>
						  <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
						  <td width='200'>
							<a href='http://extremstyle.ua/catalogs/".$item['rubric_id'].'/t'.$item['id']."/' target='_new' style='font-size:18px;color:#589a42;'>".$item['name']."</a><br />
						  <b>".($item_id['product_cine_id']*$item_id['count'])."</b> ãðí.<br />
						  Êîë-âî: ".$item_id['count']."
						  </td>
						  <td width='200'><b>
						  Êîä: ".$item['code']."<br />
						  Ðàçìåð: ".$item['size']."<br />
						  Öâåò: ".$item['color']."<br />
						  </b></td>
						  </tr>";

                        }          
                    
                    }
                }
                
                $mail.="</table>
                   </div><img src='http://extremstyle.ua/img/hr_mb.jpg' border='0' />";
                   
                $mail.="<br />
				Ìîáèëüíûé òåëåôîí: ".$order['phone']."<br />
				Àäðåñ äîñòàâêè: ".$order['adress']."<br />
				Ñïîñîá îïëàòû: ".$order['payment']."<br />
				Ñïîñîá äîñòàâêè: ".viewBook('zlo_book_delivery', $order['delivery'], 'id', 'title')."<br />
				Ñòîèìîñòü çàêàçà: ".$order['total']."<br /><br />
				";
				
				
                }
            
            }
            
            $dostavka=viewBook('zlo_book_delivery', $order['delivery'], 'id', 'value');//Ñòîèìîñòü äîñòàâêè: UAH ".$dostavka."<br/>
            $dostavka=0;
            
          /*  $mail.= "
            <br/><br/>
                    Îáùàÿ ñóììà çàêàçà: UAH ".($order['total']+$dostavka)."
            <br/><br/>";*/
            
    return $mail;
}
?>