echo '<th class="membersHeader">' . $rc_wordings[$roster_conf['roster_lang']]['Guild'] . '</th>'; echo '<th class="membersHeader">' . $rc_wordings[$roster_conf['roster_lang']]['Level'] . '</th>'; echo '<th class="membersHeaderRight">' . $rc_wordings[$roster_conf['roster_lang']]['Note'] . '</th>'; echo '</tr>'; $total = 0; $rownum = 1; while ($row = $wowdb->fetch_array($result)) { $total += 1; echo '<td class="membersRow' . $rownum . '">' . getClassIcon($row['class']); echo checkMember($row['name']) . '</td>'; echo '<td class="membersRow' . $rownum . '">'; echo $row['guild'] . '</td>'; echo '<td style="text-align:center;" class="membersRow' . $rownum . '">'; echo $row['level'] . '</td>'; echo '<td style="text-align:center;" class="membersRowRight' . $rownum . '">'; echo getNoteIcon($row['note']) . '</td>'; // Close the Row echo '</tr>'; switch ($rownum) { case 1: $rownum = 2; break; default: $rownum = 1; } } // add count echo '<tr><th colspan="4" class="membersHeaderRight">'; echo 'Total: ' . $total; echo '</th></tr>'; // Close table
if ($roster_conf['sqldebug']) { print "<!-- {$query} -->\n"; } $id_result = $wowdb->query($query) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query); $id = $wowdb->fetch_array($id_result); if ($id[0] != '') { echo ' by <a href="char.php?name=' . $row['item_buyer'] . '&server=' . $server_name . '">' . $row['item_buyer'] . '</a></td>'; } else { echo ' by ' . $row['item_buyer'] . '</td>'; } } else { echo ' <span style="color:#999999;">' . $row['item_buyer'] . '</span></td>'; } // Set note echo '<td style="text-align:center;" class="membersRowRight' . $rownum . '">'; echo getNoteIcon($row['item_value']) . '</td>'; // Close the Row echo '</tr>'; switch ($rownum) { case 1: $rownum = 2; break; default: $rownum = 1; } } // Add total loot at bottom echo '<tr><th colspan="3" class="membersHeaderRight">' . $wordings[$roster_conf['roster_lang']]['TotalLoot'] . ': ' . $total_drops . '</th></tr>'; // Close the table echo '</table>'; echo border('syellow', 'end');
$zoneicon = $roster_conf['roster_dir'] . '/addons/EventCalendar/img/icons/'; $zoneicon .= $rc_wordings[$roster_conf['roster_lang']]['Zones'][$row['type']] != '' ? 'Icon-' . $row['type'] . '.jpg' : 'Icon-Unknown.jpg'; $zone = $rc_wordings[$roster_conf['roster_lang']]['Zones'][$row['type']] != '' ? $rc_wordings[$roster_conf['roster_lang']]['Zones'][$row['type']] : $row['type']; echo '<td class="membersRow' . $rownum . '">'; if ($addon_conf['EventCalendar']['ShowIcon']) { echo '<img class="membersRowimg" width="' . $roster_conf['index_iconsize'] . '" height="' . $roster_conf['index_iconsize'] . '" src="' . $zoneicon . '" alt="' . $zone . '" /> '; } echo $row['leader'] . '</td>'; echo '<td class="membersRow' . $rownum . '">'; echo date($addon_conf['EventCalendar']['EventDate'], strtotime($row['date'])) . '</td>'; $note = $row['note']; if ($row['title'] != '') { $note = $row['title'] . '\\n' . $row['note']; } echo '<td style="text-align:center;" class="membersRowRight' . $rownum . '">'; echo getNoteIcon($note) . '</td>'; // Close the Row echo '</tr>'; switch ($rownum) { case 1: $rownum = 2; break; default: $rownum = 1; } } } // Close the table echo '</table>'; // Display the Right side / Bottom of the Stylish Border echo border('syellow', 'end');
$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', ''); ?> </td> <td width="2%"> </td>
function getLootByName($raidnum, $color, $name) { global $wowdb, $roster_conf, $wordings, $rt_wordings, $db_prefix; // Get all loot $query = 'SELECT itemname, note FROM `' . $db_prefix . 'raiditems` WHERE name = \'' . $name . '\' AND color = \'' . $color . '\' AND raidnum = ' . $raidnum . ' ' . $loot_where . ' GROUP BY itemname'; if ($roster_conf['sqldebug']) { print "<!-- {$query} -->\n"; } $result = $wowdb->query($query) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query); $rownum = 1; while ($row = $wowdb->fetch_array($result)) { // Open a new Row echo '<tr>'; // Display the loot $loot_item = '[item]' . $row['itemname'] . '[/item]'; echo itemstats_parse('<td class="membersRow' . $rownum . '">' . utf8_decode($loot_item)); // Display the count $count = 0; $cquery = 'SELECT number FROM `' . $db_prefix . 'raiditems` WHERE name = \'' . $name . '\' AND itemname = \'' . $wowdb->escape($row['itemname']) . '\' AND raidnum = ' . $raidnum; $cresult = $wowdb->query($cquery) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $cquery); while ($crow = $wowdb->fetch_array($cresult)) { $count += $crow['number']; } echo ' x' . $count . '</td>'; // Set note echo '<td style="text-align:center;" class="membersRowRight' . $rownum . '">'; echo getNoteIcon($row['note']) . '</td>'; // Close the Row echo '</tr>'; switch ($rownum) { case 1: $rownum = 2; break; default: $rownum = 1; } } }