Class Information: ', NAME, '';
echo '
';
echo '
Most Played On
';
showMostMaps('NATURAL JOIN roleperiods', 'class_id = ' . CLASSID);
echo '';
showWeaponsList('INNER JOIN roleperiods ON roleperiod_id = kill_killer WHERE class_id = ' . CLASSID);
show_extra_map_info($_GET['map']);
echo '';
echo 'Top Players
';
showPlayerTable('', 'class_id = ' . CLASSID, 10, true);
echo 'Class Relationships
';
$classes = array();
$sql = 'SELECT rp1.class_id, class_name, COUNT(*) as num FROM classes NATURAL JOIN roleperiods AS rp1 INNER JOIN kills AS k1 ON kill_killer = roleperiod_id INNER JOIN roleperiods AS rp2 ON kill_victim = rp2.roleperiod_id WHERE rp2.class_id = ' . CLASSID . ' GROUP BY class_id ORDER BY class_name';
$res = mysql_query($sql) or print(mysql_error());
while ($row = mysql_fetch_assoc($res)) {
$classes[$row['class_id']] = array(
'name' => $row['class_name'],
'data1' => $row['num']
);
}
$sql = 'SELECT rp1.class_id, class_name, COUNT(*) as num FROM classes NATURAL JOIN roleperiods AS rp1 INNER JOIN kills AS k1 ON kill_victim = roleperiod_id INNER JOIN roleperiods AS rp2 ON kill_killer = rp2.roleperiod_id WHERE rp2.class_id = ' . CLASSID . ' GROUP BY class_id ORDER BY class_name';
$res = mysql_query($sql) or print(mysql_error());
while ($row = mysql_fetch_assoc($res)) {
$classes[$row['class_id']]['data2'] = $row['num'];
$classes[$row['class_id']]['name'] = $row['class_name'];
}
showClassesTable($classes, 'Killer of ' . NAME, 'Victim of ' . NAME, true);
echo '';
require_once('inc/footer.php');
?>