postgresql7.1
select content_symlink__new(
:name,
:label,
:sym_item_id,
:folder_id,
null,
current_timestamp,
:user_id,
:ip
);
select
content_item__get_title(item_id,'f') as title, 'symlink_to_' || name as name,
item_id
from
cr_items
where
item_id in ([join $clip_items ","])
and
-- only items which have are not symlinks
content_type != 'content_symlink'
and
-- only for those item which user has cm_examine
cms_permission__permission_p(item_id, :user_id, 'cm_examine') = 't'