Converter

Hello, Does anyone know any method to convert to kill Count eucoins?
:thumbup:

With this, each kill will give you 1 eucoin.

PHP Code:

---

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

/* 캐릭터 정보(XP, BP, KillCount, DeathCount) 업데이트 */
ALTER PROC [dbo].[spUpdateCharInfoData]
  @XPInc        int,
  @BPInc        int,
  @KillInc      int,
  @DeathInc     int,
  @CID          int,
  @CIDCount     int,
  @AID          int
AS
SET NOCOUNT ON
  

SELECT @CIDCount=COUNT(*) FROM explock(nolock) WHERE CID=@CID
SELECT @AID = @AID FROM Character WHERE CID = @CID

If (@XPInc > 0 AND @CIDCount <> 1)
Begin
UPDATE Character 
SET XP=XP+(@XPInc), BP=BP+(@BPInc), KillCount=KillCount+(@KillInc), DeathCount=DeathCount+(@DeathInc)
WHERE CID=@CID
UPDATE Login SET euCoins = euCoins + 1 WHERE AID = @AID
End
else
Begin
UPDATE Character 
SET BP=BP+(@BPInc), KillCount=KillCount+(@KillInc), DeathCount=DeathCount+(@DeathInc)
WHERE CID=@CID
UPDATE Login SET euCoins = euCoins + 1 WHERE AID = @AID
End 


---

Quote:

---

Originally Posted by alfredao

With this, each kill will give you 1 eucoin.

PHP Code:

---

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

/* 캐릭터 정보(XP, BP, KillCount, DeathCount) 업데이트 */
ALTER PROC [dbo].[spUpdateCharInfoData]
  @XPInc        int,
  @BPInc        int,
  @KillInc      int,
  @DeathInc     int,
  @CID          int,
  @CIDCount     int,
  @AID          int
AS
SET NOCOUNT ON
  

SELECT @CIDCount=COUNT(*) FROM explock(nolock) WHERE CID=@CID
SELECT @AID = @AID FROM Character WHERE CID = @CID

If (@XPInc > 0 AND @CIDCount <> 1)
Begin
UPDATE Character 
SET XP=XP+(@XPInc), BP=BP+(@BPInc), KillCount=KillCount+(@KillInc), DeathCount=DeathCount+(@DeathInc)
WHERE CID=@CID
UPDATE Login SET euCoins = euCoins + 1 WHERE AID = @AID
End
else
Begin
UPDATE Character 
SET BP=BP+(@BPInc), KillCount=KillCount+(@KillInc), DeathCount=DeathCount+(@DeathInc)
WHERE CID=@CID
UPDATE Login SET euCoins = euCoins + 1 WHERE AID = @AID
End 


---

---

has a rate for it?
you can show how to use, test did not work here = (

Just run it in your GunzDB, each kill will give you a coin.

Quote:

---

Originally Posted by alfredao

Just run it in your GunzDB, each kill will give you a coin.

---

not changed at all, if you can tell more details, thanks

is to choose a type of game
Clan War example every 100 kills a Coin (or something)

Quote:

---

Originally Posted by tuiuiu

is to choose a type of game
Clan War example every 100 kills a Coin (or something)

---

I understand the system, but is not working on my db

Its not for clan war.

Open Microsoft SQL Management and press Ctrl + N and paste the code i posted.

http://174.36.245.66/alfredao/1.png

Select GunzDB in drop down then hit execute.

http://174.36.245.66/alfredao/2.png

Probably, you'll get a message like this. "Command(s) completed successfully."

http://174.36.245.66/alfredao/3.png

Now its supposed to work.

Remember, if your euCoins column isn't in login, change both "UPDATE Login SET euCoins = euCoins + 1 WHERE AID = @AID" to your own.

Quote:

---

Originally Posted by SPAIKE

excellent testing soon give feedback

---

I did exactly as you say, and nothing happens = (

Quote:

---

Originally Posted by SPAIKE

has a rate for it?
you can show how to use, test did not work here = (

---

Alfredão hey ​​I just notice that when I run your cod to dbo.Character does more of the ocntagem Killcount and DeathCount, you could review it please