diff options
| author | zotlabs <mike@macgirvin.com> | 2016-10-12 18:15:12 -0700 |
|---|---|---|
| committer | zotlabs <mike@macgirvin.com> | 2016-10-12 18:15:12 -0700 |
| commit | 9bb847bb07ec017eb8e2ebb2764b7e34acf5e619 (patch) | |
| tree | 801e83538f88a96966887a31dd7c10eb951c93e5 /Zotlabs/Module | |
| parent | 40bfce463d13a82a30ae590d650b916a051b8d31 (diff) | |
| download | volse-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/Module')
| -rw-r--r-- | Zotlabs/Module/Import.php | 26 | ||||
| -rw-r--r-- | Zotlabs/Module/Profiles.php | 6 |
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])) . "')" ); |