|
||||||||||||||||||||
| Guild Info | ||
|---|---|---|
|
For recruit inquiries please direct the interested players to an officer or instruct them to fill out an application in the forums on our website: http://www.cruxdraconis.org
|
||
| SQL Queries | ||
|---|---|---|
|
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; SELECT * FROM `roster_guild` WHERE `guild_name` = 'Crux Draconis' AND `server` = 'Bloodhoof' SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Crux Draconis' AND `server` ='Bloodhoof' SELECT IF(`officer_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 |
||