Database issue !! :D

[Air53]

I have making this crazy good database yum it looks good people. But any who, ran into a simple error i can't figure out.

look - trying to change the extended loot cost of s1,2,3,4 into gold but i looked into the extended cost table and even the loot section for these items and there just not there :/ and there in game ?!??!!

If you help i love you very much
pulse how would i find the database entry's for those items.

[singoe]

im pretty sure there is no extended cost that is gold

[kreegoth]

Find the ID for the Season gear on WOWhead or Thottbot and then Run this query in your DB

SELECT * FROM `items` WHERE `entry`=(ITEM#FROMWEBSITE)


Itll show you the result for that item.. In that screen edit the buyprice to how much gold you want..

Now you need to find the ID of the VENDOR that sells it and enter this Query

SELECT * FROM `Vendors` WHERE `Entry`= (VENDORID)

The last column in the table that comes up is Extendeditemcost.. erase the value there for the items and its now sold for just gold.

unless you have an older database and then you have a TABLE called extendedcost and in there youd find the itemID on the left and erase the value for the extended cost..