Файл: magazin.php
Строк: 809
<?php
include 'inc/_conf.php';
include 'inc/header.php';
echo'<div class="menu">';
include ("inc/verh.php");
include ("inc/vuvod.php");
$g=mysql_query("SELECT * FROM `pers` WHERE `nick`='$nick' AND `pass`='$pass' LIMIT 1");
if(mysql_num_rows($g)==1){
switch($_GET[mod]){
default:
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tip`='weapon';");
$wep = mysql_result($koli4estvo, 0);
echo"<b>Торговые ряды</b><br><br>";
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='dospeh';");
$rob = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='sapog';");
$sap = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='perch';");
$perch = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='helms';");
$helms = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='shts';");
$shts = mysql_result($koli4estvo, 0);
$wap=$shts+$helms+$perch+$rob;
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='sheya';");
$sheya = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='lvserg';");
$lvserg = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='ringuh';");
$ringuh = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='lvring';");
$lvring = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='ringring';");
$ringring = mysql_result($koli4estvo, 0);
echo "<img src='/style/img/weapon.png' alt='*'/> <a href="magazin.php?mod=weapon">Оружие</a> ($wep)<br>";
echo "<img src='/style/img/armor.png' alt='*'/> <a href="magazin.php?mod=body">Доспехи</a> ($wap)<br>";
echo "<img src='/style/img/ring.png' alt='*'/> <a href="magazin.php?mod=item&tip=kolco&tipes=lvring">Левая рука</a> ($lvring)<br>";
echo "<img src='/style/img/ring.png' alt='*'/> <a href="magazin.php?mod=item&tip=kolco2&tipes=ringring">Правая рука</a> ($ringring)<br><br>";
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='udocka';");
$ud = mysql_result($koli4estvo, 0);
break;
case 'poplavok':
echo"<img src="style/shmot/Float.gif" height=20 width=20> <a href="magazin.php?mod=pokupkafloat">Float</a> 1 <img src='/style/main/coin.png' alt='*'/> Coin of Luck";
break;
case 'pokupkafloat':
if($coin<1){
echo"Не хватает <img src='/style/main/coin.png' alt='*'/> Coin of Luck!";
include ("inc/foter.php");
exit;
}
$req1 = mysql_query("SELECT * FROM `l2_res` WHERE `usr` = '$nick' and `lat_name` = 'Float'");
$res = mysql_fetch_array($req1);
$avto1=mysql_num_rows($req1);
if($avto1==0){
mysql_query("INSERT INTO
`l2_res` SET
`usr` = '$nick',
`name` = 'Float',
`lat_name` = 'Float',
`tip` = 'res',
`what` = 'res',
`give` = '0',
`kol` = '1',
`cena` = '100'");
}else{
$nk=$res[kol]+1;
mysql_query("UPDATE `l2_res` SET `kol` = '$nk' WHERE `usr` = '$nick' and `lat_name` = 'Float'");
}
mysql_query("UPDATE l2_user SET `coin` =`coin`- '1' WHERE nick = '$nick'");
echo"Float в количестве 1 куплен.";
echo "<br><br>» <a href="magazin.php?"> Вернуться</a>";
break;
case 'Bait':
$req = mysql_query("SELECT * FROM `l2_shopelexirs` WHERE `tip`='res'");
////////////////////////////
$avto=mysql_num_rows($req);
While($mag = mysql_fetch_array($req))
{
echo"<img src="style/shmot/$mag[name].gif" height=20 width=20> <a href="magazin.php?mod=pokupkaBait&id=$mag[id]">$mag[name]</a> ".number_format ($mag[cena])." <img src='/style/main/adena.png' alt='*'/> золота<br/>";
}
echo "<br>» <a href="magazin.php?"> Вернуться</a>";
break;
case 'pokupkaBait':
$req = mysql_query("SELECT * FROM `l2_shopelexirs` WHERE`id`='$id' ");
////////////////////////////
$avto=mysql_num_rows($req);
While($mag = mysql_fetch_array($req))
{
if(empty($_POST[num])){
echo" <form action="magazin.php?mod=pokupkaBait&id=".mysql_real_escape_string($_GET[id])."" method="post">";
echo 'Сколько?<br/>';
echo '<input name="num"/><br/>';
echo '<input type="submit" value="Купить"/></form>';
}else{
if($_POST[num]<=0){
echo"Ошибка!";
echo "<br><br>» <a href="magazin.php?"> Вернуться</a>";
include ("inc/foter.php");
exit;
}
if(eregi("[^0-9]",$_POST[num])){
echo"Ошибка!";
echo "<br><br>» <a href="magazin.php?"> Вернуться</a>";
include ("inc/foter.php");
exit;
}
$cena2=$_POST[num];
$cena=$mag[cena]*$_POST[num];
if($adena<$cena){
echo"Не хватает <img src='/style/main/adena.png' alt='*'/> золота!";
echo "<br><br>» <a href="l2_magazin_soulshot.php?"> Вернуться</a>";
include ("inc/foter.php");
exit;
}
if($gorod=="Heine"){
$nalog=6;
}
if($gorod=="Rune Township"){
$nalog=9;
}
if($gorod=="Town of Aden"){
$nalog=25;
}
if($gorod=="Town of Dion"){
$nalog=7;
}
if($gorod=="Town of Giran"){
$nalog=20;
}
if($gorod=="Town of Gludio"){
$nalog=7;
}
if($gorod=="Town of Goddard"){
$nalog=12;
}
if($gorod=="Town of Oren"){
$nalog=5;
}
if($gorod=="Town of Schuttgart"){
$nalog=9;
}
$req = mysql_query("SELECT * FROM `l2_zamok` WHERE `city` = '$gorod' LIMIT 1");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto==1){
$city = mysql_fetch_array($req);
if($city[clan]!=''){
$req = mysql_query("SELECT * FROM `l2_clan` WHERE `glava`='$city[clan]'");
////////////////////////////
$clan = mysql_fetch_array($req);
$ma=($cena*$nalog)/100;
mysql_query("UPDATE `l2_clan` SET `aden` = `aden` + '$ma' WHERE `name` = '$clan[name]'");
}
}
$adena=$adena-$cena;//mony
$req = mysql_query("SELECT * FROM `l2_res` WHERE `usr` = '$nick' and `lat_name`='$mag[lat_name]' LIMIT 1");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto==0){
mysql_query("INSERT INTO
`l2_res` SET
`usr` = '$nick',
`name` = '$mag[name]',
`lat_name` = '$mag[lat_name]',
`tip` = '$mag[tip]',
`what` = '$mag[what]',
`bonus` = '0',
`give` = '0',
`cena` = '$mag[cena]',
`kol` = '$cena2'");
}else{
$myres=mysql_fetch_array($req);
$myres[kol]=$myres[kol]+$cena2;
mysql_query("UPDATE `l2_res` SET `kol` = '$myres[kol]' WHERE `usr` = '$nick' and `lat_name`='$mag[lat_name]'");
}
mysql_query("UPDATE `l2_user` SET `adena` = `adena`- '$cena' WHERE `nick` = '$nick'");
echo"<b>$mag[name]</b> <u>($cena2 штук)</u> куплены за <u>$cena</u> <img src='/style/main/adena.png' alt='*'/> золота!<br/>";
}
}
break;
case 'magazin':
echo "<form method="post" action="magazin.php?mod=magazin_ok">";
echo'<select id="select" name="tip" type="select">
<option value="weapon">Оружие</option>
<option value="golova">Шлемы</option>
<option value="shit">Щиты</option>
<option value="ruki">Перчатки</option>
<option value="nogi">Сапоги</option>
<option value="body">Доспехи</option>
<option value="maska">Маски</option>
<option value="amulet">Шея</option>
<option value="kolco">Левая рука</option>
<option value="kolco2">Правая рука</option>
<option value="serga">Левое ухо</option>
<option value="serga2">Правое ухо</option>
</select>';
echo "<input type="submit" value="Выбрать" class="ibutton"></form>";
echo "» <a href="magazin.php?"> Вернуться</a>";
break;
case 'magazin_ok':
if($tip!=weapon && $tip!=golova && $tip!=shit && $tip!=ruki && $tip!=nogi && $tip!=body && $tip!=maska && $tip!=amulet && $tip!=serga && $tip!=serga2 && $tip!=kolco && $tip!=kolco2){
echo'Ошибка!';
include ("inc/foter.php");
exit;
}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$req = mysql_query("SELECT * FROM `l2_item` WHERE `usr` = '$nick' and `image`='not' and `tip`='$tip' ORDER by `id` DESC LIMIT $startan,$num_msgs_an");
////////////////////////////
$avto=mysql_num_rows($req);
if(empty($_GET[id])){
if($avto>=1){
While($mag = mysql_fetch_array($req))
{
$cena=round($mag[cena]/2);
$w=explode("*",$mag[name]);
echo"<img src="style/shmot/$w[0].gif" height=20 width=20>"; echo" <a href="magazin.php?mod=magazin_prodaja&id=$mag[id]">$mag[name]</a> (Цена ".number_format ($cena)." <img src='/style/main/adena.png' alt='*'/> золота)<br/>";
}
$q = mysql_query("SELECT COUNT(`usr`) FROM `l2_item` WHERE `usr` = '$nick' and `image`='not' and `tip`='$tip' ");
$kol = mysql_result($q, 0);
echo '<div class="bts"></div>';
echo'Страницы: ';
if($startan!= 0) $page2left = ' <a href= magazin.php?mod=magazin_ok&tip='.$tip.'&startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= magazin.php?mod=magazin_ok&tip='.$tip.'&startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
echo '<div class="bts"></div>';
echo "» <a href="magazin.php?mod=magazin"> Вернуться</a>";
}else{
echo 'Нет вещей!';
echo "<br><br>» <a href="magazin.php?mod=magazin"> Вернуться</a>";
}}
break;
case 'magazin_prodaja':
$req = mysql_query("SELECT * FROM `l2_item` WHERE `usr` = '$nick' and `image`='not' and `id`='".mysql_real_escape_string($_GET['id'])."'");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto==1){
$item = mysql_fetch_array($req);
$cena=round($item[cena]/2);
$adena=$adena+$cena;
mysql_query("UPDATE `l2_user` SET `adena` = '$adena' WHERE `nick` = '$nick'");
mysql_query("DELETE FROM `l2_item` WHERE usr='$nick' and `image`='not' and `id`='".mysql_real_escape_string($_GET['id'])."'");
$n2='<a href="l2_pers_nick.php?nick='.$nick.'&go=go">'.$nick.'</a> продал в городской магазин вещь: <b>'.$item[name].'</b>, за <u>'.$cena.'</u> <img src="/style/main/adena.png" alt="*"/> золота.';
$time = date("H:i d.m.y");
mysql_query("INSERT INTO l2_hystory_pers SET `nick`='$nick', text='$n2', time = '$time' ");
echo"Вещь <b>$item[name]</b> продана за <u>$cena</u> <img src='/style/main/adena.png' alt='*'/> золота<br/>";
echo "<br>» <a href="magazin.php?mod=magazin"> Вернуться</a>";
}else{
echo"Нет такой вещи!<br/>";
echo "<br>» <a href="magazin.php?mod=magazin"> Вернуться</a>";
}
break;
case 'magazin_resurs':
echo "<form method="post" action="magazin.php?mod=magazin_resurs_ok">";
echo'<select id="select" name="tip" type="select">
<option value="res">Ресурсы</option>
<option value="elexir">Эликсиры</option>
<option value="scroll">Свитки</option>
<option value="recepts">Рецепты</option>
</select>';
echo "<input type="submit" value="Выбрать" class="ibutton"></form>";
echo "» <a href="magazin.php?"> Вернуться</a>";
break;
case 'magazin_resurs_ok':
if($tip!=res && $tip!=elexir && $tip!=scroll && $tip!=recepts){
echo'Ошибка!';
include ("inc/foter.php");
exit;
}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$req = mysql_query("SELECT * FROM `l2_res` WHERE `usr` = '$nick' and `bonus`='0' and `tip`='$tip' ORDER by `id` DESC LIMIT $startan,$num_msgs_an");
////////////////////////////
$avto=mysql_num_rows($req);
if(empty($_GET[id])){
if($avto>=1){
While($mag = mysql_fetch_array($req))
{
$cena=round($mag[cena]/2);
echo"<img src="style/shmot/$mag[name].gif" height=20 width=20> <a href="magazin.php?mod=res_prodaja&id=$mag[id]">$mag[name]</a> (У вас $mag[kol] штук, цена за 1, ".number_format ($cena)." <img src='/style/main/adena.png' alt='*'/> золота)<br/>";
}
$q = mysql_query("SELECT COUNT(`usr`) FROM `l2_res` WHERE `usr` = '$nick' and `tip`='$tip' ");
$kol = mysql_result($q, 0);
echo '<div class="bts"></div>';
echo'Страницы: ';
if($startan!= 0) $page2left = ' <a href= magazin.php?mod=magazin_resurs_ok&tip='.$tip.'&startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= magazin.php?mod=magazin_resurs_ok&tip='.$tip.'&startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
echo '<div class="bts"></div>';
echo "» <a href="magazin.php?mod=magazin_resurs"> Вернуться</a>";
}else{
echo 'Нет вещей!';
echo "<br><br>» <a href="magazin.php?mod=magazin_resurs"> Вернуться</a>";
}}
break;
case 'res_prodaja':
if(empty($_POST[num])){
echo" <form action="magazin.php?mod=res_prodaja&id=".mysql_real_escape_string($_GET[id])."" method="post">";
echo 'Сколько?<br/>';
echo '<input name="num"/><br/>';
echo '<input type="submit" value="Продолжить"/></form>';
}else{
if($_POST[num]<=0){
echo"Ошибка!";
echo "<br><br>» <a href="magazin.php?mod=magazin_resurs"> Вернуться</a>";
include ("inc/foter.php");
exit;
}
if(eregi("[^0-9]",$_POST[num])){
echo"Ошибка!";
echo "<br><br>» <a href="magazin.php?mod=magazin_resurs"> Вернуться</a>";
include ("inc/foter.php");
exit;
}
$req = mysql_query("SELECT * FROM `l2_res` WHERE `usr` = '$nick' and `id`='".mysql_real_escape_string($_GET['id'])."'");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto==1){
$res = mysql_fetch_array($req);
/////////////////////
if($res[kol]-$_POST[num]<=0){
mysql_query("DELETE FROM `l2_res` WHERE usr='$nick' and `id`='".mysql_real_escape_string($_GET['id'])."'");
$nkol=$res[kol];
}else{
$res[kol]=$res[kol]-$_POST[num];
mysql_query("UPDATE `l2_res` SET `kol` = '$res[kol]' WHERE `usr` = '$nick' and `id`='".mysql_real_escape_string($_GET['id'])."'");
$nkol=$_POST[num];
}
///////////////////////
$cena=round($res[cena]/2);
////////////////////////
$adena=round($adena+$cena*$nkol);
$cena=round($cena*$nkol);
/////////////////////
mysql_query("UPDATE `l2_user` SET `adena` = '$adena' WHERE `nick` = '$nick'");
//////////////////////////////////////
$n2='<a href="l2_pers_nick.php?nick='.$nick.'&go=go">'.$nick.'</a> продал в городской магазин ресурс: <b>'.$res[name].'</b>, <u>'.$nkol.'</u> шт за <u>'.$cena.'</u> <img src="/style/main/adena.png" alt="*"/> золота.';
$time = date("H:i d.m.y");
mysql_query("INSERT INTO l2_hystory_pers SET `nick`='$nick', text='$n2', time = '$time' ");
echo"<b>$res[name]</b> <u>$nkol</u> шт продано за <u>$cena</u> <img src='/style/main/adena.png' alt='*'/> золота!<br/>";
echo "<br>» <a href="magazin.php?mod=magazin_resurs"> Вернуться</a>";
}else{
echo"У вас нет данного ресурса!<br/>";
echo "<br>» <a href="magazin.php?mod=magazin_resurs"> Вернуться</a>";
}
}
break;
case 'body':
echo "<img src='/style/magazin/magazins_info.gif' alt='*'/> <b>Trader Minaless</b><br>
Благословит вас богиня тьмы! Всё, что вам нужно - здесь, Последователь Шилен! Мы всё приготовили для вас! Я клянусь своим сердцем во имя Шилен, что здесь собраны самые прекрасные и качественные товары...<br>";
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='dospeh';");
$rob = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='sapog';");
$sap = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='perch';");
$perch = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='helms';");
$helms = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='shts';");
$shts = mysql_result($koli4estvo, 0);
echo "<br><img src='/style/magazin/armorss.png' alt='*'/> <a href="magazin.php?mod=item&tip=body&tipes=dospeh">Роба</a> ($rob)<br>";
echo "<img src='/style/magazin/boots.png' alt='*'/> <a href="magazin.php?mod=item&tip=nogi&tipes=sapog">Сапоги</a> ($sap)<br>";
echo "<img src='/style/magazin/gloves.png' alt='*'/> <a href="magazin.php?mod=item&tip=ruki&tipes=perch">Перчатки</a> ($perch)<br>";
echo "<img src='/style/magazin/helmet.png' alt='*'/> <a href="magazin.php?mod=item&tip=golova&tipes=helms">Шлемы</a> ($helms)<br>";
echo "<img src='/style/magazin/shield.png' alt='*'/> <a href="magazin.php?mod=item&tip=shit&tipes=shts">Щиты</a> ($shts)<br>";
echo "<br>» <a href="magazin.php?"> Вернуться</a>";
break;
case 'item':
if($tip!=weapon && $tip!=golova && $tip!=shit && $tip!=ruki && $tip!=nogi && $tip!=body && $tip!=amulet && $tip!=serga && $tip!=serga2 && $tip!=kolco && $tip!=kolco2){
echo'Ошибка!';
include ("inc/foter.php");
exit;
}
if($tipes!=mech && $tipes!=lucas && $tipes!=db && $tipes!=kn && $tipes!=ks && $tipes!=kest && $tipes!=arbals && $tipes!=rapers && $tipes!=kpkv && $tipes!=lvserg && $tipes!=ringuh && $tipes!=lvring && $tipes!=ringring && $tipes!=sheya && $tipes!=dospeh && $tipes!=sapog && $tipes!=perch && $tipes!=helms && $tipes!=shts && $tipes!=udocka){
echo'Ошибка!';
include ("inc/foter.php");
exit;
}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$req = mysql_query("SELECT * FROM `l2_shop` WHERE `tip`='$tip' and `tipes`='$tipes' ORDER by `id` DESC LIMIT $startan,$num_msgs_an");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto>=1){
While($mag = mysql_fetch_array($req))
{
echo"<img src="style/shmot/$mag[name].gif" height=20 width=20> <a href="magazin_pokupka.php?act=ask&id=$mag[id]">$mag[name]</a> ".number_format ($mag[cena])." <img src='/style/main/adena.png' alt='*'/> золота | Грейд: $mag[grade] (<a href="magazin.php?mod=infoq&tip=$tip&tipes=$tipes&id=$mag[id]">описание</a>)<br/>";
}
$q = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tip`='$tip' and `tipes`='$tipes' ");
$kol = mysql_result($q, 0);
echo '<div class="bts"></div>';
echo'Страницы: ';
if($startan!= 0) $page2left = ' <a href= magazin.php?mod=item&tip='.$tip.'&tipes='.$tipes.'&startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= magazin.php?mod=item&tip='.$tip.'&tipes='.$tipes.'&startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
echo '<div class="bts"></div>';
echo "» <a href="magazin.php?mod=weapon"> Вернуться</a>";
}else{
echo 'В этом разделе нет вещей!';
echo "<br><br>» <a href="magazin.php?mod=weapon"> Вернуться</a>";
}
break;
case 'infoq':
$req = mysql_query("SELECT * FROM `l2_shop` WHERE `id`='".mysql_real_escape_string($_GET['id'])."'");
$avto=mysql_num_rows($req);
if($avto==0){
echo'Ошибка!';
include ("niz/niz.php");
exit;
}
$mag = mysql_fetch_array($req);
echo"
<img src="style/shmot/$mag[name].gif" height=20 width=20> <b>$mag[name]</b><br/><br/>
Атака: $mag[atak]<br/>
Защита: $mag[zahit]<br/>
Цена: ".number_format ($mag[cena])." <img src='/style/main/adena.png' alt='*'/> золота<br/>
Grade: $mag[grade]<br/>
Требования: $mag[nlvl] <img src='/style/main/up.png' alt='*'/><br/>
";
echo "<br>» <a href="magazin.php?mod=item&tip=$tip&tipes=$tipes"> Вернуться</a>";
break;
case 'weapon':
echo "<img src='/style/user/24.jpg' alt='*'/> <b>Оптимус</b><br>
Што желаеш купить? $nick <br>";
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='mech';");
$mech = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='lucas';");
$lucas = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='db';");
$db = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='kn';");
$kn = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='ks';");
$ks = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='kest';");
$kest = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='arbals';");
$arbals = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='rapers';");
$rapers = mysql_result($koli4estvo, 0);
$koli4estvo = mysql_query("SELECT COUNT(`id`) FROM `l2_shop` WHERE `tipes`='kpkv';");
$kpkv = mysql_result($koli4estvo, 0);
echo "<br><img src='/style/magazin/shop_weapon.png' alt='*'/> <a href="magazin.php?mod=item&tip=weapon&tipes=mech">Мечи</a> ($mech)<br>";
echo "<img src='/style/magazin/bow.png' alt='*'/> <a href="magazin.php?mod=item&tip=weapon&tipes=lucas">Луки</a> ($lucas)<br>";
echo "<img src='/style/magazin/dagger.png' alt='*'/> <a href="magazin.php?mod=item&tip=weapon&tipes=kn">Кортики/Ножи</a> ($kn)<br>";
echo "<img src='/style/magazin/spear.png' alt='*'/> <a href="magazin.php?mod=item&tip=weapon&tipes=ks">Копья/Пики/Секиры</a> ($ks)<br>";
echo "<img src='/style/magazin/brass.png' alt='*'/> <a href="magazin.php?mod=item&tip=weapon&tipes=kest">Кастеты</a> ($kest)<br>";
echo "<img src='/style/magazin/crossbow.png' alt='*'/> <a href="magazin.php?mod=item&tip=weapon&tipes=arbals">Арбалеты</a> ($arbals)<br>";
echo "<img src='/style/magazin/rapier.png' alt='*'/> <a href="magazin.php?mod=item&tip=weapon&tipes=rapers">Рапиры</a> ($rapers)<br>";
echo "<br>» <a href="magazin.php?"> Вернуться</a>";
break;
case 'vesh':
$req = mysql_query("SELECT * FROM `l2_shopelexirs` WHERE `tip`='elexir'");
////////////////////////////
$avto=mysql_num_rows($req);
While($mag = mysql_fetch_array($req))
{
echo"<img src="style/shmot/$mag[name].gif" height=20 width=20> <a href="magazin.php?mod=pks&id=$mag[id]">$mag[name]</a> ".number_format ($mag[cena])." <img src='/style/main/adena.png' alt='*'/> золота, <a href="magazin.php?mod=infos&id=$mag[id]">описание</a>)<br/>";
}
echo "<br>» <a href="magazin.php?"> Вернуться</a>";
break;
case 'infos':
$req = mysql_query("SELECT * FROM `l2_shopelexirs` WHERE`id`='".mysql_real_escape_string($_GET['id'])."'");
$mag = mysql_fetch_array($req);
switch($mag[what]){
case 'hp':
$tip='<font color=red>HP</font>';
break;
case 'mp':
$tip='<font color=blue>MP</font>';
break;
}
echo"
<img src="style/shmot/$mag[name].gif" height=20 width=20> <b>$mag[name]</b><br/><br/>
Востанавливает: $tip<br/>
Едениц: $mag[give]<br/>
Стоимость: ".number_format ($mag[cena])." <img src='/style/main/adena.png' alt='*'/> золота<br/>
";
echo "<br>» <a href="magazin.php?mod=vesh"> Вернуться</a>";
break;
case 'pks':
$req = mysql_query("SELECT * FROM `l2_shopelexirs` WHERE `id`='".mysql_real_escape_string($_GET['id'])."'");
$avto=mysql_num_rows($req);
if($avto==0){
echo'Такой вещи не существует!';
include ("inc/foter.php");
exit;
}
$mag = mysql_fetch_array($req);
if(empty($_POST[num])){
echo" <form action="magazin.php?mod=pks&id=".mysql_real_escape_string($_GET[id])."" method="post">";
echo 'Сколько?<br/>';
echo '<input name="num"/><br/>';
echo '<input type="submit" value="Купить"/></form>';
}else{
if($_POST[num]<=0){
echo"Ошибка!";
echo "<br><br>» <a href="magazin.php?mod=vesh"> Вернуться</a>";
include ("inc/foter.php");
exit;
}
if(eregi("[^0-9]",$_POST[num])){
echo"Ошибка!";
echo "<br><br>» <a href="magazin.php?mod=vesh"> Вернуться</a>";
include ("inc/foter.php");
exit;
}
$cena2=$_POST[num];
$cena=$mag[cena]*$_POST[num];
if($adena<$cena){
echo"Не хватает <img src='/style/main/adena.png' alt='*'/> золота!";
echo "<br><br>» <a href="magazin.php?mod=vesh"> Вернуться</a>";
include ("inc/foter.php");
exit;
}
if($gorod=="Heine"){
$nalog=6;
}
if($gorod=="Rune Township"){
$nalog=9;
}
if($gorod=="Town of Aden"){
$nalog=25;
}
if($gorod=="Town of Dion"){
$nalog=7;
}
if($gorod=="Town of Giran"){
$nalog=20;
}
if($gorod=="Town of Gludio"){
$nalog=7;
}
if($gorod=="Town of Goddard"){
$nalog=12;
}
if($gorod=="Town of Oren"){
$nalog=5;
}
if($gorod=="Town of Schuttgart"){
$nalog=9;
}
$req = mysql_query("SELECT * FROM `l2_zamok` WHERE `city` = '$gorod' LIMIT 1");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto==1){
$city = mysql_fetch_array($req);
if($city[clan]!=''){
$req = mysql_query("SELECT * FROM `l2_clan` WHERE `glava`='$city[clan]'");
////////////////////////////
$clan = mysql_fetch_array($req);
$ma=($cena*$nalog)/100;
mysql_query("UPDATE `l2_clan` SET `aden` = `aden` + '$ma' WHERE `name` = '$clan[name]'");
}
}
$req1 = mysql_query("SELECT * FROM `l2_res` WHERE `usr` = '$nick' and `lat_name` = '$mag[lat_name]'");
$res = mysql_fetch_array($req1);
$avto1=mysql_num_rows($req1);
if($avto1==0){
mysql_query("INSERT INTO
`l2_res` SET
`usr` = '$nick',
`name` = '$mag[name]',
`lat_name` = '$mag[lat_name]',
`tip` = '$mag[tip]',
`what` = '$mag[what]',
`give` = '$mag[give]',
`kol` = '$cena2',
`cena` = '$mag[cena]'");
}else{
$nk=$res[kol]+$cena2;
mysql_query("UPDATE `l2_res` SET `kol` = '$nk' WHERE `usr` = '$nick' and `lat_name` = '$mag[lat_name]'");
}
mysql_query("UPDATE l2_user SET adena = adena- '$cena' WHERE nick = '$nick'");
echo"
Вы успешно купили $mag[name] ($_POST[num] шт.)<br/>
Стоимостью: ".number_format ($cena)." <img src='/style/main/adena.png' alt='*'/> золота.
";
echo "<br><br>» <a href="magazin.php?mod=vesh"> Вернуться</a>";
}
break;
case 'svitok':
$req = mysql_query("SELECT * FROM `l2_shopscroll` WHERE`tip`='scroll'");
////////////////////////////
$avto=mysql_num_rows($req);
While($mag = mysql_fetch_array($req))
{
echo"<img src="style/shmot/$mag[name].gif" height=20 width=20> <a href="magazin.php?mod=pokscrol&id=$mag[id]">$mag[name]</a> ".number_format ($mag[cena])." <img src='/style/main/adena.png' alt='*'/> золота, <a href="magazin.php?mod=infoss&id=$mag[id]">описание</a>)<br/>";
}
echo "<br>» <a href="magazin.php?"> Вернуться</a>";
break;
case 'infoss':
$req = mysql_query("SELECT * FROM `l2_shopscroll` WHERE `id`='".mysql_real_escape_string($_GET['id'])."'");
$avto=mysql_num_rows($req);
if($avto==0){
echo'Система выдала код ошибки!';
include ("inc/foter.php");
exit;
}
$mag = mysql_fetch_array($req);
echo"
<img src="style/shmot/$mag[name].gif" height=20 width=20> <b>$mag[name]</b><br/><br/>
Описание: $mag[faq]<br/>
Цена: ".number_format ($mag[cena])." <img src='/style/main/adena.png' alt='*'/> золота<br/>
";
echo "<br>» <a href="magazin.php?mod=svitok"> Вернуться</a>";
break;
case 'pokscrol':
$req = mysql_query("SELECT * FROM `l2_shopscroll` WHERE `id`='".mysql_real_escape_string($_GET['id'])."'");
$avto=mysql_num_rows($req);
if($avto==0){
echo'Система выдала ошибку!';
include ("inc/foter.php");
exit;
}
$mag = mysql_fetch_array($req);
$nmoney=$adena-$mag[cena];
if($nmoney<0){
echo'У вас не хватает золота!';
include ("inc/foter.php");
exit;
}
if($gorod=="Heine"){
$nalog=6;
}
if($gorod=="Rune Township"){
$nalog=9;
}
if($gorod=="Town of Aden"){
$nalog=25;
}
if($gorod=="Town of Dion"){
$nalog=7;
}
if($gorod=="Town of Giran"){
$nalog=20;
}
if($gorod=="Town of Gludio"){
$nalog=7;
}
if($gorod=="Town of Goddard"){
$nalog=12;
}
if($gorod=="Town of Oren"){
$nalog=5;
}
if($gorod=="Town of Schuttgart"){
$nalog=9;
}
$req = mysql_query("SELECT * FROM `l2_zamok` WHERE `city` = '$gorod' LIMIT 1");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto==1){
$city = mysql_fetch_array($req);
if($city[clan]!=''){
$req = mysql_query("SELECT * FROM `l2_clan` WHERE `glava`='$city[clan]'");
////////////////////////////
$clan = mysql_fetch_array($req);
$ma=($mag[cena]*$nalog)/100;
mysql_query("UPDATE `l2_clan` SET `aden` = `aden` + '$ma' WHERE `name` = '$clan[name]'");
}
}
$req1 = mysql_query("SELECT * FROM `l2_res` WHERE `usr` = '$nick' and `lat_name` = '$mag[lat_name]'");
$res = mysql_fetch_array($req1);
$avto1=mysql_num_rows($req1);
if($avto1==0){
mysql_query("INSERT INTO
`l2_res` SET
`usr` = '$nick',
`name` = '$mag[name]',
`lat_name` = '$mag[lat_name]',
`tip` = '$mag[tip]',
`what` = '$mag[what]',
`give` = '$mag[give]',
`kol` = '1',
`cena` = '$mag[cena]'");
}else{
$nk=$res[kol]+1;
mysql_query("UPDATE `l2_res` SET `kol` = '$nk' WHERE `usr` = '$nick' and `lat_name` = '$mag[lat_name]'");
}
mysql_query("UPDATE l2_user SET adena = '$nmoney' WHERE nick = '$nick'");
echo"
Свиток $mag[name] куплен!<br/>
Стоимостью: ".number_format ($mag[cena])." <img src='/style/main/adena.png' alt='*'/> золота<br/>
Осталось: ".number_format ($nmoney)." <img src='/style/main/adena.png' alt='*'/> золота<br/>
";
echo "<br>» <a href="magazin.php?mod=svitok"> Вернуться</a>";
}
}else{
echo "Пройдите авторизацию!";
echo "<hr><a href="index.php">На главную</a>";
}
include ("inc/foter.php");
?>