Ir para conteúdo

Top Guilds não funciona GESIOR

Por Yamborghini
em Suporte Tibia OTServer

Featured Replies

  • Respostas 14
  • Visualizações 1.2k
  • Created
  • Última resposta

Top Posters In This Topic

Popular Days

Most Popular Posts

  • Pedro.
    Pedro.

    em outras palavras bgl mo hard, to tentando aqui, vou pedir ajuda pra vê se consigo implementar outro sistema de top guilds. Tendo sucesso vou arrumar esse layout e postar aqui e te marco.

Posted Images

Postado
  • Autor
2 minutos atrás, Jobs disse:

Sempre vai dá erro, C:\xampp\htdocs\layouts\tibiarl\layout.phpon line 344

só você abrir o layout.php da um ctrl + f e escrever thora, o nome do layout tá errado '-' 

eu ja mudei e nao funcionou.

tumblr_o70wteR8521r9n6kzo1_400.gif

  • Citar
  • Mention
    • Postado

     

     

    Cara aqui ta funcionando normalmente, eu só troquei essa parte 

      

    <div class="well">
                                                <h2><font color="black">Top 5 Guilds</font></h2>
                                             
                                                <table class="table table-condensed table-content table-striped">
                                                        <tbody>
                                                                                                                                <tr><td>1.</td><td><a href="?subtopic=guilds&action=show&guild=26"><img src="guild_image.php?id=26" width="16" height="16" border="0"/> Loneliness</a>&nbsp;<td><span class="label label-danger pull-right">126 kills</td></span></td></tr>
<tr><td>2.</td><td><a href="?subtopic=guilds&action=show&guild=30"><img src="guild_image.php?id=30" width="16" height="16" border="0"/> Out Laws</a>&nbsp;<td><span class="label label-danger pull-right">65 kills</td></span></td></tr>
<tr><td>3.</td><td><a href="?subtopic=guilds&action=show&guild=39"><img src="guild_image.php?id=39" width="16" height="16" border="0"/> Amfethamine</a>&nbsp;<td><span class="label label-danger pull-right">57 kills</td></span></td></tr>
<tr><td>4.</td><td><a href="?subtopic=guilds&action=show&guild=25"><img src="guild_image.php?id=25" width="16" height="16" border="0"/> Daylight</a>&nbsp;<td><span class="label label-danger pull-right">51 kills</td></span></td></tr>
<tr><td>5.</td><td><a href="?subtopic=guilds&action=show&guild=15"><img src="guild_image.php?id=15" width="16" height="16" border="0"/> Semicolon Parenthesis</a>&nbsp;<td><span class="label label-danger pull-right">45 kills</td></span></td></tr>
</tbody>
                                                </table>
                                        </div>
</div>

     

    por essa aqui

      

    <div class="well">
    <h2><font color="black">Top 5 Guilds</font></h2>
    <table class="table table-condensed table-content table-striped">
        <tbody>
<?php
    $guildsPower = $SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0, 4')->fetchAll();
    $i = 0;
    foreach($guildsPower as $guild) {
        echo '
           <tr><td>' . ++$i . '.</td><td><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img src="guild_image.php?id=' . $guild['id'] . '" width="16" height="16" border="0"/> ' . $guild['name'] . '</a> <td><span class="label label-danger pull-right">' . $guild['frags'] . ' kills</td></span></td></tr>';
    }
?>
        </tbody>
    </table>
</div>
 </div>

     

  • Citar
  • Mention
    • Postado
    • Autor
    2 minutos atrás, Jobs disse:

     

     

    Cara aqui ta funcionando normalmente, eu só troquei essa parte 

      

    
<div class="well">
                                                <h2><font color="black">Top 5 Guilds</font></h2>
                                             
                                                <table class="table table-condensed table-content table-striped">
                                                        <tbody>
                                                                                                                                <tr><td>1.</td><td><a href="?subtopic=guilds&action=show&guild=26"><img src="guild_image.php?id=26" width="16" height="16" border="0"/> Loneliness</a>&nbsp;<td><span class="label label-danger pull-right">126 kills</td></span></td></tr>
<tr><td>2.</td><td><a href="?subtopic=guilds&action=show&guild=30"><img src="guild_image.php?id=30" width="16" height="16" border="0"/> Out Laws</a>&nbsp;<td><span class="label label-danger pull-right">65 kills</td></span></td></tr>
<tr><td>3.</td><td><a href="?subtopic=guilds&action=show&guild=39"><img src="guild_image.php?id=39" width="16" height="16" border="0"/> Amfethamine</a>&nbsp;<td><span class="label label-danger pull-right">57 kills</td></span></td></tr>
<tr><td>4.</td><td><a href="?subtopic=guilds&action=show&guild=25"><img src="guild_image.php?id=25" width="16" height="16" border="0"/> Daylight</a>&nbsp;<td><span class="label label-danger pull-right">51 kills</td></span></td></tr>
<tr><td>5.</td><td><a href="?subtopic=guilds&action=show&guild=15"><img src="guild_image.php?id=15" width="16" height="16" border="0"/> Semicolon Parenthesis</a>&nbsp;<td><span class="label label-danger pull-right">45 kills</td></span></td></tr>
</tbody>
                                                </table>
                                        </div>
</div>

     

    por essa aqui

      

    
<div class="well">
    <h2><font color="black">Top 5 Guilds</font></h2>
    <table class="table table-condensed table-content table-striped">
        <tbody>
<?php
    $guildsPower = $SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0, 4')->fetchAll();
    $i = 0;
    foreach($guildsPower as $guild) {
        echo '
           <tr><td>' . ++$i . '.</td><td><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img src="guild_image.php?id=' . $guild['id'] . '" width="16" height="16" border="0"/> ' . $guild['name'] . '</a> <td><span class="label label-danger pull-right">' . $guild['frags'] . ' kills</td></span></td></tr>';
    }
?>
        </tbody>
    </table>
</div>
 </div>

     

    pode me passar a database que está usando?

    tumblr_o70wteR8521r9n6kzo1_400.gif

  • Citar
  • Mention

    • Participe da conversa

    Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

    Visitante
    Responder
    Ir para a lista de tópicos

    Quem Está Navegando 0

    • Nenhum usuário registrado visualizando esta página.

    Conteúdo Similar

    Estatísticas dos Fóruns

    • Tópicos 96.9k
    • Posts 520.2k

    Informação Importante

    Confirmação de Termo

    I accept