Amending a postcount in phpBB 2.0

[BillHicksRIP]

I run a phpBB forum where a particular user is spamming like crazy to up his postcount for some reason. Rather than banning him or removing postcounts from everyone, is there any way of affecting just his postcount through phpMyAdmin or something?

Any help is appreciated.

 

[WotDa]

Yup, navigate to phpbb_users then browse then edit the user in question.

I just added a post onto a user successfully. Edit the user_posts field.

 

[hitmann]

check out this MOD

http://www.phpbb.com/community/viewtopic.php?f=15&t=217133

or this one:

http://www.phpbb.com/community/viewtopic.php?f=15&t=138032

 

[WotDa]

check out these mods

Pfft, who wants to do that, easymod or not.

Edit:

or

tbh.

 

[BillHicksRIP]

Thanks for the replies. My lack of phpMyAdmin experience is showing here though. Drilled down to the guy's name, ticked the box to the left and want to change the user_posts field as advised. This brings up the SQL:-

SELECT * FROM `phpbb_users` WHERE `username` LIKE CONVERT(_utf8 'thatguy' USING latin1) COLLATE latin1_swedish_ci

Can't see where to enter the number? I guess it has to be a positive number too? It can't just be minus 1, or some text like "One less than everyone else"?. My SQL sucks.

 

[WotDa]

My version of phpmyadmin will be different, but I'll do you a screenshot tour on how to do it.










There's probably an easier/quicker way, but that's how I do it.

 

[BillHicksRIP]

I completely forgot to thank you for this. Sorry! Cheers for taking the time to help me out.