Файл: gamele.ru/includes/locations/faters/auction.php
Строк: 135
<?php
$build = mysql_fetch_assoc(mysql_query("SELECT * FROM `locations` WHERE `id` = '".$pers['loc']."'"));
function ShowSellItems($sql){
$Query = mysql_query($sql);
if(mysql_num_rows($Query)){
$OutPut = '';
while($row = mysql_fetch_assoc($Query)){
$ssv = $trb = '';
$par = explode("|",$row['i_param']);
foreach($par as $value){
$stat = explode("@",$value);
$ssv[$stat[0]] = $stat[1];
}
$need = explode("|",$row['i_need']);
foreach($need as $value) {
$treb = explode("@",$value);
$trb[$treb[0]] = $treb[1];
}
// Перекодируем удар
$Udar = array(0,0);
if($ssv[1]){
$Udar = explode("-",$ssv[1]);
}
// Items Type
$ItemType = 0;
if($row['hand']){ //Одна или 2 руки
$ItemType = 2;
}
if($row['slot'] == 16){ // Одиваем на кольчуги
$ItemType = 3;
}
// Выводим OutPut
$OutPut .= '['.$row['id_item'].',"'.vCode().'","'.$row['ItemName'].'|'.$row['img'].'|'.$row['type'].'|'.$ItemType.'|'.$row['price'].'|'.$row['block'].'|'.($row['dolg']-$row['iznos']).'|'.$row['dolg'].'|'.$Udar[0].'|'.$Udar[1].'|'.$ssv[3].'|'.$ssv[7].'|'.$ssv[8].'|'.$ssv[5].'|'.$ssv[6].'|'.$ssv[9].'|'.$ssv[10].'|0|'.$ssv[27].'|0|'.$ssv[30].'|'.$ssv[32].'|'.$ssv[31].'|'.$ssv[34].'|'.$ssv[35].'|0|'.$ssv[36].'|'.$ssv[37].'|'.$ssv[38].'|'.$ssv[39].'|'.$ssv[40].'|'.$ssv[41].'|'.$ssv[42].'|'.$ssv[43].'|'.$ssv[44].'|0|'.$ssv[28].'|'.$ssv[45].'|'.$ssv[46].'|'.$ssv[47].'|'.$ssv[48].'|'.$ssv[49].'|'.$ssv[50].'|'.$ssv[51].'|'.$ssv[52].'|0|'.$ssv[53].'|'.$ssv[54].'|'.$ssv[55].'|'.$ssv[56].'|'.$ssv[57].'|'.$ssv[58].'|'.$ssv[59].'|'.$ssv[60].'|'.$ssv[61].'|'.$ssv[62].'|'.$ssv[63].'|'.$ssv[64].'|'.$ssv[66].'|'.$ssv[67].'|'.$ssv[68].'|'.$ssv[69].'|'.$ssv[70].'","'.$row['type'].'||'.$row['level'].'|'.$trb[30].'|'.$trb[32].'|'.$trb[31].'|'.$trb[34].'|'.$trb[35].'|'.$trb[33].'|'.$row['massa'].'|'.$trb[36].'|'.$trb[37].'|'.$trb[38].'|'.$trb[39].'|'.$trb[40].'|'.$trb[41].'|'.$trb[42].'|'.$trb[43].'|'.$trb[44].'|0|'.$trb[45].'|'.$trb[46].'|'.$trb[47].'|'.$trb[48].'|'.$trb[55].'|'.$trb[57].'|'.$trb[64].'|'.$trb[68].'|0|'.$trb[70].'|'.$trb[28].'"],';
}
return substr($OutPut,0,strlen($OutPut)-1);
}else{
return false;
}
}
function ShowBuyItems($CatID){
global $pers;
$Query1 = mysql_query("SELECT * FROM `auction` WHERE `ItemCat`='".$CatID."' and `time`>'".time()."'");
if(mysql_num_rows($Query1)){
$OutPut = '';
while($row1 = mysql_fetch_assoc($Query1)){
$Query = mysql_query("SELECT `invent`.*, `items`.*, `invent`.`price`, `invent`.`dprice` FROM `items` INNER JOIN `invent` ON `items`.`id` = `invent`.`protype` WHERE `invent`.`auction`='1' and `invent`.`id_item`='".$row1['ItemID']."'");
while($row = mysql_fetch_assoc($Query)){
$ssv = $trb = '';
$par = explode("|",$row['i_param']);
foreach($par as $value){
$stat = explode("@",$value);
$ssv[$stat[0]] = $stat[1];
}
$need = explode("|",$row['i_need']);
foreach($need as $value) {
$treb = explode("@",$value);
$trb[$treb[0]] = $treb[1];
}
// Перекодируем удар
$Udar = array(0,0);
if($ssv[1]){
$Udar = explode("-",$ssv[1]);
}
// Items Type
$ItemType = 0;
if($row['hand']){ //Одна или 2 руки
$ItemType = 2;
}
if($row['slot'] == 16){ // Одиваем на кольчуги
$ItemType = 3;
}
// Выводим OutPut
$OutPut .= '['.$row1['id'].','.$row['id_item'].','.$row1['SecondBetID'].','.(($pers['id'] != $row1['FirstBetID'])?0:$pers['id']).','.$row1['ItemPrice'].',"'.date("d.m.Y",$row1['time']).'","'.$row['ItemName'].'|'.$row['img'].'|'.$row['type'].'|'.$ItemType.'|'.$row['price'].'|'.$row['block'].'|'.($row['dolg']-$row['iznos']).'|'.$row['dolg'].'|'.$Udar[0].'|'.$Udar[1].'|'.$ssv[3].'|'.$ssv[7].'|'.$ssv[8].'|'.$ssv[5].'|'.$ssv[6].'|'.$ssv[9].'|'.$ssv[10].'|0|'.$ssv[27].'|0|'.$ssv[30].'|'.$ssv[32].'|'.$ssv[31].'|'.$ssv[34].'|'.$ssv[35].'|0|'.$ssv[36].'|'.$ssv[37].'|'.$ssv[38].'|'.$ssv[39].'|'.$ssv[40].'|'.$ssv[41].'|'.$ssv[42].'|'.$ssv[43].'|'.$ssv[44].'|0|'.$ssv[28].'|'.$ssv[45].'|'.$ssv[46].'|'.$ssv[47].'|'.$ssv[48].'|'.$ssv[49].'|'.$ssv[50].'|'.$ssv[51].'|'.$ssv[52].'|0|'.$ssv[53].'|'.$ssv[54].'|'.$ssv[55].'|'.$ssv[56].'|'.$ssv[57].'|'.$ssv[58].'|'.$ssv[59].'|'.$ssv[60].'|'.$ssv[61].'|'.$ssv[62].'|'.$ssv[63].'|'.$ssv[64].'|'.$ssv[66].'|'.$ssv[67].'|'.$ssv[68].'|'.$ssv[69].'|'.$ssv[70].'","'.$row['type'].'||'.$row['level'].'|'.$trb[30].'|'.$trb[32].'|'.$trb[31].'|'.$trb[34].'|'.$trb[35].'|'.$trb[33].'|'.$row['massa'].'|'.$trb[36].'|'.$trb[37].'|'.$trb[38].'|'.$trb[39].'|'.$trb[40].'|'.$trb[41].'|'.$trb[42].'|'.$trb[43].'|'.$trb[44].'|0|'.$trb[45].'|'.$trb[46].'|'.$trb[47].'|'.$trb[48].'|'.$trb[55].'|'.$trb[57].'|'.$trb[64].'|'.$trb[68].'|0|'.$trb[70].'|'.$trb[28].'","'.(($row1['FirstBetID'] != $pers['id'] && $row1['uid'] != $pers['id'] && $pers['nv'] > ($row1['ItemPrice']+($row1['ItemPrice']*0.05)))?vCode():'').'","'.(($row1['FirstBetID'] == 0 && $row1['uid'] == $pers['id'])?vCode():'').'"],';
}
}
return substr($OutPut,0,strlen($OutPut)-1);
}
}
echo'<HTML>
<HEAD>
<LINK href="/css/frame.css" rel="STYLESHEET" type="text/css">
<META Http-Equiv="Content-Type" Content="text/html; charset=windows-1251">
<META Http-Equiv="Cache-Control" Content="No-Cache">
<META Http-Equiv="Pragma" Content="No-Cache">
<META Http-Equiv="Expires" Content="0">
<SCRIPT src="/js/t_v01.js"></SCRIPT>
<SCRIPT src="/js/signs.js"></SCRIPT>
<SCRIPT src="/js/build_v02.js"></SCRIPT>
<SCRIPT src="/js/hpmp.js"></SCRIPT>
<SCRIPT src="/js/hau.js"></SCRIPT>
</HEAD>
<BODY>
<SCRIPT language="JavaScript">
var d = document;
var adata = [';
switch($_GET['type']){
case'1':
if(!empty($_GET['sell'])){
echo ShowSellItems("SELECT `invent`.*, `items`.*, `invent`.`price`, `invent`.`dprice` FROM `items` INNER JOIN `invent` ON `items`.`id` = `invent`.`protype` WHERE `invent`.`pl_id`='".$pers['id']."' and `invent`.`used`='0' and `invent`.`cl_id`='' and `items`.`dcat`>'4' and `items`.`dcat`<'11' and `invent`.`auction`='0'");
}else{
echo ShowBuyItems("1");
}
break;
case'2':
if(!empty($_GET['sell'])){
echo ShowSellItems("SELECT `invent`.*, `items`.*, `invent`.`price`, `invent`.`dprice` FROM `items` INNER JOIN `invent` ON `items`.`id` = `invent`.`protype` WHERE `invent`.`pl_id`='".$pers['id']."' and `invent`.`used`='0' and `invent`.`cl_id`='' and `invent`.`botdrop`='1' and `invent`.`auction`='0'");
}else{
echo ShowBuyItems("2");
// echo'[460414,65375031,402043,0,2500,"28.02.2013","Дубина Огра|i_w3_ogr.gif|w3|2|2500|80|20|20|60|80|0|100|100|0|50|0|60|0|0|0|6|6|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0","w3||16|60|40|0|0|0|45|50|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|80","","1"]';
}
break;
/* А вот этот функциона уже продумывайте сами, все зависит от того что вы хотите продавать....
case'3':
echo ShowBuyItems("тут должен быть SQL запрос");
break;
case'4':
echo ShowBuyItems("тут должен быть SQL запрос");
break;
*/
case'5':
$Satats = '';
for($i = 1;$i <= 4; $i++){
$Query = mysql_query("SELECT `ItemPrice` FROM `auction` WHERE `ItemCat` = '".$i."'");
$Satats[$i]['price'] = 0;
while($row = mysql_fetch_assoc($Query)){
$Satats[$i]['price'] += $row['ItemPrice'];
}
$Satats[$i]['count'] = mysql_num_rows($Query);
}
$FullCount = ($Satats[1]['count']+$Satats[2]['count']+$Satats[3]['count']+$Satats[4]['count']);
$FullPrice = ($Satats[1]['price']+$Satats[2]['price']+$Satats[3]['price']+$Satats[4]['price']);
echo $Satats[1]['count'].','.$Satats[2]['count'].','.$Satats[3]['count'].','.$Satats[4]['count'].','.$FullCount.','.$Satats[1]['price'].','.$Satats[2]['price'].','.$Satats[3]['price'].','.$Satats[4]['price'].','.$FullPrice;
break;
}
echo'];
var build = ["'.$pers['login'].'",'.$pers['level'].','.$pers['sklon'].',"'.$pers['clan_gif'].'","'.$pers['clan'].'","'.$pers['clan_d'].'",'.$build['but'].',"main","'.$build['disbut'].'","'.$build['textid'].'"];
var inshp = ['.InsHP().'];
var vcode = ["'.vCode().'","'.vCode().'","'.vCode().'"];
var haupa = ['.$pers['id'].','.$pers['nv'].','.intval($_GET['type']).','.intval($_GET['sell']).','.intval($_GET['minl']).','.intval($_GET['maxl']).','.intval($_GET['cat']).'];
view_hau();
</SCRIPT>
</BODY>
</HTML>';