Easy Profile - Joomla Extension

My alias for the Signature filed is 'signature'.

I installed the plugin again and now I am getting the following error when I open my website.
0
SYNTAX ERROR, UNEXPECTED 'PUBLIC' (T_PUBLIC), EXPECTING END OF FILE

If I disable the plugin or uninstall it the website returns to normal.

I have already replied at https://www.easy-profile.com/support/kunena-integration-only-partial-works.html

Is there any way to link the two fields in MySQL backend under PHPAdmin?

No sorry

My alias for the Signature filed is 'signature'.

I installed the plugin again and now I am getting the following error when I open my website.
0
SYNTAX ERROR, UNEXPECTED 'PUBLIC' (T_PUBLIC), EXPECTING END OF FILE

If I disable the plugin or uninstall it the website returns to normal.

Hi @sgower,
and sorry for late reply.

You should change $data['signature'] with alias of your Easy Profile signature field, for example like $data['about_me'].

I have tried the above plugin and was able to get it to load but it does not work. Do I need to edit any of the script to make it work with my database?

Thank you very much!!!

Hi,

But I can`t import the existing Signatur in the EasyProfile field, is this right?

The fast way to do this is with an SQL query like:

UPDATE prefix_jsn_users SET signature = (SELECT signature FROM prefix_kunena_users WHERE userid = id);

Replace "prefix" with the prefix of your Joomla installation.

You can do this with a Database Tool like phpMyAdmin, normally all hosting provider provide you a tool like this.

IMPORTANT: I have tested this query in my dev environment without problems, but I recommend you to make a backup before.

Hello and thanx for your reply. I tried your solution and it works. But I can`t import the existing Signatur in the EasyProfile field, is this right?
Only in this one direction, have I understood that correctly?

Hi,
sorry for late reply, unfortunately the Kunena - Easy Profile plugin does not allow this and this is not developed by us.

to make something like this you need to develop a small plugin by following these steps:
- Create a Easy Profile field called "Signature" (type: Textarea), alias should be "signature"
- Download, Install and Enable out Skeleton Plugin (you can find it at the end of page at http://docs.easy-profile.com/index.php/article/triggers)
- Open file /plugins/jsn/skeleton/skeleton.php
- Remove Sample Functions: triggerFieldAvatarUpdate, triggerProfileUpdate
- Write a function like this:

public function triggerProfileUpdate($user,&$data,$changed,$isNew)

	{

		if($user->id && isset($data['signature'])){

			$signature = $data['signature'];

			$db = JFactory::getDbo();

			$query = 'UPDATE #__kunena_users SET signature = '.$db->quote($signature). ' WHERE userid = '. (int) $user->id;

			$db->setQuery($query);

			$db->execute();

		}

	}

Now when you update the field called "Signature" then this function will copy the value also in Kunena table.

Docs about Easy Profile triggers at http://docs.easy-profile.com/index.php/article/triggers

NOTE: This code is not tested and not supported, this is only for example purpose