<?


function sendMail ($to, $nameto, $from, $namefrom, $subject, $mailMessage, $files='') { // $files = array('archive.zip' => 


// Âàø êëþ÷ äîñòóïà ê 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";
}


//if($to=='ldit@list.ru') exit;


}


function sendMail3 ($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/'>ëè÷íûé êàáèíåò</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);
            }
            
            // Ðàññûëêà óâåäîìëåíèé àäìèíàì
            $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);
            }
            

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


$result2 = mysql_query("SELECT * FROM `card` WHERE `card`='".$discont_id."' ORDER BY `card` DESC LIMIT 1;") or die(mysql_error());
$cc = mysql_fetch_assoc($result2);
$to      = $user['email'];
$subject = 'Àêöèîííûé êóïîí ExtremStyle';
$message = <<<HTML
<img src="http://extremstyle.ua/p301.png">
<br/>
<br/>

<table cellspacing=0 cellpadding=0 style="border:1px dashed #000;border-radius:10px;padding:10px;width:660px;margin-left:4px;">
<tr>
<td align="left">

Òîëüêî äëÿ çàðåãèñòðèðîâàííûõ êëèåíòîâ äî 15.04.13 äåéñòâóåò àêöèÿ ñêèäêà íà ñêèäêó íà âåñü çèìíèé àññîðòèìåíò òîâàðîâ. Óñëîâèÿ àêöèè:
Åñëè Âû óæå çàðåãèñòðèðîâàíû íà ñàéòå, ðàñïå÷àòàéòå êëóáíóþ êàðòó è ïîëó÷èòå <b style="color:red;">ñêèäêó 15% äîïîëíèòåëüíî ê óæå äåéñòâóþùåé ñêèäêå</b>.<br/><br/>
Åñëè Âû åùå íå çàðåãèñòðèðîâàíû, òî ìîæåòå ñäåëàòü ýòî ïðÿìî ñåé÷àñ.

Êëóáíàÿ êàðòà áóäåò àâòîìàòè÷åñêè îòïðàâëåíà íà ýëåêòðîííûé àäðåñ, óêàçàííûé Âàìè ïðè ðåãèñòðàöèè è Âû ìîæåòå åå ðàñïå÷àòàòü íà
ëþáîì äîñòóïíîì ïðèíòåðå.<br/><br/>

Êëóáíàÿ êàðòà èçûìàåòñÿ ïðè îñóùåñòâëåíèè ïîêóïêè. Íî Âû ìîæåòå ðàñïå÷àòàòü êëóáíóþ êàðòó ñíîâà è ñíîâà è èñïîëüçîâàòü åå òàêèì æå
îáðàçîì äëÿ ñëåäóþùèõ ïîêóïîê íà âåñü ïåðèîä äåéñòâèÿ àêöèè.<br/><br/>

Êèåâ, óë Ãëóáî÷èöêàÿ, 53<br/>
Äíåïðîïåòðîâñê, óë. Íàáåðåæíàÿ Ïîáåäû, 118<br/>
Îäåññà, óë. Êðàñíîâà,12<br/>
Ëüâîâ, óë. Ñòðûéñêàÿ, 30 ÒÐÖ "King Cross Leopolis"<br/>
Õàðüêîâ, ïð. Ëåíèíà, 45/2. Cò.ìåòðî 23 àâãóñòà<br/>
Èíòåðíåò Ìàãàçèí<br/><br/>
<i><b style="color:red;">*</b>Àêöèÿ íå äåéñòâóåò â ìàãàçèíàõ &laquo;Ýêñòðåì Ñòàéë&raquo;, ðàñïîëîæåííûõ íà òåððèòîðèè ÃÊ &laquo;Áóêîâåëü&raquo;</i><br/><br/>
</td>
</tr>
</table>
<br/>


<table cellspacing=0 cellpadding=0 style="border:1px dashed #000;border-radius:10px;padding:10px;width:660px;margin-left:4px;">
<tr>
<td>
<table>
<tr>
<td rowspan="2">
<img src="http://extremstyle.ua/img/kvlogo.png" />
</td>
<td align="center" style="padding:10px;">
<div style="font-size:24px;border:1px dashed #000;padding:10px;border-radius:10px;">{$cc['card']}</div>
</td>
</tr>
<tr>
<td style="font-size:24px;" align="center">
ÍÀÉÁ²ËÜØÈÉ ÂÈÁ²Ð
ÍÀÉÊÐÀÙÎÃÎ ÑÏÎÐßÄÆÅÍÍß
</td>
</tr>
</table>
</td>
<td rowspan="5">
<img src="http://extremstyle.ua/bcode.php?num={$cc['card']}">
</td>
</tr>
<tr>
<td style="padding:10px;">
<b>
Äî 15.04.13 â ñåòè ìàãàçèíîâ «Ýêòðåì Ñòàéë» <b style="color:red;">*</b> ïðåäúÿâèòåëþ äàííîé
êëóáíîé êàðòû ïðåäîñòàâëÿåòñÿ <b style="color:red;">ñêèäêà 15%</b> íà âåñü çèìíèé àññîðòèìåíò òîâàðîâ,
<b style="color:red;">â òîì ÷èñëå è íà òîâàðû ñî ñêèäêîé</b>.
</b>
</td>
</tr>
<tr>
<td style="padding:10px;">
<b style="color:red;">*</b>Àêöèÿ íå äåéñòâóåò â ìàãàçèíàõ &laquo;Ýêñòðåì Ñòàéë&raquo;, ðàñïîëîæåííûõ íà òåððèòîðèè ÃÊ "Áóêîâåëü"
</td>
</tr>
</table>


<br/><br/>
×òî áû ðàñïå÷àòàòü êóïîí ïåðåéäèòå ïî ññûëêå íèæå:\r\n
<a href="http://extremstyle.ua/discont.php?id={$cc['id']}&uid={$user['id']}">http://extremstyle.ua/discont.php?id={$cc['id']}&uid={$user['id']}</a>


HTML;
$headers = 'From: ExtremStyle.ua <extremstyle@extremstyle.ua>' . "\r\n";

$headers .= 'Content-Type: text/html; charset=windows-1251' . "\r\n";

//if($row2['active']=='0')
@mail($to, $subject, $message, $headers);


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


        break;
            
        case 'auto':	// ===================[ Îòïðàâêà àâòîðååñòðàöèè ]=========================

            global $_POST;
            
            $sql = "SELECT * FROM zlo_users WHERE email='".$_POST['order_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/'>ëè÷íûé êàáèíåò</a> èñïîëüçóéòå ñëåäóþùèå äàííûå:
            <br/>
            <br/>
            <blockquote>
              <blockquote>
                            ËÎÃÈÍ: ".$user['email']." <br/>
                            ÏÀÐÎËÜ: ".$user['pass']."
              </blockquote>
            </blockquote>				
            <br/>
            <br/>";
            
            $mail .= "
            Æåëàåì ïðèÿòíûõ ïîêóïîê!	<br/><br/>";
            
            // Ðàññûëêà óâåäîìëåíèé   
            if ($user['group']!=1) {
                sendMail ($user['email'], $user['username'], 'registration@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'], 'registration@extremstyle.ua', 'extremstyle.ua', $subject, $mail);
            // }
            

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


	    $result2 = mysql_query("SELECT * FROM `card` ORDER BY `card` DESC LIMIT 1;") or die(mysql_error());
            // Øëåì ïèñüìà
			$row55 = mysql_fetch_assoc($result2);
			if(!@$row55['card']) $row55['card'] = 0;
			if(@$row55['card']>0){
				$row55['card']++;
				$discont_id = $row55['card'];
			 $result2 = mysql_query("INSERT INTO `card` (`card`,`user_id`) VALUES ('".$row55['card']."','".$user['id']."')");
			}


$result2 = mysql_query("SELECT * FROM `card` WHERE `card`='".$discont_id."' ORDER BY `card` DESC LIMIT 1;") or die(mysql_error());
$cc = mysql_fetch_assoc($result2);
$to      = $user['email'];
$subject = 'Àêöèîííûé êóïîí ExtremStyle';
$message = <<<HTML
<img src="http://extremstyle.ua/p301.png">
<br/>
<br/>

<table cellspacing=0 cellpadding=0 style="border:1px dashed #000;border-radius:10px;padding:10px;width:660px;margin-left:4px;">
<tr>
<td align="left">

Òîëüêî äëÿ çàðåãèñòðèðîâàííûõ êëèåíòîâ äî 15.04.13 äåéñòâóåò àêöèÿ ñêèäêà íà ñêèäêó íà âåñü çèìíèé àññîðòèìåíò òîâàðîâ. Óñëîâèÿ àêöèè:
Åñëè Âû óæå çàðåãèñòðèðîâàíû íà ñàéòå, ðàñïå÷àòàéòå êëóáíóþ êàðòó è ïîëó÷èòå <b style="color:red;">ñêèäêó 15% äîïîëíèòåëüíî ê óæå äåéñòâóþùåé ñêèäêå</b>.<br/><br/>
Åñëè Âû åùå íå çàðåãèñòðèðîâàíû, òî ìîæåòå ñäåëàòü ýòî ïðÿìî ñåé÷àñ.

Êëóáíàÿ êàðòà áóäåò àâòîìàòè÷åñêè îòïðàâëåíà íà ýëåêòðîííûé àäðåñ, óêàçàííûé Âàìè ïðè ðåãèñòðàöèè è Âû ìîæåòå åå ðàñïå÷àòàòü íà
ëþáîì äîñòóïíîì ïðèíòåðå.<br/><br/>

Êëóáíàÿ êàðòà èçûìàåòñÿ ïðè îñóùåñòâëåíèè ïîêóïêè. Íî Âû ìîæåòå ðàñïå÷àòàòü êëóáíóþ êàðòó ñíîâà è ñíîâà è èñïîëüçîâàòü åå òàêèì æå
îáðàçîì äëÿ ñëåäóþùèõ ïîêóïîê íà âåñü ïåðèîä äåéñòâèÿ àêöèè.<br/><br/>


Êèåâ, óë Ãëóáî÷èöêàÿ, 53<br/>
Äíåïðîïåòðîâñê, óë. Íàáåðåæíàÿ Ïîáåäû, 118<br/>
Îäåññà, óë. Êðàñíîâà,12<br/>
Ëüâîâ, óë. Ñòðûéñêàÿ, 30 ÒÐÖ "King Cross Leopolis"<br/>
Õàðüêîâ, ïð. Ëåíèíà, 45/2. Cò.ìåòðî 23 àâãóñòà<br/>
Èíòåðíåò Ìàãàçèí<br/><br/>


<i><b style="color:red;">*</b>Àêöèÿ íå äåéñòâóåò â ìàãàçèíàõ &laquo;Ýêñòðåì Ñòàéë&raquo;, ðàñïîëîæåííûõ íà òåððèòîðèè ÃÊ &laquo;Áóêîâåëü&raquo;</i><br/><br/>
</td>
</tr>
</table>
<br/>


<table cellspacing=0 cellpadding=0 style="border:1px dashed #000;border-radius:10px;padding:10px;width:660px;margin-left:4px;">
<tr>
<td>
<table>
<tr>
<td rowspan="2">
<img src="http://extremstyle.ua/img/kvlogo.png" />
</td>
<td align="center" style="padding:10px;">
<div style="font-size:24px;border:1px dashed #000;padding:10px;border-radius:10px;">{$cc['card']}</div>
</td>
</tr>
<tr>
<td style="font-size:24px;" align="center">
ÍÀÉÁ²ËÜØÈÉ ÂÈÁ²Ð
ÍÀÉÊÐÀÙÎÃÎ ÑÏÎÐßÄÆÅÍÍß
</td>
</tr>
</table>
</td>
<td rowspan="5">
<img src="http://extremstyle.ua/bcode.php?num={$cc['card']}">
</td>
</tr>
<tr>
<td style="padding:10px;">
<b>
Äî 15.04.13 â ñåòè ìàãàçèíîâ «Ýêòðåì Ñòàéë» <b style="color:red;">*</b> ïðåäúÿâèòåëþ äàííîé
êëóáíîé êàðòû ïðåäîñòàâëÿåòñÿ <b style="color:red;">ñêèäêà 15%</b> íà âåñü çèìíèé àññîðòèìåíò òîâàðîâ,
<b style="color:red;">â òîì ÷èñëå è íà òîâàðû ñî ñêèäêîé</b>.
</b>
</td>
</tr>
<tr>
<td style="padding:10px;">
<b style="color:red;">*</b>Àêöèÿ íå äåéñòâóåò â ìàãàçèíàõ &laquo;Ýêñòðåì Ñòàéë&raquo;, ðàñïîëîæåííûõ íà òåððèòîðèè ÃÊ "Áóêîâåëü"
</td>
</tr>
</table>


<br/><br/>
×òî áû ðàñïå÷àòàòü êóïîí ïåðåéäèòå ïî ññûëêå íèæå:\r\n
<a href="http://extremstyle.ua/discont.php?id={$cc['id']}&uid={$user['id']}">http://extremstyle.ua/discont.php?id={$cc['id']}&uid={$user['id']}</a>


HTML;
$headers = 'From: ExtremStyle.ua <extremstyle@extremstyle.ua>' . "\r\n";

$headers .= 'Content-Type: text/html; charset=windows-1251' . "\r\n";

//if($row2['active']=='0')
@mail($to, $subject, $message, $headers);


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


        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. (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 width=\"150px\">".$product2['name']."</td>
<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= "

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

            Ñïàñèáî çà Âàø çàêàç â èíòåðíåò ìàãàçèíå <a href='http://extremstyle.ua/'>extremstyle.ua</a><br/><br/>";


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

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

            $mail.= "
            Íàø ìåíåäæåð ñâÿæåòñÿ ñ Âàìè â áëèæàéøåå âðåìÿ.
            Äåòàëüíóþ èíôîðìàöèþ è ñîñòîÿíèå çàêàçà Âû ìîæåòå ïðîâåðèòü â
            Âàøåì ëè÷íîì êàáèíåòå <a href='http://extremstyle.ua/account/'>http://extremstyle.ua/account/</a><br/><br/>
              <blockquote>
                            ËÎÃÈÍ: ".$user['email']." <br/>
                            ÏÀÐÎËÜ: ".$user['pass']."
              </blockquote>
            <br/>
            Ñïàñèáî, ÷òî âûáðàëè íàñ!
            <br/>
			<br/>
			<b>Ïîäåëèòåñü Âàøèì ïðèîáðåòåíèåì ñ äðóçüÿìè è ñòàíü ó÷àñòíèêîì ðîçûãðûøà ïðèçîâ ñðåäè ñàìûõ àêòèâíûõ ïîëüçîâàòåëåé íàøåé ãðóïïû â ñîöèàëüíîé ñåòè:</b>
<br/>
".$datas."
            <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;
            
        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;
            
        case 'MessageToUser': // ===================[ 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;
            
        case 'MessageToAdmin': // ===================[ 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);
            
            // Âûâîä 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.="<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.="
                    <div class='order-details'>
                    <fieldset id='order-details' style='width:500px;'>
                    <legend>Òîâàðû</legend>";
                $mail.="<table>
                      <tr>
                        <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 * 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>".$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.="</table>
                   </div>";
                   
                
                }
            
            }
            
            $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;
}
?>