|
||||||||||||||||||||
|
|
|
![[]](img/note.gif)
![[]](img/no_note.gif)
| Updating Instructions | ||
|---|---|---|
|
Recommended automatic updaters:
|
||
WoWRoster v1.7.3
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
This page was created in 0.41 seconds with 85 queries executed
| SQL Queries | ||
|---|---|---|
|
SELECT `config_name`, `config_value` FROM `roster2_config` ORDER BY `id` ASC; SELECT * FROM `roster2_guild` WHERE `guild_name` = 'Imperial Defenders' AND `server` = 'Terenas' SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster2_guild` WHERE `guild_name` = 'Imperial Defenders' AND `server` ='Terenas' SELECT IF(`note` LIKE '%alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS amount, SUM(`level`) AS sum FROM `roster2_members` GROUP BY isalt, levelgroup ORDER BY isalt ASC, levelgroup DESC SELECT `name`, `lifetimeRankName` FROM `roster2_players` ORDER BY `lifetimeHighestRank`DESC, `lifetimeHK` DESC LIMIT 0 , 1 SELECT `name`, `lifetimeHK` FROM `roster2_players` ORDER BY `lifetimeHK` DESC, `lifetimeHighestRank` DESC LIMIT 0 , 1 SELECT `name`, `honorpoints` FROM `roster2_players` ORDER BY `honorpoints` DESC LIMIT 0 , 1 SELECT `name`, `arenapoints` FROM `roster2_players` ORDER BY `arenapoints` DESC LIMIT 0 , 1 SELECT `guild`, COUNT(`guild`) AS countg FROM `roster2_pvp2` WHERE `win` = '1' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC SELECT `guild`, COUNT(`guild`) AS countg FROM `roster2_pvp2` WHERE `win` = '0' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC SELECT `name`, COUNT(`name`) AS countg FROM `roster2_pvp2` WHERE `win` = '1' AND `enemy` = '1' GROUP BY `name` ORDER BY countg DESC SELECT `name`, COUNT(`name`) AS countg FROM `roster2_pvp2` WHERE `win` = '0' AND `enemy` = '1' GROUP BY `name` ORDER BY countg DESC SELECT pvp2.member_id, members.name AS gn, COUNT(pvp2.member_id) AS countg FROM `roster2_pvp2` pvp2 LEFT JOIN `roster2_members` members ON members.member_id = pvp2.member_id WHERE win = '1' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY countg DESC SELECT pvp2.member_id, members.name AS gn, COUNT(pvp2.member_id) as countg FROM `roster2_pvp2` pvp2 LEFT JOIN `roster2_members` members ON members.member_id = pvp2.member_id WHERE win = '0' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY countg DESC SELECT pvp2.member_id, members.name as gn, AVG(pvp2.`leveldiff`) as ave, COUNT(pvp2.member_id) as countg FROM `roster2_pvp2` pvp2 LEFT JOIN `roster2_members` members ON members.member_id = pvp2.member_id WHERE win = '1' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY ave DESC SELECT pvp2.member_id, members.name as gn, AVG(pvp2.`leveldiff`) as ave, COUNT(pvp2.member_id) as countg FROM `roster2_pvp2` pvp2 LEFT JOIN `roster2_members` members ON members.member_id = pvp2.member_id WHERE win = '0' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY ave DESC SELECT `members`.`member_id`, `members`.`name`, `members`.`class`, `members`.`note`, IF( `members`.`note` IS NULL OR `members`.`note` = '', 1, 0 ) AS 'nisnull', `members`.`level`, `members`.`guild_rank`, `members`.`guild_title`, `members`.`zone`, DATE_FORMAT( `members`.`last_online`, '%a %b %D, %l:%i %p' ) AS 'last_online', `players`.`race`, `players`.`lifetimeRankName`, `players`.`lifetimeHighestRank`, IF( `players`.`lifetimeHighestRank` IS NULL OR `players`.`lifetimeHighestRank` = '0', 1, 0 ) AS 'risnull', `players`.`exp`, `players`.`server`, `players`.`clientLocale` , `players`.`hearth`, IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', `players`.`dateupdatedutc` AS 'last_update', IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull' FROM `roster2_members` AS members LEFT JOIN `roster2_players` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '1' ORDER BY `members`.`level` DESC, `members`.`name` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '710' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '150' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '472' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '425' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '420' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '245' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '334' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '58' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '405' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '330' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '398' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '181' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '636' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '183' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '4' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '412' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '191' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '394' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '177' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '152' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '33' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '411' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '94' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '170' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '134' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '423' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '92' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '424' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '103' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '409' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '527' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '131' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '167' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '23' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '304' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '408' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '186' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '26' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '462' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '61' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '72' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '132' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '401' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '392' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '459' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '374' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '105' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '308' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '166' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '11' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '295' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '363' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '13' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '189' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '140' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '114' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '349' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '662' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '196' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '45' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '359' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '361' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '195' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '175' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '102' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '356' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '10' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC SELECT * FROM `roster2_skills` WHERE `member_id` = '533' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC |
||