XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Adding posts to a user?
Register
1
Raymie
Adding posts to a user?

  • 2004/5/22 20:07

  • Raymie

  • Just popping in

  • Posts: 29

  • Since: 2003/7/23


Hello Brilliant Community,

My hosting service has just funkt me and lost two months of my work and posts etc, (I guess it is my own fault for not keeping my own back-ups but that is niether here nor there.)
Anyways, out of some type of reconciliation to my loyal users, I would like to increase theier amount of posts to where we left off. It is the least I can do. Please do not tell me I have to log in as them and post 100's of messages.

Is there any way to start a user at a higher number of posts, and/or increase the number of posts a user has?

Please help me. Thank You so much.
2
photek
Re: Adding posts to a user?

  • 2004/5/22 20:32

  • photek

  • Just popping in

  • Posts: 34

  • Since: 2004/4/10


If im not mistaken, you can go into your MySQL Database Search for xoops_users, and add any number of posts to each individual user, although if you have 100+ users, this will take time as well

Resized Image
this is a screencap of my database.
3
Mithrandir
Re: Adding posts to a user?

UPDATE [prefix]_users SET posts = posts + 100

running this (and replacing [prefix] with your database prefix, naturally) will add 100 posts to each user's count.

Can be refined with a range of statements:

UPDATE [prefix]_users SET posts = posts + 50 WHERE posts < 20
UPDATE [prefix]_users SET posts = posts + 100 WHERE posts < 50
UPDATE [prefix]_users SET posts = posts + 200 WHERE posts > 50

to reward the users, who have already been active
4
photek
Re: Adding posts to a user?

  • 2004/5/22 21:12

  • photek

  • Just popping in

  • Posts: 34

  • Since: 2004/4/10


thats a better solution, never though of that..
5
Raymie
Re: Adding posts to a user?

  • 2004/5/24 23:09

  • Raymie

  • Just popping in

  • Posts: 29

  • Since: 2003/7/23


Thanks for the help. I will give it a try and report back.
6
Raymie
Re: Adding posts to a user?

  • 2004/5/27 23:07

  • Raymie

  • Just popping in

  • Posts: 29

  • Since: 2003/7/23


Thank You, the SQL was perfect.
7
Parafal
Re: Adding posts to a user?

  • 2004/5/27 23:39

  • Parafal

  • Just popping in

  • Posts: 98

  • Since: 2003/6/7 2


If you want to find a user in your SQL, look for his "id" number in xoops. After that you can go to the data base and you will find it faster. I do this when I put posts to my users.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

223 user(s) are online (151 user(s) are browsing Support Forums)

Members: 0

Guests: 223

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits