@@ 116-123 (lines=8) @@ | ||
113 | <?php |
|
114 | $sql = "SELECT `name`,`mediclevel`, $playerIdColumn as playerid FROM `players` WHERE `mediclevel` >= '1' ORDER BY `mediclevel` DESC LIMIT 10"; |
|
115 | $result_of_query = $db_link->query($sql); |
|
116 | while ($row = mysqli_fetch_assoc($result_of_query)) { |
|
117 | $playersID = $row['playerid']; |
|
118 | echo '<tr>'; |
|
119 | echo '<td>'.$row['name'].'</td>'; |
|
120 | echo '<td>'.$playersID.'</td>'; |
|
121 | echo '<td>'.$row['mediclevel'].'</td>'; |
|
122 | echo '</tr>'; |
|
123 | } ?> |
|
124 | </tbody> |
|
125 | </table> |
|
126 | </div> |
|
@@ 48-55 (lines=8) @@ | ||
45 | <?php |
|
46 | $sql = "SELECT `name`,`coplevel`, $playerIdColumn as playerid FROM `players` WHERE `coplevel` >= '1' ORDER BY `coplevel` DESC LIMIT 10"; |
|
47 | $result_of_query = $db_link->query($sql); |
|
48 | while ($row = mysqli_fetch_assoc($result_of_query)) { |
|
49 | $playersID = $row['playerid']; |
|
50 | echo '<tr>'; |
|
51 | echo '<td>'.$row['name'].'</td>'; |
|
52 | echo '<td>'.$playersID.'</td>'; |
|
53 | echo '<td>'.$row['coplevel'].'</td>'; |
|
54 | echo '</tr>'; |
|
55 | } ?> |
|
56 | </tbody> |
|
57 | </table> |
|
58 | </div> |
|
@@ 80-86 (lines=7) @@ | ||
77 | <?php |
|
78 | $sql = 'SELECT `name`, `cash`, `bankacc` FROM `players` ORDER BY `bankacc` DESC, `cash` DESC LIMIT 10'; |
|
79 | $result_of_query = $db_link->query($sql); |
|
80 | while ($row = mysqli_fetch_assoc($result_of_query)) { |
|
81 | echo '<tr>'; |
|
82 | echo '<td>'.$row['name'].'</td>'; |
|
83 | echo '<td>'.$row['cash'].'</td>'; |
|
84 | echo '<td>'.$row['bankacc'].'</td>'; |
|
85 | echo '</tr>'; |
|
86 | } ?> |
|
87 | </tbody> |
|
88 | </table> |
|
89 | </div> |
|
@@ 156-163 (lines=8) @@ | ||
153 | <?php |
|
154 | $sql = "SELECT `name`,`adminlevel`, $playerIdColumn as playerid FROM `players` WHERE `adminlevel` >= '1' ORDER BY `adminlevel` DESC LIMIT 10"; |
|
155 | $result_of_query = $db_link->query($sql); |
|
156 | while ($row = mysqli_fetch_assoc($result_of_query)) { |
|
157 | $playersID = $row['playerid']; |
|
158 | echo '<tr>'; |
|
159 | echo '<td>'.$row['name'].'</td>'; |
|
160 | echo '<td>'.$playersID.'</td>'; |
|
161 | echo '<td>'.$row['adminlevel'].'</td>'; |
|
162 | echo '</tr>'; |
|
163 | } ?> |
|
164 | </tbody> |
|
165 | </table> |
|
166 | </div> |
|
@@ 306-313 (lines=8) @@ | ||
303 | <?php |
|
304 | $sql = "SELECT `name`,`coplevel`, $playerIdColumn as playerid FROM `players` WHERE `coplevel` >= '1' ORDER BY `coplevel` DESC LIMIT 10"; |
|
305 | $result_of_query = $db_link->query($sql); |
|
306 | while ($row = mysqli_fetch_assoc($result_of_query)) { |
|
307 | $playersID = $row['playerid']; |
|
308 | echo '<tr>'; |
|
309 | echo '<td>'.$row['name'].'</td>'; |
|
310 | echo '<td>'.$playersID.'</td>'; |
|
311 | echo '<td>'.$row['coplevel'].'</td>'; |
|
312 | echo '</tr>'; |
|
313 | } ?> |
|
314 | </tbody> |
|
315 | </table> |
|
316 | </div> |
|
@@ 339-346 (lines=8) @@ | ||
336 | <?php |
|
337 | $sql = "SELECT `name`,`mediclevel`, $playerIdColumn as playerid FROM `players` WHERE `mediclevel` >= '1' ORDER BY `mediclevel` DESC LIMIT 10"; |
|
338 | $result_of_query = $db_link->query($sql); |
|
339 | while ($row = mysqli_fetch_assoc($result_of_query)) { |
|
340 | $playersID = $row['playerid']; |
|
341 | echo '<tr>'; |
|
342 | echo '<td>'.$row['name'].'</td>'; |
|
343 | echo '<td>'.$playersID.'</td>'; |
|
344 | echo '<td>'.$row['mediclevel'].'</td>'; |
|
345 | echo '</tr>'; |
|
346 | } ?> |
|
347 | </tbody> |
|
348 | </table> |
|
349 | </div> |
|
@@ 400-407 (lines=8) @@ | ||
397 | <?php |
|
398 | $sql = "SELECT `name`,`adminlevel`, $playerIdColumn as playerid FROM `players` WHERE `adminlevel` >= '1' ORDER BY `adminlevel` DESC LIMIT 10"; |
|
399 | $result_of_query = $db_link->query($sql); |
|
400 | while ($row = mysqli_fetch_assoc($result_of_query)) { |
|
401 | $playersID = $row['playerid']; |
|
402 | echo '<tr>'; |
|
403 | echo '<td>'.$row['name'].'</td>'; |
|
404 | echo '<td>'.$playersID.'</td>'; |
|
405 | echo '<td>'.$row['adminlevel'].'</td>'; |
|
406 | echo '</tr>'; |
|
407 | } ?> |
|
408 | </tbody> |
|
409 | </table> |
|
410 | </div> |
@@ 410-416 (lines=7) @@ | ||
407 | </thead> |
|
408 | <tbody> |
|
409 | <?php |
|
410 | while ($row = mysqli_fetch_assoc($result_of_query)) { |
|
411 | echo '<tr>'; |
|
412 | echo '<td>'.substr($row['pos'], 1, -1).'</td>'; |
|
413 | echo "<td><a class='btn btn-primary btn-xs' href='".$settings['url'].'editHouse/'.$row['id']."'>"; |
|
414 | echo "<i class='fa fa-pencil'></i></a></td>"; |
|
415 | echo '</tr>'; |
|
416 | } ?> |
|
417 | </tbody> |
|
418 | </table> |
|
419 | <?php echo '<a style="float: right;" href="'.$settings['url'].'houses/'.$player->playerid.'"><h4>'.$lang['more'].' <i class="fa fa-arrow-circle-right"></i></h4></a>'; |