Файл: phpfile/raritet.php
Строк: 148
<?php
if (isset($_POST['him'])) //////блок самой алхимии
{
$count = sizeof($_POST) ;
$a = 0 ;
$r = array_values($_POST) ;
$ataka = 0 ;$if='';
while ($a <= $count)
{
if (isset($r[$a]))
{
if (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`='gem'" ;
$sql8 = mysql_query($query8) or die(mysql_error()) ;
$row8 = mysql_fetch_assoc($sql8) ;
$k = mysql_num_rows($sql8) ;
$if.=$row8['tip'];
if ($k == 0)
{
print no."Ошибка запроса1!".d ;
exitw($row,$opredelenie) ;
}
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++ ;
}
$query = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'" ;
$sql = mysql_query($query) or die(mysql_error()) ;
$row = mysql_fetch_assoc($sql) ;
$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['artfizik'] ;
}
}
$tz = mt_rand(1, 100) ;
$r = ($row['artfizik'] + $bonus)/($count-1) ;
$ty = mt_rand(1, 38) ;
$t = 0 ;
if ($r > 90)
{
$r = 90 ;
}
if($pers_info['all_kraft']>time()){$r=$r*($pers_info['all_kraft_par']/100+1);};
if ($r > 90)
{
$r = 90 ;
}
if ($r < 10)
{
$r = 10 ;
}
if ($r >= mt_rand(1, 100))
{
$ataka ;
$queryp = "SELECT * FROM `raritet` WHERE `recept`='$if' " ;
$sqlp = mysql_query($queryp) or die(mysql_error()) ;
$k = mysql_num_rows($sqlp) ;
if ($k == 0)
{
print no."Вы не смогли создать раритет, неверный рецепт!".d ;
exitw($row,$opredelenie) ;
}
$rowpotroha = mysql_fetch_assoc($sqlp) ;
$TI = time() ;
mysql_query("INSERT INTO `rukzak`
( `idrukzak` , `name` , `tip` , `nazvanie` , `try` , `time` , `sozdatel` , `lvl` ,
`odeto` , `chit` ,`table`,`rus_tip`,`rus_par`,`vstavlen`,`par`,`table_gen`,`rus_tip_par`,`vstavlen2`,`par3`,`tip3`,`rus_par3`,`vstavlen3`,`par4`,`tip4`,`rus_par4`)
VALUES ('','" . mysql_real_escape_string($opredelenie) . "', '".$rowpotroha['location']."', '" .
mysql_real_escape_string($rowpotroha['name']) . "',
'" . mysql_real_escape_string($rowpotroha['par']) . "','" .
mysql_real_escape_string(time()) . "','$opredelenie','" .mysql_real_escape_string( $rowpotroha['lvl']) . "','0','" . mysql_real_escape_string($rowpotroha['idtip']) .
"','" . mysql_real_escape_string($rowpotroha['tip']) . "','" . mysql_real_escape_string($rowpotroha['rus_tip']) . "'
,'" .mysql_real_escape_string( $rowpotroha['rus_par']) ."' ,
'" . $rowpotroha['vstavlen'] . "' , '" . $rowpotroha['par2'] . "' , '" . $rowpotroha['tip2'] . "' , '" . $rowpotroha['rus_par2'] . "'
, '" . $rowpotroha['vstavlen2'] . "' , '" . $rowpotroha['par3'] . "' , '" . $rowpotroha['tip3'] . "' , '" . $rowpotroha['rus_par3'] . "',
'" . $rowpotroha['vstavlen3'] . "' , '" . $rowpotroha['par4'] . "' , '" . $rowpotroha['tip4'] . "' , '" . $rowpotroha['rus_par4'] . "') ") or die(mysql_error()) ;
print y."Вы создали:<br>
" . htmlspecialchars($rowpotroha['name']) .
"<br><a href=88.php?go=uvelir&plavit=04 style=color:#CC3333>Соеденить камни</a>" ;
$querypp = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'" ;
$sqlpp = mysql_query($querypp) or die(mysql_error()) ;
$rowpp = mysql_fetch_assoc($sqlpp) ;
$r1 = 1000/$row['artfizik'];
if ( $r1>mt_rand(1,1000))
{
$opitstar = $rowpp['artfizik'] * 100 ;
$obshopit = $rowpp['obshopit'] + $opitstar ;
$tekopit = $rowpp['tekopit'] + $opitstar ;
print "<br>Вы повысили ваш навык <br><font color=red><b>Артфизик +1! Вы получили $opitstar опыта!</b></font>" ;
$rowpp['artfizik']++ ;
$query = "UPDATE `table1` SET `obshopit`='" . mysql_real_escape_string($obshopit) .
"',`tekopit`='" . mysql_real_escape_string($tekopit) . "',`artfizik`='" .
mysql_real_escape_string($rowpp['artfizik']) . "' WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "' LIMIT 1 ;" ;
mysql_query($query) ;
$sql = mysql_query($query) or die(mysql_error()) ;
echo d;
}
exitw($row,$opredelenie) ;
;
}
else
{
print no."Вы не смогли Создать раритет!<br>
<a href=88.php?go=uvelir&plavit=08 style=color:#CC3333>Создать раритеты</a>".d ;
exitw($row,$opredelenie) ;
}
;
}
else
{
$count = sizeof($_POST) ;
if ($count <= 1)
{
print no."Вы выбрали менее 1 предмета!<br>
<a href=88.php?go=uvelir style=color:#CC3333>Ювелирная мастерсская</a>".d ;
exitw($row,$opredelenie) ;
}
print cat."Для создания раритета:<br>" ;
//////////////////////////////////////////////////////////
$query1 = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'" ;
$sql1 = mysql_query($query1) or die(mysql_error()) ;
$row1 = mysql_fetch_assoc($sql1) ;
/////////////////////////////////////////////////////////////////////////////
$bonus = 0 ;
if ($row['polog'] == 'zamok')
{
$queryz = "SELECT * FROM `zamki` WHERE `klan`='" . mysql_real_escape_string($row1['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['artfizik'] ;
}
}
$sans = round(($row1['artfizik'] + $bonus) /($count-1)) ;
$sans = round($sans) ;
if ($sans > 90)
{
$sans = 90 ;
}
//////////////////////////////
$a = 0 ;
$r = array_values($_POST) ;
print "<form name=form1 action=88.php?go=uvelir&plavit=8 method=post>" ;
while ($a <= $count)
{
if (isset($r[$a]))
{
if (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`='gem'" ;
$sql8 = mysql_query($query8) or die(mysql_error()) ;
$row8 = mysql_fetch_assoc($sql8) ;
print "<input type=hidden name=$a value=" . htmlspecialchars($r[$a]) .
" /> <font color=red>" . htmlspecialchars($row8['nazvanie']) . "</font>," ;
}
;
}
;
$a++ ;
}
$sans=round ($sans);
if ($sans > 90)
{
$sans = 90 ;
}
if ($sans < 10)
{
$sans = 10 ;
}
$rt='';
if($pers_info['all_kraft']>time()){$rt=$rt*($pers_info['all_kraft_par']/100+1);}
print "<br>Шанс на удачное соединение " . htmlspecialchars($sans) .
" $rt %<br><input class=select name=him type=submit value=Создать?>".d ;
;
}
?>