aboutsummaryrefslogtreecommitdiffstats
path: root/admin/site_update.php (unfollow)
Commit message (Collapse)AuthorFilesLines
2007-06-21Resolved issue 0000708: Error on synchronizationrub1-4/+8
Resolved issue 0000709: Error with $conf['default_admin_layout'] git-svn-id: http://piwigo.org/svn/trunk@2038 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-13Updates:vdigital1-2/+2
- Copyrights 2003-2007 - help - Some HTML comform requests git-svn-id: http://piwigo.org/svn/trunk@1903 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-09New: #images.high_filesize was added so that we can sum the filesizes in theplegall1-1/+34
filtered history. #images.high_filesize is filled during metadata synchronization. Bug fixed: in getAttribute XML function, when asking "filesize", it was returning high_filesize. The regex was too simple. git-svn-id: http://piwigo.org/svn/trunk@1883 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-11Resolved Issue ID 0000456, 0000457, 0000459, 0000465:rub1-1/+2
o Fix bugs adviser mode git-svn-id: http://piwigo.org/svn/trunk@1458 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-29bug 362: remote site update fails when inserting new cat (MySql err 1048)rvelices1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@1296 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-27merge -r1281:1283 from branch 1.6 to trunk (bug 228 fixed one more time, andplegall1-1/+1
other little things) git-svn-id: http://piwigo.org/svn/trunk@1284 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-26merge -r1276:1277 from branch-1_6 to trunk (bug 228 fixed)plegall1-4/+5
git-svn-id: http://piwigo.org/svn/trunk@1278 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-21bug fixed: popuhelp (slash)nikrou1-1/+1
svn merge -r1248:1249 from branch-1_6 into trunk git-svn-id: http://piwigo.org/svn/trunk@1250 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-18merge r1203 from branch-1_6 into trunkrvelices1-25/+97
bug 335: tn_ext, has_high and representative_ext are updated during file synchronization and not metadata synchronization git-svn-id: http://piwigo.org/svn/trunk@1204 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-04bug fixed: I had forgotten to re-add storage_category_id in the list ofplegall1-7/+2
fields to insert in #images. To avoid future mistakes, I extract automatically all keys of the first array to insert. git-svn-id: http://piwigo.org/svn/trunk@1122 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-04feature deleted: code for categories link was too complicated for such aplegall1-19/+9
simple fature. Replaced by static association. Links are not persistent anymore. modification removed: #image_category.is_storage replaced by #images.storage_category_id as in branche 1.5.. git-svn-id: http://piwigo.org/svn/trunk@1121 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-02improvement: tags replace keywords. Better data model, lessplegall1-10/+43
limitations. Each image can be associated to as many tag as needed. Tags can contain non ASCII characters. Oriented navigation with tags by association. git-svn-id: http://piwigo.org/svn/trunk@1119 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-28fix: php 5 errors and warningsrvelices1-8/+14
improve: put back update remote site from local listing.xml functionality (allow_url_fopen is false on several ISPs) git-svn-id: http://piwigo.org/svn/trunk@1107 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-09Step 2 improvement issue 0000301:rub1-1/+7
o Add and use Functions Check of status o Restricted Access for user generic git-svn-id: http://piwigo.org/svn/trunk@1072 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-04new feature: source/destination links between categories. Will we keep thisplegall1-105/+177
feature? Code is complicated and very few people will understand how it works... modification: #images.storage_category_id replaced by #image_category.is_storage improvement: many code refactoring to improve readibility improvement: virtual category creation code was moved to a dedicated function in order to be called from admin/cat_list.php and admin/cat_modify.php (create a new destination category) git-svn-id: http://piwigo.org/svn/trunk@1064 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-28remake of Remote sites and synchronize: final integration and old code cleanuprvelices1-812/+827
fix: xml getAttribute always decodes html entities and added encodeAttribute function git-svn-id: http://piwigo.org/svn/trunk@1058 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-11remake Remote Site/Synchro - bug on commentable + use l10n instead of get_langrvelices1-20/+20
git-svn-id: http://piwigo.org/svn/trunk@1033 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-08- remake of Remote sites and Synchronize: rvelices1-769/+812
- synchronization for remote and local sites are done by the same code - remote sites can update metadata now (not before) - bug 279 - fixes bug 82: has_high column - improve feature 280: user sort by filename - fix path to template mimetypes icons - bug 284: session cookie lifetime, deletion on logout and corrected issue when db upgrades were missing git-svn-id: http://piwigo.org/svn/trunk@1029 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-12-03- merge -r965:966 from branches/branch-1_5 into trunk (bug 224 fixed)plegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@967 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-10-23- bug fixed: during file tree synchronization, warning on finding the nextplegall1-1/+13
rank of category which has no sub-categories yet. git-svn-id: http://piwigo.org/svn/trunk@913 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-09-03- modification : less configuration parameters in administrationplegall1-0/+6
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
2005-07-16- new feature : RSS notification feed. Feed generator is an external toolplegall1-1/+3
(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
2005-06-11- errors and informations boxes : management centralized in admin.php,plegall1-4/+4
$errors and $infos arrays replaced by $page['errors'] and $page['infos'], special management for admin/update.php (more complex management) git-svn-id: http://piwigo.org/svn/trunk@792 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-06-11- bug 96 (informations given by uploaders are lost) correction reported fromplegall1-0/+56
branch 1.4 git-svn-id: http://piwigo.org/svn/trunk@791 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-01-31- add information after metadata synchronizationplegall1-1/+28
git-svn-id: http://piwigo.org/svn/trunk@723 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-01-15- no debug output in synchronization process (replaced by HTML comments,plegall1-12/+69
information is still available) - when showing result of a simulation, also displays the form with values given for simulation. Admin can perform another simulation or uncheck the simulation option git-svn-id: http://piwigo.org/svn/trunk@691 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-01-07all headers adapted to new year 2005, happy new yearplegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@675 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-30- admin/update : bug when trying to synchronize a particular category (itplegall1-0/+6
was deleted...) git-svn-id: http://piwigo.org/svn/trunk@666 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-30- admin/update : deletion of useless linesplegall1-8/+0
- admin/thumbnail : use new process for finding pictures without thumbnails. No more recursivity - admin/thumbnail : only show list of directory containing pictures without thumbnails, not the whole directory tree git-svn-id: http://piwigo.org/svn/trunk@665 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-28- bugs fixed in filesystem synchronization : if no existing category atplegall1-2/+4
start, need to initialize $next_rank['NULL'], $next_id and $next_element_id - bug fixed : if no queries executed on the page, $count_queries and $queries_time are not initialized for page bottom display - no use of $conf['prefix_thumbnail'] in language information (admin.lang.php) git-svn-id: http://piwigo.org/svn/trunk@660 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-27- admin/update : filesystem synchronization process completelyplegall1-425/+385
rewritten. How to speed up sync ? by avoiding recursivity ! - admin/update : option to display verbose information details - admin/update : option to simulate only. No database insert, delete or update will be made - bug fixed : in admin/cat_list, if you delete a virtual category, you may create a gap in the rank list. This gap will generate errors when trying to move a category on this gap. Fixed by calling ordering and update_global_rank at category deletion. - admin/cat_list, only one query to insert a new virtual category (no need of a second query to update uppercats and global_rank) - for a given category, even if empty, the representing element must not be the one of a forbidden category for the current user - generation time optionnaly displayed on the bottom of each page becomes more price : number of SQL queries and SQL time added. git-svn-id: http://piwigo.org/svn/trunk@659 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-12- in admin menu, status option for categories is not "permissions" butplegall1-48/+83
"private or public" choice = different language item - get_cat_display_name changed : use $conf['level_separator'] to unify presentation - default values for category properties commentable, uploadable, status and visible (set in include/config.inc.php) used for category creation (admin/update, admin/remote_site, admin/cat_list) - use mass_inserts in admin/update for inserting new categories - only one query for counting the number of sub categories in admin/cat_list git-svn-id: http://piwigo.org/svn/trunk@642 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-05- ordering function moved from admin/update to admin/include/functionplegall1-37/+0
- remote_site uses ordering and update_global_rank git-svn-id: http://piwigo.org/svn/trunk@638 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-04- shows the element representing a non empty category in cat_modifyplegall1-15/+1
- possibility to set a random representing element for a category - bug fixed : update_category function could not update nb_images - bug fixed : mass_updates was inserting in the wrong table git-svn-id: http://piwigo.org/svn/trunk@633 68402e56-0260-453c-a942-63ccdbb3a9ee
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