Index: openacs-4/packages/new-portal/tcl/portal-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/tcl/portal-procs.xql,v diff -u -r1.9 -r1.10 --- openacs-4/packages/new-portal/tcl/portal-procs.xql 22 Jan 2002 01:31:52 -0000 1.9 +++ openacs-4/packages/new-portal/tcl/portal-procs.xql 22 Jan 2002 20:02:40 -0000 1.10 @@ -81,12 +81,11 @@ - select p.name, pcp.portal_id, pp.layout_id, pl.filename as template - from portals p, portal_current_page pcp, portal_layouts pl, portal_pages pp - where pcp.page_id = :page_id - and pcp.portal_id = :portal_id - and p.portal_id = pcp.portal_id - and pp.page_id = pcp.page_id + select p.name, p.portal_id, pl.filename as template, pp.pretty_name as page_name + from portals p, portal_layouts pl, portal_pages pp + where pp.portal_id = :portal_id + and pp.page_id = :page_id + and pp.portal_id = p.portal_id and pl.layout_id = pp.layout_id @@ -533,5 +532,12 @@ + + + select theme_id from portal_element_themes where name = :theme_name + + + +