$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();
