aboutsummaryrefslogtreecommitdiffstats
path: root/admin/update.php (unfollow)
Commit message (Collapse)AuthorFilesLines
2004-11-30- update_global_rank new function : far more intelligent update. Take intoplegall1-36/+7
account the possiblity to have category tree not in category id ascending order - update global_rank when moving categories among the same parent - new function mass_updates : depending on MySQL version, create a temporary table, make one big insert and one big update by joining 2 tables (4.0.4 or above) or make 1 update per primary key - function update_category improved for representative_picture_id check : only one useful query (equivalent to NOT EXISTS) instead of N (N = number of categories) queries git-svn-id: http://piwigo.org/svn/trunk@625 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-23- global categories' options : instead of N horizontal tabs on a singleplegall1-17/+38
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
2004-11-20- optimization : representative picture becomes mandatory for a non emptyplegall1-0/+16
category. So, at each insertion in images table for a category, a new representative element is elected (by rand). This must be improved by not reelcting a random picture admin set an element as representative manually. - optimization : recent cats page only needs 2 queries instead of 3*N (N categories to display). The bad point is that it shows representative element of recent cat and not a random element among recently added. - optimization : empty cats page only needs 1 query per non empty sub category instead of... a lot. For each sub category, PhpWebGallery shows the representative element of a category chosen randomly in sub cats. Thus, get_non_empty_subcat_ids and get_first_non_empty_cat_id becomes obsolete. - new function get_cat_display_name_cache to show category names with a caching for all gallery categories names. This function, to the contrary of get_cat_display_name shows names in the correct order... git-svn-id: http://piwigo.org/svn/trunk@610 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-16- images.path column added to reduce database accessplegall1-43/+10
- 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
2004-11-13- admin/cat_options page added : manage options for the whole categoriesplegall1-1/+2
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
2004-11-06update headers to comply with GPLz0rglub1-4/+4
git-svn-id: http://piwigo.org/svn/trunk@593 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-01- synchronization interface redesigned : a form lets user choose option ofz0rglub1-75/+115
dirs/files/metadata sync on all categories or a defined one (including subcategories) - database sync is only available through update.php git-svn-id: http://piwigo.org/svn/trunk@589 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-10-30- function mysql_query replaced by pwg_query : the same with debuggingz0rglub1-16/+16
features - by default, DEBUG is set to 0 (off) git-svn-id: http://piwigo.org/svn/trunk@587 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-10-24- debug code deletionz0rglub1-2/+1
git-svn-id: http://piwigo.org/svn/trunk@581 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-09-18representative was badly tested using prefix_thumbnail...z0rglub1-3/+3
git-svn-id: http://piwigo.org/svn/trunk@522 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-09-11waiting tpl migrationgweltas1-0/+4
git-svn-id: http://piwigo.org/svn/trunk@520 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-29simplier display of update result :z0rglub1-26/+30
- number of new categories - number of new elements - number of deleted categories - number of deleted elements - only errors are fully listed git-svn-id: http://piwigo.org/svn/trunk@498 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-25very small refactoringz0rglub1-2/+2
git-svn-id: http://piwigo.org/svn/trunk@494 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-21- add files metadata support : use info for database fieldsz0rglub1-136/+153
- distinction between directories synchronization and metadata synchronization git-svn-id: http://piwigo.org/svn/trunk@486 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-05- non picture files managementz0rglub1-512/+369
- all remote site update functions moved to nex file update_remote.php git-svn-id: http://piwigo.org/svn/trunk@466 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-05-28table user_category droppedz0rglub1-5/+0
git-svn-id: http://piwigo.org/svn/trunk@423 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-03-26- Template migrationgweltas1-1/+30
- Admin Control Panel migration - Category management git-svn-id: http://piwigo.org/svn/trunk@394 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-03-20- Template migrationgweltas1-65/+59
- Admin Control Panel migration - Language migration git-svn-id: http://piwigo.org/svn/trunk@393 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-02-11header global refactoringz0rglub1-18/+26
git-svn-id: http://piwigo.org/svn/trunk@362 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-02-11using listing.xml in admin directoryz0rglub1-2/+2
git-svn-id: http://piwigo.org/svn/trunk@358 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-02-02Merge of the 1.3.1 releasegweltas1-381/+497
Creation of an unique include file (common.php) Creation of an unique define file (include/constants.php) Modification of the installation procedure git-svn-id: http://piwigo.org/svn/trunk@345 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-11-03Modifications linked to the move of admin.php to the root directory of ↵z0rglub1-6/+6
PhpWebGallery git-svn-id: http://piwigo.org/svn/trunk@228 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-11-03Modifying ./include/isadmin.inc.php in ./admin/include/isadmin.inc.php since ↵z0rglub1-1/+1
admin.php has moved to the PhpWebGallery root directory git-svn-id: http://piwigo.org/svn/trunk@226 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-11-02Modifying ../template in ./template since admin.php has moved to the ↵z0rglub1-3/+3
PhpWebGallery root directory git-svn-id: http://piwigo.org/svn/trunk@225 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-22Filename must use the same characters as the directoriesz0rglub1-25/+34
git-svn-id: http://piwigo.org/svn/trunk@160 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-20If a category with a wrong directory name (accentuated characters) evenz0rglub1-0/+15
exists (from a previous release of PhpWebGallery), a warning message is displayed but the update goes on git-svn-id: http://piwigo.org/svn/trunk@147 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-17If we delete a picture which is logically linked to a category, thez0rglub1-2/+2
informations about this category are not updated (number of pictures and date of last picture) -> use of update_category( 'all' ) git-svn-id: http://piwigo.org/svn/trunk@130 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-16Adding the name when inserting a remote category in the database. $namez0rglub1-5/+7
becomes $dir (even if named "name" in the XML file) git-svn-id: http://piwigo.org/svn/trunk@126 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-16The execution of the query to insert distant picture had vanished !z0rglub1-0/+1
git-svn-id: http://piwigo.org/svn/trunk@124 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-11- Bug correction : when adding a new category, the program enters anz0rglub1-19/+21
infinite loop -> we have to refresh the $page['plain_structure'] for each new category added - Categories.name becomes not nullable, so a default name is given when a new category is added - If a directory doesn't correspond to the regular format [A-Za-z0-9-_.], an error message is displayed, and the category not added git-svn-id: http://piwigo.org/svn/trunk@88 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-09-08waiting.category_id was replaced by waiting.storage_category_idz0rglub1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@81 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-08-30Multi categories for the same picturez0rglub1-90/+77
git-svn-id: http://piwigo.org/svn/trunk@61 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-08-24improve the header of each filez0rglub1-2/+4
git-svn-id: http://piwigo.org/svn/trunk@57 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-07-21['template'] as user_template for displaying pictures in the templatez0rglub1-4/+7
git-svn-id: http://piwigo.org/svn/trunk@29 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-07-21*** empty log message ***z0rglub1-12/+43
git-svn-id: http://piwigo.org/svn/trunk@26 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-05-27*** empty log message ***z0rglub1-2/+2
git-svn-id: http://piwigo.org/svn/trunk@19 68402e56-0260-453c-a942-63ccdbb3a9ee
2003-05-17*** empty log message ***z0rglub1-0/+575
git-svn-id: http://piwigo.org/svn/trunk@10 68402e56-0260-453c-a942-63ccdbb3a9ee