aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (follow)
Commit message (Collapse)AuthorAgeFilesLines
...
* Modification: new data model for history, more compact, more efficient. Aplegall2007-01-161-0/+88
| | | | | | | | | | | | | | | | | | | | summary table is used as cache for history stats display. New: a Perl script fill_history.pl was added to simulate a high load on history table (making the efficiency of the new data model obvious). Modification: function prepend_append_array_items moved from include/functions_search.inc.php to include/functions_search.inc.php since this function is used in new file admin/history.php Modification: admin/images/*_stats.img.php replaced by a simpler and more generic admin/images/stats.img.php unique file. New: a history detail search page was added. Currently, only start and end dates can be modified, it's just a beginning. git-svn-id: http://piwigo.org/svn/trunk@1727 68402e56-0260-453c-a942-63ccdbb3a9ee
* Upgrade feed correct I hope 8-)vdigital2006-12-161-4/+4
| | | | git-svn-id: http://piwigo.org/svn/trunk@1669 68402e56-0260-453c-a942-63ccdbb3a9ee
* Upgrade Feed correctedvdigital2006-12-161-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@1668 68402e56-0260-453c-a942-63ccdbb3a9ee
* Updrade_feed correctedvdigital2006-12-161-0/+65
| | | | git-svn-id: http://piwigo.org/svn/trunk@1667 68402e56-0260-453c-a942-63ccdbb3a9ee
* Parse error correctedvdigital2006-12-161-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@1666 68402e56-0260-453c-a942-63ccdbb3a9ee
* Admin part in coding review status.vdigital2006-12-161-0/+44
| | | | git-svn-id: http://piwigo.org/svn/trunk@1663 68402e56-0260-453c-a942-63ccdbb3a9ee
* forgot db #config upgradervelices2006-12-131-0/+44
| | | | git-svn-id: http://piwigo.org/svn/trunk@1653 68402e56-0260-453c-a942-63ccdbb3a9ee
* - remove #user_cache_categories.is_child_date_lastrvelices2006-12-071-0/+50
| | | | | | | | - optimize code in get_icon - correct css font-wigth:italic to font-style:italic - aditionnal check on $conf['authorize_remembering'] before allowing auto_login git-svn-id: http://piwigo.org/svn/trunk@1641 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fixed: Use old $conf to insert in #_configrub2006-12-041-1/+3
| | | | | | | | Only to help for next migration See http://svn.gna.org/viewcvs/phpwebgallery?rev=1565&view=rev git-svn-id: http://piwigo.org/svn/trunk@1634 68402e56-0260-453c-a942-63ccdbb3a9ee
* Improve database update of svn:1624rub2006-12-021-0/+7
| | | | git-svn-id: http://piwigo.org/svn/trunk@1626 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved Issue ID 0000299:rub2006-12-011-0/+60
| | | | | | | | | | | o Add (new) icon of parent category with children categories including new images o Improved display text for images count o Improved (a little) mass_* functions More explications on the forum. You must call directly upgrade_feep.php (http://127.0.0.1/BSF/upgrade_feed.php for example) git-svn-id: http://piwigo.org/svn/trunk@1624 68402e56-0260-453c-a942-63ccdbb3a9ee
* get rid of #users.auto_login_keyrvelices2006-12-011-0/+47
| | | | git-svn-id: http://piwigo.org/svn/trunk@1622 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 440: send mail to admin when comment is enteredrvelices2006-11-221-0/+62
| | | | git-svn-id: http://piwigo.org/svn/trunk@1617 68402e56-0260-453c-a942-63ccdbb3a9ee
* plugins go now in the #plugins tablervelices2006-10-311-0/+60
| | | | git-svn-id: http://piwigo.org/svn/trunk@1584 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved Issue ID 0000526:rub2006-10-301-0/+55
| | | | | | | | | | o Add default group to new user Allow to have n default groups. Property are save on table #_group and can be modified on administration group screen. git-svn-id: http://piwigo.org/svn/trunk@1583 68402e56-0260-453c-a942-63ccdbb3a9ee
* plugins: first prototype versionrvelices2006-10-261-0/+47
| | | | git-svn-id: http://piwigo.org/svn/trunk@1578 68402e56-0260-453c-a942-63ccdbb3a9ee
* fix a previous upgrade (username column was not binary)rvelices2006-10-241-0/+47
| | | | git-svn-id: http://piwigo.org/svn/trunk@1575 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 564: logs in the history table each user login rvelices2006-10-191-0/+52
| | | | | | | feature 562: possibility to log page visits for any combination of administrators/users/guests git-svn-id: http://piwigo.org/svn/trunk@1565 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 169: each category can have its own image orderrvelices2006-07-261-0/+46
| | | | git-svn-id: http://piwigo.org/svn/trunk@1500 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved Issue ID 0000474:rub2006-07-251-0/+46
| | | | | | | | o Delete old files index.htm git-svn-id: http://piwigo.org/svn/trunk@1497 68402e56-0260-453c-a942-63ccdbb3a9ee
* fix bug 486: field username too smallnikrou2006-07-251-0/+47
| | | | git-svn-id: http://piwigo.org/svn/trunk@1495 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 451 fixed: problem with auto loginnikrou2006-07-231-0/+47
| | | | | | | | | | - add an auto_login_key in users_table - $conf['session_length'] is no more useful and sessions length will be 0 (until browser closed) - add $conf['remember_me_name'] for cookie remember name git-svn-id: http://piwigo.org/svn/trunk@1493 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved Issue ID 0000474 (Step 1):rub2006-07-181-0/+35
| | | | | | | | | | | | | o Rename index.htm into index.php o Add index.php on all sub-directories o Use an uniform source code of index.php (like /include/index.php) (/index.php is of course not changed) git-svn-id: http://piwigo.org/svn/trunk@1481 68402e56-0260-453c-a942-63ccdbb3a9ee
* manual merge -r1344:1345 from branch 1.6 to trunk (bug 401 fixed)plegall2006-06-131-0/+51
| | | | git-svn-id: http://piwigo.org/svn/trunk@1346 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge -r1310:1311 from branch 1.6 to trunk (bug 365 fixed)plegall2006-05-151-0/+50
| | | | git-svn-id: http://piwigo.org/svn/trunk@1312 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge -r1157:1158 from branch-1_6 into trunk (images_i1 comes back)plegall2006-04-131-0/+50
| | | | git-svn-id: http://piwigo.org/svn/trunk@1159 68402e56-0260-453c-a942-63ccdbb3a9ee
* improvement: urls for tags can contain now only the tag or the id and tagrvelices2006-04-061-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
* image sort order for tagsrvelices2006-04-051-1/+3
| | | | | | very minor code and language simplifications and corrections git-svn-id: http://piwigo.org/svn/trunk@1125 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature deleted: code for categories link was too complicated for such aplegall2006-04-042-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
* improvement: tags replace keywords. Better data model, lessplegall2006-04-021-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
* [NBM] Step 7: Add functionalities subscribe/unsubscribe:rub2006-04-011-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
* [NBM] Step 4: Screen NBM is availablerub2006-03-261-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
* Step 7 improvement issue 0000301:rub2006-03-161-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
* feature 262: new user cached information nb_total_picturesrvelices2006-03-151-0/+50
| | | | git-svn-id: http://piwigo.org/svn/trunk@1081 68402e56-0260-453c-a942-63ccdbb3a9ee
* Step 1 improvement issue 0000127:rub2006-03-131-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
* bug 255: parameter values in #config limited to 255 chars (value becomes text)rvelices2006-03-091-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
* Step 1 improvement issue 0000301:rub2006-03-081-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
* bug fixed: table #categories_link was created with an hardcoded prefixplegall2006-03-051-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
* new feature: source/destination links between categories. Will we keep thisplegall2006-03-042-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
* feature 264: gallery_url, rate and rate_anonymous from config file to databaservelices2006-02-161-0/+88
| | | | git-svn-id: http://piwigo.org/svn/trunk@1044 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 251: Rating For Anonymous usersrvelices2006-02-141-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
* [NBM] Step 2: Add new table user_mail_notification (update, install, ↵rub2006-02-061-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
* feature 280: Allow visitors/users to choose image ordering inside a categoryrvelices2006-02-011-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
* Search engine redesign, first part :plegall2006-01-201-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
* bug fix 261: improve security of sessions (next to svn:1004):nikrou2006-01-181-0/+57
| | | | | | | - improve presentation code style - add upgrade database file git-svn-id: http://piwigo.org/svn/trunk@1007 68402e56-0260-453c-a942-63ccdbb3a9ee
* Database modification on users template preference with the new templateplegall2005-12-031-0/+78
| | | | | | | directory tree. git-svn-id: http://piwigo.org/svn/trunk@965 68402e56-0260-453c-a942-63ccdbb3a9ee
* - new: system to notify and upgrade database among developersplegall2005-11-241-0/+46
git-svn-id: http://piwigo.org/svn/trunk@953 68402e56-0260-453c-a942-63ccdbb3a9ee