Lines Matching refs:sql
127 $sql = $this->_createSQLFilter($this->conf['getUsers'], $filter);
130 if(($result = $this->_queryDB($sql))) {
153 $sql = $this->_createSQLFilter($this->conf['getUsers'], $filter);
154 $sql .= " ".$this->conf['SortOrder'];
155 if($limit) $sql .= " LIMIT $limit";
156 if($first) $sql .= " OFFSET $first";
157 $result = $this->_queryDB($sql);
197 $sql = str_replace('%{group}', addslashes($group), $this->conf['addGroup']);
198 $this->_modifyDB($sql);
206 $sql = $this->conf['addUserGroup'];
207 if(strpos($sql, '%{uid}') !== false) {
209 $sql = str_replace('%{uid}', addslashes($uid), $sql);
211 $sql = str_replace('%{user}', addslashes($user), $sql);
212 $sql = str_replace('%{gid}', addslashes($gid), $sql);
213 $sql = str_replace('%{group}', addslashes($group), $sql);
214 if($this->_modifyDB($sql) !== false) {
220 $sql = str_replace('%{gid}', addslashes($gid), $this->conf['delGroup']);
221 $sql = str_replace('%{group}', addslashes($group), $sql);
222 $this->_modifyDB($sql);
252 $sql = str_replace('%{user}', addslashes($user), $this->conf['addUser']);
253 $sql = str_replace('%{pass}', addslashes($pwd), $sql);
254 $sql = str_replace('%{name}', addslashes($name), $sql);
255 $sql = str_replace('%{email}', addslashes($mail), $sql);
256 if($this->_modifyDB($sql)) {