Loading...   

  • Created By Uleat On: 08:23 PM December 13, 2015
  • Link

# should return two rows with `enabled` = 1 in both
SELECT `id`, `enabled` FROM `spawn2` WHERE `id` IN (59297,59298);

# should return null
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';

# should return four rows (`groupid`, `charid`, `name`, `ismerc`)
SHOW KEYS FROM `group_id` WHERE `Key_name` LIKE 'PRIMARY';

# should return one result
SELECT `command` FROM `command_settings` WHERE `command` LIKE 'bot';

# should return eight distinct results
SELECT DISTINCT `rule_name` FROM `rule_values` WHERE `rule_name` IN ('Bots:AAExpansion', 'Bots:CreationLimit', 'Bots:FinishBuffing', 'Bots:GroupBuffing', 'Bots:ManaRegen', 'Bots:QuestableSpawnLimit', 'Bots:QuestableSpells', 'Bots:SpawnLimit');

Raw Paste Data