Amending a postcount in phpBB 2.0

BillHicksRIP · 27 Apr 2007 at 21:23

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 · 27 Apr 2007 at 21:24

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 · 27 Apr 2007 at 21:25

check out this MOD

Code:

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

or this one:

Code:

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

WotDa · 27 Apr 2007 at 21:33

hitmann said:
check out these mods

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

Edit:

or

tbh.

BillHicksRIP · 27 Apr 2007 at 22:35

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 · 28 Apr 2007 at 05:02

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 · 3 May 2007 at 14:43

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