alguem pode me ajudar a mudar meu "top level" por "top reset"?

(ser organizado pra quem tem mais resets, em vez de level)

(Storage 2310)


index.php:

Spoiler

<?php
$skills = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id = 1 OR group_id = 2 AND account_id != 1 ORDER BY level DESC LIMIT 10');
$storage = 2310;

?>
<style type="text/css" media="all">
  .Toplevelbox {
    top: -4px;
    position: relative;
    margin-bottom: 10px;
    width: 180px;
    height: 200px;
  }
  .top_level {
    position: absolute;
    top: 29px;
    left: 6px;
    height: 430px;
    width: 168px;
    z-index: 20;
    text-align: center;
    padding-top: 6px;
    font-family: Tahoma, Geneva, sans-serif;
    font-size: 9.2pt;
    color: #FFF;
    font-weight: bold;
    text-align: right;
    text-decoration: inherit;

  }

  #Topbar a {
  text-decoration: none;
  cursor: auto;
  }
  a.topfont {
    font-family: Verdana, Arial, Helvetica; 
    font-size: 11px; 
        color: #00008B;
    text-decoration: none
  }
  a:hover.topfont {
    font-family: Verdana, Arial, Helvetica; 
    font-size: 11px; 
    color: #00FFFF; 
    text-decoration:none
  }
</style>

<div id="Topbar" class="Themebox" style="background-image:url(<?PHP echo $layout_name; ?>/images/themeboxes/top_level.png);">
  <div class="top_level" style="background:url(<?PHP echo $layout_name; ?>/images/themeboxes/bg_top.png)" align="    ">
    <?php 
    $a = 1;
    foreach($skills as $skill) {
        $player_id = $skill['id'];
        $reset = $SQL->query("SELECT * FROM player_storage WHERE player_id = ".$player_id." AND `key` = ".$storage." ")->fetch();
      echo '<div align="left"><a href="?subtopic=characters&name='.$skill['name'].'" class="topfont">
        <font color="#FF0000">&nbsp;&nbsp;&nbsp;&nbsp;'.$a.' - </font>'.$skill['name'].'
        <br>
        <small><font color="black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Level: ('.$skill['level'].') <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Resets: ['.$reset['value'].']</font></small>
        <br>
      </a>
      </div>';
      $a++;
    }
    ?>
    <div class="Bottom" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/box-top.gif); top: 430px;; left:-5px;">
    </div>
</div>    
</div>
<br>
<br><br>

 

Em 23/08/2019 em 17:46, poko360 disse:

$skills = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id = 1 OR group_id = 2 AND account_id != 1 ORDER BY level DESC LIMIT 10');
$storage = 2310;

Altere para:
 

$storage = 2310;
$skills = $SQL->query('SELECT * FROM players p inner join player_storage ps on p.id = ps.player_id WHERE p.deleted = 0 AND p.group_id = 1 OR p.group_id = 2 AND p.account_id != 1 and ps.key = '.$storage.' ORDER BY ps.value desc, p.level DESC LIMIT 10');

 

edit:
funcionou obgg!!!

 

Editado Agosto 28, 2019 5 anos por poko360 (veja o histórico de edições)

em qual dos index.php se coloca isso?

qual é o nome  do seu ot?