$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);