echo '<table cellpadding="0" cellspacing="0" class="membersList">';
// Display the header of the table
echo '<tr>';
echo '<th class="membersHeader">' . $rc_wordings[$roster_conf['roster_lang']]['Class'] . '</th>';
echo '<th class="membersHeaderRight">' . $rc_wordings[$roster_conf['roster_lang']]['LimitStatus'] . '</th>';
echo '</tr>';
echo '<tr>';
// Get all limits
$query_limits = 'SELECT * FROM `' . $db_prefix . 'event_limits` WHERE eventid = ' . $eventid . ' ORDER BY class ASC';
if ($roster_conf['sqldebug']) {
print "<!-- {$query_limits} -->\n";
}
$result_limits = $wowdb->query($query_limits) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query_limits);
$rownum = 1;
while ($row = $wowdb->fetch_array($result_limits)) {
echo '<td class="membersRow' . $rownum . '">' . getClassIcon($row['class']);
echo $rc_wordings['enUS']['Classes'][$row['class']] . '</td>';
// Get all classcount
$query_classcount = 'SELECT s.name FROM `' . $db_prefix . 'event_subscribers` AS s LEFT JOIN `' . $db_prefix . 'event_members` AS m ON m.name = s.name WHERE m.class = "' . $row['class'] . '" AND eventid = ' . $eventid;
if ($roster_conf['sqldebug']) {
print "<!-- {$query_classcount} -->\n";
}
$result_classcount = $wowdb->query($query_classcount) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query_classcount);
$row_classcount = $wowdb->num_rows($result_classcount);
echo '<td style="text-align:center;" class="membersRowRight' . $rownum . '">';
echo $row['min'] . ' / ' . $row_classcount . ' / ' . $row['max'] . '</td>';
// Close the Row
echo '</tr>';
switch ($rownum) {
case 1:
$rownum = 2;
if (!empty($n_attendes['racecode']) && $n_attendes['classcode'] != '?') {
$race_txt = $roster->locale->act['Race'][$n_attendes['racecode']];
} else {
$race_txt = '';
}
if (!empty($s_attendes['classcode']) && $y_attendes['classcode'] != '?') {
$class_txt = $roster->locale->act['Class'][$n_attendes['classcode']];
$class_cd = classswitcher($n_attendes['classcode']);
} else {
$class_txt = '';
$class_cd = '';
}
echo '<tr ' . $stripe_class . '>
<td class="membersRowCell">' . $n_attendes['level'] . '</td>
<td class="membersRowCell">' . utf8_decode($n_attendes['name']) . '</td>
<td class="membersRowCell">' . getClassIcon($class_cd) . '<span class = "class' . $class_txt . 'txt">' . $class_txt . '</span></td>
<td class="membersRowCell">' . $race_txt . '</td>
<td class="membersRowCell">' . utf8_decode($n_attendes['guild']) . '</td>
<td class="membersRowCell">' . getNoteIcon($n_attendes['comment']) . '</td>
</tr>
';
}
?>
</table>
</tr></table>
<?php
}
// close the attendance if statement
?>
<?php
print border('sgreen', 'end', '');
