Thread: Ornamentions
View Single Post
  #29  
Old 03-16-2019, 11:27 PM
belvino
Fire Beetle
 
Join Date: Feb 2019
Location: MS
Posts: 25
Default

SO i used part of Trevius's post to change all the armor to type 20 ornament in the slot 6 aug slot.

Code:
/* Update all Armor and Weapons to have Aug Slot 6 for Ornamentations
This only updates items that have:
Any material slot set
At least 1 Aug Slot already Defined (prevent adding from newbie/old items)
Weapon or Armor item types
Nothing already set for Aug Slot 6
Item Class 0 */
UPDATE items
SET augslot5type = 20, augslot5visible = 1, augslot5unk2 = 1
WHERE (
slots & 4 OR
slots & 128 OR
slots & 1536 OR
slots & 4096 OR
slots & 131072 OR
slots & 262144 OR
slots & 524288 OR
slots & 2048 OR
slots & 8192 OR
slots & 16384
) AND (
augslot1type > 0 OR
augslot2type > 0 OR
augslot3type > 0 OR
augslot4type > 0 OR
) AND (
itemtype < 6 OR
itemtype = 8 OR
itemtype = 10 OR
itemtype = 35 OR
itemtype = 45
)
AND augslot5type = 0 AND itemclass = 0;
Then i changed some of the ornaments that were there by making them slot 20 and adding a hero model id. The ornaments worked before when i changed the rule in the Db to use 21 as ornament slot. This was my attempt to get both working.

When i try to equip an ornament it says not valid slot. I also tried creating a new aug ornament from scratch and get the same error.

Is there somethign else you have to change to get the ornament to go in a type 20 slot. It almost acting like it still thinks its a type 21 aug
Reply With Quote