×
Blue Eagle (1.5.0) for K5.1 is released (20 Jul 2018)

Please update the Kunena Blue Eagle to 1.5.0 if you use Kunena 5.1.
We made several bug fixes and improvements. Also Blue Eagle has now all the features from Crypsis.
Download: www.kunena.org/download/templates/category/blue-eagle-5

× This is not a support forum for JomSocial or its related products. For JomSocial support you should visit JomSocial .

The information given in this category is intended to guide users who want to use JomSocial with Kunena and, mostly, was written by Kunena users. The information here is not necessarily accurate, up-to-date nor is it intended to replace the support given by the developers of JomSocial.

If you are having problems then, for your own benefit, it would save us all a lot of time if you would kindly post your configuration report when you ask for help from this forum. If you do not post your configuration report we will not ask you for it but you will probably not get your problem solved, either.

Solved Reference Kunena_users avatar collum

More
2 years 8 months ago #1 by breebee2
Hey guys, i am trying to swap a comet chat avatar linked to jomsocial user avatar with the kunena users avatar and i cant seem to reference the actual collum correctly. This is the original and my manual attempt of the DB define that im trying to edit since which i have tried multiple combinations to switch to kunena, sorry for the burden. I will attach the php file just incase theres something there thats breaking( short file)
 
$config = new JConfig;
$secret = $config->secret;
 
 
 
define('DB_SERVER',		       'localhost'	    );
define('DB_PORT',              '3306'   	    );
define('DB_USERNAME',	       'username'	    );
define('DB_PASSWORD',	       'password'	    );
define('DB_NAME',   	       'lc' 	        );
define('TABLE_PREFIX',	       'jos_'           );
define('DB_USERTABLE',         'kunena_users'	);
define('DB_USERTABLE_NAME',	   'name'   	    );
define('DB_USERTABLE_USERID',  'kunena_users_userid');
define('DB_AVATARTABLE',       'kunena_users'      	);
define('DB_AVATARFIELD',       'kunena_users_avatar');
 
 
$config = new JConfig;
$secret = $config->secret;
 
// DO NOT EDIT DATABASE VALUES BELOW
// DO NOT EDIT DATABASE VALUES BELOW
// DO NOT EDIT DATABASE VALUES BELOW
 
define('DB_SERVER',				$config->host								);
define('DB_PORT',				'3306'										);
define('DB_USERNAME',				$config->user								);
define('DB_PASSWORD',				$config->password							);
define('DB_NAME',				$config->db									);
define('TABLE_PREFIX',				$config->dbprefix							);
define('DB_USERTABLE',				'users'										);
define('DB_USERTABLE_NAME',			'name'										);
define('DB_USERTABLE_USERID',                   'id'										);
define('DB_AVATARTABLE',                        " left join ".TABLE_PREFIX."community_users on ".TABLE_PREFIX."community_users.userid = ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID.""							);
define('DB_AVATARFIELD',                        " ".TABLE_PREFIX."community_users.thumb "	);
 
 
Attachments:

Please Log in or Create an account to join the conversation.

More
2 years 8 months ago #2 by breebee2
Ok so the answer was kunena_users.avatar , my problem was in the get user information function. Hope this helps anyone in the future :D

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to add attachements.
  • Not Allowed: to edit your message.
Time to create page: 0.075 seconds