global $scid;
include('db_config.php');
$sql0="select scode,sname from $_reg where scode='$scid'" ;
$result0=mysql_query($sql0);
$db0=mysql_fetch_array($result0);
$sname=$db0[sname];
$sql="SELECT * FROM $_act,$_data
WHERE kd_code=kp_code and kd_sch='$scid' and g+s+b>0
order by g desc,s desc,b desc,kd_code";
$result=mysql_query($sql);
echo "ÊÃØ»àËÃÕÂÃÒ§ÇÑÅ á¡»ÃÐàÀ· ʾÁ.$sname $_title";
echo "";
echo "àËÃÕ |
¡Ô¨¡ÃÃÁ |
¹Ñ¡àÃÕ¹ |
¤ÃÙ |
âçàÃÕ¹ |
ËÁÒÂà赯 |
á¨é§á¡éä¢ |
";
$gr=''; $ac=''; $md=''; $rp=''; $sc='';
while ($db=mysql_fetch_array($result)) {
if ($db[g]>0) {
$medal='·Í§';
$col='#FFFF99';
// $type=$db[g];
} elseif ($db[s]>0) {
$medal='à§Ô¹';
$col='#DDDDFF';
// $type=$db[s];
} elseif ($db[b]>0) {
$medal='·Í§á´§';
$col='#FFD9E9';
// $type=$db[b];
} elseif ($db[a]>0) {
$medal='ªÁàªÂ';
$col='#DFFFFF';
// $type=$db[b];
}
if ($db[kd_rank]<4) {
$rem="µÑÇá·¹ÀÒ¤Ï";
} else {
$rem=" ";
}
if ($db[kp_grp]==$gr) {
if ($db[kd_code] ==$ac) {
$gp=" ";
} else {
$gp="$db[kp_grp]";
}
} else {
$gp="$db[kp_grp]";
}
if ($db[kd_code] ==$ac) {
$act=" ";
} else {
$act="$db[kp_act] ($db[kp_level])";
}
if ($medal==$md) {
if ($db[kd_code]==$ac) {
$med=" ";
// $psc=" ";
} else {
$med="$medal";
// $psc="¾ÔÁ¾ì ÃÃ.";
}
} else {
$med="$medal";
// $psc="¾ÔÁ¾ì ÃÃ.";
}
if ($db[kd_ed]=='2') {
$rmk="á¨é§áÅéÇ";
} elseif($db[kd_ed]=='1') {
$rmk="ÃÍá¡éä¢";
} else {
$rmk="á¨é§á¡éä¢";
}
$sql2="select scc,scn from $_sc where scc='$db[kd_school]' ";
$result2=mysql_query($sql2);
$db2=mysql_fetch_array($result2);
$scm=$db2[scn];
echo "
$med |
$db[kp_act] |
$db[kd_std] |
$db[kd_tutor] |
$scm |
$rem |
$rmk |
";
$ac=$db[kd_code]; $gr=$db[kp_grp]; $md=$medal; $sc=$db[kd_sch];
}
echo "
";
mysql_close();
?>