Record and Play Character Movement (Save to MySQL)
[
Front page
] [
New
|
List of pages
|
Search
|
Recent changes
|
Help
]
Start:
[[Tutorial for ver.3]]
* Record and Play Character Movements (Save to MySQL) [#r...
In this example, you can use MySQL to record and play bac...
** Setting up MySQL Environment [#be7e0a5b]
If you want to use MySQL, you will need to build a MySQL ...
+ Install MySQL Community Server. Operation confirmed wit...
You can download MySQL product from [[here>https://dev.my...
It can be installed using the MySQL Installer for Windows.
-- Setup Type: Developer Default
-- MySQL Root Password: Any
+ Connect to the MySQL Server using MySQL Workbench.
+ 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;
+ Execute [Query]-[Execute (All or Selection)].
In the SIGVerse setting window, set to use MySQL.
+ Click [SIGVerse]-[SIGVerse Settings] in the Unity menu ...
+ Check [Use MySQL] in [Define symbols Settings].
#ref(UseMySQL.png)
Since an error occurs in the [Console] tab of the Unity e...
+ Access [[Download Site(Archived Versions)>https://downl...
+ Select [''8.0.15''] for [Product Version], [.NET & Mono...
+ When you unzip the downloaded zip file, confirm that My...
+ Copy the two files by drag and drop into [Assets/Plugin...
+ Confirm that the error on the [Console] tab has disappe...
#ref(MySQLLibrary.png)
** Startup Procedure [#t3463616]
//Start the [Assets/SIGVerse/ExampleScenes/Playbacker/Pla...
Follow the steps below to run the Unity example scene.
+ Open the SIGVerse project in Unity.
+ Double-click [Assets/SIGVerse/ExampleScenes/Playbacker/...
+ Click the play button at the top center of the Unity to...
** Recording to MySQL [#kb03705c]
+ Select [Database Recorder] for Mode.
+ Make some settings such as [Unique ID] and database con...
+ Click the [Start] button to start recording to MySQL.
+ Operate the character with the arrow keys. ~
(Click [Baby icon] to show/hide the panel.)
+ Click the [Stop] button to stop recording to MySQL.
Unity (The details may differ from the latest version)
#ref(PlaybackDatabaseRecording.png)
** Playback from MySQL [#e12bcc33]
+ Select [Database Player] for Mode.
+ Set the same database connection settings and [Unique I...
+ Press the [Start] button to start playback. ~
(Click [Baby icon] to show/hide the panel.)
+ When the [Stop] button is pressed or the recording time...
Unity (The details may differ from the latest version)
#ref(PlaybackDatabasePlaying.png)
----
''Reference Video''
#youtube(TO4rDd6j3qE)
End:
[[Tutorial for ver.3]]
* Record and Play Character Movements (Save to MySQL) [#r...
In this example, you can use MySQL to record and play bac...
** Setting up MySQL Environment [#be7e0a5b]
If you want to use MySQL, you will need to build a MySQL ...
+ Install MySQL Community Server. Operation confirmed wit...
You can download MySQL product from [[here>https://dev.my...
It can be installed using the MySQL Installer for Windows.
-- Setup Type: Developer Default
-- MySQL Root Password: Any
+ Connect to the MySQL Server using MySQL Workbench.
+ 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;
+ Execute [Query]-[Execute (All or Selection)].
In the SIGVerse setting window, set to use MySQL.
+ Click [SIGVerse]-[SIGVerse Settings] in the Unity menu ...
+ Check [Use MySQL] in [Define symbols Settings].
#ref(UseMySQL.png)
Since an error occurs in the [Console] tab of the Unity e...
+ Access [[Download Site(Archived Versions)>https://downl...
+ Select [''8.0.15''] for [Product Version], [.NET & Mono...
+ When you unzip the downloaded zip file, confirm that My...
+ Copy the two files by drag and drop into [Assets/Plugin...
+ Confirm that the error on the [Console] tab has disappe...
#ref(MySQLLibrary.png)
** Startup Procedure [#t3463616]
//Start the [Assets/SIGVerse/ExampleScenes/Playbacker/Pla...
Follow the steps below to run the Unity example scene.
+ Open the SIGVerse project in Unity.
+ Double-click [Assets/SIGVerse/ExampleScenes/Playbacker/...
+ Click the play button at the top center of the Unity to...
** Recording to MySQL [#kb03705c]
+ Select [Database Recorder] for Mode.
+ Make some settings such as [Unique ID] and database con...
+ Click the [Start] button to start recording to MySQL.
+ Operate the character with the arrow keys. ~
(Click [Baby icon] to show/hide the panel.)
+ Click the [Stop] button to stop recording to MySQL.
Unity (The details may differ from the latest version)
#ref(PlaybackDatabaseRecording.png)
** Playback from MySQL [#e12bcc33]
+ Select [Database Player] for Mode.
+ Set the same database connection settings and [Unique I...
+ Press the [Start] button to start playback. ~
(Click [Baby icon] to show/hide the panel.)
+ When the [Stop] button is pressed or the recording time...
Unity (The details may differ from the latest version)
#ref(PlaybackDatabasePlaying.png)
----
''Reference Video''
#youtube(TO4rDd6j3qE)
Page:
![[PukiWiki]](image/Concept_logo.jpg "[PukiWiki]"){kind=logo}
