aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (unfollow)
Commit message (Collapse)AuthorFilesLines
2014-07-28bug 3050: increase security on reset password algorithm.plegall1-0/+43
* reset key has a 1-hour life * reset key is automatically deleted once used * reset key is stored as a hash Thank you effigies for code suggestions git-svn-id: http://piwigo.org/svn/trunk@29111 68402e56-0260-453c-a942-63ccdbb3a9ee
2014-07-24feature 3103: enlarge users.id (and foreign keys user_id, added_by or ↵plegall1-0/+60
author_id) from smallint (max 30k) to mediumint unsigned (max 16M) git-svn-id: http://piwigo.org/svn/trunk@29072 68402e56-0260-453c-a942-63ccdbb3a9ee
2014-06-22feature 3095: add "comments_enable_website" param + GUImistic1001-0/+35
git-svn-id: http://piwigo.org/svn/trunk@28764 68402e56-0260-453c-a942-63ccdbb3a9ee
2014-05-24feature 3077 : improve cache invalidationmistic1001-0/+45
- add "lastmodified" automatic field for categories, groups, users, tags and images tables - provide a "server key" to the client cache manager git-svn-id: http://piwigo.org/svn/trunk@28532 68402e56-0260-453c-a942-63ccdbb3a9ee
2014-04-09bug 3070 make tag names case insesitive in the dbrvelices1-0/+37
git-svn-id: http://piwigo.org/svn/trunk@28143 68402e56-0260-453c-a942-63ccdbb3a9ee
2014-01-05Update headers to 2014. Happy new year!!mistic10080-80/+80
git-svn-id: http://piwigo.org/svn/trunk@26461 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-12-07feature 3009: "!= NULL" is invalid, use "IS NOT NULL" insteadmistic1001-2/+2
git-svn-id: http://piwigo.org/svn/trunk@25816 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-12-06feature 3009: Don't delete 'lat' and 'lon' fields in case users try to ↵mistic1001-8/+0
delete an old plugin using them (SQL crash) git-svn-id: http://piwigo.org/svn/trunk@25802 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-12-06feature 3009: Add 'latitude' and 'longitude' fields in images table mistic1001-0/+72
git-svn-id: http://piwigo.org/svn/trunk@25801 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-11-07feature 2995 missing migration task in r25372mistic1001-0/+35
git-svn-id: http://piwigo.org/svn/trunk@25373 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-07-06bug 2931: revert r23675 & r23721, make element_set_ranks.php uses ASC ↵mistic1001-0/+62
keyword (+ migration task) git-svn-id: http://piwigo.org/svn/trunk@23813 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-05-26bug 2097: wrong number of sub-albumsrvelices1-0/+37
bug 2098: make number of direct sub-albums available for each user git-svn-id: http://piwigo.org/svn/trunk@22879 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-03-23db changes for feature 2836 display # of comments/tags in menubar and ↵rvelices1-0/+47
feature 2557 recent photos should never be empty git-svn-id: http://piwigo.org/svn/trunk@21801 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-01-30feature:65 Add support for PHP mysqli extension, activated by default, ↵mistic1001-0/+43
remove returns of link_identifier git-svn-id: http://piwigo.org/svn/trunk@20462 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-01-01 update Piwigo headers to 2013 (the end of the world didn't occur as ↵plegall74-74/+74
expected on r12922) git-svn-id: http://piwigo.org/svn/trunk@19703 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-12-24bug 2794: Virtual albums are displayed in physical albums list in ↵rvelices1-0/+35
synchronization tool git-svn-id: http://piwigo.org/svn/trunk@19548 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-12-04feature 2614: on a upgraded gallery, nb_categories_page is set to 50 insteadplegall1-2/+2
of the default value 12 for a new installation. git-svn-id: http://piwigo.org/svn/trunk@19281 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-11-02feature 2727: improve password security with the use of PasswordHash class.plegall1-0/+36
This class performs salt and multiple iterations. Already used in Wordpress, Drupal, phpBB and many other web applications. $conf['pass_convert'] is replaced by $conf['password_hash'] + $conf['password_verify'] git-svn-id: http://piwigo.org/svn/trunk@18889 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-09-23feature 2614: pagination on albums mistic1001-0/+35
git-svn-id: http://piwigo.org/svn/trunk@18165 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-09-23feature 2754: Add "Email" field for user comments + mandatory "Author" mistic1001-0/+41
git-svn-id: http://piwigo.org/svn/trunk@18164 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-08-03feature 2380: add URL for user comment mistic1001-0/+38
git-svn-id: http://piwigo.org/svn/trunk@17351 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-07-02bug 2669: cancel migration task 121mistic1001-72/+1
git-svn-id: http://piwigo.org/svn/trunk@16275 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-06-24bug 2660: check guest IP on insert_user_comment (same system as rate_picture)mistic1001-0/+38
git-svn-id: http://piwigo.org/svn/trunk@15983 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-06-19feature 2656: rename language no_NO into nb_NOplegall1-0/+48
git-svn-id: http://piwigo.org/svn/trunk@15841 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-06-08feature 2650: rename language sl_SL into sl_SI according to ISO 3166-1 codesplegall1-0/+48
git-svn-id: http://piwigo.org/svn/trunk@15609 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-06-08feature 2632: derivatives: search and replace hotlinks inside Piwigoplegall1-0/+197
(page_banner, covers also plugins Additional Pages and PWG Stuffs) git-svn-id: http://piwigo.org/svn/trunk@15608 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-31feature 2632: derivatives: clean the database. Remove useless configurationplegall1-0/+60
settings and useless columns in "images" table. git-svn-id: http://piwigo.org/svn/trunk@15450 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-31feature 2632: convert 2.3 thumbnails/websize/hd settings into 2.4 ↵plegall1-0/+218
derivatives settings git-svn-id: http://piwigo.org/svn/trunk@15449 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-24feature 2632: multiple size, upgrade task for new organization of "upload"plegall1-0/+83
and "galleries" directories git-svn-id: http://piwigo.org/svn/trunk@15288 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-21multisize hotlinks and upgrade, add <IfModule mod_rewrite.c> to htaccess contentmistic1001-1/+5
git-svn-id: http://piwigo.org/svn/trunk@15178 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-19prefix_thumbnail and dir_thumbnail are planned for removal, must redefine a ↵mistic1001-0/+10
default value for htaccess git-svn-id: http://piwigo.org/svn/trunk@15128 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-19confusion in previous commitmistic1001-1/+3
git-svn-id: http://piwigo.org/svn/trunk@15127 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-19remove Warning when called from upgrade_feed.php, no consequence for upgrade.phpmistic1001-0/+2
git-svn-id: http://piwigo.org/svn/trunk@15126 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-05-19add migration task for create/modify htaccess containing rewrite rules on ↵mistic1001-0/+92
photos hotlinks git-svn-id: http://piwigo.org/svn/trunk@15124 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-04-02feature 2604: add images.rotation at database creation (not only during upgrade)plegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@13849 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-04-01feature 2604: support rotation on derivativesplegall1-0/+39
git-svn-id: http://piwigo.org/svn/trunk@13843 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-03-24feature 2598: force reset on derivative (multiple size) configuration due to ↵plegall1-0/+48
new sizes XXS and XS git-svn-id: http://piwigo.org/svn/trunk@13698 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-03-02feature 2577: bug fixed in install/db/118, remove it from piwigo_upgrade tableplegall1-1/+4
and run it once again. git-svn-id: http://piwigo.org/svn/trunk@13459 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-02-18feature:2577patdenice1-0/+38
Automaticaly install smartpocket during install or upgrade. hide mobile theme from themes list on user side. git-svn-id: http://piwigo.org/svn/trunk@13242 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-02-10feature 2567: in IMAGES_TABLE the field "name" is prefilled with the filename mistic1001-0/+65
git-svn-id: http://piwigo.org/svn/trunk@13082 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-02-06multisize - added the coi (still to affine the admin ui + language)rvelices1-0/+48
multisize - derivatives can be revuild from a larger derviative instead of the original git-svn-id: http://piwigo.org/svn/trunk@13038 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-01-17update Piwigo headers to 2012, last change before the expected (or not) ↵mistic10056-56/+56
apocalypse git-svn-id: http://piwigo.org/svn/trunk@12922 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-01-16feature:2549 update query not working well (sic)mistic1001-5/+1
git-svn-id: http://piwigo.org/svn/trunk@12905 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-01-15feaure:2379 option to display user comments sorted new>old instead of old>new mistic1001-0/+38
git-svn-id: http://piwigo.org/svn/trunk@12894 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-01-14feature:2549 Allow to disable comments for everybody mistic1001-0/+42
git-svn-id: http://piwigo.org/svn/trunk@12887 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-01-12feature 2548, multiple size:plegall1-0/+41
* adapt the upload script * remove the resize settings screen * add a new screen [Administration > Configuration > Options > Photo Sizes] with the ability to resize original after upload git-svn-id: http://piwigo.org/svn/trunk@12879 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-12-29fetaure 2542 replace $conf['local_data_dir'] with $conf['data_location'] and ↵rvelices2-2/+56
move combined files and image derivatives from local to _data git-svn-id: http://piwigo.org/svn/trunk@12802 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-08-24feature 2027 implemented: the "lost password" feature was rewritten.plegall1-0/+53
The algorithm is highly inspired from WordPress : 1) in a single field, you give a username or an email 2) Piwigo sends an email with the activation key 3) the user clicks on the link in the email (with the activation key) and is able to set a new password The "lost password" feature is no longer limited to "classic" users: administrators and webmasters can use it too (no need to tell webmasters that they can only change their password in the database) git-svn-id: http://piwigo.org/svn/trunk@11992 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-08-22feature 2413 added: move gallery_url configuration parameter from database toplegall1-0/+117
local configuration file. git-svn-id: http://piwigo.org/svn/trunk@11978 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-08-02rename #images.average_rate to rating_scorervelices1-0/+41
git-svn-id: http://piwigo.org/svn/trunk@11893 68402e56-0260-453c-a942-63ccdbb3a9ee