оптимизация/переписка кода

<?php I X
2 require_once('conf/dbc.php'); I X
3 require_once('conf/session_start.php'); I
X
4 I X
5 I X
6 if ((!isset($_SESSION['id'])) or (!isset
($_SESSION['nick']))) { I X
7 ?> I X
8 <script type="text/javascript"> I X
9 document.location.href = "login.php"; I
X
10 </script> I X
11 <?php I X
12 exit(); I X
13 } I X
14 I X
15 $page_title = 'S.T.A.L.K.E.R.-онлайн-
игра на мобильный'; I X
16 require_once('conf/head.php'); I X
17 if ((isset($_SESSION['id'])) and (isset
($_SESSION['nick']))) { I X
18 require_once('conf/banned.php'); I X
19 $user_id = abs(intval($_SESSION['id']));
I X
20 ///////////////////////////////// I X
21 ////////////////////////////////////
Записали локацию I X
22 $query = "Select admin, hp, max_hp,
location, m_fight, sost_cl, sost_p, sost_w
from users where id = '$user_id' limit 1";
I X
23 $result = mysqli_query($dbc, $query)
or die ('Ошибка передачи запроса к
БД6'); I X
24 $row = mysqli_fetch_array($result); I X
25 $location = $row['location']; I X
26 $m_fight=$row['m_fight']; I X
27 if ($location == 'monster1' or $location
== 'monster2' or $location == 'monster3'
or $location == 'monster4' or $location ==
'monster5' or $location == 'monster6' or
$location == 'monster7' or $location ==
'monster8' or $location == 'monster9') { I
X
28 $query_t = "Select id from users where
m_fight='$m_fight' and location =
'$location' and hp>0 and last_active >
NOW() - (300*5)"; I X
29 $result_t = mysqli_query($dbc,
$query_t) or die ('Ошибка передачи
запроса к БД2'); I X
30 $count = mysqli_num_rows($result_t);
I X
31 if ($count <= 1) { I X
32 $query_t = "Select id from users where
m_fight='$m_fight'"; I X
33 $result_t = mysqli_query($dbc,
$query_t) or die ('Ошибка передачи
запроса к БД2'); I X
34 while ($row_t=mysqli_fetch_array
($result_t)) { I X
35 $id_t=$row_t['id']; I X
36 $query = "update users set m_fight=0
where id = '$id_t' limit 1"; I X
37 $result = mysqli_query($dbc, $query)
or die ('Ошибка передачи запроса к
БД5'); I X
38 } I X
39 $query_tt = "Select id_monster from
m_fight where id_fight='$m_fight' limit
1"; I X
40 $result_tt = mysqli_query($dbc,
$query_tt) or die ('Ошибка передачи
запроса к БД2'); I X
41 $row_tt = mysqli_fetch_array
($result_tt); I X
42 $m=$row_tt['id_monster']; I X
43 I X
44 $query_tt = "Select clan, max_hp from
monsters where id_monster='$m' limit 1";
I X