approved_p
. (tzumainn)
ns_share
Memoize
procedure with util_memoize
ad_user_group_authorized_admin_or_site_admin
API
call to the permissions package.
static_page_index_exclusion
table
to community-core.sql; this stores SQL LIKE patterns to exclude pages
from the site-wide index
one_if_within_n_days
to
/doc/sql/pl-sql.sql (necessary for ecommerce module)
ad_header
with an optional arg for
extra stuff to put in the document HEAD (e.g., JavaScript)
ns_ora blob_dml_file
command); see
file-storage
util_link_responding_p
), and one-click restoration of links
thought to be dead by the sweeper
users_contact
in community-core.sql (thank you, Sean Y)
alter table users_contact add ( cell_phone varchar(100), priv_cell_phone integer, note varchar(4000), current_information varchar(4000) );
-- an ISO 639 language code (in lowercase) language_preference char(2) default 'en',
util_report_library_entry
and
util_report_successful_library_load
to
utilities and call them from a bunch of /tcl files so as to make
debugging easier in the event of a source code error
(**** you'll have to upgrade your utilities from
http://www.photo.net/wtr/thebook/utilities.txt to make your ACS work ****)
url
being clobbered in /pvt/home
by admin group url (thanks again, Raissa)
approved_p
column to the users
table, which
in turns breaks lots and lots of pages site-wide (because
approved_p
becomes ambiguously defined in a JOIN)
users_by_last_visit
(in
/doc/sql/community-core.sql)
n_sessions
column to the users
table.
classified_ads_audit
, two indices,
audit insert statements all over the place. Also removed some dead code
and clarified the individual ad pages.
[DoubleApos $topic]
in /bboard/q-and-a-fetch-msg, /bboard/q-and-a-post-repl-form, /bboard/usgeospacial-fetch-msg, bboard/usgeospacial-post-reply-form
checked_date date
to the
links
table.
ad_context_bar
to
/tcl/ad-navigation to support Yahoo-style navigation.
users_alertable
view to the database that
excludes users who've been deleted, who are on vacation, or whose email
address is generating bounces. Added pages to let a user announce a
vacation and then mark his or her return. Changed all the procedures
that generate alerts to query from users_alertable
rather
than users
.
administrator_p
column from the users
table, added a predefined user_group of type "system", group name
"administrators" that accomplishes the same function (lumping a set of
users together as admins).
ad_acs_version
and
ad_acs_release_date
to /tcl/ad-defs; these will let you
write programs that adjust to the ACS version