الموقع العربي الاول للعبة Silkroad Online - :::Today Coming With :::Remove PREMIUM Scroll:::

http://www2.0zz0.com/2012/10/22/15/311256858.gif

http://www2.0zz0.com/2012/10/22/16/593531309.png

http://im45.gulfup.com/wsCcCQ.png

الموضوع باين من عنوانة ... اسكرول بتشيل البرميم

**************************
::::DataBease::::

RefObCommon
..............

كود PHP:


		
			
1    70006    ITEM_MALL_PREMIUM_REMOVE    ???? ???? ??? (???)    xxx    SN_ITEM_MALL_PREMIUM_REMOVE    SN_ITEM_MALL_PREMIUM_REMOVE_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\event_ghost_bottle.ddj    xxx    xxx    60003

RefObjItem
...............

كود PHP:


		
			
60003    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_MALL_PREMIUM_REMOVE]    -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
...........

كود PHP:


		
			
1    55378    1013    SKILL_MALL_PREMIUM_REMOVE    ???? ????    SKILL_MALL_PREMIUM_REMOVE    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\mall_dungeon_free_ticket_forgotten_world.ddj    SN_SKILL_MALL_PKREMOVER    xxx    SN_SKILL_MALL_PKREMOVER_TT_DESC    xxx    0    0    3    1667396966    1851946342    1685418593    3600    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0

*****
addtimedjob

اولا دي بتشيل كل اللي جنب اسمك من برميم او جود بليز ا اي سكرول

كود PHP:


		
			
if

(@JobID= '55378')

         BEGIN 

        DECLARE @CharName16 Varchar (MAX) 

     Select @CharName16=CharName16 from _Char where CharID = @CharID 

      Begin

     DELETE FROM _TimedJob WHERE Data2 between  1 AND 31104 AND CharID = @CharID 

       return -3 

    end

       end

ثانيا البروسيدر دي بتشيل البرميم فقط عن طريق اضافة ID الاسكيل مقدمة من Xan

كود:

IF (@Operation = 41) and (@ItemRefID = 50235) 

   Begin

    DELETE FROM SRO_VT_SHARD.dbo._TimedJob

WHERE  CharID = @CharID

--Made By #Xan

AND   JobID in (9278,43653,33855)

    End

او البروسيدر دي مقدمه من Hamza FiGo

كود:

if(@JobID= '59704') --Remove Premium--

begin

DECLARE @CharName16 Varchar (MAX)

declare @RemovePrem1 int

declare @RemovePrem2 int

declare @RemovePrem3 int

declare @RemovePrem4 int

declare @RemovePrem5 int

declare @RemovePrem6 int

declare @RemovePrem7 int

declare @RemovePrem8 int

DECLARE @REMOVEPREM9 INT

SET @RemovePrem1 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3847)

SET @RemovePrem2 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3783)

SET @RemovePrem3 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3769)

SET @RemovePrem4 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3795)

SET @RemovePrem5 = (Select ID From _TimedJob Where CharID=@CharID and Data2=10800)

SET @RemovePrem6 = (Select ID From _TimedJob Where CharID=@CharID and Data2=224)

SET @RemovePrem7 = (Select ID From _TimedJob Where CharID=@CharID and Data2=1)

SET @RemovePrem8 = (Select ID From _TimedJob Where CharID=@CharID and Data2=2)

SET @REMOVEPREM9 = (SELECT ID FROM _TIMEDJOB WHERE CharID=@CharID AND Data2=707799600)

delete from _TimedJob WHERE ID=@RemovePrem1

delete from _TimedJob WHERE ID=@RemovePrem2

delete from _TimedJob WHERE ID=@RemovePrem3

delete from _TimedJob WHERE ID=@RemovePrem4

delete from _TimedJob WHERE ID=@RemovePrem5

delete from _TimedJob WHERE ID=@RemovePrem6

delete from _TimedJob WHERE ID=@RemovePrem7

delete from _TimedJob WHERE ID=@RemovePrem8

delete from _TimedJob WHERE ID=@REMOVEPREM9

delete from _TimedJob where CharID = @CharID and JobID = 5412

delete from _TimedJob where CharID = @CharID and JobID = 31104

end

This in
SRO_VT_SHARD
/////////////////

Client Media
********
itemdata_xxxx
....................

كود PHP:


		
			
1    70006    ITEM_MALL_PREMIUM_REMOVE    ???? ???? ??? (???)    xxx    SN_ITEM_MALL_PREMIUM_REMOVE    SN_ITEM_MALL_PREMIUM_REMOVE_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\event_ghost_bottle.ddj    xxx    xxx    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_MALL_PREMIUM_REMOVE]                                                                                                     -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

skilldata_enc
................

كود PHP:


		
			
1    55378    1013    SKILL_MALL_PREMIUM_REMOVE    ???? ????    SKILL_MALL_PREMIUM_REMOVE    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\mall_dungeon_free_ticket_forgotten_world.ddj    SN_SKILL_MALL_PKREMOVER    xxx    SN_SKILL_MALL_PKREMOVER_TT_DESC    xxx    0    0    3    1667396966    1851946342    1685418593    3600    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0

skilleffect
...............

كود PHP:


		
			
1    ??? ???    SKILL_MALL_PREMIUM_REMOVE    0    FALSE    0    DEFAULT    none    none    none    none    none    none    none    none    0    0,0,0,0    ONE    none    none    none    none    none    none    none    0    1    



??? ???    SKILL_MALL_PREMIUM_REMOVE    ACT_S    0    FALSE    none    none    0    0    0    0    1    0,0    AT_LOOP    MOV_NONE,0,0,0    0,0,0    false,0,0,0,0,false    system\    item_returnscroll.efp    none    0,0,0    none    0,0,0    none    0    none    none    none

[YOUTUBE]9taU-wC3RR4[/YOUTUBE]