if (mysql_num_rows($result) == 0) {
die('Unable to load member data for member_id: ' . $member_id);
}
// get member data into $member array
$member = mysql_fetch_array($result, MYSQL_ASSOC);
// generate first/last name from screen name
$names = explode(' ', $member['screen_name']);
$first_name = isset($names[0]) ? $names[0] : 'FirstName';
$last_name = (end($names) != '' and end($names) != $first_name) ? end($names) : 'LastName';
// create a customer record for the user, unless there is one
$result = mysql_query('SELECT `customer_id` FROM `customers` WHERE `internal_id`=\'' . $member_id . '\'', $og_db);
if (mysql_num_rows($result) > 0) {
$customer = mysql_fetch_array($result, MYSQL_ASSOC);
$customer_id = $customer['customer_id'];
} else {
$customer_id = $importer->create_customer($member_id, $member['email'], $first_name, $last_name);
}
// create subscription record
$recurring_id = $importer->create_subscription($customer_id, $plan_id, 'membrr', $sub_start, $sub_end, $paid);
echo 'Imported member id #' . $member_id . ' as customer #' . $customer_id . ' with subscription #' . $recurring_id . '.<br />';
}
fclose($handle);
} else {
die('Unable to open CSV file.');
}
/**
* Importer Class
*
* Creates records in OpenGateway and Membrr to import subscriptions from a data source
*
* @author Electric Function, Inc.
