Файл: www/chat/marry_new.php
Строк: 29
<?php
include '../config.php';
if(isset($aut)){
mysql_query("UPDATE `users` SET `link`='Чат [<a href=/chat/marry_new.php>Свадьбы</a>]', `link1`='<a href=/chat/marry_new.php>Свадьбы</a>', `link2`='', `link3`='', `link4`='' WHERE `id`='$aut[id]'");}
div('Наши молодожены');
$marry=mysql_num_rows(mysql_query("SELECT `id` FROM `marry`"));
$day=mysql_num_rows(mysql_query("SELECT `id` FROM `marry` WHERE `time`>'".(time()-86400)."'"));
echo 'Молодоженов:<br/>- всего: '.$marry.'<br/>- за сутки: '.$day.'<br/>';
$st=10;
$cp=ceil($marry/$st);
if(isset($_GET['p']) and !empty($_GET['p']) and is_numeric($_GET['p']) and $_GET['p']>1 and $_GET['p']<=$cp){
$p=intval($_GET['p']);
}else{
$p=1;}
$start=$p*$st-$st;
$q=mysql_query("SELECT * FROM `marry` ORDER BY `id` DESC LIMIT $start,$st");
while($r=mysql_fetch_array($q)){
$m=mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `id`='$r[id_m]'"));
$zh=mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `id`='$r[id_zh]'"));
$n++;
if(is_integer($n/2)){
echo '<div class="msg2">';
}else{
echo '<div class="msg1">';}
$komm=mysql_num_rows(mysql_query("SELECT `id` FROM `forum_msg` WHERE `id_theme`='$r[id_theme]'"));
echo '<a href="../info.php?id='.$r['id_m'].'">'.$m['login'].'</a> и <a href="../info.php?id='.$r['id_zh'].'">'.$zh['login'].'</a><br/>Свадьба: '.data($r['time']).'<br/><a href="../forum/?tid='.$r['id_theme'].'">Поздравить</a> ['.$komm.']';
echo '</div>';}
navi($p,$cp,'marry_new.php?');
echo '</div>';
include '../foot.php';
echo '</div>';
?>