Cyberbyte-Studios / CyberWorks

                        <?php

                        $sql = "SELECT `name`,`mediclevel`, $playerIdColumn as playerid FROM `players` WHERE `mediclevel` >= '1' ORDER BY `mediclevel` DESC LIMIT 10";

            $result_of_query = $db_link->query($sql);

            while ($row = mysqli_fetch_assoc($result_of_query)) {

                $playersID = $row['playerid'];

                echo '<tr>';

                echo '<td>'.$row['name'].'</td>';

                echo '<td>'.$playersID.'</td>';

                echo '<td>'.$row['mediclevel'].'</td>';

                echo '</tr>';

            } ?>

                        </tbody>

                    </table>

                </div>

                    <?php

                    $sql = "SELECT `name`,`coplevel`, $playerIdColumn as playerid FROM `players` WHERE `coplevel` >= '1' ORDER BY `coplevel` DESC LIMIT 10";

            $result_of_query = $db_link->query($sql);

            while ($row = mysqli_fetch_assoc($result_of_query)) {

                $playersID = $row['playerid'];

                echo '<tr>';

                echo '<td>'.$row['name'].'</td>';

                echo '<td>'.$playersID.'</td>';

                echo '<td>'.$row['coplevel'].'</td>';

                echo '</tr>';

            } ?>

                    </tbody>

                    </table>

                </div>

                        <?php

                        $sql = 'SELECT `name`, `cash`, `bankacc` FROM `players` ORDER BY `bankacc` DESC, `cash` DESC LIMIT 10';

            $result_of_query = $db_link->query($sql);

            while ($row = mysqli_fetch_assoc($result_of_query)) {

                echo '<tr>';

                echo '<td>'.$row['name'].'</td>';

                echo '<td>'.$row['cash'].'</td>';

                echo '<td>'.$row['bankacc'].'</td>';

                echo '</tr>';

            } ?>

                        </tbody>

                    </table>

                </div>

                    <?php

                    $sql = "SELECT `name`,`adminlevel`, $playerIdColumn as playerid FROM `players` WHERE `adminlevel` >= '1' ORDER BY `adminlevel` DESC LIMIT 10";

            $result_of_query = $db_link->query($sql);

            while ($row = mysqli_fetch_assoc($result_of_query)) {

                $playersID = $row['playerid'];

                echo '<tr>';

                echo '<td>'.$row['name'].'</td>';

                echo '<td>'.$playersID.'</td>';

                echo '<td>'.$row['adminlevel'].'</td>';

                echo '</tr>';

            } ?>

                    </tbody>

                    </table>

                </div>

                                        <?php

                                        $sql = "SELECT `name`,`coplevel`, $playerIdColumn as playerid FROM `players` WHERE `coplevel` >= '1' ORDER BY `coplevel` DESC LIMIT 10";

            $result_of_query = $db_link->query($sql);

            while ($row = mysqli_fetch_assoc($result_of_query)) {

                $playersID = $row['playerid'];

                echo '<tr>';

                echo '<td>'.$row['name'].'</td>';

                echo '<td>'.$playersID.'</td>';

                echo '<td>'.$row['coplevel'].'</td>';

                echo '</tr>';

            } ?>

                                        </tbody>

                                    </table>

                                </div>

                                        <?php

                                        $sql = "SELECT `name`,`mediclevel`, $playerIdColumn as playerid FROM `players` WHERE `mediclevel` >= '1' ORDER BY `mediclevel` DESC LIMIT 10";

            $result_of_query = $db_link->query($sql);

            while ($row = mysqli_fetch_assoc($result_of_query)) {

                $playersID = $row['playerid'];

                echo '<tr>';

                echo '<td>'.$row['name'].'</td>';

                echo '<td>'.$playersID.'</td>';

                echo '<td>'.$row['mediclevel'].'</td>';

                echo '</tr>';

            } ?>

                                        </tbody>

                                    </table>

                                </div>

                                        <?php

                                        $sql = "SELECT `name`,`adminlevel`, $playerIdColumn as playerid FROM `players` WHERE `adminlevel` >= '1' ORDER BY `adminlevel` DESC LIMIT 10";

            $result_of_query = $db_link->query($sql);

            while ($row = mysqli_fetch_assoc($result_of_query)) {

                $playersID = $row['playerid'];

                echo '<tr>';

                echo '<td>'.$row['name'].'</td>';

                echo '<td>'.$playersID.'</td>';

                echo '<td>'.$row['adminlevel'].'</td>';

                echo '</tr>';

            } ?>

                                        </tbody>

                                    </table>

                                </div>

                                        </thead>

                                        <tbody>

                                        <?php

                                        while ($row = mysqli_fetch_assoc($result_of_query)) {

                                            echo '<tr>';

                                            echo '<td>'.substr($row['pos'], 1, -1).'</td>';

                                            echo "<td><a class='btn btn-primary btn-xs' href='".$settings['url'].'editHouse/'.$row['id']."'>";

                                            echo "<i class='fa fa-pencil'></i></a></td>";

                                            echo '</tr>';

                                        } ?>

                                        </tbody>

                                    </table>

                                    <?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>';