Файл: mylaf.ru/sys/inc/frend_dr.php
Строк: 56
<?php
$nap = mysql_query("SELECT * FROM `frends` WHERE `user` = '$user[id]'");
$den = date("d");
$mes = date("m");
$count = 0;
while ($fr = mysql_fetch_array($nap)){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$fr[frend]' AND `ank_d_r` = '$den' OR `ank_d_r` = '".($den+1)."' AND `ank_m_r` = '$mes'"),0) != 0) $count++;
}
if ($count>0){
$nap = mysql_query("SELECT * FROM `frends` WHERE `user` = '$user[id]'");
$c_s = 0;
while ($fr = mysql_fetch_array($nap)){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$fr[frend]' AND `ank_d_r` = '$den' AND `ank_m_r` = '$mes'"),0) != 0) $c_s++;
}
if ($c_s>0){
echo "<div class='forum'>";
echo "<img src="/styleicons/cake.png" alt=""/><b> Сегодня день рождение </b><br />";
$fren = mysql_query("SELECT * FROM `frends` WHERE `user` = '$user[id]'");
while ($post = mysql_fetch_array($fren)){
$frend = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[frend]' AND `ank_d_r` = '$den' AND `ank_m_r` = '$mes' "));
echo "<a href='/present/present.php?user=$frend[id]'>";
echo "".$frend['nick']."";
echo "</a>";
}
echo "</div>";}
$nap = mysql_query("SELECT * FROM `frends` WHERE `user` = '$user[id]'");
$c_z = 0;
while ($fr = mysql_fetch_array($nap)){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$fr[frend]' AND `ank_d_r` = '".($den+1)."' AND `ank_m_r` = '$mes'"),0) != 0) $c_z++;
}
if ($c_z>0){
echo "<div class='forum'>";
echo "<img src="/styleicons/cake.png" alt=""/><b> Завтра день рождение </b><br />";
$fre = mysql_query("SELECT * FROM `frends` WHERE `user` = '$user[id]'");
while($post = mysql_fetch_array($fre)){
$frend = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[frend]' AND `ank_d_r` = '".($den+1)."' AND `ank_m_r` = '$mes' "));
echo "<a href='/present/present.php?user=$frend[id]'>";
echo "".$frend['nick']."";
echo "</a>";
}
echo "</div>";}
}
?>