Code: Select all
-- Sunbreeze Festival Music Cities, and City Outlands
UPDATE zone_settings SET music = '227' WHERE zoneid IN ('230','231','232','233','238','239','240','241','242','234','235','236','237');
UPDATE zone_settings SET music = '227' WHERE zoneid IN ('101','102','106','107','115','116');
-- Jeuno Christmas Music
UPDATE zone_settings SET music = '239' WHERE zoneid IN ('243','244','245','246');
-- City Outlands Defaults (Restore after Sunbreeze)
UPDATE zone_settings SET music = '116' WHERE zoneid IN ('106','107');
UPDATE zone_settings SET music = '109' WHERE zoneid IN ('101');
UPDATE zone_settings SET music = '227' WHERE zoneid IN ('102');
UPDATE zone_settings SET music = '113' WHERE zoneid IN ('115','116');
-- SanD Default
UPDATE zone_settings SET music = '107' WHERE zoneid IN ('230','231','232');
UPDATE zone_settings SET music = '156' WHERE zoneid IN ('233');
-- Bastok Default
UPDATE zone_settings SET music = '152' WHERE zoneid IN ('234','235','236');
UPDATE zone_settings SET music = '154' WHERE zoneid IN ('237');
-- Windurst Default
UPDATE zone_settings SET music = '151' WHERE zoneid IN ('238','239','240','241');
UPDATE zone_settings SET music = '162' WHERE zoneid IN ('242');
-- Jeuno Default
UPDATE zone_settings SET music = '110' WHERE zoneid IN ('244','245','246');
UPDATE zone_settings SET music = '117' WHERE zoneid IN ('243');