<?php
	class UsersItem extends kDBItem {
	
		/**
		 * Returns IDs of groups to which user belongs and membership is not expired
		 *
		 * @return Array
		 * @access public
		 */
		function getMembershipGroups($force_reload = false)
		{
			$user_groups = $this->Application->RecallVar('UserGroups');
			if($user_groups === false || $force_reload)
			{
				$sql = 'SELECT GroupId FROM %s WHERE (PortalUserId = %s) AND ( (MembershipExpires IS NULL) OR ( MembershipExpires >= UNIX_TIMESTAMP() ) )';
				$sql = sprintf($sql, TABLE_PREFIX.'UserGroup', $this->GetID() );
				return $this->Conn->GetCol($sql);
			}
			else
			{
				return explode(',', $user_groups);
			}
		}
		
		/**
		 * Set's Login from Email if required by configuration settings
		 *
		 */
		function setLogin()
		{
			if( $this->Application->ConfigValue('Email_As_Login') )
			{
				$this->SetDBField('Login', $this->GetDBField('Email') );	
			}
		}
		
		function SendEmailEvents()
		{
			switch( $this->GetDBField('Status') )
			{
				case 1:
					$this->Application->EmailEventAdmin('USER.ADD', $this->GetID() );
					$this->Application->EmailEventUser('USER.ADD', $this->GetID() );
					break;
					
				case 2:
					$this->Application->EmailEventAdmin('USER.ADD.PENDING', $this->GetID() );
					$this->Application->EmailEventUser('USER.ADD.PENDING', $this->GetID() );
					break;
			}
		}
		
		function isSubscriberOnly()
		{
			$subscribers_group_id = $this->Application->ConfigValue('User_SubscriberGroup');
			$sql = 'SELECT PortalUserId
					FROM '.TABLE_PREFIX.'UserGroup
					WHERE 	GroupId = '.$subscribers_group_id.' AND 
							PortalUserId = '.$this->GetDBField('PortalUserId').' AND 
							PrimaryGroup = 1';
			return $this->Conn->GetOne($sql) == $this->GetDBField('PortalUserId');
		}
		
	
	}
?>