• 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

island

Active member
#1
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: