$loginRows = mysqli_num_rows($loginResult); // Rows from query if ($loginRows) { try { $loginMember = mysqli_fetch_array($loginResult); if ($loginMember['status'] == 1) { $loggedOutUMEMID = $_SESSION['member']['umem_id']; // Before overwriting this grab the umem_id from the session before the member logged in unset($_SESSION['member']); $memberSess = new memberTools($loginMember['mem_id']); save_activity($loginMember['mem_id'], $mgrlang['pubLogin'], 0, "<strong>{$mgrlang[pubLoggedIn]} ({$_SERVER['REMOTE_ADDR']})</strong>"); // Make entry in the activity log db $_SESSION['member'] = $memberSess->getMemberInfoFromDB($loginMember['umem_id']); if ($_SESSION['member']['umem_id']) { if ($loginMember['membership'] == 1 or $nowGMT < $_SESSION['member']['ms_end_date'] or $_SESSION['member']['ms_end_date'] == '0000-00-00 00:00:00') { $_SESSION['member']['membershipDetails'] = $memberSess->getMembershipInfoFromDB($loginMember['membership']); // Get the membership info and add it to the member session array } else { $_SESSION['member']['membership'] = 1; $_SESSION['member']['membershipDetails'] = $memberSess->getMembershipInfoFromDB(1); // Membership is expired put them on basic free membership } //print_k($_SESSION['member']['membershipDetails']); //exit; $_SESSION['loggedIn'] = 1; // Set the logged in session but make sure first setcookie("member[umem_id]", $_SESSION['member']['umem_id'], time() + 60 * 60 * 24 * 30, "/", $cookieHost[0]); // Set a new member id cookie unset($_SESSION['lightboxItems']); // Clear the current lightboxItems session so that a new one will be grabbed after login unset($_SESSION['shippingAddressSession']);
} else { $hasOptions = 0; } if ($mediaID) { $mediaOwnerResult = mysqli_query($db, "SELECT owner FROM {$dbinfo[pre]}media WHERE media_id = '{$mediaID}'"); $mediaOwner = mysqli_fetch_assoc($mediaOwnerResult); $owner = $mediaOwner['owner']; if ($owner) { if ($owner != $_SESSION['member']['mem_id']) { $commission['mediaID'] = $mediaID; $commission['owner'] = $owner; // Select member account $contrObj = new memberTools($owner); $contr = $contrObj->getMemberInfoFromDB($owner); if ($contr) { $contrMembership = $contrObj->getMembershipInfoFromDB($contr['membership']); // Select membership if ($contrMembership['allow_selling']) { $commission['status'] = true; // Member can receive commission if ($contr['com_source'] == 1) { // Use membership comlevel $commission['memPercent'] = $contrMembership['commission']; } else { $commission['memPercent'] = $contr['com_level']; } } } //print_r($member); // testing //print_r($membership); //exit;
} // Make entry in the activity log db - only if member is logged in break; case "onetime": case "recurring": if ($membershipDB['trail_status'] and !in_array($membership, $trialedMemberships)) { /* * Trial available - upgrade */ $trialEndDate = gmdate("Y-m-d h:i:s", strtotime("+{$membershipDB[trial_length_num]} {$membershipDB[trial_length_period]}")); $trialedMembershipsUpdated = $memberDB['trialed_memberships'] . "," . $membership; $sql = "\r\n\t\t\t\t\t\t\t\t\t\t\tUPDATE {$dbinfo[pre]}members SET \r\n\t\t\t\t\t\t\t\t\t\t\tms_end_date='{$trialEndDate}',\r\n\t\t\t\t\t\t\t\t\t\t\tmembership='{$membershipDB[ms_id]}',\r\n\t\t\t\t\t\t\t\t\t\t\ttrialed_memberships='{$trialedMembershipsUpdated}'\r\n\t\t\t\t\t\t\t\t\t\t\tWHERE mem_id = '{$memberDB[mem_id]}'\r\n\t\t\t\t\t\t\t\t\t\t"; $result = mysqli_query($db, $sql); // Update database $newMembership = new memberTools($memberDB['mem_id']); $_SESSION['member']['membershipDetails'] = $newMembership->getMembershipInfoFromDB($membershipDB['ms_id']); // Update session $_SESSION['member']['membership'] = $membershipDB['ms_id']; $_SESSION['member']['ms_end_date'] = $trialEndDate; $_SESSION['member']['trialed_memberships'][] = $membership; } else { $billResult = mysqli_query($db, "\r\n\t\t\t\t\t\t\t\t\t\t\tSELECT *\r\n\t\t\t\t\t\t\t\t\t\t\tFROM {$dbinfo[pre]}billings\r\n\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}invoices\r\n\t\t\t\t\t\t\t\t\t\t\tON {$dbinfo[pre]}invoices.bill_id = {$dbinfo[pre]}billings.bill_id\r\n\t\t\t\t\t\t\t\t\t\t\tWHERE {$dbinfo[pre]}billings.membership != 0\r\n\t\t\t\t\t\t\t\t\t\t\tAND {$dbinfo[pre]}invoices.invoice_mem_id = '{$memberDB[mem_id]}'\r\n\t\t\t\t\t\t\t\t\t\t\tAND {$dbinfo[pre]}invoices.payment_status = 2 \r\n\t\t\t\t\t\t\t\t\t\t\t"); if (mysqli_num_rows($billResult)) { while ($bill = mysqli_fetch_array($billResult)) { //$sql = "UPDATE {$dbinfo[pre]}billings SET deleted='1' WHERE bill_id = '{$bill[bill_id]}'"; //$result = mysqli_query($db,$sql); $sql = "UPDATE {$dbinfo[pre]}invoices SET payment_status='6' WHERE invoice_id = '{$bill[invoice_id]}'"; $result = mysqli_query($db, $sql); } } $ubill_id = create_unique2();