Menu
▾
▴
[xoops-svn] SF.net SVN: xoops-svn:[11122] XoopsModules
|
From: <be...@us...> - 2013-03-01 03:29:23
|
Revision: 11122
http://sourceforge.net/p/xoops/svn/11122
Author: beckmi
Date: 2013-03-01 03:29:11 +0000 (Fri, 01 Mar 2013)
Log Message:
-----------
Adding DMS module
Added Paths:
-----------
XoopsModules/dms/
XoopsModules/dms/branches/
XoopsModules/dms/releases/
XoopsModules/dms/trunk/
XoopsModules/dms/trunk/dms/
XoopsModules/dms/trunk/dms/admin/
XoopsModules/dms/trunk/dms/admin/inc_admin_functions.php
XoopsModules/dms/trunk/dms/admin/inc_update_manager.php
XoopsModules/dms/trunk/dms/admin/index.php
XoopsModules/dms/trunk/dms/admin/menu.php
XoopsModules/dms/trunk/dms/admin/update_manager.php
XoopsModules/dms/trunk/dms/admin/update_manager_config.php
XoopsModules/dms/trunk/dms/admin/update_manager_slct_release.php
XoopsModules/dms/trunk/dms/admin/update_manager_slct_root_dir.php
XoopsModules/dms/trunk/dms/admin/write_js_config.php
XoopsModules/dms/trunk/dms/audit_log_detail.php
XoopsModules/dms/trunk/dms/audit_log_obj.php
XoopsModules/dms/trunk/dms/audit_log_select_user.php
XoopsModules/dms/trunk/dms/audit_log_user.php
XoopsModules/dms/trunk/dms/blocks/
XoopsModules/dms/trunk/dms/blocks/dms_block_doc_history.php
XoopsModules/dms/trunk/dms/change_log.txt
XoopsModules/dms/trunk/dms/config_doc_templates_slct_root_dir.php
XoopsModules/dms/trunk/dms/config_help_system.php
XoopsModules/dms/trunk/dms/config_main.php
XoopsModules/dms/trunk/dms/config_repo.php
XoopsModules/dms/trunk/dms/config_write_js_config.php
XoopsModules/dms/trunk/dms/config_write_swishe_config.php
XoopsModules/dms/trunk/dms/database_descript.txt
XoopsModules/dms/trunk/dms/dms.webprj
XoopsModules/dms/trunk/dms/documentation/
XoopsModules/dms/trunk/dms/file_batch_import.php
XoopsModules/dms/trunk/dms/file_checkin.php
XoopsModules/dms/trunk/dms/file_checkout.php
XoopsModules/dms/trunk/dms/file_checkout_cancel.php
XoopsModules/dms/trunk/dms/file_copy.php
XoopsModules/dms/trunk/dms/file_dir_import.php
XoopsModules/dms/trunk/dms/file_email.php
XoopsModules/dms/trunk/dms/file_import.php
XoopsModules/dms/trunk/dms/file_move.php
XoopsModules/dms/trunk/dms/file_new.php
XoopsModules/dms/trunk/dms/file_options.php
XoopsModules/dms/trunk/dms/file_recall.php
XoopsModules/dms/trunk/dms/file_restore.php
XoopsModules/dms/trunk/dms/file_retrieve.php
XoopsModules/dms/trunk/dms/file_retrieve_extern.php
XoopsModules/dms/trunk/dms/file_revert.php
XoopsModules/dms/trunk/dms/file_route.php
XoopsModules/dms/trunk/dms/file_subscription.php
XoopsModules/dms/trunk/dms/folder_archive.php
XoopsModules/dms/trunk/dms/folder_close_all.php
XoopsModules/dms/trunk/dms/folder_config_change.php
XoopsModules/dms/trunk/dms/folder_content_report.php
XoopsModules/dms/trunk/dms/folder_contract.php
XoopsModules/dms/trunk/dms/folder_copy.php
XoopsModules/dms/trunk/dms/folder_expand.php
XoopsModules/dms/trunk/dms/folder_move.php
XoopsModules/dms/trunk/dms/folder_new.php
XoopsModules/dms/trunk/dms/folder_options.php
XoopsModules/dms/trunk/dms/folder_prop_perms.php
XoopsModules/dms/trunk/dms/folder_restore.php
XoopsModules/dms/trunk/dms/group_editor.php
XoopsModules/dms/trunk/dms/images/
XoopsModules/dms/trunk/dms/images/1uparrow.png
XoopsModules/dms/trunk/dms/images/admin.gif
XoopsModules/dms/trunk/dms/images/admin.png
XoopsModules/dms/trunk/dms/images/arrow_lt.png
XoopsModules/dms/trunk/dms/images/arrow_lt_begin.png
XoopsModules/dms/trunk/dms/images/arrow_rt.png
XoopsModules/dms/trunk/dms/images/arrow_top.png
XoopsModules/dms/trunk/dms/images/controls/
XoopsModules/dms/trunk/dms/images/create.xcf
XoopsModules/dms/trunk/dms/images/doc_types/
XoopsModules/dms/trunk/dms/images/doc_types/applix.png
XoopsModules/dms/trunk/dms/images/doc_types/ascii.png
XoopsModules/dms/trunk/dms/images/doc_types/binary.png
XoopsModules/dms/trunk/dms/images/doc_types/cdbo_list.png
XoopsModules/dms/trunk/dms/images/doc_types/cdimage.png
XoopsModules/dms/trunk/dms/images/doc_types/cdtrack.png
XoopsModules/dms/trunk/dms/images/doc_types/colorscm.png
XoopsModules/dms/trunk/dms/images/doc_types/colorset.png
XoopsModules/dms/trunk/dms/images/doc_types/core.png
XoopsModules/dms/trunk/dms/images/doc_types/deb.png
XoopsModules/dms/trunk/dms/images/doc_types/doc.png
XoopsModules/dms/trunk/dms/images/doc_types/document.png
XoopsModules/dms/trunk/dms/images/doc_types/document2.png
XoopsModules/dms/trunk/dms/images/doc_types/dvi.png
XoopsModules/dms/trunk/dms/images/doc_types/empty.png
XoopsModules/dms/trunk/dms/images/doc_types/empty2.png
XoopsModules/dms/trunk/dms/images/doc_types/empty_ascii.png
XoopsModules/dms/trunk/dms/images/doc_types/encrypted.png
XoopsModules/dms/trunk/dms/images/doc_types/exec_wine.png
XoopsModules/dms/trunk/dms/images/doc_types/file_locked.png
XoopsModules/dms/trunk/dms/images/doc_types/file_temporary.png
XoopsModules/dms/trunk/dms/images/doc_types/font.png
XoopsModules/dms/trunk/dms/images/doc_types/font_bitmap.png
XoopsModules/dms/trunk/dms/images/doc_types/font_truetype.png
XoopsModules/dms/trunk/dms/images/doc_types/font_type1.png
XoopsModules/dms/trunk/dms/images/doc_types/gf.png
XoopsModules/dms/trunk/dms/images/doc_types/html.png
XoopsModules/dms/trunk/dms/images/doc_types/image.png
XoopsModules/dms/trunk/dms/images/doc_types/image2.png
XoopsModules/dms/trunk/dms/images/doc_types/images.png
XoopsModules/dms/trunk/dms/images/doc_types/info.png
XoopsModules/dms/trunk/dms/images/doc_types/java_src.png
XoopsModules/dms/trunk/dms/images/doc_types/karbon.png
XoopsModules/dms/trunk/dms/images/doc_types/kmultiple.png
XoopsModules/dms/trunk/dms/images/doc_types/kugardata.png
XoopsModules/dms/trunk/dms/images/doc_types/log.png
XoopsModules/dms/trunk/dms/images/doc_types/make.png
XoopsModules/dms/trunk/dms/images/doc_types/man.png
XoopsModules/dms/trunk/dms/images/doc_types/message.png
XoopsModules/dms/trunk/dms/images/doc_types/metafont.png
XoopsModules/dms/trunk/dms/images/doc_types/midi.png
XoopsModules/dms/trunk/dms/images/doc_types/mime-cdr.png
XoopsModules/dms/trunk/dms/images/doc_types/mime-colorset.png
XoopsModules/dms/trunk/dms/images/doc_types/mime-postscript.png
XoopsModules/dms/trunk/dms/images/doc_types/mime-resource.png
XoopsModules/dms/trunk/dms/images/doc_types/mime-template_source.png
XoopsModules/dms/trunk/dms/images/doc_types/mime.png
XoopsModules/dms/trunk/dms/images/doc_types/mime_ascii.png
XoopsModules/dms/trunk/dms/images/doc_types/mime_empty.png
XoopsModules/dms/trunk/dms/images/doc_types/mime_koffice.png
XoopsModules/dms/trunk/dms/images/doc_types/mozilla_doc.png
XoopsModules/dms/trunk/dms/images/doc_types/netscape.png
XoopsModules/dms/trunk/dms/images/doc_types/netscape_doc.png
XoopsModules/dms/trunk/dms/images/doc_types/pdf-document.png
XoopsModules/dms/trunk/dms/images/doc_types/pdf.png
XoopsModules/dms/trunk/dms/images/doc_types/php.png
XoopsModules/dms/trunk/dms/images/doc_types/pk.png
XoopsModules/dms/trunk/dms/images/doc_types/postscript.png
XoopsModules/dms/trunk/dms/images/doc_types/ps.png
XoopsModules/dms/trunk/dms/images/doc_types/quicktime.png
XoopsModules/dms/trunk/dms/images/doc_types/readme.png
XoopsModules/dms/trunk/dms/images/doc_types/real.png
XoopsModules/dms/trunk/dms/images/doc_types/real_doc.png
XoopsModules/dms/trunk/dms/images/doc_types/recycled.png
XoopsModules/dms/trunk/dms/images/doc_types/rpm.png
XoopsModules/dms/trunk/dms/images/doc_types/shellscript.png
XoopsModules/dms/trunk/dms/images/doc_types/soffice.png
XoopsModules/dms/trunk/dms/images/doc_types/sound.png
XoopsModules/dms/trunk/dms/images/doc_types/source.png
XoopsModules/dms/trunk/dms/images/doc_types/source_c.png
XoopsModules/dms/trunk/dms/images/doc_types/source_cpp.png
XoopsModules/dms/trunk/dms/images/doc_types/source_f.png
XoopsModules/dms/trunk/dms/images/doc_types/source_h.png
XoopsModules/dms/trunk/dms/images/doc_types/source_j.png
XoopsModules/dms/trunk/dms/images/doc_types/source_java.png
XoopsModules/dms/trunk/dms/images/doc_types/source_l.png
XoopsModules/dms/trunk/dms/images/doc_types/source_moc.png
XoopsModules/dms/trunk/dms/images/doc_types/source_o.png
XoopsModules/dms/trunk/dms/images/doc_types/source_p.png
XoopsModules/dms/trunk/dms/images/doc_types/source_pl.png
XoopsModules/dms/trunk/dms/images/doc_types/source_py.png
XoopsModules/dms/trunk/dms/images/doc_types/source_s.png
XoopsModules/dms/trunk/dms/images/doc_types/source_y.png
XoopsModules/dms/trunk/dms/images/doc_types/spreadsheet.png
XoopsModules/dms/trunk/dms/images/doc_types/tar.png
XoopsModules/dms/trunk/dms/images/doc_types/tex.png
XoopsModules/dms/trunk/dms/images/doc_types/tgz.png
XoopsModules/dms/trunk/dms/images/doc_types/trash.png
XoopsModules/dms/trunk/dms/images/doc_types/txt.png
XoopsModules/dms/trunk/dms/images/doc_types/txt2.png
XoopsModules/dms/trunk/dms/images/doc_types/unknown.png
XoopsModules/dms/trunk/dms/images/doc_types/vcalendar.png
XoopsModules/dms/trunk/dms/images/doc_types/vcard.png
XoopsModules/dms/trunk/dms/images/doc_types/vectorgfx.png
XoopsModules/dms/trunk/dms/images/doc_types/video.png
XoopsModules/dms/trunk/dms/images/doc_types/widget_doc.png
XoopsModules/dms/trunk/dms/images/doc_types/wordprocessing.png
XoopsModules/dms/trunk/dms/images/doc_types/zip.png
XoopsModules/dms/trunk/dms/images/file.png
XoopsModules/dms/trunk/dms/images/file_deleted.gif
XoopsModules/dms/trunk/dms/images/file_deleted.png
XoopsModules/dms/trunk/dms/images/file_import.gif
XoopsModules/dms/trunk/dms/images/file_import.png
XoopsModules/dms/trunk/dms/images/file_import.xcf
XoopsModules/dms/trunk/dms/images/file_link.gif
XoopsModules/dms/trunk/dms/images/file_link.png
XoopsModules/dms/trunk/dms/images/file_link.xcf
XoopsModules/dms/trunk/dms/images/file_link_locked.gif
XoopsModules/dms/trunk/dms/images/file_link_locked.png
XoopsModules/dms/trunk/dms/images/file_locked.png
XoopsModules/dms/trunk/dms/images/file_new.gif
XoopsModules/dms/trunk/dms/images/file_new.png
XoopsModules/dms/trunk/dms/images/file_text.gif
XoopsModules/dms/trunk/dms/images/file_text.png
XoopsModules/dms/trunk/dms/images/file_text_locked.gif
XoopsModules/dms/trunk/dms/images/file_text_locked.png
XoopsModules/dms/trunk/dms/images/file_text_locked.xcf
XoopsModules/dms/trunk/dms/images/file_unlocked.png
XoopsModules/dms/trunk/dms/images/folder_close_all.png
XoopsModules/dms/trunk/dms/images/folder_close_all.xcf
XoopsModules/dms/trunk/dms/images/folder_closed.gif
XoopsModules/dms/trunk/dms/images/folder_closed.png
XoopsModules/dms/trunk/dms/images/folder_create.gif
XoopsModules/dms/trunk/dms/images/folder_create.png
XoopsModules/dms/trunk/dms/images/folder_del_closed.gif
XoopsModules/dms/trunk/dms/images/folder_del_closed.png
XoopsModules/dms/trunk/dms/images/folder_del_open.gif
XoopsModules/dms/trunk/dms/images/folder_del_open.png
XoopsModules/dms/trunk/dms/images/folder_open.gif
XoopsModules/dms/trunk/dms/images/folder_open.png
XoopsModules/dms/trunk/dms/images/graph_end.png
XoopsModules/dms/trunk/dms/images/graph_green.png
XoopsModules/dms/trunk/dms/images/graph_grey.png
XoopsModules/dms/trunk/dms/images/graph_red.png
XoopsModules/dms/trunk/dms/images/graph_yellow.png
XoopsModules/dms/trunk/dms/images/help.gif
XoopsModules/dms/trunk/dms/images/help.xcf
XoopsModules/dms/trunk/dms/images/help3.xcf
XoopsModules/dms/trunk/dms/images/inbox_empty.gif
XoopsModules/dms/trunk/dms/images/inbox_empty.png
XoopsModules/dms/trunk/dms/images/inbox_full.gif
XoopsModules/dms/trunk/dms/images/inbox_full.png
XoopsModules/dms/trunk/dms/images/index.html
XoopsModules/dms/trunk/dms/images/line.gif
XoopsModules/dms/trunk/dms/images/line.png
XoopsModules/dms/trunk/dms/images/lockoverlay.png
XoopsModules/dms/trunk/dms/images/logo.png
XoopsModules/dms/trunk/dms/images/logo.xcf
XoopsModules/dms/trunk/dms/images/menu/
XoopsModules/dms/trunk/dms/images/menu/batch_import.gif
XoopsModules/dms/trunk/dms/images/menu/configure.gif
XoopsModules/dms/trunk/dms/images/menu/filefind.gif
XoopsModules/dms/trunk/dms/images/menu/fileimport.gif
XoopsModules/dms/trunk/dms/images/menu/filenew.gif
XoopsModules/dms/trunk/dms/images/menu/foldernew.gif
XoopsModules/dms/trunk/dms/images/menu/kmultiple.png
XoopsModules/dms/trunk/dms/images/menu/mail_send.png
XoopsModules/dms/trunk/dms/images/menu/overlay_import.gif
XoopsModules/dms/trunk/dms/images/menu/overlay_new.png
XoopsModules/dms/trunk/dms/images/menu/www.gif
XoopsModules/dms/trunk/dms/images/refresh.gif
XoopsModules/dms/trunk/dms/images/refresh.png
XoopsModules/dms/trunk/dms/images/search.gif
XoopsModules/dms/trunk/dms/images/search.png
XoopsModules/dms/trunk/dms/images/sm_arrow_lt.gif
XoopsModules/dms/trunk/dms/images/sm_arrow_rt.gif
XoopsModules/dms/trunk/dms/images/sm_arrow_rt.xcf
XoopsModules/dms/trunk/dms/images/uparrow.xcf
XoopsModules/dms/trunk/dms/images/www.png
XoopsModules/dms/trunk/dms/images/www_add.gif
XoopsModules/dms/trunk/dms/images/www_add.xcf
XoopsModules/dms/trunk/dms/images/www_open.gif
XoopsModules/dms/trunk/dms/images/www_open.png
XoopsModules/dms/trunk/dms/inc_adn_system.php
XoopsModules/dms/trunk/dms/inc_adv_system.php
XoopsModules/dms/trunk/dms/inc_class_dms_groups.php
XoopsModules/dms/trunk/dms/inc_current_version.php
XoopsModules/dms/trunk/dms/inc_defines.php
XoopsModules/dms/trunk/dms/inc_dest_path_and_file.php
XoopsModules/dms/trunk/dms/inc_dms_functions.php
XoopsModules/dms/trunk/dms/inc_extern_dmsdb_access.php
XoopsModules/dms/trunk/dms/inc_file_copy.php
XoopsModules/dms/trunk/dms/inc_file_properties.php
XoopsModules/dms/trunk/dms/inc_file_select.php
XoopsModules/dms/trunk/dms/inc_file_upload.php
XoopsModules/dms/trunk/dms/inc_folder_select.php
XoopsModules/dms/trunk/dms/inc_job_server_functions.php
XoopsModules/dms/trunk/dms/inc_lifecycle_functions.php
XoopsModules/dms/trunk/dms/inc_main_ui_2.php
XoopsModules/dms/trunk/dms/inc_message_box.php
XoopsModules/dms/trunk/dms/inc_notify_set.php
XoopsModules/dms/trunk/dms/inc_pal.php
XoopsModules/dms/trunk/dms/inc_pal_xoops.php
XoopsModules/dms/trunk/dms/inc_perms_set.php
XoopsModules/dms/trunk/dms/inc_search_x.php
XoopsModules/dms/trunk/dms/inc_write_js_config.php
XoopsModules/dms/trunk/dms/index.php
XoopsModules/dms/trunk/dms/job_server.php
XoopsModules/dms/trunk/dms/job_server_config.php
XoopsModules/dms/trunk/dms/job_server_manager.php
XoopsModules/dms/trunk/dms/language/
XoopsModules/dms/trunk/dms/language/english/
XoopsModules/dms/trunk/dms/language/english/index.html
XoopsModules/dms/trunk/dms/language/english/main.php
XoopsModules/dms/trunk/dms/language/english/modinfo.php
XoopsModules/dms/trunk/dms/language/english/~main.php
XoopsModules/dms/trunk/dms/language/french/
XoopsModules/dms/trunk/dms/language/french/index.html
XoopsModules/dms/trunk/dms/language/french/main.php
XoopsModules/dms/trunk/dms/language/french/modinfo.php
XoopsModules/dms/trunk/dms/language/portugues.do.brasil/
XoopsModules/dms/trunk/dms/language/portugues.do.brasil/index.html
XoopsModules/dms/trunk/dms/language/portugues.do.brasil/main.php
XoopsModules/dms/trunk/dms/language/portugues.do.brasil/modinfo.php
XoopsModules/dms/trunk/dms/layersmenu.js
XoopsModules/dms/trunk/dms/lifecycle_apply.php
XoopsModules/dms/trunk/dms/lifecycle_demote.php
XoopsModules/dms/trunk/dms/lifecycle_editor.php
XoopsModules/dms/trunk/dms/lifecycle_manager.php
XoopsModules/dms/trunk/dms/lifecycle_promote.php
XoopsModules/dms/trunk/dms/lifecycle_stage_editor.php
XoopsModules/dms/trunk/dms/link_move.php
XoopsModules/dms/trunk/dms/link_options.php
XoopsModules/dms/trunk/dms/mms_create_1.php
XoopsModules/dms/trunk/dms/mms_create_2.php
XoopsModules/dms/trunk/dms/mms_create_3.php
XoopsModules/dms/trunk/dms/mms_viewedit.php
XoopsModules/dms/trunk/dms/obj_delete.php
XoopsModules/dms/trunk/dms/obj_restore.php
XoopsModules/dms/trunk/dms/perms_editor.php
XoopsModules/dms/trunk/dms/perms_manager.php
XoopsModules/dms/trunk/dms/published/
XoopsModules/dms/trunk/dms/published/external/
XoopsModules/dms/trunk/dms/published/internal/
XoopsModules/dms/trunk/dms/readme.txt
XoopsModules/dms/trunk/dms/repository/
XoopsModules/dms/trunk/dms/search_ft.php
XoopsModules/dms/trunk/dms/search_prop.php
XoopsModules/dms/trunk/dms/sql/
XoopsModules/dms/trunk/dms/sql/index.html
XoopsModules/dms/trunk/dms/sql/mysql.sql
XoopsModules/dms/trunk/dms/statistics.php
XoopsModules/dms/trunk/dms/temp/
XoopsModules/dms/trunk/dms/templates/
XoopsModules/dms/trunk/dms/templates/blocks/
XoopsModules/dms/trunk/dms/templates/blocks/dms_block_history.html
XoopsModules/dms/trunk/dms/url_add.php
XoopsModules/dms/trunk/dms/url_options.php
XoopsModules/dms/trunk/dms/xoops_version.php
Added: XoopsModules/dms/trunk/dms/admin/inc_admin_functions.php
===================================================================
--- XoopsModules/dms/trunk/dms/admin/inc_admin_functions.php (rev 0)
+++ XoopsModules/dms/trunk/dms/admin/inc_admin_functions.php 2013-03-01 03:29:11 UTC (rev 11122)
@@ -0,0 +1,46 @@
+<?php
+// ------------------------------------------------------------------------ //
+// Document Management System //
+// Written By: Brian E. Reifsnyder //
+// Copyright 6/24/2003 //
+// ------------------------------------------------------------------------- //
+// 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. //
+// //
+// You may not change or alter any portion of this comment or credits //
+// of supporting developers from this source code or any supporting //
+// source code which is considered copyrighted (c) material of the //
+// original comment or credit authors. //
+// //
+// 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 //
+// ------------------------------------------------------------------------ //
+
+// DMS Admin Functions
+// inc_admin_functions.php
+
+// NOTE: When releasing a new version with the version number > 0.98, both the version and time_stamp
+// need to be updated!!!!
+
+include_once (XOOPS_ROOT_PATH."/modules/dms/inc_pal.php");
+
+function dms_update_time_stamp()
+{
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='".time()."' ";
+ $query .= "WHERE name='time_stamp'";
+ $dmsdb->query($query);
+}
+
+
+?>
Added: XoopsModules/dms/trunk/dms/admin/inc_update_manager.php
===================================================================
--- XoopsModules/dms/trunk/dms/admin/inc_update_manager.php (rev 0)
+++ XoopsModules/dms/trunk/dms/admin/inc_update_manager.php 2013-03-01 03:29:11 UTC (rev 11122)
@@ -0,0 +1,811 @@
+<?php
+// ------------------------------------------------------------------------ //
+// Document Management System //
+// Written By: Brian E. Reifsnyder //
+// Copyright 6/24/2003 //
+// ------------------------------------------------------------------------- //
+// 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. //
+// //
+// You may not change or alter any portion of this comment or credits //
+// of supporting developers from this source code or any supporting //
+// source code which is considered copyrighted (c) material of the //
+// original comment or credit authors. //
+// //
+// 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 //
+// ------------------------------------------------------------------------ //
+
+// DMS Functions
+// inc_upgrade_manager.php
+
+function dms_update_tables($old_version,$current_version)
+ {
+ while($old_version != $current_version)
+ {
+ if ($old_version==0.94) dms_update_0094();
+ if ($old_version==0.95) dms_update_0095();
+ if ($old_version==0.96) dms_update_0096();
+ if ($old_version==0.97) dms_update_0097();
+ if ($old_version==0.98) dms_update_0098();
+ if ($old_version==0.99) dms_update_0099();
+ if ($old_version==1.00) dms_update_0100();
+ if ($old_version==1.10) dms_update_0110();
+ if ($old_version==1.20) dms_update_0120();
+ if ($old_version==1.30) dms_update_0130();
+ if ($old_version==1.31) dms_update_0131();
+ if ($old_version==1.40) dms_update_0140();
+ if ($old_version==1.50) dms_update_0150();
+ if ($old_version==1.60) dms_update_0160();
+ if ($old_version==1.70) dms_update_0170();
+ if ($old_version==1.80) dms_update_0180();
+ if ($old_version==1.81) dms_update_0181();
+ if ($old_version==1.82) dms_update_0182();
+ if ($old_version==1.83) dms_update_0183();
+ if ($old_version==1.84) dms_update_0184();
+ if ($old_version==1.85) dms_update_0185();
+ if ($old_version==1.86) dms_update_0186();
+ if ($old_version==1.87) dms_update_0187();
+ if ($old_version==1.88) dms_update_0188();
+ if ($old_version==1.89) dms_update_0189();
+ if ($old_version==1.90) dms_update_0190();
+ $old_version = dms_get_old_version();
+ }
+ return;
+ }
+
+// This function must remain because the update system requires a separate method of returning the version.
+function dms_get_old_version()
+ {
+ global $dmsdb;
+
+ $query = 'SELECT data FROM '.$dmsdb->prefix("dms_config")." WHERE name='version'";
+ $old_version = $dmsdb->query($query,'data');
+
+ // If no version is found, assume version 0.94
+ if ($old_version =="") $old_version = 0.94;
+ return($old_version);
+ }
+
+function dms_update_0094()
+ {
+ global $dmsdb;
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('version','0.95')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('class_content','')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('class_header','even')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('class_subheader','even')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('class_narrow_header','head')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('class_narrow_content','odd')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('anon_user_id','0')";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0095()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='0.96' WHERE name='version'";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0096()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='0.97' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_objects")." ";
+ $query .= "ADD COLUMN time_stamp_delete varchar(12) not null default '0' AFTER time_stamp";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_objects")." ";
+ $query .= "CHANGE time_stamp time_stamp_create varchar(12) not null default '0'";
+ $dmsdb->query($query);
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_objects")." ";
+ $query .= "SET time_stamp_delete='".time()."' ";
+ $query .= "where obj_status='2'";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_object_versions")." ";
+ $query .= "CHANGE time_stamp time_stamp varchar(12) not null default '0'";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_routing_data")." ";
+ $query .= "CHANGE time_stamp time_stamp varchar(12) not null default '0'";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_audit_log")." ";
+ $query .= "CHANGE time_stamp time_stamp varchar(12) not null default '0'";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_object_perms")." ";
+ $query .= "ADD COLUMN perms_limit_flag tinyint(2) not null default '0' AFTER everyone_perms";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0097()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='0.98' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('updates_root_obj_id','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('time_stamp','".time()."')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('routing_email_enable','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('routing_email_subject','A document has been routed to your DMS inbox')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('routing_email_from','')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('document_email_enable','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('document_email_subject','A document has been sent to you from the DMS')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('document_email_from','')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('purge_enable','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('purge_level','2')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('purge_delay','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('purge_limit','2')";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_object_perms")." ";
+ $query .= "DROP COLUMN perms_limit_flag";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0098()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='0.99' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('default_interface','1')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('pc_enable','1')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('pc_cache_size','500')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('pc_cache_refresh','50')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('pc_refresh_delay','30')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('sub_email_enable','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('sub_email_subject','A document has been accessed in the DMS.')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('sub_email_from','')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('doc_display_limit','100')";
+ $dmsdb->query($query);
+
+ $query = "CREATE TABLE ".$dmsdb->prefix("dms_subscriptions")." (";
+ $query .= "row_id bigint(14) unsigned NOT NULL auto_increment, ";
+ $query .= "obj_id bigint(14) unsigned NOT NULL default '0', ";
+ $query .= "user_id bigint(14) unsigned NOT NULL default '0', ";
+ $query .= "PRIMARY KEY (row_id) ";
+ $query .= ") TYPE=MyISAM;";
+ $dmsdb->query($query);
+
+ $query = "CREATE TABLE ".$dmsdb->prefix("dms_object_misc")." (";
+ $query .= "row_id bigint(14) unsigned NOT NULL auto_increment, ";
+ $query .= "obj_id bigint(14) unsigned NOT NULL default '0', ";
+ $query .= "data_type tinyint(2) unsigned NOT NULL default '0', ";
+ $query .= "data varchar(255) NOT NULL default '', ";
+ $query .= "PRIMARY KEY (row_id) ";
+ $query .= ") TYPE=MyISAM;";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_lifecycles")." ";
+ $query .= "ADD COLUMN obj_id bigint(14) NOT NULL default '0' AFTER lifecycle_id";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_lifecycle_stages")." ";
+ $query .= "ADD COLUMN obj_id bigint(14) NOT NULL default '0' AFTER lifecycle_id";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_lifecycle_stages")." ";
+ $query .= "ADD COLUMN lifecycle_stage_name varchar(255) NOT NULL default '' AFTER new_obj_location";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_lifecycle_stages")." ";
+ $query .= "ADD COLUMN change_perms_flag tinyint(2) NOT NULL default '0' AFTER lifecycle_stage_name";
+ $dmsdb->query($query);
+
+ $query = "DROP TABLE ".$dmsdb->prefix("dms_lifecycle_apply_perms");
+ $dmsdb->query($query);
+
+ $query = "DROP TABLE ".$dmsdb->prefix("dms_lifecycle_doc_perms");
+ $dmsdb->query($query);
+ }
+
+function dms_update_0099()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.00' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "CHANGE name name varchar(30) NOT NULL default ''";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_objects")." ";
+ $query .= "DROP COLUMN lifecycle_suspend_flag";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_objects")." ";
+ $query .= "ADD COLUMN misc_text varchar(255) NOT NULL default '' AFTER time_stamp_delete";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('misc_text_disp_template','1')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('misc_text_disp_lc_stage','1')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('inherit_perms','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('max_file_sys_counter_lock','LOCKED')";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0100()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.10' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('pdftk_enable','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('pdftk_path','')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('group_source','PORTAL')";
+ $dmsdb->query($query);
+
+ $query = "CREATE TABLE ".$dmsdb->prefix("dms_object_version_comments")." (";
+ $query .= "row_id bigint(14) unsigned NOT NULL auto_increment, ";
+ $query .= "dov_row_id bigint(14) unsigned NOT NULL default '0', ";
+ $query .= "comment text NOT NULL default '', ";
+ $query .= "PRIMARY KEY (row_id) ";
+ $query .= ") TYPE=MyISAM;";
+ $dmsdb->query($query);
+
+ $query = "CREATE TABLE ".$dmsdb->prefix("dms_groups")." (";
+ $query .= "group_id bigint(14) unsigned NOT NULL auto_increment, ";
+ $query .= "group_name varchar(50) unsigned NOT NULL default '', ";
+ $query .= "group_description text NOT NULL default '', ";
+ $query .= "group_type varchar(10) NOT NULL default 'PERMS', ";
+ $query .= "PRIMARY KEY (group_id) ";
+ $query .= ") TYPE=MyISAM;";
+ $dmsdb->query($query);
+
+ $query = "CREATE TABLE ".$dmsdb->prefix("dms_groups_users_link")." (";
+ $query .= "row_id bigint(14) unsigned NOT NULL auto_increment, ";
+ $query .= "group_id bigint(14) unsigned NOT NULL default '0', ";
+ $query .= "user_id bigint(14) unsigned NOT NULL default '0', ";
+ $query .= "PRIMARY KEY (row_id) ";
+ $query .= ") TYPE=MyISAM;";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0110()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.20' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('notify_enable','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('notify_email_subject','A document has been accessed in the DMS.')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('notify_email_from','')";
+ $dmsdb->query($query);
+
+ $query = "CREATE TABLE ".$dmsdb->prefix("dms_notify")." (";
+ $query .= "row_id bigint(14) unsigned NOT NULL auto_increment, ";
+ $query .= "obj_id bigint(14) unsigned NOT NULL default '0', ";
+ $query .= "user_id bigint(14) unsigned NOT NULL default '0', ";
+ $query .= "group_id bigint(14) unsigned NOT NULL default '0', ";
+ $query .= "PRIMARY KEY (row_id) ";
+ $query .= ") TYPE=MyISAM;";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0120()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.30' WHERE name='version'";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0130()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.31' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('adn_enable','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('adn_mask','')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('adn_mask_char','')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('adn_prop_field','-1')";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0131()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.40' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('checkinout_enable','1')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('routing_enable','1')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('routing_auto_inbox','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('lifecycle_enable','1')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('comments_enable','1')";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0140()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.50' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('adv_enable','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('adv_mask','')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('adv_mask_char','')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('lifecycle_name_preserve','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('lifecycle_del_previous','0')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('lifecycle_alpha_move','0')";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_object_versions")." ";
+ $query .= "ADD COLUMN init_version_flag tinyint(2) NOT NULL default '0' AFTER sub_minor_version";
+ $dmsdb->query($query);
+
+ $query = "CREATE TABLE ".$dmsdb->prefix("dms_user_doc_history")." (";
+ $query .= "user_id bigint(14) unsigned NOT NULL default '0',";
+ $query .= "obj_id bigint(14) unsigned NOT NULL default '0',";
+ $query .= "time_stamp varchar(12) NOT NULL default '0',";
+ $query .= "obj_name varchar(30) NOT NULL default ''";
+ $query .= ") TYPE=MyISAM";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0150()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.60' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('full_text_search_cdo','0')";
+ $dmsdb->query($query);
+
+ $query = "CREATE TABLE ".$dmsdb->prefix("dms_help_system")." (";
+ $query .= "row_id bigint(14) unsigned NOT NULL auto_increment,";
+ $query .= "help_id varchar(30) NOT NULL default '',";
+ $query .= "obj_id_ptr bigint(14) unsigned NOT NULL default '0',";
+ $query .= "PRIMARY KEY (row_id)";
+ $query .= ") TYPE=MyISAM";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0160()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.70' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "CREATE TABLE ".$dmsdb->prefix("dms_user_prefs")." (";
+ $query .= "row_id bigint(14) unsigned NOT NULL auto_increment,";
+ $query .= "user_id bigint(14) unsigned NOT NULL default '0',";
+ $query .= "pref_name varchar(30) NOT NULL default '',";
+ $query .= "data varchar(30) NOT NULL default '',";
+ $query .= "PRIMARY KEY (row_id)";
+ $query .= ") TYPE=MyISAM";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_lifecycle_stages")." ";
+ $query .= "ADD COLUMN opt_obj_copy_location bigint(14) unsigned NOT NULL default '0' AFTER lifecycle_stage_name";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_lifecycle_stages")." ";
+ $query .= "ADD COLUMN perms_group_id bigint(14) unsigned NOT NULL default '0' AFTER change_perms_flag";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('prop_perms_enable','1')";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_objects")." ADD INDEX (obj_owner)";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_object_perms")." ADD INDEX (ptr_obj_id)";
+ $dmsdb->query($query);
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_lifecycle_stages")." SET change_perms_flag = '1'";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_lifecycle_stages")." ";
+ $query .= "CHANGE change_perms_flag flags smallint(8) not null default '0'";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0170()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.80' WHERE name='version'";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0180()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.81' WHERE name='version'";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0181()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.82' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "DELETE FROM ".$dmsdb->prefix("dms_config")." ";
+ $query .= "WHERE name='max_file_sys_counter_lock'";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('init_config_lock','LOCKED')";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('doc_name_sync','0')";
+ $dmsdb->query($query);
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_object_misc")." ";
+ $query .= "SET data_type='20' WHERE data_type='15'";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0182()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.83' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "CREATE TABLE ".$dmsdb->prefix("dms_job_services")." (";
+ $query .= "row_id bigint(14) unsigned NOT NULL auto_increment,";
+ $query .= "job_type smallint(8) NOT NULL default '0',";
+ $query .= "next_run_time varchar(12) NOT NULL default '0',";
+ $query .= "flags smallint(8) NOT NULL default '0',";
+ $query .= "sched_day smallint(8) NOT NULL default '0',";
+ $query .= "sched_hour smallint(8) NOT NULL default '0',";
+ $query .= "sched_minute smallint(8) NOT NULL default '0',";
+ $query .= "obj_id_a bigint(14) unsigned NOT NULL default '0',";
+ $query .= "obj_id_b bigint(14) unsigned NOT NULL default '0',";
+ $query .= "obj_id_c bigint(14) unsigned NOT NULL default '0',";
+ $query .= "PRIMARY KEY (row_id)";
+ $query .= ") TYPE=MyISAM";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0183()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.84' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_job_services")." ";
+ $query .= "ADD COLUMN text varchar(255) NOT NULL default '' AFTER obj_id_c";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('extern_doc_access','0')";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_job_services")." ";
+ $query .= "ADD COLUMN job_name varchar(50) NOT NULL default '' AFTER row_id";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0184()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.85' WHERE name='version'";
+ $dmsdb->query($query);
+
+ // Check the config of the default_interface. If it is 4, change it to 2. The Single Directory Beta interface is not the
+ // Single Directory interface.
+
+ $query = "SELECT data FROM ".$dmsdb->prefix("dms_config")." ";
+ $query .= "WHERE name='default_interface'";
+ $default_interface = $dmsdb->query($query,"data");
+ print "DI: :".$default_interface.":";
+
+ if($default_interface == '4')
+ {
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='2' WHERE name='default_interface'";
+ $dmsdb->query($query);
+ }
+
+ $query = "DELETE FROM ".$dmsdb->prefix("dms_config")." ";
+ $query .= "WHERE name='pc_enable'";
+ $dmsdb->query($query);
+
+ $query = "DELETE FROM ".$dmsdb->prefix("dms_config")." ";
+ $query .= "WHERE name='pc_cache_size'";
+ $dmsdb->query($query);
+
+ $query = "DELETE FROM ".$dmsdb->prefix("dms_config")." ";
+ $query .= "WHERE name='pc_cache_refresh'";
+ $dmsdb->query($query);
+
+ $query = "DELETE FROM ".$dmsdb->prefix("dms_config")." ";
+ $query .= "WHERE name='pc_refresh_delay'";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('doc_hist_block_rows','10')";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0185()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.86' WHERE name='version'";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0186()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.87' WHERE name='version'";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0187()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.88' WHERE name='version'";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0188()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.89' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_audit_log")." ";
+ $query .= "ADD COLUMN obj_name VARCHAR(255) NOT NULL default '' AFTER descript";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_objects")." ";
+ $query .= "ADD COLUMN file_type varchar(50) NOT NULL default 'unknown' AFTER misc_text";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0189()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.90' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='2' WHERE name='default_interface'";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('OS','unknown')";
+ $dmsdb->query($query);
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_objects")." ";
+ $query .= "SET file_type = 'unchecked' WHERE file_type = 'unknown'";
+ $dmsdb->query($query);
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_objects")." ";
+ $query .= "SET file_type = 'web_page' WHERE obj_type='40'";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_objects")." ";
+ $query .= "MODIFY file_type varchar(50) not null default 'unchecked'";
+ $dmsdb->query($query);
+ }
+
+function dms_update_0190()
+ {
+ global $dmsdb;
+
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='1.91' WHERE name='version'";
+ $dmsdb->query($query);
+
+ $query = "ALTER TABLE ".$dmsdb->prefix("dms_objects")." ";
+ $query .= "ADD COLUMN time_stamp_expire varchar(12) NOT NULL default '0' AFTER time_stamp_delete";
+ $dmsdb->query($query);
+
+ $query = "INSERT INTO ".$dmsdb->prefix("dms_config")." ";
+ $query .= "VALUES ('write_job_server_config','0')";
+ $dmsdb->query($query);
+
+ $dms_config['write_job_server_config'] = 0;
+ }
+?>
Added: XoopsModules/dms/trunk/dms/admin/index.php
===================================================================
--- XoopsModules/dms/trunk/dms/admin/index.php (rev 0)
+++ XoopsModules/dms/trunk/dms/admin/index.php 2013-03-01 03:29:11 UTC (rev 11122)
@@ -0,0 +1,42 @@
+<?php
+// ------------------------------------------------------------------------ //
+// Document Management System //
+// //
+// //
+// ------------------------------------------------------------------------- //
+// 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. //
+// //
+// You may not change or alter any portion of this comment or credits //
+// of supporting developers from this source code or any supporting //
+// source code which is considered copyrighted (c) material of the //
+// original comment or credit authors. //
+// //
+// 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 //
+// ------------------------------------------------------------------------ //
+
+// index.php
+// Administration Page
+
+include_once '../../../mainfile.php';
+include_once (XOOPS_ROOT_PATH."/class/xoopsmodule.php");
+include_once (XOOPS_ROOT_PATH."/include/cp_functions.php");
+global $db, $HTTP_POST_VARS;
+xoops_cp_header();
+
+print '<b>DMS Configuration:</b><BR><BR>';
+
+print "<a href='../config_main.php'>Configuration</a><BR>\r";
+print "<a href='update_manager.php'>Update Manager</a><BR>\r";
+
+xoops_cp_footer();
+?>
Added: XoopsModules/dms/trunk/dms/admin/menu.php
===================================================================
--- XoopsModules/dms/trunk/dms/admin/menu.php (rev 0)
+++ XoopsModules/dms/trunk/dms/admin/menu.php 2013-03-01 03:29:11 UTC (rev 11122)
@@ -0,0 +1,28 @@
+<?php
+// ------------------------------------------------------------------------ //
+// 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. //
+// //
+// You may not change or alter any portion of this comment or credits //
+// of supporting developers from this source code or any supporting //
+// source code which is considered copyrighted (c) material of the //
+// original comment or credit authors. //
+// //
+// 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 //
+// ------------------------------------------------------------------------ //
+
+$adminmenu[1]['title'] = "Configuration";
+$adminmenu[1]['link'] = "config_main.php";
+$adminmenu[2]['title'] = "Update Manager";
+$adminmenu[2]['link'] = "admin/update_manager.php";
+
+?>
Added: XoopsModules/dms/trunk/dms/admin/update_manager.php
===================================================================
--- XoopsModules/dms/trunk/dms/admin/update_manager.php (rev 0)
+++ XoopsModules/dms/trunk/dms/admin/update_manager.php 2013-03-01 03:29:11 UTC (rev 11122)
@@ -0,0 +1,206 @@
+<?php
+// ------------------------------------------------------------------------ //
+// Document Management System //
+// //
+// //
+// ------------------------------------------------------------------------- //
+// 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. //
+// //
+// You may not change or alter any portion of this comment or credits //
+// of supporting developers from this source code or any supporting //
+// source code which is considered copyrighted (c) material of the //
+// original comment or credit authors. //
+// //
+// 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 //
+// ------------------------------------------------------------------------ //
+
+// index.php
+// Administration Page
+
+include_once '../../../mainfile.php';
+include_once (XOOPS_ROOT_PATH."/class/xoopsmodule.php");
+include_once (XOOPS_ROOT_PATH."/include/cp_functions.php");
+include_once '../inc_current_version.php';
+include_once 'inc_admin_functions.php';
+
+// NOTE: DO NOT USE THE inc_dms_function.php FILE BECAUSE THE $dms_config['version'] VALUE MAY BE UPDATED
+// MULTIPLE TIMES! USE THE dms_get_old_version() FUNCTION, INSTEAD.
+
+global $db;
+
+include_once 'inc_update_manager.php';
+
+$module_obj_id="";
+$old_version = dms_get_old_version();
+
+// Update the database to the current version.
+if ($_POST["hdn_update_database"])
+ {
+ dms_update_tables($old_version,$dms_current_version);
+ $old_version = dms_get_old_version();
+
+ dms_update_time_stamp();
+ }
+
+// Update the updates_root_obj_id in the dms_config table
+if ($_POST["hdn_update_updates_root_obj_id"])
+ {
+ $query = "UPDATE ".$dmsdb->prefix("dms_config")." ";
+ $query .= "SET data='".$HTTP_POST_VARS["hdn_updates_root_obj_id"]."' ";
+ $query .= "WHERE name='updates_root_obj_id'";
+ $dmsdb->query($query);
+
+ dms_update_time_stamp();
+ }
+
+// Get $module_obj_id, if selected by user
+if ( ($_POST["hdn_select_module_id"]) && ($_POST['rad_file_id'] > 0) )
+ {
+ $module_obj_id = $HTTP_POST_VARS['rad_file_id'];
+ }
+
+// Get $module_obj_id, if passed from index.php
+if ($_GET["module_id"])
+ {
+ $module_obj_id = $_GET["module_id"];
+ }
+
+if ($_POST["hdn_install_module"])
+ {
+ // Get the path to the docbase
+ $query = "SELECT data FROM ".$dmsdb->prefix("dms_config")." ";
+ $query .= "WHERE name='doc_path'";
+ $docbase_path = $dmsdb->query($query,'data');
+
+ // Get the path to the source file
+ $query = "SELECT file_path, file_type FROM ".$dmsdb->prefix("dms_object_versions")." ";
+ $query .= "WHERE obj_id='".$_POST["txt_new_module_obj_id"]."'";
+
+ $result = $dmsdb->getarray($dmsdb->query($query));
+ $source_file_path = $docbase_path."/".$result['file_path'];
+ $file_type = $result['file_type'];
+
+ switch($file_type)
+ {
+ case "application/octet-stream": $file_type="bzip2"; break;
+ case "application/x-bzip": $file_type="bzip2"; break;
+ case "application/x-tbz": $file_type="bzip2"; break;
+ case "application/zip": $file_type="zip"; break;
+ default:
+ print "Error: Invalid file type detected, operation aborted.<BR>";
+ print "File Type: ".$file_type."<BR>";
+ exit(0);
+ break;
+ }
+
+ // Get xoops modules path
+ $xoops_modules_path = XOOPS_ROOT_PATH."/modules";
+
+ // Create the command to extract the new version
+ if($file_type == "bzip2") $command = "tar -x -j -f ".$source_file_path." -C ".$xoops_modules_path;
+ if($file_type == "zip") $command = "unzip ".$source_file_path." -d ".$xoops_modules_path;
+
+ exec($command);
+//print $command; exit(0);
+
+ dms_update_time_stamp();
+
+ // Reload this page to ensure that the versions are correct.
+ print "<SCRIPT LANGUAGE=\"Javascript\">\r";
+ print " location=\"update_manager.php\";\r";
+ print "</SCRIPT>\r";
+ }
+
+xoops_cp_header();
+
+print "<SCRIPT LANGUAGE=\"Javascript\">\r";
+print " function Update_Module()\r";
+print " {\r";
+print " if(document.frm_module_update.txt_new_module_obj_id.value.length < 1)\r";
+print " {\r";
+print " alert(\"Invalid Object ID for Next Release.\");\r";
+print " }\r";
+print " else\r";
+print " {\r";
+print " if(confirm(\"Install New Module?\"))\r";
+print " {\r";
+print " document.frm_module_update.submit();\r";
+print " }\r";
+print " }\r";
+print " }\r";
+
+print "</SCRIPT>\r";
+
+
+
+print '<b>DMS Configuration</b><BR><BR>';
+
+
+print 'Update Manager:<BR><BR>';
+
+// Beginning of Database update section.
+print "<form name=\"frm_database_update\"method=\"post\" action=\"update_manager.php\">\r";
+
+print " Database:<BR>\r";
+
+print "<BR>\r";
+print " Current Version: ".$dms_current_version."<BR>\r";
+
+if($old_version == $dms_current_version)
+ {
+ print "   No update is required.\r";
+ }
+else
+ {
+ print " Old Version: ".$old_version."<BR>\r";
+ print "<BR>\r";
+
+ print "<input type='hidden' name='hdn_update_database' value='TRUE'>";
+ print " <input type='submit' value='Update'>";
+ }
+
+print "</form>\r";
+
+// Beginning of Job Server update section
+if($dms_config['write_job_server_config'] == '1')
+ {
+ print "<BR> Job Server:<BR><BR>\r";
+ print " <input t...
[truncated message content] |
