You can use the mirc option (alt + o > sound) but it let you choose only one sound, you'll have to use a code :
on *:text:*:?:splay path\file
on *:text:*:#:splay path\file
The first line is for query message, second for channel message, replace path\file by your sounds.