Beispiel #1
0
 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
Beispiel #2
0
        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');
Beispiel #3
0
         $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 . '" />&nbsp;';
         }
         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');
Beispiel #4
0
                $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%">&nbsp;</td>
Beispiel #5
0
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;
        }
    }
}