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.

 

[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.

 

[BillHicksRIP]

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