{
header("location: error.php?eType=invalidQuery");
exit;
}
*/
/*
* Get membership list
*/
$membershipDBResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}memberships\r\n\t\t\tLEFT JOIN {$dbinfo[pre]}perms\r\n\t\t\tON ({$dbinfo[pre]}memberships.ms_id = {$dbinfo[pre]}perms.item_id AND {$dbinfo[pre]}perms.perm_area = 'memberships')\r\n\t\t\tWHERE {$dbinfo[pre]}memberships.deleted = 0\r\n\t\t\tAND ({$dbinfo[pre]}memberships.everyone = 1 OR {$dbinfo[pre]}perms.perm_value IN ({$memberPermissionsForDB})) \r\n\t\t\tORDER BY {$dbinfo[pre]}memberships.sortorder\r\n\t\t\t");
while ($membershipDB = mysqli_fetch_array($membershipDBResult)) {
if ($membershipDB['active'] == 1) {
if ($msID == $membershipDB['ums_id']) {
$msIDActive = 1;
}
// See if the msID that was passed is actually active
$memberships[$membershipDB['ms_id']] = membershipsList($membershipDB);
}
}
$smarty->assign('memberships', $memberships);
$smarty->assign('regForm', $regForm);
// Assign form requirements to smarty
if ($showMemberships or $config['settings']['reg_memberships'] or $msID) {
$smarty->assign('showMemberships', 1);
}
// Show the membership choices
if ($msID and $msIDActive) {
$selectedMembership = $msID;
}
// A msID was passed - make it selected
if ($membership) {
$selectedMembership = $membership;
require_once BASE_PATH . '/assets/includes/init.member.php';
require_once BASE_PATH . '/assets/includes/security.inc.php';
require_once BASE_PATH . '/assets/includes/language.inc.php';
require_once BASE_PATH . '/assets/includes/cart.inc.php';
require_once BASE_PATH . '/assets/includes/affiliate.inc.php';
//define('META_TITLE',''); // Override page title, description, keywords and page encoding here
//define('META_DESCRIPTION','');
//define('META_KEYWORDS','');
//define('PAGE_ENCODING','');
require_once BASE_PATH . '/assets/includes/header.inc.php';
require_once BASE_PATH . '/assets/includes/errors.php';
try {
$membershipResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}memberships\r\n\t\t\tWHERE deleted = 0\r\n\t\t\tAND ums_id = '{$id}'\r\n\t\t\t");
if ($returnRows = mysqli_num_rows($membershipResult)) {
$membership = mysqli_fetch_assoc($membershipResult);
$membershipArray = membershipsList($membership);
if ($membership['active'] == 1) {
$smarty->assign('membership', $membershipArray);
$smarty->assign('membershipRows', $returnRows);
} else {
$smarty->assign('noAccess', 1);
}
} else {
$smarty->assign('noAccess', 1);
}
$smarty->display('membership.tpl');
// Smarty template
} catch (Exception $e) {
echo $e->getMessage();
}
if ($db) {
}
$bills = mysqli_result_patch(mysqli_query($db, "\r\n\t\tSELECT COUNT({$dbinfo[pre]}billings.bill_id) \r\n\t\tFROM {$dbinfo[pre]}billings \r\n\t\tLEFT JOIN {$dbinfo[pre]}invoices \r\n\t\tON {$dbinfo[pre]}billings.bill_id = {$dbinfo[pre]}invoices.bill_id \r\n\t\tWHERE {$dbinfo[pre]}invoices.payment_status = 2 \r\n\t\tAND {$dbinfo[pre]}billings.deleted = 0\r\n\t\tAND member_id = {$memberID}\r\n\t\t"));
// Count bills due
$sales = mysqli_result_patch(mysqli_query($db, "\r\n\t\tSELECT COUNT(com_id) \r\n\t\tFROM {$dbinfo[pre]}commission \r\n\t\tWHERE contr_id = {$memberID} \r\n\t\tAND order_status = '1' \r\n\t\tAND order_date > '{$_SESSION[member][last_login]}'\r\n\t\t"));
// Count new sales
// Get membership that member is currently on
// Get membership that member is assigned to in DB
$membership['expires'] = '';
/*
* Get membership details
*/
if ($_SESSION['member']['membership'] != 1) {
//echo $_SESSION['member']['membershipDetails']['ms_id']; exit;
$membershipResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}memberships\r\n\t\t\tWHERE ms_id = '{$_SESSION[member][membership]}'\r\n\t\t\t");
$membershipDB = mysqli_fetch_array($membershipResult);
$membership = membershipsList($membershipDB);
$membership['msExpired'] = ($_SESSION['member']['ms_end_date'] > $nowGMT or $_SESSION['member']['ms_end_date'] == '0000-00-00 00:00:00') ? false : true;
$membership['msExpireDate'] = $_SESSION['member']['ms_end_date'] == '0000-00-00 00:00:00' ? $lang['never'] : $customDate->showdate($_SESSION['member']['ms_end_date'], 1);
$smarty->assign('membership', $membership);
}
// Check galleries for member
if ($_SESSION['galleriesData']) {
foreach ($_SESSION['galleriesData'] as $key => $gallery) {
if ($gallery['memSpec'] == $_SESSION['member']['mem_id']) {
$memberSpecGallery[$gallery['gallery_id']] = $_SESSION['galleriesData'][$gallery['gallery_id']];
}
}
}
//print_r($memberSpecGallery); // Testing
try {
//$signupDate = $cleanDates->showdate($_SESSION['member']['signup_date'],0);
