Помогите вырезать функцию отвичающюю за время,и перевести на mysqli

[code]<?php
require_once ('system/func.php');
auth(); // Закроем от гостей
if($_GET['id']){
$id = num($_GET['id']);
# Находим башню в базе #
$batle = mysqli_query("SELECT * FROM `bashna` WHERE `id` = '$id' ORDER BY `id` LIMIT 1");
$batle = mysql_fetch_array($batle);
if(!$batle){
header('Location: /war/');
exit();
}
$myLog = mysqli_query("SELECT * FROM `bashna_log` WHERE `id_user` = '$myID' AND `tipe` = 'user' ORDER BY `id` DESC LIMIT 1");
$myLog = mysqli_fetch_array($myLog);
$quest_1 = mysql_fetch_assoc(mysql_query("SELECT * FROM `quest` WHERE `id` = '3'"));
$q_1 = mysql_fetch_assoc(mysql_query("SELECT * FROM `quest_user` WHERE `id_quest` = '$quest_1[id]' AND `id_user` = '$myID'"));
$quest_2 = mysql_fetch_assoc(mysql_query("SELECT * FROM `quest` WHERE `id` = '8'"));
$q_2 = mysql_fetch_assoc(mysql_query("SELECT * FROM `quest_user` WHERE `id_quest` = '$quest_2[id]' AND `id_user` = '$myID'"));
if($batle['health'] > $batle['max_health'])$batle['health'] = $batle['max_health'];
if($batle['health'] < 0)$batle['health'] = 0;
# Ремонт #
if(isset($_GET['remont']) and $user['side'] == $batle['side']){
if($batle['health'] == $batle['max_health']){
$_SESSION['msg'] = "Локация ещё в порядке";
header('Location: ?');
exit();
}
if($user['kamen'] < 1){
$_SESSION['msg'] = "У вас не хватает ".ico('icons','kamen.png')." ".(1-$user['kamen'])." камня";
header("Location: ?");
exit();
}
if($user['trava'] < 1){
$_SESSION['msg'] = "У вас не хватает ".ico('icons','trava.png')." ".(1-$user['trava'])." травы";
header("Location: ?");
exit();
}
$rand = rand(1,2);
mysql_query("update `bashna` set `health` = '".($batle['health']+$rand*ceil($user['max_health']*10/100))."' where (`id` = '".$batle['id']."')");
mysql_query("update `users` set `kamen` = '".($user['kamen']-1)."', `trava` = '".($user['trava']-1)."' where (`id` = '".$myID."')");
mysql_query("INSERT INTO `bashna_log` SET `id_user` = '$myID', `tipe` = 'remont', `uron` = '".$rand*ceil($user['max_health']*10/100)."', `id_bashna` = '$batle[id]'");
if($q_2['last'] < time())mysql_query("update `quest_user` set `koll` = `koll`+'".($rand*ceil($user['max_health']*10/100))."' where (`id` = '".$q_2['id']."')");
$_SESSION['msg'] = 'Ремонт прошёл успешно';
header("Location: ?");
exit();
}
# Атака #
if(isset($_GET['attack']) and $user['side'] != $batle['side'] and $batle['last'] < time()){
if(isset($myLog) and $myLog['time'] > time()){
header('Location: ?');
exit();
}
$_hp = ceil($user['max_health']*10/100);
if($user['health'] < $_hp){
$_SESSION['msg'] = "Для нападения необходимо минимум ".ico('icons','health.png')." 10% здоровья!<br><a href='/rinok?koldun&url=/war/$batle[id]/?$random' class='btn2' data-ajax>Восстановить ".ico('icons','gold.png')." 15</a>";
header('Location: ?');
exit();
}
if(mt_rand(0,100) < $user['krit']){
$krit = true;
}
if($krit)$_str *= 2;
# Статы башни #
$batle_str = ceil($user['str']*75/100);
$batle_def = ceil($user['def']*70/100);
# Урон #
$_str_opp = rand(round($batle_str/6), round($batle_str/4));
$_def_opp = rand(round($batle_def/12), round($batle_def/7));
$_str_opp = $_str_opp - $_def;
if($_str_opp < 0)$_str_opp = 0;
$_str = $_str - $_def_opp;
if($_str < 0)$_str = 0;
if($q_1['last'] < time())mysql_query("update `quest_user` set `koll` = `koll`+'$_str' where (`id` = '".$q_1['id']."')");
mysql_query("INSERT INTO `bashna_log` SET `id_user` = '$myID', `tipe` = 'bashna', `uron` = '".$_str_opp."', `id_bashna` = '$batle[id]'");
mysql_query("INSERT INTO `bashna_log` SET `id_user` = '$myID', `tipe` = 'user', `uron` = '".$_str."', `krit` = '".($krit == true ? 1 : 0)."', `time` = '".(time()+15)."', `id_bashna` = '$batle[id]'");
mysql_query("update `bashna` set `health` = '".($batle['health']-$_str)."' where (`id` = '".$batle['id']."')");
if($_str >= $batle['health']){
mysql_query("update `bashna` set `side` = '".$user['side']."', `health` = '".$batle['max_health']."', `last` = '".(time()+60*30)."' where (`id` = '".$batle['id']."')");
mysql_query("update `users` set `gold` = '".($user['gold']+$batle['gold'])."' where (`id` = '".$myID."')");
mysql_query("DELETE FROM `bashna_log` WHERE `id_bashna` = '$batle[id]'");
mysql_query("INSERT INTO `bashna_log` SET `id_user` = '$myID', `tipe` = 'zahvat', `id_bashna` = '$batle[id]'");
$_SESSION['msg'] = "<font color='green'><b>Вы захватили $title</b></font>";
}
$exp = exp_koll(ceil($_str*50/100));
if($effect_2['on'] == 1)$exp = $exp+ceil($exp*25/100);
mysql_query("update `users` set `health` = '".($user['health']-$_str_opp)."', `exp` = '".($user['exp']+$exp)."' where (`id` = '".$myID."')");
if($user[id_clan] > 0){
mysql_query("UPDATE `users` SET `clan_exp` = '".($user['clan_exp']+clan_exp_koll($exp))."', `clan_exp_24` = '".($user['clan_exp_24']+clan_exp_koll($exp))."' WHERE `id` = '".$myID."' LIMIT 1");
mysql_query("UPDATE `clans` SET `exp` = `exp` + '".clan_exp_koll($exp)."' WHERE `id` = '".$user['id_clan']."' LIMIT 1");
}
$_SESSION['itog'] = "Добыто ".ico('icons','exp.png')." $exp опыта";
header("Location: ?");
exit();
}
# Страничка башни #
$title = $batle['name'];
require_once ('system/header.php');
echo "<div class='block'>";
$progress = round($batle['health
________
посл. ред. 05.05.2019 в 18:35; всего 1 раз(а); by _Terry_

Что перевести на mysqli?

[code]<?php
require_once ('system/func.php');
auth(); // Закроем от гостей
if($_GET['id']){
$id = num($_GET['id']);
# Находим башню в базе #
$batle = mysqli_query("SELECT * FROM `bashna` WHERE `id` = '$id' ORDER BY `id` LIMIT 1");
$batle = mysql_fetch_array($batle);
if(!$batle){
header('Location: /war/');
exit();
}
$myLog = mysqli_query("SELECT * FROM `bashna_log` WHERE `id_user` = '$myID' AND `tipe` = 'user' ORDER BY `id` DESC LIMIT 1");
$myLog = mysqli_fetch_array($myLog);
$quest_1 = mysql_fetch_assoc(mysql_query("SELECT * FROM `quest` WHERE `id` = '3'"));
$q_1 = mysql_fetch_assoc(mysql_query("SELECT * FROM `quest_user` WHERE `id_quest` = '$quest_1[id]' AND `id_user` = '$myID'"));
$quest_2 = mysql_fetch_assoc(mysql_query("SELECT * FROM `quest` WHERE `id` = '8'"));
$q_2 = mysql_fetch_assoc(mysql_query("SELECT * FROM `quest_user` WHERE `id_quest` = '$quest_2[id]' AND `id_user` = '$myID'"));
if($batle['health'] > $batle['max_health'])$batle['health'] = $batle['max_health'];
if($batle['health'] < 0)$batle['health'] = 0;
# Ремонт #
if(isset($_GET['remont']) and $user['side'] == $batle['side']){
if($batle['health'] == $batle['max_health']){
$_SESSION['msg'] = "Локация ещё в порядке";
header('Location: ?');
exit();
}
if($user['kamen'] < 1){
$_SESSION['msg'] = "У вас не хватает ".ico('icons','kamen.png')." ".(1-$user['kamen'])." камня";
header("Location: ?");
exit();
}
if($user['trava'] < 1){
$_SESSION['msg'] = "У вас не хватает ".ico('icons','trava.png')." ".(1-$user['trava'])." травы";
header("Location: ?");
exit();
}
$rand = rand(1,2);
mysql_query("update `bashna` set `health` = '".($batle['health']+$rand*ceil($user['max_health']*10/100))."' where (`id` = '".$batle['id']."')");
mysql_query("update `users` set `kamen` = '".($user['kamen']-1)."', `trava` = '".($user['trava']-1)."' where (`id` = '".$myID."')");
mysql_query("INSERT INTO `bashna_log` SET `id_user` = '$myID', `tipe` = 'remont', `uron` = '".$rand*ceil($user['max_health']*10/100)."', `id_bashna` = '$batle[id]'");
if($q_2['last'] < time())mysql_query("update `quest_user` set `koll` = `koll`+'".($rand*ceil($user['max_health']*10/100))."' where (`id` = '".$q_2['id']."')");
$_SESSION['msg'] = 'Ремонт прошёл успешно';
header("Location: ?");
exit();
}
# Атака #
if(isset($_GET['attack']) and $user['side'] != $batle['side'] and $batle['last'] < time()){
if(isset($myLog) and $myLog['time'] > time()){
header('Location: ?');
exit();
}
$_hp = ceil($user['max_health']*10/100);
if($user['health'] < $_hp){
$_SESSION['msg'] = "Для нападения необходимо минимум ".ico('icons','health.png')." 10% здоровья!<br><a href='/rinok?koldun&url=/war/$batle[id]/?$random' class='btn2' data-ajax>Восстановить ".ico('icons','gold.png')." 15</a>";
header('Location: ?');
exit();
}
if(mt_rand(0,100) < $user['krit']){
$krit = true;
}
if($krit)$_str *= 2;
# Статы башни #
$batle_str = ceil($user['str']*75/100);
$batle_def = ceil($user['def']*70/100);
# Урон #
$_str_opp = rand(round($batle_str/6), round($batle_str/4));
$_def_opp = rand(round($batle_def/12), round($batle_def/7));
$_str_opp = $_str_opp - $_def;
if($_str_opp < 0)$_str_opp = 0;
$_str = $_str - $_def_opp;
if($_str < 0)$_str = 0;
if($q_1['last'] < time())mysql_query("update `quest_user` set `koll` = `koll`+'$_str' where (`id` = '".$q_1['id']."')");
mysql_query("INSERT INTO `bashna_log` SET `id_user` = '$myID', `tipe` = 'bashna', `uron` = '".$_str_opp."', `id_bashna` = '$batle[id]'");
mysql_query("INSERT INTO `bashna_log` SET `id_user` = '$myID', `tipe` = 'user', `uron` = '".$_str."', `krit` = '".($krit == true ? 1 : 0)."', `time` = '".(time()+15)."', `id_bashna` = '$batle[id]'");
mysql_query("update `bashna` set `health` = '".($batle['health']-$_str)."' where (`id` = '".$batle['id']."')");
if($_str >= $batle['health']){
mysql_query("update `bashna` set `side` = '".$user['side']."', `health` = '".$batle['max_health']."', `last` = '".(time()+60*30)."' where (`id` = '".$batle['id']."')");
mysql_query("update `users` set `gold` = '".($user['gold']+$batle['gold'])."' where (`id` = '".$myID."')");
mysql_query("DELETE FROM `bashna_log` WHERE `id_bashna` = '$batle[id]'");
mysql_query("INSERT INTO `bashna_log` SET `id_user` = '$myID', `tipe` = 'zahvat', `id_bashna` = '$batle[id]'");
$_SESSION['msg'] = "<font color='green'><b>Вы захватили $title</b></font>";
}
$exp = exp_koll(ceil($_str*50/100));
if($effect_2['on'] == 1)$exp = $exp+ceil($exp*25/100);
mysql_query("update `users` set `health` = '".($user['health']-$_str_opp)."', `exp` = '".($user['exp']+$exp)."' where (`id` = '".$myID."')");
if($user[id_clan] > 0){
mysql_query("UPDATE `users` SET `clan_exp` = '".($user['clan_exp']+clan_exp_koll($exp))."', `clan_exp_24` = '".($user['clan_exp_24']+clan_exp_koll($exp))."' WHERE `id` = '".$myID."' LIMIT 1");
mysql_query("UPDATE `clans` SET `exp` = `exp` + '".clan_exp_koll($exp)."' WHERE `id` = '".$user['id_clan']."' LIMIT 1");
}
$_SESSION['itog'] = "Добыто ".ico('icons','exp.png')." $exp опыта";
header("Location: ?");
exit();
}
# Страничка башни #
$title = $batle['name'];
require_once ('system/header.php');
echo "<div class='block'>";
$progress = round($batle['health'

Научитесь уже обменниками кодом пользоваться!

Cezarionis , скинь ссылку на обменник кода,плиз

https://pastebin.com/

Cezarionis , https://pastebin.com/0RmgGeCQ

ооо... тут же есть код?
<php echo'hello world';
?>

подсветки нет ск...