aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (follow)
Commit message (Collapse)AuthorAgeFilesLines
* feature:2210patdenice2011-03-041-1/+1
| | | | | | Improve language management. git-svn-id: http://piwigo.org/svn/trunk@9518 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 2155 fixed: for MySQL, use the "ENGINE=MyISAM" syntax instead of theplegall2011-02-032-4/+4
| | | | | | | | deprecated "TYPE=MyISAM", so that SQL creation table statements complies with MySQL 5.5 git-svn-id: http://piwigo.org/svn/trunk@9086 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1684 fixed: the fix for bug:1683 was an "automatic repair" but it addsplegall2011-02-031-0/+63
| | | | | | | | useless code. We couldn't create a migration task on the stable branch, but on trunk this is possible. git-svn-id: http://piwigo.org/svn/trunk@9074 68402e56-0260-453c-a942-63ccdbb3a9ee
* 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