Query to set all users threads as not visible (vb4)

		vb.org Archive > Community Discussions > Forum and Server Management
Query to set all users threads as not visible (vb4)

12-30-2013, 12:21 PM

tpearl5

Join Date: Nov 2001

Location: PA

Posts: 1,014

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Query to set all users threads as not visible (vb4)

This query will set all users threads as not visible. In otherwords, not a hard delete:

Code:

UPDATE `thread` SET `visible` = "2" WHERE `postusername` = "USERNAME" AND `visible` = "1"

To reverse it and make the threads visible again just swap the 1 & 2 for 'visible'. This will probably work for vb3 as well, but has not been tested.

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT. The time now is 11:54 PM.

The Arcive of vBulletin Modifications Site.