67 Hentai Wallpapers
$sort='';
$qw2=' order by date desc';
$var="/dat";
$qw3=' tb_wallpapers.status=1';
if(isset($_GET["sort"]))
{
if($_GET["sort"]=='dat') {$var="/dat"; $qw2=' order by date desc';}
if($_GET["sort"]=='rating') {$var="/rating"; $qw2=' order by ratings desc';}
if($_GET["sort"]=='candidate') {$var="/candidate"; $qw3='tb_wallpapers.status=0'; }
if($_GET["sort"]=='views') {$var="/views"; $qw2=' order by views desc';}
if($_GET["sort"]=='down') {$var="/down"; $qw2=' order by download desc';}
if($_GET["sort"]=='teg') {$var="/teg/".urlencode($_GET["userizb"]); $tegs_sort=$_GET["userizb"]; $sort=" and UPPER(tegs) LIKE '%".(strtoupper($tegs_sort))."%' ";}
if($_GET["sort"]=='wh') {$var="/wh/".$_GET["userizb"]; $wh_sort=$_GET["userizb"]; $sort=" and UPPER(original) LIKE '%".strtoupper($wh_sort)."%' ";}
if($_GET["sort"]=='category') {$var="/category/".$_GET["userizb"]; $category_sort=$_GET["userizb"]; $sort=" and category_sub='$category_sort' "; }
}
if(isset($_POST["finder"]))
if($_POST["finder"]!='')
{
$var="/teg/".urlencode($_POST["finder"]); $tegs_sort=$_POST["finder"]; $sort="and UPPER(tegs) LIKE '%".(strtoupper($tegs_sort))."%'";
}
//if (isset($_GET["category"])){ $category_sort=$_GET["category"]; $sort=" and category_sub='$category_sort' ";}
//if (isset($_GET["reiting"])){ $qw2=' order by ratings desc';}
//if (isset($_GET["views"])){ $qw2=' order by views desc';}
//if (isset($_GET["down"])){ $qw2=' order by download desc';}
$tableName="tb_wallpapers";
$qw="";
$qw="SELECT tb_categories.category,tb_wallpapers.id,tb_wallpapers.tegs,tb_wallpapers.original,tb_wallpapers.ratings,tb_wallpapers.category_sub,tb_wallpapers.status FROM tb_categories LEFT JOIN tb_wallpapers ON tb_categories.id=tb_wallpapers.category_sub WHERE $qw3 $sort $qw2";
if(isset($_GET["sort"]))
{
if($_GET["sort"]=='izb') {
$userizb=$_GET["userizb"];
$var="/izb/".$userizb;
$qw="SELECT tb_wallpapers.id,tb_wallpapers.tegs,tb_wallpapers.original,tb_wallpapers.ratings,tb_wallpapers.category_sub,tb_wallpapers.status FROM tb_wallpapers LEFT JOIN tb_izb ON tb_izb.idimg=tb_wallpapers.id WHERE tb_izb.avtor='$userizb' $qw2";
}
if($_GET["sort"]=='color') {
$color=$_GET["userizb"];
$var="/color/".$color;
$qj1="SELECT tb_wallpapers.id,tb_wallpapers.tegs,tb_wallpapers.original,tb_wallpapers.ratings,tb_wallpapers.category_sub,tb_wallpapers.status, ";
$qj2=" FROM tb_wallpapers LEFT JOIN tb_color ON tb_color.idimg=tb_wallpapers.id WHERE ";
$qw="
($qj1 tb_color.p0 as p $qj2 tb_color.c0='$color' and tb_color.p0>=0.5) UNION
($qj1 tb_color.p1 as p $qj2 tb_color.c1='$color' and tb_color.p1>=0.5) UNION
($qj1 tb_color.p2 as p $qj2 tb_color.c2='$color' and tb_color.p2>=0.5) UNION
($qj1 tb_color.p3 as p $qj2 tb_color.c3='$color' and tb_color.p3>=0.5) UNION
($qj1 tb_color.p4 as p $qj2 tb_color.c4='$color' and tb_color.p4>=0.5) UNION
($qj1 tb_color.p5 as p $qj2 tb_color.c5='$color' and tb_color.p5>=0.5) UNION
($qj1 tb_color.p6 as p $qj2 tb_color.c6='$color' and tb_color.p6>=0.5) UNION
($qj1 tb_color.p7 as p $qj2 tb_color.c7='$color' and tb_color.p7>=0.5) UNION
($qj1 tb_color.p8 as p $qj2 tb_color.c8='$color' and tb_color.p8>=0.5) UNION
($qj1 tb_color.p9 as p $qj2 tb_color.c9='$color' and tb_color.p9>=0.5) UNION
($qj1 tb_color.p10 as p $qj2 tb_color.c10='$color' and tb_color.p10>=0.5) UNION
($qj1 tb_color.p11 as p $qj2 tb_color.c11='$color' and tb_color.p11>=0.5) UNION
($qj1 tb_color.p12 as p $qj2 tb_color.c12='$color' and tb_color.p12>=0.5) UNION
($qj1 tb_color.p13 as p $qj2 tb_color.c13='$color' and tb_color.p13>=0.5) UNION
($qj1 tb_color.p14 as p $qj2 tb_color.c14='$color' and tb_color.p14>=0.5)
ORDER BY (p+0) DESC";
}
}
// Блок листалки --------------------------------------------------------------
$limit = 16; // количество выводимой информации на одной странице
/*
$res=mysql_query($qw);
$total_pages=mysql_num_rows($res);
*/
$res = $mysqli->query($qw);
$total_pages = mysqli_num_rows($res);
include("page.php");
// Конец листалки -------------------------------------------------------------
//$res=mysql_query($qw.$qw3); // Реальный запрос
$res = $mysqli->query($qw.$qw3);
while($row=mysqli_fetch_array($res, MYSQLI_ASSOC)){
$w_id=$row["id"]; // ID картинки
$w_category=$row["category"]; // Название субкатегории картинки
if($_GET["sort"]=='izb') $w_category='Favorites of '.$userizb;
$w_id_sub=$row["category_sub"]; // ID субкатегории картинки
$w_tegs=$row["tegs"];
$w_tegs=$row["tegs"];
$w_tegs = iconv("utf-8", "windows-1251", $w_tegs);
//$w_tegs=mb_convert_encoding($w_tegs, 'utf-8', mb_detect_encoding($w_tegs));
/*echo $w_tegs;
die();*/
$w_original=$row["original"];
$w_ratings=$row["ratings"];
$w_status=$row["status"];
$mass_tegs=explode(",", $w_tegs);
$tegs_str='';
foreach ($mass_tegs as $k=>$v) $tegs_str.=$v.'';
$tegs_str=encodestring($tegs_str);
$tegs_str=str_replace(array(' '), '-', trim($tegs_str));
?>
if(isset($_SESSION["username"]) && isset($_SESSION["password"]))
if($user_status=='admin'||$user_status=='moder')
if($_GET["sort"]!='izb')
{
echo '';
if($_GET["sort"]=='candidate') // Если вошли в отстойник для админа
{
?>
if($w_status==0) { ?>
} else {?>
}?>
} else // если не отстойник
{
?>
}?>

} // конец админа
if($_GET["sort"]=='izb' && $user==$userizb) // зашли в мзбранное
{
?>
} ?>
?>
} ?>