Required remove & reset scrolls please...

[devdash]

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..

[NorseGodTyr]

Originally Posted by alydandy

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 @D

and here the scrolls & skills

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

[devdash]

Originally Posted by NorseGodTyr

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 @D

and here the scrolls & skills

thanks alot <3

[AligatorSniper]

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

[hoangphan7]

Originally Posted by AligatorSniper

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

[devdash]

Originally Posted by AligatorSniper

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.

[AligatorSniper]

im cheack in shardlog no have _addTimedJob
thank you anyway

[devdash]

Originally Posted by AligatorSniper

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