|
@@ -10,13 +10,17 @@ discard block |
|
|
block discarded – undo |
|
10
|
10
|
$sql = "SELECT `id` FROM `vehicles` INNER JOIN `players` ON vehicles.pid=players.playerid WHERE `pid` LIKE '" . $search . "' OR `classname` LIKE '%" . $search . "%' OR `name` LIKE '%" . $search . "%' OR `plate` LIKE '" . $search . "' OR `inventory` LIKE '%" . $search . "%' OR `name` LIKE '%" . $search . "%';"; |
|
11
|
11
|
$result_of_query = $db_link->query($sql); |
|
12
|
12
|
$total_records = mysqli_num_rows($result_of_query); |
|
13
|
|
- if ($pageNum > $total_records) $pageNum = $total_records; |
|
|
13
|
+ if ($pageNum > $total_records) { |
|
|
14
|
+ $pageNum = $total_records; |
|
|
15
|
+ } |
|
14
|
16
|
$sql = "SELECT vehicles.id,vehicles.pid,vehicles.classname,vehicles.active,vehicles.type,vehicles.plate,vehicles.alive,vehicles.active,players.name FROM `vehicles` INNER JOIN `players` ON vehicles.pid=players.playerid WHERE `pid` LIKE '" . $search . "' OR `vehicles.classname` LIKE '%" . $search . "%' OR `name` LIKE '%" . $search . "%' OR `vehicles.plate` LIKE '" . $search . "' OR `inventory` LIKE '%" . $search . "%' OR `name` LIKE '%" . $search . "%' " . $max . " ;"; |
|
15
|
17
|
} else { |
|
16
|
18
|
$sql = "SELECT `id` FROM `vehicles` INNER JOIN `players` ON vehicles.pid=players.playerid;"; |
|
17
|
19
|
$result_of_query = $db_link->query($sql); |
|
18
|
20
|
$total_records = mysqli_num_rows($result_of_query); |
|
19
|
|
- if ($pageNum > $total_records) $pageNum = $total_records; |
|
|
21
|
+ if ($pageNum > $total_records) { |
|
|
22
|
+ $pageNum = $total_records; |
|
|
23
|
+ } |
|
20
|
24
|
$sql = "SELECT vehicles.id,vehicles.pid,vehicles.classname,vehicles.active,vehicles.type,vehicles.plate,vehicles.alive,vehicles.active,players.name FROM `vehicles` INNER JOIN `players` ON vehicles.pid=players.playerid " . $max . " ;"; |
|
21
|
25
|
} |
|
22
|
26
|
$result_of_query = $db_link->query($sql); |
|
@@ -77,4 +81,6 @@ discard block |
|
|
block discarded – undo |
|
77
|
81
|
</table> |
|
78
|
82
|
</div> |
|
79
|
83
|
<?php |
|
80
|
|
-} else echo errorMessage(32, $lang); |
|
|
84
|
+} else { |
|
|
85
|
+ echo errorMessage(32, $lang); |
|
|
86
|
+} |