Cyberbyte-Studios /
CyberWorks
| @@ 7-21 (lines=15) @@ | ||
| 4 | ||
| 5 | $max = 'LIMIT ' . ($pageNum - 1) * $_SESSION['items'] . ',' . $_SESSION['items']; |
|
| 6 | ||
| 7 | if (isset($search)) { |
|
| 8 | logAction($_SESSION['user_name'], $lang['searched'] . ' (' . $search . ') ' . $lang['in'] . ' ' . $lang['vehicles'], 1); |
|
| 9 | ||
| 10 | $sql = "SELECT `id`,`pid`,`classname`,`active`,`type`,`plate`,`alive`,`active` FROM `vehicles` INNER JOIN `players` ON vehicles.pid=players.$playerIdColumn WHERE `pid` LIKE '" . $_SESSION['playerid'] . "' OR `classname` LIKE '%$search%' OR `name` LIKE '%$search%' OR `plate` LIKE '$search' OR `inventory` LIKE '%$search%';"; |
|
| 11 | $result_of_query = $db_link->query($sql); |
|
| 12 | $total_records = mysqli_num_rows($result_of_query); |
|
| 13 | if ($pageNum > $total_records) $pageNum = $total_records; |
|
| 14 | $sql = "SELECT `id`,`pid`,`classname`,`active`,`type`,`plate`,`alive`,`active` FROM `vehicles` INNER JOIN `players` ON vehicles.pid=players.$playerIdColumn WHERE `pid` LIKE '" . $_SESSION['playerid'] . "' OR `classname` LIKE '%$search%' OR `name` LIKE '%$search%' OR `plate` LIKE '$search' OR `inventory` LIKE '%$search%' $max;"; |
|
| 15 | } else { |
|
| 16 | $sql = "SELECT `id` FROM `vehicles` INNER JOIN `players` ON vehicles.pid=players.playerid WHERE `pid` LIKE '" . $_SESSION['playerid'] . "';"; |
|
| 17 | $result_of_query = $db_link->query($sql); |
|
| 18 | $total_records = mysqli_num_rows($result_of_query); |
|
| 19 | if ($pageNum > $total_records) $pageNum = $total_records; |
|
| 20 | $sql = "SELECT `id`,`pid`,`classname`,`active`,`type`,`plate`,`alive`,`active` FROM `vehicles` INNER JOIN `players` ON vehicles.pid=players.$playerIdColumn WHERE `pid` LIKE '" . $_SESSION['playerid'] . "' $max;"; |
|
| 21 | } |
|
| 22 | $result_of_query = $db_link->query($sql); |
|
| 23 | if ($result_of_query->num_rows > 0) { ?> |
|
| 24 | ||
| @@ 5-18 (lines=14) @@ | ||
| 2 | $db_link = serverConnect(); |
|
| 3 | $max = 'LIMIT ' . ($pageNum - 1) * $_SESSION['items'] . ',' . $_SESSION['items']; |
|
| 4 | ||
| 5 | if (isset($search)) { |
|
| 6 | logAction($_SESSION['user_name'], $lang['searched'] . ' (' . $search . ') ' . $lang['in'] . ' ' . $lang['vehicles'], 1); |
|
| 7 | $sql = "SELECT `id` FROM `houses` INNER JOIN `players` ON houses.pid=players.$playerIdColumn WHERE `id` LIKE '" . $search . "' OR `pos` LIKE '$search' OR `inventory` LIKE '%$search%' OR `name` LIKE '%$search%' AND `pid` = '" . $_SESSION['playerid'] . "';"; |
|
| 8 | $result_of_query = $db_link->query($sql); |
|
| 9 | $total_records = mysqli_num_rows($result_of_query); |
|
| 10 | if ($pageNum > $total_records) $pageNum = $total_records; |
|
| 11 | $sql = "SELECT `id`,`pid`,`pos`,`name`,`owned` FROM `houses` INNER JOIN `players` ON houses.pid=players.$playerIdColumn WHERE `id` LIKE '$search' OR `pos` LIKE '$search' OR `inventory` LIKE '%$search %' OR `name` LIKE '%$search%' AND `pid` = '" . $_SESSION['playerid'] . "' $max;"; |
|
| 12 | } else { |
|
| 13 | $sql = "SELECT `id` FROM `houses`;"; |
|
| 14 | $result_of_query = $db_link->query($sql); |
|
| 15 | $total_records = mysqli_num_rows($result_of_query); |
|
| 16 | if ($pageNum > $total_records) $pageNum = $total_records; |
|
| 17 | $sql = "SELECT `id`,`pid`,`pos`,`name`,`owned` FROM `houses` INNER JOIN `players` ON houses.pid=players.$playerIdColumn AND `pid` = '" . $_SESSION['playerid'] . "' $max;"; |
|
| 18 | } |
|
| 19 | ||
| 20 | $result_of_query = $db_link->query($sql); |
|
| 21 | if ($result_of_query->num_rows > 0) { ?> |
|
