Music for Events

[tagban]

Greetings all, I did some research and just setup queries for myself in NaviCat (Since the ZoneSettings SQL gets updated, this would need to be run whenever you'd need to run the zoneIP address update.

230 - 233 (SanD) (Default: 107(main), 156 (Chatau-233))
234-237 (Bastok) (Default: 152(main), 154 (Metalworks-237))
238-242 (Windy) (Default: 151(main), 162(HeavensTower-242))
243-246 (Jeuno) (Default: 110(main), 117((RuLude -243))
227 - Summerfest Theme Music
239 - Xmas - Jeuno Theme Music
(UPDATED!)
-----
Summerbreeze (Typically only played at night in the 3 main cities, I added Jeuno because, I love the music)
Still not sure how to get fireworks to display in the sky... But hopefully someday!

Code: Select all

## Jeuno -- Summerbreeze (Remove if you don't want this)
UPDATE zone_settings SET music_night = '227' WHERE zoneid >'237' and zoneid < '242';
## Windurst -- Summerbreeze
UPDATE zone_settings SET music_night = '227' WHERE zoneid >'242' and zoneid < '247';
## Bastok Summerbreeze
UPDATE zone_settings SET music_night = '227' WHERE zoneid >'233' and zoneid < '238';
## SanD Summerbreeze
UPDATE zone_settings SET music_night = '227' WHERE zoneid >'229' and zoneid < '233';

[whasf]

Thanks!

[tagban]

Anyone have any idea how to make the firework effects happen in the sky for the Summerbreeze festival?

I think thats the next thing I'd love to try to do.

[lautan]

I think its a weather.

[tagban]

I think its a weather.

Thanks! I'll look into it when I get off work.

[tagban]

Thanks for the thoughts. I'm assuming that to do this I'd have to modify the weather system entirely to add a new type? Or do you think its an existing type?

[kjLotus]

Thanks for the thoughts. I'm assuming that to do this I'd have to modify the weather system entirely to add a new type? Or do you think its an existing type?

just remove the restriction in the @weather command and start pumpin in numbers in gustaberg

[tagban]

Just sharing my new Queries to make this work more fluidly, I'll be adding visible changes as well VERY shortly for turning on special things like random people out selling fireworks, etc. but for now:

Default Music For Affected zones

Code: Select all

# SAND Reset
UPDATE zone_settings SET music = '107' WHERE zoneid >'229' and zoneid < '233';
# Jeuno Reset
UPDATE zone_settings SET music = '110' WHERE zoneid >'242' and zoneid < '247';
# Bastok Reset
UPDATE zone_settings SET music = '152' WHERE zoneid >'233' and zoneid < '238';
# Windy Reset
UPDATE zone_settings SET music = '151' WHERE zoneid >'237' and zoneid < '242';
# SanD Reset
UPDATE zone_settings SET music = '107' WHERE zoneid >'229' and zoneid < '233';

Jenuo Xmas

Code: Select all

# Jeuno Xmas Music
UPDATE zone_settings SET music = '239' WHERE zoneid >'242' and zoneid < '247';

Summerbreeze... (I added Jeuno because I like it, but it normally only plays in the 3 main cities and not the 'capital' zones.)

Code: Select all

## Jeuno -- Summerbreeze (NOT NORMAL BUT WHY NOT?)
UPDATE zone_settings SET music = '227' WHERE zoneid >'237' and zoneid < '242';
## Windurst -- Summerbreeze
UPDATE zone_settings SET music = '227' WHERE zoneid >'242' and zoneid < '247';
## Bastok Summerbreeze
UPDATE zone_settings SET music = '227' WHERE zoneid >'233' and zoneid < '238';
## SanD Summerbreeze
UPDATE zone_settings SET music = '227' WHERE zoneid >'229' and zoneid < '233';

[tagban]

As of 4/20~ with the Zone_settings changes, I had to add music_night and music_day to my settings:

Summerbreeze

Code: Select all

## Jeuno -- Summerbreeze (Remove if you don't want this)
UPDATE zone_settings SET music_night = '227' WHERE zoneid >'237' and zoneid < '242';
## Windurst -- Summerbreeze
UPDATE zone_settings SET music_night = '227' WHERE zoneid >'242' and zoneid < '247';
## Bastok Summerbreeze
UPDATE zone_settings SET music_night = '227' WHERE zoneid >'233' and zoneid < '238';
## SanD Summerbreeze
UPDATE zone_settings SET music_night = '227' WHERE zoneid >'229' and zoneid < '233';

More to come.

[kjLotus]

i actually added that because I saw this thread (summerfest music only plays at night)

also:

As of 4/20~

420blazeit