I know that there are several Tutorials and Guides how to fix the BlackPillBug.
But 99% of them are based on static IDs. I am tired of all those skype pms with "plazt fex blackmbot bugk halp" ö.Ö
I rewrote a small Script (and tested it on vSro v188).
PHP Code:
select ID as ID_ObjCommon,CodeName128,Link
from SRO_VT_SHARD.._RefObjCommon
where CodeName128 like 'ITEM_ETC_CURE_RANDOM_0%'
/* <-- Remove if you are sure that you'll update the right items!
update SRO_VT_SHARD.._RefObjItem
set Param4='21000',
Desc4_128='COOLTIME:0x000000C9'
where ID in
(select Link from SRO_VT_SHARD.._RefObjCommon where CodeName128 like 'ITEM_ETC_CURE_RANDOM_0%')
--*/
select ID as ID_ObjItem,Param4,Desc4_128
from SRO_VT_SHARD.._RefObjItem
where ID in
(select Link from SRO_VT_SHARD.._RefObjCommon where CodeName128 like 'ITEM_ETC_CURE_RANDOM_0%')
Make sure that it looks like this:
Otherwise if there are no Items like "ITEM_ETC_CURE_RANDOM_" in the list, you'll update wrong things and may bug your server.
If you ensured that you'll update the right items remove the /* and have fun.