Файл: btcastle.php
Строк: 132
<?php
// Подключаемся к БД
$dbhost="localhost";
$dbname="db1355926987";
$dbuser="db1355926987";
$dbpass="overlord";
$lin=mysql_connect($dbhost,$dbuser,$dbpass) or die("Не могу подключиться к серверу БД");
mysql_select_db($dbname,$lin) or die("Не могу подключиться к БД");
mysql_query("SET NAMES utf8");
mysql_query("set character_set_client='utf8'");
mysql_query("set character_set_results='utf8'");
mysql_query("set collation_connection='utf8'");
// Проверка на существование акаунта
$g=mysql_query("SELECT * FROM `bishopl2_account` WHERE `account`='$account' AND `password`='$password' LIMIT 1");
if(mysql_num_rows($g)==1){
$g=mysql_query("SELECT * FROM `bishopl2_personaz` WHERE `account`='$account' AND `login`='$login' LIMIT 1");
if(mysql_num_rows($g)==1){
$g=mysql_query("SELECT * FROM `bishopl2_guardrespawn` WHERE `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==0){
$as = mysql_query("SELECT * FROM `bishopl2_personaz` WHERE `login`='".$login."'");
$pers = mysql_fetch_array($as);
$as = mysql_query("SELECT * FROM `bishopl2_guard` WHERE `id`='".$id."'");
$mob = mysql_fetch_array($as);
if (isset($mage)){
$g=mysql_query("SELECT * FROM `bishopl2_skill` WHERE `login`='".$login."' AND `name`='".$name."' LIMIT 1");
if(mysql_num_rows($g)==1){
$as = mysql_query("SELECT * FROM `bishopl2_skill` WHERE `login`='".$login."' AND `name`='".$name."'");
$skill = mysql_fetch_array($as);
if ($pers[mmp]>=$skill[mp]){
$time=time()-$skill[otkat];
$timer=$skill[time]-$time;
$ostalos=@date("s",$timer);
if($skill[time]<="$time"){
$random=rand(1,2);
if ($random=="1"){
$udarrskill=$pers[matak]+$skill[matak];
$udar=$udarrskill-$mob[mdef];
if ($udar<"0"){$udar="0";}
$newhp=$mob[mhp]-$udar;
$time=time();
$mp=$pers[mmp]-$skill[mp];
mysql_query("UPDATE `bishopl2_guard` SET `minhp`='$newhp' WHERE `id`='$id'");
mysql_query("UPDATE `bishopl2_skill` SET `time`='$time' WHERE `login`='$login' AND `name`='$name'");
mysql_query("UPDATE `bishopl2_personaz` SET `mmp`='$mp' WHERE `login`='$login'");
mysql_query("INSERT INTO `bishopl2_battle` SET `login` = '$login', `id` = '', `msg` = 'Вы ударили монстра скилом $name: <font color="lime">$udar</font> уроном<br/>- - -'");
mysql_query("INSERT INTO `bishopl2_battle` SET `login` = '$login', `id` = '', `msg` = 'Guard Castle промахнулся'");
header("Location: osada?battle&id=$id");
}
if ($random=="2"){
$udarrskill=$pers[matak]+$skill[matak];
$udar=$udarrskill-$mob[mdef];
if ($udar<"0"){$udar="0";}
$newhp=$mob[mhp]-$udar;
$time=time();
$mp=$pers[mmp]-$skill[mp];
mysql_query("UPDATE `bishopl2_guard` SET `minhp`='$newhp' WHERE `id`='$id'");
mysql_query("UPDATE `bishopl2_skill` SET `time`='$time' WHERE `login`='$login' AND `name`='$name'");
mysql_query("UPDATE `bishopl2_personaz` SET `mmp`='$mp' WHERE `login`='$login'");
$mobmudar=$mob[patak]-$pers[pdef];
if ($mobmudar<"0"){$mobmudar="0";}
$newhp=$pers[mhp]-$mobmudar;
mysql_query("UPDATE `bishopl2_personaz` SET `mhp`='$newhp' WHERE `login`='$login'");
mysql_query("INSERT INTO `bishopl2_battle` SET `login` = '$login', `id` = '', `msg` = 'Вы ударили монстра скилом $name: <font color="lime">$udar</font> уроном<br/>- - -'");
mysql_query("INSERT INTO `bishopl2_battle` SET `login` = '$login', `id` = '', `msg` = 'Guard Castle ударил вас: <font color="lime">$mobmudar</font> уроном'");
header("Location: osada?battle&id=$id");
}
}else{
header("Location: osada?battle&id=$id&otkat");
}
}else{
header("Location: osada?battle&id=$id&mana");
}
}else{
header("Location: osada?battle&id=$id&skill");
}
exit;
}else{
$random=rand(1,3);
if ($random=="1"){
$mobpudar=$mob[patak]-$pers[pdef];
if ($mobpudar<"0"){$mobpudar="0";}
$newhp=$pers[mhp]-$mobpudar;
mysql_query("UPDATE `bishopl2_personaz` SET `mhp`='$newhp' WHERE `login`='$login'");
mysql_query("INSERT INTO `bishopl2_battle` SET `login` = '$login', `id` = '', `msg` = 'Вы промахнулись<br/>- - -'");
mysql_query("INSERT INTO `bishopl2_battle` SET `login` = '$login', `id` = '', `msg` = 'Guard Castle ударил вас: <font color="lime">$mobpudar</font> уроном'");
}
if ($random=="2"){
$pudar=$pers[patak]-$mob[pdef];
if ($pudar<"0"){$pudar="0";}
$newhp=$mob[mhp]-$pudar;
mysql_query("UPDATE `bishopl2_guard` SET `minhp`='$newhp' WHERE `id`='$id'");
mysql_query("INSERT INTO `bishopl2_battle` SET `login` = '$login', `id` = '', `msg` = 'Вы ударили монстра: <font color="lime">$pudar</font> уроном<br/>- - -'");
mysql_query("INSERT INTO `bishopl2_battle` SET `login` = '$login', `id` = '', `msg` = 'Guard Castle промахнулся'");
}
if ($random=="3"){
$pudar=$pers[patak]-$mob[pdef];
if ($pudar<"0"){$pudar="0";}
$newhp=$mob[mhp]-$pudar;
mysql_query("UPDATE `bishopl2_guard` SET `minhp`='$newhp' WHERE `id`='$id'");
$mobpudar=$mob[patak]-$pers[pdef];
if ($mobpudar<"0"){$mobpudar="0";}
$newhp=$pers[mhp]-$mobpudar;
mysql_query("UPDATE `bishopl2_personaz` SET `mhp`='$newhp' WHERE `login`='$login'");
mysql_query("INSERT INTO `bishopl2_battle` SET `login` = '$login', `id` = '', `msg` = 'Вы ударили монстра: <font color="lime">$pudar</font> уроном<br/>- - -'");
mysql_query("INSERT INTO `bishopl2_battle` SET `login` = '$login', `id` = '', `msg` = 'Guard Castle ударил вас: <font color="lime">$mobpudar</font> уроном'");
}
header("Location: osada?battle&id=$id");
exit;
}
}else{
header("Location: osada?battle&id=$id");
}
}else{
// вывод если на даном акаунте нет такого персонажа
header("Location: osada?battle&id=$id");
}
}else{
// вывод если акаунт не существует
header("Location: osada?battle&id=$id");
}
?>