[Help] change upgrade

[tabarnak1]

how i can change upgrade on myko database ( By_Piskod Db1 )
thx

 

[tabarnak1]

anny pleaple can help me ?

 

[TheWarc]

Me too, eventually i'll find out how, but would save me some time..

 

[TheWarc]

Bump, really need help on this one, I can't really find where :/

 

[davio147]

i know what maybe can help you go SQL Server KN_online table's then change in all UPGRATEEXT sipercent1=100 sipercent2=100 sipercent3=100 sipercent4=100 sipercent5=100 sipercent 6=100 sipercent7=100 sipercent8=100 sipercent9=100

 

[q12345]

davio, that's not it...

 

[davio147]

davio, that's not it...

lagalos said me :S

 

[q12345]

It's item_upgrade table, not upgradeext, because myko db's don't even have upgradeext.

 

[bl_ades]

"update item_upgrade set nGenRate 10000" or something like that 10000 means 100% +10 i think it was so

 

[jroc]

/*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='8000'
WHERE nOriginItem like '%4' AND nReqItem1='379021000'
/*+6*/
UPDATE ITEM_UPGRADE SET nGenRate='7000'
WHERE nOriginItem like '%5' AND nReqItem1='379021000'
/*+7*/
UPDATE ITEM_UPGRADE SET nGenRate='6000'
WHERE nOriginItem like '%6' AND nReqItem1='379021000'
/*+8*/
UPDATE ITEM_UPGRADE SET nGenRate='8000'
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='0'
WHERE nOriginItem like '%9' AND nReqItem1='379021000'