17 Commits

Author SHA1 Message Date
nikrou
4845a85685 Bug 1766 fixed : [PostgreSQL] unkown database function UNIX_TIMESTAMP()
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
2010-07-06 12:17:37 +00:00
nikrou
d7fa727afa Bug 1744 fixed : Incorrect use of timezone with SQLite
Fixed anti-flood system.

Merge from trunk

git-svn-id: http://piwigo.org/svn/branches/2.1@6605 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-06-25 19:45:19 +00:00
nikrou
c04a906ec4 Bug 1737 fixed : merge from trunk
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
2010-06-22 21:19:17 +00:00
nikrou
1661af7f3f Bug 1738 fixed : merge from trunk
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
2010-06-22 21:01:47 +00:00
nikrou
e49ff390d3 Bug 1717 fixed : SQLite: access failure on Admin > Tools > History
hour function doesn't exists
Merge from trunk.

git-svn-id: http://piwigo.org/svn/branches/2.1@6464 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-06-04 19:39:02 +00:00
nikrou
01788faeb5 Fix bug 1695 : incorrect boolean to string conversion for SQLite and PostgreSQL database engines merge from trunk
git-svn-id: http://piwigo.org/svn/branches/2.1@6342 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-05-24 20:44:55 +00:00
nikrou
d8d8ca5ed3 Fix get_enums function for SQLite
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
2010-05-09 20:52:38 +00:00
plegall
48ab333212 bug 1648 fixed: add the pwg_db_check_version functions for pdo-sqlite, sqlite
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-05-07 00:34:56 +00:00
nikrou
c7905118b8 Feature 1559 : remove custom function (std) for sqlite
git-svn-id: http://piwigo.org/svn/trunk@5503 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-31 18:16:27 +00:00
nikrou
4773d7a350 Feature 1255 :
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-21 22:51:36 +00:00
patdenice
54c9ceb0f4 feature 1255: add pwg_select_db function.
git-svn-id: http://piwigo.org/svn/trunk@5230 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-21 21:15:54 +00:00
plegall
86ad1d5b49 increase copyright year to 2010
git-svn-id: http://piwigo.org/svn/trunk@5196 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-19 22:37:10 +00:00
nikrou
11751ccd2c Feature 1451 : fix mispelling and missing translations
git-svn-id: http://piwigo.org/svn/trunk@5036 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-03 11:18:21 +00:00
nikrou
c1d6177df9 Feature 1255 :
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-15 19:49:04 +00:00
nikrou
e1de0d6faf Feature 511 : fix problems with calendar functions
add pwg_db_concat() function

git-svn-id: http://piwigo.org/svn/trunk@4833 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-02-03 09:26:32 +00:00
nikrou
20b58c53cd Feature 511 : improve installation for sqlite
fatal error if database cannot be accessed
fix problem with booleans

git-svn-id: http://piwigo.org/svn/trunk@4791 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-01-29 11:36:54 +00:00
nikrou
386864cd26 Feature 511 : add support for sqlite database engine
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
2010-01-28 11:30:36 +00:00