File size: 3.88Kb
<?php
echo "<center><div class='main_menu'>Выбор лучшей фотографии</div></center>";
$albums=mysql_query("SELECT * FROM `gallery` WHERE `id_user`='$user[id]'");
$c_albums="";
if(mysql_num_rows($albums)>0)
{
$data_ld=mysql_fetch_array($albums, MYSQL_ASSOC);
$c_albums.=$data_ld['id'];
while($data_ld=mysql_fetch_array($albums, MYSQL_ASSOC))
{
$c_albums.=','.$data_ld['id'];
}
}else{echo "<div class='err'>У Вас нет альбомов<br /><a href='".M."/foto/$user[id]/?act=create'>Добавить альбом</a></div>";}
// выбор строки лидерки
$mld=mysql_fetch_array(mysql_query("SELECT * FROM `mld` WHERE `uid`='$user[id]' LIMIT 1"),MYSQL_ASSOC);
if(!$mld)
{
mysql_query("INSERT INTO `mld` SET
`uid`='$user[id]',
`timestop`='$time',
`photos`='',
`mainload`='0',
`wievs`='0',
`inank`='0',
`countbuy`='0',
`nick`='$user[nick]'
");
$mld=mysql_fetch_array(mysql_query("SELECT * FROM `mld` WHERE `uid`='$user[id]' LIMIT 1"),MYSQL_ASSOC);
}
// Обработка добавленного фото
if($mld)
{
#$count_photos=explode(',',$mld['photos']);
if(isset($_GET['clearhp'])){
$mld['photos']="";
mysql_query("UPDATE `mld` SET `photos`='$mld[photos]' WHERE `uid`='$user[id]' LIMIT 1");
header("Location: ?a=addme");
exit;
}
if($mld['photos']=="")$mld['photos']="0";
$arr_phs=mysql_query("SELECT * FROM `gallery_foto` WHERE `id` IN ($mld[photos])");
if(isset($_POST['photoid']))
{
$ipph=intval(abs($_POST['photoid']));
$get_album=mysql_fetch_array(mysql_query("SELECT `id_gallery` FROM `gallery_foto` WHERE `id`='$ipph' LIMIT 1"),MYSQL_ASSOC);
$check_ph=mysql_fetch_array(mysql_query("SELECT * FROM `gallery` WHERE `id`='$get_album[id_gallery]' AND `id_user`='$user[id]' LIMIT 1"),MYSQL_ASSOC);
if(!$check_ph){$_SESSION['err'].="Это не Ваше фото...<br />";}else{
// Проверка на соответствие данному пользователю
$mld['photos'].=",$ipph";
echo $mld['photos']."<br />";
mysql_query("UPDATE `mld` SET `photos`='$mld[photos]' WHERE `uid`='$user[id]' LIMIT 1");
}
header("Location: ?a=addme");
exit;
}
if(mysql_num_rows($arr_phs)>0)
{
echo "<div class='foot'>Выбранные фотографии</div>";
while($data_ph=mysql_fetch_array($arr_phs, MYSQL_ASSOC))
{
$fotofile="foto/foto48/$data_ph[id].$data_ph[ras]";
echo "<img src='";
echo M.$fotofile;
echo "' /> ";
}
echo "</div>";
echo "<div class='p_m'><a href='?a=billing'>Установить</a>
| <a href='?a=addme&clearhp'>Очистить</a></div>";
}else{echo "<div class='foot'>Нет добавленных фото</div>";}
}
//
mysql_free_result($albums);
$all=mysql_result(mysql_query(" SELECT count(*) FROM `gallery_foto` WHERE `id_gallery` IN ($c_albums)"),0);
$pnumber=$user['set_p_str']; //Элементов на страницу
if(!isset($_GET['page'])){$_GET['page']=1;}
//$n=new Navigator($all,$pnumber);
$n=k_page($all,$pnumber);
if($_GET['page']=='end'){$page=$n;}
else{$page=intval($_GET['page']);}
if($page<1){$page=1;}
$start=$page*$pnumber-$pnumber;
if($start<1){$start=0;}
#echo $c_albums."<br />";
$photos=mysql_query("SELECT * FROM `gallery_foto` WHERE `id_gallery` IN ($c_albums) ORDER BY `rating` DESC LIMIT $start,$pnumber");
#echo mysql_error()."<br />";
if(mysql_num_rows($photos)>0)
{
echo "<table border='0' width='100%'>";
while($data_ph=mysql_fetch_array($photos, MYSQL_ASSOC))
{
$fotofile="foto/foto48/$data_ph[id].$data_ph[ras]";
#echo H.$fotofile."<br />";
echo "<tr class='main_menu'>";
echo "<td>";
echo "<img src='";
echo M.$fotofile;
echo "' />";
echo "</td><td>";
echo "<form method='post' action =''>";
echo "<input type='hidden' name='photoid' value='$data_ph[id]' />";
echo "<input type='submit' name='' value='добавить' />";
echo "</form>";
echo "</td>";
echo "</tr>";
}
echo "</table>";
if($n>1)echo str($link="?a=addme&",$n,$page); //
}
?>