How to edit forum thread view count?

Geng

I want to edit it/reset it back to 1. How do I do this?

peregrine

use phpmyadmin for example

the Discussion Table - the field is Countviews

for discussion number 141

UPDATE `GDN_Discussion` SET `CountViews` = '1' WHERE `DiscussionID` =141;

if you take out the where it will update ALL discussions to a count of 1

Geng

Thank you, I did as you said and it worked.

rbrahmson

I have a need that I'm not sure is unique - to prime several categories with discussions. I discovered that admins/moderators editing and reviewing these posts ramp up the views counts.

So I wonder whether it is possible to reset the counts when a moderator decides that some posts are "final" and ready for the audience.

Is this a phpadmin function similar to what was suggested above or more of a plugin type of solution?

hgtonight

@rbrahmson said:

Is this a phpadmin function similar to what was suggested above or more of a plugin type of solution?

If it is something you are going to do often, make a plugin.

If it is a once or twice kind of thing, use a straight db query.

EDIT - Remember that you don't have to release any plugins to the public. I have plenty of niche plugins in use around the web that I don't release here. They aren't polished enough or useful enough for a broad audience to use. Doesn't stop them from being useful to me.

rbrahmson

OK, thanks @hgtonight. So it's probably a plugin which I won't share (I'm learning the forum etiquette;-). I got the plugin template and many other plugins I could potentially use as a basis. Ready to roll up my sleeves, but still don't know how to proceed. Which plugin to model after, which functions to call, where, etc.

hgtonight

@rbrahmson said:
OK, thanks hgtonight. So it's probably a plugin which I won't share (I'm learning the forum etiquette;-). I got the plugin template and many other plugins I could potentially use as a basis. Ready to roll up my sleeves, but still don't know how to proceed. Which plugin to model after, which functions to call, where, etc.

Feel free to share it if you want feedback.

If you don't like reading source code, check out the Event plugin to find hooks to use. And check out my Testing Ground plugin for some basic information on the structure of a plugin.

Bleistivt

Using the SQL builder is dead simple. What peregrine posted above would translate to

Gdn::sql()
    ->update('Discussion')
    ->set('CountViews', 1)
    ->where('DiscussionID', 141)
    ->put();

rbrahmson

Thanks @Bleistivt - I think Plugin would work better if I need to give this function to moderators...
@hgtonight - Yes, I got your Testing Ground. Will get the Event (did you mean Eventi?) plugin as well and play with it next week. My coding experience is really from University too many years ago (if you call PL1 a programming language;-) but surprisingly I found some plugin code readable...

R_J

I would add it to the discussion options: "Reset ViewCount" or something like that with the code Bleistivt provided. You can use the Bump plugin as a blueprint

rbrahmson

Thanks guys (and/or Gals-I mean to include everyone), I'll give it a shot!