Getting Auto Event Coins Per Kills ive searched Everywhere

Hello does anyone have the sql script for this because ive been searching for 2 days now i cant find it >< please and thank you :)

same to me

did you?

http://forum.ragezone.com/f311/1-win-1-coins-745566/

Quote:

---

Originally Posted by adz28

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
AS
SET NOCOUNT ON

DECLARE @Coins int
DECLARE @AID int
SELECT @AID=AID FROM Character(nolock) WHERE CID = @CID

SELECT @Coins = @KillInc * 1

UPDATE Character
SET XP=XP+(@XPInc), BP=BP+(@BPInc), KillCount=KillCount+(@KillInc), DeathCount=DeathCount+(@DeathInc)
WHERE CID=@CID

UPDATE Account
SET Coins=Coins+(@Coins)
WHERE AID=@AID

---

---

^-^ ....

There's a whole thread somewhere on here. You didn't search good enough, unless it's gone/deleted. I'll probably find it later.