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!

Changing Anvil Rates For Weapons and Armor

Experienced Elementalist
Joined
Jan 3, 2008
Messages
299
Reaction score
1
This, I guess, is an expansion of Iceman's topic. Some people were asking me about this, so I guess I'll evaluate on it and drop my two cents so you guys can understand it more.

Background Info: Messing around with these rates ALL deal with the ITEM_UPGRADE table. You should know that the % rate of creation is the column called the nGenRate. Now, with the nGenRate, it reads it really different. (% Desired) x (100) = the value you put in nGenRate. For example:

Code:
10000 = 100%
7500 =  75%
5000 = 50%
2500 = 25%
1000 = 10%
500 = 5%
100 = 1%
10 = .1%
1 = .01%

Keep that in mind for when you put them into the query codes you'll see later. I will refer to it as (%) in the codes. However, when you put the nGenRate values in, do not leave the parentheses there. Take them out.

#### NOTICE: Elemental Scroll Rates ####

Code:
update item_upgrade set nGenRate=(%) where nReqItem1=379025000

This will edit the Blessed Elemental upgrades of ALL items. Keep in mind that Blessed Elemental Scrolls are required to make a unique item upgradeable.

#### NOTICE: Upgrading WITHOUT Trina's Piece ####

Code:
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%1'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%2'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%3'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%4'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%5'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%6'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%7'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%8'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%9'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%0'

OK, so you might be wondering what the nOriginItem is. Basically, it's the last 3 numbers of an Item ID. Basically, nOriginItem is the ItemID BEFORE the upgrade. So, where you see the %1, that codes for the +1 - +2 upgrade, %4 for +4 - +5, %0 for +10 - +11, etc. The %0 codes for all multiples of 10. Keep that in mind.

#### NOTICE: Upgrading WITH Trina's Piece ####
Code:
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%1'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%2'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%3'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%4'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%5'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%6'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%7'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%8'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%9'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%0'

Basically, same principles apply for the non-trina upgrades. So, yeah, read above.
 
Junior Spellweaver
Joined
Dec 15, 2008
Messages
124
Reaction score
40
Thank you very much for the information. Things like this really help out alot!
 
Newbie Spellweaver
Joined
Jul 10, 2006
Messages
21
Reaction score
0
This, I guess, is an expansion of Iceman's topic. Some people were asking me about this, so I guess I'll evaluate on it and drop my two cents so you guys can understand it more.

Background Info: Messing around with these rates ALL deal with the ITEM_UPGRADE table. You should know that the % rate of creation is the column called the nGenRate. Now, with the nGenRate, it reads it really different. (% Desired) x (100) = the value you put in nGenRate. For example:

Code:
10000 = 100%
7500 =  75%
5000 = 50%
2500 = 25%
1000 = 10%
500 = 5%
100 = 1%
10 = .1%
1 = .01%

Keep that in mind for when you put them into the query codes you'll see later. I will refer to it as (%) in the codes. However, when you put the nGenRate values in, do not leave the parentheses there. Take them out.

#### NOTICE: Elemental Scroll Rates ####

Code:
update item_upgrade set nGenRate=(%) where nReqItem1=379025000

This will edit the Blessed Elemental upgrades of ALL items. Keep in mind that Blessed Elemental Scrolls are required to make a unique item upgradeable.

#### NOTICE: Upgrading WITHOUT Trina's Piece ####

Code:
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%1'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%2'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%3'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%4'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%5'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%6'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%7'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%8'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%9'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%0'

OK, so you might be wondering what the nOriginItem is. Basically, it's the last 3 numbers of an Item ID. Basically, nOriginItem is the ItemID BEFORE the upgrade. So, where you see the %1, that codes for the +1 - +2 upgrade, %4 for +4 - +5, %0 for +10 - +11, etc. The %0 codes for all multiples of 10. Keep that in mind.

#### NOTICE: Upgrading WITH Trina's Piece ####
Code:
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%1'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%2'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%3'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%4'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%5'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%6'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%7'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%8'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%9'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%0'

Basically, same principles apply for the non-trina upgrades. So, yeah, read above.

so basically for 75% upgrade where it says ngenrate (%) make that ngenrate 7500?
 
Back
Top