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

Database Error
1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-19 , 30' at line 3
SQL:
SELECT *, DATE_FORMAT( `update_time`, '%d.%m. %k:%i' ) AS 'date' FROM `roster_memberlog` ORDER BY `update_time` DESC, `type` ASC LIMIT -19 , 30
File: memberlog.php
Line: 169
Backtrace (most recent call last):
  • File: /www/htdocs/w007e963/roster/lib/commonfunctions.lib.php
    • line 248
    • function called: backtrace
  • File: /www/htdocs/w007e963/roster/memberlog.php
    • line 169
    • function called: die_quietly
    • args: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-19 , 30' at line 3, Database Error, memberlog.php, 169, SELECT *, DATE_FORMAT( `update_time`, '%d.%m. %k:%i' ) AS 'date' FROM `roster_memberlog` ORDER BY `update_time` DESC, `type` ASC LIMIT -19 , 30

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.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 -19 , 30