function addToSharingTable() {
parent::addToSharingTable(); // Default processing
$oid = $this->getId() ;
if ( $member = $this->getSelfMember() ) {
$mid = $member->getId();
$sql = "
SELECT distinct(permission_group_id) as gid
FROM ".TABLE_PREFIX."contact_member_permissions
WHERE member_id = $mid
";
$rows = DB::executeAll($sql);
if (is_array($rows)) {
foreach ($rows as $row ) {
$values = array();
if ($gid = array_var($row, 'gid')) {
$values[] = "($oid, $gid)";
}
if (count($values) > 0) {
$values_str = implode(",", $values);
DB::execute("INSERT INTO ".TABLE_PREFIX."sharing_table (object_id, group_id) VALUES $values_str ON DUPLICATE KEY UPDATE object_id=object_id");
}
}
}
}
}
