aboutsummaryrefslogtreecommitdiffstats
path: root/install/db (follow)
Commit message (Collapse)AuthorAgeFilesLines
* - images.file categories.permalink old_permalinks.permalink - become binaryrvelices2008-09-121-0/+54
| | | | | | | | | | | | | | - session security improvement: now the sessions are valid only for originating ip addr (with mask 255.255.0.0 to allow users behind load balancing proxies) -> stealing the session cookie is almost a non issue (with the exception of the 65536 machines in range) - metadata sync from the sync button does not overwrite valid data with empty metadata - other small fixes/enhancements: - added event get_category_image_orders - fix display issue with redirect.tpl (h1/h2 within h1) - fix known_script smarty function registration - query search form not submitted if q is empty - better admin css rules - some other minor changes (ws_core, rest_handler, functions_search...) git-svn-id: http://piwigo.org/svn/trunk@2521 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 169 added: ability to manually sort images inside a category. Aplegall2008-09-111-0/+46
| | | | | | | | | dedicated screen let the administrator sort the images (pur HTML, no JavaScript yet). The "rank" sort order is available only for a category without flat mode. New database column image_category.rank. git-svn-id: http://piwigo.org/svn/trunk@2517 68402e56-0260-453c-a942-63ccdbb3a9ee
* remove ws access table/partners functionalityrvelices2008-09-111-0/+46
| | | | git-svn-id: http://piwigo.org/svn/trunk@2516 68402e56-0260-453c-a942-63ccdbb3a9ee
* - fix issue when picture_url_style = file (sql query like) rvelices2008-09-091-0/+5
| | | | | | - sql call SET NAMES "xxx" (if required) in upgrade.php, upgrade_feed.php and after 65-database.php git-svn-id: http://piwigo.org/svn/trunk@2512 68402e56-0260-453c-a942-63ccdbb3a9ee
* - based on test_menu by grum (thanks to you) - integration of dynamic menu ↵rvelices2008-08-281-0/+48
| | | | | | | | | | bar to pwg - the menubar is composed now of dynamic blocks that can be ordered/hidden - plugins can add their own blocks git-svn-id: http://piwigo.org/svn/trunk@2488 68402e56-0260-453c-a942-63ccdbb3a9ee
* - add #user_cache.cache_update_time - useful for plugins or the filter when ↵rvelices2008-07-221-0/+46
| | | | | | it is not possible/desirable to cache/calculate data specific to the user when pwg core does it; note that this opens the possibility to implement a data cache (file/shared mem/ etc...) for every user (for very large databases) git-svn-id: http://piwigo.org/svn/trunk@2448 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature template-extension based on 2006 chrisaga's idea.vdigital2008-07-141-0/+48
| | | | | | | chrisaga wrote: "If you want to make some template customization without building a brand new template, you should use ..." git-svn-id: http://piwigo.org/svn/trunk@2434 68402e56-0260-453c-a942-63ccdbb3a9ee
* Change some PhpWebGallery to Piwigo. (2/2)rub2008-05-151-1/+1
| | | | | | | | All phpwebgallery.net are not changed! git-svn-id: http://piwigo.org/svn/trunk@2342 68402e56-0260-453c-a942-63ccdbb3a9ee
* - remove some unnecessary db columns (#history_summary.id, #history.year, ↵rvelices2008-05-061-0/+58
| | | | | | month, day and hour) git-svn-id: http://piwigo.org/svn/trunk@2333 68402e56-0260-453c-a942-63ccdbb3a9ee
* Resolved issue 0000823: Enhance upload functionalitiesrub2008-05-021-0/+53
| | | | | | | | | | | | | | | First commit, others will be follow. Not hesitate to change my translations. Add upload configuration tabsheet (move and add configuration) Change and add define for access level Can show upload link every time Can restrict access upload.class.php Can choice category on upload page Add upload class not use for the moment Review quickly and temporary style of upload.tpl git-svn-id: http://piwigo.org/svn/trunk@2325 68402e56-0260-453c-a942-63ccdbb3a9ee
* - move #categories.date_last and nb_images to #user_cache_categoriesrvelices2008-05-011-0/+58
| | | | git-svn-id: http://piwigo.org/svn/trunk@2324 68402e56-0260-453c-a942-63ccdbb3a9ee
* - 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