• Vsro Unique Kills Record & Reward




    Required :



    unique with notification something like

    " Bank has Killed Tiger Girl From Tiger Bla bla "

    - How it works !

    1. Execute the Below Querys
    2. Open Soft 
    3. Add your Uniques Code ( Like MOB_CH_TIGERWOMAN ) , Add Silk Reward Amount , Add Service 1 = ON / 0 = OFF
    4. login With Even a Normal Character into Game Via Clinetless

    lets the program do its work




    Sql Side :


    Code:
    
CREATE PROCEDURE _Unique_Silk_reward 
    

    
-- ============================================= 
    

    
/*
    

    
ADD Silk Procedure By Eslam Galal
    

    
*/
    

    
-- ============================================= 
    

    
  @mobid INT,  
    

    
  @CharName16   VARCHAR(512) 
    
    

    
AS 
    

    
BEGIN
    
    

    
IF EXISTS ( Select * From SRO_VT_SHARDLOG.dbo._unique_Kills_Reward Where Unique_ID = @mobid And Service = 1 )
    

    
Begin
    

    
Declare @UserID int = (select UserJID from SRO_VT_SHARD.dbo._User where CharID = (SELECT CharID FROM SRO_VT_SHARD.dbo._Char where CharName16 = @CharName16))
    

    
Declare @Silk int = ( Select Silk_Amount From SRO_VT_SHARDLOG.dbo._unique_Kills_Reward Where Unique_ID = @mobid )
    

    
IF EXISTS ( Select * From SRO_VT_ACCOUNT.dbo.SK_Silk Where JID = @UserID )
    

    
BEGIN
    

    
UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own = silk_own + @silk where JID = @UserID
    

    
END
    

    
ELSE 
    

    
BEGIN
    

    
INSERT SRO_VT_ACCOUNT.dbo.SK_Silk (JID,silk_own,silk_gift,silk_point) Values (@UserID,@Silk,0,0)
    

    
END
    

    
END
    

    
END
    


    
USE [SRO_VT_SHARDLOG]
    

    
GO
    


    

    
    /****** Object:  Table [dbo].[_unique_Kills_Reward]    

    
Script Date: 5/27/2015 10:01:46 PM ******/
    

By Eslam Galull
Skype : eslam.galull

    

    
    SET ANSI_NULLS ON

    
SET QUOTED_IDENTIFIER ON
    
GO

GO


    
GO
    
SET ANSI_PADDING ON


    
CREATE TABLE [dbo].[_unique_Kills_Reward](
    

    
 [Unique_ID] [INT] NULL,
    

    
 [Silk_Amount] [INT] NULL,
    

    
 [Service] [INT] NULL
    
    

    

    
    ) 

    
GO
    Download


    - All Copyrights Reserved to Eslam Galull @galullians.com 2015








    • Twitter

    Like us

    Author Info