Website [Ajuda] Nesse codigo php para mostra ranking

[L3K0T 1017]

2 minutos atrás, leozincorsair disse:

não entendi muito bem

<?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/>";

?>

[leozincorsair 42]

1 minuto atrás, 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/>";

?>

tirou os erros, mais na mostrou as quantidade de pontos dos players

[L3K0T 1017]

Vc fez o sistema para `graduacao_points dentro do jogo?  Para dar pontos de graduação?

[leozincorsair 42]

2 minutos atrás, L3K0T disse:

Vc fez o sistema para `graduacao_points dentro do jogo?  Para dar pontos de graduação?

sim, tem por comando ou editar a tabela na db

[L3K0T 1017]

1 minuto atrás, leozincorsair disse:

sim, tem por comando ou editar a tabela na db

 

$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`,
            COUNT(`p`.`name`) AS `player_count`
        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>
                <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">Players: ' . $guild['player_count'] . '</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/>";
 

[leozincorsair 42]

Agora, 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`,
            COUNT(`p`.`name`) AS `player_count`
        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>
                <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">Players: ' . $guild['player_count'] . '</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/>";
 

mesmo bug de antes que mandei, pode deixar L3K0T por me ajudar mano.. acho que vou deixar esse sistema por um tempo

[L3K0T 1017]

25 minutos atrás, leozincorsair disse:

mesmo bug de antes que mandei, pode deixar L3K0T por me ajudar mano.. acho que vou deixar esse sistema por um tempo

 

 

<?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`,
        COUNT(`p`.`name`) AS `player_count`,
        `p`.`graduacao_points` AS `graduacao_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 `g`.`id`, `g`.`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>
        <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">Players: ' . $guild['player_count'] . '</p>
        <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">Graduação Points: ' . $guild['graduacao_points'] . '</p>
        <a href="' . WEBSITE . '/index.php/guilds/view/' . $guild['id'] . '"><img src="' . WEBSITE . '/public/images/gp/' . ($i + 1) . '.png" width="60" height="60" border="0"/><br />
        <b>' . $guild['name'] . '</b></a><br />
    </td>';
    $i++;
}

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

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

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

 

Ou esse

 

<?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`,
        COUNT(`p`.`name`) AS `player_count`
    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 `g`.`id`, `g`.`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>
        <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">Players: ' . $guild['player_count'] . '</p>';

    // Obter a quantidade de pontos de graduação dos jogadores
    $graduacaoPoints = $SQL->query('
        SELECT SUM(`graduacao_points`) AS `total_points`
        FROM `players`
        WHERE `rank_id` IN (
            SELECT `id`
            FROM `guild_ranks`
            WHERE `guild_id` = ' . $guild['id'] . '
        )
    ')->fetch(PDO::FETCH_ASSOC)['total_points'];

    echo '<p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">Graduação Points: ' . $graduacaoPoints . '</p>';

    echo '<a href="' . WEBSITE . '/index.php/guilds/view/' . $guild['id'] . '"><img src="' . WEBSITE . '/public/images/gp/' . ($i + 1) . '.png" width="60" height="60" border="0"/><br />
        <b>' . $guild['name'] . '</b></a><br />
    </td>';
    $i++;
}

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

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

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

Editado Junho 20, 2023 por L3K0T
Tem 2 codigo php (veja o histórico de edições)

[leozincorsair 42]

2 horas atrás, L3K0T disse:

Testa ai

ambos nenhum deram certo, nao aparece o ranking

[L3K0T 1017]

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

echo '<div class="message"><div class="title">Pontuação das Principais Guildas</div> <div class="content">';

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

$i = 0;

$query = '
    SELECT
        `g`.`id` AS `id`,
        `g`.`name` AS `name`,
        SUM(`p`.`graduacao_points`) AS `points`,
        COUNT(`p`.`name`) AS `player_count`
    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 `g`.`id`, `g`.`name`
    ORDER BY `points` DESC
    LIMIT 3';

foreach ($SQL->query($query) as $guild) {
    echo '<td style="padding-right:20px;padding-top:3px" align="center">
        Pontuação Principal:
        <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">' . $guild['points'] . '</p>
        <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">Jogadores: ' . $guild['player_count'] . '</p>';

    // Obter a quantidade total de pontos de graduação dos jogadores
    $subQuery = '
        SELECT SUM(`graduacao_points`) AS `total_points`
        FROM `players`
        WHERE `rank_id` IN (
            SELECT `id`
            FROM `guild_ranks`
            WHERE `guild_id` = ' . $guild['id'] . '
        )';

    $graduacaoPoints = $SQL->query($subQuery)->fetch(PDO::FETCH_ASSOC)['total_points'];

    echo '<p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">Pontos de Graduação: ' . $graduacaoPoints . '</p>';

    echo '<a href="' . WEBSITE . '/index.php/guilds/view/' . $guild['id'] . '"><img src="' . WEBSITE . '/public/images/gp/' . ($i + 1) . '.png" width="60" height="60" border="0"/><br />
        <b>' . $guild['name'] . '</b></a><br />
    </td>';
    $i++;
}

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

if (empty($i)) {
    echo "<center><font color='red'>Ainda não há guildas.</font></center>";
}

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

[leozincorsair 42]

3 horas atrás, L3K0T disse:

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

echo '<div class="message"><div class="title">Pontuação das Principais Guildas</div> <div class="content">';

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

$i = 0;

$query = '
    SELECT
        `g`.`id` AS `id`,
        `g`.`name` AS `name`,
        SUM(`p`.`graduacao_points`) AS `points`,
        COUNT(`p`.`name`) AS `player_count`
    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 `g`.`id`, `g`.`name`
    ORDER BY `points` DESC
    LIMIT 3';

foreach ($SQL->query($query) as $guild) {
    echo '<td style="padding-right:20px;padding-top:3px" align="center">
        Pontuação Principal:
        <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">' . $guild['points'] . '</p>
        <p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">Jogadores: ' . $guild['player_count'] . '</p>';

    // Obter a quantidade total de pontos de graduação dos jogadores
    $subQuery = '
        SELECT SUM(`graduacao_points`) AS `total_points`
        FROM `players`
        WHERE `rank_id` IN (
            SELECT `id`
            FROM `guild_ranks`
            WHERE `guild_id` = ' . $guild['id'] . '
        )';

    $graduacaoPoints = $SQL->query($subQuery)->fetch(PDO::FETCH_ASSOC)['total_points'];

    echo '<p style="color:#336600;display:inline;padding: 0 0 3px 0;font-weight: bold;">Pontos de Graduação: ' . $graduacaoPoints . '</p>';

    echo '<a href="' . WEBSITE . '/index.php/guilds/view/' . $guild['id'] . '"><img src="' . WEBSITE . '/public/images/gp/' . ($i + 1) . '.png" width="60" height="60" border="0"/><br />
        <b>' . $guild['name'] . '</b></a><br />
    </td>';
    $i++;
}

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

if (empty($i)) {
    echo "<center><font color='red'>Ainda não há guildas.</font></center>";
}

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

Pontuação das Principais Guildas

Ainda não há guildas.

[L3K0T 1017]

41 minutos atrás, leozincorsair disse:

Pontuação das Principais Guildas

Ainda não há guildas.

agora testa os pontos pelo MySQL se for nulo n vai aparecercnada