protected static function queryArray($query, $db = "mig", $debug = false) { if ($debug) { echo $query; } $con = migration_dbconnection::conForString($db); if (!($sql_data = mysqli_query($con, $query))) { return false; } $ret = array(); while ($o = mysqli_fetch_object($sql_data)) { $ret[] = $o; } return $ret; }
private function forceMigratePlayer($v1PlayerId) { $v1Player = migration_dbconnection::queryObject("SELECT * FROM players WHERE player_id = '{$v1PlayerId}'", "v1"); if (!$v1Player) { return 0; } $mig = migration_dbconnection::queryObject("SELECT * FROM user_migrations WHERE v1_player_id = '{$v1PlayerId}'"); if ($mig) { return $mig->v2_user_id; } $v2User = migration_dbconnection::queryObject("SELECT * FROM users WHERE user_name = '{$v1Player->user_name}'", "v2"); if (!$v2User) { $userpack = new stdClass(); $userpack->user_name = $v1Player->user_name . "_legacy_siftr"; $userpack->password = "******"; $userpack->display_name = !$v1Player->display_name || $v1Player->display_name == "" ? $v1Player->user_name : $v1Player->display_name; $userpack->email = $v1Player->email; $userpack->permission = "read_write"; $userpack->no_auto_migrate = true; //negative var name because it's a hack and we want the default to be nonexistant $v2User = bridgeService("v2", "users", "createUser", "", $userpack)->data; if (!$v2User) { return 0; } //username taken I guess migration_dbconnection::query("INSERT INTO user_migrations (v2_user_id, v2_read_write_key, v1_player_id, v1_editor_id, v1_read_write_token) VALUES ('{$v2User->user_id}', '{$v2User->read_write_key}', '{$v1Player->player_id}', '0', '0')"); } return $v2User->user_id; }