aboutsummaryrefslogtreecommitdiffstats
path: root/Zotlabs
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2016-10-12 18:15:12 -0700
committerzotlabs <mike@macgirvin.com>2016-10-12 18:15:12 -0700
commit9bb847bb07ec017eb8e2ebb2764b7e34acf5e619 (patch)
tree801e83538f88a96966887a31dd7c10eb951c93e5 /Zotlabs
parent40bfce463d13a82a30ae590d650b916a051b8d31 (diff)
downloadvolse-hubzilla-9bb847bb07ec017eb8e2ebb2764b7e34acf5e619.tar.gz
volse-hubzilla-9bb847bb07ec017eb8e2ebb2764b7e34acf5e619.tar.bz2
volse-hubzilla-9bb847bb07ec017eb8e2ebb2764b7e34acf5e619.zip
remove the rest of the backticks from sql queries; replace with TQUOT const which is driver dependent
Diffstat (limited to 'Zotlabs')
-rw-r--r--Zotlabs/Module/Import.php26
-rw-r--r--Zotlabs/Module/Profiles.php6
2 files changed, 16 insertions, 16 deletions
diff --git a/Zotlabs/Module/Import.php b/Zotlabs/Module/Import.php
index ccad4eace..bf47f2e4c 100644
--- a/Zotlabs/Module/Import.php
+++ b/Zotlabs/Module/Import.php
@@ -301,9 +301,9 @@ class Import extends \Zotlabs\Web\Controller {
dbesc_array($xchan);
- $r = dbq("INSERT INTO xchan (`"
- . implode("`, `", array_keys($xchan))
- . "`) VALUES ('"
+ $r = dbq("INSERT INTO xchan (" . TQUOT
+ . implode(TQUOT . ", " . TQUOT, array_keys($xchan))
+ . TQUOT . ") VALUES ('"
. implode("', '", array_values($xchan))
. "')" );
@@ -387,9 +387,9 @@ class Import extends \Zotlabs\Web\Controller {
}
dbesc_array($abook);
- $r = dbq("INSERT INTO abook (`"
- . implode("`, `", array_keys($abook))
- . "`) VALUES ('"
+ $r = dbq("INSERT INTO abook (" . TQUOT
+ . implode(TQUOT . ", " . TQUOT, array_keys($abook))
+ . TQUOT . ") VALUES ('"
. implode("', '", array_values($abook))
. "')" );
@@ -429,13 +429,13 @@ class Import extends \Zotlabs\Web\Controller {
unset($group['id']);
$group['uid'] = $channel['channel_id'];
dbesc_array($group);
- $r = dbq("INSERT INTO groups (`"
- . implode("`, `", array_keys($group))
- . "`) VALUES ('"
+ $r = dbq("INSERT INTO groups (" . TQUOT
+ . implode(TQUOT . ", " . TQUOT, array_keys($group))
+ . TQUOT . ") VALUES ('"
. implode("', '", array_values($group))
. "')" );
}
- $r = q("select * from `groups` where uid = %d",
+ $r = q("select * from groups where uid = %d",
intval($channel['channel_id'])
);
if($r) {
@@ -456,9 +456,9 @@ class Import extends \Zotlabs\Web\Controller {
$group_member['gid'] = $x['new'];
}
dbesc_array($group_member);
- $r = dbq("INSERT INTO group_member (`"
- . implode("`, `", array_keys($group_member))
- . "`) VALUES ('"
+ $r = dbq("INSERT INTO group_member (" . TQUOT
+ . implode(TQUOT . ", " . TQUOT, array_keys($group_member))
+ . TQUOT . ") VALUES ('"
. implode("', '", array_values($group_member))
. "')" );
}
diff --git a/Zotlabs/Module/Profiles.php b/Zotlabs/Module/Profiles.php
index 4cb8e7395..6f76cd1cf 100644
--- a/Zotlabs/Module/Profiles.php
+++ b/Zotlabs/Module/Profiles.php
@@ -119,9 +119,9 @@ class Profiles extends \Zotlabs\Web\Controller {
dbesc_array($r1[0]);
- $r2 = dbq("INSERT INTO profile (`"
- . implode("`, `", array_keys($r1[0]))
- . "`) VALUES ('"
+ $r2 = dbq("INSERT INTO profile (" . TQUOT
+ . implode(TQUOT . ", " . TQUOT, array_keys($r1[0]))
+ . TQUOT . ") VALUES ('"
. implode("', '", array_values($r1[0]))
. "')" );