public function saveMemberSocialIds($siteArr, $useAvatarFromSocialSite, $memberId)
{
$socialIdSiteArr = SocialMedia::getSocialSiteIdArr();
DB::beginTransaction();
// delete existing relationships in table
DB::table('member_social_ids')->where('member_id', $memberId)->delete();
// save new
if (count($siteArr) > 0) {
$valuesArr = array();
foreach ($siteArr as $site => $arr) {
$site = trim($site);
$siteId = trim($arr['id']);
if ($siteId == '' || $site == '' || !isset($socialIdSiteArr[$site])) {
continue;
}
$avatarSrc = isset($arr['avatar_src']) ? $arr['avatar_src'] : '';
$primaryAvatar = 0;
if ($useAvatarFromSocialSite == $site) {
$primaryAvatar = 1;
}
$valuesArr[] = array('member_id' => $memberId, 'social_site' => $site, 'member_social_id' => $siteId, 'disabled' => $arr['disabled'], 'primary_avatar' => $primaryAvatar, 'avatar' => $avatarSrc);
}
if (count($valuesArr) > 0) {
DB::table('member_social_ids')->insert($valuesArr);
}
DB::commit();
}
}
