Файл: impwar.tk/a_clothes.php
Строк: 305
<?php
require_once('conf/dbc.php');
require_once('conf/session_start.php');
require_once('conf/ban.php');
if ((!isset($_SESSION['id'])) or (!isset($_SESSION['nick']))) {
?>
<script type="text/javascript">
document.location.href = "login.php";
</script>
<?php
}
$page_title = 'Страник';
require_once('conf/head.php');
require_once('conf/top.php');
$user_id = abs(intval($_SESSION['id']));
$query = "Select money, habar from users where id = '$user_id'";
$result = mysqli_query($dbc, $query) or die ('Ошибка передачи запроса к БД');
$row = mysqli_fetch_array($result);
$money = $row['money'];
$habar = $row['habar'];
$tip=filter($_GET['type']);
if (empty($tip)) {
$tip=1;
}
?><br/>
<div style="background-color: #000000;">
<div id="main">
<div class="stats">
<center><p class="name2">Страник</p></center>
</div>
<center><div class="stats"><p>[<a <?php if ($tip == 1) {?>class="white"<?php }?> href="a_clothes.php?type=1">Всё</a>] [<a <?php if ($tip == 5) {?>class="white"<?php }?> href="a_clothes.php?type=5">Шлемы</a>] [<a <?php if ($tip == 2) {?>class="white"<?php }?> href="a_clothes.php?type=2">Одежда</a>] [<a <?php if ($tip == 3) {?>class="white"<?php }?> href="a_clothes.php?type=3">Мечи</a>] [<a <?php if ($tip == 4) {?>class="white"<?php }?> href="a_clothes.php?type=4">Топоры</a>]</p>
</center></div>
<?php
?>
<div class="stats">
<center><p>Ваши Деньги [<img src="img/ico/money.png" width="12" height="12"/> <span class="white"><?php echo "$money"; ?></span>] [<img src="img/ico/materials.png" width="12" height="12"/> <span class="white"><?php echo "$habar"; ?></span>]</p> </center>
</div>
<div class="stats">
<center><p class="white" style="background-color:#1e2833;"><b>[Лоты]</b></p> </center>
<?php
if ($tip==1) {
$query_c = "Select id_lot, thing_id, type, date,price,price_now from auction where type = 1 or type=2 or type=3 or type=4";
$result_c = mysqli_query($dbc, $query_c) or die ('Ошибка передачи запроса к БД');
}
if ($tip==2) {
$query_c = "Select id_lot, thing_id, type, date,price,price_now from auction where type = 1";
$result_c = mysqli_query($dbc, $query_c) or die ('Ошибка передачи запроса к БД');
}
if ($tip==3) {
$query_c = "Select id_lot, thing_id, type, date,price,price_now from auction where type=2";
$result_c = mysqli_query($dbc, $query_c) or die ('Ошибка передачи запроса к БД');
}
if ($tip==4) {
$query_c = "Select id_lot, thing_id, type, date,price,price_now from auction where type=3";
$result_c = mysqli_query($dbc, $query_c) or die ('Ошибка передачи запроса к БД');
}
if ($tip==5) {
$query_c = "Select id_lot, thing_id, type, date,price,price_now from auction where type=4";
$result_c = mysqli_query($dbc, $query_c) or die ('Ошибка передачи запроса к БД');
}
$total = mysqli_num_rows($result_c);
if ($total >0) {
//////////////////////////////////////////////////////
if (!empty($_GET['page'])) {
$cur_page = abs(intval($_GET['page']));
}
else {
$cur_page = 1;
}
$result_per_page = 10;
$skip = (($cur_page - 1) * $result_per_page);
$num_page = ceil($total / $result_per_page);
if ($num_page > 0) {
if ($tip == 1) {
$query_cl = "Select id_lot, thing_id, type, date,price,price_now from auction where type = 1 or type=2 or type=3 or type=4 order by date DESC limit $skip, $result_per_page";
$result_cl = mysqli_query($dbc, $query_cl) or die ('Ошибка передачи запроса к БД');
}
if ($tip == 2) {
$query_cl = "Select id_lot, thing_id, type, date,price,price_now from auction where type = 1 order by date DESC limit $skip, $result_per_page";
$result_cl = mysqli_query($dbc, $query_cl) or die ('Ошибка передачи запроса к БД');
}
if ($tip == 3) {
$query_cl = "Select id_lot, thing_id, type, date,price,price_now from auction where type=2 order by date DESC limit $skip, $result_per_page";
$result_cl = mysqli_query($dbc, $query_cl) or die ('Ошибка передачи запроса к БД');
}
if ($tip == 4) {
$query_cl = "Select id_lot, thing_id, type, date,price,price_now from auction where type=3 order by date DESC limit $skip, $result_per_page";
$result_cl = mysqli_query($dbc, $query_cl) or die ('Ошибка передачи запроса к БД');
}
if ($tip == 5) {
$query_cl = "Select id_lot, thing_id, type, date,price,price_now from auction where type=4 order by date DESC limit $skip, $result_per_page";
$result_cl = mysqli_query($dbc, $query_cl) or die ('Ошибка передачи запроса к БД');
}
while ($row_cl = mysqli_fetch_array($result_cl)) {
if ($row_cl['type']==4) {
$thing_id=$row_cl['thing_id'];
$query_th = "Select inf_id, need_lvl from things where thing_id='$thing_id' limit 1";
$result_th = mysqli_query($dbc, $query_th) or die ('Ошибка передачи запроса к БД');
$row_th = mysqli_fetch_array($result_th);
$inf_id= $row_th['inf_id'];
$query_inf = "Select name, klass, lvl_need, screen from shlem where shlem_id='$inf_id' limit 1";
$result_inf = mysqli_query($dbc, $query_inf) or die ('Ошибка передачи запроса к БД');
$row_inf = mysqli_fetch_array($result_inf);
?>
<center><div class="r2">
<?php
if ($row_inf['klass'] == 1) {?><img src="img/ico/class1.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 2) {?><img src="img/ico/class2.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 3) {?><img src="img/ico/class3.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 4) {?><img src="img/ico/class4.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 6) {?><img src="img/ico/odinochki.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 7) {?><img src="img/ico/dolg.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 8) {?><img src="img/ico/svoboda.png" width="12" height="12"/><?php }
?><a href="lot.php?lot=<?php echo $row_cl['id_lot'];?>"style="text-decoration:none; color: white;"><?php echo $row_inf['name'];?></p>
<p><img src="img/shlem/<?php echo $row_inf['screen'];?>" alt="Слот №4" width="55" height="55"/></p>
<p><span class="white"><?php echo $row_th['need_lvl'];?></span> <a class="white"> Уровень</p>
<?php if ($row_cl['price_now'] < $row_cl['price']) {?><p><a class="white">Cтавка: [<img src="img/ico/money.png" width="12" height="12"/> <span class="white"><?php echo $row_cl['price_now'];?></span>]</p><?php }?>
<p><span class="white">Выкуп:
<?php if ($row_cl['price'] >=0) {?>[<img src="img/ico/money.png" width="12" height="12"/> <span class="white"><?php echo $row_cl['price'];?></span>]<?php }?></p>
</center><p class="zx"></p></a>
<?php
}
if ($row_cl['type']==1) {
$thing_id=$row_cl['thing_id'];
$query_th = "Select inf_id, need_lvl from things where thing_id='$thing_id' limit 1";
$result_th = mysqli_query($dbc, $query_th) or die ('Ошибка передачи запроса к БД');
$row_th = mysqli_fetch_array($result_th);
$inf_id= $row_th['inf_id'];
$query_inf = "Select name, klass, lvl_need, screen from clothes where clothes_id='$inf_id' limit 1";
$result_inf = mysqli_query($dbc, $query_inf) or die ('Ошибка передачи запроса к БД');
$row_inf = mysqli_fetch_array($result_inf);
?>
<center><div class="r2">
<?php
if ($row_inf['klass'] == 1) {?><img src="img/ico/class1.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 2) {?><img src="img/ico/class2.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 3) {?><img src="img/ico/class3.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 4) {?><img src="img/ico/class4.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 6) {?><img src="img/ico/odinochki.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 7) {?><img src="img/ico/dolg.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 8) {?><img src="img/ico/svoboda.png" width="12" height="12"/><?php }
?><a href="lot.php?lot=<?php echo $row_cl['id_lot'];?>"style="text-decoration:none; color: white;"><?php echo $row_inf['name'];?></p>
<p><img src="img/clothes/<?php echo $row_inf['screen'];?>" alt="Слот №1" width="60" height="60"/></p>
<p><span class="white"><?php echo $row_th['need_lvl'];?></span> <a class="white"> Уровень</p>
<?php if ($row_cl['price_now'] < $row_cl['price']) {?><p><a class="white">Cтавка: [<img src="img/ico/money.png" width="12" height="12"/> <span class="white"><?php echo $row_cl['price_now'];?></span>]</p><?php }?>
<p><span class="white">Выкуп:
<?php if ($row_cl['price'] >=0) {?>[<img src="img/ico/money.png" width="12" height="12"/> <span class="white"><?php echo $row_cl['price'];?></span>]<?php }?></p>
</center><p class="zx"></p></a>
<?php
}
if ($row_cl['type']==2) {
$thing_id=$row_cl['thing_id'];
$query_th = "Select inf_id, need_lvl from things where thing_id='$thing_id' limit 1";
$result_th = mysqli_query($dbc, $query_th) or die ('Ошибка передачи запроса к БД');
$row_th = mysqli_fetch_array($result_th);
$inf_id= $row_th['inf_id'];
$query_inf = "Select name, klass, lvl_need, screen from pistols where pistols_id='$inf_id' limit 1";
$result_inf = mysqli_query($dbc, $query_inf) or die ('Ошибка передачи запроса к БД');
$row_inf = mysqli_fetch_array($result_inf);
?>
<center> <div class="r2">
<?php
if ($row_inf['klass'] == 1) {?><img src="img/ico/class1.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 2) {?><img src="img/ico/class2.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 3) {?><img src="img/ico/class3.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 4) {?><img src="img/ico/class4.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 6) {?><img src="img/ico/odinochki.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 7) {?><img src="img/ico/dolg.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 8) {?><img src="img/ico/svoboda.png" width="12" height="12"/><?php }
?><a href="lot.php?lot=<?php echo $row_cl['id_lot'];?>"style="text-decoration:none; color: white;"><?php echo $row_inf['name'];?></p>
<p><img src="img/weapons/<?php echo $row_inf['screen'];?>" alt="Слот №1" /></p>
<p><span class="white"><?php echo $row_th['need_lvl'];?></span><a class="white"> Уровень</p>
<?php if ($row_cl['price_now'] < $row_cl['price']) {?><p><a class="white">Cтавка: [<img src="img/ico/money.png" width="12" height="12"/> <span class="white"><?php echo $row_cl['price_now'];?></span>]</p><?php }?>
<p><a class="white">Выкуп:
<?php if ($row_cl['price'] >=0) {?>[<img src="img/ico/money.png" width="12" height="12"/> <span class="white"><?php echo $row_cl['price'];?></span>]<?php }?></p>
</center><p class="zx"></p></a>
<?php
}
if ($row_cl['type']==3) {
$thing_id=$row_cl['thing_id'];
$query_th = "Select inf_id, need_lvl from things where thing_id='$thing_id' limit 1";
$result_th = mysqli_query($dbc, $query_th) or die ('Ошибка передачи запроса к БД');
$row_th = mysqli_fetch_array($result_th);
$inf_id= $row_th['inf_id'];
$query_inf = "Select name, klass, lvl_need, screen from weapons where weapons_id='$inf_id' limit 1";
$result_inf = mysqli_query($dbc, $query_inf) or die ('Ошибка передачи запроса к БД');
$row_inf = mysqli_fetch_array($result_inf);
?>
<center><div class="r2">
<?php
if ($row_inf['klass'] == 1) {?><img src="img/ico/class1.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 2) {?><img src="img/ico/class2.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 3) {?><img src="img/ico/class3.png" width="12" height="12"/><?php }
if ($row_inf['klass'] == 4) {?><img src="img/ico/class4.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 6) {?><img src="img/ico/odinochki.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 7) {?><img src="img/ico/dolg.png" width="12" height="12"/><?php }
if ($row_cl['klass'] == 8) {?><img src="img/ico/svoboda.png" width="12" height="12"/><?php }
?><a href="lot.php?lot=<?php echo $row_cl['id_lot'];?>"style="text-decoration:none; color: white;"><?php echo $row_inf['name'];?></p>
<p><img src="img/weapons/<?php echo $row_inf['screen'];?>" alt="Слот №1" /></p>
<div class="clothes">
<p><span class="white"><?php echo $row_th['need_lvl'];?></span><a class="white"> Уровень</p>
<?php if ($row_cl['price_now'] < $row_cl['price']) {?><p><a class="white">Cтавка: [<img src="img/ico/money.png" width="12" height="12"/> <span class="white"><?php echo $row_cl['price_now'];?></span>]</p><?php }?>
<p><a class="white">Выкуп:
<?php if ($row_cl['price'] >=0) {?>[<img src="img/ico/money.png" width="12" height="12"/> <span class="white"><?php echo $row_cl['price'];?></span>]<?php }?></p>
</center><p class="zx"></p></a>
<?php
}
}
}
//////////////////////////////////////////////////////
}
else {
?><br/ ><p class="white">Нет выставленных лотов</p><?php
}
?>
<center>
<?php
$phpself= filter($_SERVER['PHP_SELF']);
$phpself = htmlentities($phpself, ENT_QUOTES);
///////////////////////////////////////
////////////////////////////////////////
if ($cur_page > 1) {
echo '<a href="' . "$phpself" . '?page=1"><<</a> ';
}
else {
echo '<< ';
}
if ($cur_page > 1) {
echo '<a href="' . "$phpself" . '?page=' . ($cur_page-1) . '"><</a> ';
}
else {
echo '<';
}
/////
if (($cur_page-3)>0) {
$k = ($cur_page-3);
?><a href="<?php echo "$phpself" . '?page=' . ($cur_page-3)?>"><?php echo "$k";?></a><?php
}
if (($cur_page-2)>0) {
$k = ($cur_page-2);
?> <a href="<?php echo "$phpself" . '?page=' . ($cur_page-2)?>"><?php echo "$k";?></a> <?php
}
if (($cur_page-1)>0) {
$k = ($cur_page-1);
?> <a href="<?php echo "$phpself" . '?page=' . ($cur_page-1)?>"><?php echo "$k";?></a> <?php
}
?> <span class="white"><?php echo " $cur_page ";?></span><?php
if (($cur_page+1)<=$num_page) {
$k = ($cur_page+1);
?> <a href="<?php echo "$phpself" . '?page=' . ($cur_page+1)?>"><?php echo "$k";?></a> <?php
}
if (($cur_page+2)<=$num_page) {
$k = ($cur_page+2);
?> <a href="<?php echo "$phpself" . '?page=' . ($cur_page+2)?>"><?php echo "$k";?></a> <?php
}
if (($cur_page+3)<=$num_page) {
$k = ($cur_page+3);
?> <a href="<?php echo "$phpself" . '?page=' . ($cur_page+3)?>"><?php echo "$k";?></a> <?php
}
/////
if ($cur_page < $num_page) {
echo '<a href="' . "$phpself" . '?page=' . ($cur_page+1) . '">></a> ';
}
else {
echo '>';
}
if ($cur_page < $num_page) {
echo ' <a href="' . "$phpself" . '?page=' . $num_page . '">>></a> ';
}
else {
echo ' >>';
}
////////////////////////////////
///////////////////////////////
?></center>
</div>
<?php
/////////////////////////////////
//////////////////////////////////
?>
</div>
</div>
<?php
require_once('conf/navig.php');
require_once('conf/foot.php');
mysqli_close($dbc);
?>
</body>
</html>