[Share] Pk Count

[jescolta19]

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

[MentaL]

[dondonk]

I think this script still have some bugs, with ZIP another character.. Can count on pk point.

Cz only type 2, pk and zip have same type.

No offence.. More power RZ!

[jescolta19]

its not a bug it works that way pk using z is also pk also counted

[dondonk]

its not a bug it works that way pk using z is also pk also counted

So, Player can make another character to raise up his pk point.. By pk using z..

Hihi... :p

[jescolta19]

allow only a certain level or reborn of characters to show in rankings

[iMeebo]

I will try this :D V

[Warrior15]

I can't add chakill with no null..how can i add

[denvee]

I can't add chakill with no null..how can i add

just put 0 on default value or binding

[Warrior15]

just put 0 on default value or binding

wow tnx

[ju_one06]

great share..i will add in my game..^^

[prodigy4]

Do I need to restart my server?

Cuz it didnt do anything, :P Im using GC panel

[AldrianPH]

Can you teach me how to execute this on ran log?

[markalejo77]

Can you teach me how to execute this on ran log?

add me in FB : Cabilangdawako

[AldrianPH]

is that you? the girl?

[markalejo77]

is that you? the girl?

thats my GF lol

[ryruz]

how about GUI?

[Ace17]

how about GUI?

this is for pk kill count only not pk steak

[ryruz]

this is for pk kill count only not pk steak

i mean GUI like this
http://prntscr.com/6zu2kg

[HolyShift]

i mean GUI like this
http://prntscr.com/6zu2kg

not needed on that and this script has no pk loss/death only kill

[Ace17]

not needed on that and this script has no pk loss/death only kill

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 ChaPKWIN=ChaPKWIN+1
    Where ChaNum=@nChaNum
    END
IF (@nType=3)
    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, @NbrightPoint, @nLifePoint, @nMoney)


    SET NOCOUNT OFF

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

[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,
    @NbrightPoint 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 (@nType=3)
    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, @NbrightPoint, @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