Jump to content

View table: EquipmentStats

Table structure:

  1. item_id - Integer (mandatory; unique)
  2. item_name - String
  3. slot - String
  4. combat_style - String
  5. attack - Integer
  6. strength - Integer
  7. defence - Integer
  8. ranged - Integer
  9. magic - Integer
  10. stab_attack - Integer
  11. slash_attack - Integer
  12. crush_attack - Integer
  13. magic_attack - Integer
  14. ranged_attack - Integer
  15. stab_defence - Integer
  16. slash_defence - Integer
  17. crush_defence - Integer
  18. magic_defence - Integer
  19. ranged_defence - Integer
  20. strength_bonus - Integer
  21. ranged_strength - Integer
  22. magic_damage - String
  23. attack_speed - Float
  24. attack_range - String
  25. requirements - Text
  26. bonuses - Text
  27. source - String
  28. verification_status - String
  29. evidence - Text

This table has 55 rows altogether.

This table is defined by the template EquipmentStats.

Recreate data.

Page item id item name slot combat style attack strength defence ranged magic stab attack slash attack crush attack magic attack ranged attack stab defence slash defence crush defence magic defence ranged defence strength bonus ranged strength magic damage attack speed attack range requirements bonuses source verification status evidence
Bow (edit) 45 Bow twohand ranged 8 4.0 7 weaponClass: bow, rangedType: standard (client keys) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bow-client-data-2026-07-05
Bronze 2hd Sword (edit) 36 Bronze 2hd Sword twohand melee -4 9 8 10 7.0 1 weaponClass: 2h_sword (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-2hd-sword-client-data-2026-07-05
Bronze Axe (edit) 4 Bronze Axe mainhand melee -2 4 2 5 5.0 1 weaponClass: axe (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-axe-client-data-2026-07-05
Bronze Boots (edit) 67 Bronze Boots feet 1 1 2 0 0 Client data lists ranged defence in three substyles — light 0, standard 0, heavy 0; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-boots-client-data-2026-07-05
Bronze Chestplate (edit) 64 Bronze Chestplate chest 11 10 6 -4 10 Client data lists ranged defence in three substyles — light 10, standard 10, heavy 10; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-chestplate-client-data-2026-07-05
Bronze Gauntlets (edit) 65 Bronze Gauntlets hands 2 2 2 1 1 1 1 1 2 Client data lists ranged defence in three substyles — light 1, standard 1, heavy 1; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-gauntlets-client-data-2026-07-05
Bronze Helmet (edit) 63 Bronze Helmet head 3 4 2 -1 3 Client data lists ranged defence in three substyles — light 3, standard 3, heavy 3; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-helmet-client-data-2026-07-05
Bronze Katana (edit) 39 Bronze Katana mainhand melee 5 7 -2 6 4.0 1 weaponClass: katana (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-katana-client-data-2026-07-05
Bronze Kiteshield (edit) 30 Bronze Kiteshield offhand 4 5 4 -1 4 Client data lists ranged defence in three substyles — light 4, standard 4, heavy 4; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-kiteshield-client-data-2026-07-05
Bronze Leggings (edit) 66 Bronze Leggings legs 6 5 4 -3 5 Client data lists ranged defence in three substyles — light 5, standard 5, heavy 5; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-leggings-client-data-2026-07-05
Bronze Pickaxe (edit) 15 Bronze Pickaxe mainhand melee 4 -2 2 5 5.0 1 weaponClass: pickaxe (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-pickaxe-client-data-2026-07-05
Bronze Shield (edit) 33 Bronze Shield offhand 2 3 2 -1 2 Client data lists ranged defence in three substyles — light 2, standard 2, heavy 2; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-shield-client-data-2026-07-05
Bronze Short Sword (edit) 12 Bronze Short Sword mainhand melee 4 3 -2 5 4.0 1 weaponClass: sword (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate bronze-short-sword-client-data-2026-07-05
Cherry Bow (edit) 47 Cherry Bow twohand ranged 20 4.0 7 weaponClass: bow, rangedType: standard (client keys) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate cherry-bow-client-data-2026-07-05
Glacial Bow (edit) 48 Glacial Bow twohand ranged 29 4.0 7 Archery 25 (gameplay-verified July 2026; equip gates are server-enforced and not present in client data) weaponClass: bow, rangedType: standard (client keys) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate glacial-bow-client-data-2026-07-05
Iron 2hd Sword (edit) 37 Iron 2hd Sword twohand melee -4 13 10 14 7.0 1 weaponClass: 2h_sword (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-2hd-sword-client-data-2026-07-05
Iron Axe (edit) 5 Iron Axe mainhand melee -2 5 3 7 5.0 1 weaponClass: axe (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-axe-client-data-2026-07-05
Iron Boots (edit) 72 Iron Boots feet 1 2 3 0 0 Client data lists ranged defence in three substyles — light 0, standard 0, heavy 0; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-boots-client-data-2026-07-05
Iron Chestplate (edit) 69 Iron Chestplate chest 15 14 9 -4 14 Client data lists ranged defence in three substyles — light 14, standard 14, heavy 14; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-chestplate-client-data-2026-07-05
Iron Gauntlets (edit) 70 Iron Gauntlets hands 3 3 3 2 2 2 1 2 3 Client data lists ranged defence in three substyles — light 2, standard 2, heavy 2; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-gauntlets-client-data-2026-07-05
Iron Helmet (edit) 68 Iron Helmet head 4 5 4 -1 4 Client data lists ranged defence in three substyles — light 4, standard 4, heavy 4; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-helmet-client-data-2026-07-05
Iron Katana (edit) 40 Iron Katana mainhand melee 6 10 -2 9 4.0 1 weaponClass: katana (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-katana-client-data-2026-07-05
Iron Kiteshield (edit) 31 Iron Kiteshield offhand 6 7 6 -1 6 Client data lists ranged defence in three substyles — light 6, standard 6, heavy 6; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-kiteshield-client-data-2026-07-05
Iron Leggings (edit) 71 Iron Leggings legs 8 7 7 -3 7 Client data lists ranged defence in three substyles — light 7, standard 7, heavy 7; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-leggings-client-data-2026-07-05
Iron Pickaxe (edit) 16 Iron Pickaxe mainhand melee 5 -2 3 7 5.0 1 weaponClass: pickaxe (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-pickaxe-client-data-2026-07-05
Iron Shield (edit) 34 Iron Shield offhand 3 4 4 -1 4 Client data lists ranged defence in three substyles — light 4, standard 4, heavy 4; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-shield-client-data-2026-07-05
Iron Short Sword (edit) 13 Iron Short Sword mainhand melee 6 5 -2 7 4.0 1 weaponClass: sword (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate iron-short-sword-client-data-2026-07-05
Mystic Hat (edit) 97 Mystic Hat head Magic 2 2 +1 Verbatim client keys, in entry order: magicAttack +2, magicStrength +1, magicDefense +2. Note: magicStrength is stored in the magic_damage column (nearest template equivalent). Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-mystic-hat: EQUIPMENT_MANIFEST entry "Mystic Hat" in client chunk c12a64812e41c536.js (module 236847); see mystic-hat-client-data-2026-07-05.
Oak Bow (edit) 46 Oak Bow twohand ranged 14 4.0 7 weaponClass: bow, rangedType: standard (client keys) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate oak-bow-client-data-2026-07-05
Ranger Boots (edit) 94 Ranger Boots feet Ranged 1 0 0 0 1 1 Verbatim client keys, in entry order: rangedAttack +1, stabDefense 0, slashDefense 0, crushDefense 0, lightDefense +1, standardDefense +1, heavyDefense +1, magicDefense +1. Note: the equal light/standard/heavy ranged-defence values are stored as a single ranged_defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-ranger-boots: EQUIPMENT_MANIFEST entry "Ranger Boots" in client chunk c12a64812e41c536.js (module 236847); see ranger-boots-client-data-2026-07-05.
Ranger Chestplate (edit) 91 Ranger Chestplate chest Ranged 6 -11 13 10 -7 18 Verbatim client keys, in entry order: rangedAttack +6, stabDefense -11, slashDefense +13, crushDefense +10, lightDefense +18, standardDefense +18, heavyDefense +18, magicDefense -7. Note: the equal light/standard/heavy ranged-defence values are stored as a single ranged_defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-ranger-chestplate: EQUIPMENT_MANIFEST entry "Ranger Chestplate" in client chunk c12a64812e41c536.js (module 236847); see ranger-chestplate-client-data-2026-07-05.
Ranger Gauntlets (edit) 92 Ranger Gauntlets hands Ranged 3 -6 -6 -6 0 0 1 Verbatim client keys, in entry order: rangedAttack +3, rangedStrength +1, stabDefense -6, slashDefense -6, crushDefense -6, lightDefense 0, standardDefense 0, heavyDefense 0, magicDefense 0. Note: the equal light/standard/heavy ranged-defence values are stored as a single ranged_defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-ranger-gauntlets: EQUIPMENT_MANIFEST entry "Ranger Gauntlets" in client chunk c12a64812e41c536.js (module 236847); see ranger-gauntlets-client-data-2026-07-05.
Ranger Helmet (edit) 90 Ranger Helmet head Ranged 2 0 0 0 0 4 Verbatim client keys, in entry order: rangedAttack +2, stabDefense 0, slashDefense 0, crushDefense 0, lightDefense +4, standardDefense +4, heavyDefense +4, magicDefense 0. Note: the equal light/standard/heavy ranged-defence values are stored as a single ranged_defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-ranger-helmet: EQUIPMENT_MANIFEST entry "Ranger Helmet" in client chunk c12a64812e41c536.js (module 236847); see ranger-helmet-client-data-2026-07-05.
Ranger Leggings (edit) 93 Ranger Leggings legs Ranged 2 -7 4 4 -6 6 Verbatim client keys, in entry order: rangedAttack +2, stabDefense -7, slashDefense +4, crushDefense +4, lightDefense +6, standardDefense +6, heavyDefense +6, magicDefense -6. Note: the equal light/standard/heavy ranged-defence values are stored as a single ranged_defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-ranger-leggings: EQUIPMENT_MANIFEST entry "Ranger Leggings" in client chunk c12a64812e41c536.js (module 236847); see ranger-leggings-client-data-2026-07-05.
SankoQuest:Schema seed (edit) 0 Schema placeholder schema-placeholder Schema placeholder row; do not treat as game data.
Shape Robe (edit) 80 Shape Robe chest Magic 10 -3 -3 -3 14 -6 +5 Verbatim client keys, in entry order: magicAttack +10, magicStrength +5, magicDefense +14, stabDefense -3, slashDefense -3, crushDefense -3, lightDefense -6, standardDefense -6, heavyDefense -6. Note: magicStrength is stored in the magic_damage column (nearest template equivalent); the equal light/standard/heavy ranged-defence values are stored as a single ranged_defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-shape-robe: EQUIPMENT_MANIFEST entry "Shape Robe" in client chunk c12a64812e41c536.js (module 236847); see shape-robe-client-data-2026-07-05.
Shape Skirt (edit) 81 Shape Skirt legs Magic 6 -2 -2 -2 11 -4 +3 Verbatim client keys, in entry order: magicAttack +6, magicStrength +3, magicDefense +11, stabDefense -2, slashDefense -2, crushDefense -2, lightDefense -4, standardDefense -4, heavyDefense -4. Note: magicStrength is stored in the magic_damage column (nearest template equivalent); the equal light/standard/heavy ranged-defence values are stored as a single ranged_defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-shape-skirt: EQUIPMENT_MANIFEST entry "Shape Skirt" in client chunk c12a64812e41c536.js (module 236847); see shape-skirt-client-data-2026-07-05.
Shape Wizard Hat (edit) 96 Shape Wizard Hat head Magic 4 3 +2 Verbatim client keys, in entry order: magicAttack +4, magicStrength +2, magicDefense +3. Note: magicStrength is stored in the magic_damage column (nearest template equivalent). Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-shape-wizard-hat: EQUIPMENT_MANIFEST entry "Shape Wizard Hat" in client chunk c12a64812e41c536.js (module 236847); see shape-wizard-hat-client-data-2026-07-05.
Staff (edit) 49 Staff twohand magic 0 -1 7 2 1 2 1 3 3 5.0 7 magicStrength: +2 (client key; magic strength bonus — no dedicated field); weaponClass: staff (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate staff-client-data-2026-07-05
Steel 2hd Sword (edit) 38 Steel 2hd Sword twohand melee -4 21 16 22 7.0 1 weaponClass: 2h_sword (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-2hd-sword-client-data-2026-07-05
Steel Axe (edit) 6 Steel Axe mainhand melee -2 8 6 9 5.0 1 weaponClass: axe (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-axe-client-data-2026-07-05
Steel Boots (edit) 77 Steel Boots feet 4 4 5 0 0 Client data lists ranged defence in three substyles — light 0, standard 0, heavy 0; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-boots-client-data-2026-07-05
Steel Chestplate (edit) 74 Steel Chestplate chest 23 22 17 -4 22 Client data lists ranged defence in three substyles — light 22, standard 22, heavy 22; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-chestplate-client-data-2026-07-05
Steel Gauntlets (edit) 75 Steel Gauntlets hands 4 4 4 3 3 3 1 3 4 Client data lists ranged defence in three substyles — light 3, standard 3, heavy 3; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-gauntlets-client-data-2026-07-05
Steel Helmet (edit) 73 Steel Helmet head 6 7 5 -1 6 Client data lists ranged defence in three substyles — light 6, standard 6, heavy 6; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-helmet-client-data-2026-07-05
Steel Katana (edit) 41 Steel Katana mainhand melee 7 15 -2 14 4.0 1 weaponClass: katana (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-katana-client-data-2026-07-05
Steel Kiteshield (edit) 32 Steel Kiteshield offhand 9 11 10 -1 10 Client data lists ranged defence in three substyles — light 10, standard 10, heavy 10; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-kiteshield-client-data-2026-07-05
Steel Leggings (edit) 76 Steel Leggings legs 12 12 11 -3 12 Client data lists ranged defence in three substyles — light 12, standard 12, heavy 12; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-leggings-client-data-2026-07-05
Steel Pickaxe (edit) 17 Steel Pickaxe mainhand melee 8 -2 6 9 5.0 1 weaponClass: pickaxe (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-pickaxe-client-data-2026-07-05
Steel Shield (edit) 35 Steel Shield offhand 4 6 5 -1 5 Client data lists ranged defence in three substyles — light 5, standard 5, heavy 5; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-shield-client-data-2026-07-05
Steel Short Sword (edit) 14 Steel Short Sword mainhand melee 8 7 -2 9 4.0 1 weaponClass: sword (client key) Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate steel-short-sword-client-data-2026-07-05
Wizard Hat (edit) 95 Wizard Hat head Magic 1 1 Verbatim client keys, in entry order: magicAttack +1, magicDefense +1. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-wizard-hat: EQUIPMENT_MANIFEST entry "Wizard Hat" in client chunk c12a64812e41c536.js (module 236847); see wizard-hat-client-data-2026-07-05.
Wizard Robe (edit) 78 Wizard Robe chest Magic 3 -2 -2 -2 4 -1 +1 Verbatim client keys, in entry order: magicAttack +3, magicStrength +1, magicDefense +4, stabDefense -2, slashDefense -2, crushDefense -2, lightDefense -1, standardDefense -1, heavyDefense -1. Note: magicStrength is stored in the magic_damage column (nearest template equivalent); the equal light/standard/heavy ranged-defence values are stored as a single ranged_defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-wizard-robe: EQUIPMENT_MANIFEST entry "Wizard Robe" in client chunk c12a64812e41c536.js (module 236847); see wizard-robe-client-data-2026-07-05.
Wizard Skirt (edit) 79 Wizard Skirt legs Magic 2 -2 -2 -2 4 -1 +1 Verbatim client keys, in entry order: magicAttack +2, magicStrength +1, magicDefense +4, stabDefense -2, slashDefense -2, crushDefense -2, lightDefense -1, standardDefense -1, heavyDefense -1. Note: magicStrength is stored in the magic_damage column (nearest template equivalent); the equal light/standard/heavy ranged-defence values are stored as a single ranged_defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate Row eqstats-wizard-skirt: EQUIPMENT_MANIFEST entry "Wizard Skirt" in client chunk c12a64812e41c536.js (module 236847); see wizard-skirt-client-data-2026-07-05.
Wooden Shield (edit) 11 Wooden Shield offhand 3 4 2 1 3 Client data lists ranged defence in three substyles — light 3, standard 3, heavy 3; the values are identical and are recorded here as a single ranged defence figure. Client data (sigma.sankoquest.com bundle, 2026-07-05) datamine-candidate wooden-shield-client-data-2026-07-05