<?php
/************* Membership V2.0 *******************/
/*
Released by AwesomePHP.com, under the GPL License, a
copy of it should be attached to the zip file, or
you can view it on http://AwesomePHP.com/gpl.txt
*/
/************* Membership V2.0 *******************/	

//Check User sessions (set it to NO at first)
$is_logged = false;

@session_start();

if($_SESSION['usersession'] == NULL){$_SESSION['usersession'] = $_COOKIE['usersession'];}

$check_user = @mysql_query("SELECT * FROM `memb_usersessions` WHERE `session_id`='$_SESSION[usersession]'");


if(@mysql_num_rows($check_user) > 0){
	$get_info = @mysql_fetch_array($check_user);
	$user_id = $get_info['user_id'];

	$user_info = @mysql_fetch_array(@mysql_query("SELECT * FROM `memb_userlist` WHERE `user_id`='$user_id'"));
	//Check User status
	// Status 1 means that the student is OK
	if($user_info['user_status'] != 1){
		//Remove sessions
		$remove = @mysql_query("DELETE FROM `memb_usersessions` WHERE `session_id`='$_SESSION[session_id]'");
		include('logout.php');
	} else {
		$is_logged = true;
		$get_memb = mysql_fetch_assoc(mysql_query("SELECT * FROM `memb_memberships` 
			WHERE `membership_id`='$user_info[membership_id]'"));
				
		if($get_memb['membership_free'] != 1){
			$get_payment_date = mysql_fetch_assoc(mysql_query("SELECT `rate_id`,`payment_date` FROM `memb_payments` 
				WHERE `membership_id`='$user_info[membership_id]' ORDER BY `payment_date` DESC LIMIT 1"));
				
			$get_plan_length = mysql_fetch_assoc(mysql_query("SELECT `rate_term`,`rate_term_c` FROM `memb_memberships_rates` 
				WHERE `rate_id`='$get_payment_date[rate_id]'"));
				
			$paidForDays = getDays($get_plan_length['rate_term'],$get_plan_length['rate_term_c']);	

			$getDifference = getDifference(date("Y-m-d G:i:s"),$get_payment_date['payment_date'],3);

			if($getDifference > $paidForDays){
				$message = 'Your membership has been expired and not renewed. We are setting your membership to Free to enable payment.';
				$update = mysql_query("UPDATE `memb_userlist` SET `membership_id`='1' 
						WHERE `user_id`='$get_user[user_id]' LIMIT 1");
				$is_logged = false;	
			}
		} 		
	}
}

?>