Idea?

[gowtham004]

is it possible to get coins on kill

Like 1 kill = 10 coins like that ??

 

[StephanW]

is it possible to get coins on kill

Like 1 kill = 10 coins like that ??

Yes, this is called bounty.
Each kill grants a player bounty (but it is not shown in the chatbox), quest gives bounty as well (as a lot of other PVE modes).

 

[gowtham004]

Yes, this is called bounty.
Each kill grants a player bounty (but it is not shown in the chatbox), quest gives bounty as well (as a lot of other PVE modes).

Yep the same, it is possible add *coins* also?

 

[xDividerx]

Yep the same, it is possible add *coins* also?

What do you mean by Coins? Can you show a screenshot of what you are talking about?

 

[Zer0nix]

i think he mean that every kill on character will get coins like a bounty in the game, if you killed some of characters or each character you will get bounty immediately.

 

[gowtham004]

What do you mean by Coins? Can you show a screenshot of what you are talking about?

No I mean when u kill some players u get bounty right like that we can add the coins to Database.

i think he mean that every kill on character will get coins like a bounty in the game, if you killed some of characters or each character you will get bounty immediately.

Exactly

 

[jorklenis2]

It does not matter.

USE [GunzDB]
GO
/** Kill for Coins **/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spUpdateCharInfoData]
-- ALTER PROC dbo.spUpdateCharInfoData
    [USER=369615]Cid[/USER]            INT,
    @XPInc            INT,
    @BPInc            INT,
    [USER=1731]KiLLi[/USER]nc        INT,
    [USER=401081]Death[/USER]Inc        INT,
    [USER=2000229413]Playtime[/USER]Inc    INT
AS BEGIN
    SET NOCOUNT ON;
DECLARE @ECoins int
DECLARE [USER=420555]Aid[/USER] int
SELECT [USER=420555]Aid[/USER]=AID FROM Character(nolock) WHERE CID = [USER=369615]Cid[/USER]

SELECT @ECoins = [USER=1731]KiLLi[/USER]nc * 1 
    UPDATE    dbo.Character
    SET        XP = XP + (@XPInc)
            , BP = BP + (@BPInc)
            , KillCount = KillCount +  [USER=1731]KiLLi[/USER]nc)
            , DeathCount = DeathCount +  [USER=401081]Death[/USER]Inc)
            , PlayTime = PlayTime +  [USER=2000229413]Playtime[/USER]Inc)
    WHERE    CID = [USER=369615]Cid[/USER];


UPDATE Account 
SET KillCoins=KillCoins+(@ECoins) 
WHERE AID [USER=420555]Aid[/USER]

ENDUSE [GunzDB]
GO
/** Kill for Coins **/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spUpdateCharInfoData]
-- ALTER PROC dbo.spUpdateCharInfoData
    [USER=369615]Cid[/USER]            INT,
    @XPInc            INT,
    @BPInc            INT,
    [USER=1731]KiLLi[/USER]nc        INT,
    [USER=401081]Death[/USER]Inc        INT,
    [USER=2000229413]Playtime[/USER]Inc    INT
AS BEGIN
    SET NOCOUNT ON;
DECLARE @ECoins int
DECLARE [USER=420555]Aid[/USER] int
SELECT [USER=420555]Aid[/USER]=AID FROM Character(nolock) WHERE CID = [USER=369615]Cid[/USER]

SELECT @ECoins = [USER=1731]KiLLi[/USER]nc * 1 
    UPDATE    dbo.Character
    SET        XP = XP + (@XPInc)
            , BP = BP + (@BPInc)
            , KillCount = KillCount +  [USER=1731]KiLLi[/USER]nc)
            , DeathCount = DeathCount +  [USER=401081]Death[/USER]Inc)
            , PlayTime = PlayTime +  [USER=2000229413]Playtime[/USER]Inc)
    WHERE    CID = [USER=369615]Cid[/USER];


UPDATE Account 
SET KillCoins=KillCoins+(@ECoins) 
WHERE AID [USER=420555]Aid[/USER]

END

 

[gowtham004]

It does not matter.

USE [GunzDB]
GO
/** Kill for Coins **/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spUpdateCharInfoData]
-- ALTER PROC dbo.spUpdateCharInfoData
    [USER=369615]Cid[/USER]            INT,
    @XPInc            INT,
    @BPInc            INT,
    [USER=1731]KiLLi[/USER]nc        INT,
    [USER=401081]Death[/USER]Inc        INT,
    [USER=2000229413]Playtime[/USER]Inc    INT
AS BEGIN
    SET NOCOUNT ON;
DECLARE @ECoins int
DECLARE [USER=420555]Aid[/USER] int
SELECT [USER=420555]Aid[/USER]=AID FROM Character(nolock) WHERE CID = [USER=369615]Cid[/USER]

SELECT @ECoins = [USER=1731]KiLLi[/USER]nc * 1 
    UPDATE    dbo.Character
    SET        XP = XP + (@XPInc)
            , BP = BP + (@BPInc)
            , KillCount = KillCount +  [USER=1731]KiLLi[/USER]nc)
            , DeathCount = DeathCount +  [USER=401081]Death[/USER]Inc)
            , PlayTime = PlayTime +  [USER=2000229413]Playtime[/USER]Inc)
    WHERE    CID = [USER=369615]Cid[/USER];


UPDATE Account 
SET KillCoins=KillCoins+(@ECoins) 
WHERE AID [USER=420555]Aid[/USER]

ENDUSE [GunzDB]
GO
/** Kill for Coins **/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spUpdateCharInfoData]
-- ALTER PROC dbo.spUpdateCharInfoData
    [USER=369615]Cid[/USER]            INT,
    @XPInc            INT,
    @BPInc            INT,
    [USER=1731]KiLLi[/USER]nc        INT,
    [USER=401081]Death[/USER]Inc        INT,
    [USER=2000229413]Playtime[/USER]Inc    INT
AS BEGIN
    SET NOCOUNT ON;
DECLARE @ECoins int
DECLARE [USER=420555]Aid[/USER] int
SELECT [USER=420555]Aid[/USER]=AID FROM Character(nolock) WHERE CID = [USER=369615]Cid[/USER]

SELECT @ECoins = [USER=1731]KiLLi[/USER]nc * 1 
    UPDATE    dbo.Character
    SET        XP = XP + (@XPInc)
            , BP = BP + (@BPInc)
            , KillCount = KillCount +  [USER=1731]KiLLi[/USER]nc)
            , DeathCount = DeathCount +  [USER=401081]Death[/USER]Inc)
            , PlayTime = PlayTime +  [USER=2000229413]Playtime[/USER]Inc)
    WHERE    CID = [USER=369615]Cid[/USER];


UPDATE Account 
SET KillCoins=KillCoins+(@ECoins) 
WHERE AID [USER=420555]Aid[/USER]

END

Thanks man jorklenis2

 

[ilmar18]

Thanks jorklenis2