Icy Phoenix

Old Support Topics - How To Empy User_post In Database

alain [ Tue 22 May, 2007 13:39 ]
Post subject: How To Empy User_post In Database

Hi
I want know how i can empy a userpost in database.

i load in mysql only user list and i want annul their messages

Thanks

(sorry my english is poor but i hope you can understand it and help me)

Zuker [ Tue 22 May, 2007 13:42 ]
Post subject: Re: How To Empy User_post In Database

U mean editing user_posts to 0?

U can do it with admin utilities in acp. When u edit an user

alain [ Tue 22 May, 2007 13:52 ]
Post subject: Re: How To Empy User_post In Database

Zuker wrote: [View Post]
U mean editing user_posts to 0?

U can do it with admin utilities in acp. When u edit an user

yes i want edit user_post to 0

with admin utilities is too slow because i have 200 user and edit all user is very slow

i have another problem.....in the http://............ip/memberlist.php i see only admin nick...how file i must edit for see all user???

Zuker [ Tue 22 May, 2007 14:34 ]
Post subject: Re: How To Empy User_post In Database

Code: [Hide]

UPDATE phpbb_users set user_post 0

Maybe could work, right?

Mighty Gorgon [ Fri 25 May, 2007 02:58 ]
Post subject: Re: How To Empy User_post In Database

Code: [Hide]

UPDATE phpbb_users SET user_posts = 0

This should be the correct SQL.

Zuker [ Fri 25 May, 2007 14:26 ]
Post subject: Re: How To Empy User_post In Database

:mricy: