Ok the easiest way to do this is to go to the plugin we need to edit in this case
?VSa - ChatBox ? MN?
How? Admincp>>> Plugin and products>>>>Plugin manager Scroll down and find the VSa-Chatbox-MN plugin and next to that click edit.
Select everything in the php code box and copy it to a text editor of your choice ( I use notepad++ )
Once there you can use the find function and look for
Code:
$vbulletin->db->show_errors();
And add on the line above it (copy and paste)
Code:
$tvsacurrent = $vbulletin->db->query_read("SELECT COUNT(ID) AS VSACURRENT FROM ".TABLE_PREFIX."vsa_chatbox AS vsa_chatbox");
while ($tvsacurrent = $vbulletin->db->fetch_array($tvsacurrent))
{
$vsacurrent = $tvsacurrent[VSACURRENT];
}
$tvsauser = $vbulletin->db->query_read("SELECT countvsachats AS VSAUSER FROM ".TABLE_PREFIX."user WHERE userid = " . $vbulletin->userinfo['userid'] ."");
while ($tvsauser = $vbulletin->db->fetch_array($tvsauser))
{
$vsauser = $tvsauser[VSAUSER];
}
if ($vsacurrent > $vsauser)
{
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET countvsachats = ".$vsacurrent." WHERE userid = " . $vbulletin->userinfo['userid'] . "");
}
if ($vsacurrent < $vsauser)
{
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET countvsachats = ".$vsacurrent." WHERE userid = " . $vbulletin->userinfo['userid'] . "");
}
$vsacb_box_totalmessages = $vbulletin->db->num_rows($vsacb_get_msg_box);
Then use the search function again to find
Code:
$vsacb_box_totalmessages>0
And on the line above that add (copy and paste) the next bit of code
Code:
if ($vsacurrent > $vsauser)
{
echo ('<div><table><tr><td><EMBED SRC="images\misc\chat.wav" HIDDEN="TRUE" AUTOSTART="TRUE"></EMBED></td></tr></div>');
}
Once you have done that you can copy the whole lot back from your text editor into the plugin phpcode box replacing the original code and click save.
You then need to find a good wav file. you can
TRY HERE and upload it to your images/misc folder ( make sure and name it "chat.wav )
Hope this helps
Mark