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

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

Shattrath City

Killion

Slave

The Hinterlands

Unscratch

Cellar Dweller

Shattrath City

Grizelda

Slave

Orgrimmar

Threnodÿ

Slave

Dalaran

Decederia

Slave

Blackrock Mountain

Jetnuls

Slave

Eastern Plaguelands

Kungfoogrip

Slave

Dalaran

Maddyx

Slave

Hellfire Peninsula

Minge

Citizen

Durotar

Syncopation

Slave

Thunder Bluff

Vivace

Slave

Eastern Plaguelands

Lyta

Slave

Dustwallow Marsh

Kulhari

Slave

Thunder Bluff

Lanfeer

Slave

Stranglethorn Vale

Allegro

Slave

Orgrimmar

Glissando

Slave

Borean Tundra

Angelika

Slave

Undercity

Susicivus

Slave

Orgrimmar

Silentfart

Slave

Orgrimmar

Udrdstructn

Slave

Thousand Needles

Udderlysilly

Slave

Orgrimmar

Scaryfat

Has a Visa

Silvermoon City

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

Cowpâté

Slave

Mulgore

Mclintock

Slave

Tirisfal Glades

Mootopia

Slave

Thunder Bluff

Yettia

Slave

Thunder Bluff

Hathora

Slave

Thunder Bluff

Unffej

Slave

Thunder Bluff

Carpenoctum

Slave

Eversong Woods

Melindaria

Slave

Eversong Woods

Dapreacher

Citizen

Tirisfal Glades

Esorsyc

Slave

Orgrimmar

Eclectickiss

Slave

Eversong Woods

Kalous

Slave

Mulgore

Oneleftnut

Slave

Silvermoon City

Orcxx

Slave

Orgrimmar

Veruca

Slave

Silvermoon City

Homogenius

Slave

Mulgore

Madlycow

Has a Visa

Mulgore

Squidsrus

Tourist

Eversong Woods

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.81 | 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.0005	SELECT guild.* FROM `roster_guild` guild WHERE `guild_id` = "1";
lib/functions.lib.php
1028	0.0012	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.0186	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.0015	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.0009	SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild') ORDER BY `config_id`;