Required remove & reset scrolls please...

01/25/2019 02:07 devdash#1
i need these 3 scrolls please
1.remove pk points scroll
2.remove fgw penalty scroll
3.remove holy water temple penalty scroll
thanks in advance..
01/25/2019 19:40 NorseGodTyr#2
Quote:
Originally Posted by alydandy View Post
i need these 4 scrolls please
1.remove maximum durability stats scroll " not removing blues " only red stats
2.remove pk points scroll
3.remove fgw penalty scroll
4.remove holy water temple penalty scroll
thanks in advance..

PHP Code:
if(@JobID= '45000')-- SkillID Holy temple remove 
        begin 
        delete from _CharInstanceWorldData where CharID =    [MENTION=395373]Chari[/MENTION]D
        return -3 
        end 
PHP Code:
if(@JobID = '45001') -- SkillID forgot World remove 
        begin 
        UPDATE _TimedJob SET TimeToKeep='7', Data1='0' WHERE CharID =   [MENTION=395373]Chari[/MENTION]D   AND Category='12' 
        DELETE FROM _TimedJob WHERE CharID =    [MENTION=395373]Chari[/MENTION]DAND Category='6' 
        return -3
end 
PHP Code:
if(@JobID = '45002') -- SkillID PK remove
        begin  
        UPDATE SRO_VT_SHARD.._Char SET DailyPK= 0, TotalPK= 0,PKPenaltyPoint= 0 WHERE CharID =    [MENTION=395373]Chari[/MENTION]D
        return -3 
        end 
change [ MENTION=395373]Chari[/ MENTION]D to @[Only registered and activated users can see links. Click Here To Register...]D

and here the scrolls & skills
Quote:
RefObjCommon
1 45000 ITEM_NORSEGOD_HW_SCROLL ???? ???? ??? (???) xxx SN_ITEM_NORSEGOD_HW_SCROLL SN_ITEM_NORSEGOD_HW_SCROLL_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 1 0 0 129 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_mall_scroll.bsr item\etc\mall_return_scroll.ddj xxx xxx 45000
1 45001 ITEM_NORSEGOD_FGW_SCROLL ???? ???? ??? (???) xxx SN_ITEM_NORSEGOD_FGW_SCROLL SN_ITEM_NORSEGOD_FGW_SCROLL_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 1 0 0 129 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_mall_scroll.bsr item\etc\mall_return_scroll.ddj xxx xxx 45001
1 45002 ITEM_NORSEGOD_PK_SCROLL ???? ???? ??? (???) xxx SN_ITEM_NORSEGOD_PK_SCROLL SN_ITEM_NORSEGOD_PK_SCROLL_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 1 0 0 129 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_mall_scroll.bsr item\etc\mall_return_scroll.ddj xxx xxx 45002

RefObjItem
45000 1 2 0 0 1 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 1000 ????(?) 1 [USU1:SKILL_NORSEGOD_REMOVETEMPLE] -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 -1 xxx -1 xxx 0 0 0
45001 1 2 0 0 1 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 1000 ????(?) 1 [USU1:SKILL_NORSEGOD_FGW] -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 -1 xxx -1 xxx 0 0 0
45002 1 2 0 0 1 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 1000 ????(?) 1 [USU1:SKILL_NORSEGOD_PK] -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 -1 xxx -1 xxx 0 0 0

RefSkill
1 45000 1011 SKILL_NORSEGOD_REMOVETEMPLE ???? ???? SKILL_NORSEGOD_REMOVETEMPLE 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\giftcoins_1000.ddj SN_SKILL_NORSEGOD_REMOVETEMPLE xxx SN_SKILL_NORSEGOD_REMOVETEMPLE_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 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
1 45001 1011 SKILL_NORSEGOD_FGW ???? ???? SKILL_NORSEGOD_FGW 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\giftcoins_1000.ddj SN_SKILL_NORSEGOD_FGW xxx SN_SKILL_NORSEGOD_FGW_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 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
1 45002 1011 SKILL_NORSEGOD_PK ???? ???? SKILL_NORSEGOD_PK 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\giftcoins_1000.ddj SN_SKILL_NORSEGOD_PK xxx SN_SKILL_NORSEGOD_PK_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 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
01/25/2019 21:05 devdash#3
Quote:
Originally Posted by NorseGodTyr View Post
PHP Code:
if(@JobID= '45000')-- SkillID Holy temple remove 
        begin 
        delete from _CharInstanceWorldData where CharID =    [MENTION=395373]Chari[/MENTION]D
        return -3 
        end 
PHP Code:
if(@JobID = '45001') -- SkillID forgot World remove 
        begin 
        UPDATE _TimedJob SET TimeToKeep='7', Data1='0' WHERE CharID =   [MENTION=395373]Chari[/MENTION]D   AND Category='12' 
        DELETE FROM _TimedJob WHERE CharID =    [MENTION=395373]Chari[/MENTION]DAND Category='6' 
        return -3
end 
PHP Code:
if(@JobID = '45002') -- SkillID PK remove
        begin  
        UPDATE SRO_VT_SHARD.._Char SET DailyPK= 0, TotalPK= 0,PKPenaltyPoint= 0 WHERE CharID =    [MENTION=395373]Chari[/MENTION]D
        return -3 
        end 
change [ MENTION=395373]Chari[/ MENTION]D to @[Only registered and activated users can see links. Click Here To Register...]D

and here the scrolls & skills
thanks alot <3
09/01/2019 17:05 AligatorSniper#4
anyone can explain how to make?
where need to put :
1) if(@JobID= '45000')-- SkillID Holy temple remove
2) if(@JobID = '45001') -- SkillID forgot World remove
3) if(@JobID = '45002') -- SkillID PK remove
thx
09/01/2019 17:31 hoangphan7#5
Quote:
Originally Posted by AligatorSniper View Post
anyone can explain how to make?
where need to put :
1) if(@JobID= '45000')-- SkillID Holy temple remove
2) if(@JobID = '45001') -- SkillID forgot World remove
3) if(@JobID = '45002') -- SkillID PK remove
thx
Put it in _AddTimedJob
09/01/2019 17:38 devdash#6
Quote:
Originally Posted by AligatorSniper View Post
anyone can explain how to make?
where need to put :
1) if(@JobID= '45000')-- SkillID Holy temple remove
2) if(@JobID = '45001') -- SkillID forgot World remove
3) if(@JobID = '45002') -- SkillID PK remove
thx
SRO_VT_SHARDLOG > _AddTimedJob in the bottom.
09/02/2019 00:48 AligatorSniper#7
im cheack in shardlog no have _addTimedJob
thank you anyway
09/02/2019 03:09 devdash#8
Quote:
Originally Posted by AligatorSniper View Post
im cheack in shardlog no have _addTimedJob
thank you anyway
my bad..sorry...sro_vt_shard not log

SRO_VT_SHARD > Programmability > Stored Procedure > ADDTimedJob