[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [16464] Stable: Merge 16454:16463 from trunk
From: |
sigurdne |
Subject: |
[Fmsystem-commits] [16464] Stable: Merge 16454:16463 from trunk |
Date: |
Tue, 21 Mar 2017 09:31:35 -0400 (EDT) |
Revision: 16464
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=16464
Author: sigurdne
Date: 2017-03-21 09:31:35 -0400 (Tue, 21 Mar 2017)
Log Message:
-----------
Stable: Merge 16454:16463 from trunk
Modified Paths:
--------------
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-active-record.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-active-recordx.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-csvlib.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-datadict.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-error.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-errorhandler.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-errorpear.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-exceptions.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-iterator.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-lib.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-memcache.lib.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-pager.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-pear.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-perf.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-php4.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-time.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-xmlschema.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-xmlschema03.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/composer.json
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-access.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-db2.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-firebird.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-generic.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-ibase.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-informix.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mssql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mssqlnative.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mysql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-oci8.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-postgres.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sapdb.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sqlite.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sybase.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/docs/changelog.md
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-access.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado5.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado_access.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado_mssql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-borland_ibase.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-csv.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2oci.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2ora.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-fbsql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-firebird.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ibase.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-informix.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-informix72.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ldap.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssqlnative.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssqlpo.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqli.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqlpo.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqlt.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-netezza.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci805.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8po.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8quercus.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_db2.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_mssql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_oracle.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbtp.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbtp_unicode.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oracle.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_mssql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_mysql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_oci.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_pgsql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_sqlite.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres64.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres7.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres8.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres9.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-proxy.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sapdb.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlanywhere.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlite.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlite3.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlitepo.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sybase.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sybase_ase.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-vfp.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/pear/Auth/Container/ADOdb.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-db2.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-informix.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mssql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mssqlnative.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mysql.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-oci8.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-postgres.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/pivottable.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/rsfilter.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/server.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-compress-bzip2.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-compress-gzip.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-cryptsession.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-cryptsession2.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-mcrypt.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-md5.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-secret.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session-clob.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session-clob2.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session2.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-cryptsession.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-session-clob.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-session.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/toexport.inc.php
branches/Version-2_0-branch/phpgwapi/inc/adodb/tohtml.inc.php
branches/Version-2_0-branch/property/inc/class.boworkorder.inc.php
branches/Version-2_0-branch/property/inc/class.soworkorder.inc.php
branches/Version-2_0-branch/property/inc/class.uitts.inc.php
branches/Version-2_0-branch/property/inc/custom/default/BkBygg_lag_Agresso_ordre_fra_melding.php
branches/Version-2_0-branch/property/inc/custom/default/BkBygg_lag_Agresso_ordre_fra_workorder.php
branches/Version-2_0-branch/property/inc/custom/default/LRS_oppdater_el_anlegg.php
Removed Paths:
-------------
branches/Version-2_0-branch/phpgwapi/inc/adodb/nbproject/
branches/Version-2_0-branch/phpgwapi/inc/adodb/tests/
branches/Version-2_0-branch/phpgwapi/inc/adodb/x.php
Property Changed:
----------------
branches/Version-2_0-branch/
Index: branches/Version-2_0-branch
===================================================================
--- branches/Version-2_0-branch 2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch 2017-03-21 13:31:35 UTC (rev 16464)
Property changes on: branches/Version-2_0-branch
___________________________________________________________________
Modified: svn:mergeinfo
## -1,4 +1,4 ##
/branches/dev-syncromind:13653
/branches/dev-syncromind-2:14933-16394
/branches/stavangerkommune:12743-12875,12986
-/trunk:14721-14732,14734-14735,14737,14739,14741,14743-14744,14746-14749,14751,14753,14755-14757,14759,14761-14764,14766-14768,14770-14783,14785-14792,14794-14813,14815-14816,14818,14820-14822,14824-14825,14827-14829,14831-14834,14836,14838,14840-14842,14844-14845,14847,14849-14866,14868-14869,14871,14873-14875,14877-14878,14880-14884,14886-14896,14898,14900-14902,14904,14906-14909,14911-14915,14917-14919,14921-14922,14924-14978,14980-15258,15260-15261,15263-15264,15266-15285,15287-15288,15290-15291,15293,15295,15297,15299-15305,15307-15310,15312-15335,15337-15352,15354,15356,15358,15360-15541,15543-15566,15568-15569,15571,15573-15581,15583,15585-15617,15619,15621-15630,15632-15635,15637-15639,15641-15643,15645,15647-15665,15667-15668,15670-15671,15673-15693,15695-15712,15714-15764,15766-15767,15769-15787,15789-15802,15804-15811,15813-15814,15816-15818,15820-15849,15851-15887,15889-15900,15902-16046,16048-16051,16053,16055,16057-16063,16065-16071,16073-16077,16079-16081,16083-16099,16101-16130,16132-16140,16142,16144-16212,16214-16219,16221,16223-16224,16226,16228-16229,16231,16233,16235,16237,16239-16240,16242,16244-16246,16248,16250-16251,16253-16255,16257-16259,16261,16263,16265,16267,16269-16276,16278,16280-16283,16285,16287-16288,16290,16292-16295,16297-16305,16307-16314,16316-16318,16320-16322,16324,16326-16330,16332,16334,16336,16338-16339,16341-16342,16344,16346,16348,16350,16352-16353,16355-16358,16360,16362,16364-16369,16371,16373,16375-16378,16380,16382-16383,16385,16387,16389,16391,16393-16395,16397,16399-16402,16404,16406,16408,16410-16415,16417,16419-16420,16422-16425,16427,16429-16440,16442,16444,16446,16448-16449,16451,16453
\ No newline at end of property
+/trunk:14721-14732,14734-14735,14737,14739,14741,14743-14744,14746-14749,14751,14753,14755-14757,14759,14761-14764,14766-14768,14770-14783,14785-14792,14794-14813,14815-14816,14818,14820-14822,14824-14825,14827-14829,14831-14834,14836,14838,14840-14842,14844-14845,14847,14849-14866,14868-14869,14871,14873-14875,14877-14878,14880-14884,14886-14896,14898,14900-14902,14904,14906-14909,14911-14915,14917-14919,14921-14922,14924-14978,14980-15258,15260-15261,15263-15264,15266-15285,15287-15288,15290-15291,15293,15295,15297,15299-15305,15307-15310,15312-15335,15337-15352,15354,15356,15358,15360-15541,15543-15566,15568-15569,15571,15573-15581,15583,15585-15617,15619,15621-15630,15632-15635,15637-15639,15641-15643,15645,15647-15665,15667-15668,15670-15671,15673-15693,15695-15712,15714-15764,15766-15767,15769-15787,15789-15802,15804-15811,15813-15814,15816-15818,15820-15849,15851-15887,15889-15900,15902-16046,16048-16051,16053,16055,16057-16063,16065-16071,16073-16077,16079-16081,16083-16099,16101-16130,16132-16140,16142,16144-16212,16214-16219,16221,16223-16224,16226,16228-16229,16231,16233,16235,16237,16239-16240,16242,16244-16246,16248,16250-16251,16253-16255,16257-16259,16261,16263,16265,16267,16269-16276,16278,16280-16283,16285,16287-16288,16290,16292-16295,16297-16305,16307-16314,16316-16318,16320-16322,16324,16326-16330,16332,16334,16336,16338-16339,16341-16342,16344,16346,16348,16350,16352-16353,16355-16358,16360,16362,16364-16369,16371,16373,16375-16378,16380,16382-16383,16385,16387,16389,16391,16393-16395,16397,16399-16402,16404,16406,16408,16410-16415,16417,16419-16420,16422-16425,16427,16429-16440,16442,16444,16446,16448-16449,16451,16453,16455-16463
\ No newline at end of property
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-active-record.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-active-record.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-active-record.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Latest version is available at http://adodb.sourceforge.net
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-active-recordx.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-active-recordx.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-active-recordx.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Latest version is available at http://adodb.sourceforge.net
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-csvlib.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-csvlib.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-csvlib.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -8,7 +8,7 @@
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-datadict.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-datadict.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-datadict.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-error.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-error.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-error.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/**
- * @version v5.20.4 30-Mar-2016
+ * @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-errorhandler.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-errorhandler.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-errorhandler.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/**
- * @version v5.20.4 30-Mar-2016
+ * @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-errorpear.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-errorpear.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-errorpear.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/**
- * @version v5.20.4 30-Mar-2016
+ * @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-exceptions.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-exceptions.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-exceptions.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- * @version v5.20.4 30-Mar-2016
+ * @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
@@ -33,16 +33,16 @@
case 'EXECUTE':
$this->sql = is_array($p1) ? $p1[0] : $p1;
$this->params = $p2;
- $s = "$dbms error: [$errno: $errmsg] in
$fn(\"$this->sql\")\n";
+ $s = "$dbms error: [$errno: $errmsg] in
$fn(\"$this->sql\")";
break;
case 'PCONNECT':
case 'CONNECT':
$user = $thisConnection->user;
- $s = "$dbms error: [$errno: $errmsg] in $fn($p1,
'$user', '****', $p2)\n";
+ $s = "$dbms error: [$errno: $errmsg] in $fn($p1,
'$user', '****', $p2)";
break;
default:
- $s = "$dbms error: [$errno: $errmsg] in $fn($p1,
$p2)\n";
+ $s = "$dbms error: [$errno: $errmsg] in $fn($p1, $p2)";
break;
}
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-iterator.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-iterator.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-iterator.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-lib.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-lib.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-lib.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -6,7 +6,7 @@
$ADODB_INCLUDED_LIB = 1;
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
@@ -426,7 +426,7 @@
if ( strpos($sql, '_ADODB_COUNT') !== FALSE ) {
$rewritesql =
preg_replace('/^\s*?SELECT\s+_ADODB_COUNT(.*)_ADODB_COUNT\s/is','SELECT
COUNT(*) ',$sql);
} else {
- $rewritesql =
preg_replace('/^\s*?SELECT\s.*?\s+(.*?)\s+FROM\s/is','SELECT COUNT(*) FROM
',$sql);
+ $rewritesql =
preg_replace('/^\s*SELECT\s.*\s+FROM\s/Uis','SELECT COUNT(*) FROM ',$sql);
}
// fix by alexander zhukov, alex#unipack.ru, because count(*)
and 'order by' fails
// with mssql, access and postgresql. Also a good speedup
optimization - skips sorting!
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-memcache.lib.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-memcache.lib.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-memcache.lib.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -11,7 +11,7 @@
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-pager.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-pager.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-pager.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights
reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb
community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-pear.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-pear.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-pear.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/**
- * @version v5.20.4 30-Mar-2016
+ * @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-perf.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-perf.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-perf.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-php4.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-php4.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-php4.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-time.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-time.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-time.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -3,7 +3,7 @@
ADOdb Date Library, part of the ADOdb abstraction library
Download: http://adodb.sourceforge.net/#download
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-xmlschema.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-xmlschema.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-xmlschema.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -157,7 +157,6 @@
* Destroys the object
*/
function destroy() {
- unset( $this );
}
/**
@@ -265,12 +264,14 @@
switch( $this->currentElement ) {
case 'INDEX':
if( !isset( $attributes['PLATFORM'] ) OR
$this->supportedPlatform( $attributes['PLATFORM'] ) ) {
- xml_set_object( $parser,
$this->addIndex( $attributes ) );
+ $index = $this->addIndex( $attributes );
+ xml_set_object( $parser, $index );
}
break;
case 'DATA':
if( !isset( $attributes['PLATFORM'] ) OR
$this->supportedPlatform( $attributes['PLATFORM'] ) ) {
- xml_set_object( $parser,
$this->addData( $attributes ) );
+ $data = $this->addData( $attributes );
+ xml_set_object( $parser, $data );
}
break;
case 'DROP':
@@ -2196,7 +2197,6 @@
function Destroy() {
ini_set("magic_quotes_runtime", $this->mgq );
#set_magic_quotes_runtime( $this->mgq );
- unset( $this );
}
}
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-xmlschema03.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-xmlschema03.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb-xmlschema03.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -175,7 +175,6 @@
* Destroys the object
*/
function destroy() {
- unset( $this );
}
/**
@@ -290,12 +289,14 @@
switch( $this->currentElement ) {
case 'INDEX':
if( !isset( $attributes['PLATFORM'] ) OR
$this->supportedPlatform( $attributes['PLATFORM'] ) ) {
- xml_set_object( $parser,
$this->addIndex( $attributes ) );
+ $index = $this->addIndex( $attributes );
+ xml_set_object( $parser, $index );
}
break;
case 'DATA':
if( !isset( $attributes['PLATFORM'] ) OR
$this->supportedPlatform( $attributes['PLATFORM'] ) ) {
- xml_set_object( $parser,
$this->addData( $attributes ) );
+ $data = $this->addData( $attributes );
+ xml_set_object( $parser, $data );
}
break;
case 'DROP':
@@ -2378,7 +2379,6 @@
function Destroy() {
ini_set("magic_quotes_runtime", $this->mgq );
#set_magic_quotes_runtime( $this->mgq );
- unset( $this );
}
}
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/adodb.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -14,7 +14,7 @@
/**
\mainpage
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights
reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb
community
@@ -37,6 +37,21 @@
if (!defined('_ADODB_LAYER')) {
define('_ADODB_LAYER',1);
+ // The ADOdb extension is no longer maintained and effectively
unsupported
+ // since v5.04. The library will not function properly if it is present.
+ if(defined('ADODB_EXTENSION')) {
+ $msg = "Unsupported ADOdb Extension (v" . ADODB_EXTENSION . ")
detected! "
+ . "Disable it to use ADOdb";
+
+ $errorfn = defined('ADODB_ERROR_HANDLER') ? ADODB_ERROR_HANDLER
: false;
+ if ($errorfn) {
+ $conn = false;
+ $errorfn('ADOdb', basename(__FILE__), -9999, $msg,
null, null, $conn);
+ } else {
+ die($msg . PHP_EOL);
+ }
+ }
+
//==============================================================================================
// CONSTANT DEFINITIONS
//==============================================================================================
@@ -217,7 +232,7 @@
/**
* ADODB version as a string.
*/
- $ADODB_vers = 'v5.20.4 30-Mar-2016';
+ $ADODB_vers = 'v5.20.9 21-Dec-2016';
/**
* Determines whether recordset->RecordCount() is used.
@@ -658,16 +673,16 @@
}
if (isset($rez)) {
$err = $this->ErrorMsg();
+ $errno = $this->ErrorNo();
if (empty($err)) {
$err = "Connection error to server
'$argHostname' with user '$argUsername'";
}
- $ret = false;
} else {
$err = "Missing extension for ".$this->dataProvider;
- $ret = 0;
+ $errno = 0;
}
if ($fn = $this->raiseErrorFn) {
-
$fn($this->databaseType,'CONNECT',$this->ErrorNo(),$err,$this->host,$this->database,$this);
+ $fn($this->databaseType, 'CONNECT', $errno, $err,
$this->host, $this->database, $this);
}
$this->_connectionID = false;
@@ -674,7 +689,7 @@
if ($this->debug) {
ADOConnection::outp( $this->host.': '.$err);
}
- return $ret;
+ return false;
}
function _nconnect($argHostname, $argUsername, $argPassword,
$argDatabaseName) {
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/composer.json
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/composer.json
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/composer.json
2017-03-21 13:31:35 UTC (rev 16464)
@@ -20,7 +20,7 @@
"keywords" : [ "database", "abstraction", "layer", "library", "php" ],
- "homepage": "http://adodb.sourceforge.net/",
+ "homepage": "http://adodb.org/",
"support" : {
"issues" : "https://github.com/ADOdb/ADOdb/issues",
"source" : "https://github.com/ADOdb/ADOdb"
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-access.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-access.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-access.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-db2.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-db2.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-db2.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-firebird.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-firebird.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-firebird.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-generic.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-generic.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-generic.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-ibase.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-ibase.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-ibase.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-informix.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-informix.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-informix.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mssql.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mssql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mssql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mssqlnative.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mssqlnative.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mssqlnative.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
@@ -146,19 +146,69 @@
return $sql;
}
- /*
- function AlterColumnSQL($tabname, $flds, $tableflds='',
$tableoptions='')
+ function DefaultConstraintname($tabname, $colname)
{
+ $constraintname = false;
+ $rs = $this->connection->Execute(
+ "SELECT name FROM sys.default_constraints
+ WHERE object_name(parent_object_id) = '$tabname'
+ AND col_name(parent_object_id, parent_column_id) =
'$colname'"
+ );
+ if ( is_object($rs) ) {
+ $row = $rs->FetchRow();
+ $constraintname = $row['name'];
+ }
+ return $constraintname;
+ }
+
+ function AlterColumnSQL($tabname, $flds, $tableflds='',$tableoptions='')
+ {
$tabname = $this->TableName ($tabname);
$sql = array();
- list($lines,$pkey) = $this->_GenFields($flds);
+
+ list($lines,$pkey,$idxs) = $this->_GenFields($flds);
+ $alter = 'ALTER TABLE ' . $tabname . $this->alterCol . ' ';
foreach($lines as $v) {
- $sql[] = "ALTER TABLE $tabname $this->alterCol $v";
+ $not_null = false;
+ if ($not_null = preg_match('/NOT NULL/i',$v)) {
+ $v = preg_replace('/NOT NULL/i','',$v);
+ }
+ if (preg_match('/^([^ ]+) .*DEFAULT
(\'[^\']+\'|\"[^\"]+\"|[^ ]+)/',$v,$matches)) {
+ list(,$colname,$default) = $matches;
+ $v = preg_replace('/^' . preg_quote($colname) .
'\s/', '', $v);
+ $t = trim(str_replace('DEFAULT
'.$default,'',$v));
+ if ( $constraintname =
$this->DefaultConstraintname($tabname,$colname) ) {
+ $sql[] = 'ALTER TABLE '.$tabname.' DROP
CONSTRAINT '. $constraintname;
+ }
+ if ($not_null) {
+ $sql[] = $alter . $colname . ' ' . $t
. ' NOT NULL';
+ } else {
+ $sql[] = $alter . $colname . ' ' . $t ;
+ }
+ $sql[] = 'ALTER TABLE ' . $tabname
+ . ' ADD CONSTRAINT DF__' . $tabname .
'__' . $colname . '__' . dechex(rand())
+ . ' DEFAULT ' . $default . ' FOR ' .
$colname;
+ } else {
+ $colname = strtok($v," ");
+ if ( $constraintname =
$this->DefaultConstraintname($tabname,$colname) ) {
+ $sql[] = 'ALTER TABLE '.$tabname.' DROP
CONSTRAINT '. $constraintname;
+ }
+ if ($not_null) {
+ $sql[] = $alter . $v . ' NOT NULL';
+ } else {
+ $sql[] = $alter . $v;
+ }
+ }
}
-
+ if (is_array($idxs)) {
+ foreach($idxs as $idx => $idxdef) {
+ $sql_idxs = $this->CreateIndexSql($idx,
$tabname, $idxdef['cols'], $idxdef['opts']);
+ $sql = array_merge($sql, $sql_idxs);
+ }
+ }
return $sql;
}
- */
+
/**
* Drop a column, syntax is ALTER TABLE table DROP COLUMN column,column
@@ -176,10 +226,12 @@
if (!is_array($flds))
$flds = explode(',',$flds);
$f = array();
- $s = 'ALTER TABLE ' . $tabname . ' DROP COLUMN ';
+ $s = 'ALTER TABLE ' . $tabname;
foreach($flds as $v) {
- //$f[] = "\n$this->dropCol ".$this->NameQuote($v);
- $f[] = $this->NameQuote($v);
+ if ( $constraintname =
$this->DefaultConstraintname($tabname,$v) ) {
+ $sql[] = 'ALTER TABLE ' . $tabname . ' DROP
CONSTRAINT ' . $constraintname;
+ }
+ $f[] = ' DROP COLUMN ' . $this->NameQuote($v);
}
$s .= implode(', ',$f);
$sql[] = $s;
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mysql.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mysql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-mysql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-oci8.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-oci8.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-oci8.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-postgres.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-postgres.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-postgres.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sapdb.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sapdb.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sapdb.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sqlite.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sqlite.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sqlite.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sybase.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sybase.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/datadict/datadict-sybase.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/docs/changelog.md
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/docs/changelog.md
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/docs/changelog.md
2017-03-21 13:31:35 UTC (rev 16464)
@@ -5,9 +5,46 @@
[v3.x](changelog_v3.x.md),
[v2.x](changelog_v2.x.md).
+## 5.20.9 - 21-Dec-2016
-## 5.20.4 - 30-Mar-2016
+- mssql: fix syntax error in version matching regex #305
+## 5.20.8 - 17-Dec-2016
+
+- mssql: support MSSQL Server 2016 and later #294
+- mssql: fix Find() returning no results. #298
+- mssql: fix Sequence name forced to 'adodbseq'. #295, #300
+- mssql: fix GenId() not returning next sequence value with SQL Server
2005/2008. #302
+- mssql: fix drop/alter column with existing default constraint. #290
+- mssql: fix PHP notice in MetaColumns(). #289
+- oci8po: fix inconsistent variable binding in SelectLimit() #288
+- oci8po: fix SelectLimit() with prepared statements #282
+
+## 5.20.7 - 20-Sep-2016
+
+- security: Fix SQL injection in PDO drivers qstr() method (CVE-2016-7405).
#226
+- oci8po: prevent segfault on PHP 7. #259
+- pdo/mysql: Fix MetaTables() method. #275
+
+## 5.20.6 - 31-Aug-2016
+
+- security: Fix XSS vulnerability in old test script (CVE-2016-4855). #274
+- adodb: Exit with error/exception when the ADOdb Extension is loaded. #269
+- adodb: Fix truncated exception messages. #273
+
+## 5.20.5 - 10-Aug-2016
+
+- adodb: Fix fatal error when connecting with missing extension. #254
+- adodb: Fix _adodb_getcount(). #236
+- mssql: Destructor fails if recordset already closed. #268
+- mssql: Use SQL server native data types if available. #234
+- mysqli: Fix PHP notice in _close() method. #240
+- pdo: Let driver handle SelectDB() and SQLDate() calls. #242
+- xml: Fix PHP strict warning. #260
+- xml: remove calls to 'unset($this)' (PHP 7.1 compatibility). #257
+
+## 5.20.4 - 31-Mar-2016
+
- adodb: Fix BulkBind() param count validation. #199
- mysqli: fix PHP warning in recordset destructor. #217
- mysqli: cast port number to int when connecting (PHP7 compatibility). #218
@@ -19,6 +56,7 @@
## 5.20.2 - 27-Dec-2015
- adodb: Remove a couple leftover PHP 4.x constructors (PHP7 compatibility).
#139
+- db2ora: Remove deprecated preg_replace '/e' flag (PHP7 compatibility). #168
- mysql: MoveNext() now respects ADODB_ASSOC_CASE. #167
- mssql, mysql, informix: Avoid PHP warning when closing recordset from
destructor. #170
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-access.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-access.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-access.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado5.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado5.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado5.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado_access.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado_access.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado_access.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado_mssql.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado_mssql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ado_mssql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-borland_ibase.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-borland_ibase.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-borland_ibase.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-csv.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-csv.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-csv.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2oci.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2oci.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2oci.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2ora.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2ora.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-db2ora.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-fbsql.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-fbsql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-fbsql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-firebird.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-firebird.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-firebird.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ibase.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ibase.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ibase.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-informix.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-informix.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-informix.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/**
-* @version v5.20.4 30-Mar-2016
+* @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-informix72.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-informix72.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-informix72.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim. All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ldap.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ldap.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-ldap.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssql.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssqlnative.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssqlnative.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssqlnative.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
@@ -125,6 +125,7 @@
var $_bindInputArray = true;
var $_dropSeqSQL = "drop table %s";
var $connectionInfo = array();
+ var $cachedSchemaFlush = false;
var $sequences = false;
var $mssql_version = '';
@@ -143,27 +144,24 @@
sqlsrv_configure('WarningsReturnAsErrors', 0);
}
}
+
+ /**
+ * Initializes the SQL Server version.
+ * Dies if connected to a non-supported version (2000 and older)
+ */
function ServerVersion() {
$data = $this->ServerInfo();
- if (preg_match('/^09/',$data['version'])){
- /*
- * SQL Server 2005
- */
- $this->mssql_version = 9;
- } elseif (preg_match('/^10/',$data['version'])){
- /*
- * SQL Server 2008
- */
- $this->mssql_version = 10;
- } elseif (preg_match('/^11/',$data['version'])){
- /*
- * SQL Server 2012
- */
- $this->mssql_version = 11;
- } else
+ preg_match('/^\d{2}/', $data['version'], $matches);
+ $version = (int)reset($matches);
+
+ // We only support SQL Server 2005 and up
+ if($version < 9) {
die("SQL SERVER VERSION {$data['version']} NOT
SUPPORTED IN mssqlnative DRIVER");
}
+ $this->mssql_version = $version;
+ }
+
function ServerInfo() {
global $ADODB_FETCH_MODE;
static $arr = false;
@@ -211,10 +209,10 @@
switch($this->mssql_version){
case 9:
case 10:
- return $this->GenID2008();
+ return $this->GenID2008($seq, $start);
break;
- case 11:
- return $this->GenID2012();
+ default:
+ return $this->GenID2012($seq, $start);
break;
}
}
@@ -221,16 +219,16 @@
function CreateSequence($seq='adodbseq',$start=1)
{
- if (!$this->mssql_vesion)
+ if (!$this->mssql_version)
$this->ServerVersion();
switch($this->mssql_version){
case 9:
case 10:
- return $this->CreateSequence2008();
+ return $this->CreateSequence2008($seq, $start);
break;
- case 11:
- return $this->CreateSequence2012();
+ default:
+ return $this->CreateSequence2012($seq, $start);
break;
}
@@ -258,7 +256,7 @@
/**
* Proper Sequences Only available to Server 2012 and up
*/
- function CreateSequence2012($seq='adodb',$start=1){
+ function CreateSequence2012($seq='adodbseq',$start=1){
if (!$this->sequences){
$sql = "SELECT name FROM sys.sequences";
$this->sequences = $this->GetCol($sql);
@@ -289,7 +287,7 @@
}
$num = $this->GetOne("select id from $seq");
sqlsrv_commit($this->_connectionID);
- return true;
+ return $num;
}
/**
* Only available to Server 2012 and up
@@ -313,7 +311,7 @@
}
if (!is_array($this->sequences)
|| is_array($this->sequences) &&
!in_array($seq,$this->sequences)){
- $this->CreateSequence2012($seq='adodbseq',$start=1);
+ $this->CreateSequence2012($seq, $start);
}
$num = $this->GetOne("SELECT NEXT VALUE FOR $seq");
@@ -468,10 +466,9 @@
function ErrorNo()
{
- if ($this->_logsql && $this->_errorCode !== false) return
$this->_errorCode;
$err = sqlsrv_errors(SQLSRV_ERR_ALL);
if($err[0]) return $err[0]['code'];
- else return -1;
+ else return 0;
}
// returns true or false
@@ -569,7 +566,7 @@
$insert = false;
// handle native driver flaw for retrieving the last insert ID
-
if(preg_match('/^\W*insert\s(?:(?:(?:\'\')*\'[^\']+\'(?:\'\')*)|[^;\'])*;?$/i',
$sql)) {
+
if(preg_match('/^\W*insert[\s\w()",.]+values\s*\((?:[^;\']|\'\'|(?:(?:\'\')*\'[^\']+\'(?:\'\')*))*;?$/i',
$sql)) {
$insert = true;
$sql .= '; '.$this->identitySQL; // select
scope_identity()
}
@@ -1074,7 +1071,7 @@
is running. All associated result memory for the specified
result identifier will automatically be freed. */
function _close()
{
- if($this->_queryID) {
+ if(is_object($this->_queryID)) {
$rez = sqlsrv_free_stmt($this->_queryID);
$this->_queryID = false;
return $rez;
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssqlpo.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssqlpo.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mssqlpo.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/**
-* @version v5.20.4 30-Mar-2016
+* @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysql.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqli.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqli.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqli.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
@@ -1054,7 +1054,7 @@
//if results are attached to this pointer from Stored Proceedure
calls, the next standard query will die 2014
//only a problem with persistant connections
- if($this->connection->_connectionID) {
+ if(isset($this->connection->_connectionID) &&
$this->connection->_connectionID) {
while(mysqli_more_results($this->connection->_connectionID)){
mysqli_next_result($this->connection->_connectionID);
}
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqlpo.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqlpo.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqlpo.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqlt.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqlt.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-mysqlt.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-netezza.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-netezza.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-netezza.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim. All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
@@ -703,9 +703,19 @@
* This implementation does not appear to work with oracle 8.0.5 or
earlier.
* Comment out this function then, and the slower SelectLimit() in the
base
* class will be used.
+ *
+ * Note: FIRST_ROWS hinting is only used if $sql is a string; when
+ * processing a prepared statement's handle, no hinting is performed.
*/
function SelectLimit($sql,$nrows=-1,$offset=-1,
$inputarr=false,$secs2cache=0)
{
+ // Since the methods used to limit the number of returned rows
rely
+ // on modifying the provided SQL query, we can't work with
prepared
+ // statements so we just extract the SQL string.
+ if(is_array($sql)) {
+ $sql = $sql[0];
+ }
+
// seems that oracle only supports 1 hint comment in 8i
if ($this->firstrows) {
if ($nrows > 500 && $nrows < 1000) {
@@ -731,20 +741,13 @@
if ($offset > 0) {
$nrows += $offset;
}
- //$inputarr['adodb_rownum'] = $nrows;
- if ($this->databaseType == 'oci8po') {
- $sql = "select * from (".$sql.") where
rownum <= ?";
- } else {
$sql = "select * from (".$sql.") where
rownum <= :adodb_offset";
- }
$inputarr['adodb_offset'] = $nrows;
$nrows = -1;
}
// note that $nrows = 0 still has to work ==> no rows
returned
- $rs =
ADOConnection::SelectLimit($sql,$nrows,$offset,$inputarr,$secs2cache);
- return $rs;
-
+ return ADOConnection::SelectLimit($sql, $nrows,
$offset, $inputarr, $secs2cache);
} else {
// Algorithm by Tomas V V Cox, from PEAR DB oci8.php
@@ -758,13 +761,19 @@
if (is_array($inputarr)) {
foreach($inputarr as $k => $v) {
+ $i=0;
+ if ($this->databaseType == 'oci8po') {
+ $bv_name = ":".$i++;
+ } else {
+ $bv_name = ":".$k;
+ }
if (is_array($v)) {
// suggested by address@hidden
if (sizeof($v) == 2) {
-
oci_bind_by_name($stmt,":$k",$inputarr[$k][0],$v[1]);
+
oci_bind_by_name($stmt,$bv_name,$inputarr[$k][0],$v[1]);
}
else {
-
oci_bind_by_name($stmt,":$k",$inputarr[$k][0],$v[1],$v[2]);
+
oci_bind_by_name($stmt,$bv_name,$inputarr[$k][0],$v[1],$v[2]);
}
} else {
$len = -1;
@@ -774,7 +783,7 @@
if (isset($bindarr)) { // is
prepared sql, so no need to oci_bind_by_name again
$bindarr[$k] = $v;
} else {
// dynamic sql, so rebind every time
-
oci_bind_by_name($stmt,":$k",$inputarr[$k],$len);
+
oci_bind_by_name($stmt,$bv_name,$inputarr[$k],$len);
}
}
}
@@ -801,17 +810,10 @@
}
$offset += 1; // in Oracle rownum starts at 1
- if ($this->databaseType == 'oci8po') {
$sql = "SELECT $hint $fields FROM".
"(SELECT rownum as adodb_rownum,
$fields FROM".
- " ($sql) WHERE rownum <= ?".
- ") WHERE adodb_rownum >= ?";
- } else {
- $sql = "SELECT $hint $fields FROM".
- "(SELECT rownum as adodb_rownum,
$fields FROM".
" ($sql) WHERE rownum <=
:adodb_nrows".
") WHERE adodb_rownum >=
:adodb_offset";
- }
$inputarr['adodb_nrows'] = $nrows;
$inputarr['adodb_offset'] = $offset;
@@ -818,7 +820,9 @@
if ($secs2cache > 0) {
$rs = $this->CacheExecute($secs2cache,
$sql,$inputarr);
}
- else $rs = $this->Execute($sql,$inputarr);
+ else {
+ $rs = $this->Execute($sql, $inputarr);
+ }
return $rs;
}
}
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci805.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci805.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci805.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/**
- * @version v5.20.4 30-Mar-2016
+ * @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8po.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8po.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8po.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim. All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
@@ -56,6 +56,21 @@
return ADOConnection::Execute($sql,$inputarr);
}
+ /**
+ * The optimizations performed by ADODB_oci8::SelectLimit() are not
+ * compatible with the oci8po driver, so we rely on the slower method
+ * from the base class.
+ * We can't properly handle prepared statements either due to
preprocessing
+ * of query parameters, so we treat them as regular SQL statements.
+ */
+ function SelectLimit($sql, $nrows=-1, $offset=-1, $inputarr=false,
$secs2cache=0)
+ {
+ if(is_array($sql)) {
+// $sql = $sql[0];
+ }
+ return ADOConnection::SelectLimit($sql, $nrows, $offset,
$inputarr, $secs2cache);
+ }
+
// emulate handling of parameters ? ?, replacing with :bind0 :bind1
function _query($sql,$inputarr=false)
{
@@ -74,12 +89,15 @@
$sql = str_replace($qmMatch,
$qmReplace, $sql);
}
+ // Replace parameters if any were found
$sqlarr = explode('?',$sql);
+ if(count($sqlarr) > 1) {
$sql = $sqlarr[0];
- foreach($inputarr as $k => $v) {
+ foreach ($inputarr as $k => $v) {
$sql .= ":$k" . $sqlarr[++$i];
}
+ }
$sql = str_replace('-QUESTIONMARK-', '?', $sql);
}
@@ -138,8 +156,10 @@
// 10% speedup to move MoveNext to child class
function MoveNext()
{
-
if(@OCIfetchinto($this->_queryID,$this->fields,$this->fetchMode)) {
+ $ret = @oci_fetch_array($this->_queryID,$this->fetchMode);
+ if($ret !== false) {
global $ADODB_ANSI_PADDING_OFF;
+ $this->fields = $ret;
$this->_currentRow++;
$this->_updatefields();
@@ -169,10 +189,12 @@
$arr = array();
return $arr;
}
- if
(address@hidden($this->_queryID,$this->fields,$this->fetchMode)) {
+ $ret = @oci_fetch_array($this->_queryID,$this->fetchMode);
+ if ($ret === false) {
$arr = array();
return $arr;
}
+ $this->fields = $ret;
$this->_updatefields();
$results = array();
$cnt = 0;
@@ -188,8 +210,9 @@
{
global $ADODB_ANSI_PADDING_OFF;
- $ret =
@OCIfetchinto($this->_queryID,$this->fields,$this->fetchMode);
+ $ret = @oci_fetch_array($this->_queryID,$this->fetchMode);
if ($ret) {
+ $this->fields = $ret;
$this->_updatefields();
if (!empty($ADODB_ANSI_PADDING_OFF)) {
@@ -198,7 +221,7 @@
}
}
}
- return $ret;
+ return $ret !== false;
}
}
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8quercus.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8quercus.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oci8quercus.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim. All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_db2.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_db2.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_db2.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_mssql.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_mssql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_mssql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_oracle.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_oracle.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbc_oracle.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbtp.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbtp.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbtp.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbtp_unicode.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbtp_unicode.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-odbtp_unicode.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights
reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb
community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oracle.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oracle.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-oracle.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/**
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights
reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb
community
@@ -196,6 +196,7 @@
$this->_driver->_connectionID = $this->_connectionID;
$this->_UpdatePDO();
+ $this->_driver->database = $this->database;
return true;
}
$this->_driver = new ADODB_pdo_base();
@@ -266,6 +267,16 @@
return $this->_driver->OffsetDate($dayFraction,$date);
}
+ function SelectDB($dbName)
+ {
+ return $this->_driver->SelectDB($dbName);
+ }
+
+ function SQLDate($fmt, $col=false)
+ {
+ return $this->_driver->SQLDate($fmt, $col);
+ }
+
function ErrorMsg()
{
if ($this->_errormsg !== false) {
@@ -507,6 +518,30 @@
{
return ($this->_connectionID) ?
$this->_connectionID->lastInsertId() : 0;
}
+
+ /**
+ * Quotes a string to be sent to the database.
+ * If we have an active connection, delegates quoting to the underlying
+ * PDO object. Otherwise, replace "'" by the value of $replaceQuote
(same
+ * behavior as mysqli driver)
+ * @param string $s The string to quote
+ * @param boolean $magic_quotes If false, use PDO::quote().
+ * @return string Quoted string
+ */
+ function qstr($s, $magic_quotes = false)
+ {
+ if (!$magic_quotes) {
+ if ($this->_connectionID) {
+ return $this->_connectionID->quote($s);
+ }
+ return "'" . str_replace("'", $this->replaceQuote, $s)
. "'";
+ }
+
+ // undo magic quotes for "
+ $s = str_replace('\\"', '"', $s);
+ return "'$s'";
+ }
+
}
class ADODB_pdo_base extends ADODB_pdo {
@@ -699,12 +734,22 @@
}
//adodb_pr($arr);
$o->name = $arr['name'];
- if (isset($arr['native_type']) && $arr['native_type'] <>
"null") {
+ if (isset($arr['sqlsrv:decl_type']) && $arr['sqlsrv:decl_type']
<> "null")
+ {
+ /*
+ * If the database is SQL server, use the native built-ins
+ */
+ $o->type = $arr['sqlsrv:decl_type'];
+ }
+ elseif (isset($arr['native_type']) && $arr['native_type'] <>
"null")
+ {
$o->type = $arr['native_type'];
}
- else {
+ else
+ {
$o->type = adodb_pdo_type($arr['pdo_type']);
}
+
$o->max_length = $arr['len'];
$o->precision = $arr['precision'];
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_mssql.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_mssql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_mssql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -2,7 +2,7 @@
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_mysql.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_mysql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_mysql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
@@ -70,7 +70,9 @@
{
$save = $this->metaTablesSQL;
if ($showSchema && is_string($showSchema)) {
- $this->metaTablesSQL .= " from $showSchema";
+ $this->metaTablesSQL .= $this->qstr($showSchema);
+ } else {
+ $this->metaTablesSQL .= 'schema()';
}
if ($mask) {
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_oci.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_oci.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_oci.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -2,7 +2,7 @@
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_pgsql.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_pgsql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_pgsql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_sqlite.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_sqlite.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-pdo_sqlite.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres64.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres64.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres64.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres7.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres7.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres7.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres8.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres8.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres8.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres9.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres9.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-postgres9.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-proxy.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-proxy.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-proxy.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sapdb.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sapdb.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sapdb.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlanywhere.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlanywhere.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlanywhere.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
reserved.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlite.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlite.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlite.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlite3.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlite3.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlite3.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlitepo.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlitepo.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sqlitepo.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sybase.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sybase.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sybase.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim. All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sybase_ase.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sybase_ase.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-sybase_ase.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-vfp.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-vfp.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/drivers/adodb-vfp.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/pear/Auth/Container/ADOdb.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/pear/Auth/Container/ADOdb.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/pear/Auth/Container/ADOdb.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-db2.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-db2.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-db2.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-informix.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-informix.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-informix.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mssql.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mssql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mssql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mssqlnative.inc.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mssqlnative.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mssqlnative.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mysql.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mysql.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-mysql.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-oci8.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-oci8.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-oci8.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-postgres.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-postgres.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/perf/perf-postgres.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/pivottable.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/pivottable.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/pivottable.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/**
- * @version v5.20.4 30-Mar-2016
+ * @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/rsfilter.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/rsfilter.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/rsfilter.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/**
- * @version v5.20.4 30-Mar-2016
+ * @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/server.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/server.php 2017-03-21
13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/server.php 2017-03-21
13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- * @version v5.20.4 30-Mar-2016
+ * @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-compress-bzip2.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-compress-bzip2.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-compress-bzip2.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Contributed by Ross Smith (address@hidden).
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-compress-gzip.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-compress-gzip.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-compress-gzip.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -2,7 +2,7 @@
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Contributed by Ross Smith (address@hidden).
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-cryptsession.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-cryptsession.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-cryptsession.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -2,7 +2,7 @@
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Contributed by Ross Smith (address@hidden).
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-cryptsession2.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-cryptsession2.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-cryptsession2.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -2,7 +2,7 @@
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Contributed by Ross Smith (address@hidden).
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-mcrypt.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-mcrypt.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-mcrypt.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -2,7 +2,7 @@
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Contributed by Ross Smith (address@hidden).
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-md5.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-md5.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-md5.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Contributed by Ross Smith (address@hidden).
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-secret.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-secret.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-encrypt-secret.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Contributed by Ross Smith (address@hidden).
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session-clob.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session-clob.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session-clob.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -2,7 +2,7 @@
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Contributed by Ross Smith (address@hidden).
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session-clob2.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session-clob2.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session-clob2.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -2,7 +2,7 @@
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Contributed by Ross Smith (address@hidden).
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -2,7 +2,7 @@
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Contributed by Ross Smith (address@hidden).
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session2.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session2.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/session/adodb-session2.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -2,7 +2,7 @@
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Contributed by Ross Smith (address@hidden).
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-cryptsession.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-cryptsession.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-cryptsession.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-session-clob.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-session-clob.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-session-clob.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified:
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-session.php
===================================================================
---
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-session.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/phpgwapi/inc/adodb/session/old/adodb-session.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
address@hidden v5.20.4 30-Mar-2016
address@hidden v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/toexport.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/toexport.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/toexport.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,7 +1,7 @@
<?php
/**
- * @version v5.20.4 30-Mar-2016
+ * @version v5.20.9 21-Dec-2016
* @copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
* @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
* Released under both BSD license and Lesser GPL library license.
Modified: branches/Version-2_0-branch/phpgwapi/inc/adodb/tohtml.inc.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/tohtml.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/tohtml.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -1,6 +1,6 @@
<?php
/*
- @version v5.20.4 30-Mar-2016
+ @version v5.20.9 21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
Released under both BSD license and Lesser GPL library license.
Deleted: branches/Version-2_0-branch/phpgwapi/inc/adodb/x.php
===================================================================
--- branches/Version-2_0-branch/phpgwapi/inc/adodb/x.php 2017-03-21
13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/phpgwapi/inc/adodb/x.php 2017-03-21
13:31:35 UTC (rev 16464)
@@ -1,9 +0,0 @@
-<?php
-include('adodb.inc.php');
-
-$db = adonewconnection('mysqli');
-$db->connect('localhost', 'root', 'C0yote71', 'mantis_13x');
-
-$t = 'mantis_user_table';
-$c = array('username' => 'test');
-print $db->getinsertsql($t, $c) . PHP_EOL;
Modified: branches/Version-2_0-branch/property/inc/class.boworkorder.inc.php
===================================================================
--- branches/Version-2_0-branch/property/inc/class.boworkorder.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/property/inc/class.boworkorder.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -135,6 +135,12 @@
'name' => lang('accounting dim b'),
'sortable' => true
);
+ $columns['service_id'] = array
+ (
+ 'id' => 'service_id',
+ 'name' => lang('service'),
+ 'sortable' => true
+ );
$columns['entry_date'] = array
(
'id' => 'entry_date',
Modified: branches/Version-2_0-branch/property/inc/class.soworkorder.inc.php
===================================================================
--- branches/Version-2_0-branch/property/inc/class.soworkorder.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/property/inc/class.soworkorder.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -238,6 +238,8 @@
$cols.= ",fm_project.ecodimb";
$cols_return[] = 'ecodimb';
+ $cols.= ",fm_workorder.service_id";
+ $cols_return[] = 'service_id';
$cols.= ",fm_workorder.contract_sum";
$cols_return[] = 'contract_sum';
$cols.= ",fm_workorder.approved";
@@ -514,9 +516,13 @@
$ordermethod = " ORDER BY
fm_workorder.inspection_on_completion {$sort}, fm_workorder.id";
break;
case 'ecodimb':
- $order_field = ",
fm_project.ecodimb";
+ $order_field = ",
fm_workorder.ecodimb";
$ordermethod = " ORDER BY
fm_workorder.ecodimb {$sort}, fm_workorder.id";
break;
+ case 'service_id':
+ $order_field = ",
fm_workorder.service_id";
+ $ordermethod = " ORDER BY
fm_workorder.service_id {$sort}, fm_workorder.id";
+ break;
case 'budget':
$order_field = ",
fm_workorder.budget";
$ordermethod = " ORDER BY
fm_workorder.budget {$sort}, fm_workorder.id";
@@ -1396,6 +1402,8 @@
function edit( $workorder )
{
+ $config = CreateObject('phpgwapi.config','property');
+ $config->read_repository();
$historylog = CreateObject('property.historylog',
'workorder');
$workorder['descr'] =
$this->db->db_addslashes($workorder['descr']);
$workorder['title'] =
$this->db->db_addslashes($workorder['title']);
@@ -1425,8 +1433,6 @@
/* else if
($this->db->f('calculation') > 0)
{
$calculation = $this->db->f('calculation');
- $config =
CreateObject('phpgwapi.config','property');
- $config->read_repository();
$tax = 1+(($config->config_data['fm_tax'])/100);
$combined_cost = $calculation * $tax;
} */
@@ -1478,12 +1484,15 @@
'contract_id' =>
$workorder['contract_id'],
'tax_code' => $workorder['tax_code'],
'unspsc_code' => $workorder['unspsc_code'],
- 'service_id' => $workorder['service_id'],
'building_part' => $workorder['building_part'],
'order_dim1' => $workorder['order_dim1'],
'mail_recipients' =>
isset($workorder['vendor_email']) && is_array($workorder['vendor_email']) ?
implode(',', $workorder['vendor_email']) : '',
);
+
if(isset($config->config_data['enable_order_service_id']) &&
$config->config_data['enable_order_service_id'])
+ {
+ $value_set['service_id'] =
$workorder['service_id'];
+ }
$this->db->query("SELECT closed AS is_closed FROM
fm_workorder_status WHERE id = '{$workorder['status']}'");
$this->db->next_record();
Modified: branches/Version-2_0-branch/property/inc/class.uitts.inc.php
===================================================================
--- branches/Version-2_0-branch/property/inc/class.uitts.inc.php
2017-03-21 13:28:41 UTC (rev 16463)
+++ branches/Version-2_0-branch/property/inc/class.uitts.inc.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -263,7 +263,7 @@
$content = file_get_contents($file);
$browser = CreateObject('phpgwapi.browser');
- $browser->content_header($document['name'], '',
$size);
+ $browser->content_header($file_name, '', $size);
echo $content;
}
Modified:
branches/Version-2_0-branch/property/inc/custom/default/BkBygg_lag_Agresso_ordre_fra_melding.php
===================================================================
---
branches/Version-2_0-branch/property/inc/custom/default/BkBygg_lag_Agresso_ordre_fra_melding.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/property/inc/custom/default/BkBygg_lag_Agresso_ordre_fra_melding.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -116,7 +116,7 @@
}
// $ressursnr =
$GLOBALS['phpgw_info']['user']['preferences']['property']['ressursnr'];
- $address = substr(htmlspecialchars($_ticket['address'],
ENT_QUOTES, 'UTF-8', true), 0, 50);
+ $address =
mb_substr(htmlspecialchars($_ticket['address'], ENT_QUOTES, 'UTF-8', true), 0,
50);
$buyer = array(
@@ -187,7 +187,7 @@
'dim6' => $dim6,
// Aktivitet - frivillig: bygningsdel, 3 siffer +
bokstavkode
'vendor_id' => $_ticket['vendor_id'],
'vendor_name' => $vendor['name'],
- 'vendor_address' => substr($vendor['address'],
0, 50),
+ 'vendor_address' =>
mb_substr($vendor['address'], 0, 50),
'order_id' => $_ticket['order_id'],
'tax_code' => $_ticket['tax_code'],
'buyer' => $buyer,
Modified:
branches/Version-2_0-branch/property/inc/custom/default/BkBygg_lag_Agresso_ordre_fra_workorder.php
===================================================================
---
branches/Version-2_0-branch/property/inc/custom/default/BkBygg_lag_Agresso_ordre_fra_workorder.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/property/inc/custom/default/BkBygg_lag_Agresso_ordre_fra_workorder.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -163,7 +163,7 @@
$address = implode(', ', $_address);
}
- $address = substr(htmlspecialchars($address,
ENT_QUOTES, 'UTF-8', true), 0, 50);
+ $address = mb_substr(htmlspecialchars($address,
ENT_QUOTES, 'UTF-8', true), 0, 50);
$buyer = array(
'Name' => $user_name,
@@ -225,8 +225,10 @@
break;
}
- $tjeneste = $workorder['service_id'] ?
$workorder['service_id'] : $tjeneste;
+ $tjeneste = $workorder['service_id'] ?
(int)$workorder['service_id'] : (int)$tjeneste;
+ $GLOBALS['phpgw']->db->query("UPDATE
fm_workorder SET service_id = {$tjeneste} WHERE id = {$workorder['id']}");
+
// _debug_array($location_info);die();
$collect_building_part = false;
@@ -289,7 +291,7 @@
'dim6' => $dim6, // Aktivitet -
frivillig: bygningsdel, 3 siffer + bokstavkode
'vendor_id' => $workorder['vendor_id'],
'vendor_name' => $vendor['name'],
- 'vendor_address' =>
substr($vendor['address'], 0, 50),
+ 'vendor_address' =>
mb_substr($vendor['address'], 0, 50),
'order_id' => $workorder['id'],
'tax_code' => $tax_code,
'buyer' => $buyer,
Modified:
branches/Version-2_0-branch/property/inc/custom/default/LRS_oppdater_el_anlegg.php
===================================================================
---
branches/Version-2_0-branch/property/inc/custom/default/LRS_oppdater_el_anlegg.php
2017-03-21 13:28:41 UTC (rev 16463)
+++
branches/Version-2_0-branch/property/inc/custom/default/LRS_oppdater_el_anlegg.php
2017-03-21 13:31:35 UTC (rev 16464)
@@ -95,7 +95,7 @@
{
xmlwriter_start_element($memory, 'Tree');
xmlwriter_write_element($memory, 'ID', 'TJ');
- xmlwriter_write_element($memory, 'Verdi',
substr($this->db->f('maalepunkt_id'), -8));
+ xmlwriter_write_element($memory, 'Verdi',
mb_substr($this->db->f('maalepunkt_id'), -8));
xmlwriter_write_element($memory, 'Beskrivelse',
$this->db->f('address'));
xmlwriter_write_element($memory, 'Firma', 'BB');
xmlwriter_write_element($memory, 'PeriodeFra',
$PeriodFrom);
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [16464] Stable: Merge 16454:16463 from trunk,
sigurdne <=