Avatarattachments
From OpenSimulator
(Difference between revisions)
| Line 26: | Line 26: | ||
'''Attachpoint''' | '''Attachpoint''' | ||
<br> | <br> | ||
| − | The point of the avatar to which the item is attached | + | The point of the avatar to which the item is attached decoded as: |
| + | <br> | ||
| + | <table> | ||
| + | <tr><td>Value<br></td><td> </td><td>Attachment Point</td></tr> | ||
| + | <tr><td>1</td><td> </td><td>Chest</td></tr> | ||
| + | <tr><td>2</td><td> </td><td>Head</td></tr> | ||
| + | <tr><td>3</td><td> </td><td>Left Shoulder</td></tr> | ||
| + | <tr><td>4</td><td> </td><td>Right Shoulder</td></tr> | ||
| + | <tr><td>5</td><td> </td><td>Left Hand</td></tr> | ||
| + | <tr><td>6</td><td> </td><td>Right Hand</td></tr> | ||
| + | <tr><td>7</td><td> </td><td>Left Foot</td></tr> | ||
| + | <tr><td>8</td><td> </td><td>Right Foot</td></tr> | ||
| + | <tr><td>9</td><td> </td><td>Back</td></tr> | ||
| + | <tr><td>10</td><td> </td><td>Pelvis</td></tr> | ||
| + | <tr><td>11</td><td> </td><td>Mouth</td></tr> | ||
| + | <tr><td>12</td><td> </td><td>Chin</td></tr> | ||
| + | <tr><td>13</td><td> </td><td>Left Ear</td></tr> | ||
| + | <tr><td>14</td><td> </td><td>Right Ear</td></tr> | ||
| + | <tr><td>15</td><td> </td><td>Left Eye</td></tr> | ||
| + | <tr><td>16</td><td> </td><td>Right Eye</td></tr> | ||
| + | <tr><td>17</td><td> </td><td>Nose</td></tr> | ||
| + | <tr><td>18</td><td> </td><td>Right Upper Arm</td></tr> | ||
| + | <tr><td>19</td><td> </td><td>Right Forearm</td></tr> | ||
| + | <tr><td>20</td><td> </td><td>Left Upper Arm</td></tr> | ||
| + | <tr><td>21</td><td> </td><td>Left Forearm</td></tr> | ||
| + | <tr><td>22</td><td> </td><td>Right Hip</td></tr> | ||
| + | <tr><td>23</td><td> </td><td>Right Upper Leg</td></tr> | ||
| + | <tr><td>24</td><td> </td><td>Right Lower Leg</td></tr> | ||
| + | <tr><td>25</td><td> </td><td>Left Hip</td></tr> | ||
| + | <tr><td>26</td><td> </td><td>Left Upper Leg</td></tr> | ||
| + | <tr><td>27</td><td> </td><td>Left Lower Leg</td></tr> | ||
| + | <tr><td>28</td><td> </td><td>Stomach</td></tr> | ||
| + | <tr><td>29</td><td> </td><td>Right Pectoral</td></tr> | ||
| + | <tr><td>30</td><td> </td><td>Left Pectoral</td></tr> | ||
| + | <tr><td>31</td><td> </td><td>HUD Centre 2</td></tr> | ||
| + | <tr><td>32</td><td> </td><td>HUD Top Right</td></tr> | ||
| + | <tr><td>33</td><td> </td><td>HUD Top </td></tr> | ||
| + | <tr><td>34</td><td> </td><td>HUD Top Left</td></tr> | ||
| + | <tr><td>35</td><td> </td><td>HUD Centre</td></tr> | ||
| + | <tr><td>36</td><td> </td><td>HUD Bottom Right</td></tr> | ||
| + | <tr><td>37</td><td> </td><td>HUD Bottom</td></tr> | ||
| + | <tr><td>38</td><td> </td><td>HUD Bottom Left</td></tr> | ||
| + | </table> | ||
<br> | <br> | ||
<br> | <br> | ||
Revision as of 23:23, 17 July 2009
avatarattachments Records details of items attached to avatars (back to Database Documentation)
The current structure of the avatarattachments table is as follows:
| Field | Type | Null | Key | Default | Extra | |
| UUID | char(36) | NO | NULL | |||
| attachpoint | integer | NULL | ||||
| item | char(36) | NO | NULL | |||
| asset | char(36) | NO | NULL | |||
(back to Database Documentation)
UUID
The UUID of the user holding the attachment. As a user can attach several items to different points and each attached item creates a new row in the table this is not a unique key.
Attachpoint
The point of the avatar to which the item is attached decoded as:
| Value | Attachment Point | |
| 1 | Chest | |
| 2 | Head | |
| 3 | Left Shoulder | |
| 4 | Right Shoulder | |
| 5 | Left Hand | |
| 6 | Right Hand | |
| 7 | Left Foot | |
| 8 | Right Foot | |
| 9 | Back | |
| 10 | Pelvis | |
| 11 | Mouth | |
| 12 | Chin | |
| 13 | Left Ear | |
| 14 | Right Ear | |
| 15 | Left Eye | |
| 16 | Right Eye | |
| 17 | Nose | |
| 18 | Right Upper Arm | |
| 19 | Right Forearm | |
| 20 | Left Upper Arm | |
| 21 | Left Forearm | |
| 22 | Right Hip | |
| 23 | Right Upper Leg | |
| 24 | Right Lower Leg | |
| 25 | Left Hip | |
| 26 | Left Upper Leg | |
| 27 | Left Lower Leg | |
| 28 | Stomach | |
| 29 | Right Pectoral | |
| 30 | Left Pectoral | |
| 31 | HUD Centre 2 | |
| 32 | HUD Top Right | |
| 33 | HUD Top | |
| 34 | HUD Top Left | |
| 35 | HUD Centre | |
| 36 | HUD Bottom Right | |
| 37 | HUD Bottom | |
| 38 | HUD Bottom Left |
Item
The UUID of the inventory item attached.
Asset
The UUID of the asset referenced by the "item".
(back to Database Documentation)