Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Miscellaneous => Topic started by: Deuzz on August 24, 2015, 08:27:10 pm

Title: [QUESTION:WotlK] removing Item arena rating
Post by: Deuzz on August 24, 2015, 08:27:10 pm

Hey,
I've a question: How do I remove the personal/team arena rating from items?

Thanks for the answers.
Kind regards

Title: Re: [QUESTION:WotlK] removing Item arena rating
Post by: Valkryst on August 24, 2015, 08:43:24 pm

Which core and game version are you running?

I've taken a look at the documentation (http://collab.kpsn.org/display/tc/item_template) for the 3.3.5a database of TrinityCore, but there doesn't seem to be a mention of an arena rating.

Title: Re: [QUESTION:WotlK] removing Item arena rating
Post by: Amaroth on August 25, 2015, 12:35:50 am

Wasn't it just a part of extended cost? It is refered in npc_vendor in world database.

ItemExtendedCost.dbc. I am not sure if it really is even handled in DB.

Title: Re: [QUESTION:WotlK] removing Item arena rating
Post by: Deuzz on August 25, 2015, 03:11:32 pm

I have the TDB 335.11.47 for patch 3.3.5a :/
But it should be possible somehow..

Title: Re: [QUESTION:WotlK] removing Item arena rating
Post by: Valkryst on August 25, 2015, 08:37:20 pm

Quote from: "Amaroth"

Wasn't it just a part of extended cost? It is refered in npc_vendor in world database.

ItemExtendedCost.dbc. I am not sure if it really is even handled in DB.

Oh, yeah. If he's referring to the initial purchase price of the item, then it could definitely be the ExtendedCost field.

If you can figure out the ExtendedCost ID for the Arena Points, then run the following query, but make sure to substitute 90000 with the ID of the ExtendedCost of the Arena Points.

Code: [Select]

UPDATE `npc_vendor` SET `ExtendedCost` = 0 WHERE `ExtendedCost` = 90000;


Title: Re: [QUESTION:WotlK] removing Item arena rating
Post by: Amaroth on August 25, 2015, 10:21:34 pm

What had Valkryst suggested will also remove arena points from prize and make items free for sale (costing only gold if they have buy prize set, likely they don't).

I suppose you don't know what extended costs are for and/or how they work. Once again:

NPC vendors have items in their vendor list assigned in world.npc_vendor table
That table contains column extended cost. It can be set either in DB or ingame by optional arguments in .npc add item command. Extended costs are in ItemExtendedCost.dbc

If you still don't know what the hell to do with information I gave you, use google for finding more information about npc_vendor and ItemExtendedCost.dbc and read getting starded tutorials.

Title: Re: [QUESTION:WotlK] removing Item arena rating
Post by: Deuzz on August 26, 2015, 01:45:42 am

Well, thanks for your answers
Problem solved ^-^