aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (follow)
Commit message (Collapse)AuthorAgeFilesLines
* fixes #478, add new column user_infos.last_visitplegall2016-05-311-0/+40
| | | | | | This will speed up user edit popin opening, by avoiding to search in history for the last user visit. The column user_infos.last_visit_from_history true/false says if the last_visit has already been search in history (to avoid making it twice). I could have implemented the search of last_visit for all users in the migration task 149 but in case of many users and long history, it would have taken years to execute...
* happy new year 2016, all headers updatedplegall2016-01-1489-89/+89
|
* feature #392, authentication keys, history logplegall2016-01-041-0/+39
| | | | | | | | | When a user successfully performs an authentication with an auth_key, Piwigo registers it in the history table. For now, it is not shown/searchable in the history screen, but we can add it in the future and we can provide a plugin with specific details about authentication keys usage.
* feature #392, authentication key, new tableplegall2015-12-311-0/+46
|
* feature #379 multiple format, step 2: download formatsplegall2015-12-071-0/+39
| | | | | * if formats are available, replace the download link on picture.php by a switchBox with all formats * register format in the history table for future statistics
* feature #379 multiple format, step 1: add formatsplegall2015-12-031-0/+44
| | | | | | * new table piwigo_image_format (each photo can have 0 to many formats) * only compatible with synchronization for now. Formats must be in sub-directory pwg_format * formats are visible on edition page only for now
* 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
generated by cgit v1.2.3 (git 2.25.1) at 2024-05-18 08:55:05 +0000