Direk anlatima geceyim 
En başta bunlari okutuyoruz DB'ye
Sonra Bunu
En son olarakta altta vermiş oldugum itemdata_35000.txt'i mediaya import ediyoruz ve 120 lvl olmuş oluyor itemler iyi forumlar
En başta bunlari okutuyoruz DB'ye
USE SRO_VT_SHARD UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_CH%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%HEAVY%13%RARE%'
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%'
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%'
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%'
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%HEAVY%13%RARE%'
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%'
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%'
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%'
Sonra Bunu
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
UPDATE _RefObjItem SET ItemClass=35 WHERE ItemClass=38
UPDATE _RefObjItem SET ItemClass=36 WHERE ItemClass=39
En son olarakta altta vermiş oldugum itemdata_35000.txt'i mediaya import ediyoruz ve 120 lvl olmuş oluyor itemler iyi forumlar
Son düzenleme:
