":: Gulvbolden :: ofc-junior.com" <snie@hockeymail.com> skrev i en
meddelelse news:96mkf8$1qpg$1@news.cybercity.dk...
> Jeg poster sourcen som et svar på denne post...
<?
$titel = "Statistik";
include("layout_top.phtml");
overskrift("Topscorerliste");
?>
<table width="100%" bgcolor="black" cellspacing="1">
<tr bgcolor="yellow">
<td width="91%"><b>Spiller:</b></td>
<td width="3%" align="center"><B>M</b></td>
<td width="3%" align="center"><b>A</b></td>
<td width="3%" align="center"><b>PPM</b></td>
<td width="3%" align="center"><b>BPM</b></td>
<td width="3%" align="center"><b>UDV</b></td>
<td width="3%" align="center"><b>P</b></td>
</tr>
<?
// hente sid's
mysqlconnect();
$sqlsid = mysql_query("select sid from rapport where hid = 1 order by sid");
while($q = mysql_fetch_array($sqlsid)) {
$spid = $q["sid"];
// indlæs data
$resultmaal = mysql_query("SELECT COUNT(sid) FROM rapport WHERE eid >= 101
AND eid <= 104 AND sid = $spid ") or die(mysql_error());
$maal = mysql_result($resultmaal,0);
$resultass = mysql_query("SELECT COUNT(ex1) FROM rapport WHERE eid >= 101
AND eid <= 104 AND ex1 = $spid ") or die(mysql_error());
$ass = mysql_result($resultass,0);
$resultppm = mysql_query("SELECT COUNT(sid) FROM rapport WHERE eid = 102 AND
sid = $spid ") or die(mysql_error());
$ppm = mysql_result($resultppm,0);
$resultbpm = mysql_query("SELECT COUNT(sid) FROM rapport WHERE eid = 103 AND
sid = $spid ") or die(mysql_error());
$bpm = mysql_result($resultbpm,0);
$resultudv = mysql_query("SELECT COUNT(sid) FROM rapport WHERE eid = 900 AND
sid = $spid ") or die(mysql_error());
$budv = mysql_result($resultudv,0);
$resultkamp = mysql_query("SELECT COUNT(sid) FROM ofck WHERE sid = $spid ")
or die(mysql_error());
$kampe = mysql_result($resultkamp,0);
$udv = $budv+$budv;
// læg data i databasen
mysqlconnect();
$idc = md5($remote_addr);
mysql_query("insert into topsctemp (id, sid, m, a, p, ppm, bpm, udv, k)
values ('$idc', '$sid', '$maal', '$ass', '$maal+$ass', '$ppm', '$bpm',
'$udv', '$kampe')");
}
//indlæs data til liste
mysqlconnect();
$id = md5($remote_addr);
$topsctemp = mysql_query("select * from topsctemp where id = $id order by p
desc"); // order by ændres alt efter if-sætning
while($r = mysql_fetch_array($topsctemp)) {
$sid = $r["sid"];
$m = $r["m"];
$a = $r["a"];
$p = $r["p"];
$ppm = $r["ppm"];
$bpm = $r["bpm"];
$udv = $r["udv"];
$k = $r["k"];
?>
<tr bgcolor="#ffffcc">
<td><?
$connection = mysql_connect("localhost","ofc","odensefloorballclub");
mysql_select_db("ofc", $connection);
$query2 = mysql_query("select * from spillere order by id");
while($t = mysql_fetch_array($query2)) {
$spillerid = $t["id"];
$fornavn = $t["fornavn"];
$efternavn = $t["efternavn"];
if($spillerid == $sid) {
?>
<?=$fornavn ?> <?=$efternavn ?>
?>
<?
}
}
?></td>
<td align="center"><?=$m ?></td>
<td align="center"><?=$a ?></td>
<td align="center"><?=$ppm ?></td>
<td align="center"><?=$bpm ?></td>
<td align="center"><?=$udv ?></td>
<td align="center" bgcolor="yellow"><?=$p ?></td>
</tr>
<?
}
mysqlconnect();
$id = md5($remote_addr);
mysql_query("delete from topsctemp where id = $id");
?>
</table><br>
<b>Forklaring:</b><br>
K = Kampe for OFC.<br>
M = Mål for OFC.<br>
A = Assists for OFC.<br>
PPM = Mål i overtal for OFC.<br>
BPM = Mål i undertal for OFC.<br>
UDV = Udvisningsminutter for OFC.<br>
PTS = Points for OFC.
<?
include("layout_bottom.phtml");
?>
.... og ja! den er rodet!!