Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Saturday 11:33 am
Add a reply View Replies (1)

Resolved Custom field "after update" hook

  1. QuickScriptz
    QuickScriptz
  2. Features Request
  3. Thursday, September 21 2017, 04:40 AM
Hi there,

We have some custom fields that when saved/updated/changed, need to also update other tables in our DB with the same information. For instance, we have a field called "Phone Number", and when you save changes to this field, we also need to update another table in our database with your new "Phone Number". Having something like Conditions where you can specify that a field maps to another table/field would be really helpful (similar to the RSForm! feature called "Mapping";).

Alternatively, if there are existing hooks we could use to achieve this functionality, that would be great to know too.

Thanks!
Responses (1)
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply, it was night for us :D

to do this you need to develop a plugin that make this. This seems complex but in reality is something very simple :D

Please follow these steps:
- Download, Install and Enable Skeleton Plugin (you will find it at http://docs.easy-profile.com/index.php/article/triggers)
- Open file /plugins/jsn/skeleton/skeleton.php
- Remove samples functions: triggerFieldAvatarUpdate, triggerProfileUpdate
- add function like this:
public function triggerProfileUpdate($user, &$data, $changed, $isNew)

{

    $value = $data['alias_of_phone_field'];

    $db = JFactory::getDbo();

    $query = 'UPDATE your_table SET phone_column = ' . $db->quote($value) . ' WHERE user_id = ' . $user->id ;

    $db->setQuery($query);

    $result = $db->execute();

}
  1. more than a month ago
  2. Features Request
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.