Little Problem on D13 Items

[MaDenGo]

D13 Items Work fine but when i add Any Blue .
Example : When i use STR Stone to add Str on there get crash and i have to delete the item
from SMC to able to login
So any idea
why i get crash when i add any blue and Normal when i add Attribute stones ( White Stats )

[MentaL]

[MaDenGo]

Any Fix !

[nemo07]

Any Fix !

check the "magicoption" in DB and Client

[MaDenGo]

check the "magicoption" in DB and Client

I Checked Magicoption (9) on Database & Client
and still crash

[MaDenGo]

Any Solve !?

[Caosfox]

try this, downgrade 1 item to d12, and try to add d12 stones, if works = problem in your d13 stones

[MaDenGo]

try this, downgrade 1 item to d12, and try to add d12 stones, if works = problem in your d13 stones

i tested add blue with SMC Without use stones
and Still crash

[Caosfox]

smc is like using stones, uses the same tables stones uses

[tapsie]

test this on your test server before

code

USE sro_vt_shard
/* Chinese */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_CH%13%RARE%'
/* EU Heavy */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%HEAVY%13%RARE%'
/* EU Light */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%LIGHT%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel2=120 WHERE CodeName128 LIKE '%ITEM_EU%LIGHT%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel3=120 WHERE CodeName128 LIKE '%ITEM_EU%LIGHT%13%RARE%'
/* EU Clothes */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel2=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel3=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel4=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
/* EU acc and weapon*/
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%13_A_RARE%' OR CodeName128 LIKE '%ITEM_EU%13_B_RARE%' OR CodeName128 LIKE '%ITEM_EU%13_C_RARE%'



and this


use sro_vt_shard
UPDATE _RefObjItem SET ItemClass=34 WHERE ItemClass=37
UPDATE _RefObjItem SET ItemClass=35 WHERE ItemClass=38
UPDATE _RefObjItem SET ItemClass=36 WHERE ItemClass=39


good luck :-)

[MaDenGo]

test this on your test server before

code

USE sro_vt_shard
/* Chinese */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_CH%13%RARE%'
/* EU Heavy */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%HEAVY%13%RARE%'
/* EU Light */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%LIGHT%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel2=120 WHERE CodeName128 LIKE '%ITEM_EU%LIGHT%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel3=120 WHERE CodeName128 LIKE '%ITEM_EU%LIGHT%13%RARE%'
/* EU Clothes */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel2=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel3=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel4=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
/* EU acc and weapon*/
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%13_A_RARE%' OR CodeName128 LIKE '%ITEM_EU%13_B_RARE%' OR CodeName128 LIKE '%ITEM_EU%13_C_RARE%'



and this


use sro_vt_shard
UPDATE _RefObjItem SET ItemClass=34 WHERE ItemClass=37
UPDATE _RefObjItem SET ItemClass=35 WHERE ItemClass=38
UPDATE _RefObjItem SET ItemClass=36 WHERE ItemClass=39


good luck :-)

This Happened when i executed your Querrys

[tapsie]

first Happy new year

Make you same Lines in media and work ^^

itemdata_45000:

1 39161 ITEM_EU_STAFF_13_A_RARE 13차 클레릭 로드 (매직) xxx SN_ITEM_EU_STAFF_13_A_RARE SN_ITEM_EU_STAFF_13_A_RARE_TT_DESC 0 0 3 1 6 15 180000 1 6 1 1 1 255 3 1 1 1 0 0 17080000 7072 10608 0 9000 5978000 1 120 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\staff_13.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\staff_13.ddj xxx xxx 1 2 0 0 34 40 85.0 127.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0 0 0 0 2 0 6 0.0 0.0 0.0 0.0 0.0 5429.0 5737.0 6635.0 7012.0 173.39999 0.0 0.0 0.0 0.0 6984.0 7711.0 8536.0 9425.0 129.0 274.0 0.0 2.0 2.0 1 ITEM_EU_STAFF_14_A_RARE 1 ITEM_EU_STAFF_14_B_RARE 1 ITEM_EU_STAFF_14_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 소유 가능한 최대 소켓 수 9 0
1 39162 ITEM_EU_STAFF_13_B_RARE 13차 클레릭 로드 (레어) xxx SN_ITEM_EU_STAFF_13_B_RARE SN_ITEM_EU_STAFF_13_B_RARE_TT_DESC 0 0 3 1 6 15 180000 1 6 1 1 1 255 3 1 1 1 0 0 17747000 7336 11004 0 9000 6211450 1 120 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\staff_13.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\staff_13.ddj xxx xxx 1 2 0 0 35 40 87.0 130.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0 0 0 0 2 0 6 0.0 0.0 0.0 0.0 0.0 6230.0 6579.0 7614.0 8041.0 196.8 0.0 0.0 0.0 0.0 7711.0 8514.0 9425.0 10406.0 133.0 282.0 0.0 2.0 2.0 1 ITEM_EU_STAFF_14_A_RARE 1 ITEM_EU_STAFF_14_B_RARE 1 ITEM_EU_STAFF_14_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 소유 가능한 최대 소켓 수 9 0
1 39163 ITEM_EU_STAFF_13_C_RARE 13차 클레릭 로드 (레전드) xxx SN_ITEM_EU_STAFF_13_C_RARE SN_ITEM_EU_STAFF_13_C_RARE_TT_DESC 0 0 3 1 6 15 180000 1 6 1 1 1 255 3 1 1 1 0 0 18280000 7695 11543 0 9000 6398000 1 120 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\staff_13.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\staff_13.ddj xxx xxx 1 2 0 0 36 40 88.0 133.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0 0 0 0 2 0 6 0.0 0.0 0.0 0.0 0.0 6947.0 7334.0 8491.0 8964.0 217.7 0.0 0.0 0.0 0.0 8347.0 9216.0 10202.0 11264.0 135.0 287.0 0.0 2.0 2.0 1 ITEM_EU_STAFF_14_A_RARE 1 ITEM_EU_STAFF_14_B_RARE 1 ITEM_EU_STAFF_14_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 소유 가능한 최대 소켓 수 9 0

good luck ^^

[MaDenGo]

Still Crash
I Execute Querrys and removed from itemdata and readded and still crash

[MaDenGo]

use sro_vt_shard
UPDATE _RefObjItem SET ItemClass=34 WHERE ItemClass=37
UPDATE _RefObjItem SET ItemClass=35 WHERE ItemClass=38
UPDATE _RefObjItem SET ItemClass=36 WHERE ItemClass=39

This Querry change the items Degree To D12 and Success no problems and stone work fine
so i think the problem on D13 Stones Right !