PDA

View Full Version : [Share]How to make a new currency and add it into your DB



enegue
12-10-09, 11:24 PM
.:Introduction:.



Welcome, I hope you will understand how to make a new currency better after you read this Guide.
Happy Learning!


You know what item you want?
Good, if not, I did just modify the 20515 (Abyssal Scepter) so it Binds on Pickup and made that one my Currency.


Follow This Guide Down Under.


.:Step I:.


Download BOTH CSVed and DBCutil if you do not have them already.
Links at the bottom.
Find the DBC you want.
In this case we want "ItemExtendedCost.dbc"


http://i158.photobucket.com/albums/t89/warwenw/1.jpg


.:Step II:.


Convert the ItemExtendedCost.dbc with DBCutil.
Just Drag and Drop.
Open ItemExtendedCost.dbc.CSV with CSVed.


http://i158.photobucket.com/albums/t89/warwenw/2.jpg


http://i158.photobucket.com/albums/t89/warwenw/3.jpg


.:Step III:.


Press "Edit" and then "Add Record ..."
Fill it in as the template I did show you before.
TIP: Currency ID should be over 3000!
Press "Apply Changes" and then "Ready"


http://i158.photobucket.com/albums/t89/warwenw/4.jpg


http://i158.photobucket.com/albums/t89/warwenw/5.jpg


http://i158.photobucket.com/albums/t89/warwenw/6.jpg


.:Step IV:.


Save the File.
Convert back to DBC.
Put it back into your DBC folder.
Go into your DB and add / edit what/wich items will use your Currency.


http://i158.photobucket.com/albums/t89/warwenw/7.jpg


http://i158.photobucket.com/albums/t89/warwenw/1.jpg


http://i158.photobucket.com/albums/t89/warwenw/8.jpg


.:Step V:.


Want to make it a .SQL file?
Think it will go Faster with a .SQL file?
Heres the .SQL template!


insert into `items_extendedcost`(`ItemId`,`CostId`) values (ITEM ID,CURRENCY ID),(ITEM ID,CURRENCY ID),


Dont forget the "," between every ")" and "("


This will make "ITEM" cost - if you did exactly as I did - 50 Abyssal Scepters.
It will not be visible in the shop as Scepters.
So my tip is either name the vendor or make a GameObject to say.
"All Items in this Vendor costs äx number' of 'x item' "


Download Links


Download CSVed 1.4.5 - An easy and powerful CSV file editor, you can manipulate any CSV file, separated with any separator - Softpedia (http://www.softpedia.com/get/System/File-Management/CSVed.shtml)


Files » Programs » DBC » Dbcutil (http://wowdev.org/files/index.php?act=view&id=15)



Credits
Warwenw of *******
Re-post by Jebus of *******

Disclaimer
I take no credit for this guide. Any +rep to me will be considered a bonus.

Lbniese
13-10-09, 02:59 AM
Very nice, i am also gonna rep+ for this, When i can.

enegue
13-10-09, 03:35 AM
Thanks a lot, Lbniese.