Newbie Spellweaver
- Joined
- Apr 1, 2017
- Messages
- 47
- Reaction score
- 1
is it possible to get coins on kill
Like 1 kill = 10 coins like that ??
Like 1 kill = 10 coins like that ??
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
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).
What do you mean by Coins? Can you show a screenshot of what you are talking about?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?
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.
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
It does not matter.
Code: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