aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (unfollow)
Commit message (Collapse)AuthorFilesLines
2006-05-15bug 365 fixed: categories.rank was limited to 255 due to storageplegall1-0/+50
limitation. Maximum is 65535 now (should be good for a long time). git-svn-id: http://piwigo.org/svn/branches/branch-1_6@1311 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-19bug fixed: during installation, upgrades from install/db with complexplegall22-1569/+0
identifier (X.x) were not correctly inserted. bug fixed: available upgrades from install/db need to be inserted in #upgrade table. deletion: all upgrades from install/db coming from trunk are removed. new: complete upgrade from any previous release from 1.3.0 to 1.5.2 with automatic detection detection of the previous release. git-svn-id: http://piwigo.org/svn/branches/branch-1_6@1209 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-13bug fixed: images_i1 (storage_category_id) comes backplegall1-0/+50
git-svn-id: http://piwigo.org/svn/branches/branch-1_6@1158 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-06improvement: urls for tags can contain now only the tag or the id and tagrvelices1-0/+58
improvement: urls for category can be now id and category names (instead of only id) improvement: added 2 indexes (#image_tag.tag_id and #tags.url_name) improvement: identification, register, search pages automatically set focus on first form input improvement: focus, nofocus css class now valid for all forms fix: category comment is tag stripped in category_subcats.inc.php (otherwise issues with html/scripts inside category comment) git-svn-id: http://piwigo.org/svn/trunk@1131 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-05image sort order for tagsrvelices1-1/+3
very minor code and language simplifications and corrections git-svn-id: http://piwigo.org/svn/trunk@1125 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-04feature deleted: code for categories link was too complicated for such aplegall2-0/+143
simple fature. Replaced by static association. Links are not persistent anymore. modification removed: #image_category.is_storage replaced by #images.storage_category_id as in branche 1.5.. git-svn-id: http://piwigo.org/svn/trunk@1121 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-02improvement: tags replace keywords. Better data model, lessplegall1-0/+151
limitations. Each image can be associated to as many tag as needed. Tags can contain non ASCII characters. Oriented navigation with tags by association. git-svn-id: http://piwigo.org/svn/trunk@1119 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-01[NBM] Step 7: Add functionalities subscribe/unsubscribe:rub1-0/+92
o reduce length of check_key o fix bugs o send mail on subscribe/unsubscribe o add and used $conf parameters o review keyword of languages o improve selection/check o can subscribe/unsubscribe with a link include on mail o fix bug mass_update collate git-svn-id: http://piwigo.org/svn/trunk@1116 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-26[NBM] Step 4: Screen NBM is availablerub1-0/+64
o Add news parameters o Add file functions_notification_by_mail.inc.php in order to use in future, these functions on php file of subscribe/unsubscribe o Write a little html help file + improve mass_update in order to used binary fields (used collate and SHOW COLUMNS FROM) git-svn-id: http://piwigo.org/svn/trunk@1105 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-16Step 7 improvement issue 0000301:rub1-0/+54
o can attribute status <= current user o define mode adviser => buttons disabled (gray on IE, not on FF) => truncated actions => display info mode adviser git-svn-id: http://piwigo.org/svn/trunk@1085 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-15feature 262: new user cached information nb_total_picturesrvelices1-0/+50
git-svn-id: http://piwigo.org/svn/trunk@1081 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-13Step 1 improvement issue 0000127:rub1-0/+63
o Add field enabled_high of table #_user_infos o Add $conf['newuser_default_enabled_high'] o Used field on picture.php git-svn-id: http://piwigo.org/svn/trunk@1078 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-09bug 255: parameter values in #config limited to 255 chars (value becomes text)rvelices1-0/+73
feature 303: page banner moved from combination of gallery_title, gallery_description and template to database (simplifies user customization) git-svn-id: http://piwigo.org/svn/trunk@1071 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-08Step 1 improvement issue 0000301:rub1-0/+103
o Change status of table #_user_infos o Don't send password to webmaster, guest, generic Next Step: o Functions Check of status o Restricted Access for user generic git-svn-id: http://piwigo.org/svn/trunk@1070 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-05bug fixed: table #categories_link was created with an hardcoded prefixplegall1-0/+69
bug fixed: on source/destination links, if an image/category association is added to a source, destinations must be filled. If an image/category association is delete from a source, the same association must be deleted in the destinations. git-svn-id: http://piwigo.org/svn/trunk@1065 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-04new feature: source/destination links between categories. Will we keep thisplegall2-0/+146
feature? Code is complicated and very few people will understand how it works... modification: #images.storage_category_id replaced by #image_category.is_storage improvement: many code refactoring to improve readibility improvement: virtual category creation code was moved to a dedicated function in order to be called from admin/cat_list.php and admin/cat_modify.php (create a new destination category) git-svn-id: http://piwigo.org/svn/trunk@1064 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-16feature 264: gallery_url, rate and rate_anonymous from config file to databaservelices1-0/+88
git-svn-id: http://piwigo.org/svn/trunk@1044 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-14feature 251: Rating For Anonymous usersrvelices1-0/+70
fix: page['items'] for favorites category and remove old use of $has_next, $has_prev in picture.php (slideshow and favorites section) optimization: one less sql query in picture.php when there are no comments display of the refresh url in redirect.tpl (useful when debugging with browser meta redirects disabled) git-svn-id: http://piwigo.org/svn/trunk@1041 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-06[NBM] Step 2: Add new table user_mail_notification (update, install, ↵rub1-0/+58
constants, delete user + Correction delete user (table user_feed missing, table sessions must be removed) git-svn-id: http://piwigo.org/svn/trunk@1028 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-01feature 280: Allow visitors/users to choose image ordering inside a categoryrvelices1-0/+50
improvement 82: Viewing pictures from remote galleries does not check anymore for the high pictures (existence flag added to create_listing_file and db) correction: link element in picture is in the head instead of body (w3c spec) correction: in profile.php the current template was not selected by default git-svn-id: http://piwigo.org/svn/trunk@1020 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-01-20Search engine redesign, first part :plegall1-0/+54
- new table #search to store search rules associated to a search id. - search rules are not passed through GET anymore, the search array build in search.php is serialized in #search table, so no need to rebuild it in function include/functions_category.inc.php::category_initialize - search array build code is improved (efficiency and layout) in search.php - SQL related to search is build in a dedicated function include/functions::get_sql_search_clause - direct search author:<...>, date_avalaible:<...>, date_creation:<...>, keywords:<...> from picture.php are not available anymore. They will come back later, with improvement (new design). Same for date_*:<> in calendar calendar category. git-svn-id: http://piwigo.org/svn/trunk@1008 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-01-18bug fix 261: improve security of sessions (next to svn:1004):nikrou1-0/+57
- improve presentation code style - add upgrade database file git-svn-id: http://piwigo.org/svn/trunk@1007 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-12-03Database modification on users template preference with the new templateplegall1-0/+78
directory tree. git-svn-id: http://piwigo.org/svn/trunk@965 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-11-24- new: system to notify and upgrade database among developersplegall1-0/+46
git-svn-id: http://piwigo.org/svn/trunk@953 68402e56-0260-453c-a942-63ccdbb3a9ee