UPGRADE ORANLARINI AYARLAMA

UPDATE ITEM_UPGRADE
SET nGenRate = 10000
WHERE (nReqItem1 = 379021000) AND (nGenRate = 7000)

UPDATE ITEM_UPGRADE
SET nGenRate = 10000
WHERE (nReqItem1 = 379021000) AND (nGenRate = 6000)

UPDATE ITEM_UPGRADE
SET nGenRate = 10000
WHERE (nReqItem1 = 379021000) AND (nGenRate = 3000)

UPDATE ITEM_UPGRADE
SET nGenRate = 10000
WHERE (nReqItem1 = 379021000) AND (nGenRate = 500)

UPDATE ITEM_UPGRADE
SET nGenRate = 30
WHERE (nReqItem1 = 379021000) AND (nGenRate = 200)

UPDATE ITEM_UPGRADE
SET nGenRate = 20
WHERE (nReqItem1 = 379021000) AND (nGenRate = 100)

UPDATE ITEM_UPGRADE
SET nGenRate = 10
WHERE (nReqItem1 = 379021000) AND (nGenRate = 0)

TY TEŞKÜR