Blame view

import/emails.php 1.31 KB
42868d70   andryeyev   Создал GIT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
  <?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."')");
  			}		 
  		 
  		 
  		 
  		 
  	 }
  	 
  	}	
  ?>