Post by Senketsu on Mar 20, 2017 14:16:53 GMT -5
If you would like to adjust your anvil rates, here are some sample codes to help get you started:
First of all, '10000' means %100, and so on.
And here's an example code to set the rates for Trina's Piece upgrades:
First of all, '10000' means %100, and so on.
/*BUS Upgrade Rates*/
/*+1*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%0' AND nReqItem1='379021000'
/*+2*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%1' AND nReqItem1='379021000'
/*+3*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%2' AND nReqItem1='379021000'
/*+4*/
UPDATE ITEM_UPGRADE SET nGenRate='9000'
WHERE nOriginItem like '%3' AND nReqItem1='379021000'
/*+5*/
UPDATE ITEM_UPGRADE SET nGenRate='7000'
WHERE nOriginItem like '%4' AND nReqItem1='379021000'
/*+6*/
UPDATE ITEM_UPGRADE SET nGenRate='5000'
WHERE nOriginItem like '%5' AND nReqItem1='379021000'
/*+7*/
UPDATE ITEM_UPGRADE SET nGenRate='4500'
WHERE nOriginItem like '%6' AND nReqItem1='379021000'
/*+8*/
UPDATE ITEM_UPGRADE SET nGenRate='3000'
WHERE nOriginItem like '%7' AND nReqItem1='379021000'
/*+9*/
UPDATE ITEM_UPGRADE SET nGenRate='1500'
WHERE nOriginItem like '%8' AND nReqItem1='379021000'
/*+10*/
UPDATE ITEM_UPGRADE SET nGenRate='700'
WHERE nOriginItem like '%9' AND nReqItem1='379021000'
/*+1*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%0' AND nReqItem1='379021000'
/*+2*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%1' AND nReqItem1='379021000'
/*+3*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%2' AND nReqItem1='379021000'
/*+4*/
UPDATE ITEM_UPGRADE SET nGenRate='9000'
WHERE nOriginItem like '%3' AND nReqItem1='379021000'
/*+5*/
UPDATE ITEM_UPGRADE SET nGenRate='7000'
WHERE nOriginItem like '%4' AND nReqItem1='379021000'
/*+6*/
UPDATE ITEM_UPGRADE SET nGenRate='5000'
WHERE nOriginItem like '%5' AND nReqItem1='379021000'
/*+7*/
UPDATE ITEM_UPGRADE SET nGenRate='4500'
WHERE nOriginItem like '%6' AND nReqItem1='379021000'
/*+8*/
UPDATE ITEM_UPGRADE SET nGenRate='3000'
WHERE nOriginItem like '%7' AND nReqItem1='379021000'
/*+9*/
UPDATE ITEM_UPGRADE SET nGenRate='1500'
WHERE nOriginItem like '%8' AND nReqItem1='379021000'
/*+10*/
UPDATE ITEM_UPGRADE SET nGenRate='700'
WHERE nOriginItem like '%9' AND nReqItem1='379021000'
And here's an example code to set the rates for Trina's Piece upgrades:
/*Trina Upgrade Rates*/
/*+1*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%0' AND nReqItem1='700002000'
/*+2*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%1' AND nReqItem1='700002000'
/*+3*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%2' AND nReqItem1='700002000'
/*+4*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%3' AND nReqItem1='700002000'
/*+5*/
UPDATE ITEM_UPGRADE SET nGenRate='8000'
WHERE nOriginItem like '%4' AND nReqItem1='700002000'
/*+6*/
UPDATE ITEM_UPGRADE SET nGenRate='7000'
WHERE nOriginItem like '%5' AND nReqItem1='700002000'
/*+7*/
UPDATE ITEM_UPGRADE SET nGenRate='6000'
WHERE nOriginItem like '%6' AND nReqItem1='700002000'
/*+8*/
UPDATE ITEM_UPGRADE SET nGenRate='4500'
WHERE nOriginItem like '%7' AND nReqItem1='700002000'
/*+9*/
UPDATE ITEM_UPGRADE SET nGenRate='3000'
WHERE nOriginItem like '%8' AND nReqItem1='700002000'
/*+10*/
UPDATE ITEM_UPGRADE SET nGenRate='1500'
WHERE nOriginItem like '%9' AND nReqItem1='700002000'
/*+1*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%0' AND nReqItem1='700002000'
/*+2*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%1' AND nReqItem1='700002000'
/*+3*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%2' AND nReqItem1='700002000'
/*+4*/
UPDATE ITEM_UPGRADE SET nGenRate='10000'
WHERE nOriginItem like '%3' AND nReqItem1='700002000'
/*+5*/
UPDATE ITEM_UPGRADE SET nGenRate='8000'
WHERE nOriginItem like '%4' AND nReqItem1='700002000'
/*+6*/
UPDATE ITEM_UPGRADE SET nGenRate='7000'
WHERE nOriginItem like '%5' AND nReqItem1='700002000'
/*+7*/
UPDATE ITEM_UPGRADE SET nGenRate='6000'
WHERE nOriginItem like '%6' AND nReqItem1='700002000'
/*+8*/
UPDATE ITEM_UPGRADE SET nGenRate='4500'
WHERE nOriginItem like '%7' AND nReqItem1='700002000'
/*+9*/
UPDATE ITEM_UPGRADE SET nGenRate='3000'
WHERE nOriginItem like '%8' AND nReqItem1='700002000'
/*+10*/
UPDATE ITEM_UPGRADE SET nGenRate='1500'
WHERE nOriginItem like '%9' AND nReqItem1='700002000'