aboutsummaryrefslogtreecommitdiffstats
path: root/include/functions_category.inc.php (follow)
Commit message (Collapse)AuthorAgeFilesLines
* improvement: $page['where'] string replaced by $page['items'].plegall2006-02-121-378/+10
| | | | | | | | | | | | | | | | | | | | | | | $page['where'] was an SQL clause used to retrieve pictures in #images table. $page['items'] is the list of picture ids of the current section. improvement: function initialize_category replaced by dedicated included PHP script include/section_init.inc.php. Code was refactored to improve readibility and maintenability. $page['navigation_bar'] is now build in category.php instead of initialize_category function. Function check_cat_id was also replaced by a piece of code in the new file. The file to include to display thumbnails from category.php is now set in section_init.inc.php instead of calculated in category.php. bug fix: the test for rel="up" link for standard HTML navigation links in category menu was not working with non numeric categories, such as "favorites". improvement: function check_login_authorization removed because useless but in profile.php. git-svn-id: http://piwigo.org/svn/trunk@1036 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 77: standard navigation link - finalizedrvelices2006-02-101-9/+10
| | | | | | | | | 3 small fixes: simplified code (unnecessary $page['tab_expand']), urls in comments (at end of line nl2br issue+regex+html 4 validated) and $page['where'] correction for most_visited git-svn-id: http://piwigo.org/svn/trunk@1031 68402e56-0260-453c-a942-63ccdbb3a9ee
* - remake of Remote sites and Synchronize: rvelices2006-02-081-5/+6
| | | | | | | | | | | | | | | - 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
* - feature 280: code simplificationrvelices2006-02-011-9/+4
| | | | git-svn-id: http://piwigo.org/svn/trunk@1022 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 280: Allow visitors/users to choose image ordering inside a categoryrvelices2006-02-011-0/+37
| | | | | | | | | | | improvement 82: Viewing pictures from remote galleries does not check anymore for the high pictures (existence flag added to create_listing_file and db) correction: link element in picture is in the head instead of body (w3c spec) correction: in profile.php the current template was not selected by default git-svn-id: http://piwigo.org/svn/trunk@1020 68402e56-0260-453c-a942-63ccdbb3a9ee
* Search engine redesign, first part :plegall2006-01-201-146/+6
| | | | | | | | | | | | | | | | | | | | | - new table #search to store search rules associated to a search id. - search rules are not passed through GET anymore, the search array build in search.php is serialized in #search table, so no need to rebuild it in function include/functions_category.inc.php::category_initialize - search array build code is improved (efficiency and layout) in search.php - SQL related to search is build in a dedicated function include/functions::get_sql_search_clause - direct search author:<...>, date_avalaible:<...>, date_creation:<...>, keywords:<...> from picture.php are not available anymore. They will come back later, with improvement (new design). Same for date_*:<> in calendar calendar category. git-svn-id: http://piwigo.org/svn/trunk@1008 68402e56-0260-453c-a942-63ccdbb3a9ee
* Improve security of sessions: nikrou2006-01-151-1/+1
| | | | | | | - use only cookies to store session id on client side - use default php session system with database handler to store sessions on server side git-svn-id: http://piwigo.org/svn/trunk@1004 68402e56-0260-453c-a942-63ccdbb3a9ee
* - bug 101 fixed: correction reported from branch 1.4plegall2005-09-181-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@867 68402e56-0260-453c-a942-63ccdbb3a9ee
* - new : external authentication in another users table. Previous users tableplegall2005-08-081-14/+8
| | | | | | | | | | | | | | | | | | | | | | | | | 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
* Bug 0000101: problem with IE search on keywordsgweltas2005-04-261-1/+1
| | | | | | | The ";" character is not allowed in a IE url. It has been replaced by a "+" character. git-svn-id: http://piwigo.org/svn/trunk@773 68402e56-0260-453c-a942-63ccdbb3a9ee
* - apply category name and element name separation in calendar specialplegall2005-03-311-8/+18
| | | | | | | | | | category - change method of counting total number of viewable pictures : pictures linked to more than one category are not counted twice. git-svn-id: http://piwigo.org/svn/trunk@761 68402e56-0260-453c-a942-63ccdbb3a9ee
* - bug fixed : search on accentuated characters is possibleplegall2005-01-201-1/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@715 68402e56-0260-453c-a942-63ccdbb3a9ee
* - back to revision 1.63 + add author in fields list for allwords searchplegall2005-01-191-8/+10
| | | | git-svn-id: http://piwigo.org/svn/trunk@710 68402e56-0260-453c-a942-63ccdbb3a9ee
* - Author included in "all words" searchgweltas2005-01-181-10/+8
| | | | git-svn-id: http://piwigo.org/svn/trunk@707 68402e56-0260-453c-a942-63ccdbb3a9ee
* - the day of the week is not displayed when year is prior to 1970plegall2005-01-161-5/+8
| | | | git-svn-id: http://piwigo.org/svn/trunk@698 68402e56-0260-453c-a942-63ccdbb3a9ee
* - bug fixed : count the exact number of elements that can be displayed inplegall2005-01-151-1/+20
| | | | | | | most_visited category because it can be less than $conf['top_number'] git-svn-id: http://piwigo.org/svn/trunk@694 68402e56-0260-453c-a942-63ccdbb3a9ee
* - bug fixed : if an element is linked more than once, bug on count of totalplegall2005-01-071-1/+1
| | | | | | | elements of best rated category git-svn-id: http://piwigo.org/svn/trunk@676 68402e56-0260-453c-a942-63ccdbb3a9ee
* 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