/** Returns a list of UserGroup objects for all groups the user is a member of */
public static function getGroups($user_id)
{
$q = 'SELECT groupId FROM ' . self::$tbl_name . ' WHERE userId = ?';
$res = Sql::pSelect1d($q, 'i', $user_id);
$groups = array();
foreach ($res as $grp_id) {
$groups[] = new UserGroup($grp_id);
}
return $groups;
}
/**
* @return array of User objects for all group members
*/
function getMembers()
{
if (!$this->id) {
throw new \Exception('no group id set');
}
$res = array();
$q = 'SELECT userId FROM tblGroupMembers WHERE groupId = ?';
foreach (Sql::pSelect1d($q, 'i', $this->id) as $uid) {
$res[] = User::get($uid);
}
return $res;
}
/** @return array of IP's associated with user_id */
public static function getIPsByUser($user_id, $type = LOGIN_INTERNAL)
{
$q = 'SELECT DISTINCT(IP) FROM ' . self::$tbl_name . ' WHERE userId = ? AND type = ?';
return Sql::pSelect1d($q, 'ii', $user_id, $type);
}
/**
* @return 1d array of owner id's matching name & value
*/
static function getList($name, $value)
{
$q = 'SELECT ownerId FROM tblSettings' . ' WHERE settingType = ? AND settingName = ? AND settingValue = ?';
return Sql::pSelect1d($q, 'iss', USER, $name, $value);
}
