aboutsummaryrefslogtreecommitdiffstats
path: root/include/category_cats.inc.php (unfollow)
Commit message (Collapse)AuthorFilesLines
2011-02-08bug 2184 fixed: avoid SQL syntax error on "display only recently posted ↵plegall1-1/+2
photos" filter. git-svn-id: http://piwigo.org/svn/trunk@9116 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-01-20bug 937 fixed: makes sure a user won't see the thumbnail of a photo that has aplegall1-67/+131
higher privacy level than user privacy level. For an acceptable solution at performance level, I have implemented a cache: for a given user, each album has a representative_picture_id. This cache also avoids to perform numerous "order by rand()" SQL queries which is the case when $conf['allow_random_representative'] = true; git-svn-id: http://piwigo.org/svn/trunk@8802 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-01-18Happy new year 2011plegall1-2/+2
Change "Piwigo - a PHP based picture gallery" into "Piwigo - a PHP based photo gallery" git-svn-id: http://piwigo.org/svn/trunk@8728 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-19increase copyright year to 2010plegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@5196 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-25Feature 1255: modification in sql queriesnikrou1-5/+3
- 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
2009-11-21Feature 1255 : limit params in sql queries were in wrong order (LIMIT count ↵nikrou1-2/+2
OFFSET offset) git-svn-id: http://piwigo.org/svn/trunk@4334 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-20Feature 1244 resolvednikrou1-7/+7
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
2009-11-15Feature 1241 resolved. replace mysql_fetch_array by mysql_fetch_assoc for ↵nikrou1-1/+1
small php code improvements git-svn-id: http://piwigo.org/svn/trunk@4265 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-03-11Move get_icon function.patdenice1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@3188 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-03-09fix html warnings. unclosed monotagsnikrou1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@3185 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-02-05- removed triggers loc_index_thumbnail and loc_index_category_thumbnailrvelices1-10/+9
- changed triggers loc_end_index_thumbnails and loc_end_index_category_thumbnails from actions to events git-svn-id: http://piwigo.org/svn/trunk@3124 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-01-04Administration: happy new year 2009, all PHP headers updated. plegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@3049 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-10- fix undefined template vars U_LOST_PASSWORD (menubar), F_ACTION ↵rvelices1-8/+6
(extend_for_templates) and F_C13Y_ACTION (check_integrity) - normalized some template variable names between category thumbnails and thumbnails (take advantage of full template change with smarty and do it now) git-svn-id: http://piwigo.org/svn/trunk@2515 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-07-12Merge from branch-1_7 (r2432).patdenice1-1/+7
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
2008-07-05- feature 832: Folders with no images sql optimizationrvelices1-36/+42
- recent pics are sorted by date descending, and only then by conf['order_by'] - updated prototype.js to version 1.6 git-svn-id: http://piwigo.org/svn/trunk@2424 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-04- fix issue when random representant was truervelices1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@2330 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-03just some optimizations (especially for large dbs)rvelices1-8/+8
- replace some REGEXP with LIKE in sql - optimized queries for the combination of large data sets with picture_url_style file git-svn-id: http://piwigo.org/svn/trunk@2327 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-04-05Bug fixed: as rvelices notified me by email, my header replacement script wasplegall1-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
2008-04-04Modification: new header on PHP files, PhpWebGallery renamed Piwigo.plegall1-0/+21
git-svn-id: http://piwigo.org/svn/trunk@2297 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-03-11- remove $conf['subcatify'] (it was my reqquest to Pierrick when plugins ↵rvelices1-102/+41
were not available; now it can be done through plugin) - optimization when show_nb_comments true (1 sql query per page instead of 1 query per element) - some cleanup & more standard trigger names git-svn-id: http://piwigo.org/svn/trunk@2274 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-03-01- thumbnails.tpl migrationrvelices1-29/+8
git-svn-id: http://piwigo.org/svn/trunk@2234 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-03-01- index.tpl, menubar.tpl, mainpage_categories.tpl and month_calendar.tpl go ↵rvelices1-15/+10
smarty - better template debugging tweak (the smarty console is shown only once at the end) git-svn-id: http://piwigo.org/svn/trunk@2231 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-01-30Replace old use of $lang by l10n function.rub1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@2201 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-11-29Merge from branch-1_7: 2174patdenice1-1/+2
Add second parameter for render_category_description to differentiate both triggers in category_cats.inc.php and section_init.inc.php. Add render_page_banner trigger. git-svn-id: http://piwigo.org/svn/trunk@2175 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-10-02- render_category_description and render_category_literal_description events ↵rvelices1-5/+0
refactoring git-svn-id: http://piwigo.org/svn/trunk@2117 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-09-19merge -r 2094 from branch-1_7 to trunkrvelices1-2/+2
- fix: quick search error if the query term contained " or ' - optimized sql query in sync_users (called every time on admin page) - a lot faster when #user_cache_categories is big - added function Template->delete_block_vars (opposite of assign_block_vars) git-svn-id: http://piwigo.org/svn/trunk@2095 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-09-13- merge content of layout.css and popuphelp.css (very few lines) into ↵rvelices1-9/+6
existing css -> faster page loading the first time (avoid 2 http requests) - optimized sql for $conf['display_fromto'] in category_cats.inc.php git-svn-id: http://piwigo.org/svn/trunk@2091 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-08-25Resolved 0000728: Add description triggers for categories and elementsrub1-2/+10
Add: o render_category_description o render_category_literal_description o render_element_description Merge branch-1_7 2048:2050 into BSF git-svn-id: http://piwigo.org/svn/trunk@2079 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-04-22Add filter conditions on new sql query added for feature 660.rub1-0/+11
git-svn-id: http://piwigo.org/svn/trunk@1971 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-04-22Feature 660 added: creation date of tthe category images can be displayedplegall1-0/+63
next to category title in subcatify mode. The feature was implemented in a very simple way that must be improved in display, performance and recursivity. git-svn-id: http://piwigo.org/svn/trunk@1970 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-09Add DateTime on administration introduction page (Useful to help user on the ↵rub1-1/+1
forum, ...) Move history configuration in a other tab. Use translation on picture hint (Kb). Show hint oh the menu text (not only on counter) git-svn-id: http://piwigo.org/svn/trunk@1884 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-08- plugin administration: small fix during activation phaservelices1-2/+11
- plugins: added 3 actions in category_cats.inc.php and 1 event that allow a plugin to decide if insertion to #history occurs - added a warning in section_init if script_basename() is not index or picture (I think we'll have issues on some servers with this function) - web service methods categories.getImages, tags.getImages and images.search return now the image comment git-svn-id: http://piwigo.org/svn/trunk@1880 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-070000662: Recent elements don't use sometimes time and not truncated datetimerub1-1/+1
& Standardize system date used git-svn-id: http://piwigo.org/svn/trunk@1876 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-06permalinks: admin fix on some tricky cases when setting a new permalinks.inc.phprvelices1-1/+1
permalinks: added ability to sort the permalink tables in the admin added new action in category_cats.inc.php git-svn-id: http://piwigo.org/svn/trunk@1873 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-04Bug: Minor HTML change to keep HTML 4.01 Strict level (category_cats.inc.php)vdigital1-1/+1
New: Label over quick search (and different display solutions in themes: center, left, italic, hidden, pre-filling hidden). git-svn-id: http://piwigo.org/svn/trunk@1869 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-28feature 657: permalinks for categoriesrvelices1-2/+2
git-svn-id: http://piwigo.org/svn/trunk@1866 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-27- refactoring page['category'] before 1.7 releaservelices1-7/+5
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
2007-02-22 o Proposition: improved display of 'x images in y sub-categories' or 'x ↵rub1-2/+6
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
2007-02-20- without subcatify, category thumbnail alt text is 'x images in y ↵rvelices1-2/+6
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
2007-02-15- feature 642: display both subcategory thumbnails and element thumbnails (if arvelices1-7/+4
category has both) in the index page - get rid of $page['cat_nb_images'] and $page['thumbnails_include'] (superfluous) - changed sql queries in section_init.inc.php for better performance with flat category view - web service fixes for categories.getList git-svn-id: http://piwigo.org/svn/trunk@1820 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-15There are no filter enabled if filter configuration is empty (no icon, no ↵rub1-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
2007-01-13very small improvements:rvelices1-2/+6
- mass_inserts does not requires keys to start at 0 - recent_cats categories are sorted by global_rank (consistency) - removed warning from page_header.php (when included from redirect) - added 2 template functions for plugins (get_var and concat_var) - removed unused code from profile.php - changed css width for tag selection (search page) from 55em to almost 100% git-svn-id: http://piwigo.org/svn/trunk@1719 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-21Feature Issue ID 0000601: Filter all public pages with only recent elementsrub1-30/+41
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
2006-12-13Feature Issue ID 0000601: Filter all public pages with only recent elementsrub1-4/+4
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
2006-12-10Feature Issue ID 0000601: Filter all public pages with only recent elementsrub1-6/+33
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
2006-12-08- new function set_status_header (set http status code)rvelices1-2/+1
- correction on recent/recent_by_child icons git-svn-id: http://piwigo.org/svn/trunk@1643 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-07- remove #user_cache_categories.is_child_date_lastrvelices1-3/+4
- 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
2006-12-07Icon is showed in the same way between recent categories and recent images.rub1-2/+2
git-svn-id: http://piwigo.org/svn/trunk@1638 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-01Resolved Issue ID 0000299:rub1-10/+23
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
2006-11-08- merge category_recent_cats and category_subcats into category_cats (a lot rvelices1-53/+79
of common code,and now representative selection works for recent cats...) - some replacements of get_thumbnail_src with get_thumbnail_url git-svn-id: http://piwigo.org/svn/trunk@1597 68402e56-0260-453c-a942-63ccdbb3a9ee
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-24 11:46:14 +0000