emails.php
1.31 KB
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."')");
}
}
}
?>