MyBB Community Forums

a user on my forum admitted to using a proxy to build up his reference count, when confronted by a member of the staff.
We've deleted all of the accounts he's referred, but his reference/referrer count is still at 9. How can we reduce it back to 0?

You can modify it via phpmyadmin if you're that bothered.

UPDATE  `mybb_users` SET  `referrals` =  '0' WHERE  `uid` = X;

Replace X with the user's User ID.

Thanks that worked.