API tools faq
paste
Hastwell

lwood262 vs fofang13 [incident 1, mawr data]

Hastwell
Jan 13th, 2015
224
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.29 KB | None | 0 0
raw download clone embed print report
  1. lwood262 vs fofang [Incident 1; ctn'd data logs]
  2.  
  3. List all Nether Quartz (#406) interacted with by fofang13 EVER, sorted by date (ascending)
  4.  
  5. SELECT FROM_UNIXTIME(epoch), prism_data.id, action, world, x, y, z, prism_data_extra.data FROM `prism_data`
  6. INNER JOIN prism_players ON prism_data.player_id = prism_players.player_id
  7. INNER JOIN prism_actions ON prism_data.action_id = prism_actions.action_id
  8. INNER JOIN prism_worlds ON prism_data.world_id = prism_worlds.world_id
  9. LEFT JOIN prism_data_extra ON prism_data.id = prism_data_extra.data_id
  10. WHERE player = 'fofang13' AND block_id = 406
  11. ORDER BY epoch;
  12.  
  13. Some data in extra_data is omitted for brevity; contains attributes not used by any actions listed.
  14. Example of original data: {"amt":1,"color":0,"slot":0,"hasFlicker":false,"hasTrail":false}
  15.  
  16. +----------------------+---------+-------------+-------+------+----+-----+--------------------------------------------------------------------+
  17. | FROM_UNIXTIME(epoch) | id | action | world | x | y | z | extra data (some useless data omitted) |
  18. +----------------------+---------+-------------+-------+------+----+-----+--------------------------------------------------------------------+
  19. | 2015-01-10 15:34:08 | 1394128 | item-pickup | DIM-1 | -42 | 75 | -77 | {"amt":1 "slot":-1, } |
  20. | 2015-01-10 15:38:15 | 1395330 | item-insert | world | -309 | 60 | -94 | {"amt":1 "slot":7, } |
  21. | 2015-01-10 15:38:15 | 1395332 | item-insert | world | -309 | 60 | -94 | {"amt":1 "slot":8, } |
  22. | 2015-01-10 15:42:42 | 1396066 | item-insert | world | -310 | 60 | -93 | {"amt":1 "slot":2, } |
  23. | 2015-01-10 15:42:42 | 1396067 | item-remove | world | -310 | 60 | -93 | {"amt":1 "slot":2, } |
  24. | 2015-01-10 15:42:42 | 1396068 | item-insert | world | -310 | 60 | -93 | {"amt":1 "slot":2, } |
  25. | 2015-01-10 15:42:48 | 1396100 | item-remove | world | -310 | 60 | -93 | {"amt":1 "slot":2, } |
  26. | 2015-01-10 15:42:57 | 1396151 | item-insert | world | -310 | 60 | -93 | {"amt":1 "slot":2, } |
  27. | 2015-01-10 15:43:31 | 1396252 | item-insert | world | -309 | 60 | -89 | {"amt":1 "slot":2, } |
  28. | 2015-01-10 15:43:31 | 1396253 | item-remove | world | -309 | 60 | -89 | {"amt":1 "slot":2, } |
  29. | 2015-01-10 15:43:31 | 1396254 | item-insert | world | -309 | 60 | -89 | {"amt":1 "slot":2, } |
  30. | 2015-01-10 15:43:31 | 1396255 | item-remove | world | -309 | 60 | -89 | {"amt":1 "slot":2, } |
  31. | 2015-01-10 15:43:31 | 1396256 | item-insert | world | -309 | 60 | -89 | {"amt":1 "slot":2, } |
  32. | 2015-01-10 15:43:33 | 1396279 | item-drop | world | -309 | 60 | -89 | {"amt":1 "slot":-1, } |
  33. | 2015-01-10 15:47:59 | 1397271 | item-insert | world | -313 | 60 | -97 | {"amt":1 "slot":0, } |
  34. | 2015-01-10 15:48:00 | 1397272 | item-remove | world | -313 | 60 | -97 | {"amt":1 "slot":0, } |
  35. | 2015-01-10 15:48:00 | 1397273 | item-insert | world | -313 | 60 | -97 | {"amt":1 "slot":0, } |
  36. | 2015-01-10 15:49:14 | 1397570 | item-insert | world | -310 | 60 | -95 | {"amt":1 "slot":2, } |
  37. | 2015-01-10 15:49:14 | 1397571 | item-remove | world | -310 | 60 | -95 | {"amt":1 "slot":2, } |
  38. | 2015-01-10 15:49:14 | 1397572 | item-insert | world | -310 | 60 | -95 | {"amt":1 "slot":2, } |
  39. | 2015-01-10 15:49:18 | 1397610 | item-remove | world | -310 | 60 | -95 | {"amt":1 "slot":2, } |
  40. | 2015-01-10 15:49:39 | 1397690 | item-insert | world | -313 | 60 | -97 | {"amt":12 "slot":-1, } |
  41. | 2015-01-10 17:57:42 | 1444149 | item-insert | world | -319 | 60 | -92 | {"amt":7 "slot":-1, } |
  42. | 2015-01-10 18:02:37 | 1444818 | item-remove | world | -313 | 60 | -97 | {"amt":5 "slot":0, } |
  43. | 2015-01-10 18:09:09 | 1446426 | item-insert | world | -319 | 60 | -94 | {"amt":5 "slot":-1, } |
  44. | 2015-01-11 16:10:59 | 1653636 | item-pickup | DIM-1 | -66 | 89 | -48 | {"amt":1 "slot":-1, } |
  45. | 2015-01-11 16:21:56 | 1655897 | item-drop | world | -310 | 60 | -94 | {"amt":57 "slot":-1, } |
  46. | 2015-01-11 16:22:02 | 1655920 | item-pickup | world | -310 | 60 | -94 | {"amt":57 "slot":-1, } |
  47. | 2015-01-11 16:22:07 | 1655959 | item-insert | world | -309 | 60 | -95 | {"amt":57 "slot":2, } |
  48. | 2015-01-11 16:22:10 | 1655979 | item-remove | world | -309 | 60 | -95 | {"amt":53 "slot":2, } |
  49. | 2015-01-11 16:28:11 | 1657610 | item-remove | world | -309 | 60 | -87 | {"amt":53 "slot":10, } |
  50. | 2015-01-11 16:48:05 | 1662714 | item-insert | world | -311 | 60 | -97 | {"amt":53 "slot":-1, } |
  51. | 2015-01-11 16:48:05 | 1662717 | item-insert | world | -311 | 60 | -97 | {"amt":53 "slot":-1, } |
  52. | 2015-01-11 16:48:06 | 1662719 | item-insert | world | -311 | 60 | -97 | {"amt":53 "slot":-1, } |
  53. | 2015-01-12 17:56:35 | 1812069 | item-remove | world | -308 | 60 | -97 | {"amt":53 "slot":3, } |
  54. | 2015-01-12 17:56:37 | 1812070 | item-insert | world | -308 | 60 | -97 | {"amt":49 "slot":3, } |
  55. | 2015-01-12 17:57:42 | 1812102 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":9, } |
  56. | 2015-01-12 17:57:42 | 1812104 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":7, } |
  57. | 2015-01-12 17:57:42 | 1812105 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":3, } |
  58. | 2015-01-12 17:57:43 | 1812106 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":5, } |
  59. | 2015-01-12 18:44:27 | 1817499 | item-remove | world | -308 | 60 | -97 | {"amt":49 "slot":3, } |
  60. | 2015-01-12 18:45:55 | 1817626 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":9, } |
  61. | 2015-01-12 18:45:56 | 1817627 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":7, } |
  62. | 2015-01-12 18:45:56 | 1817628 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":3, } |
  63. | 2015-01-12 18:45:57 | 1817630 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":5, } |
  64. | 2015-01-12 18:59:56 | 1819138 | item-insert | world | -308 | 60 | -97 | {"amt":45 "slot":-1, } |
  65. | 2015-01-12 20:19:38 | 1829178 | item-remove | world | -475 | 56 | 222 | {"amt":27 "slot":2, } |
  66. | 2015-01-12 20:19:41 | 1829185 | item-insert | world | -475 | 56 | 222 | {"amt":22 "slot":2, } |
  67. | 2015-01-12 20:19:43 | 1829190 | item-remove | world | -475 | 56 | 222 | {"amt":11 "slot":2, } |
  68. | 2015-01-12 20:19:43 | 1829191 | item-insert | world | -475 | 56 | 222 | {"amt":1 "slot":2, } |
  69. | 2015-01-12 20:19:51 | 1829221 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":9, } |
  70. | 2015-01-12 20:19:51 | 1829224 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":7, } |
  71. | 2015-01-12 20:19:52 | 1829225 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":3, } |
  72. | 2015-01-12 20:19:52 | 1829229 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":5, } |
  73. | 2015-01-12 20:20:43 | 1829338 | item-remove | world | -475 | 56 | 222 | {"amt":23 "slot":2, } |
  74. | 2015-01-12 20:20:46 | 1829346 | item-insert | world | -475 | 56 | 222 | {"amt":19 "slot":2, } |
  75. | 2015-01-12 20:20:58 | 1829370 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":3, } |
  76. | 2015-01-12 20:20:58 | 1829371 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":5, } |
  77. | 2015-01-12 20:20:58 | 1829372 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":7, } |
  78. | 2015-01-12 20:20:58 | 1829373 | item-insert | world | -480 | 54 | 217 | {"amt":1 "slot":9, } |
  79. | 2015-01-12 20:43:17 | 1832611 | item-remove | world | -475 | 56 | 222 | {"amt":19 "slot":2, } |
  80. | 2015-01-12 20:43:17 | 1832612 | item-insert | world | -475 | 56 | 222 | {"amt":19 "slot":-1, } |
  81. | 2015-01-12 20:43:17 | 1832613 | item-drop | world | -477 | 54 | 221 | {"amt":19 "slot":-1, } |
  82. | 2015-01-12 20:43:24 | 1832615 | item-pickup | world | -476 | 54 | 221 | {"amt":19 "slot":-1, } |
  83. | 2015-01-12 20:43:27 | 1832616 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  84. | 2015-01-12 20:43:28 | 1832617 | item-remove | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  85. | 2015-01-12 20:43:28 | 1832618 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  86. | 2015-01-12 20:43:28 | 1832619 | item-remove | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  87. | 2015-01-12 20:43:28 | 1832620 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  88. | 2015-01-12 20:43:28 | 1832621 | item-remove | world | -476 | 54 | 219 | {"amt":2 "slot":30, } |
  89. | 2015-01-12 20:43:28 | 1832622 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  90. | 2015-01-12 20:43:28 | 1832623 | item-remove | world | -476 | 54 | 219 | {"amt":2 "slot":30, } |
  91. | 2015-01-12 20:43:28 | 1832624 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  92. | 2015-01-12 20:43:28 | 1832625 | item-remove | world | -476 | 54 | 219 | {"amt":3 "slot":30, } |
  93. | 2015-01-12 20:43:28 | 1832626 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  94. | 2015-01-12 20:43:28 | 1832627 | item-remove | world | -476 | 54 | 219 | {"amt":3 "slot":30, } |
  95. | 2015-01-12 20:43:28 | 1832628 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  96. | 2015-01-12 20:43:29 | 1832629 | item-remove | world | -476 | 54 | 219 | {"amt":4 "slot":30, } |
  97. | 2015-01-12 20:43:29 | 1832630 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  98. | 2015-01-12 20:43:29 | 1832631 | item-remove | world | -476 | 54 | 219 | {"amt":4 "slot":30, } |
  99. | 2015-01-12 20:43:29 | 1832632 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  100. | 2015-01-12 20:43:29 | 1832633 | item-remove | world | -476 | 54 | 219 | {"amt":4 "slot":30, } |
  101. | 2015-01-12 20:43:29 | 1832634 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  102. | 2015-01-12 20:43:29 | 1832635 | item-remove | world | -476 | 54 | 219 | {"amt":5 "slot":30, } |
  103. | 2015-01-12 20:43:29 | 1832636 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  104. | 2015-01-12 20:43:30 | 1832637 | item-remove | world | -476 | 54 | 219 | {"amt":6 "slot":30, } |
  105. | 2015-01-12 20:43:30 | 1832638 | item-insert | world | -476 | 54 | 219 | {"amt":1 "slot":30, } |
  106. | 2015-01-12 20:43:30 | 1832639 | item-insert | world | -476 | 54 | 219 | {"amt":7 "slot":31, } |
  107. | 2015-01-12 20:43:32 | 1832640 | item-insert | world | -475 | 56 | 222 | {"amt":7 "slot":-1, } |
  108. | 2015-01-12 20:47:45 | 1832986 | item-insert | world | -468 | 46 | 225 | {"amt":12 "slot":-1, } |
  109. | 2015-01-12 20:48:48 | 1833157 | item-remove | world | -478 | 54 | 220 | {"amt":12 "slot":25, } |
  110. | 2015-01-12 20:48:48 | 1833159 | item-insert | world | -478 | 54 | 220 | {"amt":12 "slot":-1, } |
  111. | 2015-01-12 20:48:48 | 1833160 | item-drop | world | -478 | 54 | 220 | {"amt":12 "slot":-1, } |
  112. | 2015-01-12 21:04:10 | 1835436 | item-remove | world | -308 | 60 | -97 | {"amt":45 "slot":42, } |
  113. | 2015-01-12 21:11:59 | 1836591 | item-drop | world | -309 | 60 | -93 | {"amt":1 "slot":-1, } |
  114. | 2015-01-12 21:12:10 | 1836661 | item-insert | world | -310 | 60 | -93 | {"amt":45 "slot":13, } |
  115. | 2015-01-12 21:12:38 | 1836774 | item-insert | world | -311 | 60 | -97 | {"amt":45 "slot":-1, } |
  116. | 2015-01-12 21:15:15 | 1836990 | item-insert | world | -308 | 60 | -97 | {"amt":45 "slot":-1, } |
  117. | 2015-01-12 21:42:31 | 1841455 | item-remove | world | -307 | 60 | -95 | {"amt":4 "slot":49, } |
  118. | 2015-01-12 21:42:32 | 1841457 | item-remove | world | -307 | 60 | -95 | {"amt":3 "slot":49, } |
  119. | 2015-01-12 21:42:32 | 1841458 | item-insert | world | -307 | 60 | -95 | {"amt":4 "slot":49, } |
  120. | 2015-01-13 17:17:55 | 1943939 | item-remove | world | -308 | 60 | -97 | {"amt":45 "slot":44, } |
  121. | 2015-01-13 17:18:10 | 1943964 | item-insert | world | -319 | 61 | -89 | {"amt":1 "slot":-1, } |
  122. | 2015-01-13 17:18:12 | 1943974 | item-insert | world | -319 | 61 | -89 | {"amt":1 "slot":0, } |
  123. | 2015-01-13 17:18:12 | 1943976 | item-remove | world | -319 | 61 | -89 | {"amt":1 "slot":0, } |
  124. | 2015-01-13 17:18:12 | 1943977 | item-insert | world | -319 | 61 | -89 | {"amt":1 "slot":0, } |
  125. | 2015-01-13 17:18:12 | 1943978 | item-remove | world | -319 | 61 | -89 | {"amt":1 "slot":0, } |
  126. | 2015-01-13 17:18:12 | 1943979 | item-insert | world | -319 | 61 | -89 | {"amt":1 "slot":0, } |
  127. | 2015-01-13 17:20:02 | 1944166 | item-insert | world | -309 | 60 | -95 | {"amt":1 "slot":2, } |
  128. | 2015-01-13 17:20:02 | 1944167 | item-remove | world | -309 | 60 | -95 | {"amt":1 "slot":2, } |
  129. | 2015-01-13 17:20:02 | 1944168 | item-insert | world | -309 | 60 | -95 | {"amt":1 "slot":2, } |
  130. | 2015-01-13 17:20:15 | 1944215 | item-remove | world | -309 | 60 | -95 | {"amt":1 "slot":2, } |
  131. | 2015-01-13 17:54:52 | 1951249 | item-insert | world | -309 | 60 | -93 | {"amt":40 "slot":-1, } |
  132. | 2015-01-13 18:06:38 | 1957933 | item-remove | world | -309 | 60 | -93 | {"amt":40 "slot":52, } |
  133. | 2015-01-13 18:06:41 | 1957962 | item-insert | world | -309 | 60 | -93 | {"amt":36 "slot":52, } |
  134. | 2015-01-13 18:15:53 | 1961122 | item-insert | world | -283 | 53 | -78 | {"amt":1 "slot":3, } |
  135. | 2015-01-13 18:15:53 | 1961123 | item-insert | world | -283 | 53 | -78 | {"amt":1 "slot":4, } |
  136. | 2015-01-13 18:15:53 | 1961124 | item-insert | world | -283 | 53 | -78 | {"amt":1 "slot":6, } |
  137. | 2015-01-13 18:15:53 | 1961125 | item-insert | world | -283 | 53 | -78 | {"amt":1 "slot":7, } |
  138. | 2015-01-13 20:22:04 | 1987209 | item-remove | world | -307 | 60 | -95 | {"amt":7 "slot":49, } |
  139. | 2015-01-13 20:22:08 | 1987220 | item-remove | world | -310 | 60 | -94 | {"amt":4 "slot":32, } |
  140. +----------------------+---------+-------------+-------+------+----+-----+--------------------------------------------------------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!