Increase post count of all memebers

[abdulbasitsaeed]

Hi everyone!

I want to increase the post count of all the members on my forums (as a gift). I know that it can be done manually, user by user. But is there any way to do it on a global level, i.e. for all members altogether without editing every member's profile in the Admin Control Panel?

Any input would be appreciated.

[Adrian Schneider]

You can run the following query to add 10 posts to every member in the database:

UPDATE user
   SET posts = posts + 10

Change 10 to however many posts you want to increment their records by.

[abdulbasitsaeed]

Thank you very much for your prompt response, SirAdrian.

Just so that I'm clear on this, I am supposed to run this code in the "Execute SQL Query" option in the Admin Control Panel, right?

And I'm supposing it shall have to be executed in the Manual Query box, right?

[Adrian Schneider]

Yes.

AdminCP > Maintenance Tab > Execute SQL Query

Paste it in the box and submit. You may have to also add a table prefix before 'user' if you have one configured.

[abdulbasitsaeed]

Thank you once again, sir!

I'll hopefully get back to you on this.

--------------- Added [DATE]1253465949[/DATE] at [TIME]1253465949[/TIME] ---------------

Just wanted to let you know that it worked like a piece of cake!

Thank you, my friend.

[abdulbasitsaeed]

Another question...well, I was thinking if I could increase the reputation level of all members instead of increasing the post count.

Is it possible to execute an SQL query like above to do so?