<?php
set_time_limit(0);
//error_reporting (0);
$_SERVER['DOCUMENT_ROOT'] = realpath(dirname(__FILE__)."/..");
require($_SERVER['DOCUMENT_ROOT'] . "/libs/setup.php");
include_once($_SERVER['DOCUMENT_ROOT']."/account/func/func.php");
$setup = new setup();


  $arr_line = file("emails4.csv");
  foreach($arr_line as $line){
     $row_line = explode(";",$line);
	 $email = trim($row_line[0]);
	 if(!$setup->db->getOne('select id from zlo_users where email=?',array($email))){
		 $arr_email = explode('@',$email);
		 $fields_values = array('username'=>$arr_email[0],'email'=>$email,'pass'=>generate_password(6),'`group`'=>'2','send'=>'0','registered'=>date('Y-m-d H:i:s'),'import'=>'1');
		 //print_r($fields_values);
		 $r = $setup->db->autoExecute("zlo_users",$fields_values,DB_AUTOQUERY_INSERT);
		 if (PEAR::isError($r)) die($r->getMessage());
		 $user_id = mysql_insert_id();
	    $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."')");
			}		 
		 
		 
	 }
	 
	}	
?>