VB to IPB Conversion - unapproved post

[Rhett]

After a conversion to IPB from VB there may be a bunch of soft deleted post that appear as "unapproved post" in IPB. This query will change those post to "hidden" (soft deleted).

UPDATE posts SET queued=2 WHERE queued=1

UPDATE topics SET approved = '-1' WHERE approved = '0';