UPDATE xf_thread
SET discussion_state = 'visible'
WHERE discussion_state = 'deleted'
AND node_id IN (2,3,4)
Awesome, everything works fine now.Code:UPDATE xf_thread SET discussion_state = 'visible' WHERE discussion_state = 'deleted' AND node_id IN (2,3,4)
That query should do it......
Notice this will only run on threads in forums "2,3,4" - you can change that accordingly to the forums you want to run it on, or just delete that entire last line to make it run on all forums.
How to rebuild user's stats?
-Post Count
-Likes Recieved
Is it possible to specify the query to a certain user who deleted and time frame that they did so?Code:UPDATE xf_thread SET discussion_state = 'visible' WHERE discussion_state = 'deleted' AND node_id IN (2,3,4)
That query should do it......
Notice this will only run on threads in forums "2,3,4" - you can change that accordingly to the forums you want to run it on, or just delete that entire last line to make it run on all forums.
We use essential cookies to make this site work, and optional cookies to enhance your experience.