Table Names?

[skylark]

I would like to restore ONLY users post counts and reputation counts from a database backup. Which tables contain this data?

[Jose Amaral Rego]

Reputation points you can edit from admin control panel and or click link within users profile. How many post are you wanting to add? You do need to actually add these posts or once you use the update counter at any point, it will reset to actual users post count.

Backup prior to using this query
X=total new count
Y=user(id) number

UPDATE user SET post = 'X' WHERE userid = 'Y';

Manual Query – if you wish to run your own query, you may enter it here. Ensure that no Automatic Query is selected. Additionally, you may only run one query at a time.
http://files.vbulletin.com/doc_images/maintenance/query_main.png (http://www.vbulletin.com/docs/html/maintenance_query)

[skylark]

I would like to restore post counts and reputation scores for ALL users, so editing these scores in each users profile via admincp isn't an option.

The posts associated with these scores do physically exist already.

[Jose Amaral Rego]

Ask Jerry in forum 'vBulletin Impex Import System' if that is possible. I do not have a large database to do those type of testing... I do, but just never had the time to actually run these test to use impex to import information. Once I figure out a proper way of doing this, then I will write some instruction for myself and past it to others when need be.