rendered paste bodyDELETE FROM custom_spawnlist WHERE id in (80002,80001,80000,126530,126528,126527,126513,126512,12535,129192,129191,129190,129193,129194,129195,129197,129196);
DELETE FROM spawnlist WHERE id in (80002,80001,80000,126530,126528,126527,126513,126512,12535,129192,129191,129190,129193,129194,129195,129197,129196);
-- Giran Area
REPLACE INTO spawnlist VALUES
('id', 'location', 'count','npc_templateid', 'locx', 'locy', 'locz', 'randomx', 'randomy', 'heading', 'respawn_delay', 'loc_id', 'periodOfDay'),
('80002', 'Armor Trader', '1', '30838', '82218', '148901', '-3466', '0', '0', '0', '60', '0', '0'),
('80001', 'Misc Trader', '1', '30842', '82213', '148307', '-3466', '0', '0', '0', '60', '0', '0'),
('80000', 'Weapon Trader', '1', '30837', '82344', '148605', '-3466', '0', '0', '0', '60', '0', '0'),
('126530', 'Blacksmith of Mammon', '1', '31126', '82217', '148731', '-3467', '0', '0', '3545', '60', '0', '0'),
('126528', 'Merchant of Mammon', '1', '31113', '82223', '148606', '-3467', '0', '0', '64055', '60', '0', '0'),
('126527', 'Black Marketeer', '1', '31092', '82226', '148479', '-3467', '0', '0', '57865', '60', '0', '0'),
('126513', 'Beryl the Cat', '1', '31774', '82393', '148803', '-3467', '0', '0', '5290', '60', '0', '0'),
('126512', 'Roy the Cat', '1', '31228', '82389', '148413', '-3467', '0', '0', '61506', '60', '0', '0'),
('126535', 'Anchient Trader', '1', '70001', '83171', '148393', '-3372', '0', '0', '33713', '60', '0', '0');
-- Goddard Area
REPLACE INTO spawnlist VALUES
('129192', 'Weapon Trader', '1', '30837', '147495', '-55319', '-2734', '0', '0', '57760', '60', '0', '0'),
('129191', 'Misc Trader', '1', '30838', '147350', '-55453', '-2734', '0', '0', '55828', '60', '0', '0'),
('129190', 'Armor Trader', '1', '30842', '147426', '-55382', '-2734', '0', '0', '55676', '60', '0', '0'),
('129193', 'BlackSmith of Mammon', '1', '31126', '147273', '-55561', '-2742', '0', '0', '58020', '60', '0', '0'),
('129194', 'Merchant of Mammon', '1', '31113', '147293', '-55676', '-2750', '0', '0', '62602', '60', '0', '0'),
('129195', 'Black Marketeer', '1', '31092', '147337', '-55787', '-2758', '0', '0', '62721', '60', '0', '0'),
('129197', 'Beryl the Cat', '1', '31774', '148106', '-55577', '-2742', '0', '0', '36597', '60', '0', '0'),
('129196', 'Roy the Cat', '1', '31228', '148101', '-55467', '-2734', '0', '0'; '36510', '60', '0', '0');
-- Spawn Guard
REPLACE INTO spawnlist VALUES
-- Archers
('1000', 'WoA', '1', '30000', '193367', '-46427', '-2903', '0', '0', '36510', '60', '0', '0'),
('1001', 'MoS', '1', '30000', '123952', '-75322', '-2894', '0', '0', '36510', '60', '0', '0'),
('1002', 'Ketra Orc Outpost', '1', '30000', '130682', '-71915', '-3481', '0', '0', '36510', '60', '0', '0'),
('1003', 'Lair of Valakas', '1', '30000', '190008', '-106527', '-784', '0', '0', '36510', '60', '0', '0'),
('1004', 'Barka Silenos', '1', '30000', '125967', '-41141', '-3729', '0', '0', '36510', '60', '0', '0'),
('1005', 'Dino Island', '1', '30000', '26671', '-12331', '-2483', '0', '0', '36510', '60', '0', '0'),
-- Fighters
('1006', 'WoA', '1', '30001', '194008', '-45602', '-2889', '0', '0', '36510', '60', '0', '0'),
('1007', 'MoS', '1', '30001', '123271', '-74694', '-2891', '0', '0', '36510', '60', '0', '0'),
('1008', 'Ketra Orc Outpost', '1', '30001', '130823', '-72509', '-3513', '0', '0', '36510', '60', '0', '0'),
('1009', 'Lair of Valakas', '1', '30001', '190461', '-106329', '-785', '0', '0', '36510', '60', '0', '0'),
('1010', 'Barka Silenos', '1', '30001', '125696', '-40438', '-3781', '0', '0', '36510', '60', '0', '0'),
('1011', 'Dino Island', '1', '30001', '26369', '-11779', '-2517', '0', '0'; '36510', '60', '0', '0');