aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (unfollow)
Commit message (Collapse)AuthorFilesLines
2007-03-28Issue 578rub2-4/+93
User guest must be real user Step 1: guest is a real user On next commit, I finish installation and use of guest of user list and group git-svn-id: http://piwigo.org/svn/trunk@1926 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-27Modification: somes indexes were renamed to comply with PWG indexes namingplegall1-0/+82
rules, ie <table_name>_[u for unique]i<index number in table>. git-svn-id: http://piwigo.org/svn/trunk@1924 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-16Update svn properties (svn:eol-style and svn:keywords)rub51-162/+162
git-svn-id: http://piwigo.org/svn/trunk@1912 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-16Update index.php header.rub1-9/+7
Don't use explicitly index.php on the recursive call. Add missing index.php. Chang tags.php svn properties. git-svn-id: http://piwigo.org/svn/trunk@1909 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-13Fix bad default value for language on table user_inforub1-0/+51
Improve mail send (Undisclosed-recipients, switch language, ...) Improve send an email to group members (Use Bcc, template, multi-language, ...) (But need more improvements) git-svn-id: http://piwigo.org/svn/trunk@1904 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-13Updates:vdigital13-13/+13
- Copyrights 2003-2007 - help - Some HTML comform requests git-svn-id: http://piwigo.org/svn/trunk@1903 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-12Add notification when a picture is loaded.rub1-0/+66
Change little translations. Improve mail sent. git-svn-id: http://piwigo.org/svn/trunk@1901 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-12Apply property svn:eol-style Value: LFrub2-109/+109
git-svn-id: http://piwigo.org/svn/trunk@1900 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-09New: #images.high_filesize was added so that we can sum the filesizes in theplegall2-0/+116
filtered history. #images.high_filesize is filled during metadata synchronization. Bug fixed: in getAttribute XML function, when asking "filesize", it was returning high_filesize. The regex was too simple. git-svn-id: http://piwigo.org/svn/trunk@1883 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-28feature 657: permalinks for categoriesrvelices1-0/+71
git-svn-id: http://piwigo.org/svn/trunk@1866 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-22- user comments are not saved in the database with htmlspecialchars anymorervelices1-0/+60
- web service: added the possibility to enter a user comment using the service... - new comment functions from picture_comment.inc.php git-svn-id: http://piwigo.org/svn/trunk@1849 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-20New: non picture files are now logged in history when downloaded. Theplegall1-0/+73
history filter was redesigned: #history.is_high replaced by #history.image_type = high. The filter is simpler. git-svn-id: http://piwigo.org/svn/trunk@1844 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-14New: history logs high quality access via action.php. A new columnplegall1-0/+61
#history.is_high was added. Filter was added on administration history detail view. Modification: function get_sql_condition_FandF was slightly refactored for presentation improvement. git-svn-id: http://piwigo.org/svn/trunk@1817 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-08Web Service: vdigital1-0/+54
- Delete high and normal in #ws_access table - start date is kept. w0p0 template: Minor change git-svn-id: http://piwigo.org/svn/trunk@1791 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-06Issue 0000598: NBM: Add new informationsrub1-0/+58
Notification by mail: Add new informations about last categories and last images like new feature of RSS notification. 2 parts: - Possibility to send HTML mail - Include last categories and last images on HTML format into notification mail ccs & HTML experts! Please! Check, fix, improve and enhance HTML mail content! git-svn-id: http://piwigo.org/svn/trunk@1784 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-29Issue 0000614: Display hits under thumbnails like comments countervdigital1-0/+52
Include Show_nb_hits in #config and remove from config_default.inc.php git-svn-id: http://piwigo.org/svn/trunk@1767 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-28Web Service: Remove ws_status from #configvdigital1-0/+56
(Next steps: - Restrict Method need to be more generic maybe - Delete functions_webserv.inc.php - Activate $partner in ws.php - Include checked access in tools - ...) Issue 0000614: Display hits under thumbnails like comments counter - Add show_nb_hits to #user_infos git-svn-id: http://piwigo.org/svn/trunk@1761 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-23- revert feature 564: log the login of each user; but add the possibility to bervelices1-0/+50
done by a plugin - create a "standard" way to define PHP functions that we use but might not be available in the current php version - when a comment is rejected (spam, anti-flood etc), put the content back to the browser in case there is a real user behind it - now a comment can be entered only if the page was retrieved between 2 seconds ago and 1 hour ago git-svn-id: http://piwigo.org/svn/trunk@1744 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-22Index rename vdigital1-0/+52
git-svn-id: http://piwigo.org/svn/trunk@1741 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-21Bad quotes Fixed rub1-2/+2
git-svn-id: http://piwigo.org/svn/trunk@1740 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-21Inefficient and non required index is removed on #_image_category.vdigital1-0/+51
git-svn-id: http://piwigo.org/svn/trunk@1739 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-19feature 625: comment anti-spam - protect against some of the spam robotsrvelices1-0/+51
git-svn-id: http://piwigo.org/svn/trunk@1737 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-16Modification: new data model for history, more compact, more efficient. Aplegall1-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
2006-12-16Upgrade feed correct I hope 8-)vdigital1-4/+4
git-svn-id: http://piwigo.org/svn/trunk@1669 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-16Upgrade Feed correctedvdigital1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@1668 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-16Updrade_feed correctedvdigital1-0/+65
git-svn-id: http://piwigo.org/svn/trunk@1667 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-16Parse error correctedvdigital1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@1666 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-16Admin part in coding review status.vdigital1-0/+44
git-svn-id: http://piwigo.org/svn/trunk@1663 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-13forgot db #config upgradervelices1-0/+44
git-svn-id: http://piwigo.org/svn/trunk@1653 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-07- remove #user_cache_categories.is_child_date_lastrvelices1-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
2006-12-04Fixed: Use old $conf to insert in #_configrub1-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
2006-12-02Improve database update of svn:1624rub1-0/+7
git-svn-id: http://piwigo.org/svn/trunk@1626 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-01Resolved Issue ID 0000299:rub1-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
2006-12-01get rid of #users.auto_login_keyrvelices1-0/+47
git-svn-id: http://piwigo.org/svn/trunk@1622 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-11-22feature 440: send mail to admin when comment is enteredrvelices1-0/+62
git-svn-id: http://piwigo.org/svn/trunk@1617 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-10-31plugins go now in the #plugins tablervelices1-0/+60
git-svn-id: http://piwigo.org/svn/trunk@1584 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-10-30Resolved Issue ID 0000526:rub1-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
2006-10-26plugins: first prototype versionrvelices1-0/+47
git-svn-id: http://piwigo.org/svn/trunk@1578 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-10-24fix a previous upgrade (username column was not binary)rvelices1-0/+47
git-svn-id: http://piwigo.org/svn/trunk@1575 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-10-19feature 564: logs in the history table each user login rvelices1-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
2006-07-26feature 169: each category can have its own image orderrvelices1-0/+46
git-svn-id: http://piwigo.org/svn/trunk@1500 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-25Resolved Issue ID 0000474:rub1-0/+46
o Delete old files index.htm git-svn-id: http://piwigo.org/svn/trunk@1497 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-25fix bug 486: field username too smallnikrou1-0/+47
git-svn-id: http://piwigo.org/svn/trunk@1495 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-23bug 451 fixed: problem with auto loginnikrou1-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
2006-07-18Resolved Issue ID 0000474 (Step 1):rub1-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
2006-06-13manual merge -r1344:1345 from branch 1.6 to trunk (bug 401 fixed)plegall1-0/+51
git-svn-id: http://piwigo.org/svn/trunk@1346 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-05-15merge -r1310:1311 from branch 1.6 to trunk (bug 365 fixed)plegall1-0/+50
git-svn-id: http://piwigo.org/svn/trunk@1312 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-13merge -r1157:1158 from branch-1_6 into trunk (images_i1 comes back)plegall1-0/+50
git-svn-id: http://piwigo.org/svn/trunk@1159 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