aboutsummaryrefslogtreecommitdiffstats
path: root/include/functions_category.inc.php (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Bug 1763 fixed : [PostgreSQL] double quote used in queriesnikrou2010-07-051-1/+1
| | | | | | Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6665 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1755 fixed : Needs single quotes in queries official pluginsnikrou2010-07-031-1/+1
| | | | | | Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6655 68402e56-0260-453c-a942-63ccdbb3a9ee
* increase copyright year to 2010plegall2010-03-191-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@5196 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix some sql issues :nikrou2010-03-191-0/+4
| | | | | | | - permalink that use if() syntax - add tables themes for other database engines that mysql git-svn-id: http://piwigo.org/svn/trunk@5192 68402e56-0260-453c-a942-63ccdbb3a9ee
* -fix language keys problemsrvelices2010-03-181-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@5178 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1451 : fix mispelling and missing translationsnikrou2010-03-031-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@5036 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1451 : localization with gettextnikrou2010-03-021-4/+4
| | | | | | | | | | | Use php-gettext (developpement version rev43, because of php5.3) as fallback Use native language (english) instead of key for translation Keep directory en_UK for english customization Need some refactoring for plurals Todo : managing plugins in the same way git-svn-id: http://piwigo.org/svn/trunk@5021 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255: modification in sql queriesnikrou2009-11-251-1/+1
| | | | | | | | | - manage random function - manage regex syntax - manage quote (single instead of double) - manage interval git-svn-id: http://piwigo.org/svn/trunk@4367 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1244 resolvednikrou2009-11-201-8/+8
| | | | | | | | Replace all mysql functions in core code by ones independant of database engine Fix small php code synxtax : hash must be accessed with [ ] and not { }. git-svn-id: http://piwigo.org/svn/trunk@4325 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1241 resolved. replace mysql_fetch_array by mysql_fetch_assoc for ↵nikrou2009-11-151-4/+4
| | | | | | small php code improvements git-svn-id: http://piwigo.org/svn/trunk@4265 68402e56-0260-453c-a942-63ccdbb3a9ee
* Move get_icon function.patdenice2009-03-111-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@3188 68402e56-0260-453c-a942-63ccdbb3a9ee
* Remove get_html_menu_category function and use smarty abilities.patdenice2009-03-041-1/+24
| | | | git-svn-id: http://piwigo.org/svn/trunk@3171 68402e56-0260-453c-a942-63ccdbb3a9ee
* Administration: happy new year 2009, all PHP headers updated. plegall2009-01-041-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@3049 68402e56-0260-453c-a942-63ccdbb3a9ee
* - merge rev 2765,2769 from branch 2.0rvelices2008-10-181-2/+3
| | | | | | | | * 2765 mysql potential injection paranoia + code compaction in common.inc.php * 2769 added an image sort order by privacy level (admins only) * 2769 fix an IE6 display issue with quick search on index page git-svn-id: http://piwigo.org/svn/trunk@2770 68402e56-0260-453c-a942-63ccdbb3a9ee
* - sql optim: do not include category_cats (which makes a query) if current ↵rvelices2008-09-251-0/+2
| | | | | | | | category does not have children (info known when building menubar) - in index.php - fill the template completely before including menubar/category_cats/thumbnails (some themes might want to use in the menubar some vars ...) git-svn-id: http://piwigo.org/svn/trunk@2586 68402e56-0260-453c-a942-63ccdbb3a9ee
* - removed #debug css rule (why would we need that in default-layout?)rvelices2008-09-231-1/+1
| | | | | | | | - order by rank is not available in calendar/chronology mode - small non-functional change in functions_search.inc.php (handy for plugin) - unused variables/smaller code/unused params in func call git-svn-id: http://piwigo.org/svn/trunk@2572 68402e56-0260-453c-a942-63ccdbb3a9ee
* - images.file categories.permalink old_permalinks.permalink - become binaryrvelices2008-09-121-4/+5
| | | | | | | | | | | | | | - session security improvement: now the sessions are valid only for originating ip addr (with mask 255.255.0.0 to allow users behind load balancing proxies) -> stealing the session cookie is almost a non issue (with the exception of the 65536 machines in range) - metadata sync from the sync button does not overwrite valid data with empty metadata - other small fixes/enhancements: - added event get_category_image_orders - fix display issue with redirect.tpl (h1/h2 within h1) - fix known_script smarty function registration - query search form not submitted if q is empty - better admin css rules - some other minor changes (ws_core, rest_handler, functions_search...) git-svn-id: http://piwigo.org/svn/trunk@2521 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 169 added: ability to manually sort images inside a category. Aplegall2008-09-111-3/+9
| | | | | | | | | dedicated screen let the administrator sort the images (pur HTML, no JavaScript yet). The "rank" sort order is available only for a category without flat mode. New database column image_category.rank. git-svn-id: http://piwigo.org/svn/trunk@2517 68402e56-0260-453c-a942-63ccdbb3a9ee
* Merge from branch-1_7 (r2432).patdenice2008-07-121-1/+8
| | | | | | | Add triggers for category name (render_category_name). Add strip_tags for ALT attribute on category thumbnail. git-svn-id: http://piwigo.org/svn/trunk@2433 68402e56-0260-453c-a942-63ccdbb3a9ee
* - merge r2355 from 1.7 to trunk: fix display of menubar related tags in IE7rvelices2008-05-231-4/+3
| | | | | | | | - optimized sql query in permalinks - remove some unused global variable declarations - fix bug in admin/themeconf.inc.php git-svn-id: http://piwigo.org/svn/trunk@2356 68402e56-0260-453c-a942-63ccdbb3a9ee
* Change some PhpWebGallery to Piwigo.rub2008-05-141-2/+2
| | | | | | Not all PhpWebGallery has been translated! git-svn-id: http://piwigo.org/svn/trunk@2339 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved issue 0000823: Enhance upload functionalitiesrub2008-05-021-0/+55
| | | | | | | | | | | | | | | First commit, others will be follow. Not hesitate to change my translations. Add upload configuration tabsheet (move and add configuration) Change and add define for access level Can show upload link every time Can restrict access upload.class.php Can choice category on upload page Add upload class not use for the moment Review quickly and temporary style of upload.tpl git-svn-id: http://piwigo.org/svn/trunk@2325 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug fixed: as rvelices notified me by email, my header replacement script wasplegall2008-04-051-24/+0
| | | | | | | | | | | | bugged (r2297 was repeating new and old header). By the way, I've also removed the replacement keywords. We were using them because it was a common usage with CVS but it is advised not to use them with Subversion. Personnaly, it is a problem when I search differences between 2 Piwigo installations outside Subversion. git-svn-id: http://piwigo.org/svn/trunk@2299 68402e56-0260-453c-a942-63ccdbb3a9ee
* Modification: new header on PHP files, PhpWebGallery renamed Piwigo.plegall2008-04-041-0/+21
| | | | git-svn-id: http://piwigo.org/svn/trunk@2297 68402e56-0260-453c-a942-63ccdbb3a9ee
* - remove compatibility with old template ...rvelices2008-03-231-32/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@2290 68402e56-0260-453c-a942-63ccdbb3a9ee
* - upload.tpl goes smartyrvelices2008-03-081-2/+2
| | | | | | | - start some language cleanup and a small attempt to standardize a bit ... - debug_language now calls trigger_error instead of echo when missing language key git-svn-id: http://piwigo.org/svn/trunk@2265 68402e56-0260-453c-a942-63ccdbb3a9ee
* - migrate many templates to smartyrvelices2008-02-281-1/+23
| | | | git-svn-id: http://piwigo.org/svn/trunk@2223 68402e56-0260-453c-a942-63ccdbb3a9ee
* - render_category_description and render_category_literal_description events ↵rvelices2007-10-021-8/+2
| | | | | | refactoring git-svn-id: http://piwigo.org/svn/trunk@2117 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge -r2069 from branch-1_7 to trunkrvelices2007-07-191-6/+10
| | | | | | added 2 events: get_categories_menu_sql_where and get_html_menu_category in order to allow personalisation of the category menu git-svn-id: http://piwigo.org/svn/trunk@2070 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 713: allow permalinks to contain the slash ("/") characterrvelices2007-06-281-31/+34
| | | | git-svn-id: http://piwigo.org/svn/trunk@2047 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 657: permalinks for categoriesrvelices2007-02-281-18/+71
| | | | git-svn-id: http://piwigo.org/svn/trunk@1866 68402e56-0260-453c-a942-63ccdbb3a9ee
* - refactoring page['category'] before 1.7 releaservelices2007-02-271-28/+19
| | | | | | | | | page['category'] is not an id anymore, but an associative array of category info all of page['cat_xxx'] or page['uppercats'] merged into one simplifies calls to make_index_url give plugins a clean start for page variables for version 1.7 git-svn-id: http://piwigo.org/svn/trunk@1861 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix bug on my revision 1851.rub2007-02-231-2/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@1854 68402e56-0260-453c-a942-63ccdbb3a9ee
* o Proposition: improved display of 'x images in y sub-categories' or 'x ↵rub2007-02-221-5/+14
| | | | | | | | images in this category' for cases when categories contain both images and sub-categories o Good idea of this new way for way conf['guest_access'], but I kept last implementation for access methods (Could be useful on future development) git-svn-id: http://piwigo.org/svn/trunk@1851 68402e56-0260-453c-a942-63ccdbb3a9ee
* - without subcatify, category thumbnail alt text is 'x images in y ↵rvelices2007-02-201-9/+5
| | | | | | | | | sub-categories' - improved display of 'x images in y sub-categories' or 'x images in this category' for cases when categories contain both images and sub-categories - small lang improvement (plural 'Images within the' instead 'Image within the') git-svn-id: http://piwigo.org/svn/trunk@1840 68402e56-0260-453c-a942-63ccdbb3a9ee
* There are no filter enabled if filter configuration is empty (no icon, no ↵rub2007-01-151-1/+4
| | | | | | | | | | | | | functions, ...) New system for the filter page configuration View mode flat_recent_cat becomes flat_cat (recent period is removed because global filter is sufficient) Recent period of global filter must be defined "after" start parameter (default value is $user['recent_period']). git-svn-id: http://piwigo.org/svn/trunk@1722 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature Issue ID 0000601: Filter all public pages with only recent elementsrub2006-12-211-17/+28
| | | | | | | | | | | | | | | | | | | | | It's a finalized version. Obsolete code of draft are removed. You can filter categories and images with recent date period on your screen selection. In the future, filter could be easy done on other type data (plugin?) You can flat categories and sub-categories with a recent date period of your choice. Next, perhaps, a panel to choice recent date for the 2 features. On draft, there have problem with MySql 5, be careful! Css problem not resolved: - Menu "Categories" is bad centered - Icon on dark too on the top git-svn-id: http://piwigo.org/svn/trunk@1677 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature Issue ID 0000601: Filter all public pages with only recent elementsrub2006-12-131-3/+3
| | | | | | | | | | | | Last draft before final development. There a icon for global mode and one other for local mode. Counters are not good, filter on images are not everywhere applied, moment to update cache are not optimized, ... Go to http://forum.phpwebgallery.net/viewtopic.php?id=9490 git-svn-id: http://piwigo.org/svn/trunk@1651 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature Issue ID 0000601: Filter all public pages with only recent elementsrub2006-12-101-5/+15
| | | | | | | | | | | | | | It's a draft of the feature witch allows to show only recent elements. Development are not finished. Queries and special pages (best rates, tags, etc.) are not modified. Only main php files about images and categories are ok. Before to continue, I prefer to determinate a solution between modify cache implementation or hide counters. Go to http://forum.phpwebgallery.net/viewtopic.php?pid=50015#p50015 git-svn-id: http://piwigo.org/svn/trunk@1648 68402e56-0260-453c-a942-63ccdbb3a9ee
* - remove #user_cache_categories.is_child_date_lastrvelices2006-12-071-4/+3
| | | | | | | | - optimize code in get_icon - correct css font-wigth:italic to font-style:italic - aditionnal check on $conf['authorize_remembering'] before allowing auto_login git-svn-id: http://piwigo.org/svn/trunk@1641 68402e56-0260-453c-a942-63ccdbb3a9ee
* Proposition of translations about:rub2006-12-061-2/+2
| | | | | | | | | | | A recent picture is a last picture but a last picture is not a recent picture. A recent category is a last category but a last category is not a recent category. So it's a proposition about last is not like recent. Improvement of string including decimal number in order to concord singular and plural. Now, function l10n_dec must be used. git-svn-id: http://piwigo.org/svn/trunk@1637 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved Issue ID 0000299:rub2006-12-011-12/+51
| | | | | | | | | | | o Add (new) icon of parent category with children categories including new images o Improved display text for images count o Improved (a little) mass_* functions More explications on the forum. You must call directly upgrade_feep.php (http://127.0.0.1/BSF/upgrade_feed.php for example) git-svn-id: http://piwigo.org/svn/trunk@1624 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved Issue ID 0000567:rub2006-10-211-1/+1
| | | | | | | | | | o Don't add <BR> for categories with description including <script> (See category ping-pong, ...) git-svn-id: http://piwigo.org/svn/trunk@1573 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 169: each category can have its own image orderrvelices2006-07-261-1/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@1500 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge -r1287 from branch-1_6 to trunkrvelices2006-04-281-0/+2
| | | | | | | bug 349: Nicer display messages instead of "die" when urls cannot be solved (also set 404 status code for bots) git-svn-id: http://piwigo.org/svn/trunk@1288 68402e56-0260-453c-a942-63ccdbb3a9ee
* fix: image_order cookie path fixed for url rewritingrvelices2006-03-301-15/+4
| | | | | | | | | | | | | improve: add function access_denied called when check_status or check_restrictions fail fix: french language correction fix: remove php warnings in clean_iptc_value split search functions into include/functions_search.inc.php git-svn-id: http://piwigo.org/svn/trunk@1113 68402e56-0260-453c-a942-63ccdbb3a9ee
* URL rewriting: capable of fully working with urls without ?rvelices2006-03-221-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | URL rewriting: works with image file instead of image id (change make_picture_url to generate urls with file name instead of image id) URL rewriting: completely works with category/best_rated and picture/best_rated/534 (change 'category.php?' to 'category' in make_index_url and 'picture.php?' to 'picture' in make_picture_url to see it) fix: picture category display in upper bar fix: function rate_picture variables and use of the new user type fix: caddie icon appears now on category page fix: admin element_set sql query was using storage_category_id column (column has moved to #image_categories) fix: replaced some old $_GET[xxx] with $page[xxx] fix: pictures have metadata url (use ? parameter - might change later) git-svn-id: http://piwigo.org/svn/trunk@1092 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug fixed: create_navigation_bar take into account clean URL if requested.plegall2006-03-161-1/+1
| | | | | | | | | | | | | | | | | | deletion: argument link_class (HTML class of links) in function create_navigation_bar was removed, useless since branch 1.5. bug fixed: rate_items are now a configuration parameter (set in config file) modification: new functions library functions_rate.inc.php to reduce picture.php length. bug fixed: categories were never expanded in the menu since clean URLs. bug fixed: changing pictures sorting order in main page was always rederecting to root category. git-svn-id: http://piwigo.org/svn/trunk@1084 68402e56-0260-453c-a942-63ccdbb3a9ee
* new: cleaner URL. Instead of category.php?cat=search&search=123&start=42,plegall2006-03-151-9/+6
| | | | | | | | | | | | | | | | | | | | | | | you now have category.php?/search/123/start-42. Functions make_index_url and make_picture_url build these new URLs. Functions duplicate_picture_url and duplicate_index_url provide shortcuts to URL creation. The current main page page is still category.php but this can be modified easily in make_index_url function. In this first version, no backward compatibility. Calendar definition in URL must be discussed with rvelices. improvement: picture.php redesigned. First actions like "set as representative" or "delete a comment" which all lead to a redirection. Then the page (the big mess) and includes of new sub pages to manage specific parts of the page (metadata, user comments, rates). new: with the cleaner URL comes a new terminology. $page['cat'] doesn't exist anymore. $page['section'] is among 'categories', 'tags' (TODO), 'list', 'most_seen'... And sub parameters are set : $page['category'] if $page['section'] is "categories". See URL analyse in include/section_init.inc.php for details. git-svn-id: http://piwigo.org/svn/trunk@1082 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 262: new user cached information nb_total_picturesrvelices2006-03-151-20/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@1081 68402e56-0260-453c-a942-63ccdbb3a9ee