src/Table/User.php

84 			->from($this->_db->quoteName('#__users'))
85 			->where($this->_db->quoteName('id') . ' = ' . (int) $userId);
104 				->select($this->_db->quoteName('g.id'))
105 				->select($this->_db->quoteName('g.title'))
106 				->from($this->_db->quoteName('#__usergroups') . ' AS g')
107 				->join('INNER', $this->_db->quoteName('#__user_usergroup_map') . ' AS m ON m.group_id = g.id')
108 				->where($this->_db->quoteName('m.user_id') . ' = ' . (int) $userId);
147 				->select($this->_db->quoteName('id'))
148 				->select($this->_db->quoteName('title'))
149 				->from($this->_db->quoteName('#__usergroups'))
150 …->where($this->_db->quoteName('id') . ' = ' . implode(' OR ' . $this->_db->quoteName('id') . ' = '…
231 			->select($this->_db->quoteName('id'))
232 			->from($this->_db->quoteName('#__users'))
233 			->where($this->_db->quoteName('username') . ' = ' . $this->_db->quote($this->username))
234 			->where($this->_db->quoteName('id') . ' != ' . (int) $this->id);
248 			->select($this->_db->quoteName('id'))
249 			->from($this->_db->quoteName('#__users'))
250 …->where('LOWER(' . $this->_db->quoteName('email') . ') = LOWER(' . $this->_db->quote($this->email)…
251 			->where($this->_db->quoteName('id') . ' != ' . (int) $this->id);
269 				->select($this->_db->quoteName('id'))
270 				->from($this->_db->quoteName('#__users'))
271 				->where($this->_db->quoteName('username') . ' = ' . $this->_db->quote($rootUser));
332 				-> select($this->_db->quoteName('group_id'))
333 				-> from($this->_db->quoteName('#__user_usergroup_map'))
334 				-> where($this->_db->quoteName('user_id') . ' = ' . (int) $this->id);
353 							-> delete($this->_db->quoteName('#__user_usergroup_map'))
354 							-> where($this->_db->quoteName('user_id') . ' = ' . (int) $this->id)
355 							-> where($this->_db->quoteName('group_id') . ' = ' . (int) $map->group_id);
368 					->insert($this->_db->quoteName('#__user_usergroup_map'))
369 					->columns(array($this->_db->quoteName('user_id'), $this->_db->quoteName('group_id')));
388 				->delete($this->_db->quoteName('#__user_keys'))
389 				->where($this->_db->quoteName('user_id') . ' = ' . $this->_db->quote($this->username));
418 			->delete($this->_db->quoteName($this->_tbl))
419 			->where($this->_db->quoteName($this->_tbl_key) . ' = ' . (int) $this->$k);
425 			->delete($this->_db->quoteName('#__user_usergroup_map'))
426 			->where($this->_db->quoteName('user_id') . ' = ' . (int) $this->$k);
435 			->delete($this->_db->quoteName('#__messages_cfg'))
436 			->where($this->_db->quoteName('user_id') . ' = ' . (int) $this->$k);
441 			->delete($this->_db->quoteName('#__messages'))
442 			->where($this->_db->quoteName('user_id_to') . ' = ' . (int) $this->$k);
447 			->delete($this->_db->quoteName('#__user_keys'))
448 			->where($this->_db->quoteName('user_id') . ' = ' . $this->_db->quote($this->username));
486 			->update($db->quoteName($this->_tbl))
487 			->set($db->quoteName('lastvisitDate') . '=' . $db->quote($date->toSql()))
488 			->where($db->quoteName('id') . '=' . (int) $userId);