Файл: dvig/plavit.php
Строк: 223
<?php
$queryl0 = "SELECT*
FROM `rukzak` where `name`='" . mysql_real_escape_string($opredelenie) .
"' and `odeto`='0'" ;
$sqll0 = mysql_query($queryl0) or die(mysql_error()) ;
$num_rows = mysql_num_rows($sqll0) ;
$ru = $row['lvl'] + 99+$pers_info['rukzak'] ;
if ($ru <= $num_rows)
{
print no."Вы не можете продолжать освободите рюкзак!!".d ;
exitt($row,$opredelenie) ;
}
$query = "SELECT *
FROM `rukzak`WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"' and `chit`='ruda' and `odeto`='0'
" ;
$sql = mysql_query($query) or die(mysql_error()) ;
if (isset($_POST['ok'])) //////блок самой алхимии
{
$count = sizeof($_POST) ;
$a = 0 ;
$r = array_values($_POST) ;
$ataka = 0 ;
while ($a <= 2)
{
if ((isset($r[$a]))&&(is_numeric($r[$a])))
{
$query8 = "SELECT * FROM `rukzak` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"' and `idrukzak`='" . mysql_real_escape_string($r[$a]) .
"' and `odeto`='0' and `chit`='ruda'" ;
$sql8 = mysql_query($query8) or die(mysql_error()) ;
$row8 = mysql_fetch_assoc($sql8) ;
$k = mysql_num_rows($sql8) ;
if ($k == 0)
{
print no."Ошибка запроса!".d ;
header("location:88.php?go=kuznica&plavit=00");
exitt($row,$opredelenie) ;
}
$queryr = "SELECT * FROM `ruda` where `id`='" . mysql_real_escape_string($row8['tip']) .
"'" ;
$sqlr = mysql_query($queryr) or die(mysql_error()) ;
$rowr = mysql_fetch_assoc($sqlr) ;
mysql_query("DELETE FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string
($r[$a]) . "' and `name`='" . mysql_real_escape_string($opredelenie) .
"' and `odeto`='0' ") or die(mysql_error()) ;
}
;
$a++ ;
}
$bonus = 0 ;
if ($row['polog'] == 'zamok')
{
$queryz = "SELECT * FROM `zamki` WHERE `klan`='" . mysql_real_escape_string($row['klan']) .
"' and `sewer`='" . mysql_real_escape_string($row['sevgorod']) .
"' and `wostok`='" . mysql_real_escape_string($row['wostokgorod']) . "' " ;
$sqlz = mysql_query($queryz) or die(mysql_error()) ;
if (mysql_num_rows($sqlz) == 1)
{
$rowz = mysql_fetch_assoc($sqlz) ;
$bonus = $rowz['kuznec'] ;
}
}
$tz = mt_rand(1, 100) ;
$r = $row['kuznec'] + $bonus ;
$r3 = $row['kuznec'] + $bonus ;
$ty = mt_rand(1, 38) ;
$kuz = $row['kuznec'] ;
if($pers_info['all_kraft']>time()){$r=$r*($pers_info['all_kraft_par']/100+1);
};
$t = 0 ;
if ($r > 90)
{
$r = 90 ;
}
if ($r >= mt_rand(1, 100))
{
print cat."Вы выплавили:<br>" ;
if (($r3 > 100))
{
$ty1 = mt_rand(1, 38) ;
$r = $kuz - 100 + $bonus ;
if ($r > 50)
{
$r = 50 ;
}
if ($r >= mt_rand(1, 100))
{
$queryp = "SELECT * FROM `ruda` WHERE `id`='" . mysql_real_escape_string($ty1) .
"'" ;
$sqlp = mysql_query($queryp) or die(mysql_error()) ;
$rowp = mysql_fetch_assoc($sqlp) ;
$TI = time() ;
if($row['gild_kuznec']==10){
$proc=((rand(1,50)/100)+1);
$rowp['at']=round($rowp['at']*$proc);
}
mysql_query("INSERT INTO `rukzak` ( `idrukzak` , `name` , `tip` , `nazvanie` , `try` , `time` , `sozdatel` , `lvl` , `odeto` , `chit` ,`table`,`rus_tip`,`rus_par`)
VALUES ('','" . mysql_real_escape_string($opredelenie) . "', '" .
mysql_real_escape_string($rowp['at']) . "', '" . mysql_real_escape_string($rowp['name']) .
"',
'".mysql_real_escape_string($rowp['at'])."','" . mysql_real_escape_string($TI) . "','','','0','metal','".mysql_real_escape_string($rowp['table'])."',
'".mysql_real_escape_string($rowp['rus_tip'])."',
'".mysql_real_escape_string($rowp['rus_par'])."')") or die(mysql_error
()) ;
print "" . htmlspecialchars($rowp['name']) . "<br>" ;
}
;
}
/////////////////////////////////////////////////////////////////////
if (($r3 > 200))
{
$ty1 = mt_rand(1, 38) ;
$r = $kuz - 200 + $bonus ;
if ($r > 400)
{
$r = 40 ;
}
if($pers_info['all_kraft']>time()){$r=$r*($pers_info['all_kraft_par']/100+1) ;};
if ($r >= mt_rand(1, 100))
{
$queryp = "SELECT * FROM `ruda` WHERE `id`='" . mysql_real_escape_string($ty1) .
"'" ;
$sqlp = mysql_query($queryp) or die(mysql_error()) ;
$rowp = mysql_fetch_assoc($sqlp) ;
if($row['gild_kuznec']==10){
$proc=((rand(1,50)/100)+1);
$rowp['at']=round($rowp['at']*$proc);
}
$TI = time() ;
mysql_query("INSERT INTO `rukzak` ( `idrukzak` , `name` , `tip` , `nazvanie` , `try` , `time` , `sozdatel` , `lvl` , `odeto` , `chit` ,`table`,`rus_tip`,`rus_par`)
VALUES ('','" . mysql_real_escape_string($opredelenie) . "', '" .
mysql_real_escape_string($rowp['at']) . "', '" . mysql_real_escape_string($rowp['name']) .
"',
'".mysql_real_escape_string($rowp['at'])."','" . mysql_real_escape_string($TI) . "','','','0','metal','".mysql_real_escape_string($rowp['table'])."','".mysql_real_escape_string($rowp['rus_tip'])."','".mysql_real_escape_string($rowp['rus_par'])."')") or die(mysql_error
()) ;
print "" . htmlspecialchars($rowp['name']) . "<br>" ;
}
;
}
/////////////////////////////////////////////////////////////////////
if (($r3 > 300))
{
$ty1 = mt_rand(1, 38) ;
$r = $kuz - 300 + $bonus ;
if ($r > 30)
{
$r = 30 ;
}
if($pers_info['all_kraft']>time()){$r=$r*($pers_info['all_kraft_par']/100+1) ;};
if ($r >= mt_rand(1, 100))
{
$queryp = "SELECT * FROM `ruda` WHERE `id`='" . mysql_real_escape_string($ty1) .
"'" ;
$sqlp = mysql_query($queryp) or die(mysql_error()) ;
$rowp = mysql_fetch_assoc($sqlp) ;
if($row['gild_kuznec']==10){
$proc=((rand(1,50)/100)+1);
$rowp['at']=round($rowp['at']*$proc);
}
$TI = time() ;
mysql_query("INSERT INTO `rukzak` ( `idrukzak` , `name` , `tip` , `nazvanie` , `try` , `time` , `sozdatel` , `lvl` , `odeto` , `chit` ,`table`,`rus_tip`,`rus_par`)
VALUES ('','" . mysql_real_escape_string($opredelenie) . "', '" .
mysql_real_escape_string($rowp['at']) . "', '" . mysql_real_escape_string($rowp['name']) .
"',
'".mysql_real_escape_string($rowp['at'])."','" . mysql_real_escape_string($TI) . "','','','0','metal','".mysql_real_escape_string($rowp['table'])."','".mysql_real_escape_string($rowp['rus_tip'])."','".mysql_real_escape_string($rowp['rus_par'])."')") or die(mysql_error
()) ;
print "" . htmlspecialchars($rowp['name']) . "<br>" ;
}
;
}
/////////////////////////////////////////////////////////////////////
if (($r3 > 400))
{
$ty1 = mt_rand(1, 38) ;
$r = $kuz - 400 + $bonus ;
if ($r > 20)
{
$r = 20 ;
}
if($pers_info['all_kraft']>time()){$r=$r*($pers_info['all_kraft_par']/100+1) ;};
if ($r >= mt_rand(1, 100))
{
$queryp = "SELECT * FROM `ruda` WHERE `id`='" . mysql_real_escape_string($ty1) .
"'" ;
$sqlp = mysql_query($queryp) or die(mysql_error()) ;
$rowp = mysql_fetch_assoc($sqlp) ;
if($row['gild_kuznec']==10){
$proc=((rand(1,50)/100)+1);
$rowp['at']=round($rowp['at']*$proc);
}
$TI = time() ;
mysql_query("INSERT INTO `rukzak` ( `idrukzak` , `name` , `tip` , `nazvanie` , `try` , `time` , `sozdatel` , `lvl` , `odeto` , `chit` ,`table`,`rus_tip`,`rus_par`)
VALUES ('','" . mysql_real_escape_string($opredelenie) . "', '" .
mysql_real_escape_string($rowp['at']) . "', '" . mysql_real_escape_string($rowp['name']) .
"',
'".mysql_real_escape_string($rowp['at'])."','" . mysql_real_escape_string($TI) . "','','','0','metal','".mysql_real_escape_string($rowp['table'])."','".mysql_real_escape_string($rowp['rus_tip'])."','".mysql_real_escape_string($rowp['rus_par'])."')") or die(mysql_error
()) ;
print "" . htmlspecialchars($rowp['name']) . "<br>" ;
}
;
}
/////////////////////////////////////////////////////////////////////
if (($r3 > 500))
{
$ty1 = mt_rand(1, 38) ;
$r = $kuz - 500 + $bonus ;
if ($r > 15)
{
$r = 15 ;
}
if($pers_info['all_kraft']>time()){$r=$r*($pers_info['all_kraft_par']/100+1) ;};
if ($r >= mt_rand(1, 100))
{
$queryp = "SELECT * FROM `ruda` WHERE `id`='" . mysql_real_escape_string($ty1) .
"'" ;
$sqlp = mysql_query($queryp) or die(mysql_error()) ;
$rowp = mysql_fetch_assoc($sqlp) ;
if($row['gild_kuznec']==10){
$proc=((rand(1,50)/100)+1);
$rowp['at']=round($rowp['at']*$proc);
}
$TI = time() ;
mysql_query("INSERT INTO `rukzak` ( `idrukzak` , `name` , `tip` , `nazvanie` , `try` , `time` , `sozdatel` , `lvl` , `odeto` , `chit` ,`table`,`rus_tip`,`rus_par`)
VALUES ('','" . mysql_real_escape_string($opredelenie) . "', '" .
mysql_real_escape_string($rowp['at']) . "', '" . mysql_real_escape_string($rowp['name']) .
"',
'".mysql_real_escape_string($rowp['at'])."','" . mysql_real_escape_string($TI) . "','','','0','metal','".mysql_real_escape_string($rowp['table'])."','".mysql_real_escape_string($rowp['rus_tip'])."','".mysql_real_escape_string($rowp['rus_par'])."')") or die(mysql_error
()) ;
print "" . htmlspecialchars($rowp['name']) . "<br>" ;
}
;
}
/////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////
$queryp = "SELECT * FROM `ruda` WHERE `id`='" . mysql_real_escape_string($ty) .
"'" ;
$sqlp = mysql_query($queryp) or die(mysql_error()) ;
$rowp = mysql_fetch_assoc($sqlp) ;
if($row['gild_kuznec']==10){
$proc=((rand(1,50)/100)+1);
$rowp['at']=round($rowp['at']*$proc);
}
$TI = time() ;
mysql_query("INSERT INTO `rukzak` ( `idrukzak` , `name` , `tip` , `nazvanie` , `try` , `time` , `sozdatel` , `lvl` , `odeto` , `chit` ,`table`,`rus_tip`,`rus_par`)
VALUES ('','" . mysql_real_escape_string($opredelenie) . "', '" .
mysql_real_escape_string($rowp['at']) . "', '" . mysql_real_escape_string($rowp['name']) .
"',
'".mysql_real_escape_string($rowp['at'])."','" . mysql_real_escape_string($TI) . "','','','0','metal','".mysql_real_escape_string($rowp['table'])."','".mysql_real_escape_string($rowp['rus_tip'])."','".mysql_real_escape_string($rowp['rus_par'])."')") or die(mysql_error
()) ;
print "
" . htmlspecialchars($rowp['name']) .
"<li><a href=88.php?go=kuznica&plavit=00 style=color:#CC3333>Плавить руду</a></li>".d ;
$r1 = $row['kuznec'] / 2 ;
$rtt1 = mt_rand(1, $r1) ;
if ($rtt1 == 1)
{
$opitstar = $row['kuznec'] * 100 ;
$obshopit = $row['obshopit'] + $opitstar ;
$tekopit = $row['tekopit'] + $opitstar ;
print "no<br>Вы повысили ваш навык <br><font color=red><b>Кузнец! Вы получили " .
htmlspecialchars($opitstar) . " опыта!</b></font>".d ;
$row['kuznec']++ ;
$query = "UPDATE `table1` SET `rudokop`=" . mysql_real_escape_string($row['rudokop']) .
",`obshopit`='" . mysql_real_escape_string($obshopit) . "',`tekopit`='" .
mysql_real_escape_string($tekopit) . "',`kuznec`=" . mysql_real_escape_string($row['kuznec']) .
" WHERE `name`='" . mysql_real_escape_string($opredelenie) . "' LIMIT 1 ;" ;
mysql_query($query) ;
$sql = mysql_query($query) or die(mysql_error()) ;
}
if($rowzakls[4]==0){
mysql_query( "UPdate `slava_pers` set `4`='1' WHERE `id_pers`='".$row['ID']."'") ;
$row['slava']+=100; $row['bank']+=300;
mysql_query( "UPdate `table1` set `slava`='".$row['slava']."',`bank`=".$row['bank']." WHERE `ID`='".$row['ID']."'") ;
$_SESSION['statusis']="Вы выполнили 4-е достижение";
;}
;
}
else
{
print no."Вы не смогли Выплавить руду!<br><a href=88.php?go=kuznica&plavit=00 style=color:#CC3333>Плавить руду</a>".d ;
exitt($row,$opredelenie) ;
}
;
}
?>