[SOLVED] Create item lootable that give Currency

[blackmetal]

As the title, i'm stucking at this. Example i want A bag have loot Dalaran Cooking Award ( Currency 81 ) . How i can do this? Thanks!
TrinityCore 4.3.4

 

[Barebones]

How many Dalaran Cooking awards do you want it to have?

 

[blackmetal]

Thanks for fast reply
I want it has 5 Dalaran Cooking Award as currency, not item

 

[Barebones]

Well, it's already a currency. You can make a bag that gives you 5x of them 100% of the time. Is that what you'd like?

 

[blackmetal]

Well, i don't know how to give currency into Item loot!
If i'm using http://www.wowhead.com/item=43016/dalaran-cooking-award
After open, it go to inventory as item, not currency And i can't use that to purchase anything in Cooking vendor

 

[Barebones]

Try using .additem 43016 100

Anyway, this what you do.

Go to item_loot_template in the DB and create a new row. Set the entry to 500000, set the item to 4306, set the chance to 100, set loot mode to 1, and set the mind and the max count to 5.

Now go into item_template in the DB. Find the item with the entry Id of 44113. Copy it. Change the entry Id to 500000. Change the name of the item.

There ya go.

 

[blackmetal]

Did that several times.... Problem here is can't using item 43016 to purchase anything from Cooking Vendor!
Because It is in bag, not in tab currency

 

[Barebones]

Go into item_template in your DB and delete the item with the entry 43016.

Now, copy this and run it in your query:

INSERT INTO `item_template` VALUES (43016, 10, 0, -1, 'Dalaran Cooking Award', 32746, 2, 0, 0, 1, 0, 0, 0, 262143, 32767, 70, 29, 0, 0, 0, 0, 0, 0, 0, 2147483647, 2147483647, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, 'Redeem at the Dalaran Cooking Supplier.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340);

 

[blackmetal]

Column count doesn't match value count at row 1
Can you use Truice to create this item. Thanks for helping me

 

[Barebones]

0.o What patch are you using?

What revision is your core? I'm using:

TrinityCore rev. 6402fa02ac4a+ 2013-12-23 01:31:30 -0330 (master branch) (Win32, Release)

for 3.3.5a

 

[blackmetal]

Sorry man, i'm using 4.3.4 Core

 

[Barebones]

\facepalm My bad

 

[blackmetal]

Sr, it is my bad when i'm not telling you i'm using 4.3.4

 

[Barebones]

I should have asked. If you can, add a currency vendor that has all the currency in it. Then add each currency until you find one that goes into your currency tab. Then go into your database and find that item. Make a copy of it. Change the entry Id of the copied item to 43016. Change the name of the item. And there you go.

Make sure you have deleted the original 43016. Keep a back up just in case.

 

[blackmetal]

I can't. This is cataclysm, not WOTLK
So currency is not item in Cataclysm and i have no way to add it in vendor >.<

 

[Barebones]

When I get home I will download a repack so I can look at the db

 

[blackmetal]

Woaaa. Many thanks

 

[Barebones]

What core? Trinity right?

 

[Barebones]

[MENTION=713]blackmetal[/MENTION] Try this:

INSERT INTO `item_template` VALUES (43016, 10, 0, -1, 'Dalaran Cooking Reward', 32746, 2, 2048, 8192, 0.9661, 1, 1, 0, 0, 0, 262143, -1, 80, 80, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 1, 'Redeem at the Dalaran Cooking Supplier.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15595);

 

[Tommy]

You want a bag to have loot? That's not difficult at all, and it shouldn't have taken 2 pages to answer it.

If you're creating a new bag, set the column values (in item_template) to:

Class: 1 -- Container
Subclass: 0 -- 1 | 0 = Bag
Flags: 4 -- Can be opened

As for the loot, you can look at this page: http://collab.kpsn.org/display/tc/Loot+template+tc2 for help.

Entry = Loot entry
Item = Item entry
ChanceOrQuestChance = Chance for the item to be added to the loot (100 = will be lootable all the time)
lootmode = Leave it at 0
groupid = Leave it at 0
mincountOrRef = Minimum count of how many items that will be looted
maxcount = Maximum count of how many items will be looted (Must be higher than minCount)