/** * Resets and cascades permissions down to child objects * * @access private */ private static function cascade_permissions() { $db = new argent_database(); //$db->start_transaction(); /* Remove old cascade rules */ $sql = "\r\n DELETE FROM\r\n `ua_permissions`\r\n WHERE\r\n `master` != ''\r\n "; $db->query($sql); $sql = "\r\n SELECT\r\n *\r\n FROM\r\n `ua_permissions`\r\n WHERE\r\n `cascade` = 1\r\n "; $rules = $db->returntable($sql); if (count($rules) > 0) { foreach ($rules as $rule) { $user = $rule['user_id']; $meta_guid = $rule['meta_guid']; $descendents = argent_meta::descendents($rule['object_id']); if (count($descendents) > 0) { foreach ($descendents as $descendent) { $newguid = argent_identifier::meta_guid(); $sql = "\r\n INSERT INTO\r\n `ua_permissions`\r\n (\r\n `meta_guid`,\r\n `object_id`,\r\n `user_id`,\r\n `cascade`,\r\n `master`,\r\n `create`,\r\n `read`,\r\n `update`,\r\n `delete`,\r\n `meta_timestamp`\r\n )\r\n VALUES(\r\n '{$newguid}',\r\n '{$descendent}',\r\n '{$user}',\r\n 0,\r\n '{$meta_guid}',\r\n {$rule['create']},\r\n {$rule['read']},\r\n {$rule['update']},\r\n {$rule['delete']},\r\n NOW()\r\n )\r\n "; $db->query($sql); } } } } }
public static function find_related($primary_object_id = null, $secondary_object_id = null, $relationship = null, $include_reverse = false) { $error = new argent_error(); $db = new argent_database(); if ($primary_object_id != null && !argent_meta::object_registered($primary_object_id)) { $error->add('1038', 'Object does not exist', $primary_object_id, 'argent_uauth'); } if ($secondary_object_id != null && !argent_meta::object_registered($secondary_object_id)) { $error->add('1038', 'Object does not exist', $secondary_object_id, 'argent_uauth'); } if (!is_string($relationship) && $relationship != null) { $error->add('1050', 'Invalid data type: expecting STRING', $relationship, 'argent_meta'); } if ($error->has_errors()) { return $error; } $sql = "\r\n SELECT\r\n *\r\n FROM\r\n `ua_relationships`\r\n WHERE\r\n "; if ($primary_object_id != null || $secondary_object_id != null) { $sql .= "\r\n (\r\n "; } if ($primary_object_id != null) { $sql .= "`primary_object_id` = '{$db->escape_value($primary_object_id)}'"; } if ($primary_object_id != null && $secondary_object_id != null) { $sql .= "\r\n AND\r\n "; } if ($secondary_object_id != null) { $sql .= "\r\n `secondary_object_id` = '{$db->escape_value($secondary_object_id)}'\r\n "; } if ($primary_object_id != null || $secondary_object_id != null) { $sql .= "\r\n )\r\n "; } if ($include_reverse) { $sql .= "\r\n OR\r\n "; if ($primary_object_id != null || $secondary_object_id != null) { $sql .= "\r\n (\r\n "; } if ($secondary_object_id != null) { $sql .= "`primary_object_id` = '{$db->escape_value($secondary_object_id)}'"; } if ($primary_object_id != null && $secondary_object_id != null) { $sql .= "\r\n AND\r\n "; } if ($primary_object_id != null) { $sql .= "\r\n `secondary_object_id` = '{$db->escape_value($primary_object_id)}'\r\n "; } if ($primary_object_id != null || $secondary_object_id != null) { $sql .= "\r\n )\r\n "; } } if ($relationship != null && ($primary_object_id != null || $secondary_object_id != null)) { $sql .= "\r\n AND\r\n "; } if ($relationship != null) { $sql .= "\r\n `relationship` = '{$db->escape_value($relationship)}'\r\n "; } $relationship_data = $db->returntable($sql); return $relationship_data; }