Record and Play Character Movement (Save to MySQL)

Tutorial for ver.3

Record and Play Character Movements (Save to MySQL) †

In this example, you can use MySQL to record and play back the movements of characters and some objects.

Setting up MySQL Environment †

If you want to use MySQL, you will need to build a MySQL Server. The details are omitted, but the outline is as follows.

1. Install MySQL Community Server. Operation confirmed with version [8.0.25].
   You can download MySQL product from here. (Archived Versions here)
   It can be installed using the MySQL Installer for Windows.
   • Setup Type: Developer Default
   • MySQL Root Password: Any
2. Connect to the MySQL Server using MySQL Workbench.
3. Paste the following command into the Query field.

   CREATE DATABASE sigverse;
   
   CREATE USER sigverse@'%' IDENTIFIED BY 'sigverse';
   
   GRANT ALL ON sigverse.* TO sigverse@'%';
   
   USE sigverse;
   
   CREATE TABLE `playbacker_motion_data` (
     `recording_id` int NOT NULL,
     `elapsed_time` int NOT NULL,
     `data_type` int NOT NULL,
     `motion_data` text NOT NULL,
     PRIMARY KEY (`elapsed_time`,`data_type`,`recording_id`)
   ) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;

4. Execute [Query]-[Execute (All or Selection)].

In the SIGVerse setting window, set to use MySQL.

1. Click [SIGVerse]-[SIGVerse Settings] in the Unity menu to open the SIGVerse setting window.
2. Check [Use MySQL] in [Define symbols Settings].

Since an error occurs in the [Console] tab of the Unity editor, add the MySQL library to the Unity editor.

1. Access Download Site(Archived Versions) of Connector/NET.
2. Select [8.0.15] for [Product Version], [.NET & Mono] for [Operating System], and click [Download].　*NOT 8.0.25.
3. When you unzip the downloaded zip file, confirm that MySql.Data.dll and Google.Protobuf.dll exist in the "v4.5.2" folder.
4. Copy the two files by drag and drop into [Assets/Plugins] on the [Project] tab.
5. Confirm that the error on the [Console] tab has disappeared.

Startup Procedure †

Follow the steps below to run the Unity example scene.

1. Open the SIGVerse project in Unity.
2. Double-click [Assets/SIGVerse/ExampleScenes/Playbacker/Playbacker(.unity)] on the [Project] tab to open the target scene.
3. Click the play button at the top center of the Unity to play the scene.

Recording to MySQL †

1. Select [Database Recorder] for Mode.
2. Make some settings such as [Unique ID] and database connection information(User, Password).
3. Click the [Start] button to start recording to MySQL.
4. Operate the character with the arrow keys.
   (Click [Baby icon] to show/hide the panel.)
5. Click the [Stop] button to stop recording to MySQL.

Unity (The details may differ from the latest version)

Playback from MySQL †

1. Select [Database Player] for Mode.
2. Set the same database connection settings and [Unique ID] set in the above recording procedure.
3. Press the [Start] button to start playback.
   (Click [Baby icon] to show/hide the panel.)
4. When the [Stop] button is pressed or the recording time elapses, playback ends.

Unity (The details may differ from the latest version)

Reference Video