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

Alchimie
Level Name
375
Silv
375
Xantic
372
Pyrgus
329
Sambia
300
Brigantia
296
Spitz
201
Pazival

Bergbau
Level Name
345
Gregorian
301
Beor
300
Littlemay
286
Thaldurin
4
Pongtong

Ingenieurskunst
Level Name
300
Beor

Lederverarbeitung
Level Name
375
Amandor
300
Thainvoldo

Schmiedekunst
Level Name
310
Gregorian
300
Littlemay
225
Thaldurin

Schneiderei
Level Name
375
Amigor
375
Jacket
375
Sylv
375
Worlyn
347
Mirandana
300
Sheniva

Verzauberkunst
Level Name
375
Amigor
375
Worlyn
365
Sylv
340
Mirandana
300
Sheniva
7
Pazival

Angeln
Level Name
375
Silv
336
Amandor
311
Sylv
300
Littlemay
300
Worlyn
225
Pyrgus
195
Sheniva
182
Brigantia
161
Sambia
129
Mirandana
110
Spitz
108
Thainvoldo
40
Pongtong
22
Amigor
20
Xantic

Erste Hilfe
Level Name
375
Amandor
375
Amigor
375
Gregorian
375
Jacket
375
Mirandana
375
Pyrgus
375
Silv
375
Sylv
375
Worlyn
375
Xantic
341
Sambia
300
Brigantia
300
Littlemay
300
Sheniva
300
Thainvoldo
300
Thaldurin
225
Spitz
105
Pongtong

Kochkunst
Level Name
375
Amandor
375
Silv
375
Sylv
375
Worlyn
300
Littlemay
300
Sheniva
284
Pyrgus
265
Brigantia
93
Thainvoldo
87
Pongtong
65
Sambia
44
Thaldurin
42
Amigor
6
Beor



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.05 seconds with 5 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 `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 `s`.*, `p`.`name` FROM `roster_skills` s, `roster_players` p
WHERE p.member_id = s.member_id
AND p.guild_id = '1'
AND SUBSTRING_INDEX( s.skill_level, ':', 1 ) > 1
AND skill_name IN ('Alchemy','Alchimie','Alchimie','Herbalism','Herboristerie','Kräuterkunde','Blacksmithing','Forge','Schmiedekunst','Mining','Minage','Bergbau','Leatherworking','Travail du cuir','Lederverarbeitung','Skinning','Dépeçage','Kürschnerei','Tailoring','Couture','Schneiderei','Enchanting','Enchantement','Verzauberkunst','Engineering','Ingénierie','Ingenieurskunst','Cooking','Cuisine','Kochkunst','Fishing','Pêche','Angeln','First Aid','Secourisme','Erste Hilfe')
ORDER BY s.skill_type,s.skill_name,(mid(skill_level FROM 1 FOR (locate(':', skill_level)-1)) + 0) DESC, p.name;