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']."')");
			}



}

}
?>