Website [Ajuda] Nesse codigo php para mostra ranking

[leozincorsair 42]

 

Galera tem como me ajudar a montar um ranking na home do site, para mostrar os top 5 Kages que mais tem pontos.

 Obs: semelhante ao do print abaixo.

 

Tenho como referencia esse código php, onde mostra quantos "pontos " tem a guild..

 obs: na tabela 'players' tem outra tebela 'graduacao_points', marcando a quantidade depontos dos jogadores.

 

$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">

                   

<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`.`level`) AS `level`,

            COUNT(`p`.`name`) AS `count`,

            AVG(`p`.`level`) AS `average`,

            MIN(`p`.`level`) AS `min`,

            MAX(`p`.`level`) AS `max`

        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 `level` DESC

        LIMIT 3

    ') as $guild)

    {

        $Points = $guild['level'] + $guild['count'] + round($guild['average']) + $guild['min'] + $guild['max'];

        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;">'.$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 is no guilds yet.</font></center>";

    }

echo "</div>";

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

?>

 

 

Print anexado:

 

[Mateus Robeerto 99]

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

echo '<div class="message"><div class="title">Top 5 Kages - Pontuação</div><div class="content">
    <table border="0" cellspacing="3" cellpadding="4" width="100%">
        <tr>';

// Consulta SQL para obter os top 5 Kages com base nos pontos
$query = '
    SELECT
        `p`.`name` AS `name`,
        `p`.`points` AS `points`
    FROM `players` p
    ORDER BY `points` DESC
    LIMIT 5
';

$result = $SQL->query($query);
$i = 1;

while ($row = $result->fetch()) {
    $kageName = $row['name'];
    $kagePoints = $row['points'];

    echo '
        <td style="padding-right: 20px; padding-top: 3px;" align="center">
            <p style="color: #336600; display: inline; padding: 0 0 3px 0; font-weight: bold;">' . $kagePoints . '</p>
            <br /><b>' . $i . '. ' . $kageName . '</b>
        </td>';

    $i++;
}

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

if ($i === 1) {
    echo "<center><font color='red'>Não há Kages registrados.</font></center>";
}

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

tente ai se ve erro me fala aqui

Editado Junho 10, 2023 por sverkoa
editei e atualizei (veja o histórico de edições)

[leozincorsair 42]

3 horas atrás, sverkoa 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">

<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`.`level`) AS `level`,
            COUNT(`p`.`name`) AS `count`,
            AVG(`p`.`level`) AS `average`,
            MIN(`p`.`level`) AS `min`,
            MAX(`p`.`level`) AS `max`
        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 `level` DESC
        LIMIT 3
    ') as $guild) {
    $Points = $guild['level'] + $guild['count'] + round($guild['average']) + $guild['min'] + $guild['max'];

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

tente ai se ve erro me fala aqui

amigo, nao notei diferença.. ainda ta mostrando os "pontos" das guilds..

 era pra monstrar a  'graduacao_points' dos players

print de como esta:

https://imgur.com/a/RW4ZQAr

[leozincorsair 42]

https://imgur.com/a/RW4ZQAr

[leozincorsair 42]

n deu certo

3 horas atrás, sverkoa 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">

<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`.`level`) AS `level`,
            COUNT(`p`.`name`) AS `count`,
            AVG(`p`.`level`) AS `average`,
            MIN(`p`.`level`) AS `min`,
            MAX(`p`.`level`) AS `max`
        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 `level` DESC
        LIMIT 3
    ') as $guild) {
    $Points = $guild['level'] + $guild['count'] + round($guild['average']) + $guild['min'] + $guild['max'];

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

tente ai se ve erro me fala aqui

n deu certo, continua mostrando as guilds 

[Mateus Robeerto 99]

Editei a postagem lá. Por favor, teste e me diga se deu certo

[leozincorsair 42]

8 minutos atrás, sverkoa disse:

Editei a postagem lá. Por favor, teste e me diga se deu certo

error:

 

Error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.points' in 'field list'

 

a tabela dos pontos hokage é :

players:

graduacao_points

 

e deu uma quebrada no site o codigo.. " nao consigo mandar prints "

 

[Mateus Robeerto 99]

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

echo '<div class="message"><div class="title">Top 5 Kages - Pontuação</div><div class="content">
    <table border="0" cellspacing="3" cellpadding="4" width="100%">
        <tr>';

// Consulta SQL para obter os top 5 Kages com base nos pontos
$query = '
    SELECT
        `p`.`name` AS `name`,
        `g`.`points` AS `points`
    FROM `players` p
    LEFT JOIN `graduacao_points` g ON `p`.`id` = `g`.`player_id`
    ORDER BY `points` DESC
    LIMIT 5
';

$result = $SQL->query($query);
$i = 1;

while ($row = $result->fetch()) {
    $kageName = $row['name'];
    $kagePoints = $row['points'];

    echo '
        <td style="padding-right: 20px; padding-top: 3px;" align="center">
            <p style="color: #336600; display: inline; padding: 0 0 3px 0; font-weight: bold;">' . $kagePoints . '</p>
            <br /><b>' . $i . '. ' . $kageName . '</b>
        </td>';

    $i++;
}

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

if ($i === 1) {
    echo "<center><font color='red'>Não há Kages registrados.</font></center>";
}

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

alterei aqui agora, se ve ai e diga aqui

[leozincorsair 42]

9 minutos atrás, sverkoa disse:

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

echo '<div class="message"><div class="title">Top 5 Kages - Pontuação</div><div class="content">
    <table border="0" cellspacing="3" cellpadding="4" width="100%">
        <tr>';

// Consulta SQL para obter os top 5 Kages com base nos pontos
$query = '
    SELECT
        `p`.`name` AS `name`,
        `g`.`points` AS `points`
    FROM `players` p
    LEFT JOIN `graduacao_points` g ON `p`.`id` = `g`.`player_id`
    ORDER BY `points` DESC
    LIMIT 5
';

$result = $SQL->query($query);
$i = 1;

while ($row = $result->fetch()) {
    $kageName = $row['name'];
    $kagePoints = $row['points'];

    echo '
        <td style="padding-right: 20px; padding-top: 3px;" align="center">
            <p style="color: #336600; display: inline; padding: 0 0 3px 0; font-weight: bold;">' . $kagePoints . '</p>
            <br /><b>' . $i . '. ' . $kageName . '</b>
        </td>';

    $i++;
}

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

if ($i === 1) {
    echo "<center><font color='red'>Não há Kages registrados.</font></center>";
}

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

alterei aqui agora, se ve ai e diga aqui

 

Error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'history3.graduacao_points' doesn't exist

 

* acho que teria que colocar players ali antes de graduacao ne nao ? 

[Mateus Robeerto 99]

Acho que precisa adicionar na sua database de dados (banco de dados).

 

CREATE TABLE graduacao_points (
    player_id INT NOT NULL,
    points INT,
    PRIMARY KEY (player_id),
    FOREIGN KEY (player_id) REFERENCES players(id)
);

 

Editado Junho 10, 2023 por sverkoa (veja o histórico de edições)

[leozincorsair 42]

2 minutos atrás, sverkoa disse:

Acho que precisa adicionar na sua database de dados (banco de dados).

 

CREATE TABLE graduacao_points (
    player_id INT NOT NULL,
    points INT,
    PRIMARY KEY (player_id),
    FOREIGN KEY (player_id) REFERENCES players(id)
);

 

oque isso faz?

 

[leozincorsair 42]

14 horas atrás, sverkoa disse:

Acho que precisa adicionar na sua database de dados (banco de dados).

 

CREATE TABLE graduacao_points (
    player_id INT NOT NULL,
    points INT,
    PRIMARY KEY (player_id),
    FOREIGN KEY (player_id) REFERENCES players(id)
);

 

deu +- certo, desbugou o site, só que mostra os samples do site, e nao mostra os pontos e a fotinha do ranking

1 minuto atrás, leozincorsair disse:

deu +- certo, desbugou o site, só que mostra os samples do site, e nao mostra os pontos e a fotinha do ranking

e os pontos ingame no look do player, nao mostram, ficam sempre em 0

[Mateus Robeerto 99]

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

echo '<div class="message"><div class="title">Top 5 Kages - Pontuação</div><div class="content">
    <table border="0" cellspacing="3" cellpadding="4" width="100%">
        <tr>';


$query = '
    SELECT
        `p`.`name` AS `name`,
        `g`.`points` AS `points`,
        `p`.`profile_picture` AS `profile_picture`
    FROM `players` p
    LEFT JOIN `graduacao_points` g ON `p`.`id` = `g`.`player_id`
    ORDER BY `points` DESC
    LIMIT 5
';

$result = $SQL->query($query);
$i = 1;

while ($row = $result->fetch()) {
    $kageName = $row['name'];
    $kagePoints = $row['points'];
    $kageProfilePicture = $row['profile_picture'];

    echo '
        <td style="padding-right: 20px; padding-top: 3px;" align="center">
            <img src="' . $kageProfilePicture . '" alt="' . $kageName . '">
            <p style="color: #336600; display: inline; padding: 0 0 3px 0; font-weight: bold;">' . $kagePoints . '</p>
            <br /><b>' . $i . '. ' . $kageName . '</b>
        </td>';

    $i++;
}

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

if ($i === 1) {
    echo "<center><font color='red'>Não há Kages registrados.</font></center>";
}

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

espero que funcione!

[leozincorsair 42]

2 horas atrás, sverkoa disse:

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

echo '<div class="message"><div class="title">Top 5 Kages - Pontuação</div><div class="content">
    <table border="0" cellspacing="3" cellpadding="4" width="100%">
        <tr>';


$query = '
    SELECT
        `p`.`name` AS `name`,
        `g`.`points` AS `points`,
        `p`.`profile_picture` AS `profile_picture`
    FROM `players` p
    LEFT JOIN `graduacao_points` g ON `p`.`id` = `g`.`player_id`
    ORDER BY `points` DESC
    LIMIT 5
';

$result = $SQL->query($query);
$i = 1;

while ($row = $result->fetch()) {
    $kageName = $row['name'];
    $kagePoints = $row['points'];
    $kageProfilePicture = $row['profile_picture'];

    echo '
        <td style="padding-right: 20px; padding-top: 3px;" align="center">
            <img src="' . $kageProfilePicture . '" alt="' . $kageName . '">
            <p style="color: #336600; display: inline; padding: 0 0 3px 0; font-weight: bold;">' . $kagePoints . '</p>
            <br /><b>' . $i . '. ' . $kageName . '</b>
        </td>';

    $i++;
}

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

if ($i === 1) {
    echo "<center><font color='red'>Não há Kages registrados.</font></center>";
}

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

espero que funcione!

Error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.profile_picture' in 'field list'

[L3K0T 1017]

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

[leozincorsair 42]

3 minutos atrás, 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 "

";

 

[L3K0T 1017]

5 minutos atrás, 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.

[leozincorsair 42]

5 minutos 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/>";

?>
 

 

 

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'

[L3K0T 1017]

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

[leozincorsair 42]

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