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(); } }