MYSQL change users post count
 

Does anyone know how i can change a members thanks/reputation and post count, something on my site wasnt working for a certain member on my site, so i created a new account and it worked for him, now i merged the accounts and none of the info transfered over, im guessing its somewhere in the mysql but i really dont have a clue where it will be located

For me i just open phpmyadmin then open your database then the user table (near bottom).
search for his username and then choose edit.
After that follow the columns along until you get to the one you need to edit.
Thats how i do it. Not pretty but it works.

Posts and reputation can be changed from the adminCP (Users -> Search for Users).