Getting Auto Event Coins Per Kills ive searched Everywhere

[foeandfear]

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 :)

[MentaL]

[wayutok]

same to me

[Forean]

did you?

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

[ammw]

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

^-^ ....

[wesman2232]

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.