aboutsummaryrefslogtreecommitdiffstats
path: root/include/dblayer/functions_pgsql.inc.php (unfollow)
Commit message (Collapse)AuthorFilesLines
2011-08-24feature 2359: simpler function single_update and single_insertplegall1-20/+28
git-svn-id: http://piwigo.org/svn/trunk@11991 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-06-22feature:2359 add single_update and single_insert functionsmistic1001-2/+98
git-svn-id: http://piwigo.org/svn/trunk@11485 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-04-16merge r10430 from branch 2.2 to trunkplegall1-1/+72
bug 1818 fixed: fix "select distinct" queries for PostgreSQL. Patch by leloupv git-svn-id: http://piwigo.org/svn/trunk@10431 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-01-18Happy new year 2011plegall1-2/+2
Change "Piwigo - a PHP based picture gallery" into "Piwigo - a PHP based photo gallery" git-svn-id: http://piwigo.org/svn/trunk@8728 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-07-06Bug 1766 fixed : [PostgreSQL] unkown database function UNIX_TIMESTAMP()nikrou1-0/+5
Add a new function pwg_db_date_to_ts() to calculate a timestamp from a date git-svn-id: http://piwigo.org/svn/trunk@6666 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-06-25Bug 1744 fixed : Incorrect use of timezone with SQLitenikrou1-0/+5
Fixed anti-flood system. Need refactoring between each interval functions git-svn-id: http://piwigo.org/svn/trunk@6604 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-06-23Bug 1743 fixed : comment form is not visible because of boolean managementnikrou1-0/+4
git-svn-id: http://piwigo.org/svn/trunk@6591 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-06-22Bug 1737 fixed : Concatenation error with POstgreSQLnikrou1-4/+2
Simplify same function for SQLite git-svn-id: http://piwigo.org/svn/trunk@6580 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-06-22Bug 1738 fixed : hour function doesn't exists for database other than mysql.nikrou1-0/+5
git-svn-id: http://piwigo.org/svn/trunk@6578 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-06-09Fix bug 1722 : PosgtreSQL wants all fields in select to be in Group by clausenikrou1-4/+4
or agregate function Fix issue for lambda function (incorrect number of params) git-svn-id: http://piwigo.org/svn/trunk@6510 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-05-24Fix bug 1695 : incorrect boolean to string conversion for SQLite and ↵nikrou1-3/+3
PostgreSQL database engines git-svn-id: http://piwigo.org/svn/trunk@6339 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-05-07bug 1648 fixed: add the pwg_db_check_version functions for pdo-sqlite, sqliteplegall1-0/+15
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
2010-03-22Fix warning for postgresql installationnikrou1-6/+1
Remove unused function git-svn-id: http://piwigo.org/svn/trunk@5267 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-21Feature 1255 :nikrou1-4/+10
only one function use exceptions to deal with differents possible errors git-svn-id: http://piwigo.org/svn/trunk@5236 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-21feature 1255: add pwg_select_db function.patdenice1-2/+7
git-svn-id: http://piwigo.org/svn/trunk@5230 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-19increase copyright year to 2010plegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@5196 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-03Feature 1451 : fix mispelling and missing translationsnikrou1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@5036 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-02-28Feature 1255 : bug in install with mysql and postgresql if some form ↵nikrou1-1/+1
parameters are missing. git-svn-id: http://piwigo.org/svn/trunk@5006 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-02-15Feature 1255 :nikrou1-2/+8
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
2010-02-13Feature 1255 : bug in pwg_session_write() with postgresql.nikrou1-1/+29
replace into doesn't exists. Must do two queries git-svn-id: http://piwigo.org/svn/trunk@4886 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-02-03Feature 511 : fix problems with calendar functionsnikrou1-0/+6
add pwg_db_concat() function git-svn-id: http://piwigo.org/svn/trunk@4833 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-01-28Feature 511 : add support for sqlite database enginenikrou1-52/+14
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
2009-12-02Feature 1255 :nikrou1-127/+87
- add postgres database engine - change installation process to allow postgres or mysql database git-svn-id: http://piwigo.org/svn/trunk@4410 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-29Feature_1255:nikrou1-13/+4
- bug fix : function pwg_db_get_recent_period_expression - add extra fields for select based on "order by" git-svn-id: http://piwigo.org/svn/trunk@4387 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-29Feature_1255 :nikrou1-0/+73
- single quotes in queries - start using $conf['dblayer'] git-svn-id: http://piwigo.org/svn/trunk@4385 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-25Feature 1255: modification in sql queriesnikrou1-0/+95
- 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
2009-11-21Feature 1241 : revert pwg_db_fetch_row because we use $row[0]nikrou1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@4335 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-21Feature 1244 : misspelled functions pwg_db_free_result() (db missing)nikrou1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@4332 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-20Feature 1244 : bug fixnikrou1-1/+0
functions_mysql.inc.php must be loaded for install git-svn-id: http://piwigo.org/svn/trunk@4326 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-20Feature 1244 resolvednikrou1-0/+463
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
generated by cgit v1.2.3 (git 2.25.1) at 2024-07-04 23:44:40 +0000