装着物 
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 | | | | +-------------+--------------+------+-----+---------+-------+
装着物 
- 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
- インベントリID: アセットID
アバター作成時 
- アッセットIDはシステムに依存. assets
- インベントリID はアバター毎に作成. inventoryitems
装着物 (OLD) 
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 | +--------------------------------------+-----------------+--------------------------------------+
Counter: 1169,
today: 1,
yesterday: 2
最終更新: 2015-12-05 (土) 12:13:46 (JST) (3429d) by iseki