Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Anvil Rates - Detailed explanation

Initiate Mage
Joined
May 21, 2007
Messages
81
Reaction score
1
Well I've known about this for a while now and have hoped someone else would have posted how the upgrade table works the right way, but I guess I'm forced to post it myself ;x.

Now first things first, I'll explain what each column does and what it's used for.

nIndex - Index number, not really relevant.

nNPCNum - The number of the NPC, 5001 = Anvil

strName - You can put in the name of the scroll and stuff here, It's mainly for having notes

strNote - Same as above

nOriginType - The item's Type, for example

-1 = Any item that isn't unique
0 = Unique Dagger,
1 = Unique 1 Handed sword
etc.

So lets say we want to set an upgrade rate for a Unique dagger and the items ext. number is in the Item_ext_0 in the tbls then you'd put 0 as the nOriginType .

nOriginItem - This is the extension number, For example a Shard +8 with Elemental damage will be 111210048. Setting the upgrade rate for this you would have the nOriginItem as '48' which is the extension number.

Now gathering the information we have so far, we would set the nOriginType to -1 and the nOriginItem to 48.

One more example for nOriginItem, Lets look at hell breaker +8, the Item ID is 149101228 so the nOriginItem for this item is '228'.

nReqItem1 - The scroll's Item ID, if you want to set a trina rate as well you'd put the trina's ID in the nReqItem1 and the scroll's ID in nReqItem2

nReqNoah - You can put a price for upgrading.

bRateType - This is one I'm not sure of.

nGenRate - The upgrade percentage, 100 = 1%, 1000 = 10%, 10000 = 100%.

nGiveItem - This is the number you want to add to the extension number given. For example, lets say the nOriginItem was 48 and the nGiveItem is 1 then the Item you'll have will be a +9 with elemental thus making the nOriginItem 49. You can also put negative numbers here, Lets say you want to make the item with +8 Elemental damage a normal item (48 origin item) you would put -40 in the nGiveItem, thus making the item a normal +8 item.


That should explain all of it, If you still don't understand it post in this thread and I might be able to explain it further. Please don't PM me regarding this.

Now, the proper way to set Anvil Rates with a quick query -

UPDATE ITEM_UPGRADE SET nGenRate='ratehere'
WHERE nOriginItem like '%1' AND nReqItem1='scrollsIDhere'


Now, to set the upgrade rates for each + number you change the %1 to the number you want. If you want to set +7 - +8 rates the number would be %7.

Example :

UPDATE ITEM_UPGRADE SET nGenRate='7500'
WHERE nOriginItem like '%7' AND nReqItem1='379021000'

That would set the Upgrade rate for +7's to 75% where the Scroll used is a BUS.

Well, I hope that covers everything.

Good luck,

IceMan
 
Last edited by a moderator:
Initiate Mage
Joined
Jan 23, 2008
Messages
49
Reaction score
0
lol urs is quite a bit more detailed than mine, i just gave them a simple query that they can use to set the rates whatever and the elemental scrolls and bonuses they set to 100%, i think this 1 will help them a lil bit more tho.

good job :)
 
Initiate Mage
Joined
Nov 3, 2007
Messages
38
Reaction score
0
it works good for unique to if u put reqitem1 ( compound scroll)
with 2% if u want to remove +3 unique
 
Initiate Mage
Joined
Nov 27, 2007
Messages
32
Reaction score
0
Re: [Share] Anvil Rates - Detailed explanation

Thank-you for this explanation and the SQL statement. I was stumbling on this for the last few days doing it 'trial and error' style...
 
Initiate Mage
Joined
Jun 10, 2006
Messages
78
Reaction score
1
Re: [Share] Anvil Rates - Detailed explanation

So have some1 manage to add something new to anvil? like Weapon of selfname?
If so plz share it!
 
Initiate Mage
Joined
Jun 10, 2006
Messages
78
Reaction score
1
Re: [Share] Anvil Rates - Detailed explanation

I share if i have something ppl ask for, and i help loots of ppl whit servers, just ask around!
 
Experienced Elementalist
Member
Joined
Jun 11, 2006
Messages
214
Reaction score
0
Re: [Share] Anvil Rates - Detailed explanation

ice how i go about adding additional required item to query i keep getting errors when trying to change items needing trina and scroll for upgrade %
 
Initiate Mage
Joined
May 21, 2007
Messages
81
Reaction score
1
Re: [Share] Anvil Rates - Detailed explanation

Would be like this

UPDATE ITEM_UPGRADE SET nGenRate='ratehere'
WHERE nOriginItem like '%1' AND nReqItem1='TrinaIDHere' AND nReqItem2='ScrollIDHere'
 
Experienced Elementalist
Member
Joined
Jun 11, 2006
Messages
214
Reaction score
0
Re: [Share] Anvil Rates - Detailed explanation

thanks man your still good guy no mater what has happen in the past.
 
Initiate Mage
Joined
Jun 10, 2006
Messages
78
Reaction score
1
Re: [Share] Anvil Rates - Detailed explanation

I try to add <selfname> weapons, any clue whats wrong?
I cant upgrade it to +1 or +2

400001 5001 Quest Dagger Blessed Elemental Scroll 0 300 379025000 0 0 0 0 0 0 0 500000 0 10000 1
400002 5001 Quest Dagger(+1) Blessed Upgrade Scroll 0 301 379021000 0 0 0 0 0 0 0 240000 0 10000 1
 
Initiate Mage
Joined
Aug 2, 2008
Messages
7
Reaction score
0
Re: [Share] Anvil Rates - Detailed explanation

bRateType - This is one I'm not sure of.

think that has to do with chance each type of item has chance going at i notice that when compounding certain items have better success while other items of same type has lower.
 
Initiate Mage
Joined
Jun 10, 2006
Messages
78
Reaction score
1
Re: [Share] Anvil Rates - Detailed explanation

Sry for bumping old topic, but just 1 question
How can you upgrade Dark Vane??
In ITEM_UPGRADE Dark Vane have nOriginType = 0
But its in tbl 23 on client side

190060 5001 Dark Vane(+0) Blessed Elemental Scroll 0 101 379025000 0 0 0 0 0 0 0 500000 0 10000 100
180101 5001 Dark Vane(+1) Blessed Upgrade Scroll 0 201 379021000 0 0 0 0 0 0 0 240000 0 10000 1
180102 5001 Dark Vane(+2) Blessed Upgrade Scroll 0 202 379021000 0 0 0 0 0 0 0 240000 0 10000 1
180103 5001 Dark Vane(+3) Blessed Upgrade Scroll 0 203 379021000 0 0 0 0 0 0 0 240000 3 7000 1
180104 5001 Dark Vane(+4) Blessed Upgrade Scroll 0 204 379021000 0 0 0 0 0 0 0 240000 5 7000 1
180105 5001 Dark Vane(+5) Blessed Upgrade Scroll 0 205 379021000 0 0 0 0 0 0 0 240000 8 6000 1
180106 5001 Dark Vane(+6) Blessed Upgrade Scroll 0 206 379021000 0 0 0 0 0 0 0 240000 10 3000 1
180107 5001 Dark Vane(+7) Blessed Upgrade Scroll 0 207 379021000 0 0 0 0 0 0 0 240000 11 500 1
180108 5001 Dark Vane(+8) Blessed Upgrade Scroll 0 208 379021000 0 0 0 0 0 0 0 240000 12 200 1
180109 5001 Dark Vane(+9) Blessed Upgrade Scroll 0 209 379021000 0 0 0 0 0 0 0 240000 13 100 1
180110 5001 Dark Vane(+10) Blessed Upgrade Scroll 0 210 379021000 0 0 0 0 0 0 0 240000 0 0 0
 
Initiate Mage
Joined
Jul 30, 2008
Messages
98
Reaction score
0
Re: [Share] Anvil Rates - Detailed explanation

what we need is a anvil rate prog that lets u set upgrade/elemental/unique rates :D
 
Experienced Elementalist
Joined
Jan 3, 2008
Messages
299
Reaction score
1
Re: [Share] Anvil Rates - Detailed explanation

Sorry for bumping an old topic, but IceMan, would this make the item, Spear of <Selfname>(+0)[ID#910121300], upgradeable to (+10)?

Code:
insert into item_upgrade values ('400000','5001','Spear of <Selfname>','Blessed Elemental Scroll','7','300','379025000','0','0','0','0','0','0','0','500000','0','10000','1')
insert into item_upgrade values ('400001','5001','Spear of <Selfname>(+1)','Blessed Upgrade Scroll','7','301','379021000','0','0','0','0','0','0','0','240000','0','10000','1')
insert into item_upgrade values ('400002','5001','Spear of <Selfname>(+2)','Blessed Upgrade Scroll','7','302','379021000','0','0','0','0','0','0','0','240000','0','10000','1')
insert into item_upgrade values ('400003','5001','Spear of <Selfname>(+3)','Blessed Upgrade Scroll','7','303','379021000','0','0','0','0','0','0','0','240000','3','7000','1')
insert into item_upgrade values ('400004','5001','Spear of <Selfname>(+4)','Blessed Upgrade Scroll','7','304','379021000','0','0','0','0','0','0','0','240000','5','7000','1')
insert into item_upgrade values ('400005','5001','Spear of <Selfname>(+5)','Blessed Upgrade Scroll','7','305','379021000','0','0','0','0','0','0','0','240000','8','6000','1')
insert into item_upgrade values ('400006','5001','Spear of <Selfname>(+6)','Blessed Upgrade Scroll','7','306','379021000','0','0','0','0','0','0','0','240000','10','3000','1')
insert into item_upgrade values ('400007','5001','Spear of <Selfname>(+7)','Blessed Upgrade Scroll','7','307','379021000','0','0','0','0','0','0','0','240000','11','500','1')
insert into item_upgrade values ('400008','5001','Spear of <Selfname>(+8)','Blessed Upgrade Scroll','7','308','379021000','0','0','0','0','0','0','0','240000','12','200','1')
insert into item_upgrade values ('400009','5001','Spear of <Selfname>(+9)','Blessed Upgrade Scroll','7','309','379021000','0','0','0','0','0','0','0','240000','13','100','1')
insert into item_upgrade values ('400010','5001','Spear of <Selfname>(+10)','Blessed Upgrade Scroll','7','310','379021000','0','0','0','0','0','0','0','240000','0','0','1')
 
Back
Top