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.