Mysql-Tables

Mysql-Table explanations

itemshop_categories

1. picture

  • category_index:

    • int -> Just because
    • unique categorie index / also works as reverse “weight” -> lower = top

  • category_name:

    • String -> Name of category
    • Note: You can add categories to uiitemshop.py -> ITEMSHOP_INFO and translate like: 'categories' : { 'WEAPON' : localeInfo.ITEMSHOP_WEAPON, }

  • category_icon:

    • String -> vnum of item or icon name with type
    • Example: ice.png (root/itemshop/icons) or 71171

  • category_state:

    • Enum -> in this case used as bool
    • Enables category & items

itemshop_items

2. picture

  • vnum
    • Itemvnum
  • count
    • Itemcount
  • price
    • Itemprice
  • discountPercent
    • discount 0 - 100%
  • limitCount
    • Disabled/Unlimited = -1
    • Out of order = 0
    • Count left => 0
  • startTime
    • Time item will be buyable
  • endTime
    • Time item will stop being buyable
  • weight
    • works as reverse “weight” -> lower = top
  • socket
    • For realtime or on wear events just add the number in seconds to socket0 else it will use default value
  • attr
    • No explaination needed

promotion_codes

3. picture

  • index
    • unique index to pair rewards to code
  • promotion_code
    • Code defined for index
    • Note: You can also combine codes
      • Test123 with count 10 and Test123 with count 20 will both count until 0
  • state
    • Enables / Disables code
  • useCount
    • Redeems left

promotion_redeemed

4. picture

  • log-table & “already redeemed” source

promotion_rewards

5. picture

  • code_index
    • unique index from promotion_codes table
  • vnum
    • itemvnum
  • count
    • itemcount