aboutsummaryrefslogtreecommitdiffstats
path: root/include/ws_functions.inc.php (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Bug 1754 fixed : The keyword AS is mandatory for alias in PostgreSQL queriesnikrou2010-07-031-3/+3
| | | | git-svn-id: http://piwigo.org/svn/trunk@6652 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1716 fixed : Check upgrades failed in intronikrou2010-06-091-3/+3
| | | | | | | Incorrect use of database dependant functions. Fixed same problem for ws functions git-svn-id: http://piwigo.org/svn/trunk@6500 68402e56-0260-453c-a942-63ccdbb3a9ee
* - do not remove slashes before calling insert_user_comment (homogeneity with ↵rvelices2010-06-011-3/+3
| | | | | | | | 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/trunk@6437 68402e56-0260-453c-a942-63ccdbb3a9ee
* Amend bug 1559. standard deviation was not removed in some places.nikrou2010-05-081-1/+0
| | | | | | So, sqlite crashed because std function has been removed. git-svn-id: http://piwigo.org/svn/trunk@6125 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
* bug 1635 fixed: new API method pwg.images.checkUpload tells pLoader if Piwigoplegall2010-05-031-0/+48
| | | | | | is ready for upload (currently, it checks write access on the upload directory) git-svn-id: http://piwigo.org/svn/trunk@6049 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix missing argument for pwg_db_changes()nikrou2010-04-201-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@5930 68402e56-0260-453c-a942-63ccdbb3a9ee
* increase copyright year to 2010plegall2010-03-191-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@5196 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1451 : localization with gettextnikrou2010-03-021-1/+1
| | | | | | | | | | | Use php-gettext (developpement version rev43, because of php5.3) as fallback Use native language (english) instead of key for translation Keep directory en_UK for english customization Need some refactoring for plurals Todo : managing plugins in the same way git-svn-id: http://piwigo.org/svn/trunk@5021 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r5013 from branch 2.0 to trunkplegall2010-03-011-3/+7
| | | | | | | | | | | feature 1448 added: ability to set the upload directory (for pwg.images.add API method). Warning: due to risk on img src construction, the upload_dir must be relative to the Piwigo directory itself. git-svn-id: http://piwigo.org/svn/trunk@5014 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4953 from branch 2.0 to trunkplegall2010-02-231-16/+64
| | | | | | | | feature 1453 added: ability to check for uniqueness on filename. No change on the default behavior: uniqueness is set on md5sum. git-svn-id: http://piwigo.org/svn/trunk@4954 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4910 from branch 2.0 to trunkplegall2010-02-191-1/+1
| | | | | | | | feature 967: optionnaly transmit the original filename to pwg.images.add. When transmitted, it fills the images.file column. git-svn-id: http://piwigo.org/svn/trunk@4911 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4902 from branch 2.0 to trunkplegall2010-02-171-0/+15
| | | | | | | | bug 1423 fixed: support for ExtendedDescription (and all the ones using the "render_category_name" event) in category names. git-svn-id: http://piwigo.org/svn/trunk@4903 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4899 from branch 2.0 to trunkplegall2010-02-171-0/+22
| | | | | | | | | | bug 1422 fixed: pwg.images.add (and sub methods) can create recursive directories for windows. add trace in ws_logfile for add_file + ws_images_add_chunk git-svn-id: http://piwigo.org/svn/trunk@4900 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 :nikrou2010-02-151-1/+1
| | | | | | | update pwg_db_insert_id() function. PosgreSQL needs table name to retrieve last insert auto increment id. git-svn-id: http://piwigo.org/svn/trunk@4892 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4883 from branch 2.0 to trunkplegall2010-02-121-5/+15
| | | | | | | bug 1431: Community users now can see empty categories just like any admin. git-svn-id: http://piwigo.org/svn/trunk@4884 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 511 : add support for sqlite database enginenikrou2010-01-281-1/+1
| | | | | | Using session_write_close function when session handler use database because write is called after object destruction. git-svn-id: http://piwigo.org/svn/trunk@4781 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4684 from branch 2.0 to trunkplegall2010-01-151-0/+4
| | | | | | | | feature 1381: pwg.images.add automatically synchronizes metadata. Thank you to Jochen Roth (Polly) for the patch. git-svn-id: http://piwigo.org/svn/trunk@4685 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge -r4512 from branch 2.0 to trunkrvelices2009-12-181-16/+21
| | | | | | web method images.setPrivacyLevel (ws_images_setPrivacyLevel) is POST only git-svn-id: http://piwigo.org/svn/trunk@4513 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4510 from branch 2.0 to trunkplegall2009-12-181-0/+15
| | | | | | | | bug 1334 fixed: for POST mode on pwg.categories.setInfo, pwg.images.setInfo, pwg.images.addChunk web API methods. git-svn-id: http://piwigo.org/svn/trunk@4511 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4459 from branch 2.0 to trunkplegall2009-12-091-17/+38
| | | | | | | | | | | | | feature 1316 added: we now have the ability to only fill the single value properties that are currently empty in the database instead of automatically replacing. feature 1312: as a matter of consistency, I have changed the replace_mode (that was only for multiple values properties) into multiple_value_mode + single_value_mode. git-svn-id: http://piwigo.org/svn/trunk@4460 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4444 from branch 2.0 to trunkplegall2009-12-071-46/+122
| | | | | | | | | | | | | | | | | feature 1312 added: pwg.images.setInfo can replace multiple values propreties (tags/categories). The primary condition is to provide "tag_ids" and/or "categories" input parameters, ie pwg.images.set won't create emptiness. You can reduce the set of tags/categories but not remove all tags/categories. bug 1277 fixed: with a stronger algorithm for adding/replacing categories, we now avoid to recreate an existing image_category association. When a remote client calls pwg.images.setInfo, Piwigo returns an error 500 if: 1. the "categories" parameter is malformed (no numeric id inside) 2. one of the input categories does not exist at database level. git-svn-id: http://piwigo.org/svn/trunk@4445 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4424 from branch 2.0 to trunkplegall2009-12-041-3/+9
| | | | | | | | bug 1210 fixed: check if the memory_get_usage function is available before using it. git-svn-id: http://piwigo.org/svn/trunk@4425 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255: modification in sql queriesnikrou2009-11-251-5/+5
| | | | | | | | | - manage random function - manage regex syntax - manage quote (single instead of double) - manage interval git-svn-id: http://piwigo.org/svn/trunk@4367 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4345 from branch 2.0 to trunkplegall2009-11-221-0/+84
| | | | | | | | | | | feature 1051: ability to add/update a file for an existing photo. For example, you can add the "high" later. Another example is to update the "web resized" file (new dimensions is a common example). It also works for thumbnails. Updating an existing file has no impact on the logical level (list of tags, list of categories, title, description and so on). git-svn-id: http://piwigo.org/svn/trunk@4348 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4344 from branch 2.0 to trunkplegall2009-11-221-19/+85
| | | | | | | | | | feature 1051: new API method pwg.images.checkFiles. This method will be useful before asking for an update on photo files. Enhancement in code factorization. git-svn-id: http://piwigo.org/svn/trunk@4347 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r4328 from branch 2.0 to trunkplegall2009-11-221-127/+83
| | | | | | | | | | | | | | improvement: to prepare feature 1051, the code to add a single file (works for the 3 picture types, ie thumb/file/high) has been factorized into a single add_file function. bug fixed: when a function not directly called by the API (such as merge_chunks or the new add_file function) returning a PwgError, it was not stopping the execution, it just sets the error code/message. Now we don't return PwgError, we only create one and then exit(). git-svn-id: http://piwigo.org/svn/trunk@4346 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 : limit params in sql queries were in wrong order (LIMIT count ↵nikrou2009-11-211-4/+4
| | | | | | OFFSET offset) git-svn-id: http://piwigo.org/svn/trunk@4334 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 : improve sqlnikrou2009-11-211-3/+3
| | | | | | Replace in queries LIMIT N,M by LIMIT N OFFSET M git-svn-id: http://piwigo.org/svn/trunk@4331 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1244 resolvednikrou2009-11-201-18/+18
| | | | | | | | Replace all mysql functions in core code by ones independant of database engine Fix small php code synxtax : hash must be accessed with [ ] and not { }. git-svn-id: http://piwigo.org/svn/trunk@4325 68402e56-0260-453c-a942-63ccdbb3a9ee
* Escape all login and username characters in databaseEric2009-11-181-4/+4
| | | | | | | | Display correctly usernames (I hope not to have made mistakes) git-svn-id: http://piwigo.org/svn/trunk@4304 68402e56-0260-453c-a942-63ccdbb3a9ee
* New feature : configuration option for thumbnail directorynikrou2009-08-021-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@3720 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r3661 from branch 2.0 to trunkplegall2009-07-211-19/+15
| | | | | | | | | | | feature 1071: improve log system on API calls. The log can be activated by a configuration setting. The log file can be changed also with a configuration setting. improvement: pwg.images.add API methods gets a cleaner way to log received parameters. git-svn-id: http://piwigo.org/svn/trunk@3662 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r3659 from branch 2.0 to trunkplegall2009-07-211-1/+1
| | | | | | | bug 1070: fix a pLoader bug on Piwigo side. Catch the bad communication: don't try to find tags if tag_ids parameter is empty (but not null). git-svn-id: http://piwigo.org/svn/trunk@3660 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r3513 from branch 2.0 to trunkplegall2009-07-031-0/+2
| | | | | | | bug 1043 fixed: avoid warning when merging chunks. This warning was preventing the PwgError to work correctly and the error code was not transmitted. git-svn-id: http://piwigo.org/svn/trunk@3514 68402e56-0260-453c-a942-63ccdbb3a9ee
* - remove warn on unset variablervelices2009-07-011-10/+10
| | | | | | - insert_user_comment expects now the comment content to be sql safe (works now exactly as update_user_comment) git-svn-id: http://piwigo.org/svn/trunk@3488 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r3453 from branch 2.0 to trunkplegall2009-06-241-0/+53
| | | | | | | | feature 1033 added: new API method pwg.categories.setInfo makes possible to change the name and comment of a given category. git-svn-id: http://piwigo.org/svn/trunk@3454 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r3239 from branch 2.0 to trunkplegall2009-04-141-9/+18
| | | | | | | | bug 949 fixed: to avoid memory limit on server side, base64 encode chunks one by one on client side and base64 decode chunks one by one on server side. git-svn-id: http://piwigo.org/svn/trunk@3240 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r3192 from branch 2.0 to trunkplegall2009-03-121-23/+111
| | | | | | | | | bug 941 fixed: to be able to upload heavy photo, chunk the files, send parts one by one, and then pwg.images.add merge chunks together. Now big uploads works and you can even have a fine progress bar on client side. git-svn-id: http://piwigo.org/svn/trunk@3193 68402e56-0260-453c-a942-63ccdbb3a9ee
* Last (I hope) paranoic optims ...rvelices2009-02-141-9/+6
| | | | | | | | | - move get_uysername and get_groupname from public to admin/functions.inc.php - optim in index.php - tags.tpl does not need smarty modifier included - move func get_comment_post_key from functions_comment to functions (avoid extra inclusion every time on picture page) git-svn-id: http://piwigo.org/svn/trunk@3145 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r3064 from branch 2.0 to trunkplegall2009-01-081-2/+2
| | | | | | | | bug 912 fixed: we need an extra original_sum to pwg.images.add API method to check photo existence. Using the file_sum was a bad idea. git-svn-id: http://piwigo.org/svn/trunk@3065 68402e56-0260-453c-a942-63ccdbb3a9ee
* Administration: happy new year 2009, all PHP headers updated. plegall2009-01-041-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@3049 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r2921 from branch 2.0 to trunkplegall2008-12-031-0/+5
| | | | | | | | bug 907 fixed: avoid PHP warning when pwg.images.add adds a photo in a category that either contains no "ranked" image or when category is empty. git-svn-id: http://piwigo.org/svn/trunk@2922 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r2918 from branch 2.0 to trunkplegall2008-12-031-1/+1
| | | | | | | | bug 905 fixed: avoid PHP notice when rank is implicit in the categories parameter of the pwg.images.add web API method. git-svn-id: http://piwigo.org/svn/trunk@2920 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r2722 from branch 2.0 to trunkplegall2008-12-031-81/+178
| | | | | | | | | feature 892 added: pwg.images.setInfo added so that once we have discovered the photo was already in the database (thanks to pwg.images.exist), we can only set the photo metadata. git-svn-id: http://piwigo.org/svn/trunk@2919 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r2916 from branch 2.0 to trunkplegall2008-12-021-0/+6
| | | | | | | | bug 904 fixed: an index.htm is created in directories created by pwg.images.add web API method, only directories that contains pictures. git-svn-id: http://piwigo.org/svn/trunk@2917 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge -c2785 from branch 2.0 to trunkplegall2008-10-201-6/+57
| | | | | | | | bug 897 fixed: controls added in pwg.images.add to have clear error messages if permission is denied or any error occur during file write. git-svn-id: http://piwigo.org/svn/trunk@2786 68402e56-0260-453c-a942-63ccdbb3a9ee
* - merge rev 2765,2769 from branch 2.0rvelices2008-10-181-4/+6
| | | | | | | | * 2765 mysql potential injection paranoia + code compaction in common.inc.php * 2769 added an image sort order by privacy level (admins only) * 2769 fix an IE6 display issue with quick search on index page git-svn-id: http://piwigo.org/svn/trunk@2770 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge 2755 and 2756 from branch 2.0 to trunkrvelices2008-10-161-13/+5
| | | | | | | | - 2755 fix vulnerability http://www.milw0rm.com/exploits/6755 - 2756 security paranoia: protect session/remember me cookies from XSS attacks (works only if php>=5.2 and with IE/FF maybe others) git-svn-id: http://piwigo.org/svn/trunk@2757 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 889 added: pwg.images.exist check the existence of a photo in theplegall2008-10-071-0/+39
| | | | | | | database based on its md5sum. (avoid failing on pwg.images.add). git-svn-id: http://piwigo.org/svn/trunk@2683 68402e56-0260-453c-a942-63ccdbb3a9ee