aboutsummaryrefslogtreecommitdiffstats
path: root/include/dblayer/functions_mysql.inc.php (follow)
Commit message (Collapse)AuthorAgeFilesLines
* bug 2534 fixed: clean (as clean as possible with MySQL+MyISAM) handle ofplegall2011-12-161-2/+8
| | | | | | | | concurrency on user cache refresh. No more error when regenerating several thumbnails at once. git-svn-id: http://piwigo.org/svn/branches/2.3@12747 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-241-18/+26
| | | | git-svn-id: http://piwigo.org/svn/trunk@11991 68402e56-0260-453c-a942-63ccdbb3a9ee
* feature:2359 add single_update and single_insert functionsmistic1002011-06-221-2/+101
| | | | 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
* - 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-181-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
* Bug 1766 fixed : [PostgreSQL] unkown database function UNIX_TIMESTAMP()nikrou2010-07-061-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
* Bug 1744 fixed : Incorrect use of timezone with SQLitenikrou2010-06-251-1/+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
* Bug 1738 fixed : hour function doesn't exists for database other than mysql.nikrou2010-06-221-0/+5
| | | | git-svn-id: http://piwigo.org/svn/trunk@6578 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 1255 :nikrou2010-03-211-9/+14
| | | | | | | 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-211-3/+7
| | | | git-svn-id: http://piwigo.org/svn/trunk@5230 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
* 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-031-2/+2
| | | | 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-281-2/+2
| | | | | | parameters are missing. git-svn-id: http://piwigo.org/svn/trunk@5006 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-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
* Feature 511 : fix problems with calendar functionsnikrou2010-02-031-0/+6
| | | | | | add pwg_db_concat() function git-svn-id: http://piwigo.org/svn/trunk@4833 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 511 : add support for sqlite database enginenikrou2010-01-281-2/+3
| | | | | | 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
* Feature_1255:nikrou2009-11-291-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
* Feature_1255 :nikrou2009-11-291-0/+73
| | | | | | | - single quotes in queries - start using $conf['dblayer'] git-svn-id: http://piwigo.org/svn/trunk@4385 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1255: modification in sql queriesnikrou2009-11-251-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
* Feature 1241 : revert pwg_db_fetch_row because we use $row[0]nikrou2009-11-211-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@4335 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1244 : misspelled functions pwg_db_free_result() (db missing)nikrou2009-11-211-1/+1
| | | | git-svn-id: http://piwigo.org/svn/trunk@4332 68402e56-0260-453c-a942-63ccdbb3a9ee
* Feature 1244 : bug fixnikrou2009-11-201-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
* Feature 1244 resolvednikrou2009-11-201-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