diff options
| author | redmatrix <mike@macgirvin.com> | 2016-10-03 19:47:36 -0700 |
|---|---|---|
| committer | redmatrix <mike@macgirvin.com> | 2016-10-03 19:47:36 -0700 |
| commit | bad5057a7414eba7f7133538dd671a1413be00e3 (patch) | |
| tree | 93ebd1c119757e01c906abda611ed2e6c7b32e24 /Zotlabs/Module/Acl.php | |
| parent | fe7b7773ba9630a72d01c68dcdbc23eeced70b1b (diff) | |
| download | volse-hubzilla-bad5057a7414eba7f7133538dd671a1413be00e3.tar.gz volse-hubzilla-bad5057a7414eba7f7133538dd671a1413be00e3.tar.bz2 volse-hubzilla-bad5057a7414eba7f7133538dd671a1413be00e3.zip | |
start removing db backticks
Diffstat (limited to 'Zotlabs/Module/Acl.php')
| -rw-r--r-- | Zotlabs/Module/Acl.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Zotlabs/Module/Acl.php b/Zotlabs/Module/Acl.php index 1acd8e320..29c1e5280 100644 --- a/Zotlabs/Module/Acl.php +++ b/Zotlabs/Module/Acl.php @@ -77,7 +77,7 @@ class Acl extends \Zotlabs\Web\Controller { if($search) { - $sql_extra = " AND `name` LIKE " . protect_sprintf( "'%" . dbesc($search) . "%'" ) . " "; + $sql_extra = " AND groups.gname LIKE " . protect_sprintf( "'%" . dbesc($search) . "%'" ) . " "; $sql_extra2 = "AND ( xchan_name LIKE " . protect_sprintf( "'%" . dbesc($search) . "%'" ) . " OR xchan_addr LIKE " . protect_sprintf( "'%" . dbesc($search) . ((strpos($search,'@') === false) ? "%@%'" : "%'")) . ") "; // This horrible mess is needed because position also returns 0 if nothing is found. @@ -105,9 +105,9 @@ class Acl extends \Zotlabs\Web\Controller { if($type == '' || $type == 'g') { $r = q("SELECT groups.id, groups.hash, groups.gname - FROM groups,group_member + FROM groups, group_member WHERE groups.deleted = 0 AND groups.uid = %d - AND group_member.gid=groups.id + AND group_member.gid = groups.id $sql_extra GROUP BY groups.id ORDER BY groups.gname |