[Share] Pk Count

[DontBugMe]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO






ALTER PROCEDURE [dbo].[sp_LogAction_Insert]
    @nChaNum int,
    @nType int,
    @nTargetNum int,
    @nTargetType int,
    @nExpPoint money,
    @[I][B][URL="https://forum.ragezone.com/members/2000144584.html"]Nbr[/URL][/B][/I]ightPoint int,
    @nLifePoint int,
    @nMoney money
AS    
    SET NOCOUNT ON
IF (@nType=2)
    BEGIN
    Update RanGame1.dbo.ChaInfo
    Set ChaPKWIN=ChaPKWIN+1
    Where ChaNum=@nChaNum
    END
IF ([COLOR=#ff0000]@nType=3[/COLOR])
    BEGIN
    Update RanGame1.dbo.ChaInfo
    Set ChaPKLOSS=ChaPKLOSS+1
    Where ChaNum=@nChaNum
    END


    INSERT INTO LogAction (ChaNum,   Type,   TargetNum,   TargetType,   ExpPoint,   BrightPoint,   LifePoint,   ActionMoney) 
    VALUES    (@nChaNum, @nType, @nTargetNum, @nTargetType, @nExpPoint, @[I][B][URL="https://forum.ragezone.com/members/2000144584.html"]Nbr[/URL][/B][/I]ightPoint, @nLifePoint, @nMoney)


    SET NOCOUNT OFF

KILL and Death
i use this on my EP7 server before
credit for me ofcourse for experimenting lol

were can i replace that code?

 

[Ace17]

were can i replace that code?

add trigger

 

[Athan Gomez]

Add column in RanGame1 >Chainfo

Column name "ChaKill" bigint not null

then execute this on ranlog

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO



ALTER PROCEDURE [dbo].[sp_LogAction_Insert]
    @nChaNum int,
    @nType int,
    @nTargetNum int,
    @nTargetType int,
    @nExpPoint money,
    @nBrightPoint int,
    @nLifePoint int,
    @nMoney money
AS    
    SET NOCOUNT ON
IF (@nType=2)
    BEGIN
    Update RanGame1.dbo.ChaInfo
    Set ChaKill=ChaKill+1
    Where ChaNum=@nChaNum
    END

    INSERT INTO LogAction (ChaNum,   Type,   TargetNum,   TargetType,   ExpPoint,   BrightPoint,   LifePoint,   ActionMoney) 
    VALUES    (@nChaNum, @nType, @nTargetNum, @nTargetType, @nExpPoint, @nBrightPoint, @nLifePoint, @nMoney)

    SET NOCOUNT OFF

then create your custom ranking php script which will count values in chakill column




Sorry for sharing this someone is making money out of this
"wag nyo sakin ibenta dahil di nyo man lang alam ako ang gumawa"


Credits Iwarez and me

compatible for what ep sir?

 

[Ace17]

compatible for what ep sir?

not recommended to use this triggeron ep9 coz ep9 already have pk win and pk loss..
use it on EP3, EP4, EP5, EP6, EP7