Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Reset user comment count

edited December 2006 in Vanilla 1.0 Help
Is there a way that i can reset or modify a user's comment count?


  • Options
    Yes, but you would have to dive into the database. Look in the LUM_User table
  • Options
    i'm not experienced with mysql at all, how would i go about doing that?
  • Options
    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';
  • Options
    Cheers, found it in phpmyadmin
This discussion has been closed.