Reset user comment count

eggy900 · December 2006

Is there a way that i can reset or modify a user's comment count?

WallPhone · December 2006

Yes, but you would have to dive into the database. Look in the LUM_User table

eggy900 · December 2006

i'm not experienced with mysql at all, how would i go about doing that?

WallPhone · December 2006

First thing to do is see if you have access to an admin console like phopMyAdmin. This will make it much easier to change. Then browse the LUM_User table (listed on the left) and edit the records (click the pencil icon) for the user you want to change.

If you don't have access to that, you will probably have to either log in with a shell, or create a PHP file with the command in it, both of which are a bit more complicated, and then run a command like this one:


UPDATE LUM_User
SET CountComments = 0
WHERE Name = 'WallPhone';

eggy900 · December 2006

Cheers, found it in phpmyadmin