DELETE 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');