You will need to obtain the sound UI name from your client media file effectsound.txt.
You will also need to obtain the World ID and Region ID of the target area. Move your character to the desired location and use the following query:
SELECT SpawnWorldID, SpawnRegionID FROM _OnlinePlayers WHERE CharName16 = 'character_name'
Stored Procedure: _Command_Area_PlaySound
Parameters:
@WorldID SMALLINT- World ID@RegionID SMALLINT- Region ID@SoundEffect VARCHAR(128)- Sound UI code
Let us test the command by playing a quest sound for all players in Jangan town area.
USE [vPlus] GO EXEC _Command_Area_PlaySound 1, 25000, 'snd_quest';