Index: scripts/zones/Lower_Jeuno/npcs/Akamafula.lua =================================================================== --- scripts/zones/Lower_Jeuno/npcs/Akamafula.lua (revision 3261) +++ scripts/zones/Lower_Jeuno/npcs/Akamafula.lua (working copy) @@ -25,7 +25,12 @@ ----------------------------------- function onTrigger(player,npc) - player:showText(npc, AKAMAFULA_SHOP_DIALOG); + if (player:hasKeyItem(TENSHODO_MEMBERS_CARD)) then + if(player:sendGuild(60417,1,23,2)) then + player:showText(npc, AKAMAFULA_SHOP_DIALOG); + end + else + end end; ----------------------------------- Index: scripts/zones/Lower_Jeuno/npcs/Amalasanda.lua =================================================================== --- scripts/zones/Lower_Jeuno/npcs/Amalasanda.lua (revision 3261) +++ scripts/zones/Lower_Jeuno/npcs/Amalasanda.lua (working copy) @@ -25,7 +25,12 @@ ----------------------------------- function onTrigger(player,npc) - player:showText(npc, AMALASANDA_SHOP_DIALOG); + if (player:hasKeyItem(TENSHODO_MEMBERS_CARD)) then + if(player:sendGuild(60420,1,23,2)) then + player:showText(npc, AMALASANDA_SHOP_DIALOG); + end + else + end end; ----------------------------------- Index: scripts/zones/Nashmau/npcs/Tsutsuroon.lua =================================================================== --- scripts/zones/Nashmau/npcs/Tsutsuroon.lua (revision 0) +++ scripts/zones/Nashmau/npcs/Tsutsuroon.lua (working copy) @@ -0,0 +1,53 @@ +----------------------------------- +-- Area: Nashmau +-- NPC: Tsutsuroon +-- Type: Tenshodo Merchant +-- @zone: 53 +-- @pos: +-- +-- Auto-Script: Requires Verification (Verified by Brawndo) +----------------------------------- +package.loaded["scripts/zones/Nashmau/TextIDs"] = nil; +----------------------------------- + +require("scripts/globals/shop"); +require("scripts/zones/Nashmau/TextIDs"); + +----------------------------------- +-- onTrade Action +----------------------------------- + +function onTrade(player,npc,trade) +end; + +----------------------------------- +-- onTrigger Action +----------------------------------- + +function onTrigger(player,npc) + if (player:hasKeyItem(TENSHODO_MEMBERS_CARD)) then + if(player:sendGuild(60422,1,23,7)) then + player:showText(npc, TSUTSUROON_SHOP_DIALOG); + end + else + end +end; + +----------------------------------- +-- onEventUpdate +----------------------------------- + +function onEventUpdate(player,csid,option) + -- printf("CSID: %u",csid); + -- printf("RESULT: %u",option); +end; + +----------------------------------- +-- onEventFinish +----------------------------------- + +function onEventFinish(player,csid,option) + -- printf("CSID: %u",csid); + -- printf("RESULT: %u",option); +end; + Index: scripts/zones/Nashmau/TextIDs.lua =================================================================== --- scripts/zones/Nashmau/TextIDs.lua (revision 3261) +++ scripts/zones/Nashmau/TextIDs.lua (working copy) @@ -21,3 +21,4 @@ POPOROON_SHOP_DIALOG = 0; -- [UNKNOWN] WATAKHAMAZOM_SHOP_DIALOG = 10413; -- Looking for some bows and bolts to strrrike fear into the hearts of your enemies? You can find 'em here! -verify- YOYOROON_SHOP_DIALOG = 0; -- [UNKNOWN] + TSUTSUROON_SHOP_DIALOG = 0; \ No newline at end of file Index: scripts/zones/Norg/npcs/Vuliaie.lua =================================================================== --- scripts/zones/Norg/npcs/Vuliaie.lua (revision 0) +++ scripts/zones/Norg/npcs/Vuliaie.lua (working copy) @@ -0,0 +1,53 @@ +----------------------------------- +-- Area: Norg +-- NPC: Vuliaie +-- Type: Tenshodo Merchant +-- @zone: 252 +-- @pos: -24 0 -19 +-- +-- Auto-Script: Requires Verification (Verified by Brawndo) +----------------------------------- +package.loaded["scripts/zones/Norg/TextIDs"] = nil; +----------------------------------- + +require("scripts/globals/shop"); +require("scripts/zones/Norg/TextIDs"); + +----------------------------------- +-- onTrade Action +----------------------------------- + +function onTrade(player,npc,trade) +end; + +----------------------------------- +-- onTrigger Action +----------------------------------- + +function onTrigger(player,npc) + if (player:hasKeyItem(TENSHODO_MEMBERS_CARD)) then + if(player:sendGuild(60421,1,23,7)) then + player:showText(npc, VULIAIE_SHOP_DIALOG); + end + else + end +end; + +----------------------------------- +-- onEventUpdate +----------------------------------- + +function onEventUpdate(player,csid,option) + -- printf("CSID: %u",csid); + -- printf("RESULT: %u",option); +end; + +----------------------------------- +-- onEventFinish +----------------------------------- + +function onEventFinish(player,csid,option) + -- printf("CSID: %u",csid); + -- printf("RESULT: %u",option); +end; + Index: scripts/zones/Northern_San_dOria/npcs/Gaudylox.lua =================================================================== --- scripts/zones/Northern_San_dOria/npcs/Gaudylox.lua (revision 3261) +++ scripts/zones/Northern_San_dOria/npcs/Gaudylox.lua (working copy) @@ -7,7 +7,7 @@ ----------------------------------- require("scripts/globals/settings"); -require("scripts/globals/shop"); +--require("scripts/globals/shop"); require("scripts/globals/quests"); require("scripts/zones/Northern_San_dOria/TextIDs"); @@ -33,18 +33,20 @@ ----------------------------------- function onTrigger(player,npc) + if(player:sendGuild(60418,11,22,1)) then player:showText(npc,GAUDYLOX_SHOP_DIALOG); - stock = {0x01e1,21000, -- Black Chip - 0x01db,21000, -- Blue Chip - 0x01de,21000, -- Clear Chip - 0x01dd,21000, -- Green Chip - 0x01de,21000, -- Purple Chip - 0x01da,21000, -- Red Chip - 0x01e0,21000, -- White Chip - 0x01dc,21000} -- Yellow Chip - - showShop(player, STATIC, stock); +-- stock = {0x01e1,21000, -- Black Chip +-- 0x01db,21000, -- Blue Chip +-- 0x01de,21000, -- Clear Chip +-- 0x01dd,21000, -- Green Chip +-- 0x01de,21000, -- Purple Chip +-- 0x01da,21000, -- Red Chip +-- 0x01e0,21000, -- White Chip +-- 0x01dc,21000} -- Yellow Chip +-- +-- showShop(player, STATIC, stock); + end end; ----------------------------------- Index: scripts/zones/Port_Bastok/npcs/Blabbivix.lua =================================================================== --- scripts/zones/Port_Bastok/npcs/Blabbivix.lua (revision 0) +++ scripts/zones/Port_Bastok/npcs/Blabbivix.lua (working copy) @@ -0,0 +1,58 @@ +----------------------------------- +-- Area: Port Bastok +-- NPC: Blabbivix +-- Standard merchant, though he acts like a guild merchant +----------------------------------- + +package.loaded["scripts/zones/Port_Bastok/TextIDs"] = nil; +require("scripts/globals/settings"); +--require("scripts/globals/shop"); +require("scripts/zones/Port_Bastok/TextIDs"); + +----------------------------------- +-- onTrade Action +----------------------------------- + +function onTrade(player,npc,trade) +end; + +----------------------------------- +-- onTrigger Action +----------------------------------- + +function onTrigger(player,npc) + if(player:sendGuild(60418,11,22,3)) then + player:showText(npc,BLABBIVIX_SHOP_DIALOG); + +-- stock = {0x01e1,21000, -- Black Chip +-- 0x01db,21000, -- Blue Chip +-- 0x01de,21000, -- Clear Chip +-- 0x01dd,21000, -- Green Chip +-- 0x01de,21000, -- Purple Chip +-- 0x01da,21000, -- Red Chip +-- 0x01e0,21000, -- White Chip +-- 0x01dc,21000} -- Yellow Chip +-- showShop(player, STATIC, stock); + end +end; + +----------------------------------- +-- onEventUpdate +----------------------------------- + +function onEventUpdate(player,csid,option) +--printf("CSID: %u",csid); +--printf("RESULT: %u",option); +end; + +----------------------------------- +-- onEventFinish +----------------------------------- + +function onEventFinish(player,csid,option) +--printf("CSID: %u",csid); +--printf("RESULT: %u",option); +end; + + + Index: scripts/zones/Port_Bastok/TextIDs.lua =================================================================== --- scripts/zones/Port_Bastok/TextIDs.lua (revision 3261) +++ scripts/zones/Port_Bastok/TextIDs.lua (working copy) @@ -1,62 +1,63 @@ --- Variable TextID Description text - --- General Texts - ITEM_CANNOT_BE_OBTAINED = 6375; -- You cannot obtain the item come back again after sorting your inventory -FULL_INVENTORY_AFTER_TRADE = 6377; -- You cannot obtain the . Try trading again after sorting your inventory - ITEM_OBTAINED = 6378; -- Obtained: - GIL_OBTAINED = 6379; -- Obtained gil - KEYITEM_OBTAINED = 6381; -- Obtained key item: - HOMEPOINT_SET = 6461; -- Home point set! - NOT_HAVE_ENOUGH_GIL = 6634; -- You don't have enough money. - FISHING_MESSAGE_OFFSET = 6882; -- You can't fish here - MOGHOUSE_EXIT = 7737; -- You have learned your way through the back alleys of Bastok! Now you can exit to any area from your residence. - --- Conquest System -CONQUEST = 7793; -- You've earned conquest points! - --- Mission Dialogs - YOU_ACCEPT_THE_MISSION = 7133; -- You have accepted the mission. -ORIGINAL_MISSION_OFFSET = 7138; -- You can consult the “Mission” section of the main menu to review your objectives. Speed and efficiency are your priorities. Dismissed. -EXTENDED_MISSION_OFFSET = 8258; -- Go to Ore Street and talk to Medicine Eagle. He says he was there when the commotion started. - --- Dialog Texts -POWHATAN_DIALOG_1 = 7062; -- I'm sick and tired of entertaining guests. - - RONAN_DIALOG_1 = 7248; -- Do something! Isn't there anything you can do to make him come out of his shell? - - PAUJEAN_DIALOG_1 = 7439; -- Where can you find them? If you're the kind of adventurer I think you are, you should have a pretty good idea. Just don't do anything I wouldn't...heh heh. - - UNLOCK_NINJA = 8220; -- You can now become a ninja. - - TITAN_UNLOCKED = 8325; -- You are now able to summon Titan - --- Shop Texts - TENSHODO_SHOP_OPEN_DIALOG = 6639; -- Ah, one of our members. Welcome to the Tenshodo shop. - - EVELYN_CLOSED_DIALOG = 7367; -- Sorry, I don't have anything to sell you. I'm trying to start a business selling goods from Gustaberg, ... - ROSSWALD_CLOSED_DIALOG = 7368; -- Sorry, I don't have anything to sell you. I'm trying to start a business selling goods from Zulkheim, ... - BELKA_CLOSED_DIALOG = 7369; -- Sorry, I don't have anything to sell you. I'm trying to start a business selling goods from Derfland, ... - VATTIAN_CLOSED_DIALOG = 7370; -- I'm trying to start a business selling goods from Kuzotz, but it's not easy getting stuff from areas that aren't under Bastokan control. - - VALERIANO_SHOP_DIALOG = 7372; -- Welcome to the Troupe Valeriano. Valeriano, at your service! Have a laugh, then spend some cash! Treats and sweets from exotic lands! - - SAWYER_SHOP_DIALOG = 7417; -- Hi, there. For here or to go? - MELLOA_SHOP_DIALOG = 7418; -- Welcome to the Steaming Sheep. Would you like something to drink? - - EVELYN_OPEN_DIALOG = 7421; -- Hello! Might I interest you in some specialty goods from Gustaberg? - GALVIN_SHOP_DIALOG = 7422; -- Welcome to Galvin's Travel Gear! We do our best to get the best for only the best! - NUMA_SHOP_DIALOG = 7423; -- Hello, hello! Won't you buy something? I'll give you a rebate! - BELKA_OPEN_DIALOG = 7424; -- Welcome. I've got goods from Derfland. Interested? - ROSSWALD_OPEN_DIALOG = 7425; -- Hello, hello! Everything I have is imported directly from Zulkheim! - ILITA_SHOP_DIALOG = 7426; -- Hello there. How about buying to stay in touch with your friends? - SUGANDHI_SHOP_DIALOG = 7427; -- Traveler! I am sure my wares will prove useful on your journey. Why don't you buy some? - DENVIHR_SHOP_DIALOG = 7428; -- Ah, interested in my wares, are you? You can only buy these in Bastok, my friend. - - VATTIAN_OPEN_DIALOG = 8153; -- Welcome to my humble establishment. I have a wide variety of specialty goods from Kuzotz. - ZOBYQUHYO_OPEN_DIALOG = 8154; -- Hey therrre! I've got lots of wonderrrful goodies, fresh from the Elshimo Lowlands. - ZOBYQUHYO_CLOSED_DIALOG = 8155; -- I'm trrrying to start a business selling goods from the Elshimo Lowlands, but it's not easy getting stuff from areas that aren't under Bastokan contrrrol. - DHENTEVRYUKOH_OPEN_DIALOG = 8156; -- Welcome! Welcome! Take a wonderrr at these specialty goods from the Elshimo Uplands! -DHENTEVRYUKOH_CLOSED_DIALOG = 8157; -- I'm trrrying to start a business selling goods from the Elshimo Uplands, but it's not easy transporting goods from areas that aren't under Bastokan contrrrol. - - BAGNOBROK_CLOSED_DIALOG = 8912; -- Kbastok sis kweak! Smoblins yonly twant gstrong sfriends! Non sgoods mfrom Smovalpolos ytoday! +-- Variable TextID Description text + +-- General Texts + ITEM_CANNOT_BE_OBTAINED = 6375; -- You cannot obtain the item come back again after sorting your inventory +FULL_INVENTORY_AFTER_TRADE = 6377; -- You cannot obtain the . Try trading again after sorting your inventory + ITEM_OBTAINED = 6378; -- Obtained: + GIL_OBTAINED = 6379; -- Obtained gil + KEYITEM_OBTAINED = 6381; -- Obtained key item: + HOMEPOINT_SET = 6461; -- Home point set! + NOT_HAVE_ENOUGH_GIL = 6634; -- You don't have enough money. + FISHING_MESSAGE_OFFSET = 6882; -- You can't fish here + MOGHOUSE_EXIT = 7737; -- You have learned your way through the back alleys of Bastok! Now you can exit to any area from your residence. + +-- Conquest System +CONQUEST = 7793; -- You've earned conquest points! + +-- Mission Dialogs + YOU_ACCEPT_THE_MISSION = 7133; -- You have accepted the mission. +ORIGINAL_MISSION_OFFSET = 7138; -- You can consult the “Mission” section of the main menu to review your objectives. Speed and efficiency are your priorities. Dismissed. +EXTENDED_MISSION_OFFSET = 8258; -- Go to Ore Street and talk to Medicine Eagle. He says he was there when the commotion started. + +-- Dialog Texts +POWHATAN_DIALOG_1 = 7062; -- I'm sick and tired of entertaining guests. + + RONAN_DIALOG_1 = 7248; -- Do something! Isn't there anything you can do to make him come out of his shell? + + PAUJEAN_DIALOG_1 = 7439; -- Where can you find them? If you're the kind of adventurer I think you are, you should have a pretty good idea. Just don't do anything I wouldn't...heh heh. + + UNLOCK_NINJA = 8220; -- You can now become a ninja. + + TITAN_UNLOCKED = 8325; -- You are now able to summon Titan + +-- Shop Texts + TENSHODO_SHOP_OPEN_DIALOG = 6639; -- Ah, one of our members. Welcome to the Tenshodo shop. + + EVELYN_CLOSED_DIALOG = 7367; -- Sorry, I don't have anything to sell you. I'm trying to start a business selling goods from Gustaberg, ... + ROSSWALD_CLOSED_DIALOG = 7368; -- Sorry, I don't have anything to sell you. I'm trying to start a business selling goods from Zulkheim, ... + BELKA_CLOSED_DIALOG = 7369; -- Sorry, I don't have anything to sell you. I'm trying to start a business selling goods from Derfland, ... + VATTIAN_CLOSED_DIALOG = 7370; -- I'm trying to start a business selling goods from Kuzotz, but it's not easy getting stuff from areas that aren't under Bastokan control. + + VALERIANO_SHOP_DIALOG = 7372; -- Welcome to the Troupe Valeriano. Valeriano, at your service! Have a laugh, then spend some cash! Treats and sweets from exotic lands! + + SAWYER_SHOP_DIALOG = 7417; -- Hi, there. For here or to go? + MELLOA_SHOP_DIALOG = 7418; -- Welcome to the Steaming Sheep. Would you like something to drink? + + EVELYN_OPEN_DIALOG = 7421; -- Hello! Might I interest you in some specialty goods from Gustaberg? + GALVIN_SHOP_DIALOG = 7422; -- Welcome to Galvin's Travel Gear! We do our best to get the best for only the best! + NUMA_SHOP_DIALOG = 7423; -- Hello, hello! Won't you buy something? I'll give you a rebate! + BELKA_OPEN_DIALOG = 7424; -- Welcome. I've got goods from Derfland. Interested? + ROSSWALD_OPEN_DIALOG = 7425; -- Hello, hello! Everything I have is imported directly from Zulkheim! + ILITA_SHOP_DIALOG = 7426; -- Hello there. How about buying to stay in touch with your friends? + SUGANDHI_SHOP_DIALOG = 7427; -- Traveler! I am sure my wares will prove useful on your journey. Why don't you buy some? + DENVIHR_SHOP_DIALOG = 7428; -- Ah, interested in my wares, are you? You can only buy these in Bastok, my friend. + + VATTIAN_OPEN_DIALOG = 8153; -- Welcome to my humble establishment. I have a wide variety of specialty goods from Kuzotz. + ZOBYQUHYO_OPEN_DIALOG = 8154; -- Hey therrre! I've got lots of wonderrrful goodies, fresh from the Elshimo Lowlands. + ZOBYQUHYO_CLOSED_DIALOG = 8155; -- I'm trrrying to start a business selling goods from the Elshimo Lowlands, but it's not easy getting stuff from areas that aren't under Bastokan contrrrol. + DHENTEVRYUKOH_OPEN_DIALOG = 8156; -- Welcome! Welcome! Take a wonderrr at these specialty goods from the Elshimo Uplands! +DHENTEVRYUKOH_CLOSED_DIALOG = 8157; -- I'm trrrying to start a business selling goods from the Elshimo Uplands, but it's not easy transporting goods from areas that aren't under Bastokan contrrrol. + BLABBIVIX_SHOP_DIALOG = 8419; -- <Pshooowaaaaa> I come from the underworld.\nThese chipshhh, you knooow, are popular among us Goblinshhh.\nUse with heart of shhhtatue. + + BAGNOBROK_CLOSED_DIALOG = 8912; -- Kbastok sis kweak! Smoblins yonly twant gstrong sfriends! Non sgoods mfrom Smovalpolos ytoday! BAGNOBROK_OPEN_DIALOG = 8913; -- Kbastok! Crepublic sis gstrong! Smoblins lsell sgoods oto gstrong sfriends! \ No newline at end of file Index: scripts/zones/Windurst_Walls/npcs/Scavnix.lua =================================================================== --- scripts/zones/Windurst_Walls/npcs/Scavnix.lua (revision 3261) +++ scripts/zones/Windurst_Walls/npcs/Scavnix.lua (working copy) @@ -5,6 +5,8 @@ ----------------------------------- package.loaded["scripts/zones/Windurst_Walls/TextIDs"] = nil; +require("scripts/globals/settings"); +--require("scripts/globals/shop"); require("scripts/zones/Windurst_Walls/TextIDs"); ----------------------------------- @@ -19,6 +21,20 @@ ----------------------------------- function onTrigger(player,npc) +if(player:sendGuild(60418,11,22,6)) then + player:showText(npc,SCAVNIX_SHOP_DIALOG); + +-- stock = {0x01e1,21000, -- Black Chip +-- 0x01db,21000, -- Blue Chip +-- 0x01de,21000, -- Clear Chip +-- 0x01dd,21000, -- Green Chip +-- 0x01de,21000, -- Purple Chip +-- 0x01da,21000, -- Red Chip +-- 0x01e0,21000, -- White Chip +-- 0x01dc,21000} -- Yellow Chip +-- +-- showShop(player, STATIC, stock); + end end; ----------------------------------- Index: sql/guild_shops.sql =================================================================== --- sql/guild_shops.sql (revision 3261) +++ sql/guild_shops.sql (working copy) @@ -1,32 +1,24 @@ --- phpMyAdmin SQL Dump --- version 3.3.8 --- http://www.phpmyadmin.net --- --- Serveur: localhost --- Gnr le : Lun 05 Septembre 2011 22:45 --- Version du serveur: 6.0.0 --- Version de PHP: 5.2.9-2 +/* +Navicat MySQL Data Transfer -SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; +Source Server : DarkStar +Source Server Version : 50610 +Source Host : localhost:3306 +Source Database : dspdb +Target Server Type : MYSQL +Target Server Version : 50610 +File Encoding : 65001 -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; +Date: 2013-04-12 01:50:59 +*/ --- --- Base de donnes: `dspdb` --- - --- -------------------------------------------------------- - --- --- Structure de la table `guild_shops` --- - +SET FOREIGN_KEY_CHECKS=0; +-- ---------------------------- +-- Table structure for `guild_shops` +-- ---------------------------- DROP TABLE IF EXISTS `guild_shops`; -CREATE TABLE IF NOT EXISTS `guild_shops` ( +CREATE TABLE `guild_shops` ( `guildid` smallint(5) unsigned NOT NULL, `itemid` smallint(5) unsigned NOT NULL, `min_price` int(10) unsigned NOT NULL DEFAULT '0', @@ -36,516 +28,747 @@ PRIMARY KEY (`guildid`,`itemid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --- --- Contenu de la table `guild_shops` --- - --- Note by Gamer7542: Prices for each guild are a combination of --- price ranges listed on multiple wiki pages and actual --- screenshots taken from retail during the month of June, 2012. - --- --------------------------------- --- 513 - Woodworking Guild --- 514 - Bonecrafting Guild --- 515 - Windurst Clothcrafting Guild --- 516 - Selbina Clothcrafting Guild --- 517 - Windurst Fishing Guild --- 518 - Bibiki Bay Fishing Guild --- 519 - Boat Routes Fishing Guilds --- 520 - Selbina Fishing Guild --- 521 - Alchemy Guild --- 522 - Bastok Goldsmithing Guild --- 523 - Mhaura Goldsmithing Guild --- 524 - Leathercrafting Guild --- 525 - Cooking Guild --- 526 - San d'Oria Blacksmithing Guild --- 527 - Mhaura Blacksmithing Guild --- 528 - Bastok Blacksmithing Guild --- --------------------------------- - -INSERT INTO `guild_shops` VALUES (513, 688, 15, 28, 240, 3); -INSERT INTO `guild_shops` VALUES (513, 689, 27, 37, 240, 2); -INSERT INTO `guild_shops` VALUES (513, 691, 45, 276, 240, 40); -INSERT INTO `guild_shops` VALUES (513, 698, 72, 349, 240, 50); -INSERT INTO `guild_shops` VALUES (513, 695, 120, 132, 240, 2); -INSERT INTO `guild_shops` VALUES (513, 697, 528, 549, 240, 4); -INSERT INTO `guild_shops` VALUES (513, 696, 330, 699, 180, 65); -INSERT INTO `guild_shops` VALUES (513, 690, 1378, 10938, 240, 1500); -INSERT INTO `guild_shops` VALUES (513, 693, 640, 3586, 60, 45); -INSERT INTO `guild_shops` VALUES (513, 694, 2119, 2811, 240, 150); -INSERT INTO `guild_shops` VALUES (513, 699, 4740, 24016, 240, 675); -INSERT INTO `guild_shops` VALUES (513, 701, 6615, 8555, 240, 400); -INSERT INTO `guild_shops` VALUES (513, 700, 9075, 9075, 240, 1); -INSERT INTO `guild_shops` VALUES (513, 702, 9600, 11520, 240, 325); -INSERT INTO `guild_shops` VALUES (513, 704, 96, 149, 240, 10); -INSERT INTO `guild_shops` VALUES (513, 721, 448, 800, 240, 65); -INSERT INTO `guild_shops` VALUES (513, 705, 7, 18, 240, 2); -INSERT INTO `guild_shops` VALUES (513, 706, 27, 165, 240, 30); -INSERT INTO `guild_shops` VALUES (513, 708, 45, 276, 240, 40); -INSERT INTO `guild_shops` VALUES (513, 715, 72, 441, 240, 150); -INSERT INTO `guild_shops` VALUES (513, 712, 120, 120, 240, 1); -INSERT INTO `guild_shops` VALUES (513, 714, 606, 1036, 240, 100); -INSERT INTO `guild_shops` VALUES (513, 713, 330, 1672, 240, 225); -INSERT INTO `guild_shops` VALUES (513, 707, 1723, 9651, 240, 150); -INSERT INTO `guild_shops` VALUES (513, 710, 2119, 3843, 240, 300); -INSERT INTO `guild_shops` VALUES (513, 716, 4740, 24016, 240, 400); -INSERT INTO `guild_shops` VALUES (513, 711, 2537, 4489, 240, 350); -INSERT INTO `guild_shops` VALUES (513, 719, 45568, 62464, 240, 3000); -INSERT INTO `guild_shops` VALUES (513, 720, 2687, 20962, 240, 3050); -INSERT INTO `guild_shops` VALUES (513, 12984, 111, 292, 240, 50); -INSERT INTO `guild_shops` VALUES (513, 12289, 41, 249, 240, 40); -INSERT INTO `guild_shops` VALUES (513, 12293, 15132, 15132, 240, 1); -INSERT INTO `guild_shops` VALUES (513, 22, 282, 1639, 240, 300); -INSERT INTO `guild_shops` VALUES (513, 97, 227, 5508, 240, 900); -INSERT INTO `guild_shops` VALUES (513, 102, 291, 582, 240, 50); -INSERT INTO `guild_shops` VALUES (513, 23, 829, 1858, 240, 175); -INSERT INTO `guild_shops` VALUES (513, 92, 738, 3621, 240, 400); -INSERT INTO `guild_shops` VALUES (513, 17024, 48, 351, 240, 55); -INSERT INTO `guild_shops` VALUES (513, 17027, 9771, 44478, 240, 5800); -INSERT INTO `guild_shops` VALUES (513, 17030, 14766, 81107, 240, 11100); -INSERT INTO `guild_shops` VALUES (513, 17050, 247, 1406, 240, 200); -INSERT INTO `guild_shops` VALUES (513, 17051, 1049, 2630, 240, 300); -INSERT INTO `guild_shops` VALUES (513, 17088, 113, 286, 240, 30); -INSERT INTO `guild_shops` VALUES (513, 17095, 281, 1932, 240, 300); -INSERT INTO `guild_shops` VALUES (513, 17424, 18900, 49980, 240, 5200); -INSERT INTO `guild_shops` VALUES (513, 17217, 11492, 11492, 240, 1); -INSERT INTO `guild_shops` VALUES (513, 17318, 13, 13, 240, 1); -INSERT INTO `guild_shops` VALUES (514, 880, 57, 349, 240, 150); -INSERT INTO `guild_shops` VALUES (514, 881, 1941, 13398, 240, 150); -INSERT INTO `guild_shops` VALUES (514, 882, 150, 190, 240, 150); -INSERT INTO `guild_shops` VALUES (514, 884, 4850, 12384, 240, 150); -INSERT INTO `guild_shops` VALUES (514, 885, 25584, 69888, 240, 150); -INSERT INTO `guild_shops` VALUES (514, 888, 84, 114, 240, 150); -INSERT INTO `guild_shops` VALUES (514, 889, 298, 1495, 240, 150); -INSERT INTO `guild_shops` VALUES (514, 893, 760, 4141, 240, 150); -INSERT INTO `guild_shops` VALUES (514, 894, 968, 2952, 240, 150); -INSERT INTO `guild_shops` VALUES (514, 896, 2044, 12166, 240, 150); -INSERT INTO `guild_shops` VALUES (514, 897, 1228, 7993, 240, 150); -INSERT INTO `guild_shops` VALUES (514, 864, 72, 203, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 833, 15, 22, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 834, 80, 200, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 835, 187, 1000, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 832, 675, 1620, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 839, 137, 870, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 817, 45, 240, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 818, 120, 768, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 819, 750, 4600, 240, 600); -INSERT INTO `guild_shops` VALUES (515, 820, 2700, 3312, 240, 100); -INSERT INTO `guild_shops` VALUES (515, 816, 596, 3540, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 822, 600, 4480, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 823, 18240, 18240, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 821, 144144, 144144, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 824, 240, 588, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 825, 480, 2944, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 826, 8040, 8040, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 827, 53568, 53568, 240, 150); -INSERT INTO `guild_shops` VALUES (515, 841, 36, 200, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 833, 15, 22, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 835, 187, 1000, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 832, 675, 1620, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 839, 137, 870, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 817, 45, 240, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 818, 120, 768, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 819, 750, 4600, 240, 600); -INSERT INTO `guild_shops` VALUES (516, 820, 2700, 3312, 240, 100); -INSERT INTO `guild_shops` VALUES (516, 816, 596, 3540, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 822, 600, 4480, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 823, 18240, 18240, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 824, 240, 588, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 825, 480, 2944, 240, 150); -INSERT INTO `guild_shops` VALUES (516, 847, 10, 40, 240, 8); -INSERT INTO `guild_shops` VALUES (516, 841, 36, 200, 240, 150); -INSERT INTO `guild_shops` VALUES (517, 17396, 3, 4, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 17395, 9, 12, 240, 2); -INSERT INTO `guild_shops` VALUES (517, 16996, 52, 52, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 16997, 52, 266, 240, 50); -INSERT INTO `guild_shops` VALUES (517, 16998, 30, 184, 240, 50); -INSERT INTO `guild_shops` VALUES (517, 16999, 52, 240, 240, 50); -INSERT INTO `guild_shops` VALUES (517, 17000, 52, 322, 240, 75); -INSERT INTO `guild_shops` VALUES (517, 17392, 213, 433, 240, 75); -INSERT INTO `guild_shops` VALUES (517, 17393, 213, 213, 240, 150); -INSERT INTO `guild_shops` VALUES (517, 17394, 220, 220, 240, 150); -INSERT INTO `guild_shops` VALUES (517, 16992, 52, 238, 240, 75); -INSERT INTO `guild_shops` VALUES (517, 16993, 52, 64, 240, 5); -INSERT INTO `guild_shops` VALUES (517, 16994, 52, 52, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 17405, 540, 540, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 17407, 270, 364, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 17404, 540, 540, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 17399, 2394, 2394, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 17391, 44, 74, 240, 10); -INSERT INTO `guild_shops` VALUES (517, 17390, 145, 245, 240, 10); -INSERT INTO `guild_shops` VALUES (517, 17389, 332, 561, 240, 75); -INSERT INTO `guild_shops` VALUES (517, 17388, 934, 1667, 240, 150); -INSERT INTO `guild_shops` VALUES (517, 17387, 4077, 4077, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 17380, 25740, 25740, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 17383, 1980, 2640, 240, 200); -INSERT INTO `guild_shops` VALUES (517, 17382, 9657, 15398, 240, 1750); -INSERT INTO `guild_shops` VALUES (517, 4443, 24, 165, 240, 25); -INSERT INTO `guild_shops` VALUES (517, 4472, 30, 198, 240, 50); -INSERT INTO `guild_shops` VALUES (517, 624, 24, 156, 240, 25); -INSERT INTO `guild_shops` VALUES (517, 4484, 1350, 8784, 240, 1000); -INSERT INTO `guild_shops` VALUES (517, 4426, 195, 665, 240, 100); -INSERT INTO `guild_shops` VALUES (517, 4427, 1350, 1350, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 4482, 1712, 2000, 240, 100); -INSERT INTO `guild_shops` VALUES (517, 4783, 195, 1248, 240, 300); -INSERT INTO `guild_shops` VALUES (517, 4428, 45, 396, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 4361, 1196, 1289, 240, 25); -INSERT INTO `guild_shops` VALUES (517, 4304, 30520, 34720, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 4481, 505, 748, 240, 75); -INSERT INTO `guild_shops` VALUES (517, 4385, 520, 748, 240, 75); -INSERT INTO `guild_shops` VALUES (517, 4402, 8064, 8568, 240, 100); -INSERT INTO `guild_shops` VALUES (517, 4383, 3225, 5621, 240, 900); -INSERT INTO `guild_shops` VALUES (517, 4399, 1350, 4680, 240, 750); -INSERT INTO `guild_shops` VALUES (517, 4485, 13888, 13888, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 4290, 1008, 1289, 240, 50); -INSERT INTO `guild_shops` VALUES (517, 4451, 5440, 19520, 240, 1500); -INSERT INTO `guild_shops` VALUES (517, 4461, 4050, 4050, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 4384, 5250, 5250, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 4514, 60, 396, 240, 50); -INSERT INTO `guild_shops` VALUES (517, 4580, 4760, 4760, 240, 1); -INSERT INTO `guild_shops` VALUES (517, 4462, 1350, 8064, 240, 1250); -INSERT INTO `guild_shops` VALUES (517, 4480, 455, 2800, 240, 400); -INSERT INTO `guild_shops` VALUES (517, 4479, 7560, 8784, 240, 250); -INSERT INTO `guild_shops` VALUES (517, 4471, 11984, 13888, 240, 350); -INSERT INTO `guild_shops` VALUES (518, 17388, 766, 1667, 240, 150); -INSERT INTO `guild_shops` VALUES (518, 17382, 7081, 15398, 240, 1750); -INSERT INTO `guild_shops` VALUES (518, 4399, 1350, 4680, 240, 750); -INSERT INTO `guild_shops` VALUES (518, 4485, 2100, 13888, 240, 2500); -INSERT INTO `guild_shops` VALUES (518, 4317, 120, 120, 240, 1); -INSERT INTO `guild_shops` VALUES (518, 4484, 1350, 8784, 240, 1200); -INSERT INTO `guild_shops` VALUES (518, 4385, 115, 748, 240, 110); -INSERT INTO `guild_shops` VALUES (518, 5121, 2142, 2142, 240, 1); -INSERT INTO `guild_shops` VALUES (518, 4314, 300, 600, 240, 50); -INSERT INTO `guild_shops` VALUES (518, 4318, 3375, 3375, 240, 1); -INSERT INTO `guild_shops` VALUES (518, 624, 24, 156, 240, 25); -INSERT INTO `guild_shops` VALUES (518, 4443, 24, 165, 240, 25); -INSERT INTO `guild_shops` VALUES (519, 17395, 9, 12, 240, 2); -INSERT INTO `guild_shops` VALUES (519, 17399, 2394, 2394, 240, 1); -INSERT INTO `guild_shops` VALUES (519, 17407, 270, 364, 240, 1); -INSERT INTO `guild_shops` VALUES (519, 17400, 691, 4000, 240, 575); -INSERT INTO `guild_shops` VALUES (519, 17387, 4077, 4077, 240, 1); -INSERT INTO `guild_shops` VALUES (519, 4360, 25, 153, 240, 25); -INSERT INTO `guild_shops` VALUES (519, 4484, 1350, 8928, 240, 1200); -INSERT INTO `guild_shops` VALUES (519, 4399, 1350, 8856, 240, 1250); -INSERT INTO `guild_shops` VALUES (519, 4485, 2100, 13888, 240, 2500); -INSERT INTO `guild_shops` VALUES (519, 4451, 5440, 19520, 240, 1500); -INSERT INTO `guild_shops` VALUES (519, 4514, 60, 396, 240, 50); -INSERT INTO `guild_shops` VALUES (519, 4480, 455, 2800, 240, 400); -INSERT INTO `guild_shops` VALUES (520, 17399, 2394, 2394, 240, 1); -INSERT INTO `guild_shops` VALUES (520, 17387, 4077, 4077, 240, 1); -INSERT INTO `guild_shops` VALUES (520, 17383, 1980, 2640, 240, 200); -INSERT INTO `guild_shops` VALUES (520, 17388, 934, 1667, 240, 150); -INSERT INTO `guild_shops` VALUES (520, 17382, 9657, 15398, 240, 1750); -INSERT INTO `guild_shops` VALUES (520, 4472, 30, 198, 240, 50); -INSERT INTO `guild_shops` VALUES (520, 624, 24, 156, 240, 25); -INSERT INTO `guild_shops` VALUES (520, 4360, 25, 153, 240, 25); -INSERT INTO `guild_shops` VALUES (520, 4484, 1350, 8784, 240, 1000); -INSERT INTO `guild_shops` VALUES (520, 4385, 520, 775, 240, 75); -INSERT INTO `guild_shops` VALUES (520, 4399, 1350, 7920, 240, 1000); -INSERT INTO `guild_shops` VALUES (520, 4485, 12208, 13888, 240, 300); -INSERT INTO `guild_shops` VALUES (520, 4451, 3280, 19520, 240, 2500); -INSERT INTO `guild_shops` VALUES (520, 4461, 4050, 4995, 240, 175); -INSERT INTO `guild_shops` VALUES (520, 4384, 5250, 27160, 240, 3650); -INSERT INTO `guild_shops` VALUES (520, 4500, 29, 147, 240, 20); -INSERT INTO `guild_shops` VALUES (520, 4514, 60, 396, 240, 50); -INSERT INTO `guild_shops` VALUES (520, 4480, 455, 2800, 240, 400); -INSERT INTO `guild_shops` VALUES (521, 914, 1125, 5100, 240, 665); -INSERT INTO `guild_shops` VALUES (521, 920, 1084, 5494, 240, 150); -INSERT INTO `guild_shops` VALUES (521, 922, 297, 300, 240, 1); -INSERT INTO `guild_shops` VALUES (521, 925, 1012, 4017, 240, 500); -INSERT INTO `guild_shops` VALUES (521, 1108, 573, 795, 240, 40); -INSERT INTO `guild_shops` VALUES (521, 951, 90, 504, 240, 70); -INSERT INTO `guild_shops` VALUES (521, 621, 21, 30, 240, 2); -INSERT INTO `guild_shops` VALUES (521, 622, 36, 57, 240, 4); -INSERT INTO `guild_shops` VALUES (521, 636, 15, 97, 528, 75); -INSERT INTO `guild_shops` VALUES (521, 4165, 984, 5856, 240, 815); -INSERT INTO `guild_shops` VALUES (521, 638, 138, 777, 240, 125); -INSERT INTO `guild_shops` VALUES (521, 4443, 24, 165, 240, 25); -INSERT INTO `guild_shops` VALUES (521, 933, 600, 3360, 240, 500); -INSERT INTO `guild_shops` VALUES (521, 932, 1020, 5712, 240, 800); -INSERT INTO `guild_shops` VALUES (521, 4154, 6300, 7700, 240, 250); -INSERT INTO `guild_shops` VALUES (521, 4157, 800, 2240, 240, 240); -INSERT INTO `guild_shops` VALUES (521, 4150, 600, 3584, 240, 500); -INSERT INTO `guild_shops` VALUES (521, 4162, 810, 4284, 240, 600); -INSERT INTO `guild_shops` VALUES (521, 947, 3360, 21862, 240, 3100); -INSERT INTO `guild_shops` VALUES (521, 4166, 750, 4480, 240, 625); -INSERT INTO `guild_shops` VALUES (521, 4112, 682, 946, 240, 50); -INSERT INTO `guild_shops` VALUES (521, 4116, 3375, 5760, 240, 400); -INSERT INTO `guild_shops` VALUES (521, 4128, 4348, 22227, 240, 3025); -INSERT INTO `guild_shops` VALUES (521, 2131, 75, 150, 240, 15); -INSERT INTO `guild_shops` VALUES (521, 18228, 114, 114, 240, 1); -INSERT INTO `guild_shops` VALUES (521, 18232, 114, 114, 240, 1); -INSERT INTO `guild_shops` VALUES (521, 18236, 21, 28, 240, 2); -INSERT INTO `guild_shops` VALUES (522, 640, 9, 26, 240, 5); -INSERT INTO `guild_shops` VALUES (522, 736, 315, 705, 240, 100); -INSERT INTO `guild_shops` VALUES (522, 644, 1500, 9800, 240, 1500); -INSERT INTO `guild_shops` VALUES (522, 746, 250380, 250380, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 752, 55755, 55755, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 754, 87187, 87187, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 673, 210, 1131, 240, 150); -INSERT INTO `guild_shops` VALUES (522, 681, 10500, 42000, 240, 7500); -INSERT INTO `guild_shops` VALUES (522, 762, 334800, 334800, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 769, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (522, 770, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (522, 771, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (522, 772, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (522, 773, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (522, 774, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (522, 775, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (522, 776, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (522, 795, 1396, 1937, 240, 100); -INSERT INTO `guild_shops` VALUES (522, 796, 1396, 1937, 240, 100); -INSERT INTO `guild_shops` VALUES (522, 799, 1396, 1937, 240, 100); -INSERT INTO `guild_shops` VALUES (522, 800, 1396, 1937, 240, 100); -INSERT INTO `guild_shops` VALUES (522, 806, 1396, 1937, 240, 100); -INSERT INTO `guild_shops` VALUES (522, 807, 1396, 1937, 240, 100); -INSERT INTO `guild_shops` VALUES (522, 809, 1396, 1937, 240, 100); -INSERT INTO `guild_shops` VALUES (522, 814, 1396, 1937, 240, 100); -INSERT INTO `guild_shops` VALUES (522, 788, 9000, 16320, 240, 6250); -INSERT INTO `guild_shops` VALUES (522, 790, 9000, 16320, 240, 6250); -INSERT INTO `guild_shops` VALUES (522, 811, 9000, 16320, 240, 6250); -INSERT INTO `guild_shops` VALUES (522, 815, 9000, 16320, 240, 6250); -INSERT INTO `guild_shops` VALUES (522, 798, 9000, 16320, 240, 6250); -INSERT INTO `guild_shops` VALUES (522, 808, 9000, 16320, 240, 6250); -INSERT INTO `guild_shops` VALUES (522, 784, 23400, 49608, 240, 4500); -INSERT INTO `guild_shops` VALUES (522, 803, 23400, 49608, 240, 4500); -INSERT INTO `guild_shops` VALUES (522, 810, 23400, 49608, 240, 4500); -INSERT INTO `guild_shops` VALUES (522, 801, 23400, 49608, 240, 4500); -INSERT INTO `guild_shops` VALUES (522, 791, 23400, 49608, 240, 4500); -INSERT INTO `guild_shops` VALUES (522, 805, 23400, 49608, 240, 4500); -INSERT INTO `guild_shops` VALUES (522, 797, 23400, 49608, 240, 4500); -INSERT INTO `guild_shops` VALUES (522, 802, 23400, 49608, 240, 4500); -INSERT INTO `guild_shops` VALUES (522, 785, 48336, 284544, 240, 40000); -INSERT INTO `guild_shops` VALUES (522, 786, 48336, 284544, 240, 40000); -INSERT INTO `guild_shops` VALUES (522, 804, 48336, 284544, 240, 40000); -INSERT INTO `guild_shops` VALUES (522, 794, 48336, 284544, 240, 40000); -INSERT INTO `guild_shops` VALUES (522, 13327, 1125, 5850, 240, 750); -INSERT INTO `guild_shops` VALUES (522, 13316, 73416, 73416, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 13332, 1186, 1728, 240, 110); -INSERT INTO `guild_shops` VALUES (522, 13333, 1186, 1728, 240, 110); -INSERT INTO `guild_shops` VALUES (522, 13334, 1186, 1728, 240, 110); -INSERT INTO `guild_shops` VALUES (522, 13336, 1186, 1728, 240, 110); -INSERT INTO `guild_shops` VALUES (522, 13454, 114, 255, 240, 50); -INSERT INTO `guild_shops` VALUES (522, 13446, 21060, 21060, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 13444, 1875, 2950, 240, 200); -INSERT INTO `guild_shops` VALUES (522, 13471, 1875, 2950, 240, 200); -INSERT INTO `guild_shops` VALUES (522, 13472, 1875, 2950, 240, 200); -INSERT INTO `guild_shops` VALUES (522, 13474, 1875, 2950, 240, 200); -INSERT INTO `guild_shops` VALUES (522, 12496, 117, 117, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 12497, 1029, 1080, 240, 10); -INSERT INTO `guild_shops` VALUES (522, 12495, 4398, 4896, 240, 100); -INSERT INTO `guild_shops` VALUES (522, 16551, 1233, 3631, 240, 400); -INSERT INTO `guild_shops` VALUES (522, 16641, 6240, 6240, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 17081, 3229, 3229, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 12449, 7128, 7128, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 12577, 9144, 9144, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 12833, 1750, 1750, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 12961, 985, 985, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 1588, 20400, 20400, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 2143, 75, 75, 240, 1); -INSERT INTO `guild_shops` VALUES (522, 2144, 75, 75, 240, 1); -INSERT INTO `guild_shops` VALUES (523, 640, 9, 26, 240, 5); -INSERT INTO `guild_shops` VALUES (523, 736, 315, 705, 240, 100); -INSERT INTO `guild_shops` VALUES (523, 769, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (523, 770, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (523, 771, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (523, 772, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (523, 773, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (523, 774, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (523, 775, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (523, 776, 2632, 6328, 240, 525); -INSERT INTO `guild_shops` VALUES (523, 2143, 75, 75, 240, 1); -INSERT INTO `guild_shops` VALUES (523, 2144, 75, 75, 240, 1); -INSERT INTO `guild_shops` VALUES (524, 856, 45, 276, 240, 40); -INSERT INTO `guild_shops` VALUES (524, 505, 57, 349, 240, 50); -INSERT INTO `guild_shops` VALUES (524, 858, 483, 2967, 240, 450); -INSERT INTO `guild_shops` VALUES (524, 859, 937, 3250, 240, 400); -INSERT INTO `guild_shops` VALUES (524, 861, 393, 1312, 240, 160); -INSERT INTO `guild_shops` VALUES (524, 863, 2700, 12240, 240, 1600); -INSERT INTO `guild_shops` VALUES (524, 851, 4250, 16670, 240, 2100); -INSERT INTO `guild_shops` VALUES (524, 506, 5173, 33796, 240, 4775); -INSERT INTO `guild_shops` VALUES (524, 853, 2155, 13680, 240, 1925); -INSERT INTO `guild_shops` VALUES (524, 854, 2650, 3427, 240, 125); -INSERT INTO `guild_shops` VALUES (524, 834, 675, 3276, 240, 450); -INSERT INTO `guild_shops` VALUES (524, 695, 120, 120, 240, 1); -INSERT INTO `guild_shops` VALUES (524, 4509, 9, 12, 240, 1); -INSERT INTO `guild_shops` VALUES (524, 917, 1821, 2245, 240, 75); -INSERT INTO `guild_shops` VALUES (524, 13594, 132, 246, 240, 25); -INSERT INTO `guild_shops` VALUES (524, 13588, 2484, 3146, 240, 125); -INSERT INTO `guild_shops` VALUES (524, 13571, 7282, 37356, 240, 5200); -INSERT INTO `guild_shops` VALUES (524, 13570, 10800, 11304, 240, 100); -INSERT INTO `guild_shops` VALUES (524, 13593, 24000, 24640, 240, 110); -INSERT INTO `guild_shops` VALUES (524, 13203, 2641, 2641, 240, 1); -INSERT INTO `guild_shops` VALUES (524, 13200, 13860, 80572, 240, 11500); -INSERT INTO `guild_shops` VALUES (524, 13081, 411, 411, 240, 1); -INSERT INTO `guild_shops` VALUES (524, 13089, 6384, 15662, 240, 1550); -INSERT INTO `guild_shops` VALUES (524, 12569, 13514, 33476, 240, 3400); -INSERT INTO `guild_shops` VALUES (524, 12572, 44460, 163612, 240, 20000); -INSERT INTO `guild_shops` VALUES (524, 12993, 3366, 7001, 240, 650); -INSERT INTO `guild_shops` VALUES (524, 12994, 14352, 54537, 240, 6700); -INSERT INTO `guild_shops` VALUES (524, 12696, 324, 1425, 240, 200); -INSERT INTO `guild_shops` VALUES (524, 12697, 2700, 17136, 240, 2425); -INSERT INTO `guild_shops` VALUES (524, 12700, 29700, 182160, 240, 25500); -INSERT INTO `guild_shops` VALUES (524, 12440, 396, 1566, 240, 200); -INSERT INTO `guild_shops` VALUES (524, 12442, 13179, 51000, 240, 6325); -INSERT INTO `guild_shops` VALUES (524, 12824, 482, 2615, 240, 400); -INSERT INTO `guild_shops` VALUES (524, 12992, 453, 629, 240, 40); -INSERT INTO `guild_shops` VALUES (524, 16386, 945, 3780, 240, 475); -INSERT INTO `guild_shops` VALUES (524, 16388, 11970, 41496, 240, 5000); -INSERT INTO `guild_shops` VALUES (524, 12294, 25920, 158976, 240, 22200); -INSERT INTO `guild_shops` VALUES (524, 2129, 75, 75, 240, 1); -INSERT INTO `guild_shops` VALUES (525, 936, 14, 67, 240, 10); -INSERT INTO `guild_shops` VALUES (525, 611, 30, 42, 240, 2); -INSERT INTO `guild_shops` VALUES (525, 610, 45, 66, 240, 4); -INSERT INTO `guild_shops` VALUES (525, 612, 45, 194, 240, 30); -INSERT INTO `guild_shops` VALUES (525, 614, 60, 361, 240, 55); -INSERT INTO `guild_shops` VALUES (525, 4378, 45, 264, 240, 40); -INSERT INTO `guild_shops` VALUES (525, 616, 60, 368, 240, 50); -INSERT INTO `guild_shops` VALUES (525, 618, 21, 50, 240, 5); -INSERT INTO `guild_shops` VALUES (525, 619, 36, 42, 240, 1); -INSERT INTO `guild_shops` VALUES (525, 620, 45, 276, 240, 50); -INSERT INTO `guild_shops` VALUES (525, 621, 21, 25, 240, 1); -INSERT INTO `guild_shops` VALUES (525, 622, 36, 220, 240, 35); -INSERT INTO `guild_shops` VALUES (525, 625, 66, 334, 240, 50); -INSERT INTO `guild_shops` VALUES (525, 628, 195, 572, 240, 50); -INSERT INTO `guild_shops` VALUES (525, 629, 36, 220, 240, 40); -INSERT INTO `guild_shops` VALUES (525, 4358, 139, 163, 240, 5); -INSERT INTO `guild_shops` VALUES (525, 4372, 93, 238, 240, 20); -INSERT INTO `guild_shops` VALUES (525, 4359, 180, 1200, 240, 150); -INSERT INTO `guild_shops` VALUES (525, 4570, 42, 190, 240, 30); -INSERT INTO `guild_shops` VALUES (525, 4363, 33, 200, 240, 30); -INSERT INTO `guild_shops` VALUES (525, 4366, 18, 43, 240, 5); -INSERT INTO `guild_shops` VALUES (525, 4571, 75, 460, 240, 50); -INSERT INTO `guild_shops` VALUES (525, 4367, 36, 238, 240, 35); -INSERT INTO `guild_shops` VALUES (525, 4380, 165, 1076, 240, 150); -INSERT INTO `guild_shops` VALUES (525, 4389, 60, 157, 240, 15); -INSERT INTO `guild_shops` VALUES (525, 4390, 39, 198, 240, 30); -INSERT INTO `guild_shops` VALUES (525, 4392, 30, 152, 240, 21); -INSERT INTO `guild_shops` VALUES (525, 4412, 243, 1547, 240, 250); -INSERT INTO `guild_shops` VALUES (525, 4431, 57, 367, 240, 55); -INSERT INTO `guild_shops` VALUES (525, 4432, 45, 261, 240, 40); -INSERT INTO `guild_shops` VALUES (525, 4445, 14, 220, 240, 35); -INSERT INTO `guild_shops` VALUES (525, 4468, 60, 384, 240, 55); -INSERT INTO `guild_shops` VALUES (525, 4472, 147, 198, 240, 10); -INSERT INTO `guild_shops` VALUES (525, 4491, 150, 992, 240, 125); -INSERT INTO `guild_shops` VALUES (525, 4364, 90, 576, 240, 90); -INSERT INTO `guild_shops` VALUES (525, 4391, 18, 274, 240, 50); -INSERT INTO `guild_shops` VALUES (525, 4510, 21, 50, 240, 5); -INSERT INTO `guild_shops` VALUES (525, 4437, 612, 3024, 240, 400); -INSERT INTO `guild_shops` VALUES (525, 4376, 90, 364, 240, 50); -INSERT INTO `guild_shops` VALUES (525, 4410, 318, 1706, 240, 300); -INSERT INTO `guild_shops` VALUES (525, 4381, 1382, 3600, 240, 300); -INSERT INTO `guild_shops` VALUES (525, 4422, 150, 888, 240, 150); -INSERT INTO `guild_shops` VALUES (525, 4423, 225, 876, 240, 115); -INSERT INTO `guild_shops` VALUES (525, 4424, 825, 3875, 240, 510); -INSERT INTO `guild_shops` VALUES (525, 4441, 697, 4650, 240, 550); -INSERT INTO `guild_shops` VALUES (525, 4442, 300, 1600, 240, 250); -INSERT INTO `guild_shops` VALUES (525, 4425, 254, 1446, 240, 200); -INSERT INTO `guild_shops` VALUES (525, 4406, 638, 2200, 240, 300); -INSERT INTO `guild_shops` VALUES (525, 4436, 240, 1600, 240, 300); -INSERT INTO `guild_shops` VALUES (525, 4490, 955, 2284, 240, 250); -INSERT INTO `guild_shops` VALUES (525, 4572, 1360, 7550, 240, 1100); -INSERT INTO `guild_shops` VALUES (525, 4492, 540, 3000, 240, 400); -INSERT INTO `guild_shops` VALUES (525, 4489, 1950, 5000, 240, 500); -INSERT INTO `guild_shops` VALUES (525, 4555, 1692, 7812, 240, 1100); -INSERT INTO `guild_shops` VALUES (525, 4419, 34440, 34440, 240, 1); -INSERT INTO `guild_shops` VALUES (525, 4417, 3151, 16236, 240, 2500); -INSERT INTO `guild_shops` VALUES (525, 1554, 431, 483, 240, 10); -INSERT INTO `guild_shops` VALUES (525, 1555, 1061, 1188, 240, 25); -INSERT INTO `guild_shops` VALUES (525, 1590, 536, 1344, 240, 150); -INSERT INTO `guild_shops` VALUES (525, 1840, 1500, 3600, 240, 400); -INSERT INTO `guild_shops` VALUES (525, 2112, 530, 540, 240, 2); -INSERT INTO `guild_shops` VALUES (526, 640, 9, 15, 240, 1); -INSERT INTO `guild_shops` VALUES (526, 641, 30, 106, 240, 15); -INSERT INTO `guild_shops` VALUES (526, 643, 675, 3825, 240, 550); -INSERT INTO `guild_shops` VALUES (526, 649, 62, 346, 240, 50); -INSERT INTO `guild_shops` VALUES (526, 651, 2700, 2916, 240, 40); -INSERT INTO `guild_shops` VALUES (526, 660, 69, 138, 240, 15); -INSERT INTO `guild_shops` VALUES (526, 662, 4050, 4050, 240, 1); -INSERT INTO `guild_shops` VALUES (526, 672, 81, 106, 240, 5); -INSERT INTO `guild_shops` VALUES (526, 674, 4945, 30744, 240, 4500); -INSERT INTO `guild_shops` VALUES (526, 676, 7350, 13720, 240, 1200); -INSERT INTO `guild_shops` VALUES (526, 680, 5796, 11781, 240, 1000); -INSERT INTO `guild_shops` VALUES (526, 16411, 9576, 46986, 240, 6250); -INSERT INTO `guild_shops` VALUES (526, 16412, 22320, 49699, 240, 4600); -INSERT INTO `guild_shops` VALUES (526, 16448, 240, 761, 240, 100); -INSERT INTO `guild_shops` VALUES (526, 16545, 21067, 95504, 240, 12500); -INSERT INTO `guild_shops` VALUES (526, 16565, 1395, 8853, 240, 1250); -INSERT INTO `guild_shops` VALUES (526, 16650, 18270, 18270, 240, 1); -INSERT INTO `guild_shops` VALUES (526, 16651, 66555, 209426, 240, 24000); -INSERT INTO `guild_shops` VALUES (526, 13871, 27216, 47355, 240, 3400); -INSERT INTO `guild_shops` VALUES (526, 13873, 36960, 195148, 240, 26500); -INSERT INTO `guild_shops` VALUES (526, 14001, 42476, 88529, 240, 7800); -INSERT INTO `guild_shops` VALUES (526, 14003, 79745, 84198, 240, 750); -INSERT INTO `guild_shops` VALUES (526, 14118, 69400, 69400, 240, 1); -INSERT INTO `guild_shops` VALUES (526, 14243, 27945, 92404, 240, 11000); -INSERT INTO `guild_shops` VALUES (526, 14245, 52785, 166096, 240, 19000); -INSERT INTO `guild_shops` VALUES (526, 2143, 75, 75, 240, 1); -INSERT INTO `guild_shops` VALUES (526, 2144, 75, 75, 240, 1); -INSERT INTO `guild_shops` VALUES (527, 640, 9, 15, 240, 1); -INSERT INTO `guild_shops` VALUES (527, 641, 30, 106, 240, 15); -INSERT INTO `guild_shops` VALUES (527, 643, 675, 3825, 240, 550); -INSERT INTO `guild_shops` VALUES (527, 660, 69, 138, 240, 15); -INSERT INTO `guild_shops` VALUES (527, 652, 3517, 25620, 240, 3700); -INSERT INTO `guild_shops` VALUES (528, 640, 9, 15, 240, 1); -INSERT INTO `guild_shops` VALUES (528, 641, 30, 106, 240, 15); -INSERT INTO `guild_shops` VALUES (528, 643, 675, 3825, 240, 550); -INSERT INTO `guild_shops` VALUES (528, 649, 62, 346, 240, 50); -INSERT INTO `guild_shops` VALUES (528, 651, 2700, 2916, 240, 40); -INSERT INTO `guild_shops` VALUES (528, 660, 69, 138, 240, 15); -INSERT INTO `guild_shops` VALUES (528, 662, 4050, 4050, 240, 1); -INSERT INTO `guild_shops` VALUES (528, 672, 81, 106, 240, 5); -INSERT INTO `guild_shops` VALUES (528, 16473, 5589, 6458, 240, 150); -INSERT INTO `guild_shops` VALUES (528, 16513, 11845, 59229, 240, 8000); -INSERT INTO `guild_shops` VALUES (528, 16640, 290, 695, 240, 125); -INSERT INTO `guild_shops` VALUES (528, 17044, 6033, 26756, 240, 2100); -INSERT INTO `guild_shops` VALUES (528, 12450, 15300, 15552, 240, 75); -INSERT INTO `guild_shops` VALUES (528, 12836, 19088, 19514, 240, 75); -INSERT INTO `guild_shops` VALUES (528, 12706, 12950, 17971, 240, 900); -INSERT INTO `guild_shops` VALUES (528, 12672, 19440, 26956, 240, 1100); -INSERT INTO `guild_shops` VALUES (528, 13080, 13770, 19094, 240, 1000); -INSERT INTO `guild_shops` VALUES (528, 12299, 708, 4611, 240, 655); -INSERT INTO `guild_shops` VALUES (528, 17298, 294, 332, 240, 10); -INSERT INTO `guild_shops` VALUES (60419, 1652, 160, 360, 80, 255); -INSERT INTO `guild_shops` VALUES (60419, 4877, 39270, 102480, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4880, 14070, 15750, 0, 1); -INSERT INTO `guild_shops` VALUES (60419, 4875, 2250, 2250, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4878, 37800, 102480, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4879, 14070, 15750, 0, 1); -INSERT INTO `guild_shops` VALUES (60419, 4874, 40740, 40740, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4876, 41370, 99960, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 704, 96, 149, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 1134, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 1555, 1061, 1259, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 1475, 579, 3128, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 4958, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4937, 1561, 1747, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 5164, 2075, 2179, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 1173, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4952, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 1590, 536, 700, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 4934, 1561, 1747, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 4931, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4949, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 1182, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 1185, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4928, 1561, 1747, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 1167, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 1191, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4955, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 1170, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 1176, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4940, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 1188, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 1179, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 1194, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 5236, 224, 224, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 829, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4943, 1561, 1747, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 657, 4690, 22960, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 915, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4961, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 1164, 30, 65, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 1554, 431, 512, 240, 255); -INSERT INTO `guild_shops` VALUES (60419, 1161, 0, 0, 0, 0); -INSERT INTO `guild_shops` VALUES (60419, 4946, 0, 0, 0, 0); \ No newline at end of file +-- ---------------------------- +-- Records of guild_shops +-- ---------------------------- +INSERT INTO `guild_shops` VALUES ('513', '688', '15', '28', '240', '3'); +INSERT INTO `guild_shops` VALUES ('513', '689', '27', '37', '240', '2'); +INSERT INTO `guild_shops` VALUES ('513', '691', '45', '276', '240', '40'); +INSERT INTO `guild_shops` VALUES ('513', '698', '72', '349', '240', '50'); +INSERT INTO `guild_shops` VALUES ('513', '695', '120', '132', '240', '2'); +INSERT INTO `guild_shops` VALUES ('513', '697', '528', '549', '240', '4'); +INSERT INTO `guild_shops` VALUES ('513', '696', '330', '699', '180', '65'); +INSERT INTO `guild_shops` VALUES ('513', '690', '1378', '10938', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '693', '640', '3586', '60', '45'); +INSERT INTO `guild_shops` VALUES ('513', '694', '2119', '2811', '240', '150'); +INSERT INTO `guild_shops` VALUES ('513', '699', '4740', '24016', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '701', '6615', '8555', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '700', '9075', '9075', '240', '1'); +INSERT INTO `guild_shops` VALUES ('513', '702', '9600', '11520', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '704', '96', '149', '240', '10'); +INSERT INTO `guild_shops` VALUES ('513', '721', '448', '800', '240', '65'); +INSERT INTO `guild_shops` VALUES ('513', '705', '7', '18', '240', '2'); +INSERT INTO `guild_shops` VALUES ('513', '706', '27', '165', '240', '30'); +INSERT INTO `guild_shops` VALUES ('513', '708', '45', '276', '240', '40'); +INSERT INTO `guild_shops` VALUES ('513', '715', '72', '441', '240', '150'); +INSERT INTO `guild_shops` VALUES ('513', '712', '120', '120', '240', '1'); +INSERT INTO `guild_shops` VALUES ('513', '714', '606', '1036', '240', '100'); +INSERT INTO `guild_shops` VALUES ('513', '713', '330', '1672', '240', '225'); +INSERT INTO `guild_shops` VALUES ('513', '707', '1723', '9651', '240', '150'); +INSERT INTO `guild_shops` VALUES ('513', '710', '2119', '3843', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '716', '4740', '24016', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '711', '2537', '4489', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '719', '45568', '62464', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '720', '2687', '20962', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '12984', '111', '292', '240', '50'); +INSERT INTO `guild_shops` VALUES ('513', '12289', '41', '249', '240', '40'); +INSERT INTO `guild_shops` VALUES ('513', '12293', '15132', '15132', '240', '1'); +INSERT INTO `guild_shops` VALUES ('513', '22', '282', '1639', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '97', '227', '5508', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '102', '291', '582', '240', '50'); +INSERT INTO `guild_shops` VALUES ('513', '23', '829', '1858', '240', '175'); +INSERT INTO `guild_shops` VALUES ('513', '92', '738', '3621', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '17024', '48', '351', '240', '55'); +INSERT INTO `guild_shops` VALUES ('513', '17027', '9771', '44478', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '17030', '14766', '81107', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '17050', '247', '1406', '240', '200'); +INSERT INTO `guild_shops` VALUES ('513', '17051', '1049', '2630', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '17088', '113', '286', '240', '30'); +INSERT INTO `guild_shops` VALUES ('513', '17095', '281', '1932', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '17424', '18900', '49980', '240', '255'); +INSERT INTO `guild_shops` VALUES ('513', '17217', '11492', '11492', '240', '1'); +INSERT INTO `guild_shops` VALUES ('513', '17318', '13', '13', '240', '1'); +INSERT INTO `guild_shops` VALUES ('514', '880', '57', '349', '240', '150'); +INSERT INTO `guild_shops` VALUES ('514', '881', '1941', '13398', '240', '150'); +INSERT INTO `guild_shops` VALUES ('514', '882', '150', '190', '240', '150'); +INSERT INTO `guild_shops` VALUES ('514', '884', '4850', '12384', '240', '150'); +INSERT INTO `guild_shops` VALUES ('514', '885', '25584', '69888', '240', '150'); +INSERT INTO `guild_shops` VALUES ('514', '888', '84', '114', '240', '150'); +INSERT INTO `guild_shops` VALUES ('514', '889', '298', '1495', '240', '150'); +INSERT INTO `guild_shops` VALUES ('514', '893', '760', '4141', '240', '150'); +INSERT INTO `guild_shops` VALUES ('514', '894', '968', '2952', '240', '150'); +INSERT INTO `guild_shops` VALUES ('514', '896', '2044', '12166', '240', '150'); +INSERT INTO `guild_shops` VALUES ('514', '897', '1228', '7993', '240', '150'); +INSERT INTO `guild_shops` VALUES ('514', '864', '72', '203', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '833', '15', '22', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '834', '80', '200', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '835', '187', '1000', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '832', '675', '1620', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '839', '137', '870', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '817', '45', '240', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '818', '120', '768', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '819', '750', '4600', '240', '255'); +INSERT INTO `guild_shops` VALUES ('515', '820', '2700', '3312', '240', '100'); +INSERT INTO `guild_shops` VALUES ('515', '816', '596', '3540', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '822', '600', '4480', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '823', '18240', '18240', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '821', '144144', '144144', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '824', '240', '588', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '825', '480', '2944', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '826', '8040', '8040', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '827', '53568', '53568', '240', '150'); +INSERT INTO `guild_shops` VALUES ('515', '841', '36', '200', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '833', '15', '22', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '835', '187', '1000', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '832', '675', '1620', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '839', '137', '870', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '817', '45', '240', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '818', '120', '768', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '819', '750', '4600', '240', '255'); +INSERT INTO `guild_shops` VALUES ('516', '820', '2700', '3312', '240', '100'); +INSERT INTO `guild_shops` VALUES ('516', '816', '596', '3540', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '822', '600', '4480', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '823', '18240', '18240', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '824', '240', '588', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '825', '480', '2944', '240', '150'); +INSERT INTO `guild_shops` VALUES ('516', '847', '10', '40', '240', '8'); +INSERT INTO `guild_shops` VALUES ('516', '841', '36', '200', '240', '150'); +INSERT INTO `guild_shops` VALUES ('517', '17396', '3', '4', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '17395', '9', '12', '240', '2'); +INSERT INTO `guild_shops` VALUES ('517', '16996', '52', '52', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '16997', '52', '266', '240', '50'); +INSERT INTO `guild_shops` VALUES ('517', '16998', '30', '184', '240', '50'); +INSERT INTO `guild_shops` VALUES ('517', '16999', '52', '240', '240', '50'); +INSERT INTO `guild_shops` VALUES ('517', '17000', '52', '322', '240', '75'); +INSERT INTO `guild_shops` VALUES ('517', '17392', '213', '433', '240', '75'); +INSERT INTO `guild_shops` VALUES ('517', '17393', '213', '213', '240', '150'); +INSERT INTO `guild_shops` VALUES ('517', '17394', '220', '220', '240', '150'); +INSERT INTO `guild_shops` VALUES ('517', '16992', '52', '238', '240', '75'); +INSERT INTO `guild_shops` VALUES ('517', '16993', '52', '64', '240', '5'); +INSERT INTO `guild_shops` VALUES ('517', '16994', '52', '52', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '17405', '540', '540', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '17407', '270', '364', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '17404', '540', '540', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '17399', '2394', '2394', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '17391', '44', '74', '240', '10'); +INSERT INTO `guild_shops` VALUES ('517', '17390', '145', '245', '240', '10'); +INSERT INTO `guild_shops` VALUES ('517', '17389', '332', '561', '240', '75'); +INSERT INTO `guild_shops` VALUES ('517', '17388', '934', '1667', '240', '150'); +INSERT INTO `guild_shops` VALUES ('517', '17387', '4077', '4077', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '17380', '25740', '25740', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '17383', '1980', '2640', '240', '200'); +INSERT INTO `guild_shops` VALUES ('517', '17382', '9657', '15398', '240', '255'); +INSERT INTO `guild_shops` VALUES ('517', '4443', '24', '165', '240', '25'); +INSERT INTO `guild_shops` VALUES ('517', '4472', '30', '198', '240', '50'); +INSERT INTO `guild_shops` VALUES ('517', '624', '24', '156', '240', '25'); +INSERT INTO `guild_shops` VALUES ('517', '4484', '1350', '8784', '240', '255'); +INSERT INTO `guild_shops` VALUES ('517', '4426', '195', '665', '240', '100'); +INSERT INTO `guild_shops` VALUES ('517', '4427', '1350', '1350', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '4482', '1712', '2000', '240', '100'); +INSERT INTO `guild_shops` VALUES ('517', '4783', '195', '1248', '240', '255'); +INSERT INTO `guild_shops` VALUES ('517', '4428', '45', '396', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '4361', '1196', '1289', '240', '25'); +INSERT INTO `guild_shops` VALUES ('517', '4304', '30520', '34720', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '4481', '505', '748', '240', '75'); +INSERT INTO `guild_shops` VALUES ('517', '4385', '520', '748', '240', '75'); +INSERT INTO `guild_shops` VALUES ('517', '4402', '8064', '8568', '240', '100'); +INSERT INTO `guild_shops` VALUES ('517', '4383', '3225', '5621', '240', '255'); +INSERT INTO `guild_shops` VALUES ('517', '4399', '1350', '4680', '240', '255'); +INSERT INTO `guild_shops` VALUES ('517', '4485', '13888', '13888', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '4290', '1008', '1289', '240', '50'); +INSERT INTO `guild_shops` VALUES ('517', '4451', '5440', '19520', '240', '255'); +INSERT INTO `guild_shops` VALUES ('517', '4461', '4050', '4050', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '4384', '5250', '5250', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '4514', '60', '396', '240', '50'); +INSERT INTO `guild_shops` VALUES ('517', '4580', '4760', '4760', '240', '1'); +INSERT INTO `guild_shops` VALUES ('517', '4462', '1350', '8064', '240', '255'); +INSERT INTO `guild_shops` VALUES ('517', '4480', '455', '2800', '240', '255'); +INSERT INTO `guild_shops` VALUES ('517', '4479', '7560', '8784', '240', '250'); +INSERT INTO `guild_shops` VALUES ('517', '4471', '11984', '13888', '240', '255'); +INSERT INTO `guild_shops` VALUES ('518', '17388', '766', '1667', '240', '150'); +INSERT INTO `guild_shops` VALUES ('518', '17382', '7081', '15398', '240', '255'); +INSERT INTO `guild_shops` VALUES ('518', '4399', '1350', '4680', '240', '255'); +INSERT INTO `guild_shops` VALUES ('518', '4485', '2100', '13888', '240', '255'); +INSERT INTO `guild_shops` VALUES ('518', '4317', '120', '120', '240', '1'); +INSERT INTO `guild_shops` VALUES ('518', '4484', '1350', '8784', '240', '255'); +INSERT INTO `guild_shops` VALUES ('518', '4385', '115', '748', '240', '110'); +INSERT INTO `guild_shops` VALUES ('518', '5121', '2142', '2142', '240', '1'); +INSERT INTO `guild_shops` VALUES ('518', '4314', '300', '600', '240', '50'); +INSERT INTO `guild_shops` VALUES ('518', '4318', '3375', '3375', '240', '1'); +INSERT INTO `guild_shops` VALUES ('518', '624', '24', '156', '240', '25'); +INSERT INTO `guild_shops` VALUES ('518', '4443', '24', '165', '240', '25'); +INSERT INTO `guild_shops` VALUES ('519', '17395', '9', '12', '240', '2'); +INSERT INTO `guild_shops` VALUES ('519', '17399', '2394', '2394', '240', '1'); +INSERT INTO `guild_shops` VALUES ('519', '17407', '270', '364', '240', '1'); +INSERT INTO `guild_shops` VALUES ('519', '17400', '691', '4000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('519', '17387', '4077', '4077', '240', '1'); +INSERT INTO `guild_shops` VALUES ('519', '4360', '25', '153', '240', '25'); +INSERT INTO `guild_shops` VALUES ('519', '4484', '1350', '8928', '240', '255'); +INSERT INTO `guild_shops` VALUES ('519', '4399', '1350', '8856', '240', '255'); +INSERT INTO `guild_shops` VALUES ('519', '4485', '2100', '13888', '240', '255'); +INSERT INTO `guild_shops` VALUES ('519', '4451', '5440', '19520', '240', '255'); +INSERT INTO `guild_shops` VALUES ('519', '4514', '60', '396', '240', '50'); +INSERT INTO `guild_shops` VALUES ('519', '4480', '455', '2800', '240', '255'); +INSERT INTO `guild_shops` VALUES ('520', '17399', '2394', '2394', '240', '1'); +INSERT INTO `guild_shops` VALUES ('520', '17387', '4077', '4077', '240', '1'); +INSERT INTO `guild_shops` VALUES ('520', '17383', '1980', '2640', '240', '200'); +INSERT INTO `guild_shops` VALUES ('520', '17388', '934', '1667', '240', '150'); +INSERT INTO `guild_shops` VALUES ('520', '17382', '9657', '15398', '240', '255'); +INSERT INTO `guild_shops` VALUES ('520', '4472', '30', '198', '240', '50'); +INSERT INTO `guild_shops` VALUES ('520', '624', '24', '156', '240', '25'); +INSERT INTO `guild_shops` VALUES ('520', '4360', '25', '153', '240', '25'); +INSERT INTO `guild_shops` VALUES ('520', '4484', '1350', '8784', '240', '255'); +INSERT INTO `guild_shops` VALUES ('520', '4385', '520', '775', '240', '75'); +INSERT INTO `guild_shops` VALUES ('520', '4399', '1350', '7920', '240', '255'); +INSERT INTO `guild_shops` VALUES ('520', '4485', '12208', '13888', '240', '255'); +INSERT INTO `guild_shops` VALUES ('520', '4451', '3280', '19520', '240', '255'); +INSERT INTO `guild_shops` VALUES ('520', '4461', '4050', '4995', '240', '175'); +INSERT INTO `guild_shops` VALUES ('520', '4384', '5250', '27160', '240', '255'); +INSERT INTO `guild_shops` VALUES ('520', '4500', '29', '147', '240', '20'); +INSERT INTO `guild_shops` VALUES ('520', '4514', '60', '396', '240', '50'); +INSERT INTO `guild_shops` VALUES ('520', '4480', '455', '2800', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '914', '1125', '5100', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '920', '1084', '5494', '240', '150'); +INSERT INTO `guild_shops` VALUES ('521', '922', '297', '300', '240', '1'); +INSERT INTO `guild_shops` VALUES ('521', '925', '1012', '4017', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '1108', '573', '795', '240', '40'); +INSERT INTO `guild_shops` VALUES ('521', '951', '90', '504', '240', '70'); +INSERT INTO `guild_shops` VALUES ('521', '621', '21', '30', '240', '2'); +INSERT INTO `guild_shops` VALUES ('521', '622', '36', '57', '240', '4'); +INSERT INTO `guild_shops` VALUES ('521', '636', '15', '97', '255', '75'); +INSERT INTO `guild_shops` VALUES ('521', '4165', '984', '5856', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '638', '138', '777', '240', '125'); +INSERT INTO `guild_shops` VALUES ('521', '4443', '24', '165', '240', '25'); +INSERT INTO `guild_shops` VALUES ('521', '933', '600', '3360', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '932', '1020', '5712', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '4154', '6300', '7700', '240', '250'); +INSERT INTO `guild_shops` VALUES ('521', '4157', '800', '2240', '240', '240'); +INSERT INTO `guild_shops` VALUES ('521', '4150', '600', '3584', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '4162', '810', '4284', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '947', '3360', '21862', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '4166', '750', '4480', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '4112', '682', '946', '240', '50'); +INSERT INTO `guild_shops` VALUES ('521', '4116', '3375', '5760', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '4128', '4348', '22227', '240', '255'); +INSERT INTO `guild_shops` VALUES ('521', '2131', '75', '150', '240', '15'); +INSERT INTO `guild_shops` VALUES ('521', '18228', '114', '114', '240', '1'); +INSERT INTO `guild_shops` VALUES ('521', '18232', '114', '114', '240', '1'); +INSERT INTO `guild_shops` VALUES ('521', '18236', '21', '28', '240', '2'); +INSERT INTO `guild_shops` VALUES ('522', '640', '9', '26', '240', '5'); +INSERT INTO `guild_shops` VALUES ('522', '736', '315', '705', '240', '100'); +INSERT INTO `guild_shops` VALUES ('522', '644', '1500', '9800', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '746', '250380', '250380', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '752', '55755', '55755', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '754', '87187', '87187', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '673', '210', '1131', '240', '150'); +INSERT INTO `guild_shops` VALUES ('522', '681', '10500', '42000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '762', '334800', '334800', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '769', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '770', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '771', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '772', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '773', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '774', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '775', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '776', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '795', '1396', '1937', '240', '100'); +INSERT INTO `guild_shops` VALUES ('522', '796', '1396', '1937', '240', '100'); +INSERT INTO `guild_shops` VALUES ('522', '799', '1396', '1937', '240', '100'); +INSERT INTO `guild_shops` VALUES ('522', '800', '1396', '1937', '240', '100'); +INSERT INTO `guild_shops` VALUES ('522', '806', '1396', '1937', '240', '100'); +INSERT INTO `guild_shops` VALUES ('522', '807', '1396', '1937', '240', '100'); +INSERT INTO `guild_shops` VALUES ('522', '809', '1396', '1937', '240', '100'); +INSERT INTO `guild_shops` VALUES ('522', '814', '1396', '1937', '240', '100'); +INSERT INTO `guild_shops` VALUES ('522', '788', '9000', '16320', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '790', '9000', '16320', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '811', '9000', '16320', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '815', '9000', '16320', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '798', '9000', '16320', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '808', '9000', '16320', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '784', '23400', '49608', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '803', '23400', '49608', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '810', '23400', '49608', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '801', '23400', '49608', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '791', '23400', '49608', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '805', '23400', '49608', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '797', '23400', '49608', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '802', '23400', '49608', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '785', '48336', '284544', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '786', '48336', '284544', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '804', '48336', '284544', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '794', '48336', '284544', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '13327', '1125', '5850', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '13316', '73416', '73416', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '13332', '1186', '1728', '240', '110'); +INSERT INTO `guild_shops` VALUES ('522', '13333', '1186', '1728', '240', '110'); +INSERT INTO `guild_shops` VALUES ('522', '13334', '1186', '1728', '240', '110'); +INSERT INTO `guild_shops` VALUES ('522', '13336', '1186', '1728', '240', '110'); +INSERT INTO `guild_shops` VALUES ('522', '13454', '114', '255', '240', '50'); +INSERT INTO `guild_shops` VALUES ('522', '13446', '21060', '21060', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '13444', '1875', '2950', '240', '200'); +INSERT INTO `guild_shops` VALUES ('522', '13471', '1875', '2950', '240', '200'); +INSERT INTO `guild_shops` VALUES ('522', '13472', '1875', '2950', '240', '200'); +INSERT INTO `guild_shops` VALUES ('522', '13474', '1875', '2950', '240', '200'); +INSERT INTO `guild_shops` VALUES ('522', '12496', '117', '117', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '12497', '1029', '1080', '240', '10'); +INSERT INTO `guild_shops` VALUES ('522', '12495', '4398', '4896', '240', '100'); +INSERT INTO `guild_shops` VALUES ('522', '16551', '1233', '3631', '240', '255'); +INSERT INTO `guild_shops` VALUES ('522', '16641', '6240', '6240', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '17081', '3229', '3229', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '12449', '7128', '7128', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '12577', '9144', '9144', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '12833', '1750', '1750', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '12961', '985', '985', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '1588', '20400', '20400', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '2143', '75', '75', '240', '1'); +INSERT INTO `guild_shops` VALUES ('522', '2144', '75', '75', '240', '1'); +INSERT INTO `guild_shops` VALUES ('523', '640', '9', '26', '240', '5'); +INSERT INTO `guild_shops` VALUES ('523', '736', '315', '705', '240', '100'); +INSERT INTO `guild_shops` VALUES ('523', '769', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('523', '770', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('523', '771', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('523', '772', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('523', '773', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('523', '774', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('523', '775', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('523', '776', '2632', '6328', '240', '255'); +INSERT INTO `guild_shops` VALUES ('523', '2143', '75', '75', '240', '1'); +INSERT INTO `guild_shops` VALUES ('523', '2144', '75', '75', '240', '1'); +INSERT INTO `guild_shops` VALUES ('524', '856', '45', '276', '240', '40'); +INSERT INTO `guild_shops` VALUES ('524', '505', '57', '349', '240', '50'); +INSERT INTO `guild_shops` VALUES ('524', '858', '483', '2967', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '859', '937', '3250', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '861', '393', '1312', '240', '160'); +INSERT INTO `guild_shops` VALUES ('524', '863', '2700', '12240', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '851', '4250', '16670', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '506', '5173', '33796', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '853', '2155', '13680', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '854', '2650', '3427', '240', '125'); +INSERT INTO `guild_shops` VALUES ('524', '834', '675', '3276', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '695', '120', '120', '240', '1'); +INSERT INTO `guild_shops` VALUES ('524', '4509', '9', '12', '240', '1'); +INSERT INTO `guild_shops` VALUES ('524', '917', '1821', '2245', '240', '75'); +INSERT INTO `guild_shops` VALUES ('524', '13594', '132', '246', '240', '25'); +INSERT INTO `guild_shops` VALUES ('524', '13588', '2484', '3146', '240', '125'); +INSERT INTO `guild_shops` VALUES ('524', '13571', '7282', '37356', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '13570', '10800', '11304', '240', '100'); +INSERT INTO `guild_shops` VALUES ('524', '13593', '24000', '24640', '240', '110'); +INSERT INTO `guild_shops` VALUES ('524', '13203', '2641', '2641', '240', '1'); +INSERT INTO `guild_shops` VALUES ('524', '13200', '13860', '80572', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '13081', '411', '411', '240', '1'); +INSERT INTO `guild_shops` VALUES ('524', '13089', '6384', '15662', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '12569', '13514', '33476', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '12572', '44460', '163612', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '12993', '3366', '7001', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '12994', '14352', '54537', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '12696', '324', '1425', '240', '200'); +INSERT INTO `guild_shops` VALUES ('524', '12697', '2700', '17136', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '12700', '29700', '182160', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '12440', '396', '1566', '240', '200'); +INSERT INTO `guild_shops` VALUES ('524', '12442', '13179', '51000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '12824', '482', '2615', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '12992', '453', '629', '240', '40'); +INSERT INTO `guild_shops` VALUES ('524', '16386', '945', '3780', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '16388', '11970', '41496', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '12294', '25920', '158976', '240', '255'); +INSERT INTO `guild_shops` VALUES ('524', '2129', '75', '75', '240', '1'); +INSERT INTO `guild_shops` VALUES ('525', '936', '14', '67', '240', '10'); +INSERT INTO `guild_shops` VALUES ('525', '611', '30', '42', '240', '2'); +INSERT INTO `guild_shops` VALUES ('525', '610', '45', '66', '240', '4'); +INSERT INTO `guild_shops` VALUES ('525', '612', '45', '194', '240', '30'); +INSERT INTO `guild_shops` VALUES ('525', '614', '60', '361', '240', '55'); +INSERT INTO `guild_shops` VALUES ('525', '4378', '45', '264', '240', '40'); +INSERT INTO `guild_shops` VALUES ('525', '616', '60', '368', '240', '50'); +INSERT INTO `guild_shops` VALUES ('525', '618', '21', '50', '240', '5'); +INSERT INTO `guild_shops` VALUES ('525', '619', '36', '42', '240', '1'); +INSERT INTO `guild_shops` VALUES ('525', '620', '45', '276', '240', '50'); +INSERT INTO `guild_shops` VALUES ('525', '621', '21', '25', '240', '1'); +INSERT INTO `guild_shops` VALUES ('525', '622', '36', '220', '240', '35'); +INSERT INTO `guild_shops` VALUES ('525', '625', '66', '334', '240', '50'); +INSERT INTO `guild_shops` VALUES ('525', '628', '195', '572', '240', '50'); +INSERT INTO `guild_shops` VALUES ('525', '629', '36', '220', '240', '40'); +INSERT INTO `guild_shops` VALUES ('525', '4358', '139', '163', '240', '5'); +INSERT INTO `guild_shops` VALUES ('525', '4372', '93', '238', '240', '20'); +INSERT INTO `guild_shops` VALUES ('525', '4359', '180', '1200', '240', '150'); +INSERT INTO `guild_shops` VALUES ('525', '4570', '42', '190', '240', '30'); +INSERT INTO `guild_shops` VALUES ('525', '4363', '33', '200', '240', '30'); +INSERT INTO `guild_shops` VALUES ('525', '4366', '18', '43', '240', '5'); +INSERT INTO `guild_shops` VALUES ('525', '4571', '75', '460', '240', '50'); +INSERT INTO `guild_shops` VALUES ('525', '4367', '36', '238', '240', '35'); +INSERT INTO `guild_shops` VALUES ('525', '4380', '165', '1076', '240', '150'); +INSERT INTO `guild_shops` VALUES ('525', '4389', '60', '157', '240', '15'); +INSERT INTO `guild_shops` VALUES ('525', '4390', '39', '198', '240', '30'); +INSERT INTO `guild_shops` VALUES ('525', '4392', '30', '152', '240', '21'); +INSERT INTO `guild_shops` VALUES ('525', '4412', '243', '1547', '240', '250'); +INSERT INTO `guild_shops` VALUES ('525', '4431', '57', '367', '240', '55'); +INSERT INTO `guild_shops` VALUES ('525', '4432', '45', '261', '240', '40'); +INSERT INTO `guild_shops` VALUES ('525', '4445', '14', '220', '240', '35'); +INSERT INTO `guild_shops` VALUES ('525', '4468', '60', '384', '240', '55'); +INSERT INTO `guild_shops` VALUES ('525', '4472', '147', '198', '240', '10'); +INSERT INTO `guild_shops` VALUES ('525', '4491', '150', '992', '240', '125'); +INSERT INTO `guild_shops` VALUES ('525', '4364', '90', '576', '240', '90'); +INSERT INTO `guild_shops` VALUES ('525', '4391', '18', '274', '240', '50'); +INSERT INTO `guild_shops` VALUES ('525', '4510', '21', '50', '240', '5'); +INSERT INTO `guild_shops` VALUES ('525', '4437', '612', '3024', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '4376', '90', '364', '240', '50'); +INSERT INTO `guild_shops` VALUES ('525', '4410', '318', '1706', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '4381', '1382', '3600', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '4422', '150', '888', '240', '150'); +INSERT INTO `guild_shops` VALUES ('525', '4423', '225', '876', '240', '115'); +INSERT INTO `guild_shops` VALUES ('525', '4424', '825', '3875', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '4441', '697', '4650', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '4442', '300', '1600', '240', '250'); +INSERT INTO `guild_shops` VALUES ('525', '4425', '254', '1446', '240', '200'); +INSERT INTO `guild_shops` VALUES ('525', '4406', '638', '2200', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '4436', '240', '1600', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '4490', '955', '2284', '240', '250'); +INSERT INTO `guild_shops` VALUES ('525', '4572', '1360', '7550', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '4492', '540', '3000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '4489', '1950', '5000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '4555', '1692', '7812', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '4419', '34440', '34440', '240', '1'); +INSERT INTO `guild_shops` VALUES ('525', '4417', '3151', '16236', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '1554', '431', '483', '240', '10'); +INSERT INTO `guild_shops` VALUES ('525', '1555', '1061', '1188', '240', '25'); +INSERT INTO `guild_shops` VALUES ('525', '1590', '536', '1344', '240', '150'); +INSERT INTO `guild_shops` VALUES ('525', '1840', '1500', '3600', '240', '255'); +INSERT INTO `guild_shops` VALUES ('525', '2112', '530', '540', '240', '2'); +INSERT INTO `guild_shops` VALUES ('526', '640', '9', '15', '240', '1'); +INSERT INTO `guild_shops` VALUES ('526', '641', '30', '106', '240', '15'); +INSERT INTO `guild_shops` VALUES ('526', '643', '675', '3825', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '649', '62', '346', '240', '50'); +INSERT INTO `guild_shops` VALUES ('526', '651', '2700', '2916', '240', '40'); +INSERT INTO `guild_shops` VALUES ('526', '660', '69', '138', '240', '15'); +INSERT INTO `guild_shops` VALUES ('526', '662', '4050', '4050', '240', '1'); +INSERT INTO `guild_shops` VALUES ('526', '672', '81', '106', '240', '5'); +INSERT INTO `guild_shops` VALUES ('526', '674', '4945', '30744', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '676', '7350', '13720', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '680', '5796', '11781', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '16411', '9576', '46986', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '16412', '22320', '49699', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '16448', '240', '761', '240', '100'); +INSERT INTO `guild_shops` VALUES ('526', '16545', '21067', '95504', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '16565', '1395', '8853', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '16650', '18270', '18270', '240', '1'); +INSERT INTO `guild_shops` VALUES ('526', '16651', '66555', '209426', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '13871', '27216', '47355', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '13873', '36960', '195148', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '14001', '42476', '88529', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '14003', '79745', '84198', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '14118', '69400', '69400', '240', '1'); +INSERT INTO `guild_shops` VALUES ('526', '14243', '27945', '92404', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '14245', '52785', '166096', '240', '255'); +INSERT INTO `guild_shops` VALUES ('526', '2143', '75', '75', '240', '1'); +INSERT INTO `guild_shops` VALUES ('526', '2144', '75', '75', '240', '1'); +INSERT INTO `guild_shops` VALUES ('527', '640', '9', '15', '240', '1'); +INSERT INTO `guild_shops` VALUES ('527', '641', '30', '106', '240', '15'); +INSERT INTO `guild_shops` VALUES ('527', '643', '675', '3825', '240', '255'); +INSERT INTO `guild_shops` VALUES ('527', '660', '69', '138', '240', '15'); +INSERT INTO `guild_shops` VALUES ('527', '652', '3517', '25620', '240', '255'); +INSERT INTO `guild_shops` VALUES ('528', '640', '9', '15', '240', '1'); +INSERT INTO `guild_shops` VALUES ('528', '641', '30', '106', '240', '15'); +INSERT INTO `guild_shops` VALUES ('528', '643', '675', '3825', '240', '255'); +INSERT INTO `guild_shops` VALUES ('528', '649', '62', '346', '240', '50'); +INSERT INTO `guild_shops` VALUES ('528', '651', '2700', '2916', '240', '40'); +INSERT INTO `guild_shops` VALUES ('528', '660', '69', '138', '240', '15'); +INSERT INTO `guild_shops` VALUES ('528', '662', '4050', '4050', '240', '1'); +INSERT INTO `guild_shops` VALUES ('528', '672', '81', '106', '240', '5'); +INSERT INTO `guild_shops` VALUES ('528', '16473', '5589', '6458', '240', '150'); +INSERT INTO `guild_shops` VALUES ('528', '16513', '11845', '59229', '240', '255'); +INSERT INTO `guild_shops` VALUES ('528', '16640', '290', '695', '240', '125'); +INSERT INTO `guild_shops` VALUES ('528', '17044', '6033', '26756', '240', '255'); +INSERT INTO `guild_shops` VALUES ('528', '12450', '15300', '15552', '240', '75'); +INSERT INTO `guild_shops` VALUES ('528', '12836', '19088', '19514', '240', '75'); +INSERT INTO `guild_shops` VALUES ('528', '12706', '12950', '17971', '240', '255'); +INSERT INTO `guild_shops` VALUES ('528', '12672', '19440', '26956', '240', '255'); +INSERT INTO `guild_shops` VALUES ('528', '13080', '13770', '19094', '240', '255'); +INSERT INTO `guild_shops` VALUES ('528', '12299', '708', '4611', '240', '255'); +INSERT INTO `guild_shops` VALUES ('528', '17298', '294', '332', '240', '10'); +INSERT INTO `guild_shops` VALUES ('60419', '1652', '160', '360', '80', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '4877', '39270', '102480', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4880', '14070', '15750', '0', '1'); +INSERT INTO `guild_shops` VALUES ('60419', '4875', '2250', '2250', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4878', '37800', '102480', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4879', '14070', '15750', '0', '1'); +INSERT INTO `guild_shops` VALUES ('60419', '4874', '40740', '40740', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4876', '41370', '99960', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '704', '96', '149', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '1134', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '1555', '1061', '1259', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '1475', '579', '3128', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '4958', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4937', '1561', '1747', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '5164', '2075', '2179', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '1173', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4952', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '1590', '536', '700', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '4934', '1561', '1747', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '4931', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4949', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '1182', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '1185', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4928', '1561', '1747', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '1167', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '1191', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4955', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '1170', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '1176', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4940', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '1188', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '1179', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '1194', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '5236', '224', '224', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '829', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4943', '1561', '1747', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '657', '4690', '22960', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '915', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '4961', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60419', '1164', '30', '65', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '1554', '431', '512', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60419', '1161', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '626', '190', '1111', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60420', '620', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '657', '4690', '10500', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '704', '96', '397', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60420', '829', '35070', '77280', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '915', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1134', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1161', '66', '147', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1164', '30', '190', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1167', '147', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1170', '58', '147', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1173', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1176', '44', '147', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1179', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1182', '445', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1185', '395', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1188', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1191', '112', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1194', '460', '545', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1240', '165', '660', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1415', '55147', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1471', '316', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60420', '1475', '579', '1188', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '1554', '431', '512', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60420', '1555', '1019', '1259', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60420', '1590', '536', '2944', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60420', '1652', '150', '200', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60420', '2702', '1500', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4928', '1561', '6713', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4931', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4934', '1561', '6713', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4937', '1561', '6713', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4940', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4943', '1561', '6713', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4946', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4949', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4952', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4955', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4958', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '4961', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60420', '5164', '1945', '2854', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60420', '5237', '369', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60418', '474', '21000', '21000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60418', '475', '21000', '21000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60418', '476', '21000', '21000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60418', '477', '21000', '21000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60418', '478', '21000', '21000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60418', '479', '21000', '21000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60418', '480', '21000', '21000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60418', '481', '21000', '21000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '16962', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16406', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16420', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16407', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '13207', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17340', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16405', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17284', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16411', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '12585', '4931', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12457', '3272', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12969', '2528', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12841', '3951', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12713', '2713', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '16990', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16413', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '13088', '91200', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16974', '224510', '640640', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17322', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17304', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '13206', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16421', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '12456', '552', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12843', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '12587', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '13204', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16915', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16924', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16973', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16970', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17320', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16984', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17302', '1190', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '13728', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16903', '118496', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16897', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16871', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16975', '13266', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12584', '833', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '17802', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16901', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '12715', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16988', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16896', '592', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12968', '424', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '17303', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16967', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17285', '117904', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16412', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17267', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16982', '16004', '39645', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '13111', '20510', '146116', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16991', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16987', '14033', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16419', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17309', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17259', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17314', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '13208', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16902', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '12588', '72600', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '12460', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '12844', '94248', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '12716', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16919', '22765', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16913', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '17301', '43', '151', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '13205', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '12840', '666', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12586', '13266', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12458', '8972', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12970', '11071', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12842', '10805', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '12714', '7428', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '16917', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '16966', '2103', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '17265', '25340', '63742', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '12712', '458', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '16960', '3575', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '16900', '1608', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60417', '16964', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60417', '12459', '32436', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60421', '704', '96', '149', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1134', '810', '2095', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60421', '1555', '1061', '1259', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1475', '579', '1188', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1472', '369', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '5164', '1945', '2854', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1173', '40', '147', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1590', '536', '700', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1155', '436', '645', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1182', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60421', '1185', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60421', '1167', '30', '66', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1191', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60421', '1170', '30', '137', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1176', '30', '120', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '5235', '187', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1652', '150', '160', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1188', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60421', '1179', '96', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60421', '1194', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60421', '829', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60421', '657', '4690', '21000', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '915', '2700', '16120', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1164', '30', '65', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1554', '431', '512', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1161', '30', '96', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60421', '1415', '55147', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16962', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '704', '108', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '1134', '810', '993', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '13207', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '17340', '58', '436', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '1555', '1259', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12585', '5520', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12457', '3663', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12969', '2830', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12841', '4423', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12713', '3037', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '1475', '579', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '16990', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '13088', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16974', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '17322', '81', '116', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '17304', '57960', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '1472', '369', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '13206', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '5164', '1945', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12456', '618', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12843', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '12587', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '13204', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16915', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '1173', '172', '174', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '16924', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '1590', '639', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '16973', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16970', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '17320', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '1155', '436', '1422', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '16984', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '17302', '347', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '13728', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '1182', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16903', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16897', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '1185', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16871', '404395', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16975', '11583', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '1167', '94', '174', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12584', '933', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '17802', '418563', '464059', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16901', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '1191', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '12715', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16988', '14676', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '16896', '517', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12968', '475', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '1170', '94', '174', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '16967', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '1176', '94', '174', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '17285', '220248', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '5235', '187', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '17267', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16982', '4752', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '13111', '29942', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16991', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16987', '12253', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '17259', '158976', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '17314', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '13208', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '1652', '150', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '1188', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16902', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '1179', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '12588', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '12460', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '12844', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '12716', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16919', '2728', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '1194', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '16913', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '17301', '29', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '829', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '13205', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '12840', '745', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12586', '14850', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12458', '10044', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12970', '12393', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12842', '12096', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '12714', '8316', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '16917', '4226', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '16966', '4226', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '657', '4690', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '17265', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '12712', '513', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '915', '2700', '6048', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '1164', '30', '65', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '1554', '512', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '16960', '3121', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '1161', '160', '174', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '1415', '55147', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '16900', '1404', '0', '240', '255'); +INSERT INTO `guild_shops` VALUES ('60422', '16964', '0', '0', '0', '0'); +INSERT INTO `guild_shops` VALUES ('60422', '12459', '0', '0', '0', '0');