Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

How To Empy User_post In Database

This topic is locked: you cannot edit posts or make replies.

 

alain
Quote
Posts: 5 Location: Italy
Tue 22 May, 2007 13:39
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)

Profile PM   Website AIM YIM MSN Skype
Zuker
Quote
Posts: 2134 Location: BA
Tue 22 May, 2007 13:42
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

Profile PM   Website MSN Skype
alain
Quote
Posts: 5 Location: Italy
Tue 22 May, 2007 13:52
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???

memberlist

Profile PM   Website AIM YIM MSN Skype
Zuker
Quote
Posts: 2134 Location: BA
Tue 22 May, 2007 14:34
Subject: Re: How To Empy User_post In Database
Code: [Download] [Hide]
  1. UPDATE phpbb_users set user_post 0 


Maybe could work, right?

Profile PM   Website MSN Skype
Mighty Gorgon
Quote
Posts: 7192 Location: Borgo San Michele
Fri 25 May, 2007 02:58
Subject: Re: How To Empy User_post In Database
Code: [Download] [Hide]
  1. UPDATE phpbb_users SET user_posts = 0 


This should be the correct SQL.

Profile PM   Website
Zuker
Quote
Posts: 2134 Location: BA
Fri 25 May, 2007 14:26
Subject: Re: How To Empy User_post In Database
:mricy:

Profile PM   Website MSN Skype
This topic is locked: you cannot edit posts or make replies.
 

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.0915s (PHP: 20% SQL: 80%)
SQL queries: 10 - Debug Off - GZIP Enabled