aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (follow)
Commit message (Collapse)AuthorAgeFilesLines
* bug 270 fixed: (yes "270", submitted in 2006), time (hour:minute:second) addedplegall2011-02-031-0/+46
| | | | | | | in the date_creation field and in the synchronization from EXIF metadata. git-svn-id: http://piwigo.org/svn/trunk@9073 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 937 fixed: makes sure a user won't see the thumbnail of a photo that has aplegall2011-01-201-0/+53
| | | | | | | | | | | | 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
* Happy new year 2011plegall2011-01-1835-70/+70
| | | | | | | 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
* feature 2108 added: user upload removed from core. It will come back as aplegall2011-01-131-0/+93
| | | | | | | "new generation" user upload in the Community plugin. git-svn-id: http://piwigo.org/svn/trunk@8651 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2103 added: week may start on sunday/monday in the monthly calendarplegall2011-01-121-0/+42
| | | | git-svn-id: http://piwigo.org/svn/trunk@8626 68402e56-0260-453c-a942-63ccdbb3a9ee
* removed upgrade feed files 1-database to 60-database - they are old and ↵rvelices2011-01-0460-3493/+0
| | | | | | unused in the current upgrade process git-svn-id: http://piwigo.org/svn/trunk@8470 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2095 added: new column images.added_by (foreign key on users.id)plegall2011-01-041-0/+57
| | | | git-svn-id: http://piwigo.org/svn/trunk@8464 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2060: Remove adviser from db structure.patdenice2010-12-141-1/+1
| | | | | | Remove adviser from user_list page and some db queries. git-svn-id: http://piwigo.org/svn/trunk@8131 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2060: Add 91-database.php (set admin or webmaster advisers as normal ↵patdenice2010-12-141-0/+54
| | | | | | | | user). Remove $conf['allow_adviser'] form config_default.inc.php. git-svn-id: http://piwigo.org/svn/trunk@8127 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 1630: upgrade to Piwigo 2.1 :-)plegall2010-04-282-34/+4
| | | | | | bug 1604: only activate core themes not all themes. git-svn-id: http://piwigo.org/svn/trunk@5982 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 1502: migrate other template than yoga.patdenice2010-04-281-2/+23
| | | | git-svn-id: http://piwigo.org/svn/trunk@5981 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix some issues with database engines :nikrou2010-03-291-1/+1
| | | | | | | | - insert into syntax not correct for posgresql or sqlite - add languages table - incorrect function for row count (sqlite) git-svn-id: http://piwigo.org/svn/trunk@5452 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1535: Add language manager.patdenice2010-03-251-7/+7
| | | | git-svn-id: http://piwigo.org/svn/trunk@5357 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1535: Add languages table.patdenice2010-03-252-0/+67
| | | | | | Ready for theme manager! git-svn-id: http://piwigo.org/svn/trunk@5341 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1533: admincan activate/deactivate user customization.patdenice2010-03-241-0/+44
| | | | git-svn-id: http://piwigo.org/svn/trunk@5328 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1533: Allow activation or deactivation of download icon.patdenice2010-03-242-1/+50
| | | | | | Add display configuration for picture properties. git-svn-id: http://piwigo.org/svn/trunk@5304 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1533: Change "General" by "Options" in Configuration menu.patdenice2010-03-231-0/+54
| | | | | | | | | | | | | | | | | | | | | | | | Change "Default Display" tab by "Guest Settings" tab. Add display tab in Configuration/Option menu. Allow to activate/deactivate a lot of display features: On main page: # Display only recently posted images # Sort order # Display all elements in all sub-categories # Display a calendar by posted date # Display a calendar by creation date # Slideshow On photo page: # Show file metadata # slideshow # Add this image to your favorites # Navigation Bar # Navigation Thumbnails git-svn-id: http://piwigo.org/svn/trunk@5293 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 1522: Move config_local.inc.php to local/config/config.inc.phppatdenice2010-03-215-5/+5
| | | | git-svn-id: http://piwigo.org/svn/trunk@5215 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1522 : move database config file to local directorynikrou2010-03-212-4/+4
| | | | | | (include/config_database.inc.php becomes local/config/database.inc.php) git-svn-id: http://piwigo.org/svn/trunk@5213 68402e56-0260-453c-a942-63ccdbb3a9ee
* increase copyright year to 2010plegall2010-03-1987-87/+87
| | | | git-svn-id: http://piwigo.org/svn/trunk@5196 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 1514: bug fixed, core themes and already used themes are automaticallyplegall2010-03-171-0/+69
| | | | | | activated. git-svn-id: http://piwigo.org/svn/trunk@5157 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 1514: new screen to manage installed themes; activate, deactivate,plegall2010-03-171-0/+46
| | | | | | | | | | | | delete, set as default. plugins.class.php was merged back to a state it doesn't manage themes at all. themes.class.php was created instead, from a duplication of plugins.class.php and strongly modified then. feature 1507: the display of available themes is now much more "graphic". git-svn-id: http://piwigo.org/svn/trunk@5153 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 1502: based on Dotclear model, P@t has reorganized the way Piwigoplegall2010-03-131-0/+75
| | | | | | | manages template/theme in a simpler "theme only level" architecture. It supports multiple level inheritance. git-svn-id: http://piwigo.org/svn/trunk@5123 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 : file not needed. Job is done is install.phpnikrou2009-12-061-77/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@4433 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 : migration scriptnikrou2009-12-041-0/+77
| | | | git-svn-id: http://piwigo.org/svn/trunk@4423 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1244 resolvednikrou2009-11-208-12/+12
| | | | | | | | 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 928 resolved.nikrou2009-11-162-4/+4
| | | | | | | Replace include/mysql.inc.php by include/config_database.inc.php to be independant of database engine Rename database configurations variables by ones in $conf array. git-svn-id: http://piwigo.org/svn/trunk@4280 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1241 resolved. replace mysql_fetch_array by mysql_fetch_assoc for ↵nikrou2009-11-157-8/+8
| | | | | | small php code improvements git-svn-id: http://piwigo.org/svn/trunk@4265 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1026: Update column save author_id with valuerub2009-06-261-2/+9
| | | | | | | Check user with comment date and registration date git-svn-id: http://piwigo.org/svn/trunk@3464 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1026: Update column save author_id with valuerub2009-06-251-0/+52
| | | | git-svn-id: http://piwigo.org/svn/trunk@3459 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1026 step 2 :nikrou2009-06-231-0/+44
| | | | | | add author_id column so that guest cannot modify old users comments git-svn-id: http://piwigo.org/svn/trunk@3450 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1026 : Modify / delete comments for usersnikrou2009-06-231-0/+50
| | | | | | | | + update config table content + minor modification of Sylvia theme + need refactoring git-svn-id: http://piwigo.org/svn/trunk@3445 68402e56-0260-453c-a942-63ccdbb3a9ee
* Try to change write permission before deletion on 80-database.php (delete ↵rub2009-01-211-0/+2
| | | | | | old and unused files and directories) git-svn-id: http://piwigo.org/svn/trunk@3107 68402e56-0260-453c-a942-63ccdbb3a9ee
* Add db file upgrade feed witch not update database.rub2009-01-201-0/+986
| | | | | | 80-database.php delete old and unused files and directories between phpwebgallery-1.0.0 and Piwigo-trunk-r3105 git-svn-id: http://piwigo.org/svn/trunk@3106 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r3054 from branch 2.0 to trunkplegall2009-01-063-28/+28
| | | | | | | | Code administration: convert all text files to Unix file format (CR as eol and not CRLF) git-svn-id: http://piwigo.org/svn/trunk@3055 68402e56-0260-453c-a942-63ccdbb3a9ee
* Administration: happy new year 2009, all PHP headers updated. plegall2009-01-0480-80/+80
| | | | git-svn-id: http://piwigo.org/svn/trunk@3049 68402e56-0260-453c-a942-63ccdbb3a9ee
* - Remove advises of file removal at the end of install/upgrade.patdenice2008-11-121-29/+5
| | | | | | - Automatic change mysql.inc.php if file is writable, else purpose manual change to user. git-svn-id: http://piwigo.org/svn/trunk@2863 68402e56-0260-453c-a942-63ccdbb3a9ee
* - Webmaster or administrator can login to run upgrade.patdenice2008-11-061-4/+4
| | | | | | | | | - Inserting upgrade line in mysql.inc.php still work. - Convert espagnol upgrade file to utf8. - Minor changes in upgrade processus. - Remove all comments in pclzip.lib.php. git-svn-id: http://piwigo.org/svn/trunk@2836 68402e56-0260-453c-a942-63ccdbb3a9ee
* new: set yoga/Sylvia as default theme.plegall2008-09-271-0/+47
| | | | git-svn-id: http://piwigo.org/svn/trunk@2615 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 868 added: pwg.images.add checks if the same file has not alreadplegall2008-09-251-0/+46
| | | | | | | been uploaded. git-svn-id: http://piwigo.org/svn/trunk@2592 68402e56-0260-453c-a942-63ccdbb3a9ee
* - images.file categories.permalink old_permalinks.permalink - become binaryrvelices2008-09-121-0/+54
| | | | | | | | | | | | | | - 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-0/+46
| | | | | | | | | 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
* remove ws access table/partners functionalityrvelices2008-09-111-0/+46
| | | | git-svn-id: http://piwigo.org/svn/trunk@2516 68402e56-0260-453c-a942-63ccdbb3a9ee
* - fix issue when picture_url_style = file (sql query like) rvelices2008-09-091-0/+5
| | | | | | - sql call SET NAMES "xxx" (if required) in upgrade.php, upgrade_feed.php and after 65-database.php git-svn-id: http://piwigo.org/svn/trunk@2512 68402e56-0260-453c-a942-63ccdbb3a9ee
* - based on test_menu by grum (thanks to you) - integration of dynamic menu ↵rvelices2008-08-281-0/+48
| | | | | | | | | | bar to pwg - the menubar is composed now of dynamic blocks that can be ordered/hidden - plugins can add their own blocks git-svn-id: http://piwigo.org/svn/trunk@2488 68402e56-0260-453c-a942-63ccdbb3a9ee
* - add #user_cache.cache_update_time - useful for plugins or the filter when ↵rvelices2008-07-221-0/+46
| | | | | | it is not possible/desirable to cache/calculate data specific to the user when pwg core does it; note that this opens the possibility to implement a data cache (file/shared mem/ etc...) for every user (for very large databases) git-svn-id: http://piwigo.org/svn/trunk@2448 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature template-extension based on 2006 chrisaga's idea.vdigital2008-07-141-0/+48
| | | | | | | chrisaga wrote: "If you want to make some template customization without building a brand new template, you should use ..." git-svn-id: http://piwigo.org/svn/trunk@2434 68402e56-0260-453c-a942-63ccdbb3a9ee
* Change some PhpWebGallery to Piwigo. (2/2)rub2008-05-151-1/+1
| | | | | | | | All phpwebgallery.net are not changed! git-svn-id: http://piwigo.org/svn/trunk@2342 68402e56-0260-453c-a942-63ccdbb3a9ee
* - remove some unnecessary db columns (#history_summary.id, #history.year, ↵rvelices2008-05-061-0/+58
| | | | | | month, day and hour) git-svn-id: http://piwigo.org/svn/trunk@2333 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved issue 0000823: Enhance upload functionalitiesrub2008-05-021-0/+53
| | | | | | | | | | | | | | | 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