aboutsummaryrefslogtreecommitdiffstats
path: root/admin/update.php (follow)
Commit message (Collapse)AuthorAgeFilesLines
* - update_global_rank new function : far more intelligent update. Take intoplegall2004-11-301-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
* - global categories' options : instead of N horizontal tabs on a singleplegall2004-11-231-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
* - optimization : representative picture becomes mandatory for a non emptyplegall2004-11-201-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
* - images.path column added to reduce database accessplegall2004-11-161-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
* - admin/cat_options page added : manage options for the whole categoriesplegall2004-11-131-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
* update headers to comply with GPLz0rglub2004-11-061-4/+4
| | | | git-svn-id: http://piwigo.org/svn/trunk@593 68402e56-0260-453c-a942-63ccdbb3a9ee
* - synchronization interface redesigned : a form lets user choose option ofz0rglub2004-11-011-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
* - function mysql_query replaced by pwg_query : the same with debuggingz0rglub2004-10-301-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
* - debug code deletionz0rglub2004-10-241-2/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@581 68402e56-0260-453c-a942-63ccdbb3a9ee
* representative was badly tested using prefix_thumbnail...z0rglub2004-09-181-3/+3
| | | | git-svn-id: http://piwigo.org/svn/trunk@522 68402e56-0260-453c-a942-63ccdbb3a9ee
* waiting tpl migrationgweltas2004-09-111-0/+4
| | | | git-svn-id: http://piwigo.org/svn/trunk@520 68402e56-0260-453c-a942-63ccdbb3a9ee
* simplier display of update result :z0rglub2004-08-291-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
* very small refactoringz0rglub2004-08-251-2/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@494 68402e56-0260-453c-a942-63ccdbb3a9ee
* - add files metadata support : use info for database fieldsz0rglub2004-08-211-136/+153
| | | | | | | - distinction between directories synchronization and metadata synchronization git-svn-id: http://piwigo.org/svn/trunk@486 68402e56-0260-453c-a942-63ccdbb3a9ee
* - non picture files managementz0rglub2004-08-051-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
* table user_category droppedz0rglub2004-05-281-5/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@423 68402e56-0260-453c-a942-63ccdbb3a9ee
* - Template migrationgweltas2004-03-261-1/+30
| | | | | | | | - Admin Control Panel migration - Category management git-svn-id: http://piwigo.org/svn/trunk@394 68402e56-0260-453c-a942-63ccdbb3a9ee
* - Template migrationgweltas2004-03-201-65/+59
| | | | | | | | - Admin Control Panel migration - Language migration git-svn-id: http://piwigo.org/svn/trunk@393 68402e56-0260-453c-a942-63ccdbb3a9ee
* header global refactoringz0rglub2004-02-111-18/+26
| | | | git-svn-id: http://piwigo.org/svn/trunk@362 68402e56-0260-453c-a942-63ccdbb3a9ee
* using listing.xml in admin directoryz0rglub2004-02-111-2/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@358 68402e56-0260-453c-a942-63ccdbb3a9ee
* Merge of the 1.3.1 releasegweltas2004-02-021-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
* Modifications linked to the move of admin.php to the root directory of ↵z0rglub2003-11-031-6/+6
| | | | | | PhpWebGallery git-svn-id: http://piwigo.org/svn/trunk@228 68402e56-0260-453c-a942-63ccdbb3a9ee
* Modifying ./include/isadmin.inc.php in ./admin/include/isadmin.inc.php since ↵z0rglub2003-11-031-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
* Modifying ../template in ./template since admin.php has moved to the ↵z0rglub2003-11-021-3/+3
| | | | | | PhpWebGallery root directory git-svn-id: http://piwigo.org/svn/trunk@225 68402e56-0260-453c-a942-63ccdbb3a9ee
* Filename must use the same characters as the directoriesz0rglub2003-09-221-25/+34
| | | | git-svn-id: http://piwigo.org/svn/trunk@160 68402e56-0260-453c-a942-63ccdbb3a9ee
* If a category with a wrong directory name (accentuated characters) evenz0rglub2003-09-201-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
* If we delete a picture which is logically linked to a category, thez0rglub2003-09-171-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
* Adding the name when inserting a remote category in the database. $namez0rglub2003-09-161-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
* The execution of the query to insert distant picture had vanished !z0rglub2003-09-161-0/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@124 68402e56-0260-453c-a942-63ccdbb3a9ee
* - Bug correction : when adding a new category, the program enters anz0rglub2003-09-111-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
* waiting.category_id was replaced by waiting.storage_category_idz0rglub2003-09-081-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@81 68402e56-0260-453c-a942-63ccdbb3a9ee
* Multi categories for the same picturez0rglub2003-08-301-90/+77
| | | | git-svn-id: http://piwigo.org/svn/trunk@61 68402e56-0260-453c-a942-63ccdbb3a9ee
* improve the header of each filez0rglub2003-08-241-2/+4
| | | | git-svn-id: http://piwigo.org/svn/trunk@57 68402e56-0260-453c-a942-63ccdbb3a9ee
* ['template'] as user_template for displaying pictures in the templatez0rglub2003-07-211-4/+7
| | | | git-svn-id: http://piwigo.org/svn/trunk@29 68402e56-0260-453c-a942-63ccdbb3a9ee
* *** empty log message ***z0rglub2003-07-211-12/+43
| | | | git-svn-id: http://piwigo.org/svn/trunk@26 68402e56-0260-453c-a942-63ccdbb3a9ee
* *** empty log message ***z0rglub2003-05-271-2/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@19 68402e56-0260-453c-a942-63ccdbb3a9ee
* *** empty log message ***z0rglub2003-05-171-0/+575
git-svn-id: http://piwigo.org/svn/trunk@10 68402e56-0260-453c-a942-63ccdbb3a9ee