[cory_booth]

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?