nouser_card.php
975 Bytes
<?php
set_time_limit(0);
$_SERVER['DOCUMENT_ROOT'] = realpath(dirname(__FILE__));
require($_SERVER['DOCUMENT_ROOT'] . "/libs/setup.php");
$sql = "SELECT * FROM zlo_users WHERE `group`='2' order by id desc";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
$result2 = mysql_query("SELECT `card`,`active`,`id` FROM `card` WHERE `user_id`='".$row['id']."' LIMIT 1;") or die(mysql_error());
$row2 = mysql_fetch_assoc($result2);
if($row2['id']>0){
//print"yes<br>";
}
else{print"not<br>";
$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']."','".$row['id']."')");
}
}
}
?>