https://www.icyphoenix.com/viewtopic.php?f=35&t=2035
-----------------------------------
alain
Tue 22 May, 2007 13:39

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

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

Re: How To Empy User_post In Database
-----------------------------------
[quote user="Zuker" post="14644"]U mean editing user_posts to 0?

U can do it with admin utilities in acp. When u edit an user[/quote]

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???

 [img]http://www.icyphoenix.com/files/images/864/memberlist.jpg[/img]


-----------------------------------
Zuker
Tue 22 May, 2007 14:34

Re: How To Empy User_post In Database
-----------------------------------
[code]UPDATE phpbb_users set user_post 0[/code]

Maybe could work, right?


-----------------------------------
Mighty Gorgon
Fri 25 May, 2007 02:58

Re: How To Empy User_post In Database
-----------------------------------
[code]UPDATE phpbb_users SET user_posts = 0[/code]

This should be the correct SQL.


-----------------------------------
Zuker
Fri 25 May, 2007 14:26

Re: How To Empy User_post In Database
-----------------------------------
:mricy:


