<?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 *******************/	

//Call Database & Connect
require_once('headers/database.php');
connect();

//Call functions
require_once('headers/functions.php');

//Login Check Page
require_once('headers/logincheck.php');

//Get Admin Values
$get_cd = mysql_query("SELECT * FROM `memb_config`");
while($each = mysql_fetch_assoc($get_cd)){$$each['config_name'] = $each['config_value'];}

if($is_logged == false){
	//Disconnect Database
	disconnect_data();
	header('Location: '.$CF_URLINC.'login.php?m=1');
}

// Get membership
$get_membership = mysql_fetch_assoc(mysql_query("SELECT `membership_free`,`membership_title` 
		FROM `memb_memberships` WHERE `membership_id`='$user_info[membership_id]'"));
$get_payment = mysql_fetch_assoc(mysql_query("SELECT * FROM `memb_payments` WHERE `user_id` = '$user_info[user_id]'
		ORDER BY `payment_date` DESC"));
$get_rate = mysql_fetch_assoc(mysql_query("SELECT * FROM `memb_memberships_rates` WHERE `rate_id`='$get_payment[rate_id]'"));

$getDifference = getDifference(date("Y-m-d G:i:s"),$get_payment['payment_date'],3);
$paidForDays = getDays($get_rate['rate_term'],$get_rate['rate_term_c']);	
$daysDiffer = $paidForDays - $getDifference;

// Get memberships
$query = mysql_query("SELECT * FROM `memb_memberships` WHERE `membership_public`='1'");
while($em = mysql_fetch_assoc($query)){
	$membershipList[] = $em;
}

// get rates
$query = mysql_query("SELECT * FROM `memb_memberships_rates` WHERE `membership_id`='$_POST[membership_id]'");
while($em = mysql_fetch_assoc($query)){
	$membershipRates[] = $em;
}
if($_POST['rate_id'] != NULL){
	$get_rate = mysql_fetch_assoc(mysql_query("SELECT * FROM `memb_memberships_rates` WHERE `rate_id`='$_POST[rate_id]'"));
}

//Disconnect Database
disconnect_data();
?>