View file sots-syet-livebook/foto/inc/all_gallery.php

<?
/* Бан пользователя */ 
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `ban` WHERE `razdel` = 'foto' AND `id_user` = '$user[id]' AND (`time` > '$time' OR `view` = '0' OR `navsegda` = '1')"), 0)!=0)
{
	header('Location: /ban.php?'.SID);
	exit;
}

$set['title'] = 'Фотоальбомы'; // заголовок страницы

include_once '../sys/inc/thead.php';
title();
aut();

$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery`"),0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];


echo '<table class="post">';

if ($k_post == 0)
{
	echo '<div class="mess">';
	echo 'Нет фотоальбомов';
	echo '</div>';
}

$q = mysql_query("SELECT * FROM `gallery` ORDER BY `time` DESC LIMIT $start, $set[p_str]");

while ($post = mysql_fetch_assoc($q))
{
	$ank = get_user($post['id_user']);
echo '<a class="link" href="/foto/' . $ank['id'] . '/' . $post['id'] . '/">';
	$num++;

$foto = mysql_fetch_assoc(mysql_query("SELECT * FROM `gallery_foto` WHERE `id_gallery` = '$post[id]'  ORDER BY RAND()"));
if ($foto==null){
echo "<img style='float: left; margin: 0px 10px 0px 0px; width: 40px; height: 45px; border-radius: 5px;' src='/style/user/avatar.gif' width='46'/>";
}
else
{
echo "<img style='float: left; margin: 0px 10px 0px 0px; width: 40px; height: 45px; border-radius: 5px;' src='/foto/foto50/$foto[id].$foto[ras]' alt='Фото_$foto[id]' width='48' height='47' />";
}
	echo '' . text($post['name']) . ' (' . mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_foto` WHERE `id_gallery` = '$post[id]'"),0) . ' фото)<span style="float:right;font-size: 12px;">' . vremja($post['time_create']) . '</span></br>';

	if ($post['opis'] == null)
	echo 'Без описания<br />';
	else 
	echo output_text($post['opis']) . '<br />';
	echo 'Автор: ' . $ank['nick'] . '';
	echo '</a>';
}

echo '</table>';

if ($k_page>1)str('?',$k_page,$page); // Вывод страниц

include_once '../sys/inc/tfoot.php';
exit;
?>