Файл: foto/inc/user_show_foto.php
Строк: 205
<?php
if (!isset($user) && !isset($_GET['id_user'])){header("Location: /foto/?".SID);exit;}
if (isset($user))$ank['id']=$user['id'];
if (isset($_GET['id_user']))$ank['id']=$_GET['id_user'];
$ank=get_user($ank['id']);
if (!$ank){header("Location: /foto/?".SID);exit;}
$gallery['id']=intval($_GET['id_gallery']);
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery` WHERE `id` = '$gallery[id]' AND `id_user` = '$ank[id]' LIMIT 1"),0)==0){header("Location: /foto/$ank[id]/?".SID);exit;}
$gallery=mysql_fetch_assoc(mysql_query("SELECT * FROM `gallery` WHERE `id` = '$gallery[id]' AND `id_user` = '$ank[id]' LIMIT 1"));
$foto['id']=intval($_GET['id_foto']);
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_foto` WHERE `id` = '$foto[id]' LIMIT 1"),0)==0){header("Location: /foto/$ank[id]/$gallery[id]/?".SID);exit;}
$foto=mysql_fetch_assoc(mysql_query("SELECT * FROM `gallery_foto` WHERE `id` = '$foto[id]' LIMIT 1"));
$set['title']=$ank['nick'].' - '.$gallery['name'].' - '.$foto['name']; // заголовок страницы
include_once '../sys/inc/thead.php';
title();
if (user_access('foto_foto_edit') && $ank['level']>$user['level'] || isset($user) && $ank['id']==$user['id'])
include 'inc/gallery_show_foto_act.php';
################################################################################
if (isset($user) && $user['id']!=$ank['id'] && $user['balls']>=49 && $user['rating']>=0 && mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_rating` WHERE `id_user` = '$user[id]' AND `id_foto` = '$foto[id]'"), 0)==0)
{
if(isset($_GET['rating']) && $_GET['rating']=='1'){
$ratfoto1="Обитатель [url=/info.php?id=$user[id]]$user[nick][/url] , Проголосовал за одну из ваших фотографии ([url=/foto/$ank[id]/$gallery[id]/$foto[id]/]$foto[name][/url]). Оценка на +1";
mysql_query("INSERT INTO `jurnal` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$ank[id]', '$ratfoto1', '$time', '$kto')");
mysql_query("INSERT INTO `gallery_ratinng_user` (`id_foto`, `id_user`, `time`, `msg`) values('$foto[id]', '$user[id]', '$time', '+1')");
mysql_query("UPDATE `gallery_foto` SET `rating` = '".($foto['rating']+1)."' WHERE `id` = '$foto[id]' LIMIT 1",$db);
mysql_query("INSERT INTO `gallery_rating` (`id_user`, `id_foto`) values('$user[id]', '$foto[id]')",$db);
msg ('Ваш положительный отзыв принят');$foto=mysql_fetch_array(mysql_query("SELECT * FROM `gallery_foto` WHERE `id` = $foto[id] LIMIT 1"));
}
if(isset($_GET['rating']) && $_GET['rating']=='2'){
$ratfoto2="Обитатель [url=/info.php?id=$user[id]]$user[nick][/url], Проголосовал за одну из ваших фотографии ([url=/foto/$ank[id]/$gallery[id]/$foto[id]/]$foto[name][/url]). Оценка на +2";
mysql_query("INSERT INTO `gallery_ratinng_user` (`id_foto`, `id_user`, `time`, `msg`) values('$foto[id]', '$user[id]', '$time', '+2')");
mysql_query("INSERT INTO `jurnal` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$ank[id]', '$ratfoto2', '$time')");
mysql_query("UPDATE `gallery_foto` SET `rating` = '".($foto['rating']+2)."' WHERE `id` = '$foto[id]' LIMIT 1",$db);
mysql_query("INSERT INTO `gallery_rating` (`id_user`, `id_foto`) values('$user[id]', '$foto[id]')",$db);
msg ('Ваш положительный отзыв принят');$foto=mysql_fetch_array(mysql_query("SELECT * FROM `gallery_foto` WHERE `id` = $foto[id] LIMIT 1"));
}
if(isset($_GET['rating']) && $_GET['rating']=='3'){
$ratfoto3="Обитатель [url=/info.php?id=$user[id]]$user[nick][/url] , Проголосовал за одну из ваших фотографии ([url=/foto/$ank[id]/$gallery[id]/$foto[id]/]$foto[name][/url]). Оценка на +3";
mysql_query("INSERT INTO `gallery_ratinng_user` (`id_foto`, `id_user`, `time`, `msg`) values('$foto[id]', '$user[id]', '$time', '+3')");
mysql_query("INSERT INTO `jurnal` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$ank[id]', '$ratfoto3', '$time')");
mysql_query("UPDATE `gallery_foto` SET `rating` = '".($foto['rating']+3)."' WHERE `id` = '$foto[id]' LIMIT 1",$db);
mysql_query("INSERT INTO `gallery_rating` (`id_user`, `id_foto`) values('$user[id]', '$foto[id]')",$db);
msg ('Ваш положительный отзыв принят');$foto=mysql_fetch_array(mysql_query("SELECT * FROM `gallery_foto` WHERE `id` = $foto[id] LIMIT 1"));
}
if(isset($_GET['rating']) && $_GET['rating']=='4'){
$ratfoto4="Обитатель [url=/info.php?id=$user[id]]$user[nick][/url] , Проголосовал за одну из ваших фотографии ([url=/foto/$ank[id]/$gallery[id]/$foto[id]/]$foto[name][/url]). Оценка на +4";
mysql_query("INSERT INTO `jurnal` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$ank[id]', '$ratfoto4', '$time')");
mysql_query("INSERT INTO `gallery_ratinng_user` (`id_foto`, `id_user`, `time`, `msg`) values('$foto[id]', '$user[id]', '$time', '+4')");
mysql_query("UPDATE `gallery_foto` SET `rating` = '".($foto['rating']+4)."' WHERE `id` = '$foto[id]' LIMIT 1",$db);
mysql_query("INSERT INTO `gallery_rating` (`id_user`, `id_foto`) values('$user[id]', '$foto[id]')",$db);
msg ('Ваш положительный отзыв принят');$foto=mysql_fetch_array(mysql_query("SELECT * FROM `gallery_foto` WHERE `id` = $foto[id] LIMIT 1"));
}
if(isset($_GET['rating']) && $_GET['rating']=='5'){
$ratfoto5="Обитатель [url=/info.php?id=$user[id]]$user[nick][/url] , Проголосовал за одну из ваших фотографии ([url=/foto/$ank[id]/$gallery[id]/$foto[id]/]$foto[name][/url]). Оценка на +5";
mysql_query("INSERT INTO `jurnal` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$ank[id]', '$ratfoto5', '$time')");
mysql_query("INSERT INTO `gallery_ratinng_user` (`id_foto`, `id_user`, `time`, `msg`) values('$foto[id]', '$user[id]', '$time', '+5')");
mysql_query("UPDATE `gallery_foto` SET `rating` = '".($foto['rating']+5)."' WHERE `id` = '$foto[id]' LIMIT 1",$db);
mysql_query("INSERT INTO `gallery_rating` (`id_user`, `id_foto`) values('$user[id]', '$foto[id]')",$db);
msg ('Ваш положительный отзыв принят');
$foto=mysql_fetch_array(mysql_query("SELECT * FROM `gallery_foto` WHERE `id` = $foto[id] LIMIT 1"));
}
}
################################################################################
err();
aut();
################################################################################
echo "<div class='glav'>n";
################################################################################
echo "<center>n";
if ($set['web'])
{
echo "<a href='/foto/foto0/$foto[id].$foto[ras]' title='Скачать оригинал'><img class='show_foto' src='/foto/foto128/$foto[id].$foto[ras]' alt='$foto[name]' /></a><br />n";
}else{
echo "<a href='/foto/foto0/$foto[id].$foto[ras]' title='Скачать оригинал'><img class='show_foto' src='/foto/foto128/$foto[id].$foto[ras]' alt='$foto[name]' /></a><br />n";
}
echo "</center>n";
################################################################################
echo "</div>n";
/////////////////////////////////////////////////////////////////////////////////
if (isset($_GET['show']) && $_GET['show']=='voice')
{
echo "<div class="foot"><b>Оценки: (".mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_ratinng_user` WHERE `id_foto` = '$foto[id]'"),0).")</b></div>";
if (user_access('foto_foto_edit') && $ank['level']>$user['level'] || isset($user) && $ank['id']==$user['id'])
$num=0;
$k_post2=mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_ratinng_user` WHERE `id_foto` = '$foto[id]'"),0);
$k_page2=k_page($k_post2,$set['p_str']);
$page2=page($k_page2);
$start2=$set['p_str']*$page2-$set['p_str'];
echo "<table class='post'>n";
if ($k_post2==0)
{
echo " <tr>n";
echo " <td class='p_t'>n";
echo "Пусто!n";
echo " </td>n";
echo " </tr>n";
}
$q2=mysql_query("SELECT * FROM `gallery_ratinng_user` WHERE `id_foto` = '$foto[id]' ORDER BY `id` ASC LIMIT $start2, $set[p_str]");
while ($post2 = mysql_fetch_assoc($q2))
{
$ank22=mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '$post2[id_user]' LIMIT 1"));
echo " <tr>n";
if ($set['set_show_icon']==2){
echo "<td class='icon14'>n";
avatar4($ank22['id']);
echo " </td>n";
}
elseif ($set['set_show_icon']==1)
{
echo " <td class='icon14'>n";
echo "".status($ank22['id'])."";
echo " </td>n";
}
echo " <td class='p_t'>n";
echo "<a href='/info.php?id=$ank22[id]'>$ank22[nick]</a>n";
echo "".medal($ank22['id'])." ".online($ank22['id'])." (".vremja($post2['time']).")</br>";
echo " </td>n";
echo " </tr>n";
echo " <tr>n";
if ($set['set_show_icon'])echo " <td class='p_m' colspan='2'>n"; else echo " <td class='p_m'>n";
echo "".$post2['msg']."";
echo " </td>n";
echo " </tr>n";
}
echo "</table>n";
if ($k_page>1)str('?',$k_page,$page); // Вывод страниц
echo "<div class="foot">n";
echo "<a href='/foto/$ank[id]/$gallery[id]/'>К фотографиям</a><br />n";
echo "<a href='/foto/$ank[id]/'>К фотоальбомам</a></div>n";
}
///////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////
////////////////////////////////////////////////////////
echo "<div class='glav'>n";
if ($foto['opis']!=null)
echo esc(trim(br(bbcode(smiles(links(stripcslashes(htmlspecialchars($foto['opis']))))))))."<br />n";
echo "<a href='/foto/$ank[id]/$gallery[id]/komm/$foto[id]/'>Комментарии</a> (".mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_komm` WHERE `id_foto` = '$foto[id]'"),0).") | n";
echo "<a href='/foto/$ank[id]/$gallery[id]/$foto[id]/?show=voice'>Оценки</a> (".mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_ratinng_user` WHERE `id_foto` = '$foto[id]'"),0).")";
echo "</div>n";
echo "<div class='glav'>n";
echo "Рейтинг: $foto[rating]<br />n";
if (isset($user) && $user['id']!=$ank['id'] && $user['balls']>=0 && $user['rating']>=0 && mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_rating` WHERE `id_user` = '$user[id]' AND `id_foto` = '$foto[id]'"), 0)==0)
{
echo " <a href="?id=$foto[id]&rating=1" title="Отдать положительный голос">+1</a>|";
echo " <a href="?id=$foto[id]&rating=2" title="Отдать положительный голос">+2</a>|";
echo " <a href="?id=$foto[id]&rating=3" title="Отдать положительный голос">+3</a>|";
echo " <a href="?id=$foto[id]&rating=4" title="Отдать положительный голос">+4</a>|";
echo " <a href="?id=$foto[id]&rating=5" title="Отдать положительный голос">+5</a>";
echo "<br />n";
}
echo "</div>n";
echo "<div class='glav'>n";
#############
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_foto` WHERE `id_gallery` = '$gallery[id]'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo "<center>n";
if ($k_post==0)
{
echo "Нет фотографийn";
}
$q=mysql_query("SELECT * FROM `gallery_foto` WHERE `id_gallery` = '$gallery[id]' ORDER BY rand() DESC LIMIT 10");
while ($post = mysql_fetch_assoc($q))
{
echo "<a href='/foto/$ank[id]/$gallery[id]/$post[id]/'><img src='/foto/foto128/$post[id].$post[ras]' alt='Фото_$post[id]' width='30' height='28' /></a>";
}
echo "</center>n";
#############
echo "</div>n";
include 'inc/gallery_show_foto_form.php';
echo "<div class="foot">n";
echo "«<a href='/foto/$ank[id]/$gallery[id]/'>К фотографиям</a><br />n";
echo "«<a href='/foto/$ank[id]/'>К фотоальбомам</a><br />n";
echo "</div>n";
include_once '../sys/inc/tfoot.php';
exit;
?>