Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Message System / Level Up / Item Destroy

B1QB0SS

B1QB0SS

very nice
Joined
Jul 5, 2013
Messages
518
Reaction score
80
Hello RageZoner's
i got Alot of Free time so i decided to help newbies with some usefull stuff

Here's A Small message System For GM'S

Code: 
USE [SRO_VT_SHARD]GO
/****** Object:  StoredProcedure [dbo].[_Memo_Add]    Script Date: 5/21/2014 12:35:32 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
------------------------------------------------
-- # PROCEDURE   _Memo_Add ¼öÁ¤
------------------------------------------------


ALTER    procedure [dbo].[_Memo_Add]
        --ÇÊ¿ä ÆĶó¹ÌÅÍ
     @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName    varchar(64),
     @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName    varchar(64),
     @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge        varchar(300),
        --ºÎ°¡ ÆĶó¹ÌÅÍ
     @[I][B][URL="http://forum.ragezone.com/members/447213.html"]Max[/URL][/B][/I]_MEMO_COUNT    int
    as    
    DECLARE @SI1D int = (SELECT charid FROM _Char where CharName16 = @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName)
  -- Penalty Remover 
  IF @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'Penalty_R'
  BEGIN
  DELETE FROM _TimedJob where JobID = '1'  and CharID = @SI1D  or JobID = '2' and CharID = @SI1D
  END
    begin transaction
        declare @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]_charid int
        set @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]_charid = (select CharID from _Char where CharName16 = @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName)
        if (@@error <> 0 or @@rowcount = 0 )
        begin
            --±×·±¾Ö´Â ¾ø¾î~
            rollback transaction
            return -1
        end


        declare @[I][B][URL="http://forum.ragezone.com/members/805189.html"]memo[/URL][/B][/I]_count int
        select @[I][B][URL="http://forum.ragezone.com/members/805189.html"]memo[/URL][/B][/I]_count = count(*) from _Memo where CharID = @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]_charid
        if( @[I][B][URL="http://forum.ragezone.com/members/805189.html"]memo[/URL][/B][/I]_count >= @[I][B][URL="http://forum.ragezone.com/members/447213.html"]Max[/URL][/B][/I]_MEMO_COUNT )
        begin
            -- ÂÊÁöÇÔÀÌ ²Ëá³×~
            rollback transaction
            return -2
        end


        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        --        EUROPE_SYSTEM (ÃÖÀÎÈ£) 
        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        declare @[I][B][URL="http://forum.ragezone.com/members/18171.html"]ReF[/URL][/B][/I]ObjID int
        select @[I][B][URL="http://forum.ragezone.com/members/18171.html"]ReF[/URL][/B][/I]ObjID = RefObjID from _Char with (nolock) where CharName16 = @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName
        if (@@error <> 0 or @@rowcount = 0 )
        begin 
            rollback transaction
            return -4
        end


        declare @[I][B][URL="http://forum.ragezone.com/members/856219.html"]Record[/URL][/B][/I]Date  smalldatetime
        set @[I][B][URL="http://forum.ragezone.com/members/856219.html"]Record[/URL][/B][/I]Date = GetDate()
        insert _Memo (CharID, FromCharName,Message,Date,Status,RefObjID)  values( @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]_charid, @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName, @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge, @[I][B][URL="http://forum.ragezone.com/members/856219.html"]Record[/URL][/B][/I]Date, 0, @[I][B][URL="http://forum.ragezone.com/members/18171.html"]ReF[/URL][/B][/I]ObjID )
        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        if (@@error <> 0 or @@rowcount = 0 )
        begin
            rollback transaction
            --È£°î!!
            return -3
        end
                
        commit transaction
        return @@identity    


        If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_EU_HA_M') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_HEAVY_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_HEAVY_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_HEAVY_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_HEAVY_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_HEAVY_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_HEAVY_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_EU_HA_W') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_HEAVY_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_HEAVY_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_HEAVY_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_HEAVY_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_HEAVY_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_HEAVY_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_EU_LA_M') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_LIGHT_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_LIGHT_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_LIGHT_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_LIGHT_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_LIGHT_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_LIGHT_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_EU_LA_W') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_LIGHT_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_LIGHT_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_LIGHT_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_LIGHT_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_LIGHT_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_LIGHT_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_EU_CL_M') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_CLOTHES_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_CLOTHES_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_CLOTHES_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_CLOTHES_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_CLOTHES_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_M_CLOTHES_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_EU_CL_W') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_CLOTHES_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_CLOTHES_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_CLOTHES_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_CLOTHES_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_CLOTHES_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_W_CLOTHES_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_CH_HA_M') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_HEAVY_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_HEAVY_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_HEAVY_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_HEAVY_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_HEAVY_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_HEAVY_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_CH_HA_W') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_HEAVY_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_HEAVY_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_HEAVY_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_HEAVY_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_HEAVY_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_HEAVY_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_CH_LA_M') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_LIGHT_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_LIGHT_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_LIGHT_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_LIGHT_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_LIGHT_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_LIGHT_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_CH_LA_W') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_LIGHT_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_LIGHT_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_LIGHT_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_LIGHT_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_LIGHT_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_LIGHT_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_CH_CL_M') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_CLOTHES_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_CLOTHES_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_CLOTHES_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_CLOTHES_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_CLOTHES_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_M_CLOTHES_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_SET_CH_CL_W') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_CLOTHES_11_SA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_CLOTHES_11_HA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_CLOTHES_11_AA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_CLOTHES_11_BA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_CLOTHES_11_LA_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_W_CLOTHES_11_FA_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_EU_ITEMS_PACK') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_TSWORD_11_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_SWORD_11_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_HARP_11_S_ET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_SHIELD_11_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_DAGGER_11_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_CROSSBOW_11_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_EU_DARKSTAFF_11_SET_B_RARE',1,250
end  
    If  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'IAMGM' and @[I][B][URL="http://forum.ragezone.com/members/782815.html"]messa[/URL][/B][/I]ge = 'GM_CH_ITEMS_PACK') 
 begin 
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_BOW_11_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_BLADE_11_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_TBLADE_11_SET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_SPEAR_11_S_ET_B_RARE',1,250
exec _ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/1333413168.html"]Sen[/URL][/B][/I]derCharName,'ITEM_CH_SHIELD_11_SET_B_RARE',1,250

end

How it Works?

this Msg system got all SET CH / EU M / F D11 EGY B +250

Send Message To CharName : IAMGM

And write in message : GM_SET_EU_HA_M

To get chinese Replace "EU" With "CH"

HA = Heavy Armor

LA = Light Armor

CL = Robe

GM_EU_ITEMS_PACK : FULL EUROPE ITEMS D11 EGY B +250

GM_CH_ITEMS_PACK : Full CHINESE ITEMS D11 EGY B +250

To Get Female Gears Change "M" To "F"

There's Penalty Reset in this pRocedure
-----------------------------------------------------------------
Another small System

Put This Query in _AddLogItem

Code: 
if(@Operation = 41) And @strDesc_separado >= 15Begin
Declare @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]NameReward Varchar(64)
select @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]NameReward =CharName16  from SRO_VT_SHARD.dbo._Char where CharID @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]NameReward,'ITEM_EVENT_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,1
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]NameReward,'ITEM_COS_P_CAT_SCROLL',1,1
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]NameReward,'ITEM_COS_P_FLUTE_WHITE_SMALL',1,1

End

if Your item +15+ And it destroyed you will get Gift Change ITEM CODE Between '' To Change the Reward

@strDesc_separado >= 15 ( 15 = Item Plus )

-----------------------------------------------------------------

Here's Same Thing But this One in _addLogChar

When You Level Up To Level 110 it will Give you Some items As a gift

Code: 
if @[I][B][URL="http://forum.ragezone.com/members/1333420483.html"]event[/URL][/B][/I]ID = '22' and @[I][B][URL="http://forum.ragezone.com/members/1333359883.html"]data[/URL][/B][/I]2 = '110'declare @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name16 varchar(64) = (Select CharName16 From SRO_VT_SHARD.._Char Where CharID = @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID)
     begin
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name16,'ITEM_EVENT_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,1
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name16,'ITEM_COS_P_CAT_SCROLL',1,1
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name16,'ITEM_COS_P_FLUTE_WHITE_SMALL',1,1

      END
@data2 = '110' ( Level )

also you can change rewards by changing Item codename Between ''

Have Fun...
 
Last edited:
The Best DDoS Protected Servers
lemoniscool

lemoniscool

Master Summoner
Joined
Nov 9, 2009
Messages
579
Reaction score
238
actually even not that bad i bet some newbs will be very happy to see this
i mean .. the 2nd and 3rd stuff is just common if you know your database and its procedures etc but still .. nice for newbs ^^


//edit:
btw you forgot to mention the penalty reset feature inside your _Memo_Add procedure ^^

Code: 
 IF  [USER=1333461823]Target[/USER]CharName like 'Penalty_R'
  BEGIN
  DELETE FROM _TimedJob where JobID = '1'  and CharID = @SI1D  or JobID = '2' and CharID = @SI1D
  END

also you forgot to mention GM_EU_ITEMS_PACK and GM_CH_ITEMS_PACK to get weapons
 
Last edited:
B1QB0SS

B1QB0SS

very nice
Joined
Jul 5, 2013
Messages
518
Reaction score
80
lemoniscool said:
actually even not that bad i bet some newbs will be very happy to see this
i mean .. the 2nd and 3rd stuff is just common if you know your database and its procedures etc but still .. nice for newbs ^^


//edit:
btw you forgot to mention the penalty reset feature inside your _Memo_Add procedure ^^

Code: 
 IF  @[I][B][URL="http://forum.ragezone.com/members/1333461823.html"]Target[/URL][/B][/I]CharName like 'Penalty_R'
  BEGIN
  DELETE FROM _TimedJob where JobID = '1'  and CharID = @SI1D  or JobID = '2' and CharID = @SI1D
  END

also you forgot to mention GM_EU_ITEMS_PACK and GM_CH_ITEMS_PACK to get weapons
Click to expand...


oh thanks for attention iam sorry i forgot them :D

Edit : Edited First Post Added Missing Info

Have Fun..
 
tormentor

tormentor

Newbie Spellweaver
Joined
Jan 10, 2013
Messages
20
Reaction score
1
can you make system for the number one in kills unique take title please
 
yona1006

yona1006

Junior Spellweaver
Joined
Dec 5, 2011
Messages
105
Reaction score
16
thanks good job
( You can create where the Guild win the ftw win silk )
pls
 
B1QB0SS

B1QB0SS

very nice
Joined
Jul 5, 2013
Messages
518
Reaction score
80
RenePunik said:
About auto guild winner gift is awesome system we hope you done asap u can. we wait you :D:
Click to expand...
i'll Finish it Today



reward must be silks ? or can be items!



atm i found a way to make the reward items



and reward will be for Guild Master Only
 
lemoniscool

lemoniscool

Master Summoner
Joined
Nov 9, 2009
Messages
579
Reaction score
238
if you want to reward silk immediately use SRO_VT_ACCOUNT.CGI.CGI_WebPurchaseSilk to do so

greetz
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
254
Guests online
6,013
Total visitors
6,267
Totals may include hidden visitors.

Forum statistics

Threads
429,028
Messages
4,589,928
Members
280,331
Latest member
Lectem
Most visitors online was 8830 , on 6 Feb 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top