Ir para conteúdo
  • Cadastre-se
  • 0

[WEBSITE]erro


helnata

Pergunta

<?php

include("module/stat-menu.php");

$result = mysql_query("SELECT clan_data.*,char_name,csum,ccount,cavg FROM clan_data INNER JOIN characters ON clan_data.leader_id=characters.chanid LEFT JOIN (SELECT clanid, SUM(level) AS csum, count(level) AS ccount, AVG(level) AS cavg FROM characters WHERE clanid GROUP BY clanid) AS levels ON clan_data.clanid=levels.clanid ORDER BY clan_level DESC, csum DESC", $link)

or die ("Error: ".mysql_error());

 

print '<table>

<caption><br><b>..:: Clans Top ::..</b><br><br><hr></caption>

<thead>

<tr style="vertical-align: bottom;">

<th>|Clan Name| </th>

<th> Leader|</th>

<th class="sortedColumn"> Level|</th>

<th> Castle|</th>

<th> Soma de lv|</th>

<th> Membros|</th>

<th>Media lv|</th>

</tr>

</thead>

<tfoot>

<tr><td colspan="10" style="text-align: right;">'.$L2JBS_lang["clantop_total"].': '.mysql_num_rows($result).'</td></tr>

</tfoot>

<tbody id="TblBdy">

';

 

$i=1;

while ($row=mysql_fetch_array($result))

{

switch ($row["hasCastle"])

{

case 1: $row["hasCastle"]=$L2JBS_lang["clantop_gludiocastle"]; break;

case 2: $row["hasCastle"]=$L2JBS_lang["clantop_dioncastle"]; break;

case 3: $row["hasCastle"]=$L2JBS_lang["clantop_girancastle"]; break;

case 4: $row["hasCastle"]=$L2JBS_lang["clantop_orencastle"]; break;

case 5: $row["hasCastle"]=$L2JBS_lang["clantop_adencastle"]; break;

case 6: $row["hasCastle"]=$L2JBS_lang["clantop_innadrilcastle"]; break;

default: $row["hasCastle"]=$L2JBS_lang["clantop_nocastle"];

}

print "<tr". (($i++ % 2) ? "" : " class=\"alternateRow\"") ."><td><a href=\"index.php?d=module&p=clanview&clan_name=". $row["clan_name"]."\">". htmlspecialchars($row["clan_name"]). "</a></td><td>". $row["char_name"]. "</td><td class=\"numeric sortedColumn\">".$row["clan_level"]. "</td><td>".$row["hasCastle"]. "</td><td class=\"numeric\">".$row["csum"]. "</td><td class=\"numeric\">".$row["ccount"]. "</td><td class=\"numeric\">".$row["cavg"]. "</td></tr>\n";

}

print "</tbody>\n</table>\n";

mysql_close($link);

?>

 

Retorna neste erro....

Error: Unknown column 'characters.chanid' in 'on clause'

 

Alguem pode me ajudar....

Link para o comentário
Compartilhar em outros sites

3 respostass a esta questão

Posts recomendados

Seja Mas Especificos Nos Posts, Explique Oq Esta Acontecendo e Oq Você Quer

@@rodoolfo__

Things Teens Brasil™O MAIOR TUMBLR DESTINADO A JOVENS BRASILEIROS !

ReiYoutube O TUMBLR QUE MAIS POSTA PEROLAS DO YOUTUBE !

# Tudo Refletido O TUMBLR PESSOAL !

Link para o comentário
Compartilhar em outros sites


<?php

include("module/stat-menu.php");

$result = mysql_query("SELECT clan_data.*,char_name,csum,ccount,cavg FROM clan_data INNER JOIN characters ON clan_data.leader_id=characters.chanid LEFT JOIN (SELECT clanid, SUM(level) AS csum, count(level) AS ccount, AVG(level) AS cavg FROM characters WHERE clanid GROUP BY clanid) AS levels ON clan_data.clanid=levels.clanid ORDER BY clan_level DESC, csum DESC", $link)

or die ("Error: ".mysql_error());

 

mude "chanid" para charId

asinatura.gif

Link para o comentário
Compartilhar em outros sites

Deu certo Assim

<?php

include("module/stat-menu.php");

$result = mysql_query("SELECT clan_data.*,char_name,csum,ccount,cavg FROM clan_data INNER JOIN characters ON clan_data.leader_id=characters.obj_Id LEFT JOIN (SELECT clanid, SUM(level) AS csum, count(level) AS ccount, AVG(level) AS cavg FROM characters WHERE clanid GROUP BY clanid) AS levels ON clan_data.clan_id=levels.clanid ORDER BY clan_level DESC, csum DESC", $link)

or die ("Error: ".mysql_error());

 

print '<table>

<caption><br><b>..:: Top Clans ::..</b><br><br><hr></caption>

<thead>

<tr style="vertical-align: bottom;">

<th>Nome do clan</th>

<th>Lider</th>

<th class="sortedColumn">Level</th>

<th>Castle</th>

<th>Tax of levels</th>

<th>Menbros</th>

<th>Nivel Midio</th>

</tr>

</thead>

<tfoot>

<tr><td colspan="7" style="text-align: right;">'.$L2JBS_lang["clantop_total"].': '.mysql_num_rows($result).'</td></tr>

</tfoot>

<tbody id="TblBdy">

';

 

$i=1;

while ($row=mysql_fetch_array($result))

{

switch ($row["hasCastle"])

{

case 1: $row["hasCastle"]=$L2JBS_lang["clantop_gludiocastle"]; break;

case 2: $row["hasCastle"]=$L2JBS_lang["clantop_dioncastle"]; break;

case 3: $row["hasCastle"]=$L2JBS_lang["clantop_girancastle"]; break;

case 4: $row["hasCastle"]=$L2JBS_lang["clantop_orencastle"]; break;

case 5: $row["hasCastle"]=$L2JBS_lang["clantop_adencastle"]; break;

case 6: $row["hasCastle"]=$L2JBS_lang["clantop_innadrilcastle"]; break;

default: $row["hasCastle"]=$L2JBS_lang["clantop_nocastle"];

}

print "<tr". (($i++ % 2) ? "" : " class=\"alternateRow\"") ."><td><a href=\"index.php?d=module&p=clanview&clan_name=". $row["clan_name"]."\">". htmlspecialchars($row["clan_name"]). "</a></td><td>". $row["char_name"]. "</td><td class=\"numeric sortedColumn\">".$row["clan_level"]. "</td><td>".$row["hasCastle"]. "</td><td class=\"numeric\">".$row["csum"]. "</td><td class=\"numeric\">".$row["ccount"]. "</td><td class=\"numeric\">".$row["cavg"]. "</td></tr>\n";

}

print "</tbody>\n</table>\n";

mysql_close($link);

?>

 

Vlw ae ajuda!!!

Editado por helnata
Link para o comentário
Compartilhar em outros sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Visitante
Responder esta pergunta...

×   Você colou conteúdo com formatação.   Remover formatação

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Processando...



×
×
  • Criar Novo...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.