Current time: 04-18-2014, 10:35 AM Hello There, Guest! (LoginRegister)


Reset Views Count
03-07-2010, 12:59 AM
Post: #1
Solved: 3 Years, 6 Months, 2 Weeks, 3 Days, 20 Hours, 31 Minutes, 15 Seconds ago Reset Views Count
Hello,

I have just setup a forum for our church. I haven't announced its availability yet because the rest of the site isn't complete yet.

There are some threads in my forum that show they have been viewed 30 and 40 times ... but they are all mine while I've been dink'n around. It's not a show stopper ... but is there any way to reset the count to zero?

Thanks,
Terry

Regards,
Terry
Find all posts by this user
03-07-2010, 01:08 AM
Post: #2
Solved: 3 Years, 6 Months, 2 Weeks, 3 Days, 20 Hours, 31 Minutes, 15 Seconds ago RE: Reset Views Count
Run this query in phpMyAdmin:

PHP Code:
UPDATE `mybb_threadsSET `views` = '0'

Can you still feel the butterflies?

Free never tasted like pudding.
Visit this user's website Find all posts by this user
03-07-2010, 01:16 AM
Post: #3
Solved: 3 Years, 6 Months, 2 Weeks, 3 Days, 20 Hours, 31 Minutes, 15 Seconds ago RE: Reset Views Count
Worked Perfect! Big Grin

Thank you

Regards,
Terry
Find all posts by this user
04-07-2010, 10:05 AM
Post: #4
Solved: 3 Years, 6 Months, 2 Weeks, 3 Days, 20 Hours, 31 Minutes, 15 Seconds ago RE: Reset Views Count
Hello,

I have been working on one forum section in particular, adding up some strange view counts. Would it be possible to recount the hits on the threads in just one forum section whilst leaving the rest of the forums view counts alone?

Would appreciate any help

Big Grin
Find all posts by this user
04-07-2010, 10:10 AM
Post: #5
Solved: 3 Years, 6 Months, 2 Weeks, 3 Days, 20 Hours, 31 Minutes, 15 Seconds ago RE: Reset Views Count
Go into PHPMyAdmin and edit the view count for each specific forum/thread!
Find all posts by this user
04-07-2010, 10:35 AM
Post: #6
Solved: 3 Years, 6 Months, 2 Weeks, 3 Days, 20 Hours, 31 Minutes, 15 Seconds ago RE: Reset Views Count
(04-07-2010 10:10 AM)Prentice Wrote:  Go into PHPMyAdmin and edit the view count for each specific forum/thread!


Thanks for the quick answer, sorry I'm pretty amateur Blush, how do I select individual forums/threads within PHPMyAdmin?

Thanks
Find all posts by this user
04-07-2010, 11:16 AM
Post: #7
Solved: 3 Years, 6 Months, 2 Weeks, 3 Days, 20 Hours, 31 Minutes, 15 Seconds ago RE: Reset Views Count
PHP Code:
UPDATE `mybb_threadsSET `views` = '0' WHERE `fid` = '1'

Change the 1 to the FID of the forum and all threads in that forum will have no views.

Can you still feel the butterflies?

Free never tasted like pudding.
Visit this user's website Find all posts by this user
04-07-2010, 11:20 AM
Post: #8
Solved: 3 Years, 6 Months, 2 Weeks, 3 Days, 20 Hours, 31 Minutes, 15 Seconds ago RE: Reset Views Count
(04-07-2010 11:16 AM)MattRogowski Wrote:  
PHP Code:
UPDATE `mybb_threadsSET `views` = '0' WHERE `fid` = '1'

Change the 1 to the FID of the forum and all threads in that forum will have no views.

Great just worked,

Cheers!Big Grin
Find all posts by this user
04-07-2010, 12:04 PM
Post: #9
Solved: 3 Years, 6 Months, 2 Weeks, 3 Days, 20 Hours, 31 Minutes, 15 Seconds ago RE: Reset Views Count
Lol, Thanks for that Matt... I'm still learning Big Grin
Find all posts by this user
04-09-2011, 06:14 PM (This post was last modified: 04-09-2011 06:18 PM by akm.)
Post: #10
Solved: 3 Years, 6 Months, 2 Weeks, 3 Days, 20 Hours, 31 Minutes, 15 Seconds ago Where to reset 'Views' count ???
(03-07-2010 01:08 AM)MattRogowski Wrote:  Run this query in phpMyAdmin:
PHP Code:
UPDATE `mybb_threadsSET `views` = '0'
Talk about 'novice', am not even able to find phpMyAdmin... is that somewhere in the forum admin interface ?

Thanks again for your help !
akm
Visit this user's website Find all posts by this user


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication