Legion of Sun @ Perenolde (PvE)
Letzte Aktualisierung: 10.10. 10:10 (PST)
Mitglieder: 127 (+0 Alts)
  • Average Level: 55
  • Level 70: 52
  • Level 60-69: 36
  • Level 50-59: 7
  • Level 40-49: 7
  • Level 30-39: 3
  • Level 1-29: 22
WoW Server Status



Gesamt Ersparnisse
0 g 0 s c

Im Besitz von (Kontakt) Gegenstand und Beschreibung


WoWRoster v1.7.2

Dank an Celandro, Paleblackness, Pytte, Rubricsinger, und Konkers für den originalen Code der Seite.
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


Valid HTML 4.0 Transitional

This page was created in 0.09 seconds with 7 queries executed

SQL Queries
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Legion of Sun' AND `server` = 'Perenolde'
SELECT m.member_id, m.name as member_name, m.note as member_note, m.officer_note as member_officer_note, i.*, sum(i.item_quantity) as total_quantity
FROM `roster_items` as i, `roster_members` as m
WHERE i.member_id=m.member_id
AND m.note LIKE '%BankMule%'
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Seelengebunden%'
OR i.item_tooltip
LIKE '%Wird beim Anlegen gebunden%')
GROUP BY i.item_name
SELECT m.member_id, m.name as member_name, m.note as member_note, m.officer_note as member_officer_note, i.*
FROM `roster_items` as i, `roster_members` as m
WHERE i.member_id=m.member_id
AND m.note LIKE '%BankMule%'
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Seelengebunden%'
OR i.item_tooltip
LIKE '%Wird beim Anlegen gebunden%')
ORDER BY i.item_name
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Legion of Sun' AND `server` ='Perenolde'
SELECT IF(`note` LIKE '%alt%',1,0) AS 'isalt',
FLOOR(`level`/10) AS levelgroup,
COUNT(`level`) AS amount,
SUM(`level`) AS sum
FROM `roster_members`
GROUP BY isalt, levelgroup
ORDER BY isalt ASC, levelgroup DESC
SELECT SUM( p.money_g ) AS gold, SUM( p.money_s ) AS silver, SUM( p.money_c ) as copper
FROM `roster_players` AS p, `roster_members` AS m
WHERE m.note LIKE '%BankMule%'
AND p.member_id = m.member_id
ORDER BY m.name