Location: PHPKode > projects > Guild DKP System > dkpsystem1.4/includes/admin/outsideloot.php
<table width="100%" border="0" cellspacing="1" cellpadding="3">
  <tr>
    <td bgcolor="#003366"><font color="#FFFFFF" size="2" face="Tahoma"><strong>Outside 
      Loot</strong></font></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
  <tr> 
    <td colspan="4" bgcolor="#003366"><font color="#CCCCCC" size="1" face="Tahoma"><strong>Details</strong></font></td>
  </tr>
  <?php
$sql = $db->query("SELECT * FROM dkp_classes");
while($class_row = mysql_fetch_array($sql)) {
	$classid = $class_row[id];
	$class_name = $class_row['class'];
?>
  <tr bgcolor="#003366"> 
    <td colspan="4"><font color="#CCCCCC" size="1" face="Tahoma"><strong><?php echo $class_name; ?></strong></font></td>
  </tr>
  <tr> 
    <td width="25%" bgcolor="#999999"><u><strong><font color="#000000" size="1" face="Tahoma">Character</font></strong></u></td>
    <td width="25%" bgcolor="#999999"><u><strong><font color="#000000" size="1" face="Tahoma">Class 
      Points</font></strong></u></td>
    <td width="25%" bgcolor="#999999"><u><strong><font color="#000000" size="1" face="Tahoma">General 
      Points</font></strong></u></td>
    <td width="25%" bgcolor="#999999"><u><strong><font color="#000000" size="1" face="Tahoma">Last 
      Raid</font></strong></u></td>
  </tr>
  <?php
	$sql2 = $db->query("SELECT * FROM dkp_users WHERE class=\"$classid\" ORDER BY class_points DESC, name ASC");
	if($db->count_rows($sql2) > 0) {
		while($row = mysql_fetch_array($sql2)) {
			$id = $row[id];
			$character = $row[name];
			$class_points = $row[class_points];
			$general_points = $row[class_points_general];
			$last_active = $row[last_raid_date];
			
			$color1 = "#CCCCCC";
			$color2 = "#D7D7D7";
			$row_color = ($row_count % 2) ? $color1 : $color2;
			$row_count++;

?>
  <tr bgcolor="<?php echo $row_color; ?>"> 
    <td><a href="?d=admin&s=awardloot&userid=<?php echo $id; ?>"><font color="#000000" size="1" face="Tahoma"><strong><?php echo $character; ?></strong></font></a></td>
    <td><strong><font color="#000000" size="1" face="Tahoma"><?php echo $class_points; ?></font></strong></td>
    <td><strong><font color="#000000" size="1" face="Tahoma"><?php echo $general_points; ?></font></strong></td>
    <td><strong><font color="#000000" size="1" face="Tahoma"><?php echo $last_active; ?></font></strong></td>
  </tr>
<?php
		}
	}
	else {
?>
  <tr bgcolor="#CCCCCC"> 
    <td colspan="4"><strong><font color="#000000" size="1" face="Tahoma"><?php echo IMG_ARROW; ?>There 
      are no players in this category.</font></strong></td>
  </tr>
  <?php
	}
}
?>
</table>
Return current item: Guild DKP System