Файл: gamele.ru/gameplay/ajax/fish_ajax.php
Строк: 196
<?php
session_start();
include($_SERVER["DOCUMENT_ROOT"]."/includes/config.inc.php");
include($_SERVER["DOCUMENT_ROOT"]."/includes/functions.php");
$pers = GetUser();
$pt=explode("|",$pers['st']);
$fish=$pers['fish_skill']+$pt[59];
$pers['fish_skill']+=$pt[59];
//////////////////////
if($Trv>0){exit('MESS@["Вы обессилены и не можете осмотреться вокруг.<br /> У вас травма, позовите доктора.",0,0]');}
//////////////////////////////////
switch(intval($_GET['act'])){
case 1:
list($pers['x'], $pers['y']) = explode('_', $pers['pos']);
$grasssql=mysql_query("SELECT * FROM `nature_fish` WHERE `x`='".$pers['x']."' AND `y`='".$pers['y']."';");
if(mysql_num_rows($grasssql)<1){
echo'times@["Тут рыбы нет, или уровень вашего навыка недостаточен для ловли рыбы в этом месте."]@[0]';
mysql_query("UPDATE `user` SET `wait2`='".(time()+30)."' WHERE `id`='".$pers['id']."' LIMIT 1;");
}
else{
$error="";
$grassrow="";
while ($row = mysql_fetch_array($grasssql)){
$grass = explode("|",$row['grass']);
foreach ($grass as $val){
$grn=explode("@",$val);
if($grn[1]<=$pers['fish_skill']){
$allgrass = mysql_fetch_array(mysql_query("SELECT `items`.`id`,`items`.`name`,`items`.`gif` FROM `items` WHERE `id`='".$grn[0]."' LIMIT 1;"));
$grassrow.='['.$allgrass['id'].',"'.$allgrass['name'].'","'.$allgrass['gif'].'","'.vCode().'"],';
}
}
}
if($allgrass==""){
echo'times@["Тут рыбы нет, или уровень вашего навыка недостаточен для ловли рыбы в этом месте."]@[0]';
}
}
$serp=mysql_fetch_array(mysql_query('SELECT `invent`.*, `items`.* FROM `items` INNER JOIN `invent` ON `items`.`id` = `invent`.`protype` WHERE `pl_id`="'.$pers['id'].'" AND `items`.`type`="w69" AND `items`.`slot`="3" AND `invent`.`used`="1" LIMIT 1;'));
$priman=mysql_query('SELECT `invent`.*,`items`.* FROM `items` INNER JOIN `invent` ON `items`.`id` = `invent`.`protype` WHERE `pl_id`="'.$pers['id'].'" AND `items`.`type`="w69" AND `items`.`slot`!="3" AND `items`.`num_a`="34" AND `invent`.`used`="0" AND `invent`.`bank`="0";');
if(mysql_num_rows($priman)>0){
$primnames="";
while($primrow = mysql_fetch_array($priman)){
$primrowToOne[$primrow['id']+$primrow['arenda']+$primrow['rassrok']][md5($iz.'/'.$primrow['dolg'].$primrow['mod'])] += 1;
if($primrowToOne[$primrow['id']+$primrow['arenda']+$primrow['rassrok']][md5($iz.'/'.$primrow['dolg'].$primrow['mod'])] == 1){
$count = mysql_num_rows(mysql_query("SELECT `invent`.*, `items`.* FROM `items` INNER JOIN `invent` ON `items`.`id` = `invent`.`protype` WHERE `pl_id`='".$pers['id']."' and `invent`.`used`='0' and `dolg`='".$primrow['dolg']."' and `iznos`='".$primrow['iznos']."' and `items`.`id`='".$primrow['id']."' and `invent`.`arenda`='".$primrow['arenda']."' and `invent`.`rassrok`='".$primrow['rassrok']."' and `invent`.`mod`='".$primrow['mod']."' and `invent`.`bank`='0' $sq $sq2;"));
$primnames .= '['.$primrow['id'].',"'.$primrow['name'].'","'.$primrow['gif'].'","'.vCode().'","'.$count.'"],';
}
}
}
else{
$primnames = '';
}
$primnames=substr($primnames,0,strlen($primnames)-1);
$grassrow=substr($grassrow,0,strlen($grassrow)-1);
$captcha="00000";
echo 'FISH@["'.($error?$error:'').'",""]@[0,"'.$captcha.'","'.(($serp)?$serp['id_item']:'').'",1,1000,'.$grassrow.']@['.$primnames.']';
break;
case 2:
$tst = $pers['wait2']-time()-2;
if($tst>0){sleep($tst);}
list($pers['x'], $pers['y']) = explode('_', $pers['pos']);
$grasssql=mysql_query("SELECT * FROM `nature_fish` WHERE `x`='".$pers['x']."' AND `y`='".$pers['y']."';");
if(mysql_num_rows($grasssql)<1){
echo'times@["Тут рыбы нет, или уровень вашего навыка недостаточен для ловли рыбы в этом месте."]@[0]';
mysql_query("UPDATE `user` SET `wait2`='".(time()+30)."' WHERE `id`='".$pers['id']."' LIMIT 1;");
}
else{
$serp=mysql_fetch_array(mysql_query('SELECT `invent`.*, `items`.* FROM `items` INNER JOIN `invent` ON `items`.`id` = `invent`.`protype` WHERE `pl_id`="'.$pers['id'].'" AND `items`.`type`="w69" AND `items`.`slot`="3" AND `invent`.`used`="1" AND `invent`.`id_item`="'.intval($_GET['serp']).'" LIMIT 1;'));
$priman=mysql_fetch_array(mysql_query('SELECT `invent`.*,`items`.* FROM `items` INNER JOIN `invent` ON `items`.`id` = `invent`.`protype` WHERE `pl_id`="'.$pers['id'].'" AND `items`.`type`="w69" AND `items`.`slot`!="3" AND `items`.`num_a`="34" AND `invent`.`used`="0" AND `invent`.`bank`="0" AND `invent`.`protype`="'.intval($_GET['gid']).'" LIMIT 1;'));
if($serp['id_item'] and $priman['id_item']){
$error .= "<font class=proce style='color:black';>Снасти: <b>".$serp['name']."</b><br>Приманка: <b>".$priman['name']."</b></font>";
$dolg=$serp['dolg']-$serp['iznos']-1;
if($dolg<=0){
$error.="<br><font class=proce style='color:black';><b>".$serp['name']." </b>истратила всю долговечность, приобретите новую.</font>";
}
it_break($serp['id_item']);
it_break($priman['id_item']);
while ($row = mysql_fetch_array($grasssql)){
$grass = explode("|",$row['grass']);
$grn="";
for($i=0;$i<count($grass);$i++){
$grn=explode("@",$grass[$i]);
if($grn[1]<=$pers['fish_skill']){
$checkfish=mysql_fetch_array(mysql_query("SELECT * FROM `items` WHERE `id`='".intval($grn[0])."' AND `effect`='".$priman['effect']."' LIMIT 1;"));
if($checkfish['id']){
$grnadd[] = $checkfish;
}
}
}
if(count($grnadd)>0){
$rndgr = rand(0,(count($grnadd)-1));
$allgrass = $grnadd[$rndgr];
if($allgrass['dprice']>0){$pr=$allgrass['dprice'];$filt="`dprice`";}
else{$pr=$allgrass['price'];$filt="`price`";}
$par=explode("|",$allgrass['param']);
foreach ($par as $value) {
$stat=explode("@",$value);
switch($stat[0]){case 2: $dolg=$stat[1];break;}
}
if(rand(1,15)==1){
mysql_query("UPDATE `user` SET `wait2`='".(time()+300)."' WHERE `id`='".$pers['id']."' LIMIT 1;");
echo'times@["<font class=proce style=color:black;>Рыбка сорвалась: </font><font class=proce><b>'.$allgrass['name'].'</b></font>"]@[0]';
}
else{
$rndtrav=round(($pers['fish_skill']/40)+2);
if($rndtrav>5){$rndtrav=5;}
$rand=rand(1,$rndtrav);
for($i=0; $i<$rand;$i++){
$insert.="('".$allgrass['name']."','".$allgrass['gif']."','".$allgrass['id']."','".$pers['id']."','".$dolg."','".$pr."','".$allgrass['param']."','".$allgrass['need']."','".(time()+604800)."'),";
}
$insert=substr($insert,0,strlen($insert)-1);
mysql_query("INSERT INTO `invent` (`ItemName`,`img`,`protype`,`pl_id`,`dolg`,".$filt.",`i_param`,`i_need`,`death`) VALUES ".$insert.";");
mysql_query("UPDATE `user` SET `wait2`='".(time()+300)."' WHERE `id`='".$pers['id']."' LIMIT 1;");
echo'times@["<font class=proce style=color:black;>Поймано: </font><font class=proce style=color:#006600;><b>'.$allgrass['name'].' </b>('.$rand.' шт.)</font>"]@[0]';
$upcoeff=round(($pers['fish_skill']-$pt[59]+15)/2);
if($upcoeff>50){$upcoeff=50;}
$rndtravup=rand(1,$upcoeff);
if($rndtravup==1){
$skill=1;
mysql_query("UPDATE `user` SET `fish_skill`=`fish_skill`+'1' WHERE `id`='".$pers['id']."' LIMIT 1;");
mysql_query("INSERT INTO `chat` (`time`,`login`,`dlya`,`msg`) VALUES ('".time()."','sys','<".$pers['login'].">','".addslashes("top.frames['chmain'].add_msg('<font class=chattime> ".date("H:i:s")." </font><font color=000000><font color=#cc0000><b>Системная информация!</b></font> Умение Рыбалка увеличено до ".$pers["fish_skill"]+$skill." <BR>'+'');")."');");
$error.="<br><br><font class=proce>Поздравляем, вы подняли навык:</font><br><font class=proce style='color:black';><b>Рыболов </font><font class=proce style='color:#006600;'>+1</font>.</b>";
}
}
}else{echo'times@["Тут рыбы нет, или уровень вашего навыка недостаточен для ловли рыбы в этом месте."]@[0]';}
}
}
}
$captcha="00000";
echo 'FISH@["'.($error?$error:'test').'"]';
break;
}
?>