Insert data from blob value into other field.

[EagleOneSix-]

Morning all.

I'm trying to integrate my forum system with my Minecraft server, I need to create a mysql cron type event to move the value of a custom user profile field into another field within the same table. In this case, I need to move the value of minecraft_username in the custom_fields blob field to the minecraft_username varchar field, I'm planning to run a cron every 5 minutes to update it. How can I go about implementing this? I'm thinking an INSERT FROM type statement, but I'm clueless past that point.

Thanks.
Lewis

 

[tyteen4a03]

Why not trigger a callback when user updates the field?

 

[EagleOneSix-]

How would one go about doing that? I'm new to this stuff.

 

[tyteen4a03]

How would one go about doing that? I'm new to this stuff.

Override the actionSave() method of the controller responsible for user field editing. One for front-end, one for ACP.