|
|||||||||||||||||
| << < Mitglieder Log [270 - 281] of 281 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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
This page was created in 0.01 seconds with 6 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 *, DATE_FORMAT( `update_time`, '%d.%m. %k:%i' ) AS 'date' FROM `roster_memberlog` ORDER BY `update_time` DESC, `type` ASC SELECT *, DATE_FORMAT( `update_time`, '%d.%m. %k:%i' ) AS 'date' FROM `roster_memberlog` ORDER BY `update_time` DESC, `type` ASC LIMIT 270 , 30 |
||