//Hack up latest mess time if (iMEMBER) { include INFUSIONS."pmsound/infusion_db.php"; $pmtimecheck = dbquery("SELECT * FROM ".DB_MESSAGES." WHERE message_to='".$userdata['user_id']."' ORDER BY message_datestamp DESC"); $pmtimecheck1 = dbarray($pmtimecheck); $timecheck = $pmtimecheck1['message_datestamp']; //End time hack $msg_count = dbcount("(message_id)", "".DB_MESSAGES."", "message_to='".$userdata['user_id']."' AND message_read='0'AND message_folder='0'"); $datapm = dbarray(dbquery("SELECT * FROM ".DB_PMSOUND." WHERE user_id=".$userdata['user_id']."")); $pmsound = $datapm['pmsound']; $pmtime = $datapm['time']; if ($msg_count > 0 && $timecheck > $pmtime ) { if ($datapm['pmsound'] =="nosound") { } else { echo ''; $result = dbquery("UPDATE ".DB_PMSOUND." SET time = '".time()."' WHERE user_id='".$userdata['user_id']."'"); } } }