MyBB Community Forums

Full Version: how to reset view count for X thread only
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I want to reset the view counter for only this thread, how can i do this?
value for field views can be changed in threads table of the forum database. above referred thread id is 4

Quote:UPDATE mybb_threads SET views = XYZ WHERE tid = 4;

[common sql queries guidance]
First of all. Thank you. Second of all i am not sure why it shows different views from the thread listing VS the stats page.

mysql> UPDATE `mybb_threads` SET `views` = 1000 WHERE `tid` = 4;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0


It shows correctly on the thread listing now but the stats still show the old views at 300K views