PDA

View Full Version : Need some help...=(



kandi
12-08-10, 01:30 AM
OK, so I have been wondering about having items that you get from vendors that do not take money but that take items instead...such as the tier gear that you use tokens to get...I was wondering how to do this, if anyone has a template that i could look at that would be great.

Another thing i need help with was the whole custom weapons not working with spells such as sinister strike and stuff... I know it has something to do with me making an MPQ file i just dont know what to put into it, so if anyone could give me a template for that.

next thing, how would i go about making items as a currency and not an actual item such as emblem of valor but if i made, for example, "donate coin" and wanted that to be stored in the currency tab in your character screen rather than your bags as an item.

OK, last thing i promise lol. is there any easy way to change all of the weapons and armor that are already in the DB like say 20x normal or do i have to change them all 1 by 1?

Thank you to anyone that helps me with any of this and i promise that i will +rep everyone that helps

Dimman
12-08-10, 04:33 AM
For mangos:

UPDATE `npc_vendor` SET `ExtendedCost` = COSTID WHERE `Item` = ITEMID;This query will make the item cost the currency you want .

Heres a few extended ids

################################
########Badge of justice########
################################

2329 Badge of Justice 150
2330 Badge of Justice 125
2331 Badge of Justice 105
2333 Badge of Justice 100
2049 Badge of Justice 75
2059 Badge of Justice 60
1040 Badge of Justice 50
2332 Badge of Justice 45
1027 Badge of Justice 41
2347 Badge of Justice 40
2060 Badge of Justice 35
1037 Badge of Justice 33
1454 Badge of Justice 30
1015 Badge of Justice 25
1452 Badge of Justice 20
1642 Badge of Justice 15
1909 Badge of Justice 10

#######################
########Glowcap########
#######################

1077 Glowcap 45
388 Glowcap 30
103 Glowcap 25
1076 Glowcap 20
104 Glowcap 15
1994 Glowcap 10
102 Glowcap 2
100 Glowcap 1

##############################################
########Eye of the Storm Mark of Honor########
##############################################

1911 Eye of the Storm Mark of Honor 40
2238 Eye of the Storm Mark of Honor 20
2241 Eye of the Storm Mark of Honor 10
1652 Eye of the Storm Mark of Honor 2

###########################################
########Warsong Gulch Mark of Honor########
###########################################

1442 Warsong Gulch Mark of Honor 60
748 Warsong Gulch Mark of Honor 40
747 Warsong Gulch Mark of Honor 30
822 Warsong Gulch Mark of Honor 20
823 Warsong Gulch Mark of Honor 10
1653 Warsong Gulch Mark of Honor 2

##########################################
########Arathi Basin Mark of Honor########
##########################################

1000 Arathi Basin Mark of Honor 60
172 Arathi Basin Mark of Honor 40
463 Arathi Basin Mark of Honor 30
205 Arathi Basin Mark of Honor 20
986 Arathi Basin Mark of Honor 10
1007 Arathi Basin Mark of Honor 3
165 Arathi Basin Mark of Honor 2

##################################
########Halaa Battle Token########
##################################

1646 Halaa Battle Token 100
1647 Halaa Battle Token 70
5 Halaa Battle Token 40
6 Halaa Battle Token 20

############################
########Apexis Shard########
############################

1979 Apexis Shard 160
2272 Apexis Shard 50
1973 Apexis Shard 40
1910 Apexis Shard 35
1958 Apexis Shard 10
1948 Apexis Shard 3
1949 Apexis Shard 2

###############################
########Burning Blossom########
###############################

2353 Burning Blossom 350
2352 Burning Blossom 200
2351 Burning Blossom 100
2350 Burning Blossom 20
2349 Burning Blossom 5
2348 Burning Blossom 2


NoobLillecarl

Avidgamer
12-08-10, 06:59 AM
If you want to have a custom "coin" type thing, you edit one of the ones Fatcow has supplied you with. Just change the name to "Donation Coin" or something and add the extended item cost to your DB. For your items, I believe there is a way to say, edit ALL "Attack Power" tables etc. Not 100% sure though.

kandi
12-08-10, 09:22 AM
Awesome thanks, also what would i do to make the sword or whatever cost like 2 or 3 of a lesser sword...kind of like an upgrade or something?

Also, how would i go about finding those extended id items in the DB?

Avidgamer
14-08-10, 05:52 PM
Theres an extremely big Extended ID item list on ******* or ac-web I believe (Chances are for some sad reason those two names will be blocked out so PM me and I'll find it)

LiLLeCarl
16-08-10, 05:43 PM
Fatcow forgot to give credits to me for the list he posted there :P because i made it to him :P

kandi
16-08-10, 09:59 PM
Oh, well thank you =) all of this helped a lot

kandi
19-08-10, 06:38 PM
OK, one more question, how would I go about making custom extended prices, like not simply changing item names and such but actually adding to the list. IDK if its a .DBC file or a simple sql query so if anyone knows about where the item extend stuff is lemme know please

<3 Kandi

Avidgamer
20-08-10, 06:37 AM
It'll be in the database. Just have a look at the items, create a new item you wish to be your "token". On the items you want that token to be the price, insert this code:



UPDATE `npc_vendor` SET `ExtendedCost` = COSTID WHERE `Item` = ITEMID;Edit the "COSTID" to your created Token. Edit the "ITEMID" to the Item ID you want the token to be the price for.

Side note, that SQL query is Mangos.

kandi
20-08-10, 11:53 AM
OK, thanks, and yeah I noticed the structure lol mangos is all that i use. Also, I found out that I can make custom costid's in the dbc file Itemextendedcost.dbc so I can just create new lines in that file and make a patch later.

thanks,
Kandi