View file Readme.txt

Скрипт: Напоминания 
Автор: ise_men
Версия: DCMS 6.6.x 
Контакты: tork08@mail.ru


Описание: Выводит список друзей у которых сегодня(завтра день рождения).



Установка

1) Прописываем этот код в тот файл где хотите выводить.
 
$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){

echo "<b>Напоминание</b><br />";




$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 "<img src=\"/style\icons/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='/info.php?id=$frend[id]'>$frend[nick]</a>. ";
}}



$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 "<img src=\"/style\icons/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+1)."' AND `ank_m_r` = '$mes' "));
echo " <a href='/info.php?id=$frend[id]'>$frend[nick]</a>. ";
}}

}


Всем удачи!