account/func/func.php

<?php
function sendSMS ($tel, $text)
{
    $text = iconv ('windows-1251', 'utf-8', htmlspecialchars ($text));
    $description = iconv ('windows-1251', 'utf-8', htmlspecialchars ('Îòïðàâêà íîìåðà çàêàçà êëèåíòó'));
 
    $times = time ();
 
    $start_time = 'AUTO';
    $end_time = 'AUTO';
     
    $rate = 120;
    $livetime = 4;
    $source = 'extremstyle'; // Alfaname
    $recipient = $tel;
    $user = '380674064008';
    $password = 'smsartweb2012';
    
    $myXML = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
    $myXML .= "<request>";
    $myXML .= "<operation>SENDSMS</operation>";
    $myXML .= '		<message start_time="' . $start_time . '" end_time="' . $end_time . '" livetime="' . $livetime . '" rate="' . $rate . '" desc="' . $description . '" source="' . $source . '">' . "\n";
    $myXML .= "		<body>" . $text . "</body>";
    $myXML .= "		<recipient>" . $recipient . "</recipient>";
    $myXML .= "</message>";
    $myXML .= "</request>";
    
    $ch = curl_init ();
    curl_setopt ($ch, CURLOPT_USERPWD, $user . ':' . $password);
    curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
    curl_setopt ($ch, CURLOPT_POST, 1);
    curl_setopt ($ch, CURLOPT_URL, 'http://sms-fly.com/api/api.php');
    curl_setopt ($ch, CURLOPT_HTTPHEADER, array (
        "Content-Type: text/xml",
        "Accept: text/xml" 
    ));
    curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt ($ch, CURLOPT_POSTFIELDS, $myXML);
    $response = curl_exec ($ch);
    curl_close ($ch);
    
    // echo $response;
    // exit;
}
function ValidFormData ($data, $titles, $type)
{
    switch ($type)
    { 
        case 'only_digits' :
            
            $error = "Îøèáêà ââîäà ïîëÿ $titles, òîëüêî öèôðû.";
            
            if (strlen ($data) > 0)
            {
                if (preg_match ("/[0-9]+/i", $data))
                {
                    $error = '';
                }
            }
            return $error;
            break;
        
        case 'mobile' :
            
            $error = "Îøèáêà ââîäà ïîëÿ $titles (ôîðìàò: +380XXXXXXXXX).";
            
            if (strlen ($data) > 0)
            {
                // if(preg_match("/^(\+)[0-9]+$/i",$data.$names)) {$error='';}
            }
            // return $error;
            break;
        
        case 'require' :
            
            $error = "Ïîëå $titles îáÿçàòåëüíîå ê çàïîëíåíèþ.";
            
            if (strlen ($data) > 0)
            {
                if (preg_match ("/.{1,100}/i", $data . $names))
                {
                    $error = '';
                }
            }
            return $error;
            break;
        
        case 'email' :
            
            // Ïðîâåðêà email
            $error = "Îøèáêà ââîäà ïîëÿ $titles. ";
            
            if (strlen ($data) > 0)
            {
                
                if (preg_match ("/([\w\-]+\@[\w\-]+\.[\w\-]+)/", $data))
                {
                    
                    $error = '';
                }
            }
            return $error;
            break;
        
        default :
            
            return $error = "Îøèáêà $type";
            break;
            
            return $error;
    }
}
function FreandlyDigits ($what)
{
    $total = strlen ($what);
    $mass = '';
    $result = '';
    $j = 0;
    
    for ($i = $total; $i >= 0; $i --)
    {
        $mass[] = substr ($what, $i, 1);
        if ($i != 0)
        {
            if ($j == 3)
            {
                $mass[] = ' ';
                $j = 0;
            }
            $j ++;
        }
    }
    
    krsort ($mass);
    
    foreach ($mass as $digit)
    {
        $i ++;
        $j ++;
        $result .= $digit;
    }
    
    return $result;
}
function ExtractDate ($date)
{ // 2011-02-03 10:45:20
    if (strpos (trim ($date), " "))
    {
        
        list ($Date, $Time) = explode (" ", trim ($date));
        $result1 = explode ("-", trim ($Date));
        $result2 = explode (":", trim ($Time));
        
        foreach ($result2 as $key => $value)
        {
            $result1[] = $value;
        }
        
        return $result1;
    }
    elseif (strpos (trim ($date), "-"))
    {
        
        return $result = explode ("-", trim ($date));
    }
    elseif (strpos (trim ($date), ":"))
    {
        
        return $result = explode (":", trim ($date));
    }
}
function AddZeroDate ($i)
{
    if ($i == '')
    {
        $i = "00";
    }
    if ($i < 10)
    {
        $i = "0" . $i;
    }
    
    return $i;
}
function WhatMonth ($i)
{
    $month1['1'] = "ÿíâàðÿ";
    $month1['2'] = "ôåâðàëÿ";
    $month1['3'] = "ìàðòà";
    $month1['4'] = "àïðåëÿ";
    $month1['5'] = "ìàÿ";
    $month1['6'] = "èþíÿ";
    $month1['7'] = "èþëÿ";
    $month1['8'] = "àâãóñòà";
    $month1['9'] = "ñåíòÿáðÿ";
    $month1['10'] = "îêòÿáðÿ";
    $month1['11'] = "íîÿáðÿ";
    $month1['12'] = "äåêàáðÿ";
    
    $month2['1'] = "ßíâàðü";
    $month2['2'] = "Ôåâðàëü";
    $month2['3'] = "Ìàðò";
    $month2['4'] = "Àïðåëü";
    $month2['5'] = "Ìàé";
    $month2['6'] = "Èþíü";
    $month2['7'] = "Èþëü";
    $month2['8'] = "Àâãóñò";
    $month2['9'] = "Ñåíòÿáðü";
    $month2['10'] = "Îêòÿáðü";
    $month2['11'] = "Íîÿáðü";
    $month2['12'] = "Äåêàáðü";
    
    return $month2[$i];
}
function GetFormUrl ()
{
    $link = $_SERVER['REQUEST_URI'];
    if (! isset ($_SERVER['QUERY_STRING']))
    {
        $link .= "?" . htmlentities ($_SERVER['QUERY_STRING']);
    }
    return $link;
}
function GetSQLValueString ($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
    if (PHP_VERSION < 6)
    {
        $theValue = get_magic_quotes_gpc () ? stripslashes ($theValue) : $theValue;
    }
    
    $theValue = function_exists ("mysql_real_escape_string") ? mysql_real_escape_string ($theValue) : mysql_escape_string ($theValue);
    
    switch ($theType)
    {
        case "text" :
            $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
            break;
        case "long" :
        case "int" :
            $theValue = ($theValue != "") ? intval ($theValue) : "NULL";
            break;
        case "double" :
            $theValue = ($theValue != "") ? doubleval ($theValue) : "NULL";
            break;
        case "date" :
            $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
            break;
        case "defined" :
            $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
            break;
    }
    
    return $theValue;
}
function generate_password ($number)  
{ 
    $arr = array('a','b','c','d','e','f',
        'g','h','i','j','k','l',
        'm','n','o','p','r','s',
        't','u','v','x','y','z',
        'A','B','C','D','E','F',
        'G','H','I','J','K','L',
        'M','N','O','P','R','S',
        'T','U','V','X','Y','Z',
        '1','2','3','4','5','6',
        '7','8','9','0');
    // Ãåíåðèðóåì ïàðîëü
    $pass = "";
    for ($i = 0; $i < $number; $i++) 
    {
        // Âû÷èñëÿåì ñëó÷àéíûé èíäåêñ ìàññèâà
        $index = rand(0, count($arr) - 1);
        $pass .= $arr[$index];
    }
    return $pass;
}
// ===============
// ==== Pager ====
// ===============
function pagerGetRun ($pager, $PerPage = '', $Size = '')
{
    global $url;
    if ($PerPage != '')
    {
        $pager['PerPage'] = $PerPage;
    }
    if ($Size != '')
    {
        $pager['Size'] = $Size;
    }
    
    $result = mysql_query ($pager['sql']) or die (mysql_error ());
    $pager['TotalRows'] = mysql_affected_rows ();
    $pager['All10'] = ceil ($pager['TotalRows'] / ($pager['PerPage'] * $pager['Size'])); // êîë. âñåõ ñòðàíèö ïî 10 øò. ***
    $pager['AllPages'] = ceil ($pager['TotalRows'] / $pager['PerPage']); // êîë. ñòðàíèö ***
    $pager['ActivePage'] = 1; // àêòèâíàÿ ñòðàíèöà ***
    
    if (isset ($_GET['page']))
    {
        $pager['ActivePage'] = $_GET['page'];
    }
    
    $pager['Active10'] = ceil ($pager['ActivePage'] / $pager['Size']);
    
    $pager['sql'] .= " LIMIT " . ($pager['ActivePage'] - 1) * $pager['PerPage'] . ", " . $pager['PerPage'];
    return $pager;
}
function pagerGetShow ($pager)
{
    if ($pager['AllPages'] != 1)
    {
        
        echo '<div class="pager">';
        
        // ==== Íà÷àëî ====
        
        if ($pager['ActivePage'] > $pager['Size'])
        {
            // Àêòèâíî
            echo "<a href=" . urlQueryChange ("page", 1) . " class='begin-active'>Íà÷àëî</a> ";
            echo "<a href=" . urlQueryChange ("page", (($pager['Active10'] - 1) * $pager['Size'])) . " class='prev-active'>" . (($pager['Active10'] - 2) * $pager['Size']) . "..." . (($pager['Active10'] - 1) * $pager['Size']) . "</a> ";
            
            // Íåàêòèâíî
        }
        else
        {
            echo "<a class='begin'>Íà÷àëî</a> ";
        }
        
        // ==== Ñåðåäèíà ====
        
        // Åñëè íå ïîñëåäíèé ðÿä âûâîäà
        
        if ($pager['All10'] > $pager['Active10'])
        {
            
            for ($i = ($pager['Active10'] - 1) * $pager['Size'] + 1; $i <= $pager['Active10'] * $pager['Size']; $i ++)
                
                if ($i == $pager['ActivePage'])
                {
                    echo "<a class='numbers-active'>" . $i . "</a> ";
                }
                else
                {
                    echo "<a href=" . urlQueryChange ("page", $i) . " class='numbers'>" . $i . "</a> ";
                }
            
            // Åñëè ïîñëåäíèé ðÿä âûâîäà
        }
        else
        {
            
            for ($i = ($pager['Active10'] - 1) * $pager['Size'] + 1; $i <= $pager['AllPages']; $i ++)
                
                if ($i == $pager['ActivePage'])
                {
                    echo "<a class='numbers-active'>" . $i . "</a> ";
                }
                else
                {
                    echo "<a href=" . urlQueryChange ("page", $i) . " class='numbers'>" . $i . "</a> ";
                }
        }
        
        // ==== Êîíåö ====
        
        // 50...60
        if ((($pager['All10'] - $pager['Active10']) >= 1) && ($pager['All10'] != $pager['Active10'] + 1))
        {
            echo "<a href='" . urlQueryChange ("page", ($pager['Active10'] * $pager['Size']) + 1) . "' class='next-active'>" . ($pager['Active10'] * $pager['Size'] + 1) . "..." . (($pager['Active10'] + 1) * $pager['Size']) . "</a> ";
            echo "<a href=" . urlQueryChange ("page", $pager['AllPages']) . " class='end-active'>Êîíåö</a>";
        }
        // 50...58
        if ((($pager['All10'] - $pager['Active10']) >= 1) && ($pager['All10'] == $pager['Active10'] + 1))
        {
            echo "<a href='" . urlQueryChange ("page", ($pager['Active10'] * $pager['Size']) + 1) . "' class='next-active'>" . ($pager['Active10'] * $pager['Size'] + 1) . "..." . $pager['AllPages'] . "</a> ";
            echo "<a href=" . urlQueryChange ("page", $pager['AllPages']) . " class='end-active'>Êîíåö</a>";
        }
        
        if ($pager['Active10'] == $pager['All10'])
        {
            echo "<a class='end'>Êîíåö</a>";
        }
        
        echo '</div>';
    }
}
function urlQueryChange ($what, $for)
{
    $url = $_SERVER['REQUEST_URI'];
    
    if (! isset ($_SERVER['QUERY_STRING']) || isset ($_SERVER['QUERY_STRING']) && $_SERVER['QUERY_STRING'] == '')
    {
        
        $url .= "?" . $what . "=1";
    }
    else
    {
        
        if (! isset ($_GET['page']) or $_GET['page'] == 1)
        {
            $url .= "&" . $what . "=1";
        }
    }
    
    // if (empty($_GET['page'])) return $url.="&".$what."=".$for;
    
    // print_r($_GET);
    
    preg_match ("/$what=(.+)/", $url, $xbefore);
    $before = preg_replace ('/\&.*/', '', $xbefore[1]);
    $result = str_replace ("$what=$before", "$what=$for", $url);
    return $result;
}
// ==============
// ==== VIEW ====
// ==============
function viewBook ($table, $value, $what, $title = "title")
{
    $sql = "SELECT `$title` FROM $table WHERE $what='$value' ";
    $result = mysql_query ($sql) or die (mysql_error ());
    $row = mysql_fetch_assoc ($result);
    
    return $row[$title];
}
function viewBookSelectValue ($table, $field, $value_title = 'title', $default = '')
{
    $sql = "SELECT $field,$value_title FROM $table";
    $result = mysql_query ($sql) or die (mysql_error ());
    while ($row = mysql_fetch_assoc ($result))
    {
        if ($default != '')
        {
            if ($row[$field] == $default)
            {
                echo "<option value=\"" . $row[$field] . "\" selected>" . $row[$value_title] . "</option>";
            }
            else
            {
                echo "<option value=\"" . $row[$field] . "\">" . $row[$value_title] . "</option>";
            }
        }
        else
        {
            echo "<option value=\"" . $row[$field] . "\">" . $row[$value_title] . "</option>";
        }
    }
}
function urlQueryChange2 ($what, $for, $url = '')
{
    if ($url == '')
    {
        
        $url = $_SERVER['REQUEST_URI'];
        
        if (! isset ($_SERVER['QUERY_STRING']) || isset ($_SERVER['QUERY_STRING']) && $_SERVER['QUERY_STRING'] == '')
        {
            
            $url .= '?' . $what . "=1";
        }
        else
        {
            
            if (! isset ($_GET[$what]))
            {
                $url .= '&' . $what . "=1";
            }
        }
    }
    else
    {
        
        if (! isset ($_GET[$what]))
        {
            $url .= '&' . $what . "=1";
        }
    }
    
    // $url=preg_replace ('/st.*/','', $url);
    preg_match ("/$what=(.+)/", $url, $xbefore);
    $before = preg_replace ('/\&.*/', '', $xbefore[1]);
    $result = str_replace ("$what=$before", "$what=$for", $url);
    return $result;
}
function ChangesOfMass ($a, $b)
{
    $mass = '';
    
    foreach ($a as $key => $value)
    {
        if ($value != NULL)
        {
            if (in_array ($value, $b))
            {
                $mass['same'][] = $value;
            }
            else
            {
                $mass['add'][] = $value;
            }
        }
    }
    
    foreach ($b as $key => $value)
    {
        if ($value != NULL)
        {
            if (in_array ($value, $a))
            {
            }
            else
            {
                $mass['del'][] = $value;
            }
        }
    }
    
    return $mass;
}
function GoBack ($back = '')
{
    global $_SESSION;
    $url = $_SERVER['REQUEST_URI'];
    if (! isset ($_SESSION['data']['GoBack']))
    {
        $_SESSION['data']['GoBack'] = array (
            "/",
            "/",
            "/" 
        );
    }
    if ($_SESSION['data']['GoBack'][0] != $url)
    {
        array_unshift ($_SESSION['data']['GoBack'], $url);
        unset ($_SESSION['data']['GoBack'][3]);
    }
    
    if ($back != '')
    {
        
        echo "<script language=\"JavaScript\">{ location.href=\"" . $_SESSION['data']['GoBack'][$back] . "\"; self.focus(); } </script>";
    }
    
    // print_r($_SESSION['data']['GoBack']);
}
function AuthorizationUser ($post)
{
    if (isset ($post))
    {
        
        $sql = "SELECT u.*, u.id as user_id FROM zlo_users as u
				WHERE u.email='" . htmlspecialchars ($post['form']['login'], ENT_QUOTES) . "' AND u.pass='" . htmlspecialchars ($post['form']['pass'], ENT_QUOTES) . "' ";
        $result = mysql_query ($sql) or die (mysql_error ());
        if (mysql_affected_rows () != 0)
        {
            
            $row = mysql_fetch_assoc ($result);
            
            // ===== Îòìå÷àåì äàòó âõîäà =====
            $sql2 = "SELECT * FROM zlo_users_in_out WHERE user_id=" . $row['id'] . " ";
            $result2 = mysql_query ($sql2) or die (mysql_error ());
            if (mysql_affected_rows () != 0)
            {
                // îáíîâëÿåì
                $sql2 = "UPDATE zlo_users_in_out SET `in`=NOW() WHERE user_id=" . $row['id'] . " ";
                $result2 = mysql_query ($sql2) or die (mysql_error ());
            }
            else
            {
                // äîáàâëÿåì
                $sql2 = "INSERT INTO zlo_users_in_out (user_id,`in`) VALUES (" . $row['id'] . ",NOW())";
                $result2 = mysql_query ($sql2) or die (mysql_error ());
                
                // ===================
                // === ïðèâåäñòâèå ===
                // ===================
                
                $message = '';
                $message[0] = 'Ðåãèñòðàöèîííîå ñîãëàøåíèå';
                $message[1] = '\n\r\n\rÏðàâà è îáÿçàííîñòè';
                $message[2] = '\n\r\n\rÀäìèíèñòðàöèÿ ñàéòà ãàðàíòèðóåò, ÷òî äàííûå, êîòîðûå ïîëüçîâàòåëü óêàçûâàåò ïðè ðåãèñòðàöèè íà ñàéòå, à òàêæå ïðè äàëüíåéøåì èñïîëüçîâàíèè ëè÷íîãî êàáèíåòà, íå ïåðåäàþòñÿ òðåòüèì ëèöàì, à èñïîëüçóþòñÿ ëèøü äëÿ óäîáñòâà ïîëüçîâàòåëåé ïðè ïîêóïêå è âûáîðå òîâàðîâ íà ñàéòå extremstyle.ua. Äàííàÿ ðåãèñòðàöèÿ ñîîòâåòñòâóåò äåéñòâóþùåìó çàêîíîäàòåëüñòâó Óêðàèíû î íåïðèêîñíîâåííîñòè ëè÷íîé èíôîðìàöèè.';
                $message[3] = '\n\r\n\rÀäìèíèñòðàöèÿ ñàéòà îñòàâëÿåò çà ñîáîé ïðàâî âíîñèòü èçìåíåíèÿ â öåíû íà òîâàðû è àññîðòèìåíò, à òàêæå ìåíÿòü ëþáóþ èíôîðìàöèþ, ðàçìåùåííóþ íà ñàéòå. Àäìèíèñòðàöèÿ ñàéòà íå ãàðàíòèðóåò òî÷íîñòè â ïåðåäà÷å öâåòîâ òîâàðîâ, ïîëíîòó è 100% êîððåêòíîñòü èíôîðìàöèè.';
                $message[4] = '\n\r\n\rÏðàâà è îáÿçàííîñòè ïîëüçîâàòåëÿ';
                $message[5] = '\n\r\n\rÐåãèñòðèðóÿñü íà ñàéòå extremstyle.ua, âû ïîëó÷àåòå âîçìîæíîñòü èñïîëüçîâàòü âñå ïðåèìóùåñòâà ëè÷íîãî êàáèíåòà. Â ñëó÷àå óòåðè ïàðîëÿ, extremstyle.ua âîññòàíàâëèâàåò åãî è ïåðåñûëàåò íà ýëåêòðîííûé ÿùèê, óêàçàííûé âàìè ïðè ðåãèñòðàöèè.';
                $message[6] = '\n\r\n\rÂñå ìàòåðèàëû ñàéòà extremstyle.ua ìîãóò áûòü èñïîëüçîâàíû òîëüêî äëÿ ëè÷íûõ íåêîììåð÷åñêèõ öåëåé. Çàïðåùåíî èñïîëüçîâàòü èíôîðìàöèþ è ôîòîãðàôèè ñàéòà extremstyle.ua â ëþáûõ êîììåð÷åñêèõ èëè îáùåñòâåííûõ öåëÿõ, â ëþáûõ ïå÷àòíûõ è ýëåêòðîííûõ ñðåäñòâàõ ìàññîâîé èíôîðìàöèè áåç ïèñüìåííîãî ðàçðåøåíèÿ Àäìèíèñòðàöèè ñàéòà.';
                $message[7] = '\n\r\n\rÐåãèñòðèðóÿñü íà ñàéòå èíòåðíåò-ìàãàçèíà extremstyle.ua, âû ñîãëàøàåòåñü ñ äàííûìè óñëîâèÿìè.';
                
                $_SESSION['alert']['message'] = implode (" ", $message);
                
                echo '<script>alert("' . $_SESSION['alert']['message'] . '"); </script>';
                unset ($_SESSION['alert']['message']);
            }
            
            $_SESSION['user']['id'] = $row['user_id'];
            $_SESSION['user']['login'] = $row['username'];
            $_SESSION['user']['pass'] = $row['pass'];
            $_SESSION['user']['name'] = $row['username'];
            $_SESSION['user']['email'] = $row['email'];
            $_SESSION['user']['tel'] = $row['tel'];
            $_SESSION['user']['tel2'] = $row['tel2'];
            $_SESSION['user']['address'] = $row['address'];
            $_SESSION['user']['city'] = $row['city'];
            
            // =======================
            // === íîâûå ñîîáùåíèè ===
            // =======================
            
            $message = '';
            
            // Ïîäñ÷åò íîâûõ ñîîáùåíèé
            $sql = "SELECT id FROM zlo_users_message WHERE `status`=3 AND `to`='" . $_SESSION['user']['id'] . "'";
            $result = mysql_query ($sql) or die (mysql_error ());
            $total_messages = mysql_affected_rows ();
            if ($total_messages != 0)
            {
                $message = "Ó âàñ åñòü íîâûå ñîîáùåíèÿ ($total_messages) ";
            }
            
            // =======================
            // ==== íîâûõ îïðîñîâ ===
            // =======================
            
            $sql = "SELECT a.id
                    FROM zlo_users_audience AS a
                    WHERE a.`date_end` > NOW( )
                    AND a.`show` =1
                    AND a.id NOT IN (
                    SELECT audience_id
                    FROM zlo_users_audience_answers AS w
                    WHERE w.user_id ='" . $_SESSION['user']['id'] . "')";
            $result = mysql_query ($sql) or die (mysql_error ());
            $total_audience = mysql_affected_rows ();
            if ($total_audience != 0)
            {
                $message .= '\nÓ Âàñ åñòü íîâûå îïðîñû (' . $total_audience . ')';
            }
            
            if ($message != '')
            {
                echo ("<script>alert('$message')</script>");
            }
        }
        else
        {
            echo ("<script>alert('Íå ïðàâèëüíûé ëîãèí èëè ïàðîëü')</script>");
        }
    }
}
 
function htmlMessage ($status, $text)
{
    return '<div class="alert '.$status.'"><div class="pic"></div><div class="info">'.$text.'</div></div>';
}
?>