island
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?
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:
