- 自グリッドのアバターがどこへ移動したか?
Columns 
MariaDB [jogrid_db]> show columns from hg_traveling_data; +------------------+--------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+-------------------+-----------------------------+ | SessionID | varchar(36) | NO | PRI | NULL | | | UserID | varchar(36) | NO | MUL | NULL | | | GridExternalName | varchar(255) | NO | | | | | ServiceToken | varchar(255) | NO | | | | | ClientIPAddress | varchar(16) | NO | | | | | MyIPAddress | varchar(16) | NO | | | | | TMStamp | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +------------------+--------------+------+-----+-------------------+-----------------------------+ 7 rows in set (0.00 sec)
Select 
MariaDB [jogrid_db]> select UserID,GridExternalName,ClientIPAddress,TMStamp from hg_traveling_data; +--------------------------------------+---------------------------------+-----------------+---------------------+ | UserID | GridExternalName | ClientIPAddress | TMStamp | +--------------------------------------+---------------------------------+-----------------+---------------------+ | 3c34a5a3-1068-4151-8c98-76efb7900c02 | http://jogrid.net:8002/ | 180.220.84.22 | 2016-05-11 17:43:55 | | 64bdf6f6-f5f3-4bea-9ca2-dd763a19b68a | http://opensim.tuis.ac.jp:8002/ | 172.22.1.79 | 2016-05-17 17:51:44 | <= Fumi.Hax teleport from JOG to TUIS | 3c34a5a3-1068-4151-8c98-76efb7900c02 | http://jogrid.net:8002/ | 180.220.84.22 | 2016-05-11 17:43:23 | | 3fe3be10-9dca-4377-a157-c9d66b8d6add | http://jogrid.net:8002/ | 112.69.226.95 | 2016-05-13 20:03:10 | | 3fe3be10-9dca-4377-a157-c9d66b8d6add | http://jogrid.net:8002/ | 112.69.226.95 | 2016-05-13 21:19:24 | | 64bdf6f6-f5f3-4bea-9ca2-dd763a19b68a | http://jogrid.net:8002/ | 36.2.113.124 | 2016-05-17 02:28:38 | | 0fa2fdd3-e4b7-456f-aa79-75aade09aded | http://jogrid.net:8002/ | 219.122.167.117 | 2016-05-17 17:26:17 | | 3d6c1ecd-9ee3-4cf5-883f-c05950027a32 | http://jogrid.net:8002/ | 124.154.127.89 | 2016-05-15 22:50:11 | | 03995f91-c73f-4407-9fb9-d1e369386400 | http://jogrid.net:8002/ | 121.3.1.32 | 2016-05-12 12:23:07 | | b0d5e508-611a-44eb-82b0-70e38dfcb2a8 | http://jogrid.net:8002/ | 118.17.251.101 | 2016-05-09 21:55:02 | ..... +--------------------------------------+---------------------------------+-----------------+---------------------+ 44 rows in set (0.00 sec)
Counter: 914,
today: 1,
yesterday: 0
最終更新: 2016-05-17 (火) 17:54:12 (JST) (3193d) by iseki