aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (follow)
Commit message (Collapse)AuthorAgeFilesLines
* - transform some db fields from text to mediumtext (for large dbs); - ↵rvelices2008-04-301-0/+55
| | | | | | #sessions.data, #user_cache.forbidden_categories and #user_cache.image_access_list git-svn-id: http://piwigo.org/svn/trunk@2323 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug fixed: as rvelices notified me by email, my header replacement script wasplegall2008-04-0568-1682/+0
| | | | | | | | | | | | bugged (r2297 was repeating new and old header). By the way, I've also removed the replacement keywords. We were using them because it was a common usage with CVS but it is advised not to use them with Subversion. Personnaly, it is a problem when I search differences between 2 Piwigo installations outside Subversion. git-svn-id: http://piwigo.org/svn/trunk@2299 68402e56-0260-453c-a942-63ccdbb3a9ee
* Modification: new header on PHP files, PhpWebGallery renamed Piwigo.plegall2008-04-0468-0/+1428
| | | | git-svn-id: http://piwigo.org/svn/trunk@2297 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved issue 0000807: New slideshow featuresrub2008-02-271-0/+51
| | | | git-svn-id: http://piwigo.org/svn/trunk@2218 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved issue 0000792: Admin "intro" : Integrity control bypassrub2008-02-131-0/+51
| | | | | | Some sentences must be re-write ;-) git-svn-id: http://piwigo.org/svn/trunk@2208 68402e56-0260-453c-a942-63ccdbb3a9ee
* - PWG_CHARSET, DB_CHARSET and DB_COLLATE... utf-8 readyrvelices2007-10-091-0/+322
| | | | git-svn-id: http://piwigo.org/svn/trunk@2127 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved 0000748: Name configuration of all the tablesrub2007-09-191-0/+53
| | | | | | | Resolved 0000750: Check anomalies after upgrade (Feature proposition) git-svn-id: http://piwigo.org/svn/trunk@2096 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 731: permissions at image level rvelices2007-09-111-0/+76
| | | | | | - this is the first version - I wait for feedback before changing help files git-svn-id: http://piwigo.org/svn/trunk@2084 68402e56-0260-453c-a942-63ccdbb3a9ee
* Change headers with team emailrub2007-07-103-9/+3
| | | | git-svn-id: http://piwigo.org/svn/trunk@2059 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved issue 0000489: Mail address obligatoryrub2007-06-101-0/+51
| | | | git-svn-id: http://piwigo.org/svn/trunk@2032 68402e56-0260-453c-a942-63ccdbb3a9ee
* git-svn-id: http://piwigo.org/svn/trunk@1963 ↵rub2007-04-191-0/+53
| | | | 68402e56-0260-453c-a942-63ccdbb3a9ee
* Issue 578rub2007-03-282-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
* Modification: somes indexes were renamed to comply with PWG indexes namingplegall2007-03-271-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
* Update svn properties (svn:eol-style and svn:keywords)rub2007-03-1651-162/+162
| | | | git-svn-id: http://piwigo.org/svn/trunk@1912 68402e56-0260-453c-a942-63ccdbb3a9ee
* Update index.php header.rub2007-03-161-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
* Fix bad default value for language on table user_inforub2007-03-131-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
* Updates:vdigital2007-03-1313-13/+13
| | | | | | | | - Copyrights 2003-2007 - help - Some HTML comform requests git-svn-id: http://piwigo.org/svn/trunk@1903 68402e56-0260-453c-a942-63ccdbb3a9ee
* Add notification when a picture is loaded.rub2007-03-121-0/+66
| | | | | | | Change little translations. Improve mail sent. git-svn-id: http://piwigo.org/svn/trunk@1901 68402e56-0260-453c-a942-63ccdbb3a9ee
* Apply property svn:eol-style Value: LFrub2007-03-122-109/+109
| | | | git-svn-id: http://piwigo.org/svn/trunk@1900 68402e56-0260-453c-a942-63ccdbb3a9ee
* New: #images.high_filesize was added so that we can sum the filesizes in theplegall2007-03-092-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
* feature 657: permalinks for categoriesrvelices2007-02-281-0/+71
| | | | git-svn-id: http://piwigo.org/svn/trunk@1866 68402e56-0260-453c-a942-63ccdbb3a9ee
* - user comments are not saved in the database with htmlspecialchars anymorervelices2007-02-221-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
* New: non picture files are now logged in history when downloaded. Theplegall2007-02-201-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
* New: history logs high quality access via action.php. A new columnplegall2007-02-141-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
* Web Service: vdigital2007-02-081-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
* Issue 0000598: NBM: Add new informationsrub2007-02-061-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
* Issue 0000614: Display hits under thumbnails like comments countervdigital2007-01-291-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
* Web Service: Remove ws_status from #configvdigital2007-01-281-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
* - revert feature 564: log the login of each user; but add the possibility to bervelices2007-01-231-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
* Index rename vdigital2007-01-221-0/+52
| | | | git-svn-id: http://piwigo.org/svn/trunk@1741 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bad quotes Fixed rub2007-01-211-2/+2
| | | | git-svn-id: http://piwigo.org/svn/trunk@1740 68402e56-0260-453c-a942-63ccdbb3a9ee
* Inefficient and non required index is removed on #_image_category.vdigital2007-01-211-0/+51
| | | | git-svn-id: http://piwigo.org/svn/trunk@1739 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 625: comment anti-spam - protect against some of the spam robotsrvelices2007-01-191-0/+51
| | | | git-svn-id: http://piwigo.org/svn/trunk@1737 68402e56-0260-453c-a942-63ccdbb3a9ee
* 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