aboutsummaryrefslogtreecommitdiffstats
path: root/include/functions_category.inc.php (follow)
Commit message (Collapse)AuthorAgeFilesLines
* all headers adapted to new year 2005, happy new yearplegall2005-01-071-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@675 68402e56-0260-453c-a942-63ccdbb3a9ee
* - upgrade scripts added for releases 1.3.xplegall2005-01-061-4/+9
| | | | | | | | | | | | | | | | | | | | | | | | | - 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
* - user permissions ask update at each admin page generation. Tableplegall2004-12-251-5/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | user_forbidden must be updated only if current user is not in administrative section - bug fixed : category.php, error on page title when non category selected - admin/search : bug on variable $PHP_SELF, replaced by $_SERVER['PHP_SELF'] - admin/user_perm : inheritence management. When a category become authorized, all parent categories become authorized, when a category become forbidden, all child category become forbidden - no more recursivity in delete_categories function - new function get_fs_directories for future new method of synchronization - new function get_uppercat_ids replacing several pieces of code doing the same - new function get_fulldirs used for metadata function get_filelist and future new method of synchronization - new function get_fs for future new method of synchronization - typo correction on lang item "about_message" - no link to category privacy status management on user permission anymore (giving the menu item instead) git-svn-id: http://piwigo.org/svn/trunk@657 68402e56-0260-453c-a942-63ccdbb3a9ee
* - User permissions template migrationgweltas2004-12-231-0/+3
| | | | | | | - Categories inheritence has not yet been done git-svn-id: http://piwigo.org/svn/trunk@655 68402e56-0260-453c-a942-63ccdbb3a9ee
* - French translation of general lockgweltas2004-12-231-1/+1
| | | | | | | - Correction of page title in the category page git-svn-id: http://piwigo.org/svn/trunk@654 68402e56-0260-453c-a942-63ccdbb3a9ee
* - for searching in sub-categories, use the existing get_subcat_ids functionplegall2004-12-201-28/+6
| | | | | | | | - bug fixed : category total elements count for best rated when $user['forbidden_categories'] is not empty git-svn-id: http://piwigo.org/svn/trunk@652 68402e56-0260-453c-a942-63ccdbb3a9ee
* - bug fixed : in admin/cat_list, next_rank cant' be calculted and query toplegall2004-12-181-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* - in admin menu, status option for categories is not "permissions" butplegall2004-12-121-2/+0
| | | | | | | | | | | | | | | | | | "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
* - change the category levels separator to a "superior to" to be the same asplegall2004-12-061-1/+5
| | | | | | | | | in picture.php - add a link on each category level as in picture.php git-svn-id: http://piwigo.org/svn/trunk@641 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug fix on typoplegall2004-12-051-6/+6
| | | | git-svn-id: http://piwigo.org/svn/trunk@636 68402e56-0260-453c-a942-63ccdbb3a9ee
* - search modified : possible to partially fill the date, allwords areplegall2004-12-051-35/+71
| | | | | | | | separated from more specific search, separation of HTML (in template) and PHP code) git-svn-id: http://piwigo.org/svn/trunk@634 68402e56-0260-453c-a942-63ccdbb3a9ee
* Update of the user preferences panel.gweltas2004-12-021-1/+1
| | | | | | | Deletion of some PREFIX_TABLE occurences git-svn-id: http://piwigo.org/svn/trunk@630 68402e56-0260-453c-a942-63ccdbb3a9ee
* Search form updategweltas2004-12-021-30/+27
| | | | git-svn-id: http://piwigo.org/svn/trunk@629 68402e56-0260-453c-a942-63ccdbb3a9ee
* New ergonomic form for search queries.gweltas2004-11-251-51/+33
| | | | git-svn-id: http://piwigo.org/svn/trunk@621 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug corrected for multipages view on list special categoryplegall2004-11-241-0/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@617 68402e56-0260-453c-a942-63ccdbb3a9ee
* - global categories' options : instead of N horizontal tabs on a singleplegall2004-11-231-147/+50
| | | | | | | | | | | | | | | | | | | | | | | | | | | 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-87/+0
| | | | | | | | | | | | | | | | | | | | | | | | 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
* category random replaced by a more generic category : list. You give a listplegall2004-11-151-21/+21
| | | | | | | | | | | | | of element identifiers and it creates a page virtual temporary category. random.php generates a randomized list of element id visible to the user (according to permissions) and redirects to category.php. Major problem : elements order is in id ascending order, I don't know how to change order when having id1,id2,id3 and id2,id3,id1 (the display order is the same) git-svn-id: http://piwigo.org/svn/trunk@605 68402e56-0260-453c-a942-63ccdbb3a9ee
* - since categories.site_id can be NULL (for virtual categories), virtualplegall2004-11-151-24/+63
| | | | | | | | | | | categories could not be displayed because of a join query with sites table - get_cat_info function refactored - new function get_subcat_ids based on regular expression query git-svn-id: http://piwigo.org/svn/trunk@603 68402e56-0260-453c-a942-63ccdbb3a9ee
* - admin/cat_options page added : manage options for the whole categoriesplegall2004-11-131-3/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-20/+62
| | | | | | | | | | 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-17/+21
| | | | | | | | | features - by default, DEBUG is set to 0 (off) git-svn-id: http://piwigo.org/svn/trunk@587 68402e56-0260-453c-a942-63ccdbb3a9ee
* - refactoring of comments.phpz0rglub2004-10-231-9/+11
| | | | | | | | | | | | | | | | | - creation of function get_thumbnail_src used everywhere a thumbnail must be displayed - creation of function parse_comment_content (used in comments.php and picture.php) - concerning undefined index on arrays retrieved in database, instead of testing possibly unset values, use of @ operator (smarter...) - add pre tag in default.css stylesheet for debugging purpose (need to have left aligned text) git-svn-id: http://piwigo.org/svn/trunk@579 68402e56-0260-453c-a942-63ccdbb3a9ee
* - new special category : random picturesz0rglub2004-09-011-3/+24
| | | | | | | | | | | | | - reorganisation of special categories menu : template is used only for template. A special category is presented as the template tells to do so. - favorites becomes just another special category - bug correction for best rated category : wrong MySQL query if user has forbidden categories (see include/functions_category.inc.php diff) git-svn-id: http://piwigo.org/svn/trunk@510 68402e56-0260-453c-a942-63ccdbb3a9ee
* add rating featurez0rglub2004-08-301-0/+38
| | | | git-svn-id: http://piwigo.org/svn/trunk@507 68402e56-0260-453c-a942-63ccdbb3a9ee
* deletion of a debug instructionz0rglub2004-08-291-1/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@503 68402e56-0260-453c-a942-63ccdbb3a9ee
* search in sub-categories option is availablez0rglub2004-08-291-4/+36
| | | | git-svn-id: http://piwigo.org/svn/trunk@502 68402e56-0260-453c-a942-63ccdbb3a9ee
* Call to get_plain_structure() replaced by a call to get_user_plain_structure()gweltas2004-08-291-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@499 68402e56-0260-453c-a942-63ccdbb3a9ee
* possibility to choose the date field you want to use for calendar categoryz0rglub2004-08-261-5/+3
| | | | | | | (date_available or date_creation). git-svn-id: http://piwigo.org/svn/trunk@497 68402e56-0260-453c-a942-63ccdbb3a9ee
* - Deletion of obsolete functions in the administrative partgweltas2004-08-251-2/+2
| | | | | | | - Repair of virtual category management git-svn-id: http://piwigo.org/svn/trunk@496 68402e56-0260-453c-a942-63ccdbb3a9ee
* add in comment another possibility for counting user total number ofz0rglub2004-08-211-1/+12
| | | | | | | viewable elements (counting only once pictures linked to several categories) git-svn-id: http://piwigo.org/svn/trunk@490 68402e56-0260-453c-a942-63ccdbb3a9ee
* replacement of short_period with recent_periodz0rglub2004-07-271-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@460 68402e56-0260-453c-a942-63ccdbb3a9ee
* use new search URL variablez0rglub2004-07-261-34/+115
| | | | git-svn-id: http://piwigo.org/svn/trunk@456 68402e56-0260-453c-a942-63ccdbb3a9ee
* - code refactoringz0rglub2004-06-251-11/+28
| | | | | | | | - for calendar category, adds the support of the day request (displays the list of category for this day) git-svn-id: http://piwigo.org/svn/trunk@442 68402e56-0260-453c-a942-63ccdbb3a9ee
* - new category added : recent_catsz0rglub2004-06-181-1/+10
| | | | git-svn-id: http://piwigo.org/svn/trunk@437 68402e56-0260-453c-a942-63ccdbb3a9ee
* replace recent category by recent_pics (to have a difference withz0rglub2004-06-161-4/+4
| | | | | | | recent_cats) git-svn-id: http://piwigo.org/svn/trunk@434 68402e56-0260-453c-a942-63ccdbb3a9ee
* - adds calendar categoryz0rglub2004-06-151-8/+48
| | | | git-svn-id: http://piwigo.org/svn/trunk@429 68402e56-0260-453c-a942-63ccdbb3a9ee
* table user_category droppedz0rglub2004-05-281-30/+60
| | | | git-svn-id: http://piwigo.org/svn/trunk@423 68402e56-0260-453c-a942-63ccdbb3a9ee
* deletion empty line out of PHP boundsz0rglub2004-03-261-1/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@395 68402e56-0260-453c-a942-63ccdbb3a9ee
* - Template migrationgweltas2004-03-261-29/+13
| | | | | | | | - Admin Control Panel migration - Category management git-svn-id: http://piwigo.org/svn/trunk@394 68402e56-0260-453c-a942-63ccdbb3a9ee
* deletion of expand string in $_GET arrayz0rglub2004-03-051-24/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@387 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
* Merge of the 1.3.1 releasegweltas2004-02-021-184/+171
| | | | | | | | | 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
* A category can have its representative picturez0rglub2003-09-191-1/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@133 68402e56-0260-453c-a942-63ccdbb3a9ee
* Removing debug codez0rglub2003-09-091-1/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@83 68402e56-0260-453c-a942-63ccdbb3a9ee
* - Creation of plain structure if not existing in several functionsz0rglub2003-09-061-5/+29
| | | | | | | | | | | | - Change in SQL request about restrictions : using "AND category_id NOT IN (x,y,z)" instead of "AND category_id != x AND category_id != y AND category_id != z" - For search and most recent category, using "COUNT(DISTINCT(id))" instead of "COUNT(*)" and using JOIN with image_category table git-svn-id: http://piwigo.org/svn/trunk@67 68402e56-0260-453c-a942-63ccdbb3a9ee
* Correcting a bug in special categories (favorites, most seen, mostz0rglub2003-09-051-2/+2
| | | | | | | | recent... non numeric categories) : when a picture is linked to more than one category, it's only displayed once. git-svn-id: http://piwigo.org/svn/trunk@64 68402e56-0260-453c-a942-63ccdbb3a9ee
* Multi categories for the same picturez0rglub2003-08-301-36/+59
| | | | 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