Index: openacs-4/contrib/packages/irc-logger/tcl/irc-logger-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/irc-logger/tcl/irc-logger-procs-postgresql.xql,v diff -u -r1.1.1.1 -r1.1.1.2 --- openacs-4/contrib/packages/irc-logger/tcl/irc-logger-procs-postgresql.xql 30 Jan 2003 02:48:48 -0000 1.1.1.1 +++ openacs-4/contrib/packages/irc-logger/tcl/irc-logger-procs-postgresql.xql 11 Feb 2003 21:36:20 -0000 1.1.1.2 @@ -11,4 +11,15 @@ select etp__create_page(:parent_package_id, :date, :date, :content_type) </querytext> </fullquery> + + <fullquery name="dom::xpathFunc::irc::logger::user_link.get_user"> + <querytext> + select u.user_id, p.first_names || ' ' || p.last_name as name + from users u, persons p + where u.screen_name = :nick + and p.person_id = u.user_id + limit 1 + </querytext> + </fullquery> + </queryset>