File manager - Edit - /home/newsbmcs.com/public_html/play1/content/themes/arcade-two/page-top-players.php
Back
<?php $page_title = 'Top Players'; $meta_description = 'Top Players'; include TEMPLATE_PATH . "/includes/header.php"; $sql = "SELECT id FROM users ORDER by xp+0 DESC LIMIT 10"; $conn = open_connection(); $st = $conn->prepare($sql); $st->execute(); $row = $st->fetchAll(PDO::FETCH_ASSOC); if(count($row) >= 3) { ?> <div class="container"> <?php widget_aside('header') ?> <div class="row"> <div class="col-md-9"> <div class="top-player-wrapper"> <h2 class="text-center single-title"> <?php _e('Top Players') ?> </h2> <div class="top-3"> <?php $user = User::getById($row[1]['id']); ?> <div class="top-user rank-2"> <a href="<?php echo get_permalink('user', $user->username) ?>"> <div class="top-avatar"> <img src="<?php echo get_user_avatar($user->username) ?>"> </div> </a> <div class="top-number"> <img src="<?php echo get_template_path() . '/images/medal-2.svg' ?>"> </div> <div class="top-username"> <?php echo $user->username ?> </div> <div class="top-xp"> <?php echo $user->xp ?> xp </div> <div class="sub-text top-rank"> <?php echo $user->rank ?> </div> </div> <?php $user = User::getById($row[0]['id']); ?> <div class="top-user rank-1"> <a href="<?php echo get_permalink('user', $user->username) ?>"> <div class="top-avatar"> <img src="<?php echo get_user_avatar($user->username) ?>"> </div> </a> <div class="top-number"> <img src="<?php echo get_template_path() . '/images/medal-1.svg' ?>"> </div> <div class="top-username"> <?php echo $user->username ?> </div> <div class="top-xp"> <?php echo $user->xp ?> xp </div> <div class="sub-text top-rank"> <?php echo $user->rank ?> </div> </div> <?php $user = User::getById($row[2]['id']); ?> <div class="top-user rank-3"> <a href="<?php echo get_permalink('user', $user->username) ?>"> <div class="top-avatar"> <img src="<?php echo get_user_avatar($user->username) ?>"> </div> </a> <div class="top-number"> <img src="<?php echo get_template_path() . '/images/medal-3.svg' ?>"> </div> <div class="top-username"> <?php echo $user->username ?> </div> <div class="top-xp"> <?php echo $user->xp ?> xp </div> <div class="sub-text top-rank"> <?php echo $user->rank ?> </div> </div> </div> <div> <div class="leaderboard-table"> <?php $index = 0; foreach($row as $item){ $user = User::getById($item['id']); $index++; if($index > 3){ ?> <div class="leaderboard-row"> <div class="leaderboard-cell" style="font-weight: bold;"><?php echo $index ?></div> <div class="leaderboard-cell leaderboard-user-avatar"> <a href="<?php echo get_permalink('user', $user->username) ?>"> <img src="<?php echo get_user_avatar($user->username) ?>"> </a> </div> <div class="leaderboard-cell username"><?php echo $user->username ?></div> <div class="leaderboard-cell user-xp"><?php echo $user->xp ?> xp</div> <div class="leaderboard-cell rank"> <div class="leaderboard-cell"><?php echo $user->rank ?></div> <div class="leaderboard-cell"><img src="<?php echo DOMAIN.'images/ranks/level-'.$user->level.'.png' ?>" class="level-badge"></div> </div> </div> <?php } } ?> </div> </div> </div> </div> <div class="col-md-3"> <?php include TEMPLATE_PATH . "/parts/sidebar.php" ?> </div> </div> </div> <?php } else { ?> <h2><?php _e('You must have at least 3 registered users to show the list') ?></h2> <?php } ?> <?php include TEMPLATE_PATH . "/includes/footer.php" ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings