$saveID = mysqli_insert_id($db);
$Mailchimp = new Mailchimp($mailchimp_api_key);
$Mailchimp_Lists = new Mailchimp_Lists($Mailchimp);
$Mailchimp_Lists->subscribe($mailchimp_list_id, array('email' => $email));
mysqli_query($db, "\r\n\t\t\t\t\t\tINSERT INTO {$dbinfo[pre]}members_address \r\n\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\tmember_id,\r\n\t\t\t\t\t\t\taddress,\r\n\t\t\t\t\t\t\taddress_2,\r\n\t\t\t\t\t\t\tcity,\r\n\t\t\t\t\t\t\tstate,\r\n\t\t\t\t\t\t\tpostal_code,\r\n\t\t\t\t\t\t\tcountry\r\n\t\t\t\t\t\t) \r\n\t\t\t\t\t\tVALUES \r\n\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t'{$saveID}',\r\n\t\t\t\t\t\t\t'{$address}',\r\n\t\t\t\t\t\t\t'{$address_2}',\r\n\t\t\t\t\t\t\t'{$city}',\r\n\t\t\t\t\t\t\t'{$state}',\r\n\t\t\t\t\t\t\t'{$postal_code}',\r\n\t\t\t\t\t\t\t'{$country}'\r\n\t\t\t\t\t\t)\r\n\t\t\t\t\t");
// Save member address
$signupGroups = explode(",", $config['settings']['signup_groups']);
// Assign any signup groups
if ($signupGroups) {
foreach ($signupGroups as $key => $value) {
mysqli_query($db, "INSERT INTO {$dbinfo[pre]}groupids (mgrarea,item_id,group_id) VALUES ('members','{$saveID}','{$value}')");
}
}
//$_SESSION['testing']['step3'] = '3';
try {
$memberObj = new memberTools($saveID);
$member = $memberObj->getMemberInfoFromDB($umem_id);
// Get all the member info from the database
$member['primaryAddress'] = $memberObj->getPrimaryAddress();
if ($paidMembership) {
// Do paid membership stuff
// $saveID
// $membershipDB
$ubill_id = create_unique2();
$invoice_number = $config['settings']['invoice_prefix'] . $config['settings']['invoice_next'] . $config['settings']['invoice_suffix'];
// Get new invoice number
$cur_inv = $config['settings']['invoice_next'];
$next_inv = $cur_inv + 1;
$billDate = $nowGMT;
$dueDate = $nowGMT;
$invoiceTotal = $membershipDB['price'];
$_SESSION['billingAddressSession']['address2'] = $_SESSION['member']['primaryAddress']['address2'];
$_SESSION['billingAddressSession']['city'] = $_SESSION['member']['primaryAddress']['city'];
$_SESSION['billingAddressSession']['stateID'] = $_SESSION['member']['primaryAddress']['stateID'];
$_SESSION['billingAddressSession']['postalCode'] = $_SESSION['member']['primaryAddress']['postal_code'];
$_SESSION['billingAddressSession']['email'] = $_SESSION['member']['email'];
$_SESSION['billingAddressSession']['phone'] = $_SESSION['member']['phone'];
}
if ((!$_SESSION['billingAddressSession']['email'] or !$_SESSION['shippingAddressSession']['email']) and $_SESSION['loggedIn']) {
//echo "e";
$_SESSION['shippingAddressSession']['email'] = $_SESSION['member']['email'];
$_SESSION['billingAddressSession']['email'] = $_SESSION['member']['email'];
}
if ($config['settings']['tax_type'] != 1) {
// Billing info was passed refresh tax rates based on billing address
if ($_SESSION['billingAddressSession']['countryID'] or $_SESSION['billingAddressSession']['stateID'] or $_SESSION['billingAddressSession']['postalCode']) {
$fauxMember = new memberTools();
$newTax = $fauxMember->getMemberTaxValues($_SESSION['billingAddressSession']['countryID'], $_SESSION['billingAddressSession']['stateID'], $_SESSION['billingAddressSession']['postalCode']);
$_SESSION['tax']['tax_inc'] = $newTax['tax_inc'];
$_SESSION['tax']['tax_a_default'] = $newTax['tax_a_default'];
$_SESSION['tax']['tax_b_default'] = $newTax['tax_b_default'];
$_SESSION['tax']['tax_c_default'] = $newTax['tax_c_default'];
$_SESSION['tax']['tax_a_digital'] = $newTax['tax_a_digital'];
$_SESSION['tax']['tax_b_digital'] = $newTax['tax_b_digital'];
$_SESSION['tax']['tax_c_digital'] = $newTax['tax_c_digital'];
$_SESSION['tax']['tax_prints'] = $newTax['tax_prints'];
$_SESSION['tax']['tax_digital'] = $newTax['tax_digital'];
$_SESSION['tax']['tax_ms'] = $newTax['tax_ms'];
$_SESSION['tax']['tax_subs'] = $newTax['tax_subs'];
$_SESSION['tax']['tax_shipping'] = $newTax['tax_shipping'];
$_SESSION['tax']['tax_credits'] = $newTax['tax_credits'];
$smarty->assign('tax', $_SESSION['tax']);
*/
if ($_POST) {
$loginPassword = k_encrypt($memberPassword);
// Encrypt password
$loginResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}members\r\n\t\t\tWHERE email = '{$memberEmail}' \r\n\t\t\tAND password = '******'\r\n\t\t\tLIMIT 1\r\n\t\t");
// Pull basic login info from the db
$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;
// Check to see if any options were passed
if ($optionsPassed or $type == 'package') {
$hasOptions = 1;
} 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'];
}
}
}
save_activity($_SESSION['member']['mem_id'], $mgrlang['pubUpdateMembership'], 0, "<strong>{$membershipDB[name]} ({$membershipDB[ms_id]})</strong>");
}
// 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);
}
}
