3: 2010-04-29 (木) 23:33:05 admin  |
4: 2013-09-30 (月) 17:37:33 iseki |
| - | *** Avatars [#b9c223cf] | + | ***Avatars [#b9c223cf] |
| - | - 装着物 | + | - アバターの持ち物を管理 |
| | + | #br |
| | + | *** 装着物 [#p84144fa] |
| | mysql> show columns from Avatars; | | mysql> show columns from Avatars; |
| | +-------------+--------------+------+-----+---------+-------+ | | +-------------+--------------+------+-----+---------+-------+ |
| | +-------------+--------------+------+-----+---------+-------+ | | +-------------+--------------+------+-----+---------+-------+ |
| | | | |
| - | - 装着物 | + | *** 装着物 [#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; | | mysql> select * from Avatars; |
| | +--------------------------------------+-----------------+--------------------------------------+ | | +--------------------------------------+-----------------+--------------------------------------+ |
