XF 2.0 Updating custom user field from external script

[k3ithos]

Is it possible to update custom user fields for a user from an external script, not using any XenForo classes and functions at all? I believe data for fields are stored in the xf_user_profile and xf_user_field_value tables?

 

[k3ithos]

Bump?

 

[S Thomas]

If you know where the data is stored, you'd just need to form an UPDATE query and fire that up. Depending on what language your script is written in you'd want to use a prepared connector and leave the rest of the work to that bridge.

 

[k3ithos]

If you know where the data is stored, you'd just need to form an UPDATE query and fire that up. Depending on what language your script is written in you'd want to use a prepared connector and leave the rest of the work to that bridge.

The problem is that the custom fields data in the xf_user_profile table is BLOB data, so how would I insert a record and update that?

 

[S Thomas]

http://php.net/manual/en/function.serialize.php
This will return you a string which you can use in your UPDATE query.

 

[k3ithos]

http://php.net/manual/en/function.serialize.php
This will return you a string which you can use in your UPDATE query.

Worked out how to update it successfully, thanks for the help!