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

Insert data from blob value into other field.

Discussion in 'XenForo Development Discussions' started by EagleOneSix-, Jan 15, 2014.

  1. EagleOneSix-

    EagleOneSix- New Member

    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.

  2. tyteen4a03

    tyteen4a03 Well-Known Member

    Why not trigger a callback when user updates the field?
  3. EagleOneSix-

    EagleOneSix- New Member

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

    tyteen4a03 Well-Known Member

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

Share This Page