Index: openacs.org-dev/license.txt =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/license.txt,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/license.txt 25 Jul 2002 18:46:42 -0000 1.1 @@ -0,0 +1,340 @@ + GNU GENERAL PUBLIC LICENSE + Version 2, June 1991 + + Copyright (C) 1989, 1991 Free Software Foundation, Inc. + 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + Everyone is permitted to copy and distribute verbatim copies + of this license document, but changing it is not allowed. + + Preamble + + The licenses for most software are designed to take away your +freedom to share and change it. By contrast, the GNU General Public +License is intended to guarantee your freedom to share and change free +software--to make sure the software is free for all its users. This +General Public License applies to most of the Free Software +Foundation's software and to any other program whose authors commit to +using it. (Some other Free Software Foundation software is covered by +the GNU Library General Public License instead.) You can apply it to +your programs, too. + + When we speak of free software, we are referring to freedom, not +price. Our General Public Licenses are designed to make sure that you +have the freedom to distribute copies of free software (and charge for +this service if you wish), that you receive source code or can get it +if you want it, that you can change the software or use pieces of it +in new free programs; and that you know you can do these things. + + To protect your rights, we need to make restrictions that forbid +anyone to deny you these rights or to ask you to surrender the rights. +These restrictions translate to certain responsibilities for you if you +distribute copies of the software, or if you modify it. + + For example, if you distribute copies of such a program, whether +gratis or for a fee, you must give the recipients all the rights that +you have. You must make sure that they, too, receive or can get the +source code. And you must show them these terms so they know their +rights. + + We protect your rights with two steps: (1) copyright the software, and +(2) offer you this license which gives you legal permission to copy, +distribute and/or modify the software. + + Also, for each author's protection and ours, we want to make certain +that everyone understands that there is no warranty for this free +software. If the software is modified by someone else and passed on, we +want its recipients to know that what they have is not the original, so +that any problems introduced by others will not reflect on the original +authors' reputations. + + Finally, any free program is threatened constantly by software +patents. We wish to avoid the danger that redistributors of a free +program will individually obtain patent licenses, in effect making the +program proprietary. To prevent this, we have made it clear that any +patent must be licensed for everyone's free use or not licensed at all. + + The precise terms and conditions for copying, distribution and +modification follow. + + GNU GENERAL PUBLIC LICENSE + TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION + + 0. This License applies to any program or other work which contains +a notice placed by the copyright holder saying it may be distributed +under the terms of this General Public License. The "Program", below, +refers to any such program or work, and a "work based on the Program" +means either the Program or any derivative work under copyright law: +that is to say, a work containing the Program or a portion of it, +either verbatim or with modifications and/or translated into another +language. (Hereinafter, translation is included without limitation in +the term "modification".) Each licensee is addressed as "you". + +Activities other than copying, distribution and modification are not +covered by this License; they are outside its scope. The act of +running the Program is not restricted, and the output from the Program +is covered only if its contents constitute a work based on the +Program (independent of having been made by running the Program). +Whether that is true depends on what the Program does. + + 1. You may copy and distribute verbatim copies of the Program's +source code as you receive it, in any medium, provided that you +conspicuously and appropriately publish on each copy an appropriate +copyright notice and disclaimer of warranty; keep intact all the +notices that refer to this License and to the absence of any warranty; +and give any other recipients of the Program a copy of this License +along with the Program. + +You may charge a fee for the physical act of transferring a copy, and +you may at your option offer warranty protection in exchange for a fee. + + 2. You may modify your copy or copies of the Program or any portion +of it, thus forming a work based on the Program, and copy and +distribute such modifications or work under the terms of Section 1 +above, provided that you also meet all of these conditions: + + a) You must cause the modified files to carry prominent notices + stating that you changed the files and the date of any change. + + b) You must cause any work that you distribute or publish, that in + whole or in part contains or is derived from the Program or any + part thereof, to be licensed as a whole at no charge to all third + parties under the terms of this License. + + c) If the modified program normally reads commands interactively + when run, you must cause it, when started running for such + interactive use in the most ordinary way, to print or display an + announcement including an appropriate copyright notice and a + notice that there is no warranty (or else, saying that you provide + a warranty) and that users may redistribute the program under + these conditions, and telling the user how to view a copy of this + License. (Exception: if the Program itself is interactive but + does not normally print such an announcement, your work based on + the Program is not required to print an announcement.) + +These requirements apply to the modified work as a whole. If +identifiable sections of that work are not derived from the Program, +and can be reasonably considered independent and separate works in +themselves, then this License, and its terms, do not apply to those +sections when you distribute them as separate works. But when you +distribute the same sections as part of a whole which is a work based +on the Program, the distribution of the whole must be on the terms of +this License, whose permissions for other licensees extend to the +entire whole, and thus to each and every part regardless of who wrote it. + +Thus, it is not the intent of this section to claim rights or contest +your rights to work written entirely by you; rather, the intent is to +exercise the right to control the distribution of derivative or +collective works based on the Program. + +In addition, mere aggregation of another work not based on the Program +with the Program (or with a work based on the Program) on a volume of +a storage or distribution medium does not bring the other work under +the scope of this License. + + 3. You may copy and distribute the Program (or a work based on it, +under Section 2) in object code or executable form under the terms of +Sections 1 and 2 above provided that you also do one of the following: + + a) Accompany it with the complete corresponding machine-readable + source code, which must be distributed under the terms of Sections + 1 and 2 above on a medium customarily used for software interchange; or, + + b) Accompany it with a written offer, valid for at least three + years, to give any third party, for a charge no more than your + cost of physically performing source distribution, a complete + machine-readable copy of the corresponding source code, to be + distributed under the terms of Sections 1 and 2 above on a medium + customarily used for software interchange; or, + + c) Accompany it with the information you received as to the offer + to distribute corresponding source code. (This alternative is + allowed only for noncommercial distribution and only if you + received the program in object code or executable form with such + an offer, in accord with Subsection b above.) + +The source code for a work means the preferred form of the work for +making modifications to it. For an executable work, complete source +code means all the source code for all modules it contains, plus any +associated interface definition files, plus the scripts used to +control compilation and installation of the executable. However, as a +special exception, the source code distributed need not include +anything that is normally distributed (in either source or binary +form) with the major components (compiler, kernel, and so on) of the +operating system on which the executable runs, unless that component +itself accompanies the executable. + +If distribution of executable or object code is made by offering +access to copy from a designated place, then offering equivalent +access to copy the source code from the same place counts as +distribution of the source code, even though third parties are not +compelled to copy the source along with the object code. + + 4. You may not copy, modify, sublicense, or distribute the Program +except as expressly provided under this License. Any attempt +otherwise to copy, modify, sublicense or distribute the Program is +void, and will automatically terminate your rights under this License. +However, parties who have received copies, or rights, from you under +this License will not have their licenses terminated so long as such +parties remain in full compliance. + + 5. You are not required to accept this License, since you have not +signed it. However, nothing else grants you permission to modify or +distribute the Program or its derivative works. These actions are +prohibited by law if you do not accept this License. Therefore, by +modifying or distributing the Program (or any work based on the +Program), you indicate your acceptance of this License to do so, and +all its terms and conditions for copying, distributing or modifying +the Program or works based on it. + + 6. Each time you redistribute the Program (or any work based on the +Program), the recipient automatically receives a license from the +original licensor to copy, distribute or modify the Program subject to +these terms and conditions. You may not impose any further +restrictions on the recipients' exercise of the rights granted herein. +You are not responsible for enforcing compliance by third parties to +this License. + + 7. If, as a consequence of a court judgment or allegation of patent +infringement or for any other reason (not limited to patent issues), +conditions are imposed on you (whether by court order, agreement or +otherwise) that contradict the conditions of this License, they do not +excuse you from the conditions of this License. If you cannot +distribute so as to satisfy simultaneously your obligations under this +License and any other pertinent obligations, then as a consequence you +may not distribute the Program at all. For example, if a patent +license would not permit royalty-free redistribution of the Program by +all those who receive copies directly or indirectly through you, then +the only way you could satisfy both it and this License would be to +refrain entirely from distribution of the Program. + +If any portion of this section is held invalid or unenforceable under +any particular circumstance, the balance of the section is intended to +apply and the section as a whole is intended to apply in other +circumstances. + +It is not the purpose of this section to induce you to infringe any +patents or other property right claims or to contest validity of any +such claims; this section has the sole purpose of protecting the +integrity of the free software distribution system, which is +implemented by public license practices. Many people have made +generous contributions to the wide range of software distributed +through that system in reliance on consistent application of that +system; it is up to the author/donor to decide if he or she is willing +to distribute software through any other system and a licensee cannot +impose that choice. + +This section is intended to make thoroughly clear what is believed to +be a consequence of the rest of this License. + + 8. If the distribution and/or use of the Program is restricted in +certain countries either by patents or by copyrighted interfaces, the +original copyright holder who places the Program under this License +may add an explicit geographical distribution limitation excluding +those countries, so that distribution is permitted only in or among +countries not thus excluded. In such case, this License incorporates +the limitation as if written in the body of this License. + + 9. The Free Software Foundation may publish revised and/or new versions +of the General Public License from time to time. Such new versions will +be similar in spirit to the present version, but may differ in detail to +address new problems or concerns. + +Each version is given a distinguishing version number. If the Program +specifies a version number of this License which applies to it and "any +later version", you have the option of following the terms and conditions +either of that version or of any later version published by the Free +Software Foundation. If the Program does not specify a version number of +this License, you may choose any version ever published by the Free Software +Foundation. + + 10. If you wish to incorporate parts of the Program into other free +programs whose distribution conditions are different, write to the author +to ask for permission. For software which is copyrighted by the Free +Software Foundation, write to the Free Software Foundation; we sometimes +make exceptions for this. Our decision will be guided by the two goals +of preserving the free status of all derivatives of our free software and +of promoting the sharing and reuse of software generally. + + NO WARRANTY + + 11. BECAUSE THE PROGRAM IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY +FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN +OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES +PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED +OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF +MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS +TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU. SHOULD THE +PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, +REPAIR OR CORRECTION. + + 12. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING +WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR +REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, +INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING +OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED +TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY +YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER +PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE +POSSIBILITY OF SUCH DAMAGES. + + END OF TERMS AND CONDITIONS + + How to Apply These Terms to Your New Programs + + If you develop a new program, and you want it to be of the greatest +possible use to the public, the best way to achieve this is to make it +free software which everyone can redistribute and change under these terms. + + To do so, attach the following notices to the program. It is safest +to attach them to the start of each source file to most effectively +convey the exclusion of warranty; and each file should have at least +the "copyright" line and a pointer to where the full notice is found. + + + Copyright (C) + + This program is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with this program; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + + +Also add information on how to contact you by electronic and paper mail. + +If the program is interactive, make it output a short notice like this +when it starts in an interactive mode: + + Gnomovision version 69, Copyright (C) year name of author + Gnomovision comes with ABSOLUTELY NO WARRANTY; for details type `show w'. + This is free software, and you are welcome to redistribute it + under certain conditions; type `show c' for details. + +The hypothetical commands `show w' and `show c' should show the appropriate +parts of the General Public License. Of course, the commands you use may +be called something other than `show w' and `show c'; they could even be +mouse-clicks or menu items--whatever suits your program. + +You should also get your employer (if you work as a programmer) or your +school, if any, to sign a "copyright disclaimer" for the program, if +necessary. Here is a sample; alter the names: + + Yoyodyne, Inc., hereby disclaims all copyright interest in the program + `Gnomovision' (which makes passes at compilers) written by James Hacker. + + , 1 April 1989 + Ty Coon, President of Vice + +This General Public License does not permit incorporating your program into +proprietary programs. If your program is a subroutine library, you may +consider it more useful to permit linking proprietary applications with the +library. If this is what you want to do, use the GNU Library General +Public License instead of this License. Index: openacs.org-dev/packages/acs-tcl/tcl/site-node-apm-integration-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/acs-tcl/tcl/site-node-apm-integration-procs.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/acs-tcl/tcl/site-node-apm-integration-procs.tcl 25 Jul 2002 18:46:52 -0000 1.1 @@ -0,0 +1,70 @@ +ad_library { + + site node / apm integration procs + + @author arjun (arjun@openforce.net) + @author yon (yon@openforce.net) + @creation-date 2002-07-10 + @version $Id: site-node-apm-integration-procs.tcl,v 1.1 2002/07/25 18:46:52 rmello Exp $ + +} + +namespace eval site_node_apm_integration { + + ad_proc -public new_site_node_and_package { + {-name:required} + {-parent_id:required} + {-package_key:required} + {-instance_name:required} + {-context_id:required} + } { + create site node, instantiate package, mount package at new site node + } { + set node_id [site_node::new -name $name -parent_id $parent_id] + + set package_id [apm_package_create_instance $instance_name $context_id $package_key] + + site_node::mount -node_id $node_id -object_id $package_id + + site_node::update_cache -node_id $node_id + + # call post instantiation proc for the package + apm_package_call_post_instantiation_proc $package_id $package_key + + return $package_id + } + + ad_proc -public get_child_package_id { + {-package_id ""} + {-package_key:required} + } { + get the package_id of package_key that is mounted directly under + package_id. returns empty string if not found. + } { + if {[empty_string_p $package_id]} { + set package_id [ad_conn package_id] + } + + return [db_string select_child_package_id {} -default ""] + } + + ad_proc -public child_package_exists_p { + {-package_id ""} + {-package_key:required} + } { + Returns 1 if there exists a child package with the given package_key, + or 0 if not. + } { + set child_package_id [get_child_package_id \ + -package_id $package_id \ + -package_key $package_key + ] + + if {[empty_string_p $child_package_id]} { + return 0 + } else { + return 1 + } + } + +} Index: openacs.org-dev/packages/acs-tcl/tcl/site-node-apm-integration-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/acs-tcl/tcl/site-node-apm-integration-procs.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/acs-tcl/tcl/site-node-apm-integration-procs.xql 25 Jul 2002 18:46:52 -0000 1.1 @@ -0,0 +1,17 @@ + + + + + + select sn1.object_id + from site_nodes sn1, + apm_packages + where sn1.parent_id = (select sn2.node_id + from site_nodes sn2 + where sn2.object_id = :package_id) + and sn1.object_id = apm_packages.package_id + and apm_packages.package_key = :package_key + + + + Index: openacs.org-dev/packages/acs-templating/resources/forms/plainest.adp =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/acs-templating/resources/forms/plainest.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/acs-templating/resources/forms/plainest.adp 25 Jul 2002 18:46:52 -0000 1.1 @@ -0,0 +1,86 @@ + + + + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
@elements.section@
+ +
@elements.label@   + +
   +
+ + 		+ + + + + + + +
\@formgroup.widget@\@formgroup.label@
+
+ \@formerror.@elements.id@\@ + + + 		+ + + + + +
+ \@formerror.@elements.id@\@ + +
+ +

Index: openacs.org-dev/packages/acs-templating/tcl/file-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/acs-templating/tcl/file-procs.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/acs-templating/tcl/file-procs.tcl 25 Jul 2002 18:46:52 -0000 1.1 @@ -0,0 +1,42 @@ +# The new file type returns the list { file_name temp_file_name content_mime_type }. + +ad_proc -public template::data::transform::file { element_ref } { + + upvar $element_ref element + set element_id $element(id) + + # Work around Windows bullshit + set filename [ns_queryget $element_id] + + if { [string equal $filename ""] } { + return "" + } + + regsub -all {\\+} $filename {/} filename + regsub -all { +} $filename {_} filename + set filename [lindex [split $filename "/"] end] + return [list [list $filename [ns_queryget $element_id.tmpfile] [ns_queryget $element_id.content-type]]] + +} + +# Our file widget can't fail + +ad_proc -public template::data::validate::file { value_ref message_ref } { + return 1 +} + +ad_proc -public template::util::file::get_property { what file_list } { + + switch $what { + filename { + return [lindex $file_list 0] + } + tmp_filename { + return [lindex $file_list 1] + } + mime_type { + return [lindex $file_list 2] + } + } + +} Index: openacs.org-dev/packages/attachments/sql/postgresql/attachments-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/attachments/sql/postgresql/attachments-create.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/attachments/sql/postgresql/attachments-create.sql 25 Jul 2002 18:46:57 -0000 1.1 @@ -0,0 +1,46 @@ +-- +-- Copyright (C) 2001, 2002 OpenForce, Inc. +-- +-- this is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- this is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS +-- FOR A PARTICULAR PURPOSE. See the GNU General Public License for more +-- details. +-- + +-- +-- attachments +-- +-- @author arjun (arjun@openforce.net) +-- @version $Id: attachments-create.sql,v 1.1 2002/07/25 18:46:57 rmello Exp $ +-- + +create table attachments_fs_root_folder_map ( + package_id integer + constraint attach_fldr_map_package_id_fk + references apm_packages (package_id) + constraint attach_fldr_map_package_id_un + unique, + folder_id integer + constraint attach_fldr_map_folder_id_fk + references fs_root_folders (folder_id), + constraint attach_fldr_map_pk + primary key (package_id, folder_id) +); + +create table attachments ( + object_id integer + constraint attachments_object_id_fk + references acs_objects(object_id) + on delete cascade, + item_id integer + constraint attachments_item_id_fk + references acs_objects(object_id) + on delete cascade, + constraint attachments_pk + primary key (object_id, item_id) +); Index: openacs.org-dev/packages/attachments/sql/postgresql/attachments-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/attachments/sql/postgresql/attachments-drop.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/attachments/sql/postgresql/attachments-drop.sql 25 Jul 2002 18:46:57 -0000 1.1 @@ -0,0 +1,23 @@ +-- +-- Copyright (C) 2001, 2002 OpenForce, Inc. +-- +-- this is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- this is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS +-- FOR A PARTICULAR PURPOSE. See the GNU General Public License for more +-- details. +-- + +-- +-- attachments +-- +-- @author arjun (arjun@openforce.net) +-- @version $Id: attachments-drop.sql,v 1.1 2002/07/25 18:46:57 rmello Exp $ +-- + +drop table attachments; +drop table attachment_root_folders; Index: openacs.org-dev/packages/attachments/tcl/attachments-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/attachments/tcl/attachments-procs-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/attachments/tcl/attachments-procs-postgresql.xql 25 Jul 2002 18:46:57 -0000 1.1 @@ -0,0 +1,12 @@ + + +postgresql7.1 + + + +select item_id, acs_object__name(item_id) from attachments +where object_id= :object_id + + + + Index: openacs.org-dev/packages/calendar/tcl/cal-item-2-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/calendar/tcl/cal-item-2-procs.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/calendar/tcl/cal-item-2-procs.xql 25 Jul 2002 18:47:00 -0000 1.1 @@ -0,0 +1,27 @@ + + + + + + +update acs_events +set recurrence_id= :recurrence_id +where event_id= :cal_item_id + + + + + +insert into cal_items +(cal_item_id, on_which_calendar) +select +event_id, +(select on_which_calendar +as calendar_id from cal_items +where cal_item_id = :cal_item_id) +from acs_events where recurrence_id= :recurrence_id +and event_id <> :cal_item_id + + + + Index: openacs.org-dev/packages/faq/sql/postgresql/faq-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/faq/sql/postgresql/faq-create.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/faq/sql/postgresql/faq-create.sql 25 Jul 2002 18:47:14 -0000 1.1 @@ -0,0 +1,305 @@ +-- @jennie.ybos.net +-- @wirth.ybos.net +--openacs port @samir.symphinity.com + + +create function inline_0 () +returns integer as ' +begin + PERFORM acs_object_type__create_type ( + ''faq'', -- object_type + ''FAQ'', -- pretty_name + ''FAQs'', -- pretty_plural + ''acs_object'', -- supertype + ''FAQS'', -- table_name + ''FAQ_ID'', -- id_column + null, -- package_name + ''f'', -- abstract_p + null, -- type_extension_table + ''faq.name'' -- name_method + ); + + return 0; +end;' language 'plpgsql'; + +select inline_0 (); + +drop function inline_0 (); + + +create table faqs ( + faq_id integer constraint faqs_faq_id_fk + references acs_objects(object_id) + constraint faqs_pk + primary key, + faq_name varchar (250) + constraint faqs_faq_name_nn not null, + separate_p boolean check(separate_p in ('f','t')) +); + + +create function inline_1 () +returns integer as ' +begin + PERFORM acs_object_type__create_type ( + ''faq_q_and_a'', -- object_type + ''FAQ_Q_and_A'', -- pretty_name + ''FAQ_Q_and_As'', -- pretty_plural + ''acs_object'', -- supertype + ''FAQ_Q_AND_AS'', -- table_name + ''ENTRY_ID'', -- id_column + null, -- package_name + ''f'', -- abstract_p + null, -- type_extension_table + null -- name_method + ); + + return 0; +end;' language 'plpgsql'; + +select inline_1 (); + +drop function inline_1 (); + + +create table faq_q_and_as ( + entry_id integer constraint faq_q_and_as_entry_id_fk + references acs_objects (object_id) + constraint faq_q_sand_a_pk + primary key, + faq_id integer references faqs not null, + question varchar (4000) not null, + answer varchar (4000) not null, + -- determines the order of questions in a FAQ + sort_key integer not null +); + +create function faq__new_q_and_a (integer,integer,varchar,varchar,integer,varchar,timestamp,integer,varchar,integer + ) returns integer as +' +declare + p_entry_id alias for $1; -- default null, + p_faq_id alias for $2; + p_question alias for $3; + p_answer alias for $4; + p_sort_key alias for $5; + p_object_type alias for $6; -- default faq_q_and_a + p_creation_date alias for $7; --in acs_objects.creation_date%TYPE default sysdate, + p_creation_user alias for $8; --in acs_objects.creation_user%TYPE default null, + p_creation_ip alias for $9; -- in acs_objects.creation_ip%TYPE default null, + p_context_id alias for $10; --in acs_objects.context_id%TYPE default null + v_entry_id faq_q_and_as.entry_id%TYPE; +begin + v_entry_id := acs_object__new ( + p_entry_id, + p_object_type, + p_creation_date, + p_creation_user, + p_creation_ip, + p_context_id + ); + insert into faq_q_and_as + (entry_id, faq_id, question, answer, sort_key) + values + (v_entry_id, p_faq_id, p_question, p_answer, p_sort_key); + return v_entry_id; + +end;' language 'plpgsql'; + +create function faq__delete_q_and_a (integer) +returns integer as ' +declare + p_entry_id alias for $1; +begin + delete from faq_q_and_as where entry_id = p_entry_id; + raise NOTICE ''Deleting FAQ_Q_and_A...''; + PERFORM acs_object__delete(p_entry_id); + + return 0; + +end;' language 'plpgsql'; + + +create function faq__new_faq (integer, varchar, boolean,varchar,timestamp,integer,varchar,integer ) +returns integer as ' +declare + p_faq_id alias for $1; + p_faq_name alias for $2; + p_separate_p alias for $3; + p_object_type alias for $4; + p_creation_date alias for $5; + p_creation_user alias for $6; + p_creation_ip alias for $7; + p_context_id alias for $8; + v_faq_id faqs.faq_id%TYPE; +begin + + v_faq_id := acs_object__new ( + p_faq_id, + p_object_type, + p_creation_date, + p_creation_user, + p_creation_ip, + p_context_id + ); + + insert into faqs + (faq_id, faq_name,separate_p) + values + (v_faq_id, p_faq_name,p_separate_p); + +return v_faq_id; + +end;' language 'plpgsql'; + + +create function faq__delete_faq (integer) +returns integer as ' +declare + p_faq_id alias for $1; + del_rec record; +begin + -- Because q_and_as are objects, we need to + -- loop through a list of them, and call an explicit + -- delete function for each one. (i.e. each + -- entry_id) + for del_rec in select entry_id from faq_q_and_as + where faq_id = p_faq_id + loop + PERFORM faq__delete_q_and_a(del_rec.entry_id); + end loop; + + delete from faqs where faq_id = p_faq_id; + + PERFORM acs_object__delete(p_faq_id); + + return 0; + +end;' language 'plpgsql'; + +create function faq__name(integer) +returns varchar as ' +declare + p_faq_id alias for $1; + v_faq_name faqs.faq_name%TYPE; +begin + select faq_name into v_faq_name + from faqs + where faq_id = p_faq_id; + + return v_faq_name; +end; +' language 'plpgsql'; + +create function faq__clone (integer,integer) +returns integer as ' +declare + p_new_package_id alias for $1; --default null, + p_old_package_id alias for $2; --default null + v_faq_id faqs.faq_id%TYPE; + one_faq record; + entry record; + +begin + -- get all the faqs belonging to the old package, + -- and create new faqs for the new package + for one_faq in select * + from acs_objects o, faqs f + where o.object_id = f.faq_id + and o.context_id = p_old_package_id + loop + v_faq_id := faq__new_faq ( + one_faq.faq_name, + one_faq.separate_p, + p_new_package_id + ); + + for entry in select * from faq_q_and_as + where faq_id = one_faq.faq_id + loop + + perform faq__new_q_and_a ( + entry.faq_id, + v_faq_id, + entry.question, + entry.answer, + entry.sort_key + ); + end loop; + end loop; + return 0; + end; +' language 'plpgsql'; + + + + select acs_privilege__create_privilege('faq_view_faq'); + select acs_privilege__create_privilege('faq_create_faq'); + select acs_privilege__create_privilege('faq_delete_faq'); + select acs_privilege__create_privilege('faq_modify_faq'); + select acs_privilege__create_privilege('faq_view_q_and_a'); + select acs_privilege__create_privilege('faq_create_q_and_a'); + select acs_privilege__create_privilege('faq_delete_q_and_a'); + select acs_privilege__create_privilege('faq_modify_q_and_a'); + select acs_privilege__create_privilege('faq_admin_faq'); + select acs_privilege__create_privilege('faq_admin_q_and_a'); + select acs_privilege__add_child('faq_admin_faq', 'faq_view_faq'); + select acs_privilege__add_child('faq_admin_faq', 'faq_create_faq'); + select acs_privilege__add_child('faq_admin_faq', 'faq_delete_faq'); + select acs_privilege__add_child('faq_admin_faq', 'faq_modify_faq'); + select acs_privilege__add_child('faq_admin_q_and_a', 'faq_view_q_and_a'); + select acs_privilege__add_child('faq_admin_q_and_a', 'faq_create_q_and_a'); + select acs_privilege__add_child('faq_admin_q_and_a', 'faq_delete_q_and_a'); + select acs_privilege__add_child('faq_admin_q_and_a', 'faq_modify_q_and_a'); + select acs_privilege__add_child('faq_admin_faq', 'faq_admin_q_and_a'); + + -- bind privileges to global names + + select acs_privilege__add_child('create','faq_create_faq'); + select acs_privilege__add_child('create','faq_create_q_and_a'); + select acs_privilege__add_child('write','faq_modify_faq'); + select acs_privilege__add_child('write','faq_modify_q_and_a'); + select acs_privilege__add_child('read','faq_view_faq'); + select acs_privilege__add_child('read','faq_view_q_and_a'); + select acs_privilege__add_child('delete','faq_delete_faq'); + select acs_privilege__add_child('delete','faq_delete_q_and_a'); + select acs_privilege__add_child('admin','faq_admin_faq'); + + +create function inline_2 () +returns integer as ' +declare + default_context acs_objects.object_id%TYPE; + registered_users acs_objects.object_id%TYPE; + the_public acs_objects.object_id%TYPE; +begin + + default_context = acs__magic_object_id(''default_context''); + registered_users = acs__magic_object_id(''registered_users''); + the_public = acs__magic_object_id(''the_public''); + + -- give the public the power to view faqs by default + + PERFORM acs_permission__grant_permission (default_context, the_public, ''faq_view_faq''); + + + -- give the public the power to view q_and_as by default + + PERFORM acs_permission__grant_permission ( default_context,the_public, ''faq_view_q_and_a''); + + return 0; + +end;' language 'plpgsql'; + + +select inline_2 (); + +drop function inline_2 (); + + + + + + + + Index: openacs.org-dev/packages/faq/sql/postgresql/faq-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/faq/sql/postgresql/faq-drop.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/faq/sql/postgresql/faq-drop.sql 25 Jul 2002 18:47:14 -0000 1.1 @@ -0,0 +1,130 @@ +-- @author jennie@ybos.net +-- @author wirth@ybos.net +--openacs port @samir.symphinity.com + +--drop functions +drop function faq__new_q_and_a (integer,integer,varchar,varchar,integer,varchar,timestamp,integer,varchar,integer); +drop function faq__delete_q_and_a (integer); +drop function faq__new_faq (integer, varchar, boolean,varchar,timestamp,integer,varchar,integer ); +drop function faq__delete_faq (integer); +drop function faq__name (integer); +drop function faq__clone (integer,integer); + +--drop permissions +delete from acs_permissions where object_id in (select entry_id from faq_q_and_as); +delete from acs_permissions where object_id in (select faq_id from faqs); + + +create function inline_0() +returns integer as ' +declare + object_rec record; + default_context acs_objects.object_id%TYPE; + registered_users acs_objects.object_id%TYPE; + the_public acs_objects.object_id%TYPE; +begin + + + --drop objects + + for object_rec in select object_id from acs_objects where object_type=''faq'' + loop + PERFORM acs_object__delete( object_rec.object_id ); + end loop; + + for object_rec in select object_id from acs_objects where object_type=''faq_q_and_a'' + loop + PERFORM acs_object__delete( object_rec.object_id ); + end loop; + + + +-- bind privileges to global names + + default_context := acs__magic_object_id(''default_context''); + registered_users := acs__magic_object_id(''registered_users''); + the_public := acs__magic_object_id(''the_public''); + + -- revoke from the public the power to view faqs + + PERFORM acs_permission__revoke_permission (default_context, the_public, ''faq_view_faq''); + + + -- revoke from the public the power to view q_and_as + + PERFORM acs_permission__revoke_permission ( default_context,the_public, ''faq_view_q_and_a''); + + + +--drop permissions + PERFORM acs_privilege__remove_child(''create'',''faq_create_faq''); + PERFORM acs_privilege__remove_child(''create'',''faq_create_q_and_a''); + PERFORM acs_privilege__remove_child(''write'',''faq_modify_faq''); + PERFORM acs_privilege__remove_child(''write'',''faq_modify_q_and_a''); + PERFORM acs_privilege__remove_child(''read'',''faq_view_faq''); + PERFORM acs_privilege__remove_child(''read'',''faq_view_q_and_a''); + PERFORM acs_privilege__remove_child(''delete'',''faq_delete_faq''); + PERFORM acs_privilege__remove_child(''delete'',''faq_delete_q_and_a''); + PERFORM acs_privilege__remove_child(''admin'',''faq_admin_faq''); + + PERFORM acs_privilege__remove_child(''faq_admin_faq'', ''faq_view_faq''); + PERFORM acs_privilege__remove_child(''faq_admin_faq'', ''faq_create_faq''); + PERFORM acs_privilege__remove_child(''faq_admin_faq'', ''faq_delete_faq''); + PERFORM acs_privilege__remove_child(''faq_admin_faq'', ''faq_modify_faq''); + PERFORM acs_privilege__remove_child(''faq_admin_q_and_a'', ''faq_view_q_and_a''); + PERFORM acs_privilege__remove_child(''faq_admin_q_and_a'', ''faq_create_q_and_a''); + PERFORM acs_privilege__remove_child(''faq_admin_q_and_a'', ''faq_delete_q_and_a''); + PERFORM acs_privilege__remove_child(''faq_admin_q_and_a'', ''faq_modify_q_and_a''); + PERFORM acs_privilege__remove_child(''faq_admin_faq'', ''faq_admin_q_and_a''); + + PERFORM acs_privilege__drop_privilege(''faq_view_faq''); + PERFORM acs_privilege__drop_privilege(''faq_create_faq''); + PERFORM acs_privilege__drop_privilege(''faq_delete_faq''); + PERFORM acs_privilege__drop_privilege(''faq_modify_faq''); + PERFORM acs_privilege__drop_privilege(''faq_view_q_and_a''); + PERFORM acs_privilege__drop_privilege(''faq_create_q_and_a''); + PERFORM acs_privilege__drop_privilege(''faq_delete_q_and_a''); + PERFORM acs_privilege__drop_privilege(''faq_modify_q_and_a''); + PERFORM acs_privilege__drop_privilege(''faq_admin_faq''); + PERFORM acs_privilege__drop_privilege(''faq_admin_q_and_a''); + + return 0; +end;' language 'plpgsql'; + +select inline_0(); + +drop function inline_0(); + + + +--drop table +drop table faq_q_and_as; +drop table faqs; + + +--drop type +select acs_object_type__drop_type( + 'faq', + 't' + ); +select acs_object_type__drop_type( + 'faq_q_and_a', + 't' + ); + + + + + + + + + + + + + + + + + Index: openacs.org-dev/packages/faq/www/admin/faq-delete-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/faq/www/admin/faq-delete-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/faq/www/admin/faq-delete-postgresql.xql 25 Jul 2002 18:47:14 -0000 1.1 @@ -0,0 +1,13 @@ + + + + postgresql7.1 + + + + select faq__delete_faq (:faq_id); + + + + + Index: openacs.org-dev/packages/faq/www/admin/faq-new-2-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/faq/www/admin/faq-new-2-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/faq/www/admin/faq-new-2-postgresql.xql 25 Jul 2002 18:47:14 -0000 1.1 @@ -0,0 +1,13 @@ + + + + postgresql7.1 + + + + select faq__new_faq (:faq_id, :faq_name,:separate_p,'faq', now(), :user_id,:creation_ip,:package_id); + + + + + Index: openacs.org-dev/packages/faq/www/admin/q_and_a-delete-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/faq/www/admin/q_and_a-delete-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/faq/www/admin/q_and_a-delete-postgresql.xql 25 Jul 2002 18:47:14 -0000 1.1 @@ -0,0 +1,12 @@ + + + + postgresql7.1 + + + + select faq__delete_q_and_a (:entry_id ); + + + + Index: openacs.org-dev/packages/faq/www/admin/q_and_a-new-2-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/faq/www/admin/q_and_a-new-2-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/faq/www/admin/q_and_a-new-2-postgresql.xql 25 Jul 2002 18:47:14 -0000 1.1 @@ -0,0 +1,24 @@ + + + + postgresql7.1 + + + + select faq__new_q_and_a ( + :entry_id, + :faq_id, + :question, + :answer, + :sort_key, + 'faq_q_and_a', + now(), + :user_id, + :creation_ip, + :faq_id + ); + + + + + Index: openacs.org-dev/packages/forums/sql/postgresql/fns.patch =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/forums/sql/postgresql/fns.patch,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs.org-dev/packages/forums/sql/postgresql/fns.patch 25 Jul 2002 18:47:15 -0000 1.1 @@ -0,0 +1,115 @@ +--- forums-notifications-sanitize.sql Wed Jul 10 14:04:49 2002 ++++ forums-notifications-sanitize.sql.new Wed Jul 10 14:26:30 2002 +@@ -25,3 +25,112 @@ + + select inline_0(); + drop function inline_0 (); ++ ++-- ++-- Service contract drop stuff was missing - Roberto Mello ++-- ++ ++create function inline_0() returns integer as ' ++declare ++ impl_id integer; ++ v_foo integer; ++begin ++ ++ -- the notification type impl ++ impl_id := acs_sc_impl__get_id ( ++ ''NotificationType'', -- impl_contract_name ++ ''forums_forum_notif_type'' -- impl_name ++ ); ++ ++ PERFORM acs_sc_binding__delete ( ++ ''NotificationType'', ++ ''forums_forum_notif_type'' ++ ); ++ ++ v_foo := acs_sc_impl_alias__delete ( ++ ''NotificationType'', -- impl_contract_name ++ ''forums_forum_notif_type'', -- impl_name ++ ''GetURL'' -- impl_operation_name ++ ); ++ ++ v_foo := acs_sc_impl_alias__delete ( ++ ''NotificationType'', -- impl_contract_name ++ ''forums_forum_notif_type'', -- impl_name ++ ''ProcessReply'' -- impl_operation_name ++ ); ++ ++ select into v_foo type_id ++ from notification_types ++ where sc_impl_id = impl_id ++ and short_name = ''forums_forum_notif''; ++ ++ perform notification_type__delete (v_foo); ++ ++ delete from notification_types_intervals ++ where type_id = v_foo ++ and interval_id in ( ++ select interval_id ++ from notification_intervals ++ where name in (''instant'',''hourly'',''daily'') ++ ); ++ ++ delete from notification_types_del_methods ++ where type_id = v_foo ++ and delivery_method_id in ( ++ select delivery_method_id ++ from notification_delivery_methods ++ where short_name in (''email'') ++ ); ++ ++ -- the notification type impl ++ impl_id := acs_sc_impl__get_id ( ++ ''NotificationType'', ++ ''forums_message_notif_type'' ++ ); ++ ++ PERFORM acs_sc_binding__delete ( ++ ''NotificationType'', ++ ''forums_message_notif_type'' ++ ); ++ ++ v_foo := acs_sc_impl_alias__delete ( ++ ''NotificationType'', ++ ''forums_message_notif_type'', ++ ''GetURL'' ++ ); ++ ++ v_foo := acs_sc_impl_alias__delete ( ++ ''NotificationType'', ++ ''forums_message_notif_type'', ++ ''ProcessReply'' ++ ); ++ ++ select into v_foo type_id ++ from notification_types ++ where sc_impl_id = impl_id ++ and short_name = ''forums_message_notif''; ++ ++ perform notification_type__delete (v_foo); ++ ++ delete from notification_types_intervals ++ where type_id = v_foo ++ and interval_id in ( ++ select interval_id ++ from notification_intervals ++ where name in (''instant'',''hourly'',''daily'') ++ ); ++ ++ delete from notification_types_del_methods ++ where type_id = v_foo ++ and delivery_method_id in ( ++ select delivery_method_id ++ from notification_delivery_methods ++ where short_name in (''email'') ++ ); ++ ++ return (0); ++end; ++' language 'plpgsql'; ++ ++select inline_0(); ++drop function inline_0();