[WEBSITE]erro

[helnata]

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

[{Admin}-DRACULA-]

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

[Penetra]

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

[helnata]

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 Julho 24, 2009 por helnata