Page 1 of 2
Music for Events
Posted: Sat Jul 27, 2013 5:22 pm
by 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';
Re: Music for Events
Posted: Sat Jul 27, 2013 9:02 pm
by whasf
Thanks!
Re: Music for Events
Posted: Sun Jul 28, 2013 8:33 pm
by 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.
Re: Music for Events
Posted: Sun Jul 28, 2013 11:27 pm
by lautan
I think its a weather.
Re: Music for Events
Posted: Mon Jul 29, 2013 1:38 pm
by tagban
lautan wrote:I think its a weather.
Thanks! I'll look into it when I get off work.
Re: Music for Events
Posted: Mon Jul 29, 2013 9:41 pm
by 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?
Re: Music for Events
Posted: Mon Jul 29, 2013 11:49 pm
by kjLotus
tagban wrote: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
Re: Music for Events
Posted: Sun Apr 19, 2015 10:34 pm
by 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';
Re: Music for Events
Posted: Mon Apr 20, 2015 11:46 pm
by 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.
Re: Music for Events
Posted: Tue Apr 21, 2015 12:00 am
by kjLotus
i actually added that because I saw this thread (summerfest music only plays at night)
also:
tagban wrote:As of 4/20~
420blazeit