} $si_db = new DBConn(DB_SERVER, DB_DATABASE, DB_USER, DB_PASSWORD); assert_die($si_db->connect(TRUE), "Could not connect to sureinvoice database!\n" . $si_db->getLastError()); debug('Connected to sureinvoice database ' . DB_DATABASE); $dt_db = new DBConn($phpdt_server, $phpdt_database, $phpdt_username, $phpdt_password); assert_die($dt_db->connect(TRUE), "Could not connect to phpdt database!\n" . $dt_db->getLastError()); debug('Connected to phpdt database ' . $phpdt_database); // Migrate companies $companies = array(); $company_rates = array(); $company_sql = "\nSELECT `id`, `name`, `address1`, `address2`, `city`, `state`,\n`zip`, `phone`, `fax`, `hourly_rate`, `created_ts`, `updated_ts`\nFROM `companies`\n"; $company_result = $dt_db->query($company_sql, TRUE); assert_die($company_result, "Could not get company list!\n" . $dt_db->getLastError()); debug('Got ' . $company_result->numRows() . ' company rows from phpdt.'); while ($row = $company_result->fetchArray(MYSQL_ASSOC)) { $company_insert_sql = "\nINSERT INTO companies (id, name, address1, address2, city,\nstate, zip, phone, fax, hourly_rate,created_ts, updated_ts)\nVALUES(" . $row['id'] . ", '" . $si_db->escapeString($row['name']) . "', '" . $row['address1'] . "', \n'" . $row['address2'] . "', '" . $row['city'] . "', '" . $row['state'] . "', \n'" . $row['zip'] . "', '" . $row['phone'] . "', '" . $row['fax'] . "', \n" . $row['hourly_rate'] . ", " . $row['created_ts'] . ", " . $row['updated_ts'] . ")\n\t"; assert_die($si_db->query($company_insert_sql, TRUE), "Error adding company!\n" . $si_db->getLastError(), FALSE); debug('Added ' . $row['name'] . ' to sureinvoice'); $company_rates[$row['id']] = $row['hourly_rate']; $companies[$row['id']] = $row; } $company_result->free(); // Migrate users $users = array(); $user_sql = "\nSELECT `id`, `user_type_id`, `first_name`, `last_name`, `company_id`, \n`address1`, `address2`, `city`, `state`, `zip`, `email`, `password`, \n`hourly_rate`, `rate_type`, `active`, `created_ts`, `updated_ts`, \n`last_login_ts` \nFROM `users`"; $user_result = $dt_db->query($user_sql, TRUE); assert_die($user_result, "Could not get user list!\n" . $dt_db->getLastError()); debug('Got ' . $user_result->numRows() . ' user rows from phpdt.'); while ($row = $user_result->fetchArray(MYSQL_ASSOC)) { $user_insert_sql = "\nINSERT INTO users (id, user_type_id, first_name, last_name, company_id, \naddress1, address2, city, state, zip, email, password, hourly_rate, \nrate_type, active, created_ts, updated_ts, last_login_ts)\nVALUES(" . $row['id'] . "," . $row['user_type_id'] . ", '" . $si_db->escapeString($row['first_name']) . "', \n'" . $si_db->escapeString($row['last_name']) . "', " . $row['company_id'] . ", \n'" . $si_db->escapeString($row['address1']) . "', '" . $si_db->escapeString($row['address2']) . "', \n'" . $si_db->escapeString($row['city']) . "', '" . $si_db->escapeString($row['state']) . "', \n'" . $si_db->escapeString($row['zip']) . "', '" . $si_db->escapeString($row['email']) . "', \n'" . $row['password'] . "', '" . $row['hourly_rate'] . "', '" . $row['rate_type'] . "', '" . $row['active'] . "', \n" . $row['created_ts'] . ", " . $row['updated_ts'] . ", " . $row['last_login_ts'] . ")\n\t"; assert_die($si_db->query($user_insert_sql, TRUE), "Error adding user!\n" . $si_db->getLastError(), FALSE);