aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (unfollow)
Commit message (Collapse)AuthorFilesLines
2011-06-25bug 2363 fixed: upgrade 94 should not fail when write access is missing onplegall1-5/+21
_data/plugins. When this situation occurs, we don't save the 2.1 user upload configuration and we continue the upgrade. git-svn-id: http://piwigo.org/svn/branches/2.2@11508 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-03-04feature:2210patdenice1-1/+1
Improve language management. git-svn-id: http://piwigo.org/svn/trunk@9518 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-02-03bug 2155 fixed: for MySQL, use the "ENGINE=MyISAM" syntax instead of theplegall2-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
2011-02-03bug 1684 fixed: the fix for bug:1683 was an "automatic repair" but it addsplegall1-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
2011-02-03bug 270 fixed: (yes "270", submitted in 2006), time (hour:minute:second) addedplegall1-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
2011-01-20bug 937 fixed: makes sure a user won't see the thumbnail of a photo that has aplegall1-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
2011-01-18Happy new year 2011plegall35-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
2011-01-13feature 2108 added: user upload removed from core. It will come back as aplegall1-0/+93
"new generation" user upload in the Community plugin. git-svn-id: http://piwigo.org/svn/trunk@8651 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-01-12feature 2103 added: week may start on sunday/monday in the monthly calendarplegall1-0/+42
git-svn-id: http://piwigo.org/svn/trunk@8626 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-01-04removed upgrade feed files 1-database to 60-database - they are old and ↵rvelices60-3493/+0
unused in the current upgrade process git-svn-id: http://piwigo.org/svn/trunk@8470 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-01-04feature 2095 added: new column images.added_by (foreign key on users.id)plegall1-0/+57
git-svn-id: http://piwigo.org/svn/trunk@8464 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-12-14feature 2060: Remove adviser from db structure.patdenice1-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
2010-12-14feature 2060: Add 91-database.php (set admin or webmaster advisers as normal ↵patdenice1-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
2010-04-28feature 1630: upgrade to Piwigo 2.1 :-)plegall2-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
2010-04-28feature 1502: migrate other template than yoga.patdenice1-2/+23
git-svn-id: http://piwigo.org/svn/trunk@5981 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-29Fix some issues with database engines :nikrou1-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
2010-03-25Feature 1535: Add language manager.patdenice1-7/+7
git-svn-id: http://piwigo.org/svn/trunk@5357 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-25Feature 1535: Add languages table.patdenice2-0/+67
Ready for theme manager! git-svn-id: http://piwigo.org/svn/trunk@5341 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-24Feature 1533: admincan activate/deactivate user customization.patdenice1-0/+44
git-svn-id: http://piwigo.org/svn/trunk@5328 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-24Feature 1533: Allow activation or deactivation of download icon.patdenice2-1/+50
Add display configuration for picture properties. git-svn-id: http://piwigo.org/svn/trunk@5304 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-23Feature 1533: Change "General" by "Options" in Configuration menu.patdenice1-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
2010-03-21feature 1522: Move config_local.inc.php to local/config/config.inc.phppatdenice5-5/+5
git-svn-id: http://piwigo.org/svn/trunk@5215 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-21Feature 1522 : move database config file to local directorynikrou2-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
2010-03-19increase copyright year to 2010plegall87-87/+87
git-svn-id: http://piwigo.org/svn/trunk@5196 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-17feature 1514: bug fixed, core themes and already used themes are automaticallyplegall1-0/+69
activated. git-svn-id: http://piwigo.org/svn/trunk@5157 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-17feature 1514: new screen to manage installed themes; activate, deactivate,plegall1-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
2010-03-13feature 1502: based on Dotclear model, P@t has reorganized the way Piwigoplegall1-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
2009-12-06Feature 1255 : file not needed. Job is done is install.phpnikrou1-77/+0
git-svn-id: http://piwigo.org/svn/trunk@4433 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-12-04Feature 1255 : migration scriptnikrou1-0/+77
git-svn-id: http://piwigo.org/svn/trunk@4423 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-20Feature 1244 resolvednikrou8-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
2009-11-16Feature 928 resolved.nikrou2-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
2009-11-15Feature 1241 resolved. replace mysql_fetch_array by mysql_fetch_assoc for ↵nikrou7-8/+8
small php code improvements git-svn-id: http://piwigo.org/svn/trunk@4265 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-06-26Feature 1026: Update column save author_id with valuerub1-2/+9
Check user with comment date and registration date git-svn-id: http://piwigo.org/svn/trunk@3464 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-06-25Feature 1026: Update column save author_id with valuerub1-0/+52
git-svn-id: http://piwigo.org/svn/trunk@3459 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-06-23Feature 1026 step 2 :nikrou1-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
2009-06-23Feature 1026 : Modify / delete comments for usersnikrou1-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
2009-01-21Try to change write permission before deletion on 80-database.php (delete ↵rub1-0/+2
old and unused files and directories) git-svn-id: http://piwigo.org/svn/trunk@3107 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-01-20Add db file upgrade feed witch not update database.rub1-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
2009-01-06merge r3054 from branch 2.0 to trunkplegall3-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
2009-01-04Administration: happy new year 2009, all PHP headers updated. plegall80-80/+80
git-svn-id: http://piwigo.org/svn/trunk@3049 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-11-12- Remove advises of file removal at the end of install/upgrade.patdenice1-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
2008-11-06- Webmaster or administrator can login to run upgrade.patdenice1-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
2008-09-27new: set yoga/Sylvia as default theme.plegall1-0/+47
git-svn-id: http://piwigo.org/svn/trunk@2615 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-25feature 868 added: pwg.images.add checks if the same file has not alreadplegall1-0/+46
been uploaded. git-svn-id: http://piwigo.org/svn/trunk@2592 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-12- images.file categories.permalink old_permalinks.permalink - become binaryrvelices1-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
2008-09-11feature 169 added: ability to manually sort images inside a category. Aplegall1-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
2008-09-11remove ws access table/partners functionalityrvelices1-0/+46
git-svn-id: http://piwigo.org/svn/trunk@2516 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-09- fix issue when picture_url_style = file (sql query like) rvelices1-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
2008-08-28- based on test_menu by grum (thanks to you) - integration of dynamic menu ↵rvelices1-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
2008-07-22- add #user_cache.cache_update_time - useful for plugins or the filter when ↵rvelices1-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