[Request] Rates Query

[HellFire]

my item_upgrade table is all 100% +10 atm.
any query exist to make it all from +10 100% to 1 - 7 100% and +8 - 10 usko rate?

 

[Dakino]

why dont you use this

http://forum.ragezone.com/showthread.php?t=433468

 

[dlbert2000]

u can query for nOriginItem, the last number = what + the item is
just like in Item_org

edit: didn't see dakino posted the link

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.

If you want to set +7 - +8 rates the number would be %7.

 

[HellFire]

damn i love u man XD

 

[Advocate]

but problem with that script needs to be modify for items being up with trina and bus because iit will screw up down the road trust me

 

[IceMan1300]

All you do to change the trina rate is set the ReqItem1 to the ID of the trina and the ReqItem2 to the ID of the scroll.

 

[Advocate]

All you do to change the trina rate is set the ReqItem1 to the ID of the trina and the ReqItem2 to the ID of the scroll.

ICE been trying mess around that but keep getting errors how do include second option when adjust trina rate?