Файл: lider_ind.php
Строк: 13
<?
require_once ('system/function.php');
$ld = mysql_query("SELECT * FROM `lider` WHERE `time_end` > '".time()."' ORDER BY RAND() DESC LIMIT 3");
while($l = mysql_fetch_assoc($ld)){
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `users` WHERE `id` = '".$l['kto']."'"));
echo '<div class="podmenu">';
echo (empty($ank['avatar'])?'<img src="/files/ava/net.jpg" alt="*" style="max-width: 50px; max-height: 50px; -o-border-radius: 10px; border-radius: 10px; -moz-border-radius: 10px;">':'<img src="/files/ava/'.$ank['avatar'].'" alt="*" style="max-width: 50px; max-height: 50px; -o-border-radius: 10px; border-radius: 10px; -moz-border-radius: 10px;">');
echo ' '.nick($l['kto']).'<br>Подпись: '.$l['podp'].'</div>';
}
$lider = mysql_result(mysql_query("SELECT COUNT(*) FROM `lider`"),0);
if($lider == 0){
echo '<div class="podmenu">Нет лидеров</div>';
}
$l = mysql_fetch_assoc(mysql_query("SELECT * FROM `lider`"));
if($l['time_end'] < time()) {
mysql_query("DELETE FROM `lider` WHERE `kto` = '".$l['kto']."'");
}
?>