Auto Add coins for ijji site rip

[gregon13]

Well I was messing around with the DB modified a proc so every time you kill some one you get a coin :

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

I know I know this has been released here before but for the mpog site, I like this proc better and it seems to run smoothly with the gme

[MentaL]

[hotgame]

thanks dude :)

[Rodi[WWG]]

this has been released already.

and btw, change "coins" to your own coin table...

[SHEEN[GB]]

Thanks man, this is great!

[Joe9099]

i have a great idea for this, i have never thought of it haha, nice one man

[Phoenix]

Thanks a lot! I was looking for this. This system is there in HeroGamers GunZ.

[robertinh07]

work in server files 2008?

[Joe9099]

work in server files 2008?

I havnt seen the 2008 db, but i guess it could work if modified a bit, but i cant say for sure as i dont know what 2008 db is like

[robertinh07]

ok, don't work, when I put it, the kill count and death, did not work anymore.

@Gregon, know how to do this for files that runs on server 2008?

[PrØ]

Nice Idea. But Why we Need SomeThing Like It :P!!

[SHEEN[GB]]

Tested in 2008 files don't work :(

[robertinh07]

Work in files 2008 with some modifications ;D

[Anniversary]

great men thanks <3

[gregon13]

I use it with 2008 just fine

[peterflister]

Well I was messing around with the DB modified a proc so every time you kill some one you get a coin :

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,
  @Coins        int,
  @AID          int
AS
SET NOCOUNT ON

SELECT @Coins = @KillInc * 1
SELECT @AID=AID FROM Character(nolock) WHERE CID = @CID

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

I know I know this has been released here before but for the mpog site, I like this proc better and it seems to run smoothly with the gme

HI gregon,
please, add msn?
peter_net@msn.com
Thanks ! help me '-'