Файл: phpfile/aljad.php
Строк: 148
<?
$query = "SELECT *
FROM `rukzak`WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"' and `chit`='trava' and `odeto`='0'
" ;
$sql = mysql_query($query) or die(mysql_error()) ;
if (isset($_POST['him'])) //////блок самой алхимии
{
$count = sizeof($_POST) ;
$a = 0 ;
$r = array_values($_POST) ;
$tpm = 0 ;
$mpm = 0 ;
$hpm = 0 ;
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 ((`tip`='artefakt' And `table` ='jad' )or(`chit` ='ja'))" ;
$sql8 = mysql_query($query8) or die(mysql_error()) ;
$row8 = mysql_fetch_assoc($sql8) ;
$k = mysql_num_rows($sql8) ;
if ($k == 0)
{
print "<center><div class="style_mess_no">Ошибка запроса!</div></center>" ;
exitt($row,$opredelenie) ;
}
$tpm += $row8['try'] ;
mysql_query("DELETE FROM `rukzak` WHERE `idrukzak` = '" .
mysql_real_escape_string($r[$a]) . "'and `name`='" . mysql_real_escape_string($opredelenie) .
"' and `odeto`='0' LIMIT 1") 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) ;
$tz = mt_rand(1, 100) ;
$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['alhimia'] ;
;
}
}
$r =100/($count - 1) ;
if ($r > 90)
{
$r = 90 ;
}
if ($r >= mt_rand(1, 100))
{$count=$count-1;
$tpm=round($tpm/$count);
$elnaz = "Яд"."($tpm,$count)" ;
mysql_query("INSERT INTO `rukzak` (`idrukzak`, `name` , `tip` , `nazvanie`,`try`,`time`,`sozdatel`,`lvl`,`chit` ,`par`,`table`,`rus_tip`,`rus_par`)
VALUES ('','" . mysql_real_escape_string($opredelenie) . "', 'jad', '" . mysql_real_escape_string($elnaz) .
"','$tpm','" . time() . "','" . mysql_real_escape_string($opredelenie) . "','','jad','$count','jad','Яд','яда'
)") or die(mysql_error()) ;
print "<div class="chat_conteiner">Вы создали:<br>
$elnaz <br><a href=88.php?go=allab&plavit=04 style=color:green>Создать яд</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 = $row['alhimia'] / ($count * 5) + 5 ;
$rtt1 = rand(1, $r1) ;
if ($rtt1 == 1)
{
$opitstar = $row['alhimia'] * 100 ;
$obshopit = $row['obshopit'] + $opitstar ;
$tekopit = $row['tekopit'] + $opitstar ;
print "<br>Вы повысили ваш навык <br><font color=red><b>Алхимии +1! Вы получили " .
htmlspecialchars($opitstar) . " опыта!</b></font>" ;
$row['alhimia']++ ;
$query = "UPDATE `table1` SET `alhimia`='" . mysql_real_escape_string($row['alhimia']) .
"',`obshopit`='" . mysql_real_escape_string($obshopit) . "',`tekopit`='" .
mysql_real_escape_string($tekopit) . "' WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "' LIMIT 1 ;" ;
mysql_query($query) ;
$sql = mysql_query($query) or die(mysql_error()) ;
}
echo('</div>');
;
}
else
{
print "<center><div class="style_mess_no">Вы не смогли создать яд!<br><a href=88.php?go=allab&plavit=04 style=color:green>Создать Яд</a></div></center>" ;
exitt($row,$opredelenie) ;
}
;
}
else
{
$count = sizeof($_POST) ;
if (($count - 1) > 10)
{
print "<center><div class="style_mess_no">Вы выбрали более 10 ингридиентов!<br><a href=88.php?go=allab style=green>Лаболатория</a></div></center>" ;
exitt($row,$opredelenie) ;
}
if ($count <= 1)
{
print "<center><div class="style_mess_no">Вы нечего не выбрали!<br><a href=88.php?go=allab&plavit=04 style=color:green>Создать яд</a></div></center>" ;
exitt($row,$opredelenie) ;
}
print "<div class="chat_conteiner">Для создания яда вы выбрали вы выбрали:<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) ;
/////////////////////////////////////////////////////////////////////////////
$sans = round($row1['alhimia'] / ($count - 1)) ;
$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['alhimia'] ;
;
}
}
$sans = round(100/($count - 1)) ;
//////////////////////////////
$a = 0 ;
$r = array_values($_POST) ;
print "<form name=form1 action=88.php?go=allab&plavit=4 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 ((`tip`='artefakt' And `table` ='jad' )or(`chit` ='ja'))" ;
$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++ ;
}
if ($sans > 90)
{
$sans = 90 ;
}
$rt='';
if($bonus>0){ $rt= "(+ $bonus)" ;
}
print "<br>Шанс на удачное создания яда $sans $rt %</div><li><input class=select name=him type=submit value=Создать?></li>" ;
;
}
?>