منتدى استراحات زايد

I have installed a hack that deletes visitor messages every 30 days. I have a problem with the fact that after it deletes the messages, people that haven't checked their visitor messages have "phantom" message notifications. I found a fix on vb.org for it that someone got here, however, it doesn't work properly on my site. I do not have table prefixes - I don't have my site going to www.mysite.com/forum/ - and the code incorporates a table prefix. I changed it to what I thought it should be, but it isn't getting rid of them. Can someone please just tell me how to edit this in order to take into account that I don't use table prefixes? I know that I should ask on vb.org and I have, but my members are driving me nuts about it.

Quote:
Originally Posted by TheInsaneManiac http://vb.ma7room.com/images/buttons/viewpost.gif
Thanks to some staff on VBulletin I got a query that will reset the count after deletion. I then implemented it into the current code.

This is the code I need to edit:

Add Below:
Code:
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vmunreadcount = '0'");

(and it's this hack, just FYI http://www.vbulletin.org/forum/showt...=174737&page=4)