Cyberbyte-Studios /
CyberWorks
| @@ 5-22 (lines=18) @@ | ||
| 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 h.`id` FROM `houses` h INNER JOIN `players` p ON houses.pid=players.$playerIdColumn WHERE h.`pid` LIKE '$search ' OR p.$playerIdColumn LIKE '$search ' OR h.`pos` LIKE '$search' OR p.`name` LIKE '%$search%';"; |
|
| 8 | $result_of_query = $db_link->query($sql); |
|
| 9 | $total_records = mysqli_num_rows($result_of_query); |
|
| 10 | if ($pageNum > $total_records) { |
|
| 11 | $pageNum = $total_records; |
|
| 12 | } |
|
| 13 | $sql = "SELECT h.id, h.pid, h.pos, p.name, h.owned FROM `houses` h INNER JOIN `players` p ON h.pid=p.$playerIdColumn WHERE h.`pid` LIKE '$search ' OR p.$playerIdColumn LIKE '$search ' OR h.`pos` LIKE '$search' OR p.`name` LIKE '%$search%' $max;"; |
|
| 14 | } else { |
|
| 15 | $sql = "SELECT `id` FROM `houses`;"; |
|
| 16 | $result_of_query = $db_link->query($sql); |
|
| 17 | $total_records = mysqli_num_rows($result_of_query); |
|
| 18 | if ($pageNum > $total_records) { |
|
| 19 | $pageNum = $total_records; |
|
| 20 | } |
|
| 21 | $sql = "SELECT h.id, h.pid, h.pos, p.name, h.owned FROM `houses` h INNER JOIN `players` p ON h.pid=p.$playerIdColumn $max;"; |
|
| 22 | } |
|
| 23 | ||
| 24 | $result_of_query = $db_link->query($sql); |
|
| 25 | if ($result_of_query->num_rows > 0) { ?> |
|
| @@ 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` FROM `vehicles` INNER JOIN `players` ON vehicles.pid=players.$playerIdColumn 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 | $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 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.$playerIdColumn 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 | } else { |
|
| 16 | $sql = "SELECT `id` FROM `vehicles` INNER JOIN `players` ON vehicles.pid=players.$playerIdColumn;"; |
|
| 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 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.$playerIdColumn $max;"; |
|
| 21 | } |
|
| 22 | $result_of_query = $db_link->query($sql); |
|
| 23 | if ($result_of_query->num_rows > 0) { ?> |
|
| 24 | ||
