aboutsummaryrefslogtreecommitdiffstats
path: root/install (follow)
Commit message (Collapse)AuthorAgeFilesLines
* - bug 209 fixed: upgrade script did not delete obsolete columns in usersplegall2005-12-063-0/+217
| | | | | | | | | table. users.password column was not updated by upgrade script. To fix this bug, a new upgrade script from 1.5.0 was added even if database model did not change, it's just about fixing upgraded database. git-svn-id: http://piwigo.org/svn/branches/branch-1_5@974 68402e56-0260-453c-a942-63ccdbb3a9ee
* - bug 181 fixed: "Parameters not created in phpwebgallery_config duringplegall2005-10-232-2/+56
| | | | | | | | | upgrade". gallery_title and gallery_description had not been added to config table. (use|show)_(exif|iptc) and authorize_remembering have also been removed... git-svn-id: http://piwigo.org/svn/trunk@911 68402e56-0260-453c-a942-63ccdbb3a9ee
* - modification: configuration parameters gallery_title andplegall2005-10-071-5/+3
| | | | | | | | | | | | gallery_description are GUI managed in Administration>Configuration>General - bug fixed: configuration parameters (use|show)_(exif|iptc) and authorize_remembering should have been deleted from config table some time ago. git-svn-id: http://piwigo.org/svn/trunk@882 68402e56-0260-453c-a942-63ccdbb3a9ee
* - update: upgrade from 1.4.0 or 1.4.1. Upgrade from 1.3.x is not availableplegall2005-09-208-2010/+550
| | | | | | | | | | | | | | anymore. - update: README files updated for very near branch 1.5 :-) - new: file tools/config_local.inc.php as example for optional include/config_local.inc.php - bug fixed: configuration parameter show_picture_name_on_title was useless git-svn-id: http://piwigo.org/svn/trunk@870 68402e56-0260-453c-a942-63ccdbb3a9ee
* (not in ChangeLog)plegall2005-09-032-2/+2
| | | | | | | | | | - yoga template used for installation and by default in user_infos table - adaptation of yoga template to itself (no use of icons from template default) git-svn-id: http://piwigo.org/svn/trunk@860 68402e56-0260-453c-a942-63ccdbb3a9ee
* - modification : less configuration parameters in administrationplegall2005-09-032-16/+9
| | | | | | | | | | | | | | | | | | | screen. These parameters are move to include/config_default.inc.php. - new : ability to add a single picture to caddie from picture.php - new : contextual help, only a few pages are available. - new : ability to delete users from admin/user_list - modification : reorganization of configuration file - new : configuration parameter use_exif_mapping - improvement : MOD hidemail added to standard git-svn-id: http://piwigo.org/svn/trunk@858 68402e56-0260-453c-a942-63ccdbb3a9ee
* - deletion : no mail notification anymore. Feature replaced by RSS feedplegall2005-08-241-1/+0
| | | | | | | | | | | | notification. - improvement : on waiting pictures management. Ability to validate all or reject all in one clic. - regrouped fields in admin/update git-svn-id: http://piwigo.org/svn/trunk@849 68402e56-0260-453c-a942-63ccdbb3a9ee
* - modification : RSS feed work only with a given feed identifier. Thus weplegall2005-08-191-2/+12
| | | | | | | | | | can avoid fixed frequency notification to concentrate on variable frequency notification, which is much more interesting. To do this, feeds have moved to a dedicated table allowing each user (including guest user) to have more than on feed. git-svn-id: http://piwigo.org/svn/trunk@833 68402e56-0260-453c-a942-63ccdbb3a9ee
* - new : external authentication in another users table. Previous users tableplegall2005-08-081-10/+20
| | | | | | | | | | | | | | | | | | | | | | | | | is divided between users (common properties with any web application) and user_infos (phpwebgallery specific informations). External table and fields can be configured. - modification : profile.php is not reachable through administration anymore (not useful). - modification : in profile.php, current password is mandatory only if user tries to change his password. Username can't be changed. - deletion : of obsolete functions get_user_restrictions, update_user_restrictions, get_user_all_restrictions, is_user_allowed, update_user - modification : $user['forbidden_categories'] equals at least "-1" so that category_id NOT IN ($user['forbidden_categories']) can always be used. - modification : user_forbidden table becomes user_cache so that not only restriction informations can be stored in this table. git-svn-id: http://piwigo.org/svn/trunk@808 68402e56-0260-453c-a942-63ccdbb3a9ee
* - new feature : RSS notification feed. Feed generator is an external toolplegall2005-07-162-191/+208
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (FeedCreator class v1.7.2). New file feed.php - new database field : comments.validation_date (datetime). This field is required for notification feed. - new database field : users.feed_id (varchar(50)). users.feed_id is an alias of users.id but is much more complicated to find (50 characters, figures or letters, case sensitive) : the purpose is to keep it secret (as far as possible). - new database field : users.last_feed_check (datetime) - new database field : users.registration_date (datetime) - bug fixed : no need to add the (unavailable) session id to install.php in the installation form. - modified database field : images.date_available become more precise (date to datetime). This precision is needed for notification feed. - new index : comments_i1 (validation_date). Might be useful for feed queries. - new index : comments_i2 (image_id). Useful each time you want to have informations about an element and its associated comments. - version 9.11 of mysqldump outputs database field names and table names with backquote "`" (didn't find how to take them off) git-svn-id: http://piwigo.org/svn/trunk@801 68402e56-0260-453c-a942-63ccdbb3a9ee
* - new feature : caddie (new table was forgotten in previous commit)plegall2005-03-251-0/+11
| | | | git-svn-id: http://piwigo.org/svn/trunk@757 68402e56-0260-453c-a942-63ccdbb3a9ee
* - by default use_iptc and use_exif are set to falseplegall2005-01-171-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@701 68402e56-0260-453c-a942-63ccdbb3a9ee
* all headers adapted to new year 2005, happy new yearplegall2005-01-075-5/+5
| | | | git-svn-id: http://piwigo.org/svn/trunk@675 68402e56-0260-453c-a942-63ccdbb3a9ee
* - upgrade scripts added for releases 1.3.xplegall2005-01-066-1/+1851
| | | | | | | | | | | | | | | | | | | | | | | | | - my_error function moved from admin/include/functions.php to include/functions.inc.php - because MySQL temporary tables are not always authorized on creation, use a temporary table name (with the current microsecond) on a non temporary table (in mass_updates function) - ability to retrieve distant full directories (usefull in upgrade scripts) - global variables $count_queries and $queries_time moved into global array $page - get_cat_display_name displays category names in correct order : the one given by uppercats - function setup_style simplified - default value for configuration parameter "show_nb_comments" set to false (less queries by default) git-svn-id: http://piwigo.org/svn/trunk@672 68402e56-0260-453c-a942-63ccdbb3a9ee
* - new feature : lock temporary your gallery for maintenanceplegall2004-12-201-0/+1
| | | | | | | - $user keys for guest user are initialized with default values of $conf git-svn-id: http://piwigo.org/svn/trunk@653 68402e56-0260-453c-a942-63ccdbb3a9ee
* - restricted access mode deleted : set all your categories as privateplegall2004-12-201-1/+0
| | | | | | | instead git-svn-id: http://piwigo.org/svn/trunk@651 68402e56-0260-453c-a942-63ccdbb3a9ee
* - Minor update of language filegweltas2004-12-201-0/+2
| | | | | | | - Configuration / Default dispaly : maximum height & width git-svn-id: http://piwigo.org/svn/trunk@649 68402e56-0260-453c-a942-63ccdbb3a9ee
* - in picture.php, $user['maxwidth'] and $user['maxheight'] can be unset ifplegall2004-12-202-2/+17
| | | | | | | | | | | | | | | | | | NULL in database - new table user_forbidden {user_id,need_update,forbidden_categories} and deletion of field users.forbidden_categories - new function calculate_permissions to update table user_forbidden when needed - simplification of include/user.inc.php - in footer of each page, use "-" instead of "::" to separate page information git-svn-id: http://piwigo.org/svn/trunk@648 68402e56-0260-453c-a942-63ccdbb3a9ee
* - bug fixed : in admin/cat_list, next_rank cant' be calculted and query toplegall2004-12-182-5/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | count sub-categories per sub-categories became false if no sub-categories - virtual association come back in admin/infos_images (not only in admin/picture_modify) - check_favorites function in admin section becomes check_user_favorites in public section : favorites are checked when user tries to display his favorites. Function was optimized. - in function update_category, wrap of long queries due to many categories to update at the same time - typo fixed in description of paginate_pages_around configuration parameter - bug fixed in new navigation bar : no separation pipe was displayed between next and last when the page displayed was the last - sessions.expiration changed of type from int to datetime (a lot easier to read) - sessions.ip removed : IP address is no longer used to verify session - $lang['cat_options'] was missing in en_UK.iso-8859-1 - typo fixed in language/en_UK.iso-8859-1/admin.lang.php on editcat_lock_info language item git-svn-id: http://piwigo.org/svn/trunk@647 68402e56-0260-453c-a942-63ccdbb3a9ee
* changing name of key from none to history_i1plegall2004-11-241-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@616 68402e56-0260-453c-a942-63ccdbb3a9ee
* Drop of PRIMARY Key on history table.gweltas2004-11-241-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@615 68402e56-0260-453c-a942-63ccdbb3a9ee
* - global categories' options : instead of N horizontal tabs on a singleplegall2004-11-232-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | page, N options in the left menu (but the same backend) - categories.global_rank : new calculated field. It gives a global rank of the category among all others (updated during ordering) - category.php page : menu is generated faster thanks to categories.global_rank, recursivity becomes useless :-) - new function to display select box with a set of categories : display_select_cat_wrapper - cat_options : instead of using 1 multiselect for true/false items, using 1 multiselect for true, and another one for false. The form provides buttons with arrows to switch categories from one multiselect to another - deletion of obsolete function display_categories (working with the old template system) - deletion of obsolete functions get_user_plain_structure, create_user_structure, get_user_subcat_ids, update_structure, count_images : useless thanks to global_rank git-svn-id: http://piwigo.org/svn/trunk@614 68402e56-0260-453c-a942-63ccdbb3a9ee
* optimization : instead of reading each $conf['calendar_datefield'] forplegall2004-11-212-1/+3
| | | | | | | | | matching YEAR() and MONTH(), use of SQL statement BETWEEN ... AND ... on the date field + new index image_i5 on date_creation (default date field for calendar) git-svn-id: http://piwigo.org/svn/trunk@612 68402e56-0260-453c-a942-63ccdbb3a9ee
* - images.path column added to reduce database accessplegall2004-11-162-0/+2
| | | | | | | | | | - function mass_inserts moved from admin/remote_sites.php to admin/include/function.php - function mass_inserts used in admin/update.php git-svn-id: http://piwigo.org/svn/trunk@606 68402e56-0260-453c-a942-63ccdbb3a9ee
* - admin/cat_options page added : manage options for the whole categoriesplegall2004-11-133-7/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | tree (uploadable, commentable). status and visible will be soon added - admin.php : $conf_link var to avoid lines longer than 79 characters - config.upload_available configuration parameter disappear : it's simpler to manage with cat_options - config.show_comments idem : new column categories.commentable, each categories can be commentable or not - categories.site_id becomes a nullable column : a virtual category does belong to no site - function display_select_categories has a new argument : $CSS_classes array to optionnaly assign a CSS class to each category in the select field - added informations in include/config.inc.php for setting default value of : - categories.visible - categories.status - categories.uploadable - categories.commentable - 2 new indexes images_i3(average_rate) and images_i4(hit) : optimizes best rated and most visited categories git-svn-id: http://piwigo.org/svn/trunk@602 68402e56-0260-453c-a942-63ccdbb3a9ee
* there was a bug in the mysql structure script generator : when a column wasz0rglub2004-10-231-91/+91
| | | | | | | nullable the script said the opposite git-svn-id: http://piwigo.org/svn/trunk@573 68402e56-0260-453c-a942-63ccdbb3a9ee
* - checkbox for "remember me" are only shown if authorizedz0rglub2004-10-061-1/+0
| | | | | | | | | | | | | | - simplification : each session is created with a cookie and if PhpWebGallery can't read the cookie, it uses the URI id and it will be used in the add_session_id function. - configuration parameter "auth_method" disappeared (didn't lived much...) - only one session id size possible. More comments for configuration in include/config.inc.php git-svn-id: http://piwigo.org/svn/trunk@555 68402e56-0260-453c-a942-63ccdbb3a9ee
* - deletion of session_time and session_id_size as config parameterz0rglub2004-10-021-3/+2
| | | | | | | | | | | | - new feature : "remember me" creates a long time cookie - possibility to set the default authentication method to URI or cookie - really technical parameters (session identifier size, session duration) are set in the config file and not in database + configuration.php git-svn-id: http://piwigo.org/svn/trunk@541 68402e56-0260-453c-a942-63ccdbb3a9ee
* -First draft of history displaygweltas2004-09-261-2/+3
| | | | git-svn-id: http://piwigo.org/svn/trunk@537 68402e56-0260-453c-a942-63ccdbb3a9ee
* - in admin/configuration, add new step with "sections" (general, comments,z0rglub2004-09-031-4/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | default, upload, metadata, sessions) - admin/configuration.php and its template have been higly simplificated by making things more generic : for example, for each configuration parameter, its name must correspond to the name we find in the config table and belongs to a section, in the lang array we find : - $lang['conf_<section>_<param>'] - $lang['conf_<section>_<param>_info'] - $lang['conf_<section>_<param>_error'] optionnaly - more described message when connection to database server is impossible - redefinitions of get_languages and get_templates functions - deletion of configuration parameters : webmaster, session_keyword - rename of configuration parameters : - default_lang => default_language - default_style => default_template git-svn-id: http://piwigo.org/svn/trunk@512 68402e56-0260-453c-a942-63ccdbb3a9ee
* add rating featurez0rglub2004-08-302-0/+20
| | | | git-svn-id: http://piwigo.org/svn/trunk@507 68402e56-0260-453c-a942-63ccdbb3a9ee
* "show metadata" feature added : you can ask to show metadata (EXIF and IPTC)z0rglub2004-08-251-0/+2
| | | | | | | | on picture.php page. Metadata read functions were moved from admin/include/functions_metadata.php to include/functions_metadata.inc.php git-svn-id: http://piwigo.org/svn/trunk@493 68402e56-0260-453c-a942-63ccdbb3a9ee
* - add files metadata support : use info for database fieldsz0rglub2004-08-211-0/+1
| | | | | | | | - distinction between directories synchronization and metadata synchronization git-svn-id: http://piwigo.org/svn/trunk@487 68402e56-0260-453c-a942-63ccdbb3a9ee
* - add files metadata support : use info for database fieldsz0rglub2004-08-212-0/+3
| | | | | | | - distinction between directories synchronization and metadata synchronization git-svn-id: http://piwigo.org/svn/trunk@486 68402e56-0260-453c-a942-63ccdbb3a9ee
* - non picture files management (adds column images.representative_ext)z0rglub2004-08-052-6/+6
| | | | | | | - short_period + long_period replaced by a single recent_period git-svn-id: http://piwigo.org/svn/trunk@474 68402e56-0260-453c-a942-63ccdbb3a9ee
* Installation procedure updategweltas2004-07-281-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@463 68402e56-0260-453c-a942-63ccdbb3a9ee
* replacement of short_period and long_period by recent_periodz0rglub2004-07-091-3/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@452 68402e56-0260-453c-a942-63ccdbb3a9ee
* - moved index images.storage_category_id to images_i1z0rglub2004-06-251-1/+2
| | | | | | | - new index images_i2 on images.date_available git-svn-id: http://piwigo.org/svn/trunk@444 68402e56-0260-453c-a942-63ccdbb3a9ee
* - moved index storage_category_id to images_i1z0rglub2004-06-251-6/+7
| | | | | | | - new index images_i2 on images.date_available git-svn-id: http://piwigo.org/svn/trunk@443 68402e56-0260-453c-a942-63ccdbb3a9ee
* table user_category droppedz0rglub2004-05-282-20/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@423 68402e56-0260-453c-a942-63ccdbb3a9ee
* field comments.date becomes a datetime MySQL field type (instead of int)z0rglub2004-05-202-134/+138
| | | | git-svn-id: http://piwigo.org/svn/trunk@420 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 15 : useless index in categories droppedz0rglub2004-03-312-2/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@407 68402e56-0260-453c-a942-63ccdbb3a9ee
* Default configurationgweltas2004-03-271-1/+8
| | | | git-svn-id: http://piwigo.org/svn/trunk@399 68402e56-0260-453c-a942-63ccdbb3a9ee
* new version of config tablez0rglub2004-03-041-22/+5
| | | | git-svn-id: http://piwigo.org/svn/trunk@385 68402e56-0260-453c-a942-63ccdbb3a9ee
* initial revisionz0rglub2004-03-042-0/+157
| | | | git-svn-id: http://piwigo.org/svn/trunk@384 68402e56-0260-453c-a942-63ccdbb3a9ee
* move admin/phpwebgallery_structure.sql to install/phpwebgallery_structure.sqlz0rglub2004-03-041-0/+263
git-svn-id: http://piwigo.org/svn/trunk@381 68402e56-0260-453c-a942-63ccdbb3a9ee