Announcement

Collapse
No announcement yet.

Editing Thread Views

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Editing Thread Views

    We have a thread that had 5 posts in it that also had a total of 25,000 views. We broke out the posts to individual threads and wanted to share those thread views among those 5 new threads at 5,000 each. Is there a way to edit the number of views for these new threads? Will the following query work perhaps?

    UPDATE `thread` SET `views` = 'zzz' WHERE `thread`.`threadid` =x LIMIT 1 ;

    Where x is the ID of the thread and zzz is the number of Views.

    Thanks!
    http://www.hometheatershack.com/forums

  • #2
    Surely this has come up before, no?
    http://www.hometheatershack.com/forums

    Comment


    • #3
      This is a very basic query...

      Code:
      UPDATE thread
      SET views=5000
      WHERE threadid=X or threadid=X or threadid=X or threadid=X or threadid=X
      You can expand on that. (X = of course equals the database numeric value of the target thread record) This will update 5 threads with the specified value at the SET entry.

      Adjust your table prefix, if you use one. I tested and confirm this works on a 3.8 database. (MySQL 5.1.45 at the time...)

      Good luck.
      To be updated...

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X