Файл: gamele.ru/includes/locations/map/alhim/alhim_create.php
Строк: 88
<?
$pers = GetUser($user['login']);
$pt=allparam($pers);
$err="0";
$chrecipe = mysql_query("SELECT * FROM `alhim` WHERE `id`='".intval($_POST['rid'])."' LIMIT 1;");
if(mysql_num_rows($chrecipe)>0){
$chrecipe=mysql_fetch_array($chrecipe);
if($pers['alhim_rec']=="0"){$alhim_rec = "0";}
else{$alhim_rec = explode("|",$pers['alhim_rec']);}
if($pt[68]>=$chrecipe['nav'] and in_array($chrecipe['id'],$alhim_rec)){
$reg = explode("|",$chrecipe['reagents']);
$regmiss="";
$grassit = mysql_query("SELECT * FROM `items` WHERE `type`='w66' AND `slot`='0' or `type`='w71';");
while ($grow = mysql_fetch_array($grassit)){
$plcol[$grow['id']] = mysql_num_rows(mysql_query("SELECT `invent`.`id_item` FROM `invent` WHERE `protype`='".$grow['id']."' AND `pl_id`='".$pers['id']."'"));
}
foreach ($reg as $val){
$reagent=explode("@",$val);
$regit = mysql_fetch_array(mysql_query("SELECT `items`.`name` FROM `items` WHERE `items`.`id`='".$reagent[0]."' LIMIT 1;"));
if($plcol[$reagent[0]]<$reagent[1]){
$regmiss.='<b>'.$regit['name'].'</b> в количестве '.($reagent[1]-$plcol[$reagent[0]]).' шт.<br>';
$err="1";
$dolg=$IT['dolg']-$IT['iznos']-1;
}
}
$IT=mysql_fetch_array(mysql_query('SELECT `invent`.*, `items`.* FROM `items` INNER JOIN `invent` ON `items`.`id` = `invent`.`protype` WHERE `items`.`id`="'.$chrecipe['protype'].'" LIMIT 1;'));
if($IT!='' and $err=="0"){
$pr=explode("|",$IT['param']);
foreach ($pr as $value) {$stat=explode("@",$value);switch($stat[0]){case 2: $dolg=$stat[1];break;}}
$insert="";
for($i=0;$i<$chrecipe['col'];$i++){$insert.="('".$IT['name']."','".$IT['gif']."','".$IT['id']."','".$pers['id']."','".$dolg."','".$IT['price']."','".$IT['param']."','".$IT['need']."','".(time()+86400*$IT['srok'])."'),";}
$insert=substr($insert,0,strlen($insert)-1);
foreach ($reg as $val){
$reagent=explode("@",$val);
mysql_query("DELETE FROM `invent` WHERE `pl_id`='".$pers['id']."' AND `protype`='".$reagent[0]."' AND `bank`='0' ORDER by `death` LIMIT ".$reagent[1].";");
}
mysql_query("INSERT INTO `invent` (`ItemName`,`img`,`protype`,`pl_id`,`dolg`,`price`,`i_param`,`i_need`,`death`) VALUES ".$insert.";");
mysql_query("INSERT INTO `chat` (`time`,`login`,`dlya`,`msg`) VALUES ('".time()."','sys','<".$pers['login'].">','".addslashes("top.frames['chmain'].add_msg('<div id=msg><font class=massm> GameLE.Ru </font> <font color=000000>Вы успешно создали <b>".$IT['name']."</b> x".$chrecipe['col'].".</font></font><br></div>'+'');")."');");
$upcoeff=round(($pers['alhim']-$pt[68]+15)/2);
if($upcoeff>50){$upcoeff=50;}
$rndtravup=rand(1,$upcoeff);
if($rndtravup==1){
$skil=$pers['alhim']+1;
mysql_query("UPDATE `user` SET `alhim`=`alhim`+'1' WHERE `id`='".$player['id']."'");
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["alhim"]+$skill." <BR>'+'');")."');");
}
}
else if($err=="1"){echo'<center><b><font class=nickname><font color=#cc0000>Недостаточно реагентов</font></font></b><br>'.$regmiss.'</center>';}
else if($IT==''){echo'<center><b><font class=nickname><font color=#cc0000>Недостаточно реагентов</font></font></b></center>';}
}
}
?>