ICT : Reading Topic : Mass Delete Posts

Welcome guest
Login : Register : Team list : Latest posts : Help

» Home » Discussion Forums » Reading Topic

» ICT V 1.0 » Feature Discussions » Mass Delete Posts

Only one page to show.

Kathleen	March 07^th, 2007 03:45 GMT

Topics: 5 Replies: 11 Member Post: #11283 PT: #1/3	Wasn't sure where to ask this. If someone deletes their account, your left with all their prior posts and 'Guest' in the avatar. Question - Is there someway of mass pruning, or mass deleting all post by a member? Thanks

Camil	March 10^th, 2007 14:49 GMT

Topics: 155
Replies: 3414
Development

Post: #11284
PT: #2/3

You need to do that from the SQL Client. It's not hard to do but you must know what your doing or you might end up with an unusable forum. The way to do it would be like this in the SQLCLient.

Ex:

Table prefix = ict_
Name of member deleted: Camil

Code

UPDATE ict_messages SET STATUS=2 WHERE GNAME="Camil"

Once that is done, you need to go to the Forums Manager and Re-Count the forums so that the number of posts in topics match reality.

Kathleen	March 11^th, 2007 19:21 GMT

Topics: 5 Replies: 11 Member Post: #11286 PT: #3/3	Excellent, thank you.

Only one page to show. Posts in this thread ( 3 )

[

Subscriptions disabled ]

[

Print Topic :: Print page]

» Home » Discussion Forums » Reading Topic