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 -r1.2
--- openacs-4/contrib/packages/irc-logger/tcl/irc-logger-procs-postgresql.xql	30 Jan 2003 02:48:48 -0000	1.1
+++ openacs-4/contrib/packages/irc-logger/tcl/irc-logger-procs-postgresql.xql	31 Jan 2003 06:27:32 -0000	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>