flagflag  
  
Cur: 2015-12-05 (Sat) 12:13:46 iseki source
Line 1: Line 1:
 +***Avatars [#kcb3003d]
 +- アバターの持ち物を管理
 +#br
 +*** 装着物 [#jeec7920]
 + 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  |    |        |      |
 + +-------------+--------------+------+--​---+---------+-------+
 +*** 装着物 [#sc725a30]
 +- 0.7.6 (アバター作成時)
 +
 + mysql> select * from Avatars where PrincipalID='0dc023b7-a10d-483e-b001-8b0​37ddbb984';
 + +--------------------------------------​+--------------+------------------------​----------------------------------------​-----------+
 + | 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:66c​41e39-38f9-f75a-024e-585989bfab73 |
 + | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 1:0 | 924e19e2-b96c-4f24-a15e-03076b51a19c:77c​41e39-38f9-f75a-024e-585989bbabbb |
 + | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 2:0 | cce8ab9b-9967-4be5-8a57-46c000c87d9f:d34​2e6c0-b9d2-11dc-95ff-0800200c9a66 |
 + | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 3:0 | 2f954254-e2b9-4d56-ac55-46759ae7ed49:4bb​6fa4d-1cd2-498a-a84c-95c1a0e745a7 |
 + | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 4:0 | a68f54d7-24e1-4e1e-93d4-2daf61290a18:000​00000-38f9-1111-024e-222222111110 |
 + | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 5:0 | f1cf1d15-c42c-49c9-bdcb-2eb1f40d6416:000​00000-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
 +**** アバター作成時 [#ze55c8a0]
 +-- アッセットIDはシステムに依存． [[assets>../assets]]
 +-- インベントリID はアバター毎に作成． [[inventoryitems>../inventoryitems]]
 +#br
 +
 +*** 装着物　（OLD） [#x20f5717]
 + 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                                    |
 + +--------------------------------------​+-----------------+---------------------​-----------------+
  
  • Backup diff of OpenSim/DB/0.7.5/Avatars(No. All)
    • Cur: 2015-12-05 (Sat) 12:13:46 iseki
Front page   New List of Pages Search Recent changes   Help   RSS of recent changes (RSS 1.0) RSS of recent changes (RSS 2.0) RSS of recent changes (RSS Atom)
Page owner: iseki
Site admin: admin

Site Search


Advanced Search

Login
Username:

Password:


Lost Password?
Register now!!

Sub Menu

Books

mini Calendar
Last MonthApr 2024Next Month
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30
Today

Who's Online
72 user(s) are online (12 user(s) are browsing xpwiki)

Members: 0
Guests: 72

more...

Access Counter
Today : 2026520265202652026520265
Yesterday : 1795517955179551795517955
Total : 2337924223379242233792422337924223379242233792422337924223379242
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com