This is a read only copy without any forum functionality of the old Modcraft forum.
If there is anything that you would like to have removed, message me on Discord via Kaev#5208.
Big thanks to Alastor for making this copy!

Menu

Author Topic: [QUESTION:WotlK] removing Item arena rating  (Read 1041 times)

Deuzz

  • Registred Member
  • GM Isle Explorer
  • *****
  • Posts: 21
    • View Profile
[QUESTION:WotlK] removing Item arena rating
« 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
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

Valkryst

  • Moderators
  • Model Change Addict
  • *****
  • Posts: 224
    • View Profile
    • http://valkryst.com/blog/
Re: [QUESTION:WotlK] removing Item arena rating
« Reply #1 on: August 24, 2015, 08:43:24 pm »
Which core and game version are you running?

I've taken a look at the documentation for the 3.3.5a database of TrinityCore, but there doesn't seem to be a mention of an arena rating.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
MY BLOG IS NOW HERE.

Amaroth

  • Contributors
  • Creator of Worlds
  • *****
  • Posts: 1219
    • View Profile
    • Amaroth's Tools
Re: [QUESTION:WotlK] removing Item arena rating
« Reply #2 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.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
English YT tutorial channel. Check it out if you preffer videos over walls of text.:
https://www.youtube.com/AmarothEng

Want to support me for my releases and/or tutorials? You can send donation via Paypal to:
jantoms@seznam.cz

Deuzz

  • Registred Member
  • GM Isle Explorer
  • *****
  • Posts: 21
    • View Profile
Re: [QUESTION:WotlK] removing Item arena rating
« Reply #3 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..
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

Valkryst

  • Moderators
  • Model Change Addict
  • *****
  • Posts: 224
    • View Profile
    • http://valkryst.com/blog/
Re: [QUESTION:WotlK] removing Item arena rating
« Reply #4 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;
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
MY BLOG IS NOW HERE.

Amaroth

  • Contributors
  • Creator of Worlds
  • *****
  • Posts: 1219
    • View Profile
    • Amaroth's Tools
Re: [QUESTION:WotlK] removing Item arena rating
« Reply #5 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.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
English YT tutorial channel. Check it out if you preffer videos over walls of text.:
https://www.youtube.com/AmarothEng

Want to support me for my releases and/or tutorials? You can send donation via Paypal to:
jantoms@seznam.cz

Deuzz

  • Registred Member
  • GM Isle Explorer
  • *****
  • Posts: 21
    • View Profile
Re: [QUESTION:WotlK] removing Item arena rating
« Reply #6 on: August 26, 2015, 01:45:42 am »
Well, thanks for your answers
Problem solved ^-^
« Last Edit: January 01, 1970, 01:00:00 am by Admin »