aboutsummaryrefslogtreecommitdiffstats
path: root/include/dblayer (follow)
Commit message (Collapse)AuthorAgeFilesLines
* feature:65 add fetch_array SQL functionsmistic1002013-02-012-0/+10
| | | | git-svn-id: http://piwigo.org/svn/trunk@20510 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature:65 Add support for PHP mysqli extension, activated by default, ↵mistic1002013-01-302-9/+803
| | | | | | remove returns of link_identifier git-svn-id: http://piwigo.org/svn/trunk@20462 68402e56-0260-453c-a942-63ccdbb3a9ee
* update Piwigo headers to 2013 (the end of the world didn't occur as ↵plegall2013-01-012-2/+2
| | | | | | expected on r12922) git-svn-id: http://piwigo.org/svn/trunk@19703 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2773: add pwg_db_close() methodmistic1002012-10-131-0/+5
| | | | git-svn-id: http://piwigo.org/svn/trunk@18634 68402e56-0260-453c-a942-63ccdbb3a9ee
* batch manager - remove unused code, less sql queries and avoid 4 calls to ↵rvelices2012-10-091-5/+14
| | | | | | same display_select function git-svn-id: http://piwigo.org/svn/trunk@18573 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2604: support rotation on derivativesplegall2012-04-011-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@13843 68402e56-0260-453c-a942-63ccdbb3a9ee
* remove files related to database engines other than MySQLplegall2012-03-023-2233/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@13465 68402e56-0260-453c-a942-63ccdbb3a9ee
* multisize - added the coi (still to affine the admin ui + language)rvelices2012-02-061-3/+3
| | | | | | multisize - derivatives can be revuild from a larger derviative instead of the original git-svn-id: http://piwigo.org/svn/trunk@13038 68402e56-0260-453c-a942-63ccdbb3a9ee
* update Piwigo headers to 2012, last change before the expected (or not) ↵mistic1002012-01-175-5/+5
| | | | | | apocalypse git-svn-id: http://piwigo.org/svn/trunk@12922 68402e56-0260-453c-a942-63ccdbb3a9ee
* fetaure 2542 replace $conf['local_data_dir'] with $conf['data_location'] and ↵rvelices2011-12-292-2/+2
| | | | | | move combined files and image derivatives from local to _data git-svn-id: http://piwigo.org/svn/trunk@12802 68402e56-0260-453c-a942-63ccdbb3a9ee
* better get_boolean function: able to detect "0" as false, (bool)false as falseplegall2011-12-161-8/+11
| | | | | | | and (int)0 as false. git-svn-id: http://piwigo.org/svn/trunk@12752 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r12747 from branch 2.3 to trunkplegall2011-12-161-2/+8
| | | | | | | | | | bug 2534 fixed: clean (as clean as possible with MySQL+MyISAM) handle of concurrency on user cache refresh. No more error when regenerating several thumbnails at once. git-svn-id: http://piwigo.org/svn/trunk@12748 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r12009 from branch 2.2 to trunkplegall2011-08-301-1/+1
| | | | | | | | | | bug 2416 fixed: the CAST function in MySQL seems to return unexpected results, depending on MySQL version. As a consequence it was producing virtual years in calendar display. git-svn-id: http://piwigo.org/svn/trunk@12010 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 2359: simpler function single_update and single_insertplegall2011-08-244-78/+108
| | | | git-svn-id: http://piwigo.org/svn/trunk@11991 68402e56-0260-453c-a942-63ccdbb3a9ee
* bug:2383flop252011-08-091-2/+2
| | | | | | /!\ corrected but not checked git-svn-id: http://piwigo.org/svn/trunk@11925 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature:2359 add single_update and single_insert functionsmistic1002011-06-224-34/+423
| | | | git-svn-id: http://piwigo.org/svn/trunk@11485 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r11363 from branch 2.2 to trunkplegall2011-06-141-1/+1
| | | | | | | | | | bug 2342 fixed: with MySQL 5.5, "set level = NULL" fails because images.level is a NOT NULL field. The same test is performed in the same function (mass_updates) but for array bigger than 10 rows. git-svn-id: http://piwigo.org/svn/trunk@11364 68402e56-0260-453c-a942-63ccdbb3a9ee
* merge r10430 from branch 2.2 to trunkplegall2011-04-161-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
* - fix icon display on index page (calendar by post date)rvelices2011-01-221-5/+3
| | | | | | | - remove unnecessary include_once - mysql functions simplification git-svn-id: http://piwigo.org/svn/trunk@8844 68402e56-0260-453c-a942-63ccdbb3a9ee
* Happy new year 2011plegall2011-01-185-10/+10
| | | | | | | 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
* Bug 1766 fixed : [PostgreSQL] unkown database function UNIX_TIMESTAMP()nikrou2010-07-064-0/+20
| | | | | | 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
* Bug 1744 fixed : Incorrect use of timezone with SQLitenikrou2010-06-254-1/+20
| | | | | | | | Fixed anti-flood system. Need refactoring between each interval functions git-svn-id: http://piwigo.org/svn/trunk@6604 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1743 fixed : comment form is not visible because of boolean managementnikrou2010-06-231-0/+4
| | | | git-svn-id: http://piwigo.org/svn/trunk@6591 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1737 fixed : Concatenation error with POstgreSQLnikrou2010-06-223-10/+4
| | | | | | Simplify same function for SQLite git-svn-id: http://piwigo.org/svn/trunk@6580 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1738 fixed : hour function doesn't exists for database other than mysql.nikrou2010-06-224-12/+21
| | | | git-svn-id: http://piwigo.org/svn/trunk@6578 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix bug 1722 : PosgtreSQL wants all fields in select to be in Group by clausenikrou2010-06-091-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
* Fix bug 1717 : SQLite: access failure on Admin > Tools > Historynikrou2010-06-042-0/+12
| | | | | | hour function doesn't exists git-svn-id: http://piwigo.org/svn/trunk@6463 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix bug 1695 : incorrect boolean to string conversion for SQLite and ↵nikrou2010-05-243-9/+9
| | | | | | PostgreSQL database engines git-svn-id: http://piwigo.org/svn/trunk@6339 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
* 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-073-1/+46
| | | | | | | | | | 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
* feature 1630: upgrade to Piwigo 2.1 :-)plegall2010-04-281-9/+17
| | | | | | bug 1604: only activate core themes not all themes. git-svn-id: http://piwigo.org/svn/trunk@5982 68402e56-0260-453c-a942-63ccdbb3a9ee
* Bug 1567 fixed : problem with old version of mysqlnikrou2010-04-101-0/+1
| | | | | | | required version is now 5.0.0 move required version to functions database specific file like others engines git-svn-id: http://piwigo.org/svn/trunk@5782 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1559 : remove custom function (std) for sqlitenikrou2010-03-312-58/+0
| | | | git-svn-id: http://piwigo.org/svn/trunk@5503 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix some issues with database engines :nikrou2010-03-291-1/+1
| | | | | | | | - insert into syntax not correct for posgresql or sqlite - add languages table - incorrect function for row count (sqlite) git-svn-id: http://piwigo.org/svn/trunk@5452 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix warning for postgresql installationnikrou2010-03-221-6/+1
| | | | | | Remove unused function git-svn-id: http://piwigo.org/svn/trunk@5267 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature 1255: Move $conf['db_sqlite_default'] and ↵patdenice2010-03-211-1/+1
| | | | | | | | | $conf['dbengine_select_default'] in install.php (as constants). PDO::SQLite is now displayed as SQLite in install page. Always display unique SQLite engine. git-svn-id: http://piwigo.org/svn/trunk@5239 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 :nikrou2010-03-214-33/+35
| | | | | | | 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
* feature 1255: add pwg_select_db function.patdenice2010-03-214-9/+28
| | | | git-svn-id: http://piwigo.org/svn/trunk@5230 68402e56-0260-453c-a942-63ccdbb3a9ee
* increase copyright year to 2010plegall2010-03-195-5/+5
| | | | git-svn-id: http://piwigo.org/svn/trunk@5196 68402e56-0260-453c-a942-63ccdbb3a9ee
* Fix some sql issues :nikrou2010-03-191-2/+2
| | | | | | | - permalink that use if() syntax - add tables themes for other database engines that mysql git-svn-id: http://piwigo.org/svn/trunk@5192 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1451 : fix mispelling and missing translationsnikrou2010-03-034-5/+5
| | | | git-svn-id: http://piwigo.org/svn/trunk@5036 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 : bug in install with mysql and postgresql if some form ↵nikrou2010-02-282-3/+3
| | | | | | parameters are missing. git-svn-id: http://piwigo.org/svn/trunk@5006 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1459 : add support for SQLite3 via PDOnikrou2010-02-262-0/+602
| | | | git-svn-id: http://piwigo.org/svn/trunk@4967 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 : missing quotes in concat function for mysqlnikrou2010-02-211-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@4929 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255 :nikrou2010-02-153-4/+10
| | | | | | | 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
* Feature 1255 : bug in pwg_session_write() with postgresql.nikrou2010-02-131-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
* Feature 511 : fix problems with calendar functionsnikrou2010-02-033-3/+39
| | | | | | add pwg_db_concat() function git-svn-id: http://piwigo.org/svn/trunk@4833 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 511 : improve installation for sqlitenikrou2010-01-291-4/+22
| | | | | | | 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
* Feature 511 : add support for sqlite database enginenikrou2010-01-284-54/+587
| | | | | | 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