/** * */ public static function default_connection() { _db::connect(ini::get('mysql', 'server'), ini::get('mysql', 'database'), ini::get('mysql', 'username'), ini::get('mysql', 'password')); }
<?php use classes\db; define('load_core', false); include '../../index.php'; db::default_connection(); db::connect('localhost', 'nxcl_old', 'root', '', 'old'); set_time_limit(0); $tables = array('flight' => array('ID' => 'fid', 'Pilot_No' => 'pid', 'Club_No' => 'cid', 'Glider_No' => 'gid', 'Base_Score' => 'base_score', 'Score' => 'score', 'Multi' => 'multi', 'Date' => 'date', 'Season' => 'season', 'DateAdded' => 'created', 'Cords' => 'coords', 'Launch' => 'lid', 'Type' => 'ftid', 'Defined' => 'defined', 'Ridge' => 'ridge', 'Winter' => 'winter', 'Vis_Info' => 'info', 'Admin_Info' => 'admin_info', 'Personal' => 'personal', 'Delay' => 'delayed', 'Comp' => 'comp_id', 'dim' => 'did', 'flighttime' => 'duration', 'ODs' => 'od_score', 'ODt' => 'od_time', 'ORs' => 'or_score', 'ORt' => 'or_time', 'TRs' => 'tr_score', 'TRt' => 'tr_time', 'Speed' => 'speed'), 'pilot' => array('P_ID' => 'pid', 'P_NAME' => 'name', 'Gender' => 'gender', 'BHPA' => 'bhpa_no', 'Rating' => 'rating', 'Email' => 'email'), 'glider' => array('G_ID' => 'gid', 'G_NAME' => 'name', 'G_CLASS' => 'class', 'Manufacturer' => array('get_manu', 'mid'), 'Kingpost' => 'kingpost', 'Single_Surface' => 'single_surface', 'Hangies_League' => 'hangies'), 'waypoint' => array('ID' => 'wid', 'INFO' => 'title', 'Lat' => 'lat', 'Lon' => 'lon')); foreach ($tables as $table => $keys) { echo '<h1>Importing: ' . $table . '</h1>'; db::swap_connection('old'); $res = db::query('SELECT * FROM ' . $table . 's'); db::swap_connection('default'); db::query('TRUNCATE ' . $table); // prepare_statement $sql_arr = []; $key_arr = []; foreach ($keys as $old => $new) { if (is_array($new)) { $sql_arr[] = '`' . $new[1] . '`'; } else { $sql_arr[] = '`' . $new . '`'; } $key_arr[] = ':' . $old . '_[id]'; } $base_sql = 'INSERT INTO ' . $table . ' (' . implode(', ', $sql_arr) . ') VALUES '; $key_set = '(' . implode(', ', $key_arr) . ')'; $part_cnt = 0; $cnt = 0; $params = [];