XF 1.5 mysql query help


Active member
I'm trying to import the reputation numbers from vbulletin into a custom user field in xenforo.

Can anyone help me with a query to do this?

The vbulletin reputation field is stored in the user table and reputation column

In xenforo I've created a new custom field named vbreputation which would stored be in the xf_user_field_value table

However, I see the structure of xf_user_field_value is a bit different in that there are many rows for each userid which contain only user_id, user_field, and user_value and user_field vbreputation only exists as a row in phpmyadmin if I manually set it for one user but by default doesn't exist.

Can anyone help me with a query to accomplish this?
Last edited: