2017-05-03, 04:30 PM
2017-05-03, 04:55 PM
value for field views can be changed in threads table of the forum database. above referred thread id is 4
[common sql queries guidance]
Quote:UPDATEmybb_threads
SETviews
= XYZ WHEREtid
= 4;
[common sql queries guidance]
2017-05-03, 06:41 PM
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.
It shows correctly on the thread listing now but the stats still show the old views at 300K views
https://python-forum.io/stats.php
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
mysql>
It shows correctly on the thread listing now but the stats still show the old views at 300K views
https://python-forum.io/stats.php