diff options
| author | zotlabs <mike@macgirvin.com> | 2016-10-09 16:31:04 -0700 |
|---|---|---|
| committer | zotlabs <mike@macgirvin.com> | 2016-10-09 16:31:04 -0700 |
| commit | e7233c0c94d0464994df94d8907518d49fcb0650 (patch) | |
| tree | face7f2e2c8b6212349e769f6c552138006e1f1e /Zotlabs/Module/Admin | |
| parent | 2bdf135cbcf6208a4c2400d846b2fbffd8ae2c6b (diff) | |
| download | volse-hubzilla-e7233c0c94d0464994df94d8907518d49fcb0650.tar.gz volse-hubzilla-e7233c0c94d0464994df94d8907518d49fcb0650.tar.bz2 volse-hubzilla-e7233c0c94d0464994df94d8907518d49fcb0650.zip | |
more backquotes - this should take care of most except for the array import queries
Diffstat (limited to 'Zotlabs/Module/Admin')
| -rw-r--r-- | Zotlabs/Module/Admin/Accounts.php | 7 | ||||
| -rw-r--r-- | Zotlabs/Module/Admin/Dbsync.php | 2 |
2 files changed, 4 insertions, 5 deletions
diff --git a/Zotlabs/Module/Admin/Accounts.php b/Zotlabs/Module/Admin/Accounts.php index 143d00a3b..2043550fc 100644 --- a/Zotlabs/Module/Admin/Accounts.php +++ b/Zotlabs/Module/Admin/Accounts.php @@ -133,10 +133,9 @@ class Accounts { $base = z_root() . '/admin/accounts?f='; $odir = (($dir === 'asc') ? '0' : '1'); - $users = q("SELECT `account_id` , `account_email`, `account_lastlog`, `account_created`, `account_expires`, " . "`account_service_class`, ( account_flags & %d ) > 0 as `blocked`, " . - "(SELECT %s FROM channel as ch " . - "WHERE ch.channel_account_id = ac.account_id and ch.channel_removed = 0 ) as `channels` " . - "FROM account as ac where true $serviceclass order by $key $dir limit %d offset %d ", + $users = q("SELECT account_id , account_email, account_lastlog, account_created, account_expires, account_service_class, ( account_flags & %d ) > 0 as blocked, + (SELECT %s FROM channel as ch WHERE ch.channel_account_id = ac.account_id and ch.channel_removed = 0 ) as channels FROM account as ac + where true $serviceclass order by $key $dir limit %d offset %d ", intval(ACCOUNT_BLOCKED), db_concat('ch.channel_address', ' '), intval(\App::$pager['itemspage']), diff --git a/Zotlabs/Module/Admin/Dbsync.php b/Zotlabs/Module/Admin/Dbsync.php index 305126c7d..cff8a2484 100644 --- a/Zotlabs/Module/Admin/Dbsync.php +++ b/Zotlabs/Module/Admin/Dbsync.php @@ -42,7 +42,7 @@ class Dbsync { } $failed = array(); - $r = q("select * from config where `cat` = 'database' "); + $r = q("select * from config where cat = 'database' "); if(count($r)) { foreach($r as $rr) { $upd = intval(substr($rr['k'],8)); |