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:
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 ####
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 ####
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 ####
Basically, same principles apply for the non-trina upgrades. So, yeah, read above.
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.