select (user_id) as dummy from jb_screens where user_id = :user_id insert into jb_user_jabber_information (user_id) values (:user_id) select screen_id from jb_screens where im_screen_name = :jscreen and service = 'j' update jb_user_jabber_information SET jabber_regstate = 'a' , jabber_passwd = :passwd where user_id = :user_id select screen_id from jb_screens where lower(im_screen_name) = lower(:screen) and lower(service) = lower(:service) update jb_screens set refcount = refcount + 1 where screen_id = :screen_id insert into jb_screens (screen_id , im_screen_name , service ,status , refcount ) values (acs_object_id_seq.nextval , lower(:screen) , lower(:service) , 'offline' , '1') select (screen_id) as new_screen_id from jb_screens where im_screen_name = lower(:screen) and service = lower(:service) select (sn.im_screen_name) as screen, (sn.service) as service ,(sn.status) as status FROM jb_screens sn WHERE sn.user_id = :user_id select (sn.im_screen_name) as screen, (sn.service) as service ,(sn.status) as status FROM jb_screens sn WHERE sn.user_id = :user_id_friend SELECT (sn.im_screen_name) as screen FROM jb_screens sn WHERE sn.user_id = :user_id_friend AND sn.service = 'aim' SELECT im_screen_name FROM jb_screens WHERE user_id = :user_id AND service = 'jabber' SELECT (jcr.room_id) as room_id , (jcr.name) as room_name FROM jb_room_start_from_thread jrsft , jb_conference_rooms jcr WHERE jrsft.thread_id = :thread_id AND jrsft.room_id = jcr.room_id SELECT (thread_id) as cur_thread_id , subject , start_time FROM jb_conference_room_threads WHERE room_id = :room_id SELECT (jcr.name) as room_name FROM jb_conference_groups jcg , jb_conference_rooms jcr WHERE jcg.group_id = :group_id AND jcg.default_room_id = jcr.room_id SELECT group_name FROM groups WHERE group_id = :group_id SELECT room_id FROM jb_conference_rooms WHERE lower(name) = lower(:room_name) SELECT (room_id) as new_room_id FROM jb_conference_rooms WHERE name = :room_name INSERT INTO jb_room_party_map (room_id , party_id) VALUES (:new_room_id , :group_id) UPDATE jb_conference_rooms SET type = 'master' WHERE room_id = :new_room_id Select jb_make_group_conference_group(:room_name , :group_id) SELECT im_screen_name , status , service FROM jb_screens WHERE user_id = :to_user_id