PHP Errors addons/guildinfo/inc/update_hook.php Notice line 190: Undefined index: member Notice line 190: Undefined index: member Notice line 190: Undefined index: member Notice line 190: Undefined index: member Notice line 190: Undefined index: member Notice line 190: Undefined index: member Notice line 190: Undefined index: member addons/achievements/inc/update_hook.php Notice line 154: Undefined index: Achievements lib/dbal/mysql.php Roster Notice line 243: Database error. See query log for details SQL Queries Line Time Query lib/roster.php 150 0.0013 SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; 570 0.0007 SELECT * FROM `roster_addon` ORDER BY `basename`; lib/login.php 77 0.0032 SELECT * FROM `roster_account` ORDER BY `account_id` DESC; lib/functions.lib.php 1033 0.0035 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '2' ORDER BY `id` ASC; 1033 0.0017 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '3' ORDER BY `id` ASC; 1033 0.0011 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '4' ORDER BY `id` ASC; 1033 0.0022 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '5' ORDER BY `id` ASC; 1033 0.0026 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '6' ORDER BY `id` ASC; 1033 0.0013 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '9' ORDER BY `id` ASC; 1033 0.0005 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '2' ORDER BY `id` ASC; 1033 0.0007 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '3' ORDER BY `id` ASC; 1033 0.0005 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '4' ORDER BY `id` ASC; 1033 0.0004 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '5' ORDER BY `id` ASC; 1033 0.0011 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '6' ORDER BY `id` ASC; 1033 0.0005 SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '9' ORDER BY `id` ASC; addons/info/inc/update_hook.php 49 0.0005 SELECT * FROM `roster_addons_info_default`; 111 0.0007 DELETE `roster_addons_info_display` FROM `roster_addons_info_display` LEFT JOIN `roster_players` USING (`member_id`) WHERE `roster_players`.`member_id` IS NULL; 67 0.0002 SELECT `member_id` FROM `roster_addons_info_display` WHERE `member_id` = '7'; 49 0.0004 SELECT * FROM `roster_addons_info_default`; lib/update.lib.php 638 0.0008 SELECT `type`, COUNT(`rule_id`) FROM `roster_upload` WHERE (`type` = 0 OR `type` = 1) AND 'Pagans of Dawn' LIKE `name` AND 'Arathor' LIKE `server` AND 'EU' LIKE `region` GROUP BY `type` ORDER BY `type` DESC; 652 0.0003 SELECT `update_time` FROM `roster_guild` WHERE 'Pagans of Dawn' LIKE `guild_name` AND 'Arathor' LIKE `server` AND 'EU' LIKE `region`; 3437 0.0002 SELECT * FROM `roster_guild` WHERE `guild_name` = 'Pagans of Dawn' AND `server` = 'Arathor' AND `region` = 'EU'; 3536 0.0002 UPDATE `roster_guild` SET `guild_name` = 'Pagans of Dawn', `server` = 'Arathor', `region` = 'EU', `faction` = 'Alliance', `factionEn` = 'Alliance', `guild_motd` = 'Welcome to Vironsis and Hamrammr, our two latest recruits. Congratulations to Expectations for reaching lvl 85.', `guild_num_members` = '12', `guild_xp` = '3014839:21550000', `guild_xpcap` = '260250:7807500', `guild_level` = '4', `update_time` = '2011-11-22 19:12:43', `DBversion` = '3.1', `GPversion` = '1.0.0', `guild_info_text` = 'Welcome to the Pagans of Dawn, a very small and very elite social guild.\n\nAt the moment, we are pretty much dormant, just waiting for Cataclysm, although Kharaghiosis is aiming for Loremaster.\n\nIn the meantime, battle well.\nTom' WHERE `guild_id` = '1'; 3541 0.0006 UPDATE `roster_members` SET `active` = '0' WHERE `guild_id` = '1'; 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Greymouser' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Greymouser', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Paladin', `classid` = '2', `level` = '83', `note` = '', `guild_rank` = '1', `guild_title` = 'Officer', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '0', `last_online` = '2011-11-22 7:12:43' WHERE `member_id` = '1'; 3163 0.0002 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Marzipan' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Marzipan', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Death Knight', `classid` = '6', `level` = '85', `note` = '', `guild_rank` = '2', `guild_title` = 'Veteran', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '0', `last_online` = '2011-11-22 15:12:43' WHERE `member_id` = '2'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Blueface' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Blueface', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Warrior', `classid` = '1', `level` = '85', `note` = '', `guild_rank` = '2', `guild_title` = 'Veteran', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '0', `last_online` = '2011-11-22 13:12:43' WHERE `member_id` = '3'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Hamrammr' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Hamrammr', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Mage', `classid` = '8', `level` = '15', `note` = '', `guild_rank` = '2', `guild_title` = 'Veteran', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '0', `last_online` = '2011-11-4 4:12:43' WHERE `member_id` = '4'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Kharaghiosis' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Kharaghiosis', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Hunter', `classid` = '3', `level` = '85', `note` = '', `guild_rank` = '1', `guild_title` = 'Officer', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '0', `last_online` = '2011-11-20 20:12:43' WHERE `member_id` = '5'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Bethanie' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Bethanie', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Mage', `classid` = '8', `level` = '85', `note` = '', `guild_rank` = '2', `guild_title` = 'Veteran', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '0', `last_online` = '2011-11-22 7:12:43' WHERE `member_id` = '6'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Tomofinland' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Tomofinland', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Hunter', `classid` = '3', `level` = '85', `note` = '', `guild_rank` = '0', `guild_title` = 'Guild Master', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '1', `last_online` = '2011-11-22 19:12:43' WHERE `member_id` = '7'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Bleys' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Bleys', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Death Knight', `classid` = '6', `level` = '85', `note` = '', `guild_rank` = '1', `guild_title` = 'Officer', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '0', `last_online` = '2011-11-22 18:12:43' WHERE `member_id` = '10'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Vironsusi' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Vironsusi', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Druid', `classid` = '11', `level` = '15', `note` = '', `guild_rank` = '2', `guild_title` = 'Veteran', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '0', `last_online` = '2011-11-21 14:12:43' WHERE `member_id` = '9'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Expectations' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Expectations', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Druid', `classid` = '11', `level` = '85', `note` = '', `guild_rank` = '1', `guild_title` = 'Officer', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '0', `last_online` = '2011-11-22 7:12:43' WHERE `member_id` = '8'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Clonezone' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Clonezone', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Mage', `classid` = '8', `level` = '85', `note` = '', `guild_rank` = '5', `guild_title` = 'Banker', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '0', `last_online` = '2011-11-22 3:12:43' WHERE `member_id` = '11'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3576 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Menergy' AND `server` = 'Arathor' AND `region` = 'EU'; 3657 0.0002 UPDATE `roster_members` SET `name` = 'Menergy', `server` = 'Arathor', `region` = 'EU', `guild_id` = '1', `class` = 'Warrior', `classid` = '1', `level` = '85', `note` = '', `guild_rank` = '1', `guild_title` = 'Officer', `officer_note` = '', `zone` = 'Stormwind City', `status` = '', `active` = '1', `online` = '0', `last_online` = '2011-11-22 3:12:43' WHERE `member_id` = '12'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3346 0.0002 SELECT * FROM `roster_members` WHERE `guild_id` = '1' AND `active` = '0'; 3163 0.0001 DELETE FROM `roster_guild` WHERE `guild_id` NOT IN (SELECT DISTINCT `guild_id` FROM `roster_members`); 3437 0.0002 SELECT * FROM `roster_guild` WHERE `guild_name` = 'Pagans of Dawn' AND `server` = 'Arathor' AND `region` = 'EU'; 467 0.0002 SELECT `guild_id`, `member_id` FROM `roster_members` WHERE `name` = 'Tomofinland' AND `server` = 'Arathor' AND `region` = 'EU'; 516 0.0002 SELECT `guild_id`, `member_id` FROM `roster_members` WHERE `name` = 'Tomofinland' AND `server` = 'Arathor' AND `region` = 'EU'; 522 0.0002 SELECT `dateupdatedutc` FROM `roster_players` WHERE 'Tomofinland' LIKE `name` AND 'Arathor' LIKE `server` AND 'EU' LIKE `region`; 3910 0.0002 SELECT `member_id` FROM `roster_members` WHERE `name` = 'Tomofinland' AND `server` = 'Arathor' AND `region` = 'EU'; 3932 0.0001 UPDATE `roster_members` SET `level` = '85' WHERE `member_id` = '7' LIMIT 1; 3940 0.0001 SELECT `member_id` FROM `roster_players` WHERE `member_id` = '7'; 4252 0.0005 UPDATE `roster_players` SET `name` = 'Tomofinland', `guild_id` = '1', `server` = 'Arathor', `region` = 'EU', `level` = '85', `crit` = '17.35', `stat_int` = '97', `stat_int_c` = '313', `stat_int_b` = '216', `stat_int_d` = '0', `stat_agl` = '212', `stat_agl_c` = '3388', `stat_agl_b` = '3176', `stat_agl_d` = '0', `stat_sta` = '159', `stat_sta_c` = '5254', `stat_sta_b` = '5095', `stat_sta_d` = '0', `stat_str` = '76', `stat_str_c` = '91', `stat_str_b` = '15', `stat_str_d` = '0', `stat_spr` = '105', `stat_spr_c` = '120', `stat_spr_b` = '15', `stat_spr_d` = '0', `dodge` = '2.25', `parry` = '5.00', `block` = '0', `mitigation` = '34.50900595372673', `stat_armor` = '13437', `stat_armor_c` = '13737', `stat_armor_b` = '300', `stat_armor_d` = '0', `stat_def` = '400', `stat_def_c` = '400', `stat_def_b` = '0', `stat_def_d` = '0', `stat_block` = '0', `stat_block_c` = '0', `stat_block_b` = '0', `stat_block_d` = '0', `stat_parry` = '0', `stat_parry_c` = '0', `stat_parry_b` = '0', `stat_parry_d` = '0', `stat_defr` = '0', `stat_defr_c` = '0', `stat_defr_b` = '0', `stat_defr_d` = '0', `stat_dodge` = '50', `stat_dodge_c` = '50', `stat_dodge_b` = '0', `stat_dodge_d` = '0', `stat_res_melee` = '171', `res_holy` = '0', `res_holy_c` = '0', `res_holy_b` = '0', `res_holy_d` = '0', `res_frost` = '0', `res_frost_c` = '0', `res_frost_b` = '0', `res_frost_d` = '0', `res_arcane` = '0', `res_arcane_c` = '0', `res_arcane_b` = '0', `res_arcane_d` = '0', `res_fire` = '0', `res_fire_c` = '0', `res_fire_b` = '0', `res_fire_d` = '0', `res_shadow` = '0', `res_shadow_c` = '0', `res_shadow_b` = '0', `res_shadow_d` = '0', `res_nature` = '0', `res_nature_c` = '85', `res_nature_b` = '85', `res_nature_d` = '0', `melee_power` = '4536', `melee_power_c` = '4648', `melee_power_b` = '112', `melee_power_d` = '0', `melee_hit` = '376', `melee_hit_c` = '379', `melee_hit_b` = '3', `melee_hit_d` = '0', `melee_crit` = '1516', `melee_crit_c` = '1524', `melee_crit_b` = '8', `melee_crit_d` = '0', `melee_haste` = '638', `melee_haste_c` = '643', `melee_haste_b` = '5', `melee_haste_d` = '0', `melee_expertise` = '0', `melee_expertise_c` = '0', `melee_expertise_b` = '0', `melee_expertise_d` = '0', `melee_crit_chance` = '17.35', `melee_power_dps` = '332.0', `melee_mhand_speed` = '3.14', `melee_mhand_dps` = '862.273', `melee_mhand_skill` = '236', `melee_mhand_mindam` = '2387.41', `melee_mhand_maxdam` = '3032.836', `melee_mhand_rating` = '236', `melee_mhand_rating_c` = '236', `melee_mhand_rating_b` = '0', `melee_mhand_rating_d` = '0', `melee_ohand_speed` = '0', `melee_ohand_dps` = '0', `melee_ohand_skill` = '0', `melee_ohand_mindam` = '0', `melee_ohand_maxdam` = '0', `melee_ohand_rating` = '0', `melee_ohand_rating_c` = '0', `melee_ohand_rating_b` = '0', `melee_ohand_rating_d` = '0', `ranged_power` = '8658', `ranged_power_c` = '12020', `ranged_power_b` = '3362', `ranged_power_d` = '0', `ranged_hit` = '376', `ranged_hit_c` = '379', `ranged_hit_b` = '3', `ranged_hit_d` = '0', `ranged_crit` = '1516', `ranged_crit_c` = '1524', `ranged_crit_b` = '8', `ranged_crit_d` = '0', `ranged_haste` = '726', `ranged_haste_c` = '732', `ranged_haste_b` = '6', `ranged_haste_d` = '0', `ranged_crit_chance` = '17.35', `ranged_power_dps` = '618.4', `ranged_speed` = '2.65', `ranged_dps` = '1424.1', `ranged_skill` = '1', `ranged_mindam` = '3362.897', `ranged_maxdam` = '4185', `ranged_rating` = '1', `ranged_rating_c` = '1', `ranged_rating_b` = '0', `ranged_rating_d` = '0', `ranged_range_tooltip` = '3362 - 4185', `ranged_power_tooltip` = 'Increases damage with ranged weapons by 618.4 damage per second.', `spell_hit` = '376', `spell_hit_c` = '380', `spell_hit_b` = '4', `spell_hit_d` = '0', `spell_crit` = '1516', `spell_crit_c` = '1524', `spell_crit_b` = '8', `spell_crit_d` = '0', `spell_haste` = '638', `spell_haste_c` = '643', `spell_haste_b` = '5', `spell_haste_d` = '0', `spell_crit_chance` = '8.46', `mana_regen` = '0', `mana_regen_cast` = '0', `spell_penetration` = '0', `spell_damage` = '303', `spell_healing` = '303', `spell_crit_chance_holy` = '8.46', `spell_crit_chance_frost` = '8.46', `spell_crit_chance_arcane` = '8.46', `spell_crit_chance_fire` = '8.46', `spell_crit_chance_shadow` = '8.46', `spell_crit_chance_nature` = '8.46', `spell_damage_holy` = '303', `spell_damage_frost` = '303', `spell_damage_arcane` = '303', `spell_damage_fire` = '303', `spell_damage_shadow` = '303', `spell_damage_nature` = '303', `talent_points` = '0', `money_s` = '57', `money_c` = '97', `money_g` = '9291', `exp` = '2079:12267000:0', `race` = 'Night Elf', `raceEn` = 'NightElf', `class` = 'Hunter', `classid` = '3', `classEn` = 'HUNTER', `health` = '112333', `mana` = '110', `power` = 'Focus', `sex` = 'Male', `sexid` = '0', `hearth` = 'Dwarven District', `dateupdatedutc` = '2011-11-22 19:12:28', `DBversion` = '3.1', `CPversion` = '1.0.0', `timeplayed` = '0', `timelevelplayed` = '0', `clientLocale` = 'enUS' WHERE `member_id` = '7'; 1823 0.0026 DELETE FROM `roster_items` WHERE `member_id` = '7' AND `item_parent` = 'equip'; 1173 0.0003 REPLACE INTO `roster_gems` SET `gem_id` = '52168', `gem_name` = 'Perfect Rigid Zephyrite', `gem_color` = 'blue', `gem_tooltip` = 'Perfect Rigid Zephyrite\nRequires Item Level: 285\n+35 Hit Rating |cfffffe8b(+0.29%)|r\n\\\"Matches a Blue Socket.\\\"\n ', `gem_bonus` = '+35 Hit Rating (+0.29%)', `gem_socketid` = '3949', `gem_texture` = 'inv_misc_cutgemperfect3', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Belt of the Stargazer', `item_parent` = 'equip', `item_slot` = 'Waist', `item_color` = '0070dd', `item_id` = '62439:0:3949:0:0:0:0:0:85:0', `item_texture` = 'inv_belt_mail_dungeonmail_c_04', `item_quantity` = '1', `item_tooltip` = 'Belt of the Stargazer\nSoulbound\nWaist Mail\n1251 Armor\n+179 Agility |cfffffe8b(+0.58% Crit)|r\n+298 Stamina\n|cffffffff+35 Hit Rating |cfffffe8b(+0.29%)|cffffffff|r\nSocket Bonus: +10 Critical Strike Rating |cfffffe8b(+0.06%)|r\nDurability 45 / 45\nRequires Level 83\n|cffffd100ItemLevel: 333|r\nRequires Ramkahen - Honored\nEquip: Increases your haste rating by 133 |cfffffe8b(+1.04%)|r.\nEquip: Increases your critical strike rating by 113 |cfffffe8b(+0.63%)|r.\n\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A2\n \n|cffffffffStat Summary|r\nHealth 4797.8 (|cffffffff+0.0|r)\nRanged Attack Power 469.9 (|cffffffff+0.0|r)\nRanged Hit Chance 0.29% (|cffffffff+0.00%|r)\nRanged Crit Chance 1.26% (|cffffffff+0.00%|r)\nRanged Haste 1.04% (|cffffffff+0.00%|r)', `item_level` = '333', `item_type` = 'Armor', `item_subtype` = 'Mail', `item_rarity` = '3', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Worldbinder Signet', `item_parent` = 'equip', `item_slot` = 'Finger0', `item_color` = '0070dd', `item_id` = '61474:0:0:0:0:0:0:1877294976:85:0', `item_texture` = 'inv_misc_vinering', `item_quantity` = '1', `item_tooltip` = 'Worldbinder Signet\nSoulbound\nFinger\n+130 Agility |cfffffe8b(+0.42% Crit)|r\n+195 Stamina\n|cffffd100ItemLevel: 318|r\nEquip: Increases your critical strike rating by 72 |cfffffe8b(+0.40%)|r.\nEquip: Increases your mastery rating by 95 |cfffffe8b(+0.53)|r. (Master of Beasts)\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFF69CCF0Bethanie |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A3\n \n|cffffffffStat Summary|r\nHealth 3139.5 (|cffffffff+0.0|r|||cffff2020-1706.6|r)\nRanged Attack Power 341.3 (|cffffffff+0.0|r|||cffff2020-186.4|r)\nRanged Hit Chance 0.00% (|cffffffff+0.00%|r|||cffff2020-1.01%|r)\nRanged Crit Chance 0.82% (|cffffffff+0.00%|r|||cffff2020-0.62%|r)\nMastery 0.5 (|cffffffff+0.0|r|||cff20ff20+0.5|r)', `item_level` = '318', `item_type` = 'Armor', `item_subtype` = 'Miscellaneous', `item_rarity` = '3', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Nightweaver\'s Amulet', `item_parent` = 'equip', `item_slot` = 'Neck', `item_color` = 'a335ee', `item_id` = '70106:0:0:0:0:0:0:0:85:0', `item_texture` = 'inv_neck_hyjaldaily_01', `item_quantity` = '1', `item_tooltip` = 'Nightweaver\'s Amulet\nSoulbound\nNeck\n+301 Stamina\n+201 Intellect\nRequires Level 85\n|cffffd100ItemLevel: 365|r\nEquip: Increases your haste rating by 102 |cfffffe8b(+0.80%)|r.\nEquip: Increases your mastery rating by 153 |cfffffe8b(+0.85)|r. (Master of Beasts)\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFF69CCF0Bethanie |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A3\n \n|cffffffffStat Summary|r\nHealth 4846.1 (|cffffffff+0.0|r)\nRanged Haste 0.80% (|cffffffff+0.00%|r)\nMastery 0.9 (|cffffffff+0.0|r)', `item_level` = '365', `item_type` = 'Armor', `item_subtype` = 'Miscellaneous', `item_rarity` = '4', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Schnottz\'s Medallion of Command', `item_parent` = 'equip', `item_slot` = 'Trinket0', `item_color` = '0070dd', `item_id` = '65805:0:0:0:0:0:0:1787379712:85:0', `item_texture` = 'inv_jewelry_amulet_01', `item_quantity` = '1', `item_tooltip` = 'Schnottz\'s Medallion of Command\nSoulbound\nTrinket\n+234 Agility |cfffffe8b(+0.76% Crit)|r\n|cffffd100ItemLevel: 325|r\nEquip: Your melee attacks have a chance to grant 918 mastery rating |cfffffe8b(+5.12)|r for 20 sec.\n \n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A4\n \n|cffffffffStat Summary|r\nRanged Attack Power 614.3 (|cffffffff+0.0|r|||cff20ff20+175.9|r)\nRanged Crit Chance 0.76% (|cffffffff+0.00%|r|||cff20ff20+0.22%|r)', `item_level` = '325', `item_type` = 'Armor', `item_subtype` = 'Miscellaneous', `item_rarity` = '3', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Mantle of Doubt', `item_parent` = 'equip', `item_slot` = 'Back', `item_color` = 'a335ee', `item_id` = '71268:4087:0:0:0:0:0:1975436800:85:0', `item_texture` = 'inv_cape_firelands_fireset_d_01', `item_quantity` = '1', `item_tooltip` = 'Mantle of Doubt\nSoulbound\nBack\n647 Armor\n+201 Agility |cfffffe8b(+0.65% Crit)|r\n+301 Stamina\n+50 Critical Strike Rating |cfffffe8b(+0.28%)|r\n|cffffd100ItemLevel: 365|r\nEquip: Increases your hit rating by 134 |cfffffe8b(+1.12%)|r.\nEquip: Increases your mastery rating by 134 |cfffffe8b(+0.75)|r. (Master of Beasts)\n \n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A3\n \n|cffffffffStat Summary|r\nHealth 4846.1 (|cffffffff+0.0|r)\nRanged Attack Power 527.6 (|cffffffff+0.0|r)\nRanged Hit Chance 1.12% (|cffffffff+0.00%|r)\nRanged Crit Chance 0.65% (|cffffffff+0.00%|r)\nMastery 0.7 (|cffffffff+0.0|r)', `item_level` = '365', `item_type` = 'Armor', `item_subtype` = 'Cloth', `item_rarity` = '4', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Blue Workman\'s Shirt', `item_parent` = 'equip', `item_slot` = 'Shirt', `item_color` = 'ffffff', `item_id` = '41253:0:0:0:0:0:0:72394872:85:0', `item_texture` = 'inv_shirt_13', `item_quantity` = '1', `item_tooltip` = 'Blue Workman\'s Shirt\nShirt\n|cffffd100ItemLevel: 1|r\n|cff00ff00|r\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cFFFFD700Source: |cFF00FF9ATailoring, 400', `item_level` = '1', `item_type` = 'Armor', `item_subtype` = 'Miscellaneous', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Gauntlets of the Obelisk', `item_parent` = 'equip', `item_slot` = 'Hands', `item_color` = '1eff00', `item_id` = '65849:3234:0:0:0:0:0:63442312:85:0', `item_texture` = 'inv_gauntlets_124', `item_quantity` = '1', `item_tooltip` = 'Gauntlets of the Obelisk\nSoulbound\nHands Mail\n1297 Armor\n+164 Agility |cfffffe8b(+0.53% Crit)|r\n+245 Stamina\n+20 Hit Rating |cfffffe8b(+0.17%)|r\nDurability 40 / 40\n|cffffd100ItemLevel: 312|r\nEquip: Increases your critical strike rating by 101 |cfffffe8b(+0.56%)|r.\nEquip: Increases your haste rating by 114 |cfffffe8b(+0.89%)|r.\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A2\n \n|cffffffffStat Summary|r\nHealth 3944.5 (|cffffffff+0.0|r)\nRanged Attack Power 430.5 (|cffffffff+0.0|r)\nRanged Crit Chance 1.09% (|cffffffff+0.00%|r)\nRanged Haste 0.89% (|cffffffff+0.00%|r)', `item_level` = '312', `item_type` = 'Armor', `item_subtype` = 'Mail', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Brewtaster Bracers', `item_parent` = 'equip', `item_slot` = 'Wrist', `item_color` = '1eff00', `item_id` = '63848:4086:0:0:0:0:0:1405024256:85:0', `item_texture` = 'inv_bracer_81', `item_quantity` = '1', `item_tooltip` = 'Brewtaster Bracers\nSoulbound\nWrist Mail\n926 Armor\n+130 Agility |cfffffe8b(+0.42% Crit)|r\n+195 Stamina\n+50 Dodge Rating |cfffffe8b(+0.26%)|r\nDurability 40 / 40\n|cffffd100ItemLevel: 318|r\nEquip: Increases your hit rating by 66 |cfffffe8b(+0.55%)|r.\nEquip: Increases your critical strike rating by 99 |cfffffe8b(+0.55%)|r.\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cffffffffStat Summary|r\nHealth 3139.5 (|cffffffff+0.0|r)\nRanged Attack Power 341.3 (|cffffffff+0.0|r)\nRanged Hit Chance 0.55% (|cffffffff+0.00%|r)\nRanged Crit Chance 0.97% (|cffffffff+0.00%|r)', `item_level` = '318', `item_type` = 'Armor', `item_subtype` = 'Mail', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0008 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Gear Detector', `item_parent` = 'equip', `item_slot` = 'Trinket1', `item_color` = '1eff00', `item_id` = '61462:0:0:0:0:0:0:989334336:85:0', `item_texture` = 'inv_gizmo_08', `item_quantity` = '1', `item_tooltip` = 'Gear Detector\nSoulbound\nTrinket\n+167 Agility |cfffffe8b(+0.54% Crit)|r\n|cffffd100ItemLevel: 289|r\nEquip: Your melee and ranged critical strikes have a chance to grant 1002 haste rating |cfffffe8b(+7.82%)|r for 20 sec.\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A2\n \n|cffffffffStat Summary|r\nRanged Attack Power 438.4 (|cffff2020-175.9|r|||cffffffff+0.0|r)\nRanged Crit Chance 0.54% (|cffff2020-0.22%|r|||cffffffff+0.00%|r)', `item_level` = '289', `item_type` = 'Armor', `item_subtype` = 'Miscellaneous', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0008 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Aeronaut\'s Helm', `item_parent` = 'equip', `item_slot` = 'Head', `item_color` = '1eff00', `item_id` = '65881:3817:0:0:0:0:0:1273142656:85:0', `item_texture` = 'inv_helmet_191', `item_quantity` = '1', `item_tooltip` = 'Aeronaut\'s Helm\nSoulbound\nHead Mail\n1686 Armor\n+220 Agility |cfffffe8b(+0.71% Crit)|r\n+331 Stamina\n+50 Attack Power and +20 Critical Strike Rating |cfffffe8b(+0.11%)|r\nDurability 70 / 70\n|cffffd100ItemLevel: 312|r\nEquip: Increases your critical strike rating by 136 |cfffffe8b(+0.76%)|r.\nEquip: Increases your mastery rating by 153 |cfffffe8b(+0.85)|r. (Master of Beasts)\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cffffffffStat Summary|r\nHealth 5329.1 (|cffffffff+0.0|r)\nRanged Attack Power 577.5 (|cffffffff+0.0|r)\nRanged Crit Chance 1.47% (|cffffffff+0.00%|r)\nMastery 0.9 (|cffffffff+0.0|r)', `item_level` = '312', `item_type` = 'Armor', `item_subtype` = 'Mail', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0008 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Matoclaw\'s Band', `item_parent` = 'equip', `item_slot` = 'Finger1', `item_color` = 'a335ee', `item_id` = '70105:0:0:0:0:0:0:0:85:0', `item_texture` = 'inv_jewelry_ring_13', `item_quantity` = '1', `item_tooltip` = 'Matoclaw\'s Band\nSoulbound\nUnique-Equipped\nFinger\n+201 Agility |cfffffe8b(+0.65% Crit)|r\n+301 Stamina\nRequires Level 85\n|cffffd100ItemLevel: 365|r\nEquip: Increases your hit rating by 121 |cfffffe8b(+1.01%)|r.\nEquip: Increases your critical strike rating by 142 |cfffffe8b(+0.79%)|r.\n \n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A4\n \n|cffffffffStat Summary|r\nHealth 4846.1 (|cff20ff20+1706.6|r|||cffffffff+0.0|r)\nRanged Attack Power 527.6 (|cff20ff20+186.4|r|||cffffffff+0.0|r)\nRanged Hit Chance 1.01% (|cff20ff20+1.01%|r|||cffffffff+0.00%|r)\nRanged Crit Chance 1.44% (|cff20ff20+0.62%|r|||cffffffff+0.00%|r)\nMastery 0.0 (|cffff2020-0.5|r|||cffffffff+0.0|r)', `item_level` = '365', `item_type` = 'Armor', `item_subtype` = 'Miscellaneous', `item_rarity` = '4', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Bloodthirsty Dragonscale Chest', `item_parent` = 'equip', `item_slot` = 'Chest', `item_color` = '0070dd', `item_id` = '70039:4063:0:0:0:0:0:910960128:85:0', `item_texture` = 'inv_chest_mail_dungeonmail_c_04', `item_quantity` = '1', `item_tooltip` = 'Bloodthirsty Dragonscale Chest\nSoulbound\nChest Mail\n2424 Armor\n+338 Agility |cfffffe8b(+1.09% Crit)|r\n+507 Stamina\n+15 All Stats\nDurability 135 / 135\nRequires Level 85\n|cffffd100ItemLevel: 358|r\nEquip: Increases your critical strike rating by 257 |cfffffe8b(+1.43%)|r.\nEquip: Increases your resilience rating by 171 |cfffffe8b(-2.15%)|r.\n \nBloodthirsty Dragonscale (1/8)\n Bloodthirsty Dragonscale Belt\n Bloodthirsty Dragonscale Boots\n Bloodthirsty Dragonscale Bracers\n Bloodthirsty Dragonscale Chest\n Bloodthirsty Dragonscale Gloves\n Bloodthirsty Dragonscale Helm\n Bloodthirsty Dragonscale Legs\n Bloodthirsty Dragonscale Shoulders\n \n(2) Set: +400 resilience rating |cfffffe8b(-4.85%)|r.\n|cff00ff00|r\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cFFFFD700Source: |cFF00FF9ALeatherworking, 525\n \n|cffffffffStat Summary|r\nHealth 8162.7 (|cffffffff+0.0|r)\nRanged Attack Power 887.3 (|cffffffff+0.0|r)\nRanged Crit Chance 2.53% (|cffffffff+0.00%|r)\nResilience 171 (|cffffffff+0|r)', `item_level` = '358', `item_type` = 'Armor', `item_subtype` = 'Mail', `item_rarity` = '3', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Renowned Guild Tabard', `item_parent` = 'equip', `item_slot` = 'Tabard', `item_color` = 'a335ee', `item_id` = '69210:0:0:0:0:0:0:0:85:0', `item_texture` = 'inv_epicguildtabard', `item_quantity` = '1', `item_tooltip` = 'Renowned Guild Tabard\nBattle.net Account Bound\nTabard\n|cffffd100ItemLevel: 1|r\nEquip: You champion the causes of your guild. All guild reputation gains are increased by 100%.\n \n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFF69CCF0Bethanie |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A5', `item_level` = '1', `item_type` = 'Armor', `item_subtype` = 'Miscellaneous', `item_rarity` = '4', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Volatile Thunderstick', `item_parent` = 'equip', `item_slot` = 'Ranged', `item_color` = '0070dd', `item_id` = '59599:4177:0:0:0:0:0:1616355456:85:0', `item_texture` = 'inv_weapon_rifle_43', `item_quantity` = '1', `item_tooltip` = 'Volatile Thunderstick\nSoulbound\nRanged Gun\n958 - 1781 Damage Speed 2.80\n(489.3 damage per second)\n+84 Agility |cfffffe8b(+0.27% Crit)|r\n+126 Stamina\n+88 Ranged Haste Rating |cfffffe8b(+0.69%)|r\nDurability 75 / 75\nRequires Level 83\n|cffffd100ItemLevel: 333|r\nEquip: Increases your mastery rating by 56 |cfffffe8b(+0.31)|r. (Master of Beasts)\nEquip: Increases your critical strike rating by 56 |cfffffe8b(+0.31%)|r.\n|cff00ff00|r\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cFFFFD700Source: |cFF00FF9AEngineering, 495\n \n|cffffffffStat Summary|r\nHealth 2028.6 (|cffffffff+0.0|r)\nRanged Attack Power 220.5 (|cffffffff+0.0|r)\nRanged Crit Chance 0.58% (|cffffffff+0.00%|r)\nMastery 0.3 (|cffffffff+0.0|r)', `item_level` = '333', `item_type` = 'Weapon', `item_subtype` = 'Guns', `item_rarity` = '3', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Staff of Draconic Pacification', `item_parent` = 'equip', `item_slot` = 'MainHand', `item_color` = '0070dd', `item_id` = '63808:0:0:0:0:0:0:2030011008:85:0', `item_texture` = 'inv_staff_116', `item_quantity` = '1', `item_tooltip` = 'Staff of Draconic Pacification\nSoulbound\nTwo-Hand Staff\n1291 - 1937 Damage Speed 3.30\n(489.2 damage per second)\n+268 Agility |cfffffe8b(+0.87% Crit)|r\n+402 Stamina\nDurability 100 / 100\n|cffffd100ItemLevel: 333|r\nEquip: Increases your haste rating by 165 |cfffffe8b(+1.29%)|r.\nEquip: Increases your mastery rating by 186 |cfffffe8b(+1.04)|r. (Master of Beasts)\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cffffffffStat Summary|r\nHealth 6472.2 (|cffffffff+0.0|r)\nRanged Attack Power 703.5 (|cffffffff+0.0|r)\nRanged Crit Chance 0.87% (|cffffffff+0.00%|r)\nRanged Haste 1.29% (|cffffffff+0.00%|r)\nMastery 1.0 (|cffffffff+0.0|r)', `item_level` = '333', `item_type` = 'Weapon', `item_subtype` = 'Staves', `item_rarity` = '3', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Gryphon-Grip Leggings', `item_parent` = 'equip', `item_slot` = 'Legs', `item_color` = '0070dd', `item_id` = '63832:0:0:0:0:0:0:2114460288:85:0', `item_texture` = 'inv_pants_mail_dungeonmail_c_03', `item_quantity` = '1', `item_tooltip` = 'Gryphon-Grip Leggings\nSoulbound\nLegs Mail\n1946 Armor\n+268 Agility |cfffffe8b(+0.87% Crit)|r\n+402 Stamina\nDurability 100 / 100\n|cffffd100ItemLevel: 333|r\nEquip: Increases your critical strike rating by 191 |cfffffe8b(+1.07%)|r.\nEquip: Increases your mastery rating by 157 |cfffffe8b(+0.88)|r. (Master of Beasts)\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cffffffffStat Summary|r\nHealth 6472.2 (|cffffffff+0.0|r)\nRanged Attack Power 703.5 (|cffffffff+0.0|r)\nRanged Crit Chance 1.93% (|cffffffff+0.00%|r)\nMastery 0.9 (|cffffffff+0.0|r)', `item_level` = '333', `item_type` = 'Armor', `item_subtype` = 'Mail', `item_rarity` = '3', `locale` = 'enUS'; 1145 0.0007 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Shoulderpads of Reconstruction', `item_parent` = 'equip', `item_slot` = 'Shoulder', `item_color` = '0070dd', `item_id` = '61395:3808:0:0:0:0:0:1609187328:85:0', `item_texture` = 'inv_shoulder_mail_dungeonmail_c_03', `item_quantity` = '1', `item_tooltip` = 'Shoulderpads of Reconstruction\nSoulbound\nShoulder Mail\n1587 Armor\n+173 Agility |cfffffe8b(+0.56% Crit)|r\n+260 Stamina\n+40 Attack Power and +15 Crit Rating |cfffffe8b(+0.08%)|r\nDurability 80 / 80\n|cffffd100ItemLevel: 318|r\nEquip: Increases your haste rating by 124 |cfffffe8b(+0.97%)|r.\nEquip: Increases your mastery rating by 101 |cfffffe8b(+0.56)|r. (Master of Beasts)\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cffffffffStat Summary|r\nHealth 4186 (|cffffffff+0|r)\nRanged Attack Power 454.1 (|cffffffff+0.0|r)\nRanged Crit Chance 0.56% (|cffffffff+0.00%|r)\nRanged Haste 0.97% (|cffffffff+0.00%|r)\nMastery 0.6 (|cffffffff+0.0|r)', `item_level` = '318', `item_type` = 'Armor', `item_subtype` = 'Mail', `item_rarity` = '3', `locale` = 'enUS'; 1173 0.0003 REPLACE INTO `roster_gems` SET `gem_id` = '52204', `gem_name` = 'Adept Ember Topaz', `gem_color` = 'orange', `gem_tooltip` = 'Adept Ember Topaz\nRequires Item Level: 285\n+20 Agility |cfffffe8b(+0.06% Crit)|r and +20 Mastery Rating |cfffffe8b(+0.11)|r\n\\\"Matches a Red or Yellow Socket.\\\"\n \n \n|cFFFFD700Source: |cFF00FF9AJewelcrafting, 465', `gem_bonus` = '+20 Agility (+0.06% Crit) and +20 Mastery Rating (+0.11)', `gem_socketid` = '4008', `gem_texture` = 'inv_misc_cutgemsuperior4', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Moccasins of Verdurous Glooms', `item_parent` = 'equip', `item_slot` = 'Feet', `item_color` = 'a335ee', `item_id` = '58199:0:4008:0:0:0:0:0:85:0', `item_texture` = 'inv_boots_mail_raidhunter_i_01', `item_quantity` = '1', `item_tooltip` = 'Moccasins of Verdurous Glooms\nSoulbound\nFeet Mail\n1673 Armor\n+233 Agility |cfffffe8b(+0.75% Crit)|r\n+380 Stamina\n|cffffffff+20 Agility |cfffffe8b(+0.06% Crit)|cffffffff and +20 Mastery Rating |cfffffe8b(+0.11)|cffffffff|r\nSocket Bonus: +10 Mastery Rating |cfffffe8b(+0.06)|r\nDurability 75 / 75\nRequires Level 85\n|cffffd100ItemLevel: 359|r\nEquip: Increases your critical strike rating by 149 |cfffffe8b(+0.83%)|r.\nEquip: Increases your mastery rating by 169 |cfffffe8b(+0.94)|r. (Master of Beasts)\n\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFEquipped: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cFFFFD700Source: |cFF00FF9AJustice Points, 1650x\n \n|cffffffffStat Summary|r\nHealth 6118.0 (|cffffffff+0.0|r)\nRanged Attack Power 664.1 (|cffffffff+0.0|r)\nRanged Crit Chance 1.65% (|cffffffff+0.00%|r)\nMastery 1.1 (|cffffffff+0.0|r)', `item_level` = '359', `item_type` = 'Armor', `item_subtype` = 'Mail', `item_rarity` = '4', `locale` = 'enUS'; 1939 0.0086 DELETE FROM `roster_items` WHERE `member_id` = '7' AND UPPER(`item_parent`) LIKE 'BANK%'; 1946 0.0011 DELETE FROM `roster_items` WHERE `member_id` = '7' AND `item_parent` = 'bags' AND UPPER(`item_slot`) LIKE 'BANK%'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Emerald Bag', `item_parent` = 'bags', `item_slot` = 'Bank Bag5', `item_color` = '0070dd', `item_id` = '45773:0:0:0:0:0:0:2073661568:85:0', `item_texture` = 'inv_misc_bag_18', `item_quantity` = '32', `item_tooltip` = 'Emerald Bag\nSoulbound\n32 Slot Herb Bag\n|cff00ff00|r\n \n \n|cFFFFD700Source: |cFF00FF9ATailoring, 435', `item_level` = '', `item_type` = '', `item_subtype` = '', `item_rarity` = '', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Cenarion Herb Bag', `item_parent` = 'bags', `item_slot` = 'Bank Bag4', `item_color` = '1eff00', `item_id` = '22251:0:0:0:0:0:0:1239835802:85:0', `item_texture` = 'inv_misc_bag_cenarionherbbag', `item_quantity` = '20', `item_tooltip` = 'Cenarion Herb Bag\nSoulbound\n20 Slot Herb Bag\n|cff00ff00|r\n \n \n|cFFFFD700Source: |cFF00FF9ATailoring, 275', `item_level` = '', `item_type` = '', `item_subtype` = '', `item_rarity` = '', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Mana Thistle', `item_parent` = 'Bank Bag4', `item_slot` = '5', `item_color` = 'ffffff', `item_id` = '22793:0:0:0:0:0:0:982902944:85:0', `item_texture` = 'inv_misc_herb_manathistle', `item_quantity` = '20', `item_tooltip` = 'Mana Thistle\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F008|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A8|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0063|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A63|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A71', `item_level` = '70', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Mana Thistle', `item_parent` = 'Bank Bag4', `item_slot` = '6', `item_color` = 'ffffff', `item_id` = '22793:0:0:0:0:0:0:583744332:85:0', `item_texture` = 'inv_misc_herb_manathistle', `item_quantity` = '20', `item_tooltip` = 'Mana Thistle\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F008|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A8|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0063|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A63|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A71', `item_level` = '70', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0007 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Mana Thistle', `item_parent` = 'Bank Bag4', `item_slot` = '7', `item_color` = 'ffffff', `item_id` = '22793:0:0:0:0:0:0:502588384:85:0', `item_texture` = 'inv_misc_herb_manathistle', `item_quantity` = '20', `item_tooltip` = 'Mana Thistle\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F008|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A8|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0063|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A63|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A71', `item_level` = '70', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Mana Thistle', `item_parent` = 'Bank Bag4', `item_slot` = '8', `item_color` = 'ffffff', `item_id` = '22793:0:0:0:0:0:0:-2031535104:85:0', `item_texture` = 'inv_misc_herb_manathistle', `item_quantity` = '3', `item_tooltip` = 'Mana Thistle\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F008|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A8|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0063|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A63|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A71', `item_level` = '70', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Adder\'s Tongue', `item_parent` = 'Bank Bag4', `item_slot` = '9', `item_color` = 'ffffff', `item_id` = '36903:0:0:0:0:0:0:2127010432:85:0', `item_texture` = 'inv_misc_herb_evergreenmoss', `item_quantity` = '20', `item_tooltip` = 'Adder\'s Tongue\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0020|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A20|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A21', `item_level` = '77', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Icethorn', `item_parent` = 'Bank Bag4', `item_slot` = '10', `item_color` = 'ffffff', `item_id` = '36906:0:0:0:0:0:0:499653936:85:0', `item_texture` = 'inv_misc_herb_icethorn', `item_quantity` = '5', `item_tooltip` = 'Icethorn\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F003|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A3|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F005|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A5|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A8', `item_level` = '80', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Terocone', `item_parent` = 'Bank Bag4', `item_slot` = '11', `item_color` = 'ffffff', `item_id` = '22789:0:0:0:0:0:0:1890705152:85:0', `item_texture` = 'inv_misc_herb_terrocone', `item_quantity` = '20', `item_tooltip` = 'Terocone\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0034|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A34|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A34', `item_level` = '60', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Terocone', `item_parent` = 'Bank Bag4', `item_slot` = '12', `item_color` = 'ffffff', `item_id` = '22789:0:0:0:0:0:0:722137632:85:0', `item_texture` = 'inv_misc_herb_terrocone', `item_quantity` = '14', `item_tooltip` = 'Terocone\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0034|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A34|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A34', `item_level` = '60', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Talandra\'s Rose', `item_parent` = 'Bank Bag4', `item_slot` = '13', `item_color` = 'ffffff', `item_id` = '36907:0:0:0:0:0:0:1742505344:85:0', `item_texture` = 'inv_misc_herb_talandrasrose', `item_quantity` = '6', `item_tooltip` = 'Talandra\'s Rose\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0024|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A24|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F006|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A6|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A30', `item_level` = '72', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Fel Lotus', `item_parent` = 'Bank Bag4', `item_slot` = '14', `item_color` = '1eff00', `item_id` = '22794:0:0:0:0:0:0:1843084416:85:0', `item_texture` = 'inv_misc_herb_fellotus', `item_quantity` = '6', `item_tooltip` = 'Fel Lotus\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F004|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A4|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F006|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A6|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A10', `item_level` = '70', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Tiger Lily', `item_parent` = 'Bank Bag4', `item_slot` = '15', `item_color` = 'ffffff', `item_id` = '36904:0:0:0:0:0:0:1172164736:85:0', `item_texture` = 'inv_misc_herb_tigerlily', `item_quantity` = '5', `item_tooltip` = 'Tiger Lily\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F003|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A3|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F005|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A5|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A8', `item_level` = '72', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Deadnettle', `item_parent` = 'Bank Bag4', `item_slot` = '18', `item_color` = 'ffffff', `item_id` = '37921:0:0:0:0:0:0:1415847744:85:0', `item_texture` = 'inv_misc_herb_constrictorgrass', `item_quantity` = '20', `item_tooltip` = 'Deadnettle\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F006|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A6|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0069|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A69|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A75', `item_level` = '72', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Deadnettle', `item_parent` = 'Bank Bag4', `item_slot` = '19', `item_color` = 'ffffff', `item_id` = '37921:0:0:0:0:0:0:-1668086400:85:0', `item_texture` = 'inv_misc_herb_constrictorgrass', `item_quantity` = '20', `item_tooltip` = 'Deadnettle\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F006|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A6|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0069|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A69|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A75', `item_level` = '72', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Deadnettle', `item_parent` = 'Bank Bag4', `item_slot` = '17', `item_color` = 'ffffff', `item_id` = '37921:0:0:0:0:0:0:1819435008:85:0', `item_texture` = 'inv_misc_herb_constrictorgrass', `item_quantity` = '19', `item_tooltip` = 'Deadnettle\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F006|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A6|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0069|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A69|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A75', `item_level` = '72', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0005 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Deadnettle', `item_parent` = 'Bank Bag4', `item_slot` = '20', `item_color` = 'ffffff', `item_id` = '37921:0:0:0:0:0:0:1994152064:85:0', `item_texture` = 'inv_misc_herb_constrictorgrass', `item_quantity` = '10', `item_tooltip` = 'Deadnettle\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F006|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A6|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0069|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A69|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A75', `item_level` = '72', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Bank Contents', `item_parent` = 'bags', `item_slot` = 'Bank Bag0', `item_color` = 'ffffff', `item_id` = '0:0:0:0:0:0:0:0', `item_texture` = 'inv_misc_bag_15', `item_quantity` = '28', `item_tooltip` = 'Relic of Ulduar\n\"There are certain to be individuals who place value in these.\"\n \n \n|cFF69CCF0Bethanie |cFF00FF9A|cFFFF7F003|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A3|cFFFFFFFF)\n|cFF00FF00Pagans of Dawn |cFF00FF9A|cFFFFFFFF(Guild Bank: |cFF00FF9A20|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A23', `item_level` = '', `item_type` = '', `item_subtype` = '', `item_rarity` = '', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Mallet of Zul\'Farrak', `item_parent` = 'Bank Bag0', `item_slot` = '1', `item_color` = '0070dd', `item_id` = '9240:0:0:0:0:0:0:500741580:85:0', `item_texture` = 'inv_hammer_19', `item_quantity` = '1', `item_tooltip` = 'Mallet of Zul\'Farrak\nSoulbound\nUnique\nOne-Hand Mace\n58 - 109 Damage Speed 2.50\n(33.5 damage per second)\n+8 Strength\n+8 Stamina\nDurability 0 / 90\nRequires Level 35\n|cffffd100ItemLevel: 50|r\n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A4', `item_level` = '50', `item_type` = 'Weapon', `item_subtype` = 'One-Handed Maces', `item_rarity` = '3', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Holy Dust', `item_parent` = 'Bank Bag0', `item_slot` = '2', `item_color` = 'ffffff', `item_id` = '29735:0:0:0:0:0:0:777680486:85:0', `item_texture` = 'inv_misc_dust_06', `item_quantity` = '7', `item_tooltip` = 'Holy Dust\nSoulbound\n\"This shimmering dust is used as a material for Aldor inscriptions.\"\n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F002|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A2|cFFFFFFFF)\n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F008|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A8|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F007|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A7|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F005|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A5|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A22', `item_level` = '0', `item_type` = 'Consumable', `item_subtype` = 'Consumable', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Spectral Essence', `item_parent` = 'Bank Bag0', `item_slot` = '3', `item_color` = '1eff00', `item_id` = '13544:0:0:0:0:0:0:989511418:85:0', `item_texture` = 'inv_misc_orb_05', `item_quantity` = '1', `item_tooltip` = 'Spectral Essence\nSoulbound\nUnique\nTrinket\n|cffffd100ItemLevel: 60|r\n\"Allows communication with the deceased of Caer Darrow.\"\n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A5\n \n|cffffffffStat Summary|r\nRanged Attack Power 0.0 (|cffff2020-614.3|r|||cffff2020-438.4|r)\nRanged Crit Chance 0.00% (|cffff2020-0.76%|r|||cffff2020-0.54%|r)', `item_level` = '60', `item_type` = 'Armor', `item_subtype` = 'Miscellaneous', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Elixir of Shadows', `item_parent` = 'Bank Bag0', `item_slot` = '4', `item_color` = 'ffffff', `item_id` = '32446:0:0:0:0:0:0:2101746263:85:0', `item_texture` = 'inv_poison_mindnumbing', `item_quantity` = '9', `item_tooltip` = 'Elixir of Shadows\nSoulbound\nUse: Allows the imbiber to see the shadowy spirits of Skettis.\n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F009|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A9|cFFFFFFFF)\n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F009|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A9|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F002|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A2|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A22', `item_level` = '1', `item_type` = 'Quest', `item_subtype` = 'Quest', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Oshu\'gun Crystal Powder Sample', `item_parent` = 'Bank Bag0', `item_slot` = '5', `item_color` = 'ffffff', `item_id` = '26043:0:0:0:0:0:0:1802192192:85:0', `item_texture` = 'inv_enchant_dustvision', `item_quantity` = '43', `item_tooltip` = 'Oshu\'gun Crystal Powder Sample\nSoulbound\nUnique (100)\n\"You may turn 10 of these items in to Chief Researcher Kartos at Halaa if the Alliance have control of the base.\"\n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0012|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A12|cFFFFFFFF)\n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F0013|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A13|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0043|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A43|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F0047|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A47|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F0063|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A63|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A178', `item_level` = '65', `item_type` = 'Miscellaneous', `item_subtype` = 'Junk', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Spirit Shard', `item_parent` = 'Bank Bag0', `item_slot` = '6', `item_color` = 'ffffff', `item_id` = '28558:0:0:0:0:0:0:1434591104:85:0', `item_texture` = 'inv_jewelry_frostwolftrinket_04', `item_quantity` = '5', `item_tooltip` = 'Spirit Shard\nSoulbound\n\"The shard pulses with energy.\"\n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F003|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A3|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F005|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A5|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A9', `item_level` = '1', `item_type` = 'Quest', `item_subtype` = 'Quest', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Northern Spices', `item_parent` = 'Bank Bag0', `item_slot` = '7', `item_color` = 'ffffff', `item_id` = '43007:0:0:0:0:0:0:1251902424:85:0', `item_texture` = 'inv_misc_ammo_gunpowder_05', `item_quantity` = '41', `item_tooltip` = 'Northern Spices\n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0041|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A41|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F00125|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A125|cFFFFFFFF)\n|cFF69CCF0Bethanie |cFF00FF9A|cFFFF7F0013|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A13|cFFFFFFFF)\n|cFF00FF00Pagans of Dawn |cFF00FF9A|cFFFFFFFF(Guild Bank: |cFF00FF9A98|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A277\n \n|cFFFFD700Source: |cFF00FF9ADalaran Cooking Award, 1x', `item_level` = '80', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Preserved Holly', `item_parent` = 'Bank Bag0', `item_slot` = '8', `item_color` = '1eff00', `item_id` = '21213:0:0:0:0:0:0:-1857086463:85:0', `item_texture` = 'inv_misc_plant_03', `item_quantity` = '18', `item_tooltip` = 'Preserved Holly\nRequires Level 20\nUse: Your mount will be more festive. (1 Min Cooldown)\n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F005|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A5|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0018|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A18|cFFFFFFFF)\n|cFF69CCF0Bethanie |cFF00FF9A|cFFFF7F005|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A5|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A28\n \n|cFFFFD700Source: |cFF00FF9AFeast of Winter Veil, Ticking Present', `item_level` = '20', `item_type` = 'Miscellaneous', `item_subtype` = 'Holiday', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'MiniZep Controller', `item_parent` = 'Bank Bag0', `item_slot` = '9', `item_color` = '0070dd', `item_id` = '46709:0:0:0:0:0:0:1740125312:85:0', `item_texture` = 'inv_gizmo_goblingtonkcontroller', `item_quantity` = '1', `item_tooltip` = 'MiniZep Controller\nSoulbound\nUse: Summon and control your MiniZep! (30 Sec Cooldown)\n \n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFF69CCF0Bethanie |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A3', `item_level` = '55', `item_type` = 'Miscellaneous', `item_subtype` = 'Holiday', `item_rarity` = '3', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Drakkari Offerings', `item_parent` = 'Bank Bag0', `item_slot` = '10', `item_color` = 'ffffff', `item_id` = '38551:0:0:0:0:0:0:514455536:85:0', `item_texture` = 'inv_misc_urn_01', `item_quantity` = '3', `item_tooltip` = 'Drakkari Offerings\nSoulbound\n\"These can be used 10 at a time at various Drakkari troll god shrines to gain their blessings.\"\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F004|cFFFFFFFF (|cFFFFFFFFBags: |cFF00FF9A4|cFFFFFFFF)\n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F002|cFFFFFFFF (|cFFFFFFFFBags: |cFF00FF9A1|cFFFFFFFF, |cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F003|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A3|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F0067|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A67|cFFFFFFFF)\n|cFF69CCF0Bethanie |cFF00FF9A|cFFFF7F004|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A4|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A80', `item_level` = '1', `item_type` = 'Quest', `item_subtype` = 'Quest', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Tabard of the Guardians of Hyjal', `item_parent` = 'Bank Bag0', `item_slot` = '12', `item_color` = 'ffffff', `item_id` = '65906:0:0:0:0:0:0:0:85:0', `item_texture` = 'inv_misc_tabard_guardiansofhyjal', `item_quantity` = '1', `item_tooltip` = 'Tabard of the Guardians of Hyjal\nSoulbound\nUnique\nTabard\n|cffffd100ItemLevel: 85|r\nRequires Guardians of Hyjal - Friendly\nEquip: You champion the cause of the Guardians of Hyjal. All reputation gains while in level 85 Cataclysm dungeons will be applied to your standing with them.\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1', `item_level` = '85', `item_type` = 'Armor', `item_subtype` = 'Miscellaneous', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Apexis Shard', `item_parent` = 'Bank Bag0', `item_slot` = '13', `item_color` = 'ffffff', `item_id` = '32569:0:0:0:0:0:0:1095332615:85:0', `item_texture` = 'inv_misc_apexis_shard', `item_quantity` = '9', `item_tooltip` = 'Apexis Shard\nSoulbound\n\"A slivered fragment of an Apexis Crystal.\"\n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F009|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A9|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A9', `item_level` = '0', `item_type` = 'Miscellaneous', `item_subtype` = 'Junk', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Depleted Crystal Focus', `item_parent` = 'Bank Bag0', `item_slot` = '14', `item_color` = 'ffffff', `item_id` = '32576:0:0:0:0:0:0:-1718164240:85:0', `item_texture` = 'inv_stone_03', `item_quantity` = '1', `item_tooltip` = 'Depleted Crystal Focus\nUse: Combine with 10 Apexis Shards to create a Charged Crystal Focus. The charged crystal can be used for instant healing and is rumored to have other uses. Kronk in Ogri\'la can likely tell you about this.\n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1', `item_level` = '0', `item_type` = 'Consumable', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Gnomeregan Pride', `item_parent` = 'Bank Bag0', `item_slot` = '15', `item_color` = '0070dd', `item_id` = '54651:0:0:0:0:0:0:141013184:85:0', `item_texture` = 'inv_misc_tournaments_symbol_gnome', `item_quantity` = '1', `item_tooltip` = 'Gnomeregan Pride\nSoulbound\nUse: Transform into Gnomeregan Infantry. (4 Hr Cooldown)\n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFF69CCF0Bethanie |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A6', `item_level` = '20', `item_type` = 'Consumable', `item_subtype` = 'Consumable', `item_rarity` = '3', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Gnomeregan Drape', `item_parent` = 'Bank Bag0', `item_slot` = '16', `item_color` = 'ffffff', `item_id` = '53097:0:0:0:0:0:0:1726318464:85:0', `item_texture` = 'inv_misc_tournaments_banner_gnome', `item_quantity` = '1', `item_tooltip` = 'Gnomeregan Drape\nSoulbound\nBack\n92 Armor\nRequires Level 75\n|cffffd100ItemLevel: 80|r\n\"Waterproof, stain-proof, one size fits all. Hooray, science!\"\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A5', `item_level` = '80', `item_type` = 'Armor', `item_subtype` = 'Cloth', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Tabard of the Explorer', `item_parent` = 'Bank Bag0', `item_slot` = '17', `item_color` = 'a335ee', `item_id` = '43348:0:0:0:0:0:0:100839382:85:0', `item_texture` = 'inv_chest_cloth_30', `item_quantity` = '1', `item_tooltip` = 'Tabard of the Explorer\nSoulbound\nTabard\n|cffffd100ItemLevel: 1|r\n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBags: |cFF00FF9A1|cFFFFFFFF)\n|cFFFF7D0AExpectations |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFF69CCF0Bethanie |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A6', `item_level` = '1', `item_type` = 'Armor', `item_subtype` = 'Miscellaneous', `item_rarity` = '4', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Vrykul Bones', `item_parent` = 'Bank Bag0', `item_slot` = '18', `item_color` = 'ffffff', `item_id` = '43089:0:0:0:0:0:0:-1580640128:85:0', `item_texture` = 'inv_misc_bone_01', `item_quantity` = '15', `item_tooltip` = 'Vrykul Bones\nSoulbound\n\"May be given to The Bone Witch in Njorndar Village, fifteen at a time, in exchange for a fate rune.\"\n \n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F0010|cFFFFFFFF (|cFFFFFFFFBags: |cFF00FF9A1|cFFFFFFFF, |cFFFFFFFFBank: |cFF00FF9A9|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0015|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A15|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F009|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A9|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A34', `item_level` = '1', `item_type` = 'Quest', `item_subtype` = 'Quest', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Netherweave Bag', `item_parent` = 'Bank Bag0', `item_slot` = '28', `item_color` = '1eff00', `item_id` = '21841:0:0:0:0:0:0:1669716692:85:0', `item_texture` = 'inv_misc_bag_23_netherweave', `item_quantity` = '1', `item_tooltip` = 'Netherweave Bag\nSoulbound\n16 Slot Bag\n|cff00ff00|r\n \n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F002|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A2|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A3\n \n|cFFFFD700Source: |cFF00FF9ATailoring, 315', `item_level` = '63', `item_type` = 'Container', `item_subtype` = 'Bag', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Imbued Netherweave Bag', `item_parent` = 'bags', `item_slot` = 'Bank Bag1', `item_color` = '1eff00', `item_id` = '21843:0:0:0:0:0:0:312821208:85:0', `item_texture` = 'inv_misc_bag_24_netherweave_imbued', `item_quantity` = '18', `item_tooltip` = 'Imbued Netherweave Bag\nSoulbound\n18 Slot Bag\n|cff00ff00|r\n \n \n|cFFFFD700Source: |cFF00FF9ATailoring, 340', `item_level` = '', `item_type` = '', `item_subtype` = '', `item_rarity` = '', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Scroll of Intellect VII', `item_parent` = 'Bank Bag1', `item_slot` = '1', `item_color` = 'ffffff', `item_id` = '37091:0:0:0:0:0:0:307279468:85:0', `item_texture` = 'inv_scroll_01', `item_quantity` = '1', `item_tooltip` = 'Scroll of Intellect VII\nRequires Level 70\nUse: Increases the target\'s Intellect by 25 for 30 min. This effect counts as a Battle Elixir. (1 Sec Cooldown)\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cFFFFD700Source: |cFF00FF9AInscription, 360', `item_level` = '70', `item_type` = 'Consumable', `item_subtype` = 'Scroll', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Arcane Crystal', `item_parent` = 'Bank Bag1', `item_slot` = '2', `item_color` = '1eff00', `item_id` = '12363:0:0:0:0:0:0:1680516288:85:0', `item_texture` = 'inv_misc_gem_topaz_01', `item_quantity` = '8', `item_tooltip` = 'Arcane Crystal\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F008|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A8|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A8', `item_level` = '60', `item_type` = 'Gem', `item_subtype` = 'Simple', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Swim Speed Potion', `item_parent` = 'Bank Bag1', `item_slot` = '3', `item_color` = 'ffffff', `item_id` = '6372:0:0:0:0:0:0:756548480:85:0', `item_texture` = 'inv_potion_13', `item_quantity` = '1', `item_tooltip` = 'Swim Speed Potion\nRequires Level 10\nUse: Increases swim speed by 100% for 20 sec.\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cFFFFD700Source: |cFF00FF9AAlchemy, 100', `item_level` = '20', `item_type` = 'Consumable', `item_subtype` = 'Potion', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Pygmy Oil', `item_parent` = 'Bank Bag1', `item_slot` = '4', `item_color` = 'ffffff', `item_id` = '40195:0:0:0:0:0:0:1799709210:85:0', `item_texture` = 'inv_potion_07', `item_quantity` = '6', `item_tooltip` = 'Pygmy Oil\nUse: Drink it.\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0010|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A10|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A10\n \n|cFFFFD700Source: |cFF00FF9AAlchemy, 375', `item_level` = '75', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Stonescale Oil', `item_parent` = 'Bank Bag1', `item_slot` = '5', `item_color` = 'ffffff', `item_id` = '13423:0:0:0:0:0:0:190429440:85:0', `item_texture` = 'inv_potion_68', `item_quantity` = '2', `item_tooltip` = 'Stonescale Oil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F002|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A2|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A2\n \n|cFFFFD700Source: |cFF00FF9AAlchemy, 250', `item_level` = '50', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Fire Oil', `item_parent` = 'Bank Bag1', `item_slot` = '6', `item_color` = 'ffffff', `item_id` = '6371:0:0:0:0:0:0:1998743936:85:0', `item_texture` = 'inv_potion_38', `item_quantity` = '12', `item_tooltip` = 'Fire Oil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0012|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A12|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A12\n \n|cFFFFD700Source: |cFF00FF9AAlchemy, 130', `item_level` = '25', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Tainted Vial', `item_parent` = 'Bank Bag1', `item_slot` = '7', `item_color` = '9d9d9d', `item_id` = '8925:0:0:0:0:0:0:0:85:0', `item_texture` = 'inv_potion_87', `item_quantity` = '8', `item_tooltip` = 'Tainted Vial\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F008|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A8|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A8', `item_level` = '35', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '0', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Hyjal Expedition Bag', `item_parent` = 'bags', `item_slot` = 'Bank Bag2', `item_color` = '1eff00', `item_id` = '54446:0:0:0:0:0:0:1395797120:85:0', `item_texture` = 'inv_misc_bag_30', `item_quantity` = '36', `item_tooltip` = 'Hyjal Expedition Bag\nSoulbound\n36 Slot Herb Bag\n|cff00ff00|r\n \n \n|cFF00FF00Pagans of Dawn |cFF00FF9A|cFFFFFFFF(Guild Bank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1\n \n|cFFFFD700Source: |cFF00FF9ATailoring, 490', `item_level` = '', `item_type` = '', `item_subtype` = '', `item_rarity` = '', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Stormvine', `item_parent` = 'Bank Bag2', `item_slot` = '1', `item_color` = 'ffffff', `item_id` = '52984:0:0:0:0:0:0:1942047744:85:0', `item_texture` = 'inv_misc_herb_stormvine', `item_quantity` = '20', `item_tooltip` = 'Stormvine\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0028|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A28|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A28', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Stormvine', `item_parent` = 'Bank Bag2', `item_slot` = '2', `item_color` = 'ffffff', `item_id` = '52984:0:0:0:0:0:0:1466635264:85:0', `item_texture` = 'inv_misc_herb_stormvine', `item_quantity` = '8', `item_tooltip` = 'Stormvine\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0028|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A28|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A28', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Azshara\'s Veil', `item_parent` = 'Bank Bag2', `item_slot` = '3', `item_color` = 'ffffff', `item_id` = '52985:0:0:0:0:0:0:1500011904:85:0', `item_texture` = 'inv_misc_herb_azsharasveil', `item_quantity` = '20', `item_tooltip` = 'Azshara\'s Veil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F00203|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A203|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A203', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Azshara\'s Veil', `item_parent` = 'Bank Bag2', `item_slot` = '4', `item_color` = 'ffffff', `item_id` = '52985:0:0:0:0:0:0:603804512:85:0', `item_texture` = 'inv_misc_herb_azsharasveil', `item_quantity` = '20', `item_tooltip` = 'Azshara\'s Veil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F00203|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A203|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A203', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Azshara\'s Veil', `item_parent` = 'Bank Bag2', `item_slot` = '5', `item_color` = 'ffffff', `item_id` = '52985:0:0:0:0:0:0:2042843648:85:0', `item_texture` = 'inv_misc_herb_azsharasveil', `item_quantity` = '20', `item_tooltip` = 'Azshara\'s Veil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F00203|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A203|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A203', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Azshara\'s Veil', `item_parent` = 'Bank Bag2', `item_slot` = '6', `item_color` = 'ffffff', `item_id` = '52985:0:0:0:0:0:0:616371328:85:0', `item_texture` = 'inv_misc_herb_azsharasveil', `item_quantity` = '20', `item_tooltip` = 'Azshara\'s Veil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F00203|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A203|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A203', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Azshara\'s Veil', `item_parent` = 'Bank Bag2', `item_slot` = '7', `item_color` = 'ffffff', `item_id` = '52985:0:0:0:0:0:0:1933206656:85:0', `item_texture` = 'inv_misc_herb_azsharasveil', `item_quantity` = '20', `item_tooltip` = 'Azshara\'s Veil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F00203|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A203|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A203', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Azshara\'s Veil', `item_parent` = 'Bank Bag2', `item_slot` = '8', `item_color` = 'ffffff', `item_id` = '52985:0:0:0:0:0:0:-2079651584:85:0', `item_texture` = 'inv_misc_herb_azsharasveil', `item_quantity` = '20', `item_tooltip` = 'Azshara\'s Veil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F00203|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A203|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A203', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Azshara\'s Veil', `item_parent` = 'Bank Bag2', `item_slot` = '9', `item_color` = 'ffffff', `item_id` = '52985:0:0:0:0:0:0:478142928:85:0', `item_texture` = 'inv_misc_herb_azsharasveil', `item_quantity` = '20', `item_tooltip` = 'Azshara\'s Veil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F00203|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A203|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A203', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Azshara\'s Veil', `item_parent` = 'Bank Bag2', `item_slot` = '10', `item_color` = 'ffffff', `item_id` = '52985:0:0:0:0:0:0:1479575040:85:0', `item_texture` = 'inv_misc_herb_azsharasveil', `item_quantity` = '20', `item_tooltip` = 'Azshara\'s Veil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F00203|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A203|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A203', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Azshara\'s Veil', `item_parent` = 'Bank Bag2', `item_slot` = '11', `item_color` = 'ffffff', `item_id` = '52985:0:0:0:0:0:0:1128585600:85:0', `item_texture` = 'inv_misc_herb_azsharasveil', `item_quantity` = '20', `item_tooltip` = 'Azshara\'s Veil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F00203|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A203|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A203', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Azshara\'s Veil', `item_parent` = 'Bank Bag2', `item_slot` = '12', `item_color` = 'ffffff', `item_id` = '52985:0:0:0:0:0:0:1481140480:85:0', `item_texture` = 'inv_misc_herb_azsharasveil', `item_quantity` = '20', `item_tooltip` = 'Azshara\'s Veil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F00203|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A203|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A203', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Azshara\'s Veil', `item_parent` = 'Bank Bag2', `item_slot` = '13', `item_color` = 'ffffff', `item_id` = '52985:0:0:0:0:0:0:670092512:85:0', `item_texture` = 'inv_misc_herb_azsharasveil', `item_quantity` = '3', `item_tooltip` = 'Azshara\'s Veil\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F00203|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A203|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A203', `item_level` = '82', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Twilight Jasmine', `item_parent` = 'Bank Bag2', `item_slot` = '14', `item_color` = 'ffffff', `item_id` = '52987:0:0:0:0:0:0:1828812288:85:0', `item_texture` = 'inv_misc_herb_twilightjasmine', `item_quantity` = '20', `item_tooltip` = 'Twilight Jasmine\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0071|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A71|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A71', `item_level` = '85', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Twilight Jasmine', `item_parent` = 'Bank Bag2', `item_slot` = '15', `item_color` = 'ffffff', `item_id` = '52987:0:0:0:0:0:0:781782816:85:0', `item_texture` = 'inv_misc_herb_twilightjasmine', `item_quantity` = '20', `item_tooltip` = 'Twilight Jasmine\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0071|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A71|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A71', `item_level` = '85', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Twilight Jasmine', `item_parent` = 'Bank Bag2', `item_slot` = '16', `item_color` = 'ffffff', `item_id` = '52987:0:0:0:0:0:0:608930688:85:0', `item_texture` = 'inv_misc_herb_twilightjasmine', `item_quantity` = '20', `item_tooltip` = 'Twilight Jasmine\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0071|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A71|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A71', `item_level` = '85', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Twilight Jasmine', `item_parent` = 'Bank Bag2', `item_slot` = '17', `item_color` = 'ffffff', `item_id` = '52987:0:0:0:0:0:0:1273139584:85:0', `item_texture` = 'inv_misc_herb_twilightjasmine', `item_quantity` = '11', `item_tooltip` = 'Twilight Jasmine\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0071|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A71|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A71', `item_level` = '85', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Heartblossom', `item_parent` = 'Bank Bag2', `item_slot` = '18', `item_color` = 'ffffff', `item_id` = '52986:0:0:0:0:0:0:-1928138112:85:0', `item_texture` = 'inv_misc_herb_heartblossom', `item_quantity` = '4', `item_tooltip` = 'Heartblossom\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0018|cFFFFFFFF (|cFFFFFFFFBags: |cFF00FF9A18|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F004|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A4|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A22', `item_level` = '83', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Whiptail', `item_parent` = 'Bank Bag2', `item_slot` = '19', `item_color` = 'ffffff', `item_id` = '52988:0:0:0:0:0:0:1243665728:85:0', `item_texture` = 'inv_misc_herb_whiptail', `item_quantity` = '20', `item_tooltip` = 'Whiptail\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F003|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A3|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0028|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A28|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F0012|cFFFFFFFF (|cFFFFFFFFBags: |cFF00FF9A12|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A43', `item_level` = '84', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Whiptail', `item_parent` = 'Bank Bag2', `item_slot` = '20', `item_color` = 'ffffff', `item_id` = '52988:0:0:0:0:0:0:-2142593280:85:0', `item_texture` = 'inv_misc_herb_whiptail', `item_quantity` = '8', `item_tooltip` = 'Whiptail\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F003|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A3|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0028|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A28|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F0012|cFFFFFFFF (|cFFFFFFFFBags: |cFF00FF9A12|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A43', `item_level` = '84', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Cinderbloom', `item_parent` = 'Bank Bag2', `item_slot` = '21', `item_color` = 'ffffff', `item_id` = '52983:0:0:0:0:0:0:654244576:85:0', `item_texture` = 'inv_misc_herb_cinderbloom', `item_quantity` = '20', `item_tooltip` = 'Cinderbloom\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0012|cFFFFFFFF (|cFFFFFFFFBags: |cFF00FF9A12|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0056|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A56|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A68', `item_level` = '81', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0005 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Cinderbloom', `item_parent` = 'Bank Bag2', `item_slot` = '22', `item_color` = 'ffffff', `item_id` = '52983:0:0:0:0:0:0:463310880:85:0', `item_texture` = 'inv_misc_herb_cinderbloom', `item_quantity` = '17', `item_tooltip` = 'Cinderbloom\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0012|cFFFFFFFF (|cFFFFFFFFBags: |cFF00FF9A12|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0056|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A56|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A68', `item_level` = '81', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Imbued Netherweave Bag', `item_parent` = 'bags', `item_slot` = 'Bank Bag7', `item_color` = '1eff00', `item_id` = '21843:0:0:0:0:0:0:788626698:85:0', `item_texture` = 'inv_misc_bag_24_netherweave_imbued', `item_quantity` = '18', `item_tooltip` = 'Imbued Netherweave Bag\nSoulbound\n18 Slot Bag\n|cff00ff00|r\n \n \n|cFFFFD700Source: |cFF00FF9ATailoring, 340', `item_level` = '', `item_type` = '', `item_subtype` = '', `item_rarity` = '', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Crystal Vial', `item_parent` = 'Bank Bag7', `item_slot` = '3', `item_color` = 'ffffff', `item_id` = '3371:0:0:0:0:0:0:0:85:0', `item_texture` = 'inv_alchemy_leadedvial', `item_quantity` = '17', `item_tooltip` = 'Crystal Vial\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0057|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A57|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A57', `item_level` = '1', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Crystal Vial', `item_parent` = 'Bank Bag7', `item_slot` = '4', `item_color` = 'ffffff', `item_id` = '3371:0:0:0:0:0:0:0:85:0', `item_texture` = 'inv_alchemy_leadedvial', `item_quantity` = '20', `item_tooltip` = 'Crystal Vial\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0057|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A57|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A57', `item_level` = '1', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Crystal Vial', `item_parent` = 'Bank Bag7', `item_slot` = '5', `item_color` = 'ffffff', `item_id` = '3371:0:0:0:0:0:0:0:85:0', `item_texture` = 'inv_alchemy_leadedvial', `item_quantity` = '20', `item_tooltip` = 'Crystal Vial\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0057|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A57|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A57', `item_level` = '1', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Pygmy Oil', `item_parent` = 'Bank Bag7', `item_slot` = '10', `item_color` = 'ffffff', `item_id` = '40195:0:0:0:0:0:0:-1647864637:85:0', `item_texture` = 'inv_potion_07', `item_quantity` = '4', `item_tooltip` = 'Pygmy Oil\nUse: Drink it.\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0010|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A10|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A10\n \n|cFFFFD700Source: |cFF00FF9AAlchemy, 375', `item_level` = '75', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Glassfin Minnow', `item_parent` = 'Bank Bag7', `item_slot` = '11', `item_color` = 'ffffff', `item_id` = '41814:0:0:0:0:0:0:593344608:85:0', `item_texture` = 'inv_misc_fish_69', `item_quantity` = '4', `item_tooltip` = 'Glassfin Minnow\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F004|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A4|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A4', `item_level` = '70', `item_type` = 'Trade Goods', `item_subtype` = 'Meat', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Stonescale Eel', `item_parent` = 'Bank Bag7', `item_slot` = '12', `item_color` = 'ffffff', `item_id` = '13422:0:0:0:0:0:0:-1513352576:85:0', `item_texture` = 'inv_misc_fish_11', `item_quantity` = '3', `item_tooltip` = 'Stonescale Eel\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F003|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A3|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A3', `item_level` = '45', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Pygmy Suckerfish', `item_parent` = 'Bank Bag7', `item_slot` = '13', `item_color` = 'ffffff', `item_id` = '40199:0:0:0:0:0:0:1484571648:85:0', `item_texture` = 'inv_misc_fish_55', `item_quantity` = '1', `item_tooltip` = 'Pygmy Suckerfish\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1', `item_level` = '75', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Deviate Fish', `item_parent` = 'Bank Bag7', `item_slot` = '14', `item_color` = 'ffffff', `item_id` = '6522:0:0:0:0:0:0:130061737:85:0', `item_texture` = 'inv_misc_monsterhead_01', `item_quantity` = '3', `item_tooltip` = 'Deviate Fish\nUse: Eat me. (10 Sec Cooldown)\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F003|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A3|cFFFFFFFF)\n|cFFABD473Kharaghiosis |cFF00FF9A|cFFFF7F004|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A4|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A7', `item_level` = '15', `item_type` = 'Consumable', `item_subtype` = 'Food & Drink', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Firefin Snapper', `item_parent` = 'Bank Bag7', `item_slot` = '15', `item_color` = 'ffffff', `item_id` = '6359:0:0:0:0:0:0:585609536:85:0', `item_texture` = 'inv_misc_monsterhead_01', `item_quantity` = '6', `item_tooltip` = 'Firefin Snapper\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F006|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A6|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A6', `item_level` = '25', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Lightning Eel', `item_parent` = 'Bank Bag7', `item_slot` = '16', `item_color` = 'ffffff', `item_id` = '13757:0:0:0:0:0:0:-2098267648:85:0', `item_texture` = 'inv_misc_fish_12', `item_quantity` = '2', `item_tooltip` = 'Lightning Eel\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F002|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A2|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A2', `item_level` = '45', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Oily Blackmouth', `item_parent` = 'Bank Bag7', `item_slot` = '17', `item_color` = 'ffffff', `item_id` = '6358:0:0:0:0:0:0:-1200461568:85:0', `item_texture` = 'inv_misc_monsterhead_04', `item_quantity` = '8', `item_tooltip` = 'Oily Blackmouth\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0028|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A28|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A28', `item_level` = '15', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Oily Blackmouth', `item_parent` = 'Bank Bag7', `item_slot` = '18', `item_color` = 'ffffff', `item_id` = '6358:0:0:0:0:0:0:-1899272192:85:0', `item_texture` = 'inv_misc_monsterhead_04', `item_quantity` = '20', `item_tooltip` = 'Oily Blackmouth\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0028|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A28|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A28', `item_level` = '15', `item_type` = 'Trade Goods', `item_subtype` = 'Other', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Cenarion Herb Bag', `item_parent` = 'bags', `item_slot` = 'Bank Bag3', `item_color` = '1eff00', `item_id` = '22251:0:0:0:0:0:0:725633618:85:0', `item_texture` = 'inv_misc_bag_cenarionherbbag', `item_quantity` = '20', `item_tooltip` = 'Cenarion Herb Bag\nSoulbound\n20 Slot Herb Bag\n|cff00ff00|r\n \n \n|cFFFFD700Source: |cFF00FF9ATailoring, 275', `item_level` = '', `item_type` = '', `item_subtype` = '', `item_rarity` = '', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Ancient Lichen', `item_parent` = 'Bank Bag3', `item_slot` = '1', `item_color` = 'ffffff', `item_id` = '22790:0:0:0:0:0:0:301860940:85:0', `item_texture` = 'inv_misc_herb_ancientlichen', `item_quantity` = '1', `item_tooltip` = 'Ancient Lichen\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0021|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A21|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A21', `item_level` = '68', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Ancient Lichen', `item_parent` = 'Bank Bag3', `item_slot` = '2', `item_color` = 'ffffff', `item_id` = '22790:0:0:0:0:0:0:1574648960:85:0', `item_texture` = 'inv_misc_herb_ancientlichen', `item_quantity` = '20', `item_tooltip` = 'Ancient Lichen\n \n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0021|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A21|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A21', `item_level` = '68', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Lichbloom', `item_parent` = 'Bank Bag3', `item_slot` = '3', `item_color` = 'ffffff', `item_id` = '36905:0:0:0:0:0:0:317059368:85:0', `item_texture` = 'inv_misc_herb_whispervine', `item_quantity` = '20', `item_tooltip` = 'Lichbloom\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0036|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A36|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A37', `item_level` = '80', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Lichbloom', `item_parent` = 'Bank Bag3', `item_slot` = '4', `item_color` = 'ffffff', `item_id` = '36905:0:0:0:0:0:0:1850237696:85:0', `item_texture` = 'inv_misc_herb_whispervine', `item_quantity` = '16', `item_tooltip` = 'Lichbloom\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0036|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A36|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A37', `item_level` = '80', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Felweed', `item_parent` = 'Bank Bag3', `item_slot` = '5', `item_color` = 'ffffff', `item_id` = '22785:0:0:0:0:0:0:368868592:85:0', `item_texture` = 'inv_misc_herb_felweed', `item_quantity` = '19', `item_tooltip` = 'Felweed\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F007|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A7|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0055|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A55|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A62', `item_level` = '60', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Felweed', `item_parent` = 'Bank Bag3', `item_slot` = '6', `item_color` = 'ffffff', `item_id` = '22785:0:0:0:0:0:0:1190060608:85:0', `item_texture` = 'inv_misc_herb_felweed', `item_quantity` = '20', `item_tooltip` = 'Felweed\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F007|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A7|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0055|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A55|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A62', `item_level` = '60', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Felweed', `item_parent` = 'Bank Bag3', `item_slot` = '7', `item_color` = 'ffffff', `item_id` = '22785:0:0:0:0:0:0:812564992:85:0', `item_texture` = 'inv_misc_herb_felweed', `item_quantity` = '16', `item_tooltip` = 'Felweed\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F007|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A7|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0055|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A55|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A62', `item_level` = '60', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0002 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Cinderbloom', `item_parent` = 'Bank Bag3', `item_slot` = '8', `item_color` = 'ffffff', `item_id` = '52983:0:0:0:0:0:0:-1970171008:85:0', `item_texture` = 'inv_misc_herb_cinderbloom', `item_quantity` = '19', `item_tooltip` = 'Cinderbloom\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0012|cFFFFFFFF (|cFFFFFFFFBags: |cFF00FF9A12|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0056|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A56|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A68', `item_level` = '81', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0005 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Frost Lotus', `item_parent` = 'Bank Bag3', `item_slot` = '9', `item_color` = '1eff00', `item_id` = '36908:0:0:0:0:0:0:-1864775168:85:0', `item_texture` = 'inv_misc_herb_frostlotus', `item_quantity` = '20', `item_tooltip` = 'Frost Lotus\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0057|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A57|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0048|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A48|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A105', `item_level` = '80', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Frost Lotus', `item_parent` = 'Bank Bag3', `item_slot` = '10', `item_color` = '1eff00', `item_id` = '36908:0:0:0:0:0:0:1588047360:85:0', `item_texture` = 'inv_misc_herb_frostlotus', `item_quantity` = '20', `item_tooltip` = 'Frost Lotus\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0057|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A57|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0048|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A48|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A105', `item_level` = '80', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Frost Lotus', `item_parent` = 'Bank Bag3', `item_slot` = '11', `item_color` = '1eff00', `item_id` = '36908:0:0:0:0:0:0:1438101312:85:0', `item_texture` = 'inv_misc_herb_frostlotus', `item_quantity` = '8', `item_tooltip` = 'Frost Lotus\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0057|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A57|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0048|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A48|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A105', `item_level` = '80', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '2', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Mote of Life', `item_parent` = 'Bank Bag3', `item_slot` = '12', `item_color` = 'ffffff', `item_id` = '22575:0:0:0:0:0:0:-1399341056:85:0', `item_texture` = 'inv_elemental_mote_life01', `item_quantity` = '9', `item_tooltip` = 'Mote of Life\nUse: Turn ten Motes of Life into Primal Life. (0 Sec Cooldown)\n \n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F003|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A3|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F009|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A9|cFFFFFFFF)\n|cFF00FF00Pagans of Dawn |cFF00FF9A|cFFFFFFFF(Guild Bank: |cFF00FF9A9|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A21', `item_level` = '65', `item_type` = 'Trade Goods', `item_subtype` = 'Elemental', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Goldclover', `item_parent` = 'Bank Bag3', `item_slot` = '13', `item_color` = 'ffffff', `item_id` = '36901:0:0:0:0:0:0:-2116022784:85:0', `item_texture` = 'inv_misc_herb_goldclover', `item_quantity` = '20', `item_tooltip` = 'Goldclover\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F002|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A2|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0076|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A76|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A78', `item_level` = '72', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0005 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Goldclover', `item_parent` = 'Bank Bag3', `item_slot` = '14', `item_color` = 'ffffff', `item_id` = '36901:0:0:0:0:0:0:-1984536320:85:0', `item_texture` = 'inv_misc_herb_goldclover', `item_quantity` = '20', `item_tooltip` = 'Goldclover\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F002|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A2|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0076|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A76|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A78', `item_level` = '72', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Goldclover', `item_parent` = 'Bank Bag3', `item_slot` = '15', `item_color` = 'ffffff', `item_id` = '36901:0:0:0:0:0:0:1787860992:85:0', `item_texture` = 'inv_misc_herb_goldclover', `item_quantity` = '20', `item_tooltip` = 'Goldclover\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F002|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A2|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0076|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A76|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A78', `item_level` = '72', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Goldclover', `item_parent` = 'Bank Bag3', `item_slot` = '16', `item_color` = 'ffffff', `item_id` = '36901:0:0:0:0:0:0:336778608:85:0', `item_texture` = 'inv_misc_herb_goldclover', `item_quantity` = '16', `item_tooltip` = 'Goldclover\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F002|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A2|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0076|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A76|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A78', `item_level` = '72', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Dreaming Glory', `item_parent` = 'Bank Bag3', `item_slot` = '17', `item_color` = 'ffffff', `item_id` = '22786:0:0:0:0:0:0:-1763099648:85:0', `item_texture` = 'inv_misc_herb_dreamingglory', `item_quantity` = '20', `item_tooltip` = 'Dreaming Glory\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0015|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A15|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0071|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A71|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A86', `item_level` = '60', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0003 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Dreaming Glory', `item_parent` = 'Bank Bag3', `item_slot` = '18', `item_color` = 'ffffff', `item_id` = '22786:0:0:0:0:0:0:1458496064:85:0', `item_texture` = 'inv_misc_herb_dreamingglory', `item_quantity` = '20', `item_tooltip` = 'Dreaming Glory\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0015|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A15|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0071|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A71|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A86', `item_level` = '60', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Dreaming Glory', `item_parent` = 'Bank Bag3', `item_slot` = '19', `item_color` = 'ffffff', `item_id` = '22786:0:0:0:0:0:0:-2022019072:85:0', `item_texture` = 'inv_misc_herb_dreamingglory', `item_quantity` = '11', `item_tooltip` = 'Dreaming Glory\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0015|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A15|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0071|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A71|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A86', `item_level` = '60', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0005 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Dreaming Glory', `item_parent` = 'Bank Bag3', `item_slot` = '20', `item_color` = 'ffffff', `item_id` = '22786:0:0:0:0:0:0:1338500096:85:0', `item_texture` = 'inv_misc_herb_dreamingglory', `item_quantity` = '20', `item_tooltip` = 'Dreaming Glory\n \n \n|cFFF58CBAGreymouser |cFF00FF9A|cFFFF7F0015|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A15|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F0071|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A71|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A86', `item_level` = '60', `item_type` = 'Trade Goods', `item_subtype` = 'Herb', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0006 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Netherweave Bag', `item_parent` = 'bags', `item_slot` = 'Bank Bag6', `item_color` = '1eff00', `item_id` = '21841:0:0:0:0:0:0:1957058606:85:0', `item_texture` = 'inv_misc_bag_23_netherweave', `item_quantity` = '16', `item_tooltip` = 'Netherweave Bag\nSoulbound\n16 Slot Bag\n|cff00ff00|r\n \n \n|cFFC41F3BBleys |cFF00FF9A|cFFFF7F002|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A2|cFFFFFFFF)\n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A3\n \n|cFFFFD700Source: |cFF00FF9ATailoring, 315', `item_level` = '', `item_type` = '', `item_subtype` = '', `item_rarity` = '', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Chilled Abomination Guts', `item_parent` = 'Bank Bag6', `item_slot` = '1', `item_color` = 'ffffff', `item_id` = '43966:0:0:0:0:0:0:560328608:85:0', `item_texture` = 'inv_misc_organ_11', `item_quantity` = '1', `item_tooltip` = 'Chilled Abomination Guts\nQuest Item\nUnique\n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1', `item_level` = '0', `item_type` = 'Quest', `item_subtype` = 'Quest', `item_rarity` = '1', `locale` = 'enUS'; 1145 0.0004 INSERT INTO `roster_items` SET `member_id` = '7', `item_name` = 'Abomination Reanimation Kit', `item_parent` = 'Bank Bag6', `item_slot` = '2', `item_color` = 'ffffff', `item_id` = '43968:0:0:0:0:0:0:278496480:85:0', `item_texture` = 'inv_misc_bag_felclothbag', `item_quantity` = '1', `item_tooltip` = 'Abomination Reanimation Kit\nQuest Item\nUnique\nUse: Uses Chilled Abomination Guts to create a Reanimated Abomination that will obey your command for a short time. (20 Sec Cooldown)\n\"Add guts and shake vigorously.\"\n \n|cFFABD473Tomofinland |cFF00FF9A|cFFFF7F001|cFFFFFFFF (|cFFFFFFFFBank: |cFF00FF9A1|cFFFFFFFF)\n|cFFFFD700Total owned: |cFF00FF9A1', `item_level` = '0', `item_type` = 'Quest', `item_subtype` = 'Quest', `item_rarity` = '1', `locale` = 'enUS'; 2017 0.0004 DELETE FROM `roster_mailbox` WHERE `member_id` = '7'; 2026 0.0018 DELETE FROM `roster_items` WHERE `member_id` = '7' AND UPPER(`item_parent`) LIKE 'MAIL%'; 2301 0.0006 DELETE FROM `roster_skills` WHERE `member_id` = '7'; 2326 0.0002 INSERT INTO `roster_skills` SET `member_id` = '7', `skill_type` = 'Professions', `skill_name` = 'Herbalism', `skill_order` = '1', `skill_level` = '525:525'; 2326 0.0001 INSERT INTO `roster_skills` SET `member_id` = '7', `skill_type` = 'Professions', `skill_name` = 'Alchemy', `skill_order` = '1', `skill_level` = '525:525'; 2326 0.0002 INSERT INTO `roster_skills` SET `member_id` = '7', `skill_type` = 'Secondary Skills', `skill_name` = 'Cooking', `skill_order` = '2', `skill_level` = '477:525'; 2326 0.0002 INSERT INTO `roster_skills` SET `member_id` = '7', `skill_type` = 'Secondary Skills', `skill_name` = 'First Aid', `skill_order` = '2', `skill_level` = '459:525'; 2326 0.0001 INSERT INTO `roster_skills` SET `member_id` = '7', `skill_type` = 'Secondary Skills', `skill_name` = 'Fishing', `skill_order` = '2', `skill_level` = '377:450'; 1762 0.0003 DELETE FROM `roster_recipes` WHERE `member_id` = '7'; 2379 0.0033 DELETE FROM `roster_spellbook` WHERE `member_id` = '7' AND `spell_build` = 0; 2387 0.0007 DELETE FROM `roster_spellbooktree` WHERE `member_id` = '7' AND `spell_build` = 0; 2433 0.0003 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Control Pet', `spell_texture` = 'ability_hunter_beastcall02', `spell_rank` = 'Passive', `spell_tooltip` = 'Control Pet\nAllows you to give commands to control your pet.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Bestial Wrath', `spell_texture` = 'ability_druid_ferociousbite', `spell_tooltip` = 'Bestial Wrath\n100 yd range\nInstant 1.17 min cooldown\nSend your pet into a rage causing 20% additional damage for 10 sec. The beast does not feel pity or remorse or fear and it cannot be stopped unless killed.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Aspect of the Hawk', `spell_texture` = 'spell_nature_ravenform', `spell_tooltip` = 'Aspect of the Hawk\nInstant 1 sec cooldown\nThe Hunter takes on the aspects of a hawk, increasing ranged attack power by 2600. Only one Aspect can be active at a time.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Fervor', `spell_texture` = 'ability_hunter_aspectoftheviper', `spell_tooltip` = 'Fervor\nInstant 2 min cooldown\nInstantly restores 50 Focus to you and your pet.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Feed Pet', `spell_texture` = 'ability_hunter_beasttraining', `spell_tooltip` = 'Feed Pet\n10 yd range\nInstant 10 sec cooldown\nFeed your pet the selected item, instantly restoring 50% of its total health. Cannot be used while in combat.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Scare Beast', `spell_texture` = 'ability_druid_cower', `spell_tooltip` = 'Scare Beast\n25 Focus 30 yd range\n1.43 sec cast\nScares a beast, causing it to run in fear for up to 20 sec. Damage caused may interrupt the effect. Only one beast can be feared at a time.' 2433 0.0003 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Aspect of the Fox', `spell_texture` = 'ability_hunter_aspectofthefox', `spell_tooltip` = 'Aspect of the Fox\nInstant 1 sec cooldown\nThe Hunter takes on the aspects of a fox, allowing him to shoot Steady Shot and Cobra Shot while moving and causing him to gain 5 Focus whenever you receive a melee attack.' 2433 0.0003 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Revive Pet', `spell_texture` = 'ability_hunter_beastsoothe', `spell_tooltip` = 'Revive Pet\n35 Focus\n9.53 sec cast\nRevive your pet, returning it to life with 15% of its base health.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Mend Pet', `spell_texture` = 'ability_hunter_mendpet', `spell_tooltip` = 'Mend Pet\n45 yd range\nInstant\nHeals your pet for 25% of its total health over 10 sec.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Widow Venom', `spell_texture` = 'ability_hunter_potentvenom', `spell_tooltip` = 'Widow Venom\n15 Focus 5-40 yd range\nInstant cast\nRequires Ranged Weapon\nA venomous shot that reduces the effectiveness of any healing taken for 30 sec.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Tame Beast', `spell_texture` = 'ability_hunter_beasttaming', `spell_tooltip` = 'Tame Beast\n30 yd range\nChanneled\nBegins taming a beast to be your companion. If you lose the beast\'s attention for any reason, the taming process will fail.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Aspect of the Pack', `spell_texture` = 'ability_mount_whitetiger', `spell_tooltip` = 'Aspect of the Pack\nInstant 1 sec cooldown\nThe Hunter and raid members within 55 yards take on the aspects of a pack of cheetahs, increasing movement speed by 30%. If you are struck under the effect of this aspect, you will be dazed for 4 sec. Only one Aspect can be active at a time.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Animal Handler', `spell_texture` = 'ability_hunter_animalhandler', `spell_rank` = 'Passive', `spell_tooltip` = 'Animal Handler\nAttack Power increased by 25%.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Beast Lore', `spell_texture` = 'ability_physical_taunt', `spell_tooltip` = 'Beast Lore\n40 yd range\nInstant\nGather information about the target beast. The tooltip will display damage, health, armor, any special resistances, and diet. In addition, Beast Lore will reveal whether or not the creature is tameable and what abilities the tamed creature has.' 2433 0.0001 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Eagle Eye', `spell_texture` = 'ability_hunter_eagleeye', `spell_tooltip` = 'Eagle Eye\nUnlimited range\nChanneled\nZooms in the Hunter\'s vision. Only usable outdoors. Lasts 1 min.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Master\'s Call', `spell_texture` = 'ability_hunter_masterscall', `spell_tooltip` = 'Master\'s Call\n40 yd range\nInstant 45 sec cooldown\nYour pet attempts to remove all root and movement impairing effects from itself and its target, and causes your pet and its target to be immune to all such effects for 4 sec.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Kill Command', `spell_texture` = 'ability_hunter_killcommand', `spell_tooltip` = 'Kill Command\n40 Focus\nInstant cast 6 sec cooldown\nGive the command to kill, causing your pet to instantly inflict 8805 damage to its target.\n\nThe pet must be in combat and within 5 yards of the target to Kill Command.' 2433 0.0001 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Intimidation', `spell_texture` = 'ability_devour', `spell_tooltip` = 'Intimidation\nInstant 42 sec cooldown\nCommand your pet to intimidate the target, causing a high amount of threat and stunning the target for 3 sec. Lasts 15 sec.' 2433 0.0003 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Aspect of the Cheetah', `spell_texture` = 'ability_mount_jungletiger', `spell_tooltip` = 'Aspect of the Cheetah\nInstant 1 sec cooldown\nThe Hunter takes on the aspects of a cheetah, increasing movement speed by 30%. If the Hunter is struck, he will be dazed for 4 sec. Only one Aspect can be active at a time.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Dismiss Pet', `spell_texture` = 'spell_nature_spiritwolf', `spell_tooltip` = 'Dismiss Pet\n2 sec cast\nTemporarily sends this pet away. You can call it back later.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_name` = 'Aspect of the Wild', `spell_texture` = 'spell_nature_protectionformnature', `spell_tooltip` = 'Aspect of the Wild\nInstant 1 sec cooldown\nThe Hunter, group and raid members within 30 yards take on the aspect of the wild, increasing Nature resistance by 195. Only one Aspect can be active at a time.' 2448 0.0002 INSERT INTO `roster_spellbooktree` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Beast Mastery', `spell_texture` = 'ability_hunter_bestialdiscipline' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Master Riding', `spell_texture` = 'spell_nature_swiftness', `spell_rank` = 'Master', `spell_tooltip` = 'Master Riding\nYou can now ride at the highest possible speed on your flying mount.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Wisp Spirit', `spell_texture` = 'spell_nature_wispsplode', `spell_rank` = 'Racial Passive', `spell_tooltip` = 'Wisp Spirit\nTransform into a wisp upon death, increasing speed by 75%.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Elusiveness', `spell_texture` = 'ability_racial_ultravision', `spell_rank` = 'Racial Passive', `spell_tooltip` = 'Elusiveness\nReduces the chance enemies have to detect you while Shadowmelded and increases your speed while stealthed by 5%.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Armor Skills', `spell_texture` = 'inv_chest_chain_06', `spell_rank` = 'Passive', `spell_tooltip` = 'Armor Skills\nHunters can wear cloth and leather armor. At level 40, they can also receive training to wear mail.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Shadowmeld', `spell_texture` = 'ability_ambush', `spell_rank` = 'Racial', `spell_tooltip` = 'Shadowmeld\nInstant 2 min cooldown\nActivate to slip into the shadows, reducing the chance for enemies to detect your presence. Lasts until cancelled or upon moving. Any threat is restored versus enemies still in combat upon cancellation of this effect.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Quickness', `spell_texture` = 'ability_racial_shadowmeld', `spell_rank` = 'Racial Passive', `spell_tooltip` = 'Quickness\nReduces the chance that melee and ranged attackers will hit you by 2%.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Mastery', `spell_texture` = 'spell_holy_championsbond', `spell_rank` = 'Passive', `spell_tooltip` = 'Mastery\n|CFFFFFFFFMaster of Beasts|R\nIncreases the damage done by your pets by 24%. Each point of Mastery increases pet damage by an additional 1.67%.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Nature Resistance', `spell_texture` = 'spell_nature_spiritarmor', `spell_rank` = 'Racial Passive', `spell_tooltip` = 'Nature Resistance\nIncreases your resistance to harmful Nature effects by 85.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Cold Weather Flying', `spell_texture` = 'spell_frost_arcticwinds', `spell_rank` = 'Passive', `spell_tooltip` = 'Cold Weather Flying\nAllows you to ride flying mounts in Northrend.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Flight Master\'s License', `spell_texture` = 'inv_scroll_11', `spell_rank` = 'Passive', `spell_tooltip` = 'Flight Master\'s License\nAllows you to ride flying mounts in Eastern Kingdoms, Kalimdor, and Deepholm.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Mail Specialization', `spell_texture` = 'inv_chest_chain_11', `spell_rank` = 'Passive', `spell_tooltip` = 'Mail Specialization\nIncreases your Agility by 5% while wearing Mail in all armor slots.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Dual Wield', `spell_texture` = 'ability_dualwield', `spell_rank` = 'Passive', `spell_tooltip` = 'Dual Wield\nAllows one-hand and off-hand weapons to be equipped in the off-hand.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Languages', `spell_texture` = 'inv_misc_note_05', `spell_rank` = 'Racial Passive', `spell_tooltip` = 'Languages\nCommon, Darnassian.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Auto Attack', `spell_texture` = 'inv_staff_116', `spell_tooltip` = 'Auto Attack\nAutomatically attacks a target in melee with an equipped weapon. This ability can be toggled on or off.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Artisan Riding', `spell_texture` = 'spell_nature_swiftness', `spell_rank` = 'Artisan', `spell_tooltip` = 'Artisan Riding\nYou can now learn to ride fast flying mounts from your riding trainer.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_name` = 'Weapon Skills', `spell_texture` = 'inv_weapon_bow_02', `spell_rank` = 'Passive', `spell_tooltip` = 'Weapon Skills\nHunters can use the following weapons:\n\n-- Melee --\nAxes\nDaggers\nFist Weapons\nPolearms\nStaves\nSwords\n\n-- Ranged --\nBows\nCrossbows\nGuns' 2448 0.0002 INSERT INTO `roster_spellbooktree` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'General', `spell_texture` = 'spellbook-icon' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Cobra Shot', `spell_texture` = 'ability_hunter_cobrashot', `spell_tooltip` = 'Cobra Shot\n5-40 yd range\n1.89 sec cast\nRequires Ranged Weapon\nDeals weapon damage plus 481 in the form of Nature damage and increases the duration of your Serpent Sting on the target by 6 sec. Generates 9 Focus.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Feign Death', `spell_texture` = 'ability_rogue_feigndeath', `spell_tooltip` = 'Feign Death\nInstant 25 sec cooldown\nFeign death, tricking enemies into ignoring you. Lasts up to 6 min.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Serpent Sting', `spell_texture` = 'ability_hunter_quickshot', `spell_tooltip` = 'Serpent Sting\n25 Focus 5-40 yd range\nInstant cast\nRequires Ranged Weapon\nCauses 7108 Nature damage over 15 sec.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Scatter Shot', `spell_texture` = 'ability_golemstormbolt', `spell_tooltip` = 'Scatter Shot\n20 yd range\nInstant cast 30 sec cooldown\nRequires Ranged Weapon\nA short-range shot that deals 50% weapon damage and disorients the target for 4 sec. Any damage caused will remove the effect. Turns off your attack when used.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Disengage', `spell_texture` = 'ability_rogue_feint', `spell_tooltip` = 'Disengage\nInstant 25 sec cooldown\nYou attempt to disengage from combat, leaping backwards. Can only be used while in combat.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Raptor Strike', `spell_texture` = 'ability_meleedamage', `spell_tooltip` = 'Raptor Strike\nMelee Range\nInstant 6 sec cooldown\nRequires Melee Weapon\nAn attack that instantly deals your normal weapon damage plus 374.' 2433 0.0004 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Ice Trap', `spell_texture` = 'spell_frost_freezingbreath', `spell_rank` = 'Frost', `spell_tooltip` = 'Ice Trap\nInstant 30 sec cooldown\nPlace a frost trap that creates an ice slick around itself for 39 sec when the first enemy approaches it. All enemies within 10 yards will be slowed by 50% while in the area of effect. Trap will exist for 1 min.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Camouflage', `spell_texture` = 'ability_hunter_displacement', `spell_tooltip` = 'Camouflage\n20 Focus\nInstant 1 min cooldown\nYou blend into your surroundings, causing you and your pet to be untargetable by ranged attacks. Also reduces the range at which enemy creatures can detect you, and provides stealth while stationary.\n\nYou can lay traps while camouflaged, but any damage done by you or your pet will cancel the effect. Cannot be cast while in combat. Lasts for 1 min.' 2433 0.0004 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Immolation Trap', `spell_texture` = 'spell_fire_flameshock', `spell_rank` = 'Fire', `spell_tooltip` = 'Immolation Trap\nInstant 30 sec cooldown\nPlace a fire trap that will burn the first enemy to approach for 4947 Fire damage over 15 sec. Trap will exist for 1 min.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Parry', `spell_texture` = 'ability_parry', `spell_rank` = 'Passive', `spell_tooltip` = 'Parry\nRequires Melee Weapon\nGives a chance to parry enemy melee attacks.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Snake Trap', `spell_texture` = 'ability_hunter_snaketrap', `spell_rank` = 'Nature', `spell_tooltip` = 'Snake Trap\nInstant 30 sec cooldown\nPlace a nature trap that will release several venomous snakes to attack the first enemy to approach. The snakes will die after 15 sec. Trap will exist for 1 min.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Wing Clip', `spell_texture` = 'ability_rogue_trip', `spell_tooltip` = 'Wing Clip\nMelee Range\nInstant\nRequires Melee Weapon\nMaims the enemy, reducing the target\'s movement speed by 50% for 10 sec.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Deterrence', `spell_texture` = 'ability_whirlwind', `spell_tooltip` = 'Deterrence\nInstant 2 min cooldown\nWhen activated, increases the chance melee attacks will miss you by 100%, reduces the chance ranged attacks will hit you by 100% and grants a 100% chance to deflect spells. While Deterrence is active, you cannot attack. Lasts 5 sec.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Explosive Trap', `spell_texture` = 'spell_fire_selfdestruct', `spell_rank` = 'Fire', `spell_tooltip` = 'Explosive Trap\nInstant 30 sec cooldown\nPlace a fire trap that explodes when an enemy approaches, causing 879 Fire damage and burning all enemies for 8910 additional Fire damage over 20 sec to all within 10 yards. Trap will exist for 1 min.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Trap Launcher', `spell_texture` = 'ability_hunter_traplauncher', `spell_tooltip` = 'Trap Launcher\n20 Focus\nInstant 1.5 sec cooldown\nWhen used, your next Trap can be launched to a target location within 40 yards. Lasts for 15 sec.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Freezing Trap', `spell_texture` = 'spell_frost_chainsofice', `spell_rank` = 'Frost', `spell_tooltip` = 'Freezing Trap\nInstant 30 sec cooldown\nPlace a frost trap that freezes the first enemy that approaches, preventing all action for up to 1.30 min. Any damage caused will break the ice. Only one target can be Freezing Trapped at a time. Trap will exist for 1 min.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_name` = 'Misdirection', `spell_texture` = 'ability_hunter_misdirection', `spell_tooltip` = 'Misdirection\n100 yd range\nInstant 30 sec cooldown\nThe current party or raid member targeted will receive the threat caused by your next damaging attack and all actions taken for 4 sec afterwards. Transferred threat is not permanent, and will fade after 30 sec.' 2448 0.0002 INSERT INTO `roster_spellbooktree` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Survival', `spell_texture` = 'ability_hunter_camouflage' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_name` = 'Distracting Shot', `spell_texture` = 'spell_arcane_blink', `spell_tooltip` = 'Distracting Shot\n5-40 yd range\nInstant cast 8 sec cooldown\nRequires Ranged Weapon\nDistracts the target to attack you, but has no effect if the target is already attacking you. Lasts 6 sec.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_name` = 'Flare', `spell_texture` = 'spell_fire_flare', `spell_tooltip` = 'Flare\n40 yd range\nInstant 20 sec cooldown\nExposes all hidden and invisible enemies within 10 yards of the targeted area for 20 sec.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_name` = 'Rapid Fire', `spell_texture` = 'ability_hunter_runningshot', `spell_tooltip` = 'Rapid Fire\nInstant 5 min cooldown\nIncreases ranged attack speed by 50% for 15 sec.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_name` = 'Auto Shot', `spell_texture` = 'inv_weapon_rifle_43', `spell_tooltip` = 'Auto Shot\n5-40 yd range\nInstant cast 2.65 sec cooldown\nRequires Ranged Weapon\nAutomatically shoots the target until cancelled.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_name` = 'Arcane Shot', `spell_texture` = 'ability_impalingbolt', `spell_tooltip` = 'Arcane Shot\n25 Focus 5-40 yd range\nInstant cast\nRequires Ranged Weapon\nAn instant shot that causes 100% weapon damage plus 871 as Arcane damage.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_name` = 'Steady Shot', `spell_texture` = 'ability_hunter_steadyshot', `spell_tooltip` = 'Steady Shot\n5-40 yd range\n1.89 sec cast\nRequires Ranged Weapon\nA steady shot that causes 100% weapon damage plus 532. Generates 9 Focus.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_name` = 'Kill Shot', `spell_texture` = 'ability_hunter_assassinate2', `spell_tooltip` = 'Kill Shot\n5-45 yd range\nInstant cast 10 sec cooldown\nRequires Ranged Weapon\nYou attempt to finish the wounded target off, firing a long range attack dealing 150% weapon damage plus 4421. Kill Shot can only be used on enemies that have 20% or less health.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_name` = 'Hunter\'s Mark', `spell_texture` = 'ability_hunter_snipershot', `spell_tooltip` = 'Hunter\'s Mark\n100 yd range\nInstant\nPlaces the Hunter\'s Mark on the target, increasing the ranged attack power of all attackers against that target by 1772. In addition, the target of this ability can always be seen by the hunter whether it stealths or turns invisible. The target also appears on the mini-map. Lasts for 5 min.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_name` = 'Concussive Shot', `spell_texture` = 'spell_frost_stun', `spell_tooltip` = 'Concussive Shot\n5-40 yd range\nInstant cast 5 sec cooldown\nRequires Ranged Weapon\nDazes the target, slowing movement speed by 50% for 6 sec.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_name` = 'Multi-Shot', `spell_texture` = 'ability_upgrademoonglaive', `spell_tooltip` = 'Multi-Shot\n40 Focus 5-40 yd range\nInstant cast\nRequires Ranged Weapon\nFires several missiles, hitting your current target and all enemies within 8 yards of that target for 120% of weapon damage.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_name` = 'Tranquilizing Shot', `spell_texture` = 'spell_nature_drowsy', `spell_tooltip` = 'Tranquilizing Shot\n20 Focus 5-35 yd range\nInstant cast\nRequires Ranged Weapon\nAttempts to remove 1 Enrage and 1 Magic effect from an enemy target.' 2448 0.0002 INSERT INTO `roster_spellbooktree` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'Marksmanship', `spell_texture` = 'ability_hunter_focusedaim' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'All - Guild Perks', `spell_name` = 'Fast Track', `spell_texture` = 'achievement_guildperk_fasttrack', `spell_rank` = 'Rank 1', `spell_tooltip` = 'Fast Track\nExperience gained from killing monsters and completing quests increased by 5%.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'All - Guild Perks', `spell_name` = 'Mount Up', `spell_texture` = 'achievement_guildperk_mountup', `spell_tooltip` = 'Mount Up\nIncreases speed while mounted by 10%. Not active in Battlegrounds or Arenas.' 2433 0.0002 INSERT INTO `roster_spellbook` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'All - Guild Perks', `spell_name` = 'Mr. Popularity', `spell_texture` = 'achievement_guildperk_mrpopularity', `spell_rank` = 'Rank 1', `spell_tooltip` = 'Mr. Popularity\nReputation gained from killing monsters and completing quests increased by 5%.' 2448 0.0002 INSERT INTO `roster_spellbooktree` SET `member_id` = '7', `spell_build` = '0', `spell_type` = 'All - Guild Perks', `spell_texture` = 'achievement_guildperk_fasttrack_rank2' 2632 0.0006 DELETE FROM `roster_glyphs` WHERE `member_id` = '7' AND `glyph_build` = 0; 2663 0.0002 INSERT INTO `roster_glyphs` SET `member_id` = '7', `glyph_name` = 'Glyph of Bestial Wrath', `glyph_type` = '1', `glyph_build` = '0', `glyph_icon` = 'ability_druid_ferociousbite', `glyph_tooltip` = 'Glyph of Bestial Wrath\nMajor Glyph\nDecreases the cooldown of Bestial Wrath by 20 sec.\n', `glyph_order` = '1'; 2663 0.0002 INSERT INTO `roster_glyphs` SET `member_id` = '7', `glyph_name` = 'Glyph of Revive Pet', `glyph_type` = '2', `glyph_build` = '0', `glyph_icon` = 'ability_hunter_beastsoothe', `glyph_tooltip` = 'Glyph of Revive Pet\nMinor Glyph\nReduces the pushback suffered from damaging attacks while casting Revive Pet by 100%.\n', `glyph_order` = '2'; 2663 0.0002 INSERT INTO `roster_glyphs` SET `member_id` = '7', `glyph_name` = 'Glyph of Feign Death', `glyph_type` = '2', `glyph_build` = '0', `glyph_icon` = 'ability_rogue_feigndeath', `glyph_tooltip` = 'Glyph of Feign Death\nMinor Glyph\nReduces the cooldown of your Feign Death spell by 5 sec.\n', `glyph_order` = '3'; 2663 0.0001 INSERT INTO `roster_glyphs` SET `member_id` = '7', `glyph_name` = 'Glyph of Snake Trap', `glyph_type` = '1', `glyph_build` = '0', `glyph_icon` = 'ability_hunter_snaketrap', `glyph_tooltip` = 'Glyph of Snake Trap\nMajor Glyph\nSnakes from your Snake Trap take 90% reduced damage from area of effect spells.\n', `glyph_order` = '4'; 2663 0.0002 INSERT INTO `roster_glyphs` SET `member_id` = '7', `glyph_name` = 'Glyph of Aspect of the Pack', `glyph_type` = '2', `glyph_build` = '0', `glyph_icon` = 'ability_mount_whitetiger', `glyph_tooltip` = 'Glyph of Aspect of the Pack\nMinor Glyph\nIncreases the range of your Aspect of the Pack ability by 15 yards.\n', `glyph_order` = '5'; 2663 0.0001 INSERT INTO `roster_glyphs` SET `member_id` = '7', `glyph_name` = 'Glyph of Wyvern Sting', `glyph_type` = '1', `glyph_build` = '0', `glyph_icon` = 'inv_spear_02', `glyph_tooltip` = 'Glyph of Wyvern Sting\nMajor Glyph\nDecreases the cooldown of your Wyvern Sting by 6 sec.\n', `glyph_order` = '6'; 2663 0.0002 INSERT INTO `roster_glyphs` SET `member_id` = '7', `glyph_name` = 'Glyph of Rapid Fire', `glyph_type` = '3', `glyph_build` = '0', `glyph_icon` = 'ability_hunter_runningshot', `glyph_tooltip` = 'Glyph of Rapid Fire\nPrime Glyph\nIncreases the haste from Rapid Fire by an additional 10%.\n', `glyph_order` = '7'; 2663 0.0002 INSERT INTO `roster_glyphs` SET `member_id` = '7', `glyph_name` = 'Glyph of Kill Shot', `glyph_type` = '3', `glyph_build` = '0', `glyph_icon` = 'ability_hunter_assassinate2', `glyph_tooltip` = 'Glyph of Kill Shot\nPrime Glyph\nIf the damage from your Kill Shot fails to kill a target at or below 20% health, your Kill Shot\'s cooldown is instantly reset. This effect has a 6 sec cooldown.\n', `glyph_order` = '8'; 2663 0.0002 INSERT INTO `roster_glyphs` SET `member_id` = '7', `glyph_name` = 'Glyph of Serpent Sting', `glyph_type` = '3', `glyph_build` = '0', `glyph_icon` = 'ability_hunter_quickshot', `glyph_tooltip` = 'Glyph of Serpent Sting\nPrime Glyph\nIncreases the periodic critical strike chance of your Serpent Sting by 6%.\n', `glyph_order` = '9'; 2714 0.0003 DELETE FROM `roster_talents` WHERE `member_id` = '7' AND `build` = 0; 2721 0.0004 DELETE FROM `roster_talenttree` WHERE `member_id` = '7' AND `build` = 0; 2727 0.0004 DELETE FROM `roster_talent_builds` WHERE `member_id` = '7' AND `build` = 0; 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Master Marksman', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Master Marksman', `row` = '6', `column` = '3', `rank` = '0', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Readiness', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Readiness', `row` = '6', `column` = '5', `rank` = '0', `maxrank` = '1' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Trueshot Aura', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Trueshot Aura', `row` = '5', `column` = '3', `rank` = '0', `maxrank` = '1' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Silencing Shot', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Silencing Shot', `row` = '4', `column` = '2', `rank` = '0', `maxrank` = '1' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Concussive Barrage', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Concussive Barrage', `row` = '4', `column` = '3', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Bombardment', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Bombardment', `row` = '5', `column` = '2', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Piercing Shots', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Piercing Shots', `row` = '4', `column` = '4', `rank` = '0', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Chimera Shot', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Chimera Shot', `row` = '8', `column` = '3', `rank` = '0', `maxrank` = '1' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Efficiency', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Efficiency', `row` = '2', `column` = '3', `rank` = '0', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Careful Aim', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Careful Aim', `row` = '3', `column` = '4', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Go for the Throat', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Go for the Throat', `row` = '2', `column` = '2', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Sic \'Em!', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Sic \'Em!', `row` = '3', `column` = '2', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Marked for Death', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Marked for Death', `row` = '7', `column` = '4', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Improved Steady Shot', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Improved Steady Shot', `row` = '3', `column` = '3', `rank` = '0', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Resistance is Futile', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Resistance is Futile', `row` = '5', `column` = '5', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Rapid Killing', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Rapid Killing', `row` = '2', `column` = '4', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Termination', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Termination', `row` = '5', `column` = '4', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Posthaste', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Posthaste', `row` = '7', `column` = '2', `rank` = '0', `maxrank` = '2' 2788 0.0003 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Rapid Recuperation', `tree` = 'Marksmanship', `build` = '0', `tooltip` = 'Rapid Recuperation', `row` = '6', `column` = '2', `rank` = '0', `maxrank` = '2' 2806 0.0002 INSERT INTO `roster_talenttree` SET `member_id` = '7', `tree` = 'Marksmanship', `background` = 'huntermarksmanship', `pointsspent` = '0', `order` = '2', `build` = '0' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Beast Mastery', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Beast Mastery', `row` = '8', `column` = '3', `rank` = '1', `maxrank` = '1' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Bestial Wrath', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Bestial Wrath', `row` = '6', `column` = '3', `rank` = '1', `maxrank` = '1' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'One with Nature', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'One with Nature', `row` = '2', `column` = '3', `rank` = '3', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Frenzy', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Frenzy', `row` = '3', `column` = '4', `rank` = '3', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Fervor', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Fervor', `row` = '4', `column` = '3', `rank` = '1', `maxrank` = '1' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Improved Kill Command', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Improved Kill Command', `row` = '2', `column` = '2', `rank` = '2', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Longevity', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Longevity', `row` = '5', `column` = '2', `rank` = '3', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Bestial Discipline', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Bestial Discipline', `row` = '2', `column` = '4', `rank` = '3', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Cobra Strikes', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Cobra Strikes', `row` = '4', `column` = '2', `rank` = '3', `maxrank` = '3' 2788 0.0001 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'The Beast Within', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'The Beast Within', `row` = '7', `column` = '3', `rank` = '1', `maxrank` = '1' 2788 0.0001 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Ferocious Inspiration', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Ferocious Inspiration', `row` = '6', `column` = '4', `rank` = '1', `maxrank` = '1' 2788 0.0001 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Kindred Spirits', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Kindred Spirits', `row` = '7', `column` = '2', `rank` = '2', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Crouching Tiger, Hidden Chimera', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Crouching Tiger, Hidden Chimera', `row` = '6', `column` = '2', `rank` = '1', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Improved Mend Pet', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Improved Mend Pet', `row` = '3', `column` = '5', `rank` = '2', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Invigoration', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Invigoration', `row` = '7', `column` = '4', `rank` = '2', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Killing Streak', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Killing Streak', `row` = '5', `column` = '4', `rank` = '2', `maxrank` = '2' 2788 0.0001 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Pathfinding', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Pathfinding', `row` = '3', `column` = '2', `rank` = '0', `maxrank` = '2' 2788 0.0001 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Focus Fire', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Focus Fire', `row` = '4', `column` = '4', `rank` = '0', `maxrank` = '1' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Spirit Bond', `tree` = 'Beast Mastery', `build` = '0', `tooltip` = 'Spirit Bond', `row` = '3', `column` = '3', `rank` = '2', `maxrank` = '2' 2806 0.0001 INSERT INTO `roster_talenttree` SET `member_id` = '7', `tree` = 'Beast Mastery', `background` = 'hunterbeastmastery', `pointsspent` = '33', `order` = '1', `build` = '0' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Pathing', `tree` = 'Survival', `build` = '0', `tooltip` = 'Pathing', `row` = '2', `column` = '3', `rank` = '0', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Survival Tactics', `tree` = 'Survival', `build` = '0', `tooltip` = 'Survival Tactics', `row` = '3', `column` = '2', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Mirrored Blades', `tree` = 'Survival', `build` = '0', `tooltip` = 'Mirrored Blades', `row` = '5', `column` = '3', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Entrapment', `tree` = 'Survival', `build` = '0', `tooltip` = 'Entrapment', `row` = '3', `column` = '4', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Improved Serpent Sting', `tree` = 'Survival', `build` = '0', `tooltip` = 'Improved Serpent Sting', `row` = '2', `column` = '4', `rank` = '2', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Resourcefulness', `tree` = 'Survival', `build` = '0', `tooltip` = 'Resourcefulness', `row` = '5', `column` = '2', `rank` = '0', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Trap Mastery', `tree` = 'Survival', `build` = '0', `tooltip` = 'Trap Mastery', `row` = '3', `column` = '3', `rank` = '3', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Point of No Escape', `tree` = 'Survival', `build` = '0', `tooltip` = 'Point of No Escape', `row` = '3', `column` = '5', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Black Arrow', `tree` = 'Survival', `build` = '0', `tooltip` = 'Black Arrow', `row` = '8', `column` = '3', `rank` = '0', `maxrank` = '1' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Serpent Spread', `tree` = 'Survival', `build` = '0', `tooltip` = 'Serpent Spread', `row` = '7', `column` = '4', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Sniper Training', `tree` = 'Survival', `build` = '0', `tooltip` = 'Sniper Training', `row` = '7', `column` = '2', `rank` = '0', `maxrank` = '3' 2788 0.0003 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Counterattack', `tree` = 'Survival', `build` = '0', `tooltip` = 'Counterattack', `row` = '4', `column` = '3', `rank` = '0', `maxrank` = '1' 2788 0.0003 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Toxicology', `tree` = 'Survival', `build` = '0', `tooltip` = 'Toxicology', `row` = '6', `column` = '2', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Lock and Load', `tree` = 'Survival', `build` = '0', `tooltip` = 'Lock and Load', `row` = '4', `column` = '4', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Wyvern Sting', `tree` = 'Survival', `build` = '0', `tooltip` = 'Wyvern Sting', `row` = '6', `column` = '3', `rank` = '0', `maxrank` = '1' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Noxious Stings', `tree` = 'Survival', `build` = '0', `tooltip` = 'Noxious Stings', `row` = '6', `column` = '4', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Hunting Party', `tree` = 'Survival', `build` = '0', `tooltip` = 'Hunting Party', `row` = '6', `column` = '5', `rank` = '0', `maxrank` = '1' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'T.N.T.', `tree` = 'Survival', `build` = '0', `tooltip` = 'T.N.T.', `row` = '5', `column` = '4', `rank` = '0', `maxrank` = '2' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Hunter vs. Wild', `tree` = 'Survival', `build` = '0', `tooltip` = 'Hunter vs. Wild', `row` = '2', `column` = '2', `rank` = '3', `maxrank` = '3' 2788 0.0002 INSERT INTO `roster_talents` SET `member_id` = '7', `name` = 'Thrill of the Hunt', `tree` = 'Survival', `build` = '0', `tooltip` = 'Thrill of the Hunt', `row` = '4', `column` = '2', `rank` = '0', `maxrank` = '3' 2806 0.0002 INSERT INTO `roster_talenttree` SET `member_id` = '7', `tree` = 'Survival', `background` = 'huntersurvival', `pointsspent` = '8', `order` = '3', `build` = '0' 2846 0.0004 SELECT * FROM `roster_talenttree` WHERE `member_id` = '7' AND `build` = '0' ORDER BY `order` ASC 2851 0.0004 SELECT * FROM `roster_talents` WHERE `member_id` = '7' AND `build` = '0' AND `tree` = 'Beast Mastery' ORDER BY `row` ASC , `column` ASC 2851 0.0006 SELECT * FROM `roster_talents` WHERE `member_id` = '7' AND `build` = '0' AND `tree` = 'Marksmanship' ORDER BY `row` ASC , `column` ASC 2851 0.0005 SELECT * FROM `roster_talents` WHERE `member_id` = '7' AND `build` = '0' AND `tree` = 'Survival' ORDER BY `row` ASC , `column` ASC 2822 0.0002 INSERT INTO `roster_talent_builds` SET `build` = '0', `member_id` = '7', `tree` = '2330232310321112121000000000000000000030203000000000000000' 2831 0.0018 DELETE FROM `roster_talents` WHERE `member_id` = '7' AND `build` = 0; 2087 0.0026 DELETE FROM `roster_reputation` WHERE `member_id` = '7'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Stormpike Guard', `curr_rep` = '100', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'The Stormpike Dwarves have set up residence in Alterac Valley, where they\'re locked in battle with the Frostwolf Orcs.'; 2189 0.0004 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'The Oracles', `curr_rep` = '999', `max_rep` = '1000', `AtWar` = '0', `Standing` = 'Exalted', `Description` = 'The gorlocs of Sholazar Basin are a race of reptilian creatures who see themselves as guardians of the titan technology that remains in the zone (though they understand little of it). They find themselves in an escalating territorial war with the wolvar.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Ogri\'la', `curr_rep` = '0', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'The enlightened denizens of Ogri\'la have made their dwelling in the western Blade\'s Edge Mountains, where proximity to apexis crystals has caused them to transcend their brutish ogre nature.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'The Kalu\'ak', `curr_rep` = '999', `max_rep` = '1000', `AtWar` = '0', `Standing` = 'Exalted', `Description` = 'The tuskarr are a tough but peaceful people who derive their livelihood from fishing and whaling. Their settlements have recently come under fierce attack and welcome any allies who would come to their aid.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Ratchet', `curr_rep` = '2070', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'Part of the Steamwheedle Cartel, this goblin city provides a neutral haven for those that wish to trade goods and services in the Barrens.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'The Frostborn', `curr_rep` = '230', `max_rep` = '6000', `AtWar` = '0', `Standing` = 'Friendly', `Description` = 'This mysterious race of frost dwarves makes their home in the Storm Peaks. They\'ve recently befriended members of the Explorers\' League and welcome Alliance members within their settlements.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Hydraxian Waterlords', `curr_rep` = '682', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'These elementals have made their home on the islands east of Azshara. Sworn enemies of the armies of Ragnaros.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Shen\'dralar', `curr_rep` = '0', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'A remnant of the once powerful elves living in Dire Maul, yet still wise and knowledgeable about great secrets. '; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Sporeggar', `curr_rep` = '12683', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'The sporelings are a mostly peaceful race of mushroom-men native to Outland. Their home is located in the southern bogs of Zangarmarsh. '; 2189 0.0003 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Valiance Expedition', `curr_rep` = '999', `max_rep` = '1000', `AtWar` = '0', `Standing` = 'Exalted', `Description` = 'The main armies of the Alliance in Northrend, moving against the Scourge and unified under King Varian Wrynn\'s command.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Gelkis Clan Centaur', `curr_rep` = '941', `max_rep` = '6000', `AtWar` = '0', `Standing` = 'Friendly', `Description` = 'These centaur have made their home in the southern region of Desolace. Mortal enemies of the Magram Centaur.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Ashtongue Deathsworn', `curr_rep` = '275', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'The elite of the Broken tribe known as the Ashtongue, officially aligned with Illidan. The Deathsworn are Akama\'s most trusted lieutenants and are privy to their leader\'s mysterious motivations.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Kurenai', `curr_rep` = '2242', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'Draenei for \"redeemed.\" These Broken have escaped the grasp of their various slavers in Outland and have made their home in Nagrand. It is there that they seek to rediscover their destiny.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Gnomeregan', `curr_rep` = '4352', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'The former denizens of Gnomeregan, now living in exile in Ironforge and in league with the Alliance.'; 2189 0.0015 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Silverwing Sentinels', `curr_rep` = '10', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'Staunch defenders of Ashenvale, locked in battle against the Warsong Outriders in Warsong Gulch.'; 2189 0.0004 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Magram Clan Centaur', `curr_rep` = '29975', `max_rep` = '36000', `AtWar` = '1', `Standing` = 'Hated', `Description` = 'These centaur have made their home in the eastern region of Desolace. Mortal enemies of the Gelkis Centaur.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'The League of Arathor', `curr_rep` = '0', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'The League of Arathor seeks to reclaim the lost land of Arathi Basin for their benefactors in Stormwind.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Thorium Brotherhood', `curr_rep` = '1425', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'The dwarves of the Thorium Brotherhood epitomize excellence in craftsmanship and are bent on unlocking the secrets of Blackrock Mountain.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Bloodsail Buccaneers', `curr_rep` = '12800', `max_rep` = '36000', `AtWar` = '1', `Standing` = 'Hated', `Description` = 'These bloodthirsty corsairs are the bane of many a merchant in the high seas. Sworn enemies of Booty Bay.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Cenarion Circle', `curr_rep` = '480', `max_rep` = '6000', `AtWar` = '0', `Standing` = 'Friendly', `Description` = 'The druids of Cenarion Circle are guardians of nature and make their home in tranquil Moonglade.'; 2189 0.0003 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Darkmoon Faire', `curr_rep` = '2550', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'A traveling fair that showcases the weird and the extraordinary. Often spotted in Elwynn Forest, Mulgore, and Terokkar Forest.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Sha\'tari Skyguard', `curr_rep` = '999', `max_rep` = '1000', `AtWar` = '0', `Standing` = 'Exalted', `Description` = 'An airborne military force created by Shattrath City to deal with the threats that loom in the highest reaches of Outland.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Frenzyheart Tribe', `curr_rep` = '0', `max_rep` = '36000', `AtWar` = '1', `Standing` = 'Hated', `Description` = 'Driven from their lands by the Scourge, this fierce tribe of wolvar stumbled upon Sholazar Basin, where they intend to make their new home. Their aggressive nature has put them at odds with the various gorloc tribes known collectively as the Oracles.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Zandalar Tribe', `curr_rep` = '0', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'These trolls have come to Yojamba Isle in an effort to recruit help against the resurrected Blood God and his Atal\'ai Priests in Zul\'Gurub.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Wintersaber Trainers', `curr_rep` = '75', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'This small group of reclusive night elves raises and trains wintersabers in the Winterspring area.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Timbermaw Hold', `curr_rep` = '2079', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'As the last uncorrupted furbolg tribe, the Timbermaw seek to preserve their spiritual ways and end the suffering of their brethren.'; 2189 0.0003 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Keepers of Time', `curr_rep` = '260', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'The Keepers of Time are bronze dragons hand-picked by Nozdormu to watch over the Caverns of Time.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Knights of the Ebon Blade', `curr_rep` = '999', `max_rep` = '1000', `AtWar` = '0', `Standing` = 'Exalted', `Description` = 'Freed from the grasp of the Lich King, his former Death Knights have regrouped against him under the banner of Highlord Darion Mograine.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'The Violet Eye', `curr_rep` = '655', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'A secret sect of the Kirin Tor founded to spy on Medivh and his activities.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'The Scale of the Sands', `curr_rep` = '0', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'A secretive subgroup of the Bronze Dragonflight, led by Soridormi, prime mate of Nozdormu.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'The Sons of Hodir', `curr_rep` = '999', `max_rep` = '1000', `AtWar` = '0', `Standing` = 'Exalted', `Description` = 'The frost giants of the Storm Peaks are a war-like race that makes their home in Dun Niffelem.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Cenarion Expedition', `curr_rep` = '2190', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'An exploratory force sent to Outland by the Cenarion Circle to study surviving life forms. The Cenarion Expedition has quickly gained in size and autonomy since the opening of the Dark Portal.'; 2189 0.0001 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Syndicate', `curr_rep` = '31325', `max_rep` = '36000', `AtWar` = '1', `Standing` = 'Hated', `Description` = 'A primarily human criminal organization that operates mostly out of the Alterac Mountains and Hillsbrad Foothills.'; 2189 0.0001 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Everlook', `curr_rep` = '3068', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'This trading post is run by the goblins of the Steamwheedle Cartel and it sits in the crossroads of Winterspring\'s main trade routes.'; 2189 0.0003 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Booty Bay', `curr_rep` = '3904', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'This booming coastal city is run by Baron Revilgaz of the Blackwater Raiders. Mortal enemies of the Bloodsail Buccaneers and part of the Steamwheedle Cartel.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'The Consortium', `curr_rep` = '4385', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'Led by Nexus-Prince Haramad, the Consortium is a loosely affiliated cartel of ethereal smugglers, traders and thieves that has come to Outland to benefit from its riches.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Ravenholdt', `curr_rep` = '55', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'This guild of thieves and assassins welcomes only those of extraordinary prowess into its fold. Sworn rivals of the Syndicate.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Shattered Sun Offensive', `curr_rep` = '999', `max_rep` = '1000', `AtWar` = '0', `Standing` = 'Exalted', `Description` = 'Shattrath City\'s final push against Prince Kael\'thas\' operations in the Sunwell.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Honor Hold', `curr_rep` = '2857', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'Vestiges of the Sons of Lothar, veterans of the Alliance that first came into Draenor, have steadfastly held on to this Hellfire outpost. They are now joined by the armies from Stormwind and Ironforge.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Inactive', `name` = 'Gadgetzan', `curr_rep` = '2933', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'Capital of the Steamwheedle Cartel and home to goblinhood\'s finest engineers, alchemists and merchants.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Guild', `name` = 'Pagans of Dawn', `curr_rep` = '8547', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'Guild reputation is your personal standing with your guild, and is required to buy guild rewards. Guild reputation is gained automatically when you earn guild experience.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Cataclysm', `name` = 'Wildhammer Clan', `curr_rep` = '4310', `max_rep` = '6000', `AtWar` = '0', `Standing` = 'Friendly', `Description` = 'The Wildhammer dwarves are known for their near-reckless courage as well as their unsurpassed gryphon-riding skills. After losing their home of Grim Batol to a Dark Iron Curse, they\'ve spread their dwellings around the Twilight Highlands.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Cataclysm', `name` = 'Baradin\'s Wardens', `curr_rep` = '4575', `max_rep` = '6000', `AtWar` = '0', `Standing` = 'Friendly', `Description` = 'Once led by Duke Reginald Baradin II, this fierce army has historic ties to the island stronghold of Tol Barad. They have joined the forces of the Alliance in an effort to repeal the Horde invaders and gain control of this strategic island.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Cataclysm', `name` = 'The Earthen Ring', `curr_rep` = '1390', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'This gathering of the most powerful shaman of Azeroth seeks to maintain the balance between the world\'s elemental forces. Their main focus during the cataclysm has been to repair and stabilize the damage caused by Deathwing\'s arrival.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Cataclysm', `name` = 'Guardians of Hyjal', `curr_rep` = '15400', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'Faced with the impending devastation of Mount Hyjal, the most powerful members of the Cenarion Circle have joined forces with their Emerald Dragonflight allies to fend off Ragnaros\' elemental hordes and the Twilight\'s Hammer.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Cataclysm', `name` = 'Avengers of Hyjal', `curr_rep` = '0', `max_rep` = '3000', `AtWar` = '0', `Standing` = 'Neutral', `Description` = 'Infuriated by the destruction wrought by the Lord of Flame, the Cenarion Circle seize the initiative, fighting back against Ragnaros and driving deep into the very heart of the Firelands.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Cataclysm', `name` = 'Ramkahen', `curr_rep` = '6490', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'The cat-like people of Ramkahen are the descendants of the Tol\'vir, guardians of Uldum. Though they\'ve lost their stone bodies, protecting the secrets of the titans is still a part of their rigid tradition.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Cataclysm', `name` = 'Therazane', `curr_rep` = '0', `max_rep` = '36000', `AtWar` = '1', `Standing` = 'Hated', `Description` = 'The elemental plane of earth, Deepholm, is ruled by Therazane and her children, the Stone Lords. After witnessing the devastation Deathwing and his followers caused her realm, Therazane treats all outsiders with open hostility.'; 2144 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Wrath of the Lich King', `parent` = 'Alliance Vanguard', `name` = 'The Silver Covenant', `curr_rep` = '3582', `max_rep` = '6000', `AtWar` = '0', `Standing` = 'Friendly', `Description` = 'A militant core of high elves that rejects the admission of blood elves into the Kirin Tor. They\'ve united under the banner of Vereesa Windrunner and joined the Alliance forces in Northrend.'; 2144 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Wrath of the Lich King', `parent` = 'Alliance Vanguard', `name` = 'Explorers\' League', `curr_rep` = '4077', `max_rep` = '6000', `AtWar` = '0', `Standing` = 'Friendly', `Description` = 'This organization seeks to find the origin of the dwarven race by collecting Titan artifacts. Their most recent research has led them to various archeological sites in Northrend.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Wrath of the Lich King', `parent` = 'Alliance Vanguard', `name` = 'Alliance Vanguard', `curr_rep` = '12312', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'The combined forces of the Alliance in Northrend, lead by the Valiance Expedition, but also including civilian groups such as the Explorer\'s League.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Wrath of the Lich King', `name` = 'The Wyrmrest Accord', `curr_rep` = '11945', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'With the Blue Dragonflight\'s violent upheaval against all mortal users of magic, the remaining dragonflights have banded under the leadership of the Red Dragonflight to combat their wayward kin.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Wrath of the Lich King', `name` = 'Kirin Tor', `curr_rep` = '4834', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'The mages and archmages running the city of Dalaran. Faced with the rising threats of the Blue Dragonflight and the Scourge, they\'ve transported their city to the heart of Northrend.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Wrath of the Lich King', `name` = 'Argent Crusade', `curr_rep` = '8985', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'Led by Tirion Fordring, the Argent Crusade combines the reformed Order of the Silver Hand with the Argent Dawn in one final push against the forces of the Lich King.'; 2144 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Classic', `parent` = 'Alliance', `name` = 'Exodar', `curr_rep` = '4317', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'The naaru vessel that brought the draenei to Azeroth. Though stranded in the Azuremyst Isles, it acts as a home city for this noble race.'; 2144 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Classic', `parent` = 'Alliance', `name` = 'Gilneas', `curr_rep` = '2293', `max_rep` = '6000', `AtWar` = '0', `Standing` = 'Friendly', `Description` = 'The people of Gilneas are a nation of survivors. Having walled themselves off from the rest of humanity, they must now face new threats from within.'; 2144 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Classic', `parent` = 'Alliance', `name` = 'Stormwind', `curr_rep` = '999', `max_rep` = '1000', `AtWar` = '0', `Standing` = 'Exalted', `Description` = 'One of the last bastions of human power, this Alliance capital is ruled by the prodigal king, Varian Wrynn.'; 2144 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Classic', `parent` = 'Alliance', `name` = 'Ironforge', `curr_rep` = '13458', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'This Alliance capital is the pride of the Dun Morogh dwarves. Home to King Magni.'; 2144 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Classic', `parent` = 'Alliance', `name` = 'Darnassus', `curr_rep` = '18401', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'This Alliance capital is populated by Night Elves and is located in the Island of Teldrassil. Ruled by the Priestess of the Moon, Tyrande Whisperwind.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Classic', `parent` = 'Alliance', `name` = 'Alliance', `curr_rep` = '6267', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = ''; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'Classic', `name` = 'Argent Dawn', `curr_rep` = '4928', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'An organization focused on protecting Azeroth from the threat of the Scourge. Strongholds of the Argent Dawn can be found in the Eastern and Western Plaguelands.'; 2144 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'The Burning Crusade', `parent` = 'Shattrath City', `name` = 'The Scryers', `curr_rep` = '10711', `max_rep` = '36000', `AtWar` = '1', `Standing` = 'Hated', `Description` = 'Voren\'thal the Seer leads the dissident blood elves who\'ve rejected Kael\'thas\' path to power. They\'ve joined forces with the naaru of Shattrath City, much to the dismay of the Aldor.'; 2144 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'The Burning Crusade', `parent` = 'Shattrath City', `name` = 'The Sha\'tar', `curr_rep` = '999', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'The Sha\'tar are a group of powerful naaru who rule over a rebuilt Shattrath City. With the help of the Aldor and the Scryers, they lead the battle against Illidan and the Burning Legion.'; 2144 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'The Burning Crusade', `parent` = 'Shattrath City', `name` = 'The Aldor', `curr_rep` = '7445', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = 'An ancient order of draenei priests once run by Velen, the Aldor are currently led by High Priestess Ishanah. They are servants of the naaru in Shattrath City known as the Sha\'tar. Rivals of the Scryers.'; 2144 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'The Burning Crusade', `parent` = 'Shattrath City', `name` = 'Lower City', `curr_rep` = '3752', `max_rep` = '12000', `AtWar` = '0', `Standing` = 'Honored', `Description` = 'The refugees of Shattrath come from diverse backgrounds and races. Word of helpful deeds spreads quickly among the Denizens of Lower City.'; 2189 0.0002 INSERT INTO `roster_reputation` SET `member_id` = '7', `faction` = 'The Burning Crusade', `parent` = 'Shattrath City', `name` = 'Shattrath City', `curr_rep` = '7445', `max_rep` = '21000', `AtWar` = '0', `Standing` = 'Revered', `Description` = ''; 2226 0.0009 DELETE FROM `roster_currency` WHERE `member_id` = '7'; 2262 0.0002 INSERT INTO `roster_currency` SET `member_id` = '7', `order` = '0', `category` = 'Player vs. Player', `name` = 'Honor Points', `count` = '285', `tooltip` = 'Honor Points\nEarned as a reward for Battlegrounds and other types of PvP and used to purchase powerful PvP armor and weapons.\n \nTotal Maximum: |cffffffff285/4000\n \n|cFFF58CBAGreymouser |cFF00FF9A24\n|cFFC41F3BBleys |cFF00FF9A163\n|cFFABD473Tomofinland |cFF00FF9A285\n|cFFABD473Kharaghiosis |cFF00FF9A339\n|cFFFF7D0AExpectations |cFF00FF9A48\n \n|cFFFFD700Total owned: |cFF00FF9A859', `icon` = 'pvpcurrency-honor-alliance'; 2262 0.0002 INSERT INTO `roster_currency` SET `member_id` = '7', `order` = '1', `category` = 'Player vs. Player', `name` = 'Tol Barad Commendation', `count` = '30', `tooltip` = 'Tol Barad Commendation\nAwarded for brave deeds performed on Tol Barad.\n \n|cFFC41F3BBleys |cFF00FF9A6\n|cFFABD473Tomofinland |cFF00FF9A30\n|cFFABD473Kharaghiosis |cFF00FF9A35\n \n|cFFFFD700Total owned: |cFF00FF9A71', `icon` = 'achievement_zone_tolbarad'; 2262 0.0003 INSERT INTO `roster_currency` SET `member_id` = '7', `order` = '2', `category` = 'Player vs. Player', `name` = 'Conquest Points', `count` = '0', `tooltip` = 'Conquest Points\nEarned as a reward for Arena or Rated Battlegrounds and used to purchase the most powerful PvP armor and weapons.\n \nWeekly Maximum: |cffffffff0/1650\n \n|cFFFFD700Total owned: |cFF00FF9A0', `icon` = 'pvpcurrency-conquest-alliance'; 2262 0.0002 INSERT INTO `roster_currency` SET `member_id` = '7', `order` = '3', `category` = 'Miscellaneous', `name` = 'Dalaran Cooking Award', `count` = '35', `tooltip` = 'Dalaran Cooking Award\nGranted to the finest cooks of Dalaran, these awards are used to purchase special cooking recipes, spices, and even a fine hat!\n \n|cFFABD473Tomofinland |cFF00FF9A35\n|cFFABD473Kharaghiosis |cFF00FF9A45\n|cFFFF7D0AExpectations |cFF00FF9A16\n|cFF69CCF0Bethanie |cFF00FF9A17\n \n|cFFFFD700Total owned: |cFF00FF9A113', `icon` = 'inv_misc_ribbon_01'; 2262 0.0002 INSERT INTO `roster_currency` SET `member_id` = '7', `order` = '4', `category` = 'Miscellaneous', `name` = 'Mark of the World Tree', `count` = '67', `tooltip` = 'Mark of the World Tree\nGranted by the Guardians of Hyjal. Can be used to purchase reinforcements for the Invasion of the Firelands.\n \n|cFFC41F3BBleys |cFF00FF9A53\n|cFFABD473Tomofinland |cFF00FF9A67\n|cFFABD473Kharaghiosis |cFF00FF9A107\n|cFFFF7D0AExpectations |cFF00FF9A23\n|cFF69CCF0Bethanie |cFF00FF9A23\n \n|cFFFFD700Total owned: |cFF00FF9A273', `icon` = 'inv_misc_markoftheworldtree'; 2262 0.0002 INSERT INTO `roster_currency` SET `member_id` = '7', `order` = '5', `category` = 'Miscellaneous', `name` = 'Chef\'s Award', `count` = '31', `tooltip` = 'Chef\'s Award\nAwarded to Azeroth\'s finest chefs. Can be redeemed for exquisite cooking recipes.\n \n|cFFF58CBAGreymouser |cFF00FF9A6\n|cFFC41F3BBleys |cFF00FF9A15\n|cFFABD473Tomofinland |cFF00FF9A31\n|cFFABD473Kharaghiosis |cFF00FF9A15\n|cFFFF7D0AExpectations |cFF00FF9A7\n|cFF69CCF0Bethanie |cFF00FF9A4\n \n|cFFFFD700Total owned: |cFF00FF9A78', `icon` = 'achievement_profession_chefhat'; 1715 0.0004 DELETE FROM `roster_quests` WHERE `member_id` = '7'; 1312 0.0003 REPLACE INTO `roster_quest_data` SET `quest_id` = '13395', `quest_name` = 'Army of the Damned', `quest_level` = '80', `reward_money` = '165300', `zone` = 'Icecrown', `locale` = 'enUS'; 1376 0.0002 INSERT INTO `roster_quests` SET `member_id` = '7', `quest_id` = '13395', `quest_index` = '6', `difficulty` = '1'; 1312 0.0002 REPLACE INTO `roster_quest_data` SET `quest_id` = '13288', `quest_name` = 'That\'s Abominable!', `quest_level` = '80', `reward_money` = '132300', `zone` = 'Icecrown', `locale` = 'enUS'; 1376 0.0002 INSERT INTO `roster_quests` SET `member_id` = '7', `quest_id` = '13288', `quest_index` = '7', `difficulty` = '1'; 1312 0.0002 REPLACE INTO `roster_quest_data` SET `quest_id` = '27006', `quest_name` = 'Fly Over', `quest_level` = '83', `reward_money` = '104600', `zone` = 'Deepholm', `locale` = 'enUS'; 1376 0.0002 INSERT INTO `roster_quests` SET `member_id` = '7', `quest_id` = '27006', `quest_index` = '1', `difficulty` = '2'; 1312 0.0002 REPLACE INTO `roster_quest_data` SET `quest_id` = '27004', `quest_name` = 'The Twilight Plot', `quest_level` = '83', `reward_money` = '104600', `zone` = 'Deepholm', `locale` = 'enUS'; 1376 0.0002 INSERT INTO `roster_quests` SET `member_id` = '7', `quest_id` = '27004', `quest_index` = '2', `difficulty` = '2'; 1312 0.0002 REPLACE INTO `roster_quest_data` SET `quest_id` = '26326', `quest_name` = 'The Very Earth Beneath Our Feet', `quest_level` = '83', `reward_money` = '10450', `zone` = 'Deepholm', `locale` = 'enUS'; 1376 0.0001 INSERT INTO `roster_quests` SET `member_id` = '7', `quest_id` = '26326', `quest_index` = '3', `difficulty` = '2'; 1312 0.0002 REPLACE INTO `roster_quest_data` SET `quest_id` = '29181', `quest_name` = 'Druids of the Talon', `quest_level` = '85', `reward_money` = '206700', `zone` = 'Firelands Invasion', `locale` = 'enUS'; 1376 0.0001 INSERT INTO `roster_quests` SET `member_id` = '7', `quest_id` = '29181', `quest_index` = '4', `difficulty` = '2'; 1312 0.0002 REPLACE INTO `roster_quest_data` SET `quest_id` = '29214', `quest_name` = 'The Shadow Wardens', `quest_level` = '85', `reward_money` = '206700', `zone` = 'Firelands Invasion', `locale` = 'enUS'; 1376 0.0001 INSERT INTO `roster_quests` SET `member_id` = '7', `quest_id` = '29214', `quest_index` = '5', `difficulty` = '2'; 1632 0.0005 DELETE FROM `roster_buffs` WHERE `member_id` = '7'; 1676 0.0003 INSERT INTO `roster_buffs` SET `member_id` = '7', `name` = 'Guild Champion', `icon` = 'inv_epicguildtabard', `tooltip` = 'Guild Champion\nAll guild reputation gains are increased by 100%.'; 1676 0.0002 INSERT INTO `roster_buffs` SET `member_id` = '7', `name` = 'Well Fed', `icon` = 'spell_misc_food', `tooltip` = 'Well Fed\nCritical Strike Rating increased by 40 and Stamina increased by 40.\n48 minutes remaining'; 1676 0.0002 INSERT INTO `roster_buffs` SET `member_id` = '7', `name` = 'Protection', `icon` = 'inv_alchemy_potion_empty', `tooltip` = 'Protection\nArmor increased by 220. Guardian Elixir.\n2 hours remaining'; 1676 0.0002 INSERT INTO `roster_buffs` SET `member_id` = '7', `name` = 'Deadly Strikes', `icon` = 'inv_alchemy_potion_02', `tooltip` = 'Deadly Strikes\nIncreases critical strike rating by 45.\n2 hours remaining'; 1676 0.0004 INSERT INTO `roster_buffs` SET `member_id` = '7', `name` = 'Fortitude', `icon` = 'spell_holy_wordfortitude', `tooltip` = 'Fortitude Magic\nStamina increased by 132.\n47 minutes remaining'; 1676 0.0002 INSERT INTO `roster_buffs` SET `member_id` = '7', `name` = 'Potion of Treasure Finding', `icon` = 'inv_misc_potionsete', `tooltip` = 'Potion of Treasure Finding\nYou can find extra treasure from monsters in Mount Hyjal, Vash\'jir, Deepholm, Twilight Highlands and Uldum. Start killing!\n7 minutes remaining'; 1676 0.0002 INSERT INTO `roster_buffs` SET `member_id` = '7', `name` = 'Aspect of the Hawk', `icon` = 'spell_nature_ravenform', `tooltip` = 'Aspect of the Hawk\nIncreases ranged attack power by 2600.'; 4295 0.0005 DELETE FROM `roster_pets` WHERE `member_id` = '7'; 4302 0.0003 DELETE FROM `roster_pet_spellbook` WHERE `member_id` = '7'; 3036 0.0002 SELECT * FROM `roster_guild` guild WHERE `guild_name` NOT LIKE 'guildless-_'; 3047 0.0002 SELECT `type`, COUNT(`rule_id`) FROM `roster_upload` WHERE (`type` = 0 OR `type` = 1) AND 'Pagans of Dawn' LIKE `name` AND 'Arathor' LIKE `server` AND 'EU' LIKE `region` GROUP BY `type` ORDER BY `type` DESC; 3065 0.0004 SELECT * FROM `roster_members` members INNER JOIN `roster_guild` guild USING (`guild_id`) WHERE `guild_name` LIKE 'guildless-_'; addons/memberslist/inc/update_hook.php 93 0.0004 SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 1; 155 0.0003 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '1'; 225 0.0001 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=1 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='1' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '1', `main_id` = '1', `alt_type` = 1 WHERE `member_id` = '1' 155 0.0002 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '2'; 225 0.0001 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=2 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='2' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '2', `main_id` = '2', `alt_type` = 1 WHERE `member_id` = '2' 155 0.0002 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '3'; 225 0.0001 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=3 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='3' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '3', `main_id` = '3', `alt_type` = 1 WHERE `member_id` = '3' 155 0.0002 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '4'; 225 0.0001 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=4 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='4' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '4', `main_id` = '4', `alt_type` = 1 WHERE `member_id` = '4' 155 0.0002 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '5'; 225 0.0001 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=5 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='5' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '5', `main_id` = '5', `alt_type` = 1 WHERE `member_id` = '5' 155 0.0002 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '6'; 225 0.0001 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=6 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='6' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '6', `main_id` = '6', `alt_type` = 1 WHERE `member_id` = '6' 155 0.0002 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '7'; 225 0.0001 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=7 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='7' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '7', `main_id` = '7', `alt_type` = 1 WHERE `member_id` = '7' 155 0.0002 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '10'; 225 0.0002 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=10 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='10' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '10', `main_id` = '10', `alt_type` = 1 WHERE `member_id` = '10' 155 0.0002 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '9'; 225 0.0001 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=9 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='9' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '9', `main_id` = '9', `alt_type` = 1 WHERE `member_id` = '9' 155 0.0002 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '8'; 225 0.0001 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=8 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='8' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '8', `main_id` = '8', `alt_type` = 1 WHERE `member_id` = '8' 155 0.0002 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '11'; 225 0.0001 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=11 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='11' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '11', `main_id` = '11', `alt_type` = 1 WHERE `member_id` = '11' 155 0.0002 SELECT `alt`.*, `member`.`name`, `member`.`server` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '12'; 225 0.0001 SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=12 392 0.0001 SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='12' 414 0.0001 UPDATE `roster_addons_memberslist_alts` SET `member_id` = '12', `main_id` = '12', `alt_type` = 1 WHERE `member_id` = '12' 456 0.0002 DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL addons/guildinfo/inc/update_hook.php 111 0.0002 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='1' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '1', `TotalXP` = '1194949', `WeeklyXP` = '841286', `TotalRank` = '10', `WeeklyRank` = '4', `Member` = 'Greymouser', `guild_id` = '1' WHERE `member_id` = '1' 111 0.0001 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='2' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '2', `TotalXP` = '4308253', `WeeklyXP` = '242900', `TotalRank` = '9', `WeeklyRank` = '8', `Member` = 'Marzipan', `guild_id` = '1' WHERE `member_id` = '2' 111 0.0001 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='3' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '3', `TotalXP` = '5254224', `WeeklyXP` = '17350', `TotalRank` = '6', `WeeklyRank` = '10', `Member` = 'Blueface', `guild_id` = '1' WHERE `member_id` = '3' 111 0.0001 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='4' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '4', `TotalXP` = '3536', `WeeklyXP` = '0', `TotalRank` = '11', `WeeklyRank` = '11', `Member` = 'Hamrammr', `guild_id` = '1' WHERE `member_id` = '4' 111 0.0001 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='5' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '5', `TotalXP` = '7422814', `WeeklyXP` = '871050', `TotalRank` = '3', `WeeklyRank` = '3', `Member` = 'Kharaghiosis', `guild_id` = '1' WHERE `member_id` = '5' 111 0.0001 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='6' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '6', `TotalXP` = '5300744', `WeeklyXP` = '373989', `TotalRank` = '5', `WeeklyRank` = '7', `Member` = 'Bethanie', `guild_id` = '1' WHERE `member_id` = '6' 111 0.0001 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='7' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '7', `TotalXP` = '6990888', `WeeklyXP` = '765138', `TotalRank` = '4', `WeeklyRank` = '5', `Member` = 'Tomofinland', `guild_id` = '1' WHERE `member_id` = '7' 111 0.0001 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='10' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '10', `TotalXP` = '4652817', `WeeklyXP` = '156150', `TotalRank` = '8', `WeeklyRank` = '9', `Member` = 'Bleys', `guild_id` = '1' WHERE `member_id` = '10' 111 0.0001 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='9' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '9', `TotalXP` = '738', `WeeklyXP` = '0', `TotalRank` = '12', `WeeklyRank` = '12', `Member` = 'Vironsusi', `guild_id` = '1' WHERE `member_id` = '9' 111 0.0001 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='8' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '8', `TotalXP` = '5151247', `WeeklyXP` = '740852', `TotalRank` = '7', `WeeklyRank` = '6', `Member` = 'Expectations', `guild_id` = '1' WHERE `member_id` = '8' 111 0.0001 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='11' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '11', `TotalXP` = '7479571', `WeeklyXP` = '880514', `TotalRank` = '2', `WeeklyRank` = '2', `Member` = 'Clonezone', `guild_id` = '1' WHERE `member_id` = '11' 111 0.0001 SELECT `member_id` FROM `roster_addons_guildinfo_ranks` WHERE `member_id`='12' 133 0.0002 UPDATE `roster_addons_guildinfo_ranks` SET `member_id` = '12', `TotalXP` = '9973970', `WeeklyXP` = '1521527', `TotalRank` = '1', `WeeklyRank` = '1', `Member` = 'Menergy', `guild_id` = '1' WHERE `member_id` = '12' 175 0.0003 SELECT `Member`,`Achievement`,`Date` FROM `roster_addons_guildinfo_news` WHERE `Member`='Expectations' AND `Achievement`='Mantle of Fury' AND `Date`='2011-11-20 00:00:00' 197 0.0002 UPDATE `roster_addons_guildinfo_news` SET `Achievement` = 'Mantle of Fury', `Member` = 'Expectations', `Date` = '2011-11-20 00:00:00', `Typpe` = '3', `guild_id` = '1', `Display_date` = 'Sun November 20th' WHERE `Member` = '' and `Achievement` = 'Mantle of Fury' 175 0.0002 SELECT `Member`,`Achievement`,`Date` FROM `roster_addons_guildinfo_news` WHERE `Member`='Kharaghiosis' AND `Achievement`='Mantle of Doubt' AND `Date`='2011-11-19 00:00:00' 197 0.0002 UPDATE `roster_addons_guildinfo_news` SET `Achievement` = 'Mantle of Doubt', `Member` = 'Kharaghiosis', `Date` = '2011-11-19 00:00:00', `Typpe` = '3', `guild_id` = '1', `Display_date` = 'Sat November 19th' WHERE `Member` = '' and `Achievement` = 'Mantle of Doubt' 175 0.0002 SELECT `Member`,`Achievement`,`Date` FROM `roster_addons_guildinfo_news` WHERE `Member`='Clonezone' AND `Achievement`='Mantle of Desire' AND `Date`='2011-11-19 00:00:00' 197 0.0002 UPDATE `roster_addons_guildinfo_news` SET `Achievement` = 'Mantle of Desire', `Member` = 'Clonezone', `Date` = '2011-11-19 00:00:00', `Typpe` = '3', `guild_id` = '1', `Display_date` = 'Sat November 19th' WHERE `Member` = '' and `Achievement` = 'Mantle of Desire' 175 0.0002 SELECT `Member`,`Achievement`,`Date` FROM `roster_addons_guildinfo_news` WHERE `Member`='Menergy' AND `Achievement`='Mantle of Fury' AND `Date`='2011-11-19 00:00:00' 197 0.0002 UPDATE `roster_addons_guildinfo_news` SET `Achievement` = 'Mantle of Fury', `Member` = 'Menergy', `Date` = '2011-11-19 00:00:00', `Typpe` = '3', `guild_id` = '1', `Display_date` = 'Sat November 19th' WHERE `Member` = '' and `Achievement` = 'Mantle of Fury' 175 0.0002 SELECT `Member`,`Achievement`,`Date` FROM `roster_addons_guildinfo_news` WHERE `Member`='Bethanie' AND `Achievement`='Mantle of Desire' AND `Date`='2011-11-19 00:00:00' 197 0.0002 UPDATE `roster_addons_guildinfo_news` SET `Achievement` = 'Mantle of Desire', `Member` = 'Bethanie', `Date` = '2011-11-19 00:00:00', `Typpe` = '3', `guild_id` = '1', `Display_date` = 'Sat November 19th' WHERE `Member` = '' and `Achievement` = 'Mantle of Desire' 175 0.0002 SELECT `Member`,`Achievement`,`Date` FROM `roster_addons_guildinfo_news` WHERE `Member`='Clonezone' AND `Achievement`='Breeches of Mended Nightmares' AND `Date`='2011-11-19 00:00:00' 197 0.0002 UPDATE `roster_addons_guildinfo_news` SET `Achievement` = 'Breeches of Mended Nightmares', `Member` = 'Clonezone', `Date` = '2011-11-19 00:00:00', `Typpe` = '4', `guild_id` = '1', `Display_date` = 'Sat November 19th' WHERE `Member` = '' and `Achievement` = 'Breeches of Mended Nightmares' 175 0.0002 SELECT `Member`,`Achievement`,`Date` FROM `roster_addons_guildinfo_news` WHERE `Member`='Pagans of Dawn' AND `Achievement`='4' AND `Date`='2011-11-20 00:00:00' 197 0.0002 UPDATE `roster_addons_guildinfo_news` SET `Achievement` = '4', `Member` = 'Pagans of Dawn', `Date` = '2011-11-20 00:00:00', `Typpe` = '6', `guild_id` = '1', `Display_date` = 'Sun November 20th' WHERE `Member` = '' and `Achievement` = '4' addons/achievements/inc/update_hook.php 160 0.0003 DELETE FROM `roster_addons_achievements_data` WHERE `member_id` = '7'; 167 0.0001 DELETE FROM `roster_addons_achievements_summary` WHERE `member_id` = '7';1146: Table 'pod064971.roster_addons_achievements_summary' doesn't exist addons/keys/inc/update_hook.php 99 0.0006 DELETE FROM `roster_addons_keys_keycache` WHERE `member_id` = '7'; 110 0.0012 INSERT INTO `roster_addons_keys_keycache` (`member_id`, `key_name`, `stage`) SELECT '7', `stages`.`key_name`, `stages`.`stage` FROM `roster_addons_keys_stages` AS stages, `roster_players` AS data WHERE `stages`.`locale` = 'enUS' AND `stages`.`faction` = 'A' AND `data`.`member_id` = '7' AND `stages`.`type` = 'G' AND (`data`.`money_c` + `data`.`money_s` * 100 + `data`.`money_g` * 10000) >= `stages`.`count`; 127 0.055 INSERT INTO `roster_addons_keys_keycache` (`member_id`, `key_name`, `stage`) SELECT '7', `key_name`, `stage` FROM (SELECT `stages`.`key_name`, `stages`.`stage`, `stages`.`count` AS need_count, SUM(`data`.`item_quantity`) AS item_count FROM `roster_addons_keys_stages` AS stages, `roster_items` AS data WHERE `stages`.`locale` = 'enUS' AND `stages`.`faction` = 'A' AND `data`.`member_id` = '7' AND (`stages`.`type` = 'In' AND `data`.`item_name` = `stages`.`value` OR `stages`.`type` = 'Ii' AND `data`.`item_id` LIKE CONCAT(`stages`.`value`, ':%')) GROUP BY `stages`.`key_name`, `stages`.`stage`, `stages`.`count` ) AS data_query WHERE `item_count` >= `need_count`; 141 0.0057 INSERT INTO `roster_addons_keys_keycache` (`member_id`, `key_name`, `stage`) SELECT '7', `stages`.`key_name`, `stages`.`stage` FROM `roster_addons_keys_stages` AS stages, `roster_quests` AS link, `roster_quest_data` AS data WHERE `stages`.`locale` = 'enUS' AND `stages`.`faction` = 'A' AND `link`.`member_id` = '7' AND `link`.`quest_id` = `data`.`quest_id` AND `stages`.`type` = 'Q' AND `data`.`quest_name` = `stages`.`value`; 159 0.0015 INSERT INTO `roster_addons_keys_keycache` (`member_id`, `key_name`, `stage`) SELECT '7', `stages`.`key_name`, `stages`.`stage` FROM `roster_addons_keys_stages` AS stages, `roster_reputation` AS data WHERE `stages`.`locale` = 'enUS' AND `stages`.`faction` = 'A' AND `data`.`member_id` = '7' AND `stages`.`type` = 'R' AND `data`.`name` = `stages`.`value` AND `stages`.`count` <= `data`.`curr_rep` + CASE `data`.`Standing` WHEN 'Hated' THEN -42000 WHEN 'Hostile' THEN -6000 WHEN 'Unfriendly' THEN -3000 WHEN 'Neutral' THEN 0 WHEN 'Friendly' THEN 3000 WHEN 'Honored' THEN 9000 WHEN 'Revered' THEN 21000 WHEN 'Exalted' THEN 42000 END; 171 0.0012 INSERT INTO `roster_addons_keys_keycache` (`member_id`, `key_name`, `stage`) SELECT '7', `stages`.`key_name`, `stages`.`stage` FROM `roster_addons_keys_stages` AS stages, `roster_skills` AS data WHERE `stages`.`locale` = 'enUS' AND `stages`.`faction` = 'A' AND `data`.`member_id` = '7' AND `stages`.`type` = 'S' AND `data`.`skill_name` = `stages`.`value` AND `stages`.`count` <= SUBSTRING_INDEX(`data`.`skill_level`,':',1); lib/menu.php 102 0.0007 SELECT `mb`.*, `a`.`basename` FROM `roster_menu_button` AS mb LEFT JOIN `roster_addon` AS a ON `mb`.`addon_id` = `a`.`addon_id` WHERE `a`.`addon_id` IS NULL OR `a`.`active` = 1; 119 0.0003 SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild') ORDER BY `config_id`;