boa tarde, como faço pra colocar o número de resets q cada player tem nesse meu widget top rank ?? as query do meu reset são, tirei elas de um rank q eu tenho, só q ele é em pagina e não, no widget top rank $resets = $SQL->query("SELECT `name`,`reset` FROM `players` WHERE `reset` != 0 ORDER BY `reset` DESC LIMIT $top;"); $count = $resets->rowCount(); <?php $skills = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id = 1 AND account_id != 1 ORDER BY level DESC LIMIT 10'); ?> <style type="text/css" media="all"> .Toplevelbox { top: -4px; position: relative; margin-bottom: 10px; width: 180px; height: 346px; } .top_level_x { position: absolute; top: 29px; left: 6px; height: 290px; width: 168px; z-index: 20; text-align: center; padding-top: 6px; font-family: Tahoma, Geneva, sans-serif; font-size: 9.2pt; color: black; font-weight: bold; text-align: right; text-decoration: inherit; text-shadow: 0.1em 0.1em #333 } .top_level { position: absolute; top: 29px; left: 6px; height: 300px; width: 168px; z-index: 20; text-align: center; padding-top: 6px; font-family: Tahoma, Geneva, sans-serif; font-size: 9.2pt; color: black; font-weight: bold; text-align: right; text-decoration: inherit; text-shadow: 0.1em 0.1em #333 } #Topbar a { text-decoration: none; cursor: auto; } a.topfont { font-family: Verdana, Arial, Helvetica; font-size: 11px; color: #ffcc33; text-decoration: none text-shadow: #FA0606 1px 1px 10px; } a:hover.topfont { font-family: Verdana, Arial, Helvetica; font-size: 11px; color: #CCC; text-decoration:none } </style> <div id="Topbar" class="Themebox" style="background-image:url(<?PHP echo $layout_name; ?>/images/top_level.png);"> <div class="top_level" style="background:url(<?PHP echo $layout_name; ?>/images/bg_top.png)" align=" "> <?php $a = 1; foreach($skills as $skill) { echo '<div align="left"> <a href="?subtopic=characters&name='.$skill['name'].'" class="topfont"> <font color="#CCC"> '.$a.' - </font>'.$skill['name'].' <br> <small><font color="white"> Level: ('.$skill['level'].')</font></small> <br> </a> <img src="/images/outfit.php?id='.$skill['looktype'].'&addons='.$skill['lookaddons'].'&head='.$skill['lookhead'].'&body='.$skill['lookbody'].'&legs='.$skill['looklegs'].'&feet='.$skill['lookfeet'].'" width="64" height="64" style="width: 64px; height: 64px; position: absolute; background-position: 0 0; background-repeat: no-repeat; left: -50px; margin-top: -70px;"> </div>'; $a++; } ?>

@BilauX <?php $skills = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id = 1 AND account_id != 1 ORDER BY reset DESC LIMIT 10'); ?> <style type="text/css" media="all"> .Toplevelbox { top: -4px; position: relative; margin-bottom: 10px; width: 180px; height: 346px; } .top_level_x { position: absolute; top: 29px; left: 6px; height: 290px; width: 168px; z-index: 20; text-align: center; padding-top: 6px; font-family: Tahoma, Geneva, sans-serif; font-size: 9.2pt; color: black; font-weight: bold; text-align: right; text-decoration: inherit; text-shadow: 0.1em 0.1em #333 } .top_level { position: absolute; top: 29px; left: 6px; height: 300px; width: 168px; z-index: 20; text-align: center; padding-top: 6px; font-family: Tahoma, Geneva, sans-serif; font-size: 9.2pt; color: black; font-weight: bold; text-align: right; text-decoration: inherit; text-shadow: 0.1em 0.1em #333 } #Topbar a { text-decoration: none; cursor: auto; } a.topfont { font-family: Verdana, Arial, Helvetica; font-size: 11px; color: #ffcc33; text-decoration: none text-shadow: #FA0606 1px 1px 10px; } a:hover.topfont { font-family: Verdana, Arial, Helvetica; font-size: 11px; color: #CCC; text-decoration:none } </style> <div id="Topbar" class="Themebox" style="background-image:url(<?PHP echo $layout_name; ?>/images/top_level.png);"> <div class="top_level" style="background:url(<?PHP echo $layout_name; ?>/images/bg_top.png)" align=" "> <?php $a = 1; foreach($skills as $skill) { echo '<div align="left"> <a href="?subtopic=characters&name='.$skill['name'].'" class="topfont"> <font color="#CCC"> '.$a.' - </font>'.$skill['name'].' <br> <small><font color="white"> Level: ('.$skill['level'].'), Reset: ['.$skill['reset'].']</font></small> <br> </a> <img src="/images/outfit.php?id='.$skill['looktype'].'&addons='.$skill['lookaddons'].'&head='.$skill['lookhead'].'&body='.$skill['lookbody'].'&legs='.$skill['looklegs'].'&feet='.$skill['lookfeet'].'" width="64" height="64" style="width: 64px; height: 64px; position: absolute; background-position: 0 0; background-repeat: no-repeat; left: -50px; margin-top: -70px;"> </div>'; $a++; } ?>