Add music to zones that don't have it

[zuziko]

I have experience with creating bgw from wav files using the old tool Ximc, I'm just not sure how to add them to the zones that don't already have it, do not want to overwrite SE files like wind effects to make it work.

Is their a script, or something in the database that I can edit so that the zones will use the new bgw files I have created?

[cocosolos]

The music IDs are in the zone_settings table in the DB. They get sent to the client and it handles the rest. I don't know if the client will recognize a new ID or not, but you should at least be able to share and/or replace one of the existing ones.

[zuziko]

In the zone_settings I will change the music_day and music _night

[TeoTwawki]

and you do that how exactly. in detail. I'm asking for a reason. I can't help you if you keep answering the what and not the how.

[zuziko]

Oh sorry, I'm using HeidiSQL to edit the database zone_settings. I will type 109 which is West Ronfaure in for the music_day & music_night for La_Theine_Plateau. I want to use a custom track but was testing this way because I know this track is the correct format. Track wont play after restart. Even if I set music_day and music_night to 0 in West_Ronfaure it changes nothing.

[TeoTwawki]

alright, have you ever run a query before? I want you to run these 3 by pasting them into a query tab like this picture and then clicking the button circled in red:

REPLACE INTO `zone_settings` VALUES (100,2,'127.0.0.1',54230,'West_Ronfaure',0,0,0,0,0,0.00,2206);
REPLACE INTO `zone_settings` VALUES (101,2,'127.0.0.1',54230,'East_Ronfaure',0,0,0,0,0,0.00,2206);
REPLACE INTO `zone_settings` VALUES (102,2,'127.0.0.1',54230,'La_Theine_Plateau',109,109,101,103,0,0.00,2206);

Do this with your server exe's shut down. start up after, then log in and travel to all 3 zones. Attack and kill a mob. Music in Ronfaure should be gone. La'Thiene should sound like Ronfaure. Also make sure you don't have multiple databases or something - this works on my testbed, my ronfa is silent and my la'theine sounds like the dragon quest overworld music because I felt like it 😛

[TeoTwawki]

ps you might need to fix your ips/ports after, because my query reset them to default and I didn't think about that before posting.

[zuziko]

That worked! Just had the edit the ip, I have this open to home network. Thank you!

The file that I made with Ximc does not work at all though. I just manually put it in the sound folder, backed up file 118 (Rolanberry fields) and renamed my new custom one to 118. Started the server up and got no sound at all in Rolanberry fields with it. Is there a guide somewhere about how to create these the correct way? As you mentioned above it must be the wrong format.

[zuziko]

Nevermind, I actually just got it to work. Had to edit the wav file db to make the file waaayyy louder before converting to bgw. Thank you for all the help!