Index: trunk/core/units/users/users_event_handler.php
===================================================================
diff -u -N -r2136 -r2186
--- trunk/core/units/users/users_event_handler.php	(.../users_event_handler.php)	(revision 2136)
+++ trunk/core/units/users/users_event_handler.php	(.../users_event_handler.php)	(revision 2186)
@@ -660,6 +660,40 @@
 				}
 			}
 		}
+		
+		function OnCheckExpiredMembership(&$event)
+		{
+			$sql = 'SELECT PortalUserId FROM '.TABLE_PREFIX.'UserGroup
+					WHERE MembershipExpires IS NOT NULL AND MembershipExpires < '.mktime();
+			$user_ids = $this->Conn->GetCol($sql);
+			if(is_array($user_ids) && count($user_ids) > 0)
+			{
+				foreach($user_ids as $id)
+				{
+					
+				}
+			}
+			$sql = 'DELETE FROM '.TABLE_PREFIX.'UserGroup
+					WHERE MembershipExpires IS NOT NULL AND MembershipExpires < '.mktime();
+			$this->Conn->Query($sql);
+			
+			$pre_expiration = mktime() - $this->Application->ConfigValue('User_MembershipExpirationReminder') * 3600 * 24;
+			$sql = 'SELECT PortalUserId FROM '.TABLE_PREFIX.'UserGroup
+					WHERE MembershipExpires IS NOT NULL AND MembershipExpires < '.$pre_expiration.'
+					AND ExpirationReminderSent = 0';
+			$user_ids = $this->Conn->GetCol($sql);
+			if(is_array($user_ids) && count($user_ids) > 0)
+			{
+				foreach($user_ids as $id)
+				{
+					
+				}
+				$sql = 'UPDATE '.TABLE_PREFIX.'UserGroup
+						SET ExpirationReminderSent = 1
+						WHERE PortalUserId IN ('.implode($user_ids).')';
+				$this->Conn->Query($sql);
+			}
+		}
 	}
 	
 ?>
\ No newline at end of file