|
|||||||||||||
SQL Queries | ||
---|---|---|
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; SELECT * FROM `roster_guild` WHERE `guild_name` = 'Chevaliers' AND `server` = 'Sinstralis' SELECT a.*, b.*, c.guild_name FROM `roster_players` a, `roster_members` b, `roster_guild` c WHERE a.member_id = b.member_id AND a.name = 'Arthemys' AND a.server = 'Sinstralis' AND a.guild_id = c.guild_id SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Arthemys' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_slot` = 'Bag0' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_parent` = 'Bag0' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_slot` = 'Bag1' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_parent` = 'Bag1' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_slot` = 'Bag2' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_parent` = 'Bag2' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_slot` = 'Bag3' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_parent` = 'Bag3' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_slot` = 'Bag4' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_parent` = 'Bag4' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_slot` = 'Bag5' SELECT * FROM `roster_items` WHERE `member_id` = 25 AND `item_parent` = 'Bag5' |
||