account/auto_registration.php

<?
	// Ïîäêëþ÷åíèå
	include_once($_SERVER['DOCUMENT_ROOT']."/config/config.php"); 
	include_once($_SERVER['DOCUMENT_ROOT']."/account/func/func.php");
	include_once($_SERVER['DOCUMENT_ROOT']."/account/func/func.eMailing.php");
	include_once($_SERVER['DOCUMENT_ROOT']."/libs/Tools.class.php");
	
	// ============================== 
	// ======== Îáðàáîòêà ===========
	// ==============================
	
	global $_SESSION;
    $_POST['form']['interest'] = '';
    
    if (isset ($_POST['form']['mailing']))
    {
        $_POST['form']['interest'] = '44:45';
    }
    
    // ñîçäàåì ìåéë ïî óìîë÷àíèþ äëÿ óïðàâëåíèÿ çàêàçîâ
    if (isset ($_POST['form']['no_account']))
    {
        $_POST['order_email'] = date ('d/m/y/H.i.s') . '@user.com';
        $_POST['form']['email'] = $_POST['order_email'];
        $_POST['form']['interest'] = '';
    }
    
    if (strpos ($_POST['form']['email'], "@user.com"))
    {
        $_POST['form']['group'] = 1;
    }
    else
    {
        $_POST['form']['group'] = 2;
    }
    	
    	// Ïðîâåðÿåì ñóùåñòâîâàíèå ïîëüçîâàòåëÿ
	
	$sql0 = "
        SELECT * FROM zlo_users
		WHERE email='".htmlspecialchars($_POST['order_email'],ENT_QUOTES)."' 
    ";
	$result0 = mysql_query($sql0) or die(mysql_error());
	if (mysql_affected_rows()==0) 
	{ 
		// Äîáàâëÿåì ïîëüçîâàòåëÿ
		$pass = generate_password(6);
		$sql = sprintf("
	        INSERT INTO zlo_users 
	        (username, pass, send, email, city, address, tel, interest, hash, registered, `group`) 
	        VALUES 
	        (%s, %s,%s,%s, %s, %s, %s, %s, %s, NOW(), %s)",
                GetSQLValueString($_POST['order_name'], "text"),
                GetSQLValueString($pass, "text"),
                GetSQLValueString('1', "text"),
                GetSQLValueString($_POST['order_email'], "text"),
                GetSQLValueString($_POST['order_city'], "text"),
                GetSQLValueString($_POST['order_adress'], "text"),
                GetSQLValueString($_POST['order_phone'], "text"),
                GetSQLValueString($_POST['form']['interest'], "text"),
                GetSQLValueString(md5($_POST['order_email'] . "_extremstyle.ua"), "text"),
                GetSQLValueString($_POST['form']['group'], "text")
        );
		$result = mysql_query($sql) or die(mysql_error());
		
		// ñîçäàåì êóïîí
		Tools::addUserCoupon (mysql_insert_id());
        
        // Óçíàåì ID
        $sql = "
            SELECT id 
            FROM zlo_users
            WHERE email='" . htmlspecialchars ($_POST['order_email'], ENT_QUOTES) . "' 
                AND `pass`='" . $pass . "' 
            LIMIT 1
        ";
        $result = mysql_query ($sql) or die (mysql_error ());
        if (mysql_affected_rows () != 0)
        {
            $user = mysql_fetch_assoc ($result);
            $_SESSION['user']['order_account'] = $user['id'];
        } 
	} 
	else 
	{
        $user = mysql_fetch_assoc ($result0);
        $_SESSION['user']['order_account'] = $user['id'];
        if (! isset ($alert_not))
        {
            echo ("<script language=\"JavaScript\">alert('Âû ìîæåòå âîñïîëüçîâàòüñÿ óñëóãîé ëè÷íîãî êàáèíåòà. Íàïîìèíàíèå ëîãèíà è ïàðîëÿ áûëè âûñëàíû íà Âàø email. ')</script>");
        }
        // Øëåì ïèñüìà
        eMailing ('remind', $user['id']); 
	}
	
?>