It looks like I missed that one when I ported it - Sorry!
Here's a patch (both the datamodel file and the neighborhoods.tcl file need to be patched). I'll log it in the SDM and send Roberto a note as well.
diff -urBb acs3-pg/www/doc/sql/homepage.sql openkurup/www/doc/sql/homepage.sql
--- acs3-pg/www/doc/sql/homepage.sql Fri Apr 14 14:52:01 2000
+++ openkurup/www/doc/sql/homepage.sql Thu Apr 26 15:50:27 2001
@@ -764,6 +764,18 @@
' language 'plpgsql';
+create function hp_get_nh_member_count(integer) returns integer as '
+declare
+ neighborhoodid alias for $1;
+ counter integer;
+BEGIN
+ select into counter count(*) from users_homepages
+ where neighborhood_id = neighborhoodid;
+ return counter;
+END;
+' language 'plpgsql';
+
+
create function hp_neighborhood_in_subtree_p(integer,integer) returns varchar as '
declare
source_node alias for $1;
diff -urBb acs3-pg/www/homepage/neighborhoods.tcl openkurup/www/homepage/neighborhoods.tcl
--- acs3-pg/www/homepage/neighborhoods.tcl Mon Mar 26 14:22:00 2001
+++ openkurup/www/homepage/neighborhoods.tcl Thu Apr 26 15:50:40 2001
@@ -200,7 +200,8 @@
hp_neighborhood_level_gen(neighborhood_id,1,0) as level,
description,
parent_id,
- hp_neighborhood_sortkey_gen(neighborhood_id,hp_get_neighborhood_root_node()) as generated_sort_key
+ hp_neighborhood_sortkey_gen(neighborhood_id,hp_get_neighborhood_root_node()) as generated_sort_key,
+ hp_get_nh_member_count(neighborhood_id) as total_homepages
from users_neighborhoods
where hp_neighborhood_level_gen(neighborhood_id,1,0) > 1
and hp_neighborid_is_subnode(neighborhood_id,$neighborhood_node) = 't'
