Ornamentions

[demonstar55]

Heroic Armor (armor ornamentation) is RoF+ only.

[Bandor]

upon running the SQL code I ran into a couple errors. First one kept saying column type 6 is nonexistant so I removed this code and it passed through

UPDATE items SET augslot6type = (augslot6type + 2) WHERE augslot6type = 20 OR augslot6type = 21;

Then when I get down to the bottom of the code it says error in my SQL synthax

) AND (
itemtype < 6 OR
itemtype = 8 OR
itemtype = 10 OR
itemtype = 35 OR
itemtype = 45
)
AND augslot5type = 0 AND itemclass = 0;

Upon logging into my server I can see what it did,switching all container ornaments to augs instead of containers and setting special ornaments with there own slot (21). It also removed slot 20 off my weapons and changed them to slot 22. So now would I simply edit my items and decide which get slot 20 and 21?

PS slot 21 is actually labeled special ornaments but it changed them from weapon augs to armor augs lol.

[trevius]

From the SQL errors you are getting, it means you are not on the latest source updates. I just implemented the 6th aug slot for RoF+ a couple of days ago, so if you wanted to use it (for RoF+ only), you would need to update your source and your database (via automatic DB update script when you start the server after source update).

Again, the SQL in my previous post was designed for my server, Storm Haven. In our case, we have augs using slot 20 and 21 that are not ornaments, so I had to move them to another slot. That may not be required in your own database.

There is actually some more SQL that would be needed for your inventory table if you already have some ornaments applied to some items so it can move them from aug slot 5 to aug slot 6. Most servers probably would not have any, though.

Currently, we only have support for 1 ornamentation aug slot (per the rule for it). We will need to implement a new rule to override the current one that would allow both slot 20 and 21 to be considered ornamentation slots. I may get this added fairly soon if I get time. Basically, for now, all you can do is set both Armor and Weapon Ornamentations to use the same aug type (20 by default I think). On Live, I believe type 20 is for Weapons and 21 is for Armor, but I haven't really looked too deep into it yet. There may be other criteria as to why some are special and some are not.

You should already have a lot of functional weapon Ornamentations in your database if you ran the SQL I posted previously. Though, not all items with "Ornamentation" in the name will actually work because some are old and are missing the idfile data that tells the server which weapon model to use for them. For those, I am going to look into matching up weapon models with item icons and see if we can get some SQL together to automatically set the weapon models based on icon number for ornaments.

Even after all of this, the only way to have Hero's Forge Armor Model Ornamentations is to manually add them yourself. You can test them by simply setting the heroforgemodel field to something like 63 on one of your weapon Ornamentations, and then setting the slots field to 923268, which will allow it to be used in all worn slots (so you can have a full set of the same armor model by using the same Ornamentation aug if it is not lore).

[Bandor]

So I updated my source recently and can now use weapon augs though only on UF. Augs appear to be completely broke on my side for RoF2 for some reason. Everytime I put a aug anywhere off my cursor I get Warning Invalid slot move from slot 30 to slot 31 with 0 charges. And if I aug a item it just instead duplicates the item im trying to aug and items go missing etc its a mess lol. So in essence no idea how to test if my aug to give hero forge appearance works giving as I can not currently use augs in RoF2 lol.