query("SELECT * FROM " . $default->owl_folders_user_links_table . " AS FURL INNER JOIN " . $default->owl_role_table . " AS R ON FURL.role_id = R.id WHERE folder_id = " . $iFolderID . " AND user_id = " . $_SESSION["user_id"] . " AND R.can_write = 1"); if ($sql->next_record()) { return true; } $_SESSION["errorMessage"] = $lang_err_user_role; return false; } /** * Checks if a given role exists using the role primary key * * @param $iRoleID Primary key of role to check for * * @return true if role exists, false otherwise and set $_SESSION["errorMessage"] */ function roleIDExists($iRoleID) { global $default; $sql = new Owl_DB(); $sql->query("SELECT id FROM " . $default->owl_role_table . " WHERE id = " . $iRoleID; if (sql->next_record()) { return true; } $_SESSION["errorMessage"] = $lang_err_role_not_exist . $sRoleName; return false; } /** * Checks if a given role exists using the role name * * @param $sRoleName Name of role to check for * * @return true if role exists, false otherwise and set $_SESSION["errorMessage"] */ function roleNameExists($sRoleName) { global $default; $sql = new Owl_DB(); $sql->query("SELECT id FROM " . $default->owl_role_table . " WHERE name = '" . $sRoleName . "'"; if (sql->next_record()) { return true; } $_SESSION["errorMessage"] = $lang_err_role_not_exist . $sRoleName; return false; } /** * Get the primary key for a role * * @param $sRoleName Name of role to get primary key for * * @return ID if role exists, false otherwise and set $_SESSION["errorMessage"] */ function getRoleID($sRoleName) { global $default, $lang_database_error; if (roleExists($sRoleName) { $sql = new Owl_DB(); $sql->query("SELECT id FROM " . $default->owl_role_table . " WHERE name = '" . $sRoleName . "'"; sql->next_record(); return sql->f("id"); } $_SESSION["errorMessage"] = $lang_database_error; return false; } /** * Checks if the current user is in a given role * * @param $sRoleName Name of role to check * * @return true if the user is in the role, false otherwise and sets $_SESSION["errorMessage"] */ function isInGroup($sGroupName) { return true; } } ?>