aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (follow)
Commit message (Collapse)AuthorAgeFilesLines
* bug 3050: increase security on reset password algorithm.plegall2014-07-281-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
* feature 3103: enlarge users.id (and foreign keys user_id, added_by or ↵plegall2014-07-241-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
* feature 3095: add "comments_enable_website" param + GUImistic1002014-06-221-0/+35
| | | | git-svn-id: http://piwigo.org/svn/trunk@28764 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 3077 : improve cache invalidationmistic1002014-05-241-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
* bug 3070 make tag names case insesitive in the dbrvelices2014-04-091-0/+37
| | | | git-svn-id: http://piwigo.org/svn/trunk@28143 68402e56-0260-453c-a942-63ccdbb3a9ee
* Update headers to 2014. Happy new year!!mistic1002014-01-0580-80/+80
| | | | git-svn-id: http://piwigo.org/svn/trunk@26461 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 3009: "!= NULL" is invalid, use "IS NOT NULL" insteadmistic1002013-12-071-2/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@25816 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 3009: Don't delete 'lat' and 'lon' fields in case users try to ↵mistic1002013-12-061-8/+0
| | | | | | delete an old plugin using them (SQL crash) git-svn-id: http://piwigo.org/svn/trunk@25802 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 3009: Add 'latitude' and 'longitude' fields in images table mistic1002013-12-061-0/+72
| | | | git-svn-id: http://piwigo.org/svn/trunk@25801 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2995 missing migration task in r25372mistic1002013-11-071-0/+35
| | | | git-svn-id: http://piwigo.org/svn/trunk@25373 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 2931: revert r23675 & r23721, make element_set_ranks.php uses ASC ↵mistic1002013-07-061-0/+62
| | | | | | keyword (+ migration task) git-svn-id: http://piwigo.org/svn/trunk@23813 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 2097: wrong number of sub-albumsrvelices2013-05-261-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
* db changes for feature 2836 display # of comments/tags in menubar and ↵rvelices2013-03-231-0/+47
| | | | | | feature 2557 recent photos should never be empty git-svn-id: http://piwigo.org/svn/trunk@21801 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature:65 Add support for PHP mysqli extension, activated by default, ↵mistic1002013-01-301-0/+43
| | | | | | remove returns of link_identifier git-svn-id: http://piwigo.org/svn/trunk@20462 68402e56-0260-453c-a942-63ccdbb3a9ee
* update Piwigo headers to 2013 (the end of the world didn't occur as ↵plegall2013-01-0174-74/+74
| | | | | | expected on r12922) git-svn-id: http://piwigo.org/svn/trunk@19703 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 2794: Virtual albums are displayed in physical albums list in ↵rvelices2012-12-241-0/+35
| | | | | | synchronization tool git-svn-id: http://piwigo.org/svn/trunk@19548 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2614: on a upgraded gallery, nb_categories_page is set to 50 insteadplegall2012-12-041-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
* feature 2727: improve password security with the use of PasswordHash class.plegall2012-11-021-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
* feature 2614: pagination on albums mistic1002012-09-231-0/+35
| | | | git-svn-id: http://piwigo.org/svn/trunk@18165 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2754: Add "Email" field for user comments + mandatory "Author" mistic1002012-09-231-0/+41
| | | | git-svn-id: http://piwigo.org/svn/trunk@18164 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2380: add URL for user comment mistic1002012-08-031-0/+38
| | | | git-svn-id: http://piwigo.org/svn/trunk@17351 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 2669: cancel migration task 121mistic1002012-07-021-72/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@16275 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 2660: check guest IP on insert_user_comment (same system as rate_picture)mistic1002012-06-241-0/+38
| | | | git-svn-id: http://piwigo.org/svn/trunk@15983 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2656: rename language no_NO into nb_NOplegall2012-06-191-0/+48
| | | | git-svn-id: http://piwigo.org/svn/trunk@15841 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2650: rename language sl_SL into sl_SI according to ISO 3166-1 codesplegall2012-06-081-0/+48
| | | | git-svn-id: http://piwigo.org/svn/trunk@15609 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2632: derivatives: search and replace hotlinks inside Piwigoplegall2012-06-081-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
* feature 2632: derivatives: clean the database. Remove useless configurationplegall2012-05-311-0/+60
| | | | | | | settings and useless columns in "images" table. git-svn-id: http://piwigo.org/svn/trunk@15450 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2632: convert 2.3 thumbnails/websize/hd settings into 2.4 ↵plegall2012-05-311-0/+218
| | | | | | derivatives settings git-svn-id: http://piwigo.org/svn/trunk@15449 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2632: multiple size, upgrade task for new organization of "upload"plegall2012-05-241-0/+83
| | | | | | | and "galleries" directories git-svn-id: http://piwigo.org/svn/trunk@15288 68402e56-0260-453c-a942-63ccdbb3a9ee
* multisize hotlinks and upgrade, add <IfModule mod_rewrite.c> to htaccess contentmistic1002012-05-211-1/+5
| | | | git-svn-id: http://piwigo.org/svn/trunk@15178 68402e56-0260-453c-a942-63ccdbb3a9ee
* prefix_thumbnail and dir_thumbnail are planned for removal, must redefine a ↵mistic1002012-05-191-0/+10
| | | | | | default value for htaccess git-svn-id: http://piwigo.org/svn/trunk@15128 68402e56-0260-453c-a942-63ccdbb3a9ee
* confusion in previous commitmistic1002012-05-191-1/+3
| | | | git-svn-id: http://piwigo.org/svn/trunk@15127 68402e56-0260-453c-a942-63ccdbb3a9ee
* remove Warning when called from upgrade_feed.php, no consequence for upgrade.phpmistic1002012-05-191-0/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@15126 68402e56-0260-453c-a942-63ccdbb3a9ee
* add migration task for create/modify htaccess containing rewrite rules on ↵mistic1002012-05-191-0/+92
| | | | | | photos hotlinks git-svn-id: http://piwigo.org/svn/trunk@15124 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2604: add images.rotation at database creation (not only during upgrade)plegall2012-04-021-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@13849 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2604: support rotation on derivativesplegall2012-04-011-0/+39
| | | | git-svn-id: http://piwigo.org/svn/trunk@13843 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2598: force reset on derivative (multiple size) configuration due to ↵plegall2012-03-241-0/+48
| | | | | | new sizes XXS and XS git-svn-id: http://piwigo.org/svn/trunk@13698 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2577: bug fixed in install/db/118, remove it from piwigo_upgrade tableplegall2012-03-021-1/+4
| | | | | | | and run it once again. git-svn-id: http://piwigo.org/svn/trunk@13459 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature:2577patdenice2012-02-181-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
* feature 2567: in IMAGES_TABLE the field "name" is prefilled with the filename mistic1002012-02-101-0/+65
| | | | git-svn-id: http://piwigo.org/svn/trunk@13082 68402e56-0260-453c-a942-63ccdbb3a9ee
* multisize - added the coi (still to affine the admin ui + language)rvelices2012-02-061-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
* update Piwigo headers to 2012, last change before the expected (or not) ↵mistic1002012-01-1756-56/+56
| | | | | | apocalypse git-svn-id: http://piwigo.org/svn/trunk@12922 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature:2549 update query not working well (sic)mistic1002012-01-161-5/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@12905 68402e56-0260-453c-a942-63ccdbb3a9ee
* feaure:2379 option to display user comments sorted new>old instead of old>new mistic1002012-01-151-0/+38
| | | | git-svn-id: http://piwigo.org/svn/trunk@12894 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature:2549 Allow to disable comments for everybody mistic1002012-01-141-0/+42
| | | | git-svn-id: http://piwigo.org/svn/trunk@12887 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2548, multiple size:plegall2012-01-121-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
* fetaure 2542 replace $conf['local_data_dir'] with $conf['data_location'] and ↵rvelices2011-12-292-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
* feature 2027 implemented: the "lost password" feature was rewritten.plegall2011-08-241-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
* feature 2413 added: move gallery_url configuration parameter from database toplegall2011-08-221-0/+117
| | | | | | | local configuration file. git-svn-id: http://piwigo.org/svn/trunk@11978 68402e56-0260-453c-a942-63ccdbb3a9ee
* rename #images.average_rate to rating_scorervelices2011-08-021-0/+41
| | | | git-svn-id: http://piwigo.org/svn/trunk@11893 68402e56-0260-453c-a942-63ccdbb3a9ee