PDA

View Full Version : Recent Visitors


ccole513
01-15-2009, 08:53 PM
I would like to reset the number of visits given in an individual's RV block. What queries should I run to reset their profile views?

chrisbeau
04-28-2009, 06:42 PM
Bump, the answer would be nice to know :)

chrisbeau
05-02-2009, 04:32 PM
No one ?

Lynne
05-02-2009, 04:46 PM
probably just:

Update user set profilevisits=0

try it on a test board first cuz I'm not sure about that.

chrisbeau
05-13-2009, 07:14 PM
probably just:

Update user set profilevisits=0

try it on a test board first cuz I'm not sure about that.

Dont have a test board.

Lynne
05-13-2009, 07:27 PM
Well then, close your forums, do a backup of your database, run the query, test the site, reopen the forums.

I highly recommend everyone have a test board.

Dismounted
05-14-2009, 09:45 AM
The query Lynne posted should work - but make a backup of your database anyway!

Also, make sure you place a prefix in front of "user" (if you have one).
UPDATE user SET profilevisits = 0