as.php
982 Bytes
<?php
set_time_limit(0);
$_SERVER['DOCUMENT_ROOT'] = realpath(dirname(__FILE__)."/..");
require($_SERVER['DOCUMENT_ROOT'] . "/libs/setup.php");
$setup = new setup();
$_SERVER['DOCUMENT_ROOT'] = realpath(dirname(__FILE__));
$tmpfname = $_SERVER['DOCUMENT_ROOT'] . "/cron/as.txt";
$handle2 = fopen($tmpfname, "a");
if (($handle = fopen("as.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
if(strlen($data[0])>0){
//echo $data[0] . "<br />\n";
$user_id = $setup->db->getOne("select id from zlo_users where email=?",array(trim($data[0])));
if($user_id){
// $fields_values = array('kiev'=>3);
// print_r($fields_values);
// $r = $setup->db->autoExecute("zlo_users",$fields_values,DB_AUTOQUERY_UPDATE,"id='".$user_id."'");
// if (PEAR::isError($r)) die($r->getMessage());
}else{
fwrite($handle2,$data[0]."\r\n");
}
}
}
fclose($handle);
fclose($handle2);
}
?>