aboutsummaryrefslogtreecommitdiffstats
path: root/include/dblayer (unfollow)
Commit message (Collapse)AuthorFilesLines
2016-01-14happy new year 2016, all headers updatedplegall2-2/+2
2015-12-08fixes #384 use built-in functions to set charsetplegall2-3/+5
2014-02-11feature 2999: (incomplete) doc of mysqli functionsmistic1001-85/+117
git-svn-id: http://piwigo.org/svn/trunk@27337 68402e56-0260-453c-a942-63ccdbb3a9ee
2014-02-11arrayfromquery optimizations: move double if from inside loop to outside + ↵rvelices2-0/+140
use directly mysqli calls to avoid function call overhead for every row retrieved from db git-svn-id: http://piwigo.org/svn/trunk@27336 68402e56-0260-453c-a942-63ccdbb3a9ee
2014-01-05Update headers to 2014. Happy new year!!mistic1002-2/+2
git-svn-id: http://piwigo.org/svn/trunk@26461 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-11-10move array_from_query to functions.inc.phpmistic1002-60/+0
git-svn-id: http://piwigo.org/svn/trunk@25427 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-10-19remove all array_push (50% slower than []) + some changes missing for ↵mistic1002-22/+10
feature:2978 git-svn-id: http://piwigo.org/svn/trunk@25018 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-09-05bug 2865: correct handle of sockets for mysqlimistic1001-1/+1
git-svn-id: http://piwigo.org/svn/trunk@24346 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-04-12merge r22183 from branch 2.5 to trunkplegall1-1/+1
typo fixed in code comment git-svn-id: http://piwigo.org/svn/trunk@22184 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-04-12merge r22181 from branch 2.5 to trunkplegall1-1/+22
bug 2865: mysqli can now handle socket and specific port number git-svn-id: http://piwigo.org/svn/trunk@22182 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-03-02feature:65 add pwg_db_errno and pwg_db_errormistic1002-0/+24
git-svn-id: http://piwigo.org/svn/trunk@21088 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-02-12feature:65 fix fatal error at the end of the install process, remove unused ↵mistic1001-41/+0
file and function git-svn-id: http://piwigo.org/svn/trunk@20721 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-02-01feature:65 add fetch_array SQL functionsmistic1002-0/+10
git-svn-id: http://piwigo.org/svn/trunk@20510 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-01-30feature:65 Add support for PHP mysqli extension, activated by default, ↵mistic1002-9/+803
remove returns of link_identifier git-svn-id: http://piwigo.org/svn/trunk@20462 68402e56-0260-453c-a942-63ccdbb3a9ee
2013-01-01 update Piwigo headers to 2013 (the end of the world didn't occur as ↵plegall2-2/+2
expected on r12922) git-svn-id: http://piwigo.org/svn/trunk@19703 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-10-13feature 2773: add pwg_db_close() methodmistic1001-0/+5
git-svn-id: http://piwigo.org/svn/trunk@18634 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-10-09batch manager - remove unused code, less sql queries and avoid 4 calls to ↵rvelices1-5/+14
same display_select function git-svn-id: http://piwigo.org/svn/trunk@18573 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-04-01feature 2604: support rotation on derivativesplegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@13843 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-03-02remove files related to database engines other than MySQLplegall3-2233/+0
git-svn-id: http://piwigo.org/svn/trunk@13465 68402e56-0260-453c-a942-63ccdbb3a9ee
2012-02-06multisize - added the coi (still to affine the admin ui + language)rvelices1-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
2012-01-17update Piwigo headers to 2012, last change before the expected (or not) ↵mistic1005-5/+5
apocalypse git-svn-id: http://piwigo.org/svn/trunk@12922 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-12-29fetaure 2542 replace $conf['local_data_dir'] with $conf['data_location'] and ↵rvelices2-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
2011-12-16better get_boolean function: able to detect "0" as false, (bool)false as falseplegall1-8/+11
and (int)0 as false. git-svn-id: http://piwigo.org/svn/trunk@12752 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-12-16merge r12747 from branch 2.3 to trunkplegall1-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
2011-08-30merge r12009 from branch 2.2 to trunkplegall1-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
2011-08-24feature 2359: simpler function single_update and single_insertplegall4-78/+108
git-svn-id: http://piwigo.org/svn/trunk@11991 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-08-09bug:2383flop251-2/+2
/!\ corrected but not checked git-svn-id: http://piwigo.org/svn/trunk@11925 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-06-22feature:2359 add single_update and single_insert functionsmistic1004-34/+423
git-svn-id: http://piwigo.org/svn/trunk@11485 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-06-14merge r11363 from branch 2.2 to trunkplegall1-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
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-22- fix icon display on index page (calendar by post date)rvelices1-5/+3
- remove unnecessary include_once - mysql functions simplification git-svn-id: http://piwigo.org/svn/trunk@8844 68402e56-0260-453c-a942-63ccdbb3a9ee
2011-01-18Happy new year 2011plegall5-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
2010-07-06Bug 1766 fixed : [PostgreSQL] unkown database function UNIX_TIMESTAMP()nikrou4-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
2010-06-25Bug 1744 fixed : Incorrect use of timezone with SQLitenikrou4-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
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 POstgreSQLnikrou3-10/+4
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.nikrou4-12/+21
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-06-04Fix bug 1717 : SQLite: access failure on Admin > Tools > Historynikrou2-0/+12
hour function doesn't exists git-svn-id: http://piwigo.org/svn/trunk@6463 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-05-24Fix bug 1695 : incorrect boolean to string conversion for SQLite and ↵nikrou3-9/+9
PostgreSQL database engines git-svn-id: http://piwigo.org/svn/trunk@6339 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-05-09Fix get_enums function for SQLitenikrou2-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
2010-05-07SQLite availabilty must be check by existence of SQLite3 classnikrou1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@6092 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-05-07bug 1648 fixed: add the pwg_db_check_version functions for pdo-sqlite, sqliteplegall3-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
2010-04-28feature 1630: upgrade to Piwigo 2.1 :-)plegall1-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
2010-04-10Bug 1567 fixed : problem with old version of mysqlnikrou1-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
2010-03-31Feature 1559 : remove custom function (std) for sqlitenikrou2-58/+0
git-svn-id: http://piwigo.org/svn/trunk@5503 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-29Fix some issues with database engines :nikrou1-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
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: Move $conf['db_sqlite_default'] and ↵patdenice1-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
2010-03-21Feature 1255 :nikrou4-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