Hier klicken um zur Aktualisierungsanleitung zu gelangen

!! Alle Info's zum Gildentreffen sind jetzt im Forum !!

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

Ehren Statistiken
Höchstrangigstes Mitglied diese Woche Jacket keine
Höchsten Lebenszeit Rang Jacket Rittmeister
Höchsten Lebenszeit ES Jacket 56286
Die meisten Ehrenpunkte Silv 21959
Die meisten Arenapunkte Silv 1763
PvP Statistiken

Name Klasse Level Today HK Today CP Yest HK Yest CP Life HK Highest Rank Honor Points Arena Points
 Jäger
70
0 0 0 0 4295 Feldwebel 2846 746
 Priester
70
0 0 0 0 142 Nichts 1546 692
Bhijzzgaa
 Paladin
70
               
Blütenglanz
 Schurke
70
               
Calma
 Magier
70
               
Crashlike
 Krieger
70
               
Darkbulls
 Magier
70
               
Demerol
 Schurke
70
               
Deven
 Krieger
70
               
Eldoreth
 Magier
70
               
Elliryn
 Magier
70
               
Elopak
 Krieger
70
               
Exilom
 Paladin
70
               
Feurgisson
 Paladin
70
               
Game
 Schurke
70
               
Glungli
 Krieger
70
               
 Krieger
70
0 0 0 0 20968 Ritter der Allianz 592 0
 Hexenmeister
70
2 11 312 4997 56286 Rittmeister 12516 873
Jephraim
 Krieger
70
               
Kevian
 Krieger
70
               
Laactrice
 Magier
70
               
Lanthien
 Schurke
70
               
Licik
 Schurke
70
               
 Jäger
70
10 116 358 1392 14546 Kürassier 2814 0
Medy
 Krieger
70
               
 Magier
70
0 0 0 0 130 Gefreiter 439 0
Nightdragon
 Hexenmeister
70
               
Nuisance
 Schamane
70
               
Pandalf
 Krieger
70
               
Pandoria
 Paladin
70
               
Pongtung
 Magier
70
               
 Paladin
70
0 0 0 0 3563 Fähnrich 38 0
Ravenja
 Schurke
70
               
Ribbel
 Jäger
70
               
Sajaha
 Jäger
70
               
 Priester
70
0 0 0 0 5878 Leutnant 3051 0
Silberchen
 Priester
70
               
 Hexenmeister
70
38 189 178 2535 11250 Leutnant 21959 1763
 Magier
70
0 0 0 0 9 Nichts 20 0
 Jäger
70
0 0 0 0 1535 Fußknecht 7023 0
 Krieger
70
0 0 0 0 289 Fußknecht 623 0
Thundergnom
 Magier
70
               
Tifah
 Paladin
70
               
Venom
 Schurke
70
               
Wildschwein
 Krieger
70
               
Wilfried
 Krieger
70
               
Wishless
 Druide
70
               
 Hexenmeister
70
0 0 0 0 10650 Leutnant 6823 0
 Magier
70
0 0 0 0 33630 Ritter der Allianz 1834 0
Yori
 Druide
70
               
Zipfelmütze
 Krieger
70
               
Zwieback
 Jäger
70
               
Hérok
 Krieger
69
               
Yshtaar
 Druide
69
               
Droid
 Priester
68
               
Ephraim
 Paladin
68
               
Philomenatsh
 Magier
68
               
 Magier
68
0 0 0 0 235 Nichts 342 0
Tabetha
 Priester
68
               
Crazymaus
 Schurke
67
               
Isgahart
 Schurke
67
               
Myrtha
 Priester
67
               
 Magier
66
0 0 0 0 3481 Feldwebel 136 0
Gothfraidh
 Krieger
66
               
Xalevia
 Druide
66
               
Kamikatze
 Paladin
65
               
Bassus
 Druide
64
               
Leane
 Paladin
64
               
Washaki
 Magier
64
               
Dämonenblut
 Hexenmeister
63
               
Medie
 Hexenmeister
63
               
Zab
 Schurke
63
               
Centavo
 Paladin
62
               
Graham
 Schurke
62
               
Sylphinja
 Hexenmeister
62
               
Blutaxt
 Jäger
61
               
Jephtha
 Magier
61
               
Rincewind
 Magier
61
               
 Paladin
60
0 0 0 0 513 Fußknecht 150 0
Centaur
 Priester
60
               
Creeper
 Jäger
60
               
Dok
 Priester
60
               
Gloin
 Paladin
60
               
Idoron
 Paladin
60
               
Kalisto
 Krieger
60
               
Macam
 Schurke
60
               
Samuel
 Schurke
60
               
Sancar
 Priester
60
               
Markor
 Krieger
56
               
 Jäger
56
0 0 0 0 6 Nichts 0 0
Picu
 Hexenmeister
54
               
Nakuan
 Jäger
53
               
Goldlocke
 Krieger
52
               
Sayer
 Jäger
52
               
 Magier
50
0 0 0 0 418 Fußknecht 0 0
Wäschlomba
 Krieger
48
               
Tossi
 Magier
47
               
Aimiee
 Krieger
45
               
Elymias
 Hexenmeister
43
               
Nacina
 Paladin
41
               
Eldoren
 Hexenmeister
40
               
Pongi
 Krieger
40
               
 Priester
38
0 0 0 0 20 Gefreiter 0 0
Amanie
 Magier
36
               
Zingg
 Magier
30
               
Nicklasius
 Priester
29
               
Shelórfíndel
 Schurke
29
               
Bulingar
 Krieger
27
               
Bliblob
 Hexenmeister
26
               
Hogrux
 Magier
26
               
Alinda
 Schurke
25
               
Suran
 Jäger
25
               
Kevia
 Schamane
21
               
Darkfrost
 Priester
18
               
Jeanbaptiste
 Schurke
18
               
Calmalita
 Druide
15
               
Rautio
 Druide
15
               
Bloedel
 Priester
14
               
Atunah
 Schamane
12
               
Katattafisch
 Magier
12
               
 Jäger
2
0 0 0 0 0 0 0 0
Sponschbob
 Hexenmeister
2
               
 Schurke
1
0 0 0 0 0 0 0 0
Bänkiboy
 Krieger
1
               
Feurgibank
 Paladin
1
               
Gsafe
 Hexenmeister
1
               
Losraidbank
 Priester
1
               

Anleitung zur Aktualisierung
Empfehlung zur automatischen Aktualisierung:
  • Benutze den UniUploader
    (Du kannst dieses Programm von der WoW-Roster-Webseite herunterladen, schaue nach dem "UniUploader Installer" für die aktuellste Version)
Anleitung:
  1. Lade den Character Profiler herunter
  2. Extrahiere die Zip-Datei in ein eigenes Verzeichnis unter C:\Program Files\World of Warcraft\Interface\Addons\CharacterProfiler\
  3. Starte WoW
  4. Öffne einmal dein Bankschliessfach, deine Rucksäcke, deine Berufsseiten und deine Charakter-Übersicht
  5. Logge aus oder beende WoW (Siehe oben, falls das der UniUploader automatisch erledigen soll.)
  6. Gehe zur Update-Seite
  7. Wähle die Datei "CharacterProfiler.lua" aus
Optionale PvP Stats:
  1. Lade PvPLog herunter
  2. Auch in ein eigenes Addon-Verzeichnis entpacken
  3. Mache ein paar Duelle oder PvP-Kills
  4. Lade "PvPLog.lua" über die Update-Seite hoch


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.02 seconds with 18 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 `name`, `RankName` FROM `roster_players` ORDER BY `RankInfo` DESC LIMIT 0,1
SELECT `name`, `lifetimeRankName` FROM `roster_players` ORDER BY `lifetimeHighestRank`DESC, `lifetimeHK` DESC LIMIT 0 , 1
SELECT `name`, `lifetimeHK` FROM `roster_players` ORDER BY `lifetimeHK` DESC, `lifetimeHighestRank` DESC LIMIT 0 , 1
SELECT `name`, `honorpoints` FROM `roster_players` ORDER BY `honorpoints` DESC LIMIT 0 , 1
SELECT `name`, `arenapoints` FROM `roster_players` ORDER BY `arenapoints` DESC LIMIT 0 , 1
SELECT `guild`, COUNT(`guild`) AS countg FROM `roster_pvp2` WHERE `win` = '1' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC
SELECT `guild`, COUNT(`guild`) AS countg FROM `roster_pvp2` WHERE `win` = '0' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC
SELECT `name`, COUNT(`name`) AS countg FROM `roster_pvp2` WHERE `win` = '1' AND `enemy` = '1' GROUP BY `name` ORDER BY countg DESC
SELECT `name`, COUNT(`name`) AS countg FROM `roster_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 `roster_pvp2` pvp2 LEFT JOIN `roster_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 `roster_pvp2` pvp2 LEFT JOIN `roster_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 `roster_pvp2` pvp2 LEFT JOIN `roster_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 `roster_pvp2` pvp2 LEFT JOIN `roster_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`, '%d.%m. %k:%i' ) AS 'last_online', `players`.`race`, `players`.`RankName`, `players`.`RankInfo`, IF( `players`.`RankInfo` IS NULL OR `players`.`RankInfo` = '0', 1, 0 ) AS 'risnull', `players`.`exp`, `players`.`server`, `players`.`clientLocale` , `players`.`RankIcon`, `players`.`Rankexp`, `players`.`sessionHK`, `players`.`sessionCP`, `players`.`yesterdayHK`, `players`.`yesterdayContribution`, `players`.`lifetimeHK`, `players`.`lifetimeRankName`, `players`.`honorpoints`, `players`.`arenapoints` FROM `roster_members` AS members LEFT JOIN `roster_players` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '1' ORDER BY `members`.`level` DESC, `members`.`name` ASC