Easy Profile - Joomla Extension

Easy Profile Support wrote:

Hi,
sorry but this is too complex for our support, you need a developer to make this.

Some Tip:
- Develop plugin based on our skeleton plugin to store changes from users in an DB table
- Develop system plugin to get data from DB table, generate a mail and send message
- Maybe you need also a Cron process to trigger previous system plugin

Easy Profile Support wrote:

- Develop plugin based on our skeleton plugin to store changes from users in an DB table

Just a question, by DB table, do you mean a custom table created by me where I'll store all changes made?

I'm trying to develop the plugin, it's quite difficult

triggerProfileUpdate($user,&$data,$changed,$isNew){ 

    if(!isNew && count($changed))

    {

        $user_id=$user->id;

        $user_formatName=$user->name;

        $user_fieldsUpdated=implode('; ',$changed);

        $user_oldValues=array();

        $user_newValues=array();

        foreach($changed as $fieldChanged)

        {

            $user_oldValues[]=$user->$fieldChanged;

            $user_newValues[]=$data[$fieldChanged];

        }

        $user_oldValues=implode('; ',$user_oldValues);

        $user_newValues=implode('; ',$user_newValues);

        

        // Code to store data in DB table

        $db=JFactory::getDbo();

        $query=$db->getQuery(true);

        $columns = array('user_id', 'fullname', 'fieldsUpdated', 'oldValues', 'newValues');

        $values = array($user_id, $db->quote($user_formatName), $db->quote($user_fieldsUpdated), $db->quote($user_oldValues), $db->quote($user_newValues));

 

        $query->insert($db->quoteName('#__yourTable'))->columns($db->quoteName($columns))->values(implode(',', $values));

 

        $db->setQuery($query);

        $db->execute();

    }

}