{ 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);