aboutsummaryrefslogtreecommitdiffstats
path: root/include (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Bug 1766 fixed : [PostgreSQL] unkown database function UNIX_TIMESTAMP()nikrou2010-07-065-1/+21
| | | | | | | Add a new function pwg_db_date_to_ts() to calculate a timestamp from a date Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6667 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1763 fixed : [PostgreSQL] double quote used in queriesnikrou2010-07-053-6/+6
| | | | | | Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6665 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1762 fixed : Compleet RSS Feed returns noticenikrou2010-07-051-23/+2
| | | | | | | Remove mysql specific function Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6663 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1760 fixed : Avoid session fixationnikrou2010-07-051-1/+1
| | | | | | | | | After connection, session id is changed using session_regenerate_id but without removing old session. Passing param true makes the job Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6661 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1755 fixed : Needs single quotes in queries official pluginsnikrou2010-07-031-1/+1
| | | | | | Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6655 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1754 fixed : The keyword AS is mandatory for alias in PostgreSQL queriesnikrou2010-07-034-10/+10
| | | | | | Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6653 68402e56-0260-453c-a942-63ccdbb3a9ee
* we are on the branch 2.1 nowplegall2010-06-291-1/+1
| | | | git-svn-id: http://piwigo.org/svn/branches/2.1@6630 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1744 fixed : Incorrect use of timezone with SQLitenikrou2010-06-255-5/+26
| | | | | | | | Fixed anti-flood system. Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6605 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1735 fixed : merge from trunknikrou2010-06-241-2/+2
| | | | | | | | | | Comment page is not PostgreSQL compatible Fixed by adding all fields except category_id in group by clause category_id is retrieved later in an another query (with permissions filter) Fixed also problem of FROM_UNIXTIME function not POstgreSQL compatible git-svn-id: http://piwigo.org/svn/branches/2.1@6602 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1736 fixed : Complete RSS Feed returns error start or end dates can be nullnikrou2010-06-241-19/+57
| | | | | | merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6598 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix bug 1743 : comment form is not visible because of boolean managementnikrou2010-06-231-0/+4
| | | | | | merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6592 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1733 fixed : merge from trunk.nikrou2010-06-231-4/+4
| | | | | | Queries must use single quotes. git-svn-id: http://piwigo.org/svn/branches/2.1@6590 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1737 fixed : merge from trunknikrou2010-06-223-10/+4
| | | | | | | Concatenation error with POstgreSQL Simplify same function for SQLite git-svn-id: http://piwigo.org/svn/branches/2.1@6581 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1738 fixed : merge from trunknikrou2010-06-224-12/+21
| | | | | | hour function doesn't exists for database other than mysql. git-svn-id: http://piwigo.org/svn/branches/2.1@6579 68402e56-0260-453c-a942-63ccdbb3a9ee
* misplaced closing paranthesis in common.inc.phprvelices2010-06-121-1/+1
| | | | git-svn-id: http://piwigo.org/svn/branches/2.1@6524 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1730 fixed : search doesn't work when database engine is not mysqlnikrou2010-06-101-1/+1
| | | | | | | For posgresql and sqlite date must allways use day and month with two diggits. merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6519 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix bug 1722 : PosgtreSQL wants all fields in select to be in Group by clausenikrou2010-06-093-12/+30
| | | | | | | | | or agregate function Fix issue for lambda function (incorrect number of params) merge from trunk. git-svn-id: http://piwigo.org/svn/branches/2.1@6511 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1716 fixed : SQLite: Check upgrades failed in intronikrou2010-06-091-3/+3
| | | | | | | | | Incorrect use of dependant database function Fixed same problem in ws functions merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6501 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r6484 from trunk to branch 2.1rvelices2010-06-072-33/+32
| | | | | | | - revert r6473 and r6475 - moved call to event format_exif_data earlier git-svn-id: http://piwigo.org/svn/branches/2.1@6485 68402e56-0260-453c-a942-63ccdbb3a9ee
* one of my previous merge from trunk was incompletervelices2010-06-061-1/+1
| | | | git-svn-id: http://piwigo.org/svn/branches/2.1@6477 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r6475 rvelices2010-06-061-4/+4
| | | | | | | previous commit was still not ok - quick fix (maybe not the cleanest) of regression 2.0 -> 2.1 when displaying metadata on picture page (event called with different input) git-svn-id: http://piwigo.org/svn/branches/2.1@6476 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r6473 from trunk to branch 2.1 rvelices2010-06-062-27/+27
| | | | | | - quick fix (maybe not the cleanest) of regression 2.0 -> 2.1 when displaying metadata on picture page (event called with different input) git-svn-id: http://piwigo.org/svn/branches/2.1@6474 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1717 fixed : SQLite: access failure on Admin > Tools > Historynikrou2010-06-042-0/+12
| | | | | | | hour function doesn't exists Merge from trunk. git-svn-id: http://piwigo.org/svn/branches/2.1@6464 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r6437 from trunk to branch 2.1rvelices2010-06-013-21/+6
| | | | | | | - do not remove slashes before calling insert_user_comment (homogeneity with update_user_comment and general use of slashes in piwigo) - when using a modifier on a non array variable use @| instead of | (generated code is simpler and faster) git-svn-id: http://piwigo.org/svn/branches/2.1@6438 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1705 fixed : User cannot add comment with double quotesnikrou2010-05-291-1/+1
| | | | | | Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6424 68402e56-0260-453c-a942-63ccdbb3a9ee
* added a test that $conf['gallery_url'] != http://piwigo.org/demorvelices2010-05-281-0/+4
| | | | git-svn-id: http://piwigo.org/svn/branches/2.1@6412 68402e56-0260-453c-a942-63ccdbb3a9ee
* - merged the linkroot integration with the existing gallery_url (unique ↵rvelices2010-05-284-59/+51
| | | | | | | | $conf['gallery_url'] used for RSS, mail homepage root in the browse path) - added an option $conf['debug_mail'] - if set all outgoing mails are saved into local_data_dir git-svn-id: http://piwigo.org/svn/branches/2.1@6410 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1704 fixed: windows needs a specific directory separator when creatingplegall2010-05-271-0/+4
| | | | | | recursive directory. git-svn-id: http://piwigo.org/svn/branches/2.1@6384 68402e56-0260-453c-a942-63ccdbb3a9ee
* Issue 1521 : add linkroot to spacial pageslaurent.duretz2010-05-261-8/+8
| | | | git-svn-id: http://piwigo.org/svn/branches/2.1@6368 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 1697: ability to deactivate the synchronization method to add photos.plegall2010-05-251-0/+3
| | | | git-svn-id: http://piwigo.org/svn/branches/2.1@6361 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge -r 6355 from trunk rvelices2010-05-251-15/+18
| | | | | | fix bug 1663 : wrong decoding of non Ascii iptc/exif (charset issue) git-svn-id: http://piwigo.org/svn/branches/2.1@6356 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix bug 1695 : incorrect boolean to string conversion for SQLite and ↵nikrou2010-05-243-9/+9
| | | | | | PostgreSQL database engines merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6342 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1694 fixed: COMPUTED Exif fields were not displayed on picture.phpplegall2010-05-241-4/+4
| | | | git-svn-id: http://piwigo.org/svn/branches/2.1@6338 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1682: r6312 was producing a MySQL error (depending on the MySQL serverplegall2010-05-241-1/+2
| | | | | | | | | version) because a count() implies a group by. This code change was checked against MySQL 5.0.75, MySQL 5.0.51 (where the error occured) and SQLite 3.6.22. git-svn-id: http://piwigo.org/svn/branches/2.1@6321 68402e56-0260-453c-a942-63ccdbb3a9ee
* Merge r6318 from trunk to branch 2.1.patdenice2010-05-241-0/+1
| | | | | | $themeconf['id'] hard coded in template class git-svn-id: http://piwigo.org/svn/branches/2.1@6319 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1685 fixed: typo on identification.php linkplegall2010-05-231-1/+1
| | | | git-svn-id: http://piwigo.org/svn/branches/2.1@6313 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1684 fixed: the test to check availability of the user_infos line wasplegall2010-05-231-14/+18
| | | | | | | | | | | | wrong. I had changed the old db_num_rows > 0 because it was not working with SQLite. As suggested by nicolas, let's use a simpler trick "count(1)" in the query itself, this way it should work with any database engine. I've also removed the while (true) (ugly infinite loop, with a condition for exit) that was producing an infinite loop for Piwigo installations with 2.0 database model and 2.1 code (before launching upgrade.php) git-svn-id: http://piwigo.org/svn/branches/2.1@6312 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1683 fixed: as soon as an admin modifies the admin>conf>options>guest ↵plegall2010-05-231-0/+41
| | | | | | | | settings, registration is broken. This is because user_infos.theme/language are emptied (while they should not). I have also added an "automatic repair" piece of code in get_default_user_info function. This piece of code should be removed for 2.2 with the appropriate migration task. git-svn-id: http://piwigo.org/svn/branches/2.1@6311 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix get_enums function for SQLitenikrou2010-05-092-2/+26
| | | | | | | hard coded enums values for all tables because enum feature doesn't exists for SQLite. git-svn-id: http://piwigo.org/svn/trunk@6153 68402e56-0260-453c-a942-63ccdbb3a9ee
* add nl.piwigo.org as domain name if current language is nl_NLplegall2010-05-091-1/+1
| | | | | | | | fix typos on language names in install.php correct list of available newsletters git-svn-id: http://piwigo.org/svn/trunk@6152 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1652 fixed: json_encode function is required for admin.php?fckb_tags=1plegall2010-05-083-33/+54
| | | | | | (used in the new tags widget) git-svn-id: http://piwigo.org/svn/trunk@6126 68402e56-0260-453c-a942-63ccdbb3a9ee
* Amend bug 1559. standard deviation was not removed in some places.nikrou2010-05-082-2/+0
| | | | | | So, sqlite crashed because std function has been removed. git-svn-id: http://piwigo.org/svn/trunk@6125 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1649 fixed: search EXIF/IPTC in the high definition photo if there is noplegall2010-05-071-3/+18
| | | | | | EXIF/IPTC in the web sized photo. git-svn-id: http://piwigo.org/svn/trunk@6093 68402e56-0260-453c-a942-63ccdbb3a9ee
* SQLite availabilty must be check by existence of SQLite3 classnikrou2010-05-071-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@6092 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1648 fixed: add the pwg_db_check_version functions for pdo-sqlite, sqliteplegall2010-05-074-2/+47
| | | | | | | | | | and pgsql, also make the $pwg_db_link global in the install_db_connect function so that it can be used in SQLite functions. bug fixed: with pdo-sqlite, pwg_db_num_rows always returns 0, so when initializing user data, it tries to insert the same row twice. git-svn-id: http://piwigo.org/svn/trunk@6090 68402e56-0260-453c-a942-63ccdbb3a9ee
* remove debug traceplegall2010-05-041-1/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@6075 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1501 fixed: with apache_authentication, fall back to REDIRECT_REMOTE_USERplegall2010-05-041-4/+18
| | | | | | if REMOTE_USER is not set. git-svn-id: http://piwigo.org/svn/trunk@6074 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1063 fixed: avoid error when adding a tag in chinese or russian characters.plegall2010-05-031-0/+7
| | | | | | | | | | | | | In any language where the str2url would return an empty string. The behavior doesn't change for european characters. rvelices warned me about the many issues we might encounter with copy/paste of the URL and required url_encode/url_decode BUT after many tests (Linux with Firefox 3.0/Google Chrome 5, MacOS 10.6 with Firefox/Safari, WindowsXP with IE6/Firefox) I've found 0 problem, even with the most error prone mode $conf['tag_url_style'] = 'tag' git-svn-id: http://piwigo.org/svn/trunk@6060 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug 1639 fixed: the upload form now correctly uses the $conf['upload_dir']plegall2010-05-031-2/+4
| | | | | | | | | | | | | parameter (web API already use it). By default, the $conf['upload_dir'] is no longer dependent to PHPWG_ROOT_PATH because it becomes a real mess when admin/include/uploadify.php (called directly, not from an include) tries to perform an upload. Improvement: make clearer how $conf['upload_dir'] can be set (relative to the Piwigo installation directory + HTTP reachable) git-svn-id: http://piwigo.org/svn/trunk@6052 68402e56-0260-453c-a942-63ccdbb3a9ee
* improvement: use the same code to check upload readiness in admin>photos>addplegall2010-05-031-11/+18
| | | | | | | | | screen and in web API. bug fixed: UploadForm partly takes into account the configurable upload directory (must be propagated everywhere in the UploadForm process) git-svn-id: http://piwigo.org/svn/trunk@6051 68402e56-0260-453c-a942-63ccdbb3a9ee