WoW Guild
|
WoW Guild |
| Black Cell: Perklon | |||||
|---|---|---|---|---|---|
| Earned: 0.00 | Spent: 0.00 | Adjustment: 0.00 | Current: 0.00 | ||
| Last 30 Days: 0% of raids | Last 60 Days: 0% of raids | Last 90 Days: 59% of raids | Lifetime (06/08/10 - 06/17/10): 59% of raids | ||
| Raid Attendance History | ||||
|---|---|---|---|---|
| Date | Name | Note | Earned | Current |
| 06/17/10 | Valithria Dreamwalker | Valithria Dreamwalker | 0.00 | 0.00 |
| 06/09/10 | Lich King | Lich King | 0.00 | 0.00 |
| 06/09/10 | Sindragosa | Sindragosa | 0.00 | 0.00 |
| 06/09/10 | Valithria Dreamwalker | Valithria Dreamwalker | 0.00 | 0.00 |
| 06/09/10 | Professor Putricide | Professor Putricide | 0.00 | 0.00 |
| 06/08/10 | Festergut | Festergut | 0.00 | 0.00 |
| 06/08/10 | Rotface | Rotface | 0.00 | 0.00 |
| 06/08/10 | Blood-Queen Lana'thel | Blood-Queen Lana'thel | 0.00 | 0.00 |
| 06/08/10 | Blood Princes | Blood Princes | 0.00 | 0.00 |
| 06/08/10 | Deathbringer Saurfang | Deathbringer Saurfang | 0.00 | 0.00 |
| 06/08/10 | Gunship | Gunship | 0.00 | 0.00 |
| 06/08/10 | Lady Deathwhisper | Lady Deathwhisper | 0.00 | 0.00 |
| 06/08/10 | Lord Marrowgar | Lord Marrowgar | 0.00 | 0.00 |
| ... found 13 attended raid(s) / 100 per page | ||||
| Item Purchase History | ||||
|---|---|---|---|---|
| Date | Name | Raid | Spent | Current |
| 06/09/10 | Memory of Malygos | Sindragosa | 0.00 | 0.00 |
| 06/09/10 | Conqueror's Mark of Sanctification | Sindragosa | 0.00 | 0.00 |
| 06/08/10 | Conqueror's Mark of Sanctification | Blood-Queen Lana'thel | 0.00 | 0.00 |
| 06/08/10 | The Lady's Brittle Bracers | Lady Deathwhisper | 0.00 | 0.00 |
| ... found 4 purchased item(s) / 100 per page | ||||
| Individual Adjustment History | ||
|---|---|---|
| Date | Reason | Adjustment |
| ... found 0 adjustment(s) | ||
| Attendance by Event | |
|---|---|
| Event | Percent |
| Blood Princes | 1 (50%)
|
| Blood-Queen Lana'thel | 1 (100%)
|
| Deathbringer Saurfang | 1 (50%)
|
| Festergut | 1 (50%)
|
| Gunship | 1 (50%)
|
| Lady Deathwhisper | 1 (50%)
|
| Lich King | 1 (100%)
|
| Lord Marrowgar | 1 (50%)
|
| Professor Putricide | 1 (50%)
|
| Rotface | 1 (50%)
|
| Sindragosa | 1 (100%)
|
| Valithria Dreamwalker | 2 (100%)
|
| Queries |
|---|
| SELECT config_name, config_value FROM eqdkpnew_config |
| SELECT session_id, session_start, session_current, session_page, session_ip FROM eqdkpnew_sessions AS s WHERE (`session_id` = 'ef113ad3d6815914983d358ad894bd05') AND (`session_ip` = '38.107.191.83') LIMIT 1 |
| INSERT INTO eqdkpnew_sessions (session_id, user_id, session_start, session_current, session_page, session_ip) VALUES ('f12e4139d6a702602841c498a486b5a9', '-1', '1283767761', '1283767761', 'viewmember.php?s=&name=Perklon', '38.107.191.83') |
| SELECT s.*, c.* FROM eqdkpnew_styles AS s, eqdkpnew_style_config AS c WHERE (s.`style_id` = c.`style_id`) AND (s.`style_id` = '1') |
| SELECT auth_value, auth_default AS auth_setting FROM eqdkpnew_auth_options |
| SELECT plugin_code, plugin_path, plugin_installed FROM eqdkpnew_plugins ORDER BY plugin_name |
| SELECT member_id, member_name, member_earned, member_spent, member_adjustment, (member_earned-member_spent+member_adjustment) AS member_current, member_firstraid, member_lastraid FROM eqdkpnew_members WHERE (`member_name` = 'Perklon') |
| SELECT COUNT(*) FROM eqdkpnew_raids WHERE (raid_date BETWEEN 1281157200 AND 1283767761) |
| SELECT COUNT(*) FROM eqdkpnew_raids AS r, eqdkpnew_raid_attendees AS ra WHERE (ra.`raid_id` = r.`raid_id`) AND (ra.`member_name` = 'Perklon') AND (r.`raid_date` BETWEEN 1281157200 AND 1283767761) |
| SELECT COUNT(*) FROM eqdkpnew_raids WHERE (raid_date BETWEEN 1278565200 AND 1283767761) |
| SELECT COUNT(*) FROM eqdkpnew_raids AS r, eqdkpnew_raid_attendees AS ra WHERE (ra.`raid_id` = r.`raid_id`) AND (ra.`member_name` = 'Perklon') AND (r.`raid_date` BETWEEN 1278565200 AND 1283767761) |
| SELECT COUNT(*) FROM eqdkpnew_raids WHERE (raid_date BETWEEN 1275973200 AND 1283767761) |
| SELECT COUNT(*) FROM eqdkpnew_raids AS r, eqdkpnew_raid_attendees AS ra WHERE (ra.`raid_id` = r.`raid_id`) AND (ra.`member_name` = 'Perklon') AND (r.`raid_date` BETWEEN 1275973200 AND 1283767761) |
| SELECT COUNT(*) FROM eqdkpnew_raids WHERE (raid_date BETWEEN 1276046371 AND 1276835386) |
| SELECT COUNT(*) FROM eqdkpnew_raids AS r, eqdkpnew_raid_attendees AS ra WHERE (ra.`raid_id` = r.`raid_id`) AND (ra.`member_name` = 'Perklon') AND (r.`raid_date` BETWEEN 1276046371 AND 1276835386) |
| SELECT r.raid_id, r.raid_name, r.raid_date, r.raid_note, r.raid_value FROM eqdkpnew_raids AS r, eqdkpnew_raid_attendees AS ra WHERE (ra.raid_id = r.raid_id) AND (ra.`member_name` = 'Perklon') ORDER BY r.raid_date DESC LIMIT 0,100 |
| SELECT COUNT(*) FROM eqdkpnew_raids AS r, eqdkpnew_raid_attendees AS ra WHERE (ra.raid_id = r.raid_id) AND (ra.`member_name` = 'Perklon') |
| SELECT i.item_id, i.item_name, i.item_value, i.item_date, i.raid_id, r.raid_name FROM eqdkpnew_items AS i LEFT JOIN eqdkpnew_raids AS r ON r.raid_id = i.raid_id WHERE (i.`item_buyer` = 'Perklon') ORDER BY i.item_date DESC LIMIT 0,100 |
| SELECT COUNT(*) FROM eqdkpnew_items WHERE (`item_buyer` = 'Perklon') ORDER BY item_date DESC |
| SELECT adjustment_value, adjustment_date, adjustment_reason, member_name FROM eqdkpnew_adjustments WHERE (`member_name` = 'Perklon') OR (member_name IS NULL AND adjustment_date >= 1276046371) ORDER BY adjustment_date DESC |
| SELECT e.event_id, r.raid_name, COUNT(ra.raid_id) AS raid_count FROM eqdkpnew_events AS e, eqdkpnew_raid_attendees AS ra, eqdkpnew_raids AS r WHERE (e.event_name = r.raid_name) AND (r.raid_id = ra.raid_id) AND (ra.`member_name` = 'Perklon') AND (r.`raid_date` >= 1276046371) GROUP BY ra.member_name, r.raid_name |
| SELECT raid_name, COUNT(raid_id) AS raid_count FROM eqdkpnew_raids WHERE (`raid_date` >= 1276046371) GROUP BY raid_name |