Auto Add coins for ijji site rip

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

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

---

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

thanks dude :)

this has been released already.

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

Thanks man, this is great!

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

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

work in server files 2008?

Quote:

---

Originally Posted by robertinh07

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

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?

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

Tested in 2008 files don't work :(

Work in files 2008 with some modifications ;D

great men thanks <3

I use it with 2008 just fine

Quote:

---

Originally Posted by gregon13

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

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,
  @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 '-'