Query to set all users blog posts as not visible (vb4)

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

12-30-2013, 12:23 PM

tpearl5

Join Date: Nov 2001

Location: PA

Posts: 1,014

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

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

Query to set all users blog posts as not visible (vb4)

This query will set all of one user's blog posts to not visible (not a hard delete):

Code:

UPDATE `blog` SET `state` = "deleted" WHERE `username` = "USERNAME" AND `state` = "visible";

You can reverse this by swapping 'deleted' and 'visible' for state =

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.