MyBB Community Forums

Anyone know how I can add 100 posts to all users using mySQL command?

Thanks in advance!

This should work.

UPDATE `mybb_users` SET `postnum` = '100' 

Run that in phpMyAdmin.

I mean +100, not just 100. How do I add 100 to what they already have?

There isn't a possible way to do that by an SQL command all in one go. You would have to work out what each post count would need to be set to then run the command on every individual account.

Remember you can also set post counts in your admincp when you edit a user.

Oh that.
Didn't know you could do that sorry for the confusion.

Wow that's cool. Wasn't some SQL codes thread somewhere? This should be added (if it's not)