WoWRoster [ Geriatric Ward @ US-Aerie Peak ]

Beta Software

By using this beta software you are bound by the terms outlined here.

For information on removing this message, click the link.

Geriatric Ward @ US-Aerie PeakGeriatric Ward @ US-Aerie Peak

Members: 63Members: 63

Affiliated Alliance guild: <Thud and Blunder> on Eldre'Thalas

Honor System Stats

PvP Stats

Close all	Open all	Ungroup alts	Group alts (open)	Group alts (closed)

Name

Class

Level

Title

Professions

Last Zone

Note

Scherzo

Slave

Dalaran

Unscratch

Cellar Dweller

Howling Fjord

Killion

Slave

The Hinterlands

Syncopation

Slave

Thunder Bluff

Vivace

Slave

Shattrath City

Grizelda

Slave

Orgrimmar

Threnodÿ

Slave

Dalaran

Decederia

Slave

Orgrimmar

Jetnuls

Slave

Eastern Plaguelands

Kungfoogrip

Slave

Dalaran

Maddyx

Slave

Hellfire Peninsula

Minge

Citizen

Durotar

Rosemilk

Nominated Slave

Plaguelands: The Scarlet Enclave

Lyta

Slave

Dustwallow Marsh

Kulhari

Slave

Thunder Bluff

Lanfeer

Slave

Stranglethorn Vale

Allegro

Slave

Undercity

Glissando

Slave

Undercity

Susicivus

Slave

Thunder Bluff

Angelika

Slave

Undercity

Silentfart

Slave

Orgrimmar

Udderlysilly

Slave

Stranglethorn Vale

Udrdstructn

Slave

Thousand Needles

Gangar

Citizen

Mulgore

Sorge

Slave

Orgrimmar

Redmolly

Slave

Silvermoon City

Wickednova

Slave

Silvermoon City

Darkmrstress

Slave

Undercity

Hoofhardead

Slave

The Barrens

Horderoids

Citizen

Silverpine Forest

Kreature

Slave

Undercity

Parmesanoveg

Slave

The Barrens

Deadheadz

Slave

Thunder Bluff

Cremepuffveg

Slave

Orgrimmar

Omgyourdead

Slave

Undercity

Cowswithgunz

Slave

The Barrens

Cyndrialeaf

Slave

Silvermoon City

Unffej

Slave

Thunder Bluff

Cowpâté

Slave

Mulgore

Mclintock

Slave

Tirisfal Glades

Mootopia

Slave

Thunder Bluff

Yettia

Slave

Thunder Bluff

Hathora

Slave

Thunder Bluff

Carpenoctum

Slave

Eversong Woods

Melindaria

Slave

Eversong Woods

Esorsyc

Slave

Orgrimmar

Eclectickiss

Slave

Eversong Woods

Kalous

Slave

Mulgore

Oneleftnut

Slave

Silvermoon City

Orcxx

Slave

Orgrimmar

Roseleena

Slave

Eversong Woods

Veruca

Slave

Silvermoon City

Homogenius

Slave

Mulgore

Ixchel

Tourist

Eversong Woods

Madlycow

Has a Visa

Mulgore

Sutpen

Citizen

Durotar

Snakexx

Slave

Tirisfal Glades

Fleabait

Slave

Mulgore

Spiralistica

Slave

Eversong Woods

Eeyorc

Slave

Durotar

Cyrah

Slave

Durotar

Pigpenz

Slave

Eversong Woods

Pomprincess

Slave

Eversong Woods

WoWRoster v2.0.9.2014

Props to Celandro, Paleblackness, Pytte, Rubricsinger, and Konkers for the original code used for this site.
WoWRoster home - www.wowroster.net
World of Warcraft and Blizzard Entertainment are trademarks or registered trademarks of Blizzard Entertainment, Inc. in the U.S. and/or other countries. All other trademarks are the property of their respective owners.
Additional Credits

0.9 | 22

SQL Queries

Line	Time	Query
lib/roster.php
152	0.0014	SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
523	0.0007	SELECT * FROM `roster_addon` ORDER BY `basename`;
427	0.0006	SELECT guild.* FROM `roster_guild` guild WHERE `guild_id` = "1";
lib/functions.lib.php
1028	0.0013	SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '5' ORDER BY `id` ASC;
1028	0.0014	SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '5' ORDER BY `id` ASC;
lib/hslist.php
34	0.0015	SELECT `name`, `lifetimeRankName` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `lifetimeHighestRank`DESC, `lifetimeHK` DESC LIMIT 0 , 1
51	0.0013	SELECT `name`, `lifetimeHK` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `lifetimeHK` DESC, `lifetimeHighestRank` DESC LIMIT 0 , 1
68	0.0013	SELECT `name`, `honorpoints` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `honorpoints` DESC LIMIT 0 , 1
85	0.0013	SELECT `name`, `arenapoints` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `arenapoints` DESC LIMIT 0 , 1
addons/pvplog/inc/pvplist.php
40	0.001	SELECT `pvp`.`guild`, COUNT(`pvp`.`guild`) AS countg FROM `roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`guild` != '' AND `pvp`.`win` = '1' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`guild` ORDER BY countg DESC
63	0.0005	SELECT `pvp`.`guild`, COUNT(`pvp`.`guild`) AS countg FROM `roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`guild` != '' AND `pvp`.`win` = '0' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`guild` ORDER BY countg DESC
86	0.0004	SELECT `pvp`.`name`, COUNT(`pvp`.`name`) AS countg FROM `roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`guild` != '' AND `pvp`.`win` = '1' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`name` ORDER BY countg DESC
109	0.0004	SELECT `pvp`.`name`, COUNT(`pvp`.`name`) AS countg FROM `roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`win` = '0' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`name` ORDER BY countg DESC
132	0.0004	SELECT `pvp`.`member_id`, `members`.`name` AS gn, COUNT(`pvp`.`member_id`) AS countg FROM `roster_addons_pvplog_pvp2` pvp LEFT JOIN `roster_members` members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`win` = '1' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`member_id` ORDER BY countg DESC;
155	0.0004	SELECT `pvp`.`member_id`, `members`.`name` AS gn, COUNT(`pvp`.`member_id`) AS countg FROM `roster_addons_pvplog_pvp2` pvp LEFT JOIN `roster_members` members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`win` = '0' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`member_id` ORDER BY countg DESC;
178	0.0004	SELECT `pvp`.`member_id`, `members`.`name` AS gn, AVG(`pvp`.`leveldiff`) AS ave, COUNT(`pvp`.`member_id`) AS countg FROM `roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`win` = '1' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`member_id` ORDER BY ave DESC
203	0.0004	SELECT `pvp`.`member_id`, `members`.`name` AS gn, AVG(`pvp`.`leveldiff`) AS ave, COUNT(`pvp`.`member_id`) AS countg FROM `roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`win` = '0' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`member_id` ORDER BY ave DESC
addons/memberslist/inc/memberslist.php
362	0.0183	SELECT `members`.`member_id`, `members`.`name`, `members`.`class`, `members`.`classid`, `members`.`level`, `members`.`zone`, `members`.`online`, `members`.`last_online`, UNIX_TIMESTAMP(`members`.`last_online`) AS 'last_online_stamp', DATE_FORMAT( DATE_ADD(`members`.`last_online`, INTERVAL 0 HOUR ), '%a %b %D, %l:%i %p' ) AS 'last_online_format', `members`.`note`, `members`.`guild_title`, `alts`.`main_id`, `guild`.`update_time`, `guild`.`factionEn`, IF( `members`.`note` IS NULL OR `members`.`note` = '', 1, 0 ) AS 'nisnull', `members`.`officer_note`, IF( `members`.`officer_note` IS NULL OR `members`.`officer_note` = '', 1, 0 ) AS 'onisnull', `members`.`guild_rank`, `players`.`server`, `players`.`race`, `players`.`sex`, `players`.`exp`, `players`.`clientLocale`, `players`.`lifetimeRankName`, `players`.`lifetimeHighestRank`, IF( `players`.`lifetimeHighestRank` IS NULL OR `players`.`lifetimeHighestRank` = '0', 1, 0 ) AS 'risnull', `players`.`hearth`, IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', UNIX_TIMESTAMP( `players`.`dateupdatedutc`) AS 'last_update_stamp', DATE_FORMAT( DATE_ADD(`players`.`dateupdatedutc`, INTERVAL 0 HOUR ), '%a %b %D, %l:%i %p' ) AS 'last_update_format', IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull', GROUP_CONCAT( DISTINCT CONCAT( `proftable`.`skill_name` , '\|', `proftable`.`skill_level` ) ORDER BY `proftable`.`skill_order`) as professions, GROUP_CONCAT( DISTINCT CONCAT( `talenttable`.`tree` , '\|', `talenttable`.`pointsspent` , '\|', `talenttable`.`background` ) ORDER BY `talenttable`.`order`) AS 'talents' FROM `roster_members` AS members LEFT JOIN `roster_players` AS players ON `members`.`member_id` = `players`.`member_id` LEFT JOIN `roster_skills` AS proftable ON `members`.`member_id` = `proftable`.`member_id` AND ( `proftable`.`skill_order` = 2 OR `proftable`.`skill_order` = 3 ) LEFT JOIN `roster_talenttree` AS talenttable ON `members`.`member_id` = `talenttable`.`member_id` LEFT JOIN `roster_addons_memberslist_alts` AS alts ON `members`.`member_id` = `alts`.`member_id` LEFT JOIN `roster_guild` AS guild ON `members`.`guild_id` = `guild`.`guild_id` WHERE (`members`.`guild_id` = "1") GROUP BY `members`.`member_id` ORDER BY IF(`members`.`member_id` = `alts`.`member_id`,1,0),`members`.`level` DESC,`members`.`name` ASC
header.php
209	0.0006	SELECT `guild_name`, CONCAT(`region`,'-',`server`), `guild_id` FROM `roster_guild` ORDER BY `region` ASC, `server` ASC, `guild_name` ASC;
lib/menu.php
184	0.0016	SELECT count(`member_id`) AS `amount`, IF(`note` LIKE '%alt%',1,0) AS isalt, FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 30 AND `guild_id` = '1' GROUP BY isalt, label;
364	0.0012	SELECT `mb`.*, `a`.`basename` FROM `roster_menu_button` AS mb LEFT JOIN `roster_addon` AS a ON `mb`.`addon_id` = `a`.`addon_id` WHERE `a`.`addon_id` IS NULL OR `a`.`active` = 1;
381	0.0006	SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild') ORDER BY `config_id`;