• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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: