Add an alert sound to new chats....
OK folks, this is not for the faint of heart and I know there must be a much easier way to do this, but until something better comes along....
BEFORE YOU BEGIN.
You'll need a wav file and access to your database.
STEP 1: UPDATE USER TABLE
Add new column of type "INT"
Name Column = "countvsachats"
STEP 2: MODIFY PLUGINS - (VSa - ChatBox - MN)
Find the following function "ccbmessages"
Add above: $vbulletin->db->show_errors();
PHP 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);
STEP 3: Scroll down and find .... if ($vsacb_box_totalmessages>0)
Add above (notice here I am loading a chat.wav from images\misc - you'll need to upload a wav and change accordingly):
PHP Code:
if ($vsacurrent > $vsauser)
{
echo ('<div><table><tr><td><EMBED SRC="images\misc\chat.wav" HIDDEN="TRUE" AUTOSTART="TRUE"></EMBED></td></tr></div>');
}
I have yet to try with FireFox but the idea is simple. Have a coulm in the user tabe keep track of the current amount of chats. When the chatbox refreshes, run a quick query to count the number of chats. If the chats in the query are larger than the entry in the user table - update the user table to match and fire off a sound.
I hope that there will be a good response to this and Valter might provide a similar solution?
More Information