Index: openacs-4/packages/acs-subsite/www/pvt/alerts-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/alerts-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/www/pvt/alerts-oracle.xql 1 May 2001 19:00:18 -0000 1.1 @@ -0,0 +1,26 @@ + + + + oracle8.1.6 + + + + + select cea.valid_p, + ad.domain, + cea.alert_id, + cea.expires, + cea.frequency, + cea.alert_type, + cea.category, + cea.keywords + from classified_email_alerts cea, ad_domains ad + where user_id = :user_id + and ad.domain_id = cea.domain_id + and sysdate <= expires + order by expires desc + + + + + Index: openacs-4/packages/acs-subsite/www/pvt/alerts-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/alerts-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-subsite/www/pvt/alerts-postgresql.xql 22 Apr 2001 16:13:15 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/pvt/alerts-postgresql.xql 1 May 2001 19:00:18 -0000 1.2 @@ -1,25 +1,11 @@ + -postgresql7.1 + postgresql7.1 - - -select first_names, last_name, email, url from persons, parties where persons.person_id = parties.party_id and party_id =:user_id - - - - - - select bea.valid_p, bea.frequency, bea.keywords, bt.topic, bea.rowid - from bboard_email_alerts bea, bboard_topics bt - where bea.user_id = :user_id - and bea.topic_id = bt.topic_id - order by bea.frequency - - - - - + + + select cea.valid_p, ad.domain, cea.alert_id, @@ -31,9 +17,10 @@ from classified_email_alerts cea, ad_domains ad where user_id = :user_id and ad.domain_id = cea.domain_id - and sysdate <= expires + and now() <= expires order by expires desc - + + Index: openacs-4/packages/acs-subsite/www/pvt/alerts.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/alerts.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/www/pvt/alerts.xql 1 May 2001 19:00:18 -0000 1.1 @@ -0,0 +1,23 @@ + + + + + + select first_names, last_name, email, url from persons, parties where persons.person_id = parties.party_id and party_id =:user_id + + + + + + + + select bea.valid_p, bea.frequency, bea.keywords, bt.topic, bea.rowid + from bboard_email_alerts bea, bboard_topics bt + where bea.user_id = :user_id + and bea.topic_id = bt.topic_id + order by bea.frequency + + + + + Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/acs-subsite/www/pvt/home-postgresql.xql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/acs-subsite/www/pvt/home.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/home.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/www/pvt/home.xql 1 May 2001 19:00:18 -0000 1.1 @@ -0,0 +1,45 @@ + + + + + + + select first_names, last_name, email, url, + coalesce(screen_name,'< none set up >') as screen_name + from cc_users + where user_id=:user_id + + + + + + + + +select attr_value +from acs_attribute_values +where object_id = :user_id +and attribute_id = + (select attribute_id + from acs_attributes + where object_type = 'person' + and attribute_name = 'bio') + + + + + + + + select cr.publish_date, coalesce(cr.title,'your portrait') as portrait_title + from cr_revisions cr, cr_items ci, acs_rels a + where cr.revision_id = ci.live_revision + and ci.item_id = a.object_id_two + and a.object_id_one = :user_id + and a.rel_type = 'user_portrait_rel' + + + + + + Index: openacs-4/packages/acs-subsite/www/pvt/set-on-vacation-to-null.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/set-on-vacation-to-null.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/www/pvt/set-on-vacation-to-null.xql 1 May 2001 19:00:18 -0000 1.1 @@ -0,0 +1,24 @@ + + + + + + + select no_alerts_until from users where user_id = :user_id + + + + + + + + + update users + set no_alerts_until = :clear + where user_id = :user_id + + + + + + Index: openacs-4/packages/acs-subsite/www/pvt/set-on-vacation-until.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/set-on-vacation-until.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/www/pvt/set-on-vacation-until.xql 1 May 2001 19:00:18 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + update users set no_alerts_until = :on_vacation_until where user_id = :user_id + + + + + Index: openacs-4/packages/acs-subsite/www/pvt/toggle-dont-spam-me-p-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/toggle-dont-spam-me-p-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/www/pvt/toggle-dont-spam-me-p-oracle.xql 1 May 2001 19:00:18 -0000 1.1 @@ -0,0 +1,13 @@ + + + + oracle8.1.6 + + + + update user_preferences set dont_spam_me_p = util.logical_negation(dont_spam_me_p) where user_id = :user_id + + + + + Index: openacs-4/packages/acs-subsite/www/pvt/toggle-dont-spam-me-p-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/toggle-dont-spam-me-p-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-subsite/www/pvt/toggle-dont-spam-me-p-postgresql.xql 22 Apr 2001 16:13:15 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/pvt/toggle-dont-spam-me-p-postgresql.xql 1 May 2001 19:00:18 -0000 1.2 @@ -1,11 +1,13 @@ + -postgresql7.1 + postgresql7.1 - - -update user_preferences set dont_spam_me_p = util__logical_negation(dont_spam_me_p) where user_id = :user_id - + + + update user_preferences set dont_spam_me_p = util__logical_negation(dont_spam_me_p) where user_id = :user_id + + Index: openacs-4/packages/acs-subsite/www/pvt/unsubscribe-2-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/unsubscribe-2-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/www/pvt/unsubscribe-2-oracle.xql 1 May 2001 19:00:18 -0000 1.1 @@ -0,0 +1,26 @@ + + + + oracle8.1.6 + + + + select rel_id +from group_member_map +where group_id = acs.magic_object_id('registered_users') + and member_id = :user_id + + + + + + + +begin + membership_rel.deleted( rel_id => :rel_id ); +end; + + + + + Index: openacs-4/packages/acs-subsite/www/pvt/unsubscribe-2-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/unsubscribe-2-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-subsite/www/pvt/unsubscribe-2-postgresql.xql 22 Apr 2001 16:13:15 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/pvt/unsubscribe-2-postgresql.xql 1 May 2001 19:00:18 -0000 1.2 @@ -1,20 +1,25 @@ + -postgresql7.1 + postgresql7.1 - - -select rel_id + + + select rel_id from group_member_map where group_id = acs__magic_object_id('registered_users') and member_id = :user_id - + - - - select membership_rel__deleted(:rel_id); - + + + + + select membership_rel__deleted( :rel_id ); + + + Index: openacs-4/packages/acs-subsite/www/pvt/unsubscribe-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/unsubscribe-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/www/pvt/unsubscribe-oracle.xql 1 May 2001 19:00:18 -0000 1.1 @@ -0,0 +1,15 @@ + + + + oracle8.1.6 + + + + select no_alerts_until, acs_user.receives_alerts_p(:user_id) as on_vacation_p +from users +where user_id = :user_id + + + + + Index: openacs-4/packages/acs-subsite/www/pvt/unsubscribe-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/unsubscribe-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-subsite/www/pvt/unsubscribe-postgresql.xql 22 Apr 2001 16:13:15 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/pvt/unsubscribe-postgresql.xql 1 May 2001 19:00:18 -0000 1.2 @@ -1,13 +1,15 @@ + -postgresql7.1 + postgresql7.1 - - -select no_alerts_until, acs_user__receives_alerts_p(:user_id) as on_vacation_p + + + select no_alerts_until, acs_user__receives_alerts_p(:user_id) as on_vacation_p from users where user_id = :user_id - + + Index: openacs-4/packages/acs-subsite/www/pvt/unsubscribe.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/unsubscribe.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/www/pvt/unsubscribe.xql 1 May 2001 19:00:18 -0000 1.1 @@ -0,0 +1,13 @@ + + + + + + select dont_spam_me_p +from user_preferences +where user_id = :user_id + + + + +