projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Cleanup on key_in_foreign_table calls, removed obsolete $escaped argument.
[fa-stable.git]
/
admin
/
db
/
company_db.inc
diff --git
a/admin/db/company_db.inc
b/admin/db/company_db.inc
index c1197dcce8bb05cd5753114aaf5196b0468c6533..b75251d5feabc2cc0d3df5e95c29f1f061853660 100644
(file)
--- a/
admin/db/company_db.inc
+++ b/
admin/db/company_db.inc
@@
-177,10
+177,8
@@
function get_payment_terms_all($show_inactive)
value is name of foreign key field. For numeric keys $stdkey field name is used.
$stdkey - standard name of foreign key.
*/
value is name of foreign key field. For numeric keys $stdkey field name is used.
$stdkey - standard name of foreign key.
*/
-function key_in_foreign_table($id, $tables, $stdkey
, $escaped=false
)
+function key_in_foreign_table($id, $tables, $stdkey)
{
{
- if (!$escaped)
- $id = db_escape($id);
if (!is_array($tables))
$tables = array($tables);
if (!is_array($tables))
$tables = array($tables);
@@
-191,7
+189,7
@@
function key_in_foreign_table($id, $tables, $stdkey, $escaped=false)
$tbl = $key;
$key = $stdkey;
}
$tbl = $key;
$key = $stdkey;
}
- $sqls[] = "(SELECT COUNT(*) as cnt FROM
".TB_PREF."$tbl WHERE $key=$id
)\n";
+ $sqls[] = "(SELECT COUNT(*) as cnt FROM
`".TB_PREF."$tbl` WHERE `$key`=".db_escape($id)."
)\n";
}
$sql = "SELECT sum(cnt) FROM (". implode(' UNION ', $sqls).") as counts";
}
$sql = "SELECT sum(cnt) FROM (". implode(' UNION ', $sqls).") as counts";