4: 2013-09-30 (Mon) 17:37:33 iseki  |
Cur: 1970-01-01 (Thu) 18:00:00 |
| - | ***Avatars [#b9c223cf] | |
| - | - アバターの持ち物を管理 | |
| - | #br | |
| - | *** 装着物 [#p84144fa] | |
| - | mysql> show columns from Avatars; | |
| - | +-------------+--------------+------+-----+---------+-------+ | |
| - | | Field | Type | Null | Key | Default | Extra | | |
| - | +-------------+--------------+------+-----+---------+-------+ | |
| - | | PrincipalID | char(36) | NO | PRI | NULL | | | |
| - | | Name | varchar(32) | NO | PRI | NULL | | | |
| - | | Value | varchar(255) | NO | | | | | |
| - | +-------------+--------------+------+-----+---------+-------+ | |
| | | | |
| - | *** 装着物 [#v4461ef9] | |
| - | - 0.7.6 (アバター作成時) | |
| - | | |
| - | mysql> select * from Avatars where PrincipalID='0dc023b7-a10d-483e-b001-8b037ddbb984'; | |
| - | +--------------------------------------+--------------+---------------------------------------------------------------------------+ | |
| - | | PrincipalID | Name | Value | | |
| - | +--------------------------------------+--------------+---------------------------------------------------------------------------+ | |
| - | | 0dc023b7-a10d-483e-b001-8b037ddbb984 | AvatarHeight | 1.690999 | | |
| - | | 0dc023b7-a10d-483e-b001-8b037ddbb984 | AvatarType | 1 | | |
| - | | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Serial | 0 | | |
| - | | 0dc023b7-a10d-483e-b001-8b037ddbb984 | VisualParams | 33,61,85,23,58,127,63,...........................................,150,150 | | |
| - | | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 0:0 | 45ac2bd3-d28b-4c5b-8877-d37cab0e77b4:66c41e39-38f9-f75a-024e-585989bfab73 | | |
| - | | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 1:0 | 924e19e2-b96c-4f24-a15e-03076b51a19c:77c41e39-38f9-f75a-024e-585989bbabbb | | |
| - | | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 2:0 | cce8ab9b-9967-4be5-8a57-46c000c87d9f:d342e6c0-b9d2-11dc-95ff-0800200c9a66 | | |
| - | | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 3:0 | 2f954254-e2b9-4d56-ac55-46759ae7ed49:4bb6fa4d-1cd2-498a-a84c-95c1a0e745a7 | | |
| - | | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 4:0 | a68f54d7-24e1-4e1e-93d4-2daf61290a18:00000000-38f9-1111-024e-222222111110 | | |
| - | | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 5:0 | f1cf1d15-c42c-49c9-bdcb-2eb1f40d6416:00000000-38f9-1111-024e-222222111120 | | |
| - | +--------------------------------------+--------------+---------------------------------------------------------------------------+ | |
| - | 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 | |
| - | **** アバター作成時 [#ca8a6a5a] | |
| - | -- アッセットIDはシステムに依存． [[assets>../assets]] | |
| - | -- インベントリID はアバター毎に作成． [[inventoryitems>../inventoryitems]] | |
| - | #br | |
| - | | |
| - | *** 装着物 （OLD） [#x67ece58] | |
| - | mysql> select * from Avatars; | |
| - | +--------------------------------------+-----------------+--------------------------------------+ | |
| - | | PrincipalID | Name | Value | | |
| - | +--------------------------------------+-----------------+--------------------------------------+ | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderPantsAsset | 79731125-31b9-414a-bb1e-3458e629799c | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderShirtAsset | 0049510a-e0f9-471d-9128-08930b3d8f5a | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SocksAsset | 565c5109-40b7-48e8-ada8-303611b91e30 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkirtAsset | 00000000-0000-0000-0000-000000000000 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkinAsset | 9586e719-14bd-4130-af16-4b46943ff265 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShoesAsset | 00000000-0000-0000-0000-000000000000 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | PantsAsset | 82cdc415-f56b-4271-acff-e4e221d3562f | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShirtAsset | b5b146b3-8c20-4c2e-977a-d84f1a66beb6 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | EyesAsset | 17718b9a-b040-4fec-b1ad-3a3e0705b422 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | GlovesAsset | 00000000-0000-0000-0000-000000000000 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | HairAsset | d4a7c839-513e-e450-c563-26ceefdb845e | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | JacketAsset | 00000000-0000-0000-0000-000000000000 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | BodyAsset | 66207dfb-723a-4ea4-ad24-32e21a266b2a | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderPantsItem | 4d5af7ca-1401-43f5-bd34-2a9a78ae042f | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderShirtItem | d4d92b93-ece7-4df9-8bae-3b0ca3af6dc2 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SocksItem | 589839da-fd4b-4af3-8de0-c65a2bd0946c | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkirtItem | 00000000-0000-0000-0000-000000000000 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkinItem | 002a473d-2128-4054-8db4-ef8c6687c439 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShoesItem | 00000000-0000-0000-0000-000000000000 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShirtItem | f7aaa131-862e-47c0-865d-90259a871426 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | PantsItem | a9e16c8f-b640-4607-907d-7f73241f7c6c | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | JacketItem | 00000000-0000-0000-0000-000000000000 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | HairItem | 33eb9a48-3483-4ebc-b1dc-2b235aa5b4f3 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | BodyItem | 4bd2cad4-eca1-44df-a89f-e29125b179bf | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | GlovesItem | 00000000-0000-0000-0000-000000000000 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | EyesItem | dbbed340-5963-400b-b7bf-9d239b16d9d4 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | AvatarHeight | 1.489767 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | Serial | 1 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | UserID | 751c1531-03b5-48a9-8f2d-51a0527be7ca | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | METHOD | setavatar | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | VERSIONMAX | 0 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | VERSIONMIN | 0 | | |
| - | | 751c1531-03b5-48a9-8f2d-51a0527be7ca | AvatarType | 1 | | |
| - | +--------------------------------------+-----------------+--------------------------------------+ | |
