flagflag  If you want to see English page, please click "English" Button at Left.

inventoryitems anchor.png

  • インベントリのデータ
     
Page Top

DB anchor.png

mysql> show columns from inventoryitems;
+------------------------------+------------------+------+-----+--------------------------------------+-------+
| Field                        | Type             | Null | Key | Default                              | Extra |
+------------------------------+------------------+------+-----+--------------------------------------+-------+
| assetID                      | varchar(36)      | YES  |     | NULL                                 |       |
| assetType                    | int(11)          | YES  |     | NULL                                 |       |
| inventoryName                | varchar(64)      | YES  |     | NULL                                 |       |
| inventoryDescription         | varchar(128)     | YES  |     | NULL                                 |       |
| inventoryNextPermissions     | int(10) unsigned | YES  |     | NULL                                 |       |
| inventoryCurrentPermissions  | int(10) unsigned | YES  |     | NULL                                 |       |
| invType                      | int(11)          | YES  |     | NULL                                 |       |
| creatorID                    | varchar(255)     | NO   |     | 00000000-0000-0000-0000-000000000000 |       |
| inventoryBasePermissions     | int(10) unsigned | NO   |     | 0                                    |       |
| inventoryEveryOnePermissions | int(10) unsigned | NO   |     | 0                                    |       |
| salePrice                    | int(11)          | NO   |     | 0                                    |       |
| saleType                     | tinyint(4)       | NO   |     | 0                                    |       |
| creationDate                 | int(11)          | NO   |     | 0                                    |       |
| groupID                      | varchar(36)      | NO   |     | 00000000-0000-0000-0000-000000000000 |       |
| groupOwned                   | tinyint(4)       | NO   |     | 0                                    |       |
| flags                        | int(11) unsigned | NO   |     | 0                                    |       |
| inventoryID                  | char(36)         | NO   | PRI | 00000000-0000-0000-0000-000000000000 |       |
| avatarID                     | char(36)         | YES  | MUL | NULL                                 |       |
| parentFolderID               | char(36)         | YES  | MUL | NULL                                 |       |
| inventoryGroupPermissions    | int(10) unsigned | NO   |     | 0                                    |       |
+------------------------------+------------------+------+-----+--------------------------------------+-------+
20 rows in set (0.00 sec)
Page Top

Ex. anchor.png

mysql> select * from inventoryitems where avatarID='0dc023b7-a10d-483e-b001-8b037ddbb984';
+--------------------------------------+-----------+---------------+----------------------+--------------------------+-----------------------------+---------+--------------------------------------+--------------------------+------------------------------+-----------+----------+--------------+--------------------------------------+------------+-------+--------------------------------------+--------------------------------------+--------------------------------------+---------------------------+
| assetID                              | assetType | inventoryName | inventoryDescription | inventoryNextPermissions | inventoryCurrentPermissions | invType | creatorID                            | inventoryBasePermissions | inventoryEveryOnePermissions | salePrice | saleType | creationDate | groupID                              | groupOwned | flags | inventoryID                          | avatarID                             | parentFolderID                       | inventoryGroupPermissions |
+--------------------------------------+-----------+---------------+----------------------+--------------------------+-----------------------------+---------+--------------------------------------+--------------------------+------------------------------+-----------+----------+--------------+--------------------------------------+------------+-------+--------------------------------------+--------------------------------------+--------------------------------------+---------------------------+
| 66c41e39-38f9-f75a-024e-585989bfab73 |        13 | Default Shape |                      |                   581632 |                      581632 |      18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 |                   581632 |                       581632 |         0 |        0 |   1380526900 | 00000000-0000-0000-0000-000000000000 |          0 |     0 | 45ac2bd3-d28b-4c5b-8877-d37cab0e77b4 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 907354d3-832a-49f9-89a3-e004efd15119 |                    581632 |
| 77c41e39-38f9-f75a-024e-585989bbabbb |        13 | Default Skin  |                      |                   581632 |                      581632 |      18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 |                   581632 |                       581632 |         0 |        0 |   1380526900 | 00000000-0000-0000-0000-000000000000 |          0 |     1 | 924e19e2-b96c-4f24-a15e-03076b51a19c | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 907354d3-832a-49f9-89a3-e004efd15119 |                    581632 |
| d342e6c0-b9d2-11dc-95ff-0800200c9a66 |        13 | Default Hair  |                      |                   581632 |                      581632 |      18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 |                   581632 |                       581632 |         0 |        0 |   1380526900 | 00000000-0000-0000-0000-000000000000 |          0 |     2 | cce8ab9b-9967-4be5-8a57-46c000c87d9f | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 907354d3-832a-49f9-89a3-e004efd15119 |                    581632 |
| 4bb6fa4d-1cd2-498a-a84c-95c1a0e745a7 |        13 | Default Eyes  |                      |                   581632 |                      581632 |      18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 |                   581632 |                       581632 |         0 |        0 |   1380526900 | 00000000-0000-0000-0000-000000000000 |          0 |     3 | 2f954254-e2b9-4d56-ac55-46759ae7ed49 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 907354d3-832a-49f9-89a3-e004efd15119 |                    581632 |
| 00000000-38f9-1111-024e-222222111110 |         5 | Default Shirt |                      |                   581632 |                      581632 |      18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 |                   581632 |                       581632 |         0 |        0 |   1380526900 | 00000000-0000-0000-0000-000000000000 |          0 |     4 | a68f54d7-24e1-4e1e-93d4-2daf61290a18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 80971833-381f-4590-9896-41e3fb76feb5 |                    581632 |
| 00000000-38f9-1111-024e-222222111120 |         5 | Default Pants |                      |                   581632 |                      581632 |      18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 |                   581632 |                       581632 |         0 |        0 |   1380526900 | 00000000-0000-0000-0000-000000000000 |          0 |     5 | f1cf1d15-c42c-49c9-bdcb-2eb1f40d6416 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 80971833-381f-4590-9896-41e3fb76feb5 |                    581632 |
+--------------------------------------+-----------+---------------+----------------------+--------------------------+-----------------------------+---------+--------------------------------------+--------------------------+------------------------------+-----------+----------+--------------+--------------------------------------+------------+-------+--------------------------------------+--------------------------------------+--------------------------------------+---------------------------+
6 rows in set (0.00 sec)

トップ   凍結 差分 バックアップ 複製 名前変更 リロード   新規 ページ一覧 単語検索 最終更新   ヘルプ   最終更新のRSS 1.0 最終更新のRSS 2.0 最終更新のRSS Atom
Counter: 504, today: 1, yesterday: 0
最終更新: 2013-09-30 (月) 17:41:27 (JST) (2258d) by iseki

サイト内 検索

ログイン

ユーザー名:

パスワード:


パスワード紛失
新規登録

サブ メニュー

ミニカレンダー

前月2019年 12月翌月
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 31
<今日>

オンライン状況

136 人のユーザが現在オンラインです。 (35 人のユーザが xpwiki を参照しています。)

登録ユーザ: 0
ゲスト: 136

もっと...

アクセスカウンタ

今日 : 1549815498154981549815498
昨日 : 1426214262142621426214262
総計 : 1296018112960181129601811296018112960181129601811296018112960181
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com