$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'];
$membershipPeriodName = $lang[$membershipDB['period']];
$invoiceMembershipName = "{$lang[membership]}: {$membershipDB[name]} ({$membershipPeriodName})";
// Create bill record
// Assign member ID as memXXX to permissions
if ($memberGroupsFixed) {
foreach ($memberGroupsFixed as $groups) {
$_SESSION['member']['permmissions'][] = $groups;
}
}
$iplogin = $_SERVER['REMOTE_ADDR'];
mysqli_query($db, "UPDATE {$dbinfo[pre]}members SET last_login = '******' WHERE mem_id = '{$loginMember[mem_id]}'");
// Set the last login time and date
mysqli_query($db, "UPDATE {$dbinfo[pre]}members SET ip_login = '******' WHERE mem_id = '{$loginMember[mem_id]}'");
// Set the last login IP
mysqli_query($db, "UPDATE {$dbinfo[pre]}orders SET member_id = '{$loginMember[mem_id]}' WHERE uorder_id = '{$_SESSION[uniqueOrderID]}'");
// reassign any carts to this member
mysqli_query($db, "UPDATE {$dbinfo[pre]}lightboxes SET member_id = '{$loginMember[mem_id]}', umember_id ='{$loginMember[umem_id]}', guest='0' WHERE umember_id = '{$loggedOutUMEMID}' AND guest = '1'");
// Update guest lightboxes to this member
$_SESSION['member']['primaryAddress'] = $memberSess->getPrimaryAddress();
// Get the members primary address
if ($config['settings']['tax_type'] == 0) {
$_SESSION['tax'] = $memberSess->getMemberTaxValues();
}
$ratedMediaResult = mysqli_query($db, "SELECT member_id,media_id FROM {$dbinfo[pre]}media_ratings WHERE member_id = '{$loginMember[mem_id]}'");
// Find out which media a member already rated
while ($ratedMedia = mysqli_fetch_array($ratedMediaResult)) {
$_SESSION['ratedMedia'][] = $ratedMedia['media_id'];
}
// Moved out of member session array so it can be handled separately and between logged in and not logged in visitors
header("location: {$_SESSION[jumpToOnLogin]}");
exit;
} else {
$logNotice = 'loginFailedMessage';
// The session assign/login failed
