Quote:
Originally Posted by Play-Sro
reload your database from old database
Table
_RefObjCommon
_Refobjitem
_RefMagicOpt
Select to _RefObjCommon
Code:
select * from SRO_VT_SHARD.._RefObjCommon where CodeName128 like 'ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_%'
Select to _Refobjitem
Code:
select * from SRO_VT_SHARD.._RefObjItem where id in (select Link from SRO_VT_SHARD.._RefObjCommon where CodeName128 like 'ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_%')
select to _RefMagicOpt
Code:
select * from _RefMagicOpt where MOptName128 = 'MATTR_ATHANASIA'
|
Code:
1 61653 ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_13 ??? ??? xxx SN_ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_13 SN_ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_TT_DESC 1 0 3 3 11 7 180000 3 0 1 1 1 255 1 1 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_archemy.bsr item\etc\archemy_magicstone_athanasia.ddj xxx xxx 21461
Code:
21461 20 2 0 0 13 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 0 0 0 0 0 0 0 13 MATTR_ATHANASIA 0 ? 0, 0, 0, 0 0 ? 0, 0, 0, 0 100 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 -1 xxx -1 xxx 0 0 0
Code:
1 439 MATTR_ATHANASIA + 13 0.3 0 1635018849 65538 196612 327686 1949133172 0 0 0 0 1 0 0 0 0 0 0 1635018849 0 0 0 0 0 weapon 1 armor 1 shield 1 accessory 1 xxx 0 xxx 0 xxx 0 xxx 0 xxx 0 xxx 0