Em 20/06/2023 em 12:20, L3K0T disse:

$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = $ots->getDBHandle();

echo '<div class="message"><div class="title">Top Guild Points</div> <div class="content">';

echo '<table border="0" cellspacing="3" cellpadding="4" width="100%">
    <tr>';

$i = 0;

foreach($SQL->query('
        SELECT
            `g`.`id` AS `id`,
            `g`.`name` AS `name`,
            SUM(`p`.`graduacao_points`) AS `points`
        FROM `players` p
        LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
        LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
        WHERE `g`.`id` = `g`.`id`
        GROUP BY `name`
        ORDER BY `points` DESC
        LIMIT 3
    ') as $guild) {

        echo '
            <td style="padding-right:20px;padding-top:3px" align="center">
                Top Rating :
                <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">'.$guild['points'].'</p>
                <a href="'.WEBSITE.'/index.php/guilds/view/' . $guild['id'] . '"><img src="'.WEBSITE.'/public/images/gp/'. $i = $i + 1 .'.png" width="60" height="60" border="0"/>
                <br /><b>' . $guild['name'] . '</b></a><br />
            </td>';
    }

echo '</tr>
</table>';

if(empty($i)) {
    echo "<center><font color='red'>There are no guilds yet.</font></center>";
}

echo "</div>";
echo "</div><br/>";
 

 

 

$ots = POT::getInstance(); >$ots-connect(POT::DB_MYSQL, connection()); $SQL = >$ots-getDBHandle(); echo '

Top Guild Points

'; echo ''; $i = 0; >foreach($SQL-query(' SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, SUM(`p`.`graduacao_points`) AS `points` FROM `players` p LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id` WHERE `g`.`id` = `g`.`id` GROUP BY `name` ORDER BY `points` DESC LIMIT 3 ') as $guild) { echo ' '; } echo '

Top Rating :  '.$guild['points'].'   ' . $guild['name'] . '

'; if(empty($i)) { echo " There are no guilds yet. "; } echo "

"; echo "

";

 

  Em 20/06/2023 em 12:25, leozincorsair disse:

 

 

$ots = POT::getInstance(); >$ots-connect(POT::DB_MYSQL, connection()); $SQL = >$ots-getDBHandle(); echo '

Top Guild Points

'; echo ''; $i = 0; >foreach($SQL-query(' SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, SUM(`p`.`graduacao_points`) AS `points` FROM `players` p LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id` WHERE `g`.`id` = `g`.`id` GROUP BY `name` ORDER BY `points` DESC LIMIT 3 ') as $guild) { echo ' '; } echo '

Top Rating :  '.$guild['points'].'   ' . $guild['name'] . '

'; if(empty($i)) { echo " There are no guilds yet. "; } echo "

"; echo "

";

 

 

<?php

$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = $ots->getDBHandle();

echo '<div class="message"><div class="title">Top Guild Points</div> <div class="content">';

echo '<table border="0" cellspacing="3" cellpadding="4" width="100%">
    <tr>';

$i = 0;

foreach ($SQL->query('
        SELECT
            `g`.`id` AS `id`,
            `g`.`name` AS `name`,
            SUM(`p`.`graduacao_points`) AS `points`
        FROM `players` p
        LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
        LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
        WHERE `g`.`id` = `g`.`id`
        GROUP BY `name`
        ORDER BY `points` DESC
        LIMIT 3
    ') as $guild) {

    echo '
            <td style="padding-right:20px;padding-top:3px" align="center">
                Top Rating :
                <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">' . $guild['points'] . '</p>
                <a href="' . WEBSITE . '/index.php/guilds/view/' . $guild['id'] . '"><img src="' . WEBSITE . '/public/images/gp/' . $i = $i + 1 . '.png" width="60" height="60" border="0"/>
                <br /><b>' . $guild['name'] . '</b></a><br />
            </td>';
}

echo '</tr>
</table>';

if (empty($i)) {
    echo "<center><font color='red'>There are no guilds yet.</font></center>";
}

echo "</div>";
echo "</div><br/>";

?>
 

Importe pro MySQL

 

ALTER TABLE players
ADD graduacao_points INT;

 

Certifique-se de ter substituído POT::getInstance(), POT::DB_MYSQL e connection() pelos valores corretos para sua configuração de banco de dados.

  Em 20/06/2023 em 12:27, L3K0T disse:

<?php

$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = $ots->getDBHandle();

echo '<div class="message"><div class="title">Top Guild Points</div> <div class="content">';

echo '<table border="0" cellspacing="3" cellpadding="4" width="100%">
    <tr>';

$i = 0;

foreach($SQL->query('
        SELECT
            `g`.`id` AS `id`,
            `g`.`name` AS `name`,
            SUM(`p`.`graduacao_points`) AS `points`
        FROM `players` p
        LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
        LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
        WHERE `g`.`id` = `g`.`id`
        GROUP BY `name`
        ORDER BY `points` DESC
        LIMIT 3
    ') as $guild) {

        echo '
            <td style="padding-right:20px;padding-top:3px" align="center">
                Top Rating :
                <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">'.$guild['points'].'</p>
                <a href="'.WEBSITE.'/index.php/guilds/view/' . $guild['id'] . '"><img src="'.WEBSITE.'/public/images/gp/'. $i = $i + 1 .'.png" width="60" height="60" border="0"/>
                <br /><b>' . $guild['name'] . '</b></a><br />
            </td>';
    }

echo '</tr>
</table>';

if(empty($i)) {
    echo "<center><font color='red'>There are no guilds yet.</font></center>";
}

echo "</div>";
echo "</div><br/>";

?>
 

 

 

Importe pro MySQL

 

ALTER TABLE players
ADD graduacao_points INT;

Erro

Comando SQL:

 

ALTER TABLE players
ADD graduacao_points INT

 

Mensagens do MySQL : 

#1060 - Duplicate column name 'graduacao_points'

  Em 20/06/2023 em 12:33, leozincorsair disse:

Erro

Comando SQL:

 

ALTER TABLE players
ADD graduacao_points INT

 

Mensagens do MySQL : 

#1060 - Duplicate column name 'graduacao_points'

Testa o outro é porque ja tem a coluna então não precisa adicionar só pega o php acima

  Em 20/06/2023 em 12:35, L3K0T disse:

Testa o outro é porque ja tem a coluna então não precisa adicionar só pega o php acima

não entendi muito bem