OpenSim/DB/0.7.5/Avatars
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
***Avatars [#kcb3003d]
- アバターの持ち物を管理
#br
*** 装着物 [#jeec7920]
mysql> show columns from Avatars;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| PrincipalID | char(36) | NO | PRI | NULL | ...
| Name | varchar(32) | NO | PRI | NULL | ...
| Value | varchar(255) | NO | | | ...
+-------------+--------------+------+-----+---------+---...
*** 装着物 [#sc725a30]
- 0.7.6 (アバター作成時)
mysql> select * from Avatars where PrincipalID='0dc023b7...
+--------------------------------------+--------------+-...
| PrincipalID | Name | ...
+--------------------------------------+--------------+-...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | AvatarHeight | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | AvatarType | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Serial | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | VisualParams | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 0:0 | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 1:0 | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 2:0 | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 3:0 | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 4:0 | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 5:0 | ...
+--------------------------------------+--------------+-...
10 rows in set (0.00 sec)
- Name
-- Wearable 0:0 : Shape
-- Wearable 1:0 : Skin
-- Wearable 2:0 : Hair
-- Wearable 3:0 : Eye
-- Wearable 4:0 : Shirt
-- Wearable 5:0 : Pant
- Value
-- インベントリID: アセットID
#br
**** アバター作成時 [#ze55c8a0]
-- アッセットIDはシステムに依存． [[assets>../assets]]
-- インベントリID はアバター毎に作成． [[inventoryitems>....
#br
*** 装着物 （OLD） [#x20f5717]
mysql> select * from Avatars;
+--------------------------------------+----------------...
| PrincipalID | Name ...
+--------------------------------------+----------------...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderPantsAsset...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderShirtAsset...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SocksAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkirtAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkinAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShoesAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | PantsAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShirtAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | EyesAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | GlovesAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | HairAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | JacketAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | BodyAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderPantsItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderShirtItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SocksItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkirtItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkinItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShoesItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShirtItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | PantsItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | JacketItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | HairItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | BodyItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | GlovesItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | EyesItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | AvatarHeight ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | Serial ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | UserID ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | METHOD ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | VERSIONMAX ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | VERSIONMIN ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | AvatarType ...
+--------------------------------------+----------------...
終了行:
***Avatars [#kcb3003d]
- アバターの持ち物を管理
#br
*** 装着物 [#jeec7920]
mysql> show columns from Avatars;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| PrincipalID | char(36) | NO | PRI | NULL | ...
| Name | varchar(32) | NO | PRI | NULL | ...
| Value | varchar(255) | NO | | | ...
+-------------+--------------+------+-----+---------+---...
*** 装着物 [#sc725a30]
- 0.7.6 (アバター作成時)
mysql> select * from Avatars where PrincipalID='0dc023b7...
+--------------------------------------+--------------+-...
| PrincipalID | Name | ...
+--------------------------------------+--------------+-...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | AvatarHeight | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | AvatarType | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Serial | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | VisualParams | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 0:0 | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 1:0 | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 2:0 | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 3:0 | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 4:0 | ...
| 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 5:0 | ...
+--------------------------------------+--------------+-...
10 rows in set (0.00 sec)
- Name
-- Wearable 0:0 : Shape
-- Wearable 1:0 : Skin
-- Wearable 2:0 : Hair
-- Wearable 3:0 : Eye
-- Wearable 4:0 : Shirt
-- Wearable 5:0 : Pant
- Value
-- インベントリID: アセットID
#br
**** アバター作成時 [#ze55c8a0]
-- アッセットIDはシステムに依存． [[assets>../assets]]
-- インベントリID はアバター毎に作成． [[inventoryitems>....
#br
*** 装着物 （OLD） [#x20f5717]
mysql> select * from Avatars;
+--------------------------------------+----------------...
| PrincipalID | Name ...
+--------------------------------------+----------------...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderPantsAsset...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderShirtAsset...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SocksAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkirtAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkinAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShoesAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | PantsAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShirtAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | EyesAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | GlovesAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | HairAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | JacketAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | BodyAsset ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderPantsItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderShirtItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SocksItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkirtItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkinItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShoesItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShirtItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | PantsItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | JacketItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | HairItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | BodyItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | GlovesItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | EyesItem ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | AvatarHeight ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | Serial ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | UserID ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | METHOD ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | VERSIONMAX ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | VERSIONMIN ...
| 751c1531-03b5-48a9-8f2d-51a0527be7ca | AvatarType ...
+--------------------------------------+----------------...
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
