function get_owner_site_id($entity_id)
{
// do we really need the whole object?
//$d = get_entity_by_id_object( $entity_id );
$d = new DBSelector();
$d->add_table('entity');
$d->add_relation('entity.id = ' . $entity_id);
$d->add_field('r', 'entity_a', 'site_id');
$d->add_table('ar', 'allowable_relationship');
$d->add_table('r', 'relationship');
$d->add_relation('ar.id = r.type');
if (reason_relationship_names_are_unique()) {
$d->add_relation('ar.type = "owns"');
} else {
$d->add_relation('ar.name = "owns"');
}
$d->add_relation('r.entity_b = ' . $entity_id);
$d->set_num(1);
$r = db_query($d->get_query(), 'Error getting owning site ID.');
if ($row = mysql_fetch_array($r, MYSQL_ASSOC)) {
return $row['site_id'];
} else {
return false;
}
}
