Dit is mijn code:
<?php
function liststats($divid,$season) {
global $_CONF,$_LANG;
require("classes/Menu.php");
$result_stats = mysql_query("SELECT * FROM ".$_CONF['tprefix']."player_stats WHERE div_id!='0003' AND game_id !='00000035' AND team_id !='0001' AND played != '0' ");
if(!$result_stats) { echo mysql_errno().": ".mysql_error()."<br>"; }
$statcount = mysql_numrows($result_stats);
$sc = 0;
$p_array = Array();
while($sc < $statcount) {
$playerid = mysql_result($result_stats,$sc,"playerid");
$p_array[$playerid][pid] = $playerid;
$p_array[$playerid][goals] = $p_array[$playerid][goals] + mysql_result($result_stats,$sc,"goals");
$p_array[$playerid][assists] = $p_array[$playerid][assists] + mysql_result($result_stats,$sc,"assists");
$p_array[$playerid][saves] = $p_array[$playerid][saves] + mysql_result($result_stats,$sc,"saves");
$p_array[$playerid][shutouts] = $p_array[$playerid][player_stats.shutouts] + mysql_result($result_stats,$sc,"shutouts");
$p_array[$playerid][minutes] = $p_array[$playerid][minutes] + mysql_result($result_stats,$sc,"minutes");
$p_array[$playerid][yellow] = $p_array[$playerid][yellow] + mysql_result($result_stats,$sc,"yellow");
$p_array[$playerid][red] = $p_array[$playerid][red] + mysql_result($result_stats,$sc,"red");
$p_array[$playerid][gp] = $p_array[$playerid][gp] + mysql_result($result_stats,$sc,"played");
$p_array[$playerid][pts] = ($p_array[$playerid][goals] * $_CONF['goal']) + ($p_array[$playerid][assists] * $_CONF['assist']);
$result_player = mysql_query("SELECT * FROM ".$_CONF['tprefix']."players WHERE teamid !='0020' AND teamid !='0032' AND id = '$playerid' ");
$p_array[$playerid][fname] = mysql_result($result_player,0,"fname");
$p_array[$playerid][lname] = mysql_result($result_player,0,"lname");
$p_array[$playerid][position] = mysql_result($result_player,0,"position");
$p_array[$playerid][number] = mysql_result($result_player,0,"number");
$teaminfoid = mysql_result($result_player,0,"teamid");
$p_array[$playerid][teamid] = $teaminfoid;
$result_team = mysql_query("SELECT name FROM ".$_CONF['tprefix']."teams WHERE id = '$teaminfoid'");
$p_array[$playerid][team] = mysql_result($result_team,0,"name");
$sc++;
}
uasort($p_array, 'Compare_stats');
$si = 1;
while ((list ($key, $value) = each ($p_array)) && $si < "11") {
if($_CONF['playerinfo'] == "1") {
$playerinfo = "
<a href=\"playerinfo.php?pid=".$value["pid"]."\"
onClick=\"NewWindow(this.href,'name','400','450','yes');return false;\">
<u>$value[fname] $value[lname]</u></a>";
} else {
$playerinfo = "
$value[fname] $value[lname]";
}
if($si == 1) {
$stats .= "
<tr bgcolor=\"#ffffff\" align=\"center\">
<td height=\"1\" bgcolor=\"#006600\" colspan=\"6\"></td>
</tr>
<tr bgcolor=\"#FFECD7\" align=\"center\">
<td class=\"table_text\">$si</td>
<td class=\"table_text\" align=\"left\">$playerinfo</td>
<td class=\"table_text\">".$value["position"]."</td>
<td class=\"table_text\">".$value["gp"]."</td>
<td class=\"table_text\">".$value["goals"]."</td>
<td class=\"table_text\">".$value["assists"]."</td>
<tr bgcolor=\"#ffffff\" align=\"center\">
<td height=\"1\" bgcolor=\"#006600\" colspan=\"6\"></td>
</tr>";
}else{
$stats .= "
<tr bgcolor=\"#ffffff\" align=\"center\">
<td class=\"table_text\">$si</td>
<td class=\"table_text\" align=\"left\">$playerinfo</td>
<td class=\"table_text\">".$value["position"]."</td>
<td class=\"table_text\">".$value["gp"]."</td>
<td class=\"table_text\">".$value["goals"]."</td>
<td class=\"table_text\">".$value["assists"]."</td>
</tr>";
}
$si++;
}
if($si == 0) {
$stats = "<tr><td class=\"body_text\" align=\"center\" colspan=\"13\"
bgcolor=\"#ffffff\">$_LANG[cc_nostats]</td></tr>";
}
$item_menu = new Menu;
$item_menu->CreateMain($type = "stats");
$item_menu->CreateAnn();
$menu = $item_menu->get();
ob_start();
include("html/topscorer_body.html");
$contents = ob_get_contents();
ob_end_clean();
return $contents;
}
?>
kan iemand mij helpen???
Alvast bedankt
[edit]
Mod-Edit: Ik heb ook even php-tags toegevoegd in verband met de highlighting.
SanThe.
[/edit]