SQL question - Edit # views, plus date for "Last Post" column

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • forteanajones
    Senior Member
    • Aug 2002
    • 138
    • 3.6.x

    SQL question - Edit # views, plus date for "Last Post" column

    (Had to double-post this here, as the Impex support may be minimal this afternoon.)

    I ended up having to go live without these missing posts, and am now trying to re-create them with the Adv. Editing Options for Mods and Admins hack from vb.org.

    All is well except for two things:
    1. Post dates in the "Last Post" column show up as the current date, instead of one of the dates in the thread itself. This is a problem I need to adress right away.

    2. Number of views is not up-to-date and accurate since technically, these are now new posts. This is less urgent but I would also like to address it.
    Can someone share the appropriate SQL I might use to make these two (ostensibly simple) corrections?
    Last edited by forteanajones; Fri 22 Sep '06, 3:40pm.
  • forteanajones
    Senior Member
    • Aug 2002
    • 138
    • 3.6.x

    #2
    Anyone?

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    😀
    😂
    🥰
    😘
    🤢
    😎
    😞
    😡
    👍
    👎