Auto Add coins for ijji site rip

Quote:

---

Originally Posted by gregon13

I use it with 2008 just fine

---

Odd, I've executed it to my GunzDB and no coins get added to my account, and yes I am using ijji web files.

i think thaths not a good idea for everykill a coin lol

u swap 100 times and u can get almost 2 shotguns lol.... for donaters wtf but u can change it so i rate it

10/10

Hmm i just tested this and its also not working for me :/

ye I just noticed I gave you guys the wrong one, I fixed it, look at the OP and try the new one

Remember : Create column "coins" in dbo.Account

Quote:

---

Originally Posted by xD?

USE [GunzDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

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 test in 08 files = work fine

Why is needed to multiply @Coins by 1? lol

Quote:

---

Originally Posted by alfredao

Why is needed to multiply @Coins by 1? lol

---

What do you mean? I have it set so it gives you one coin per kill

What about a script that gives you 1 coin every hour you are online ingame ?

Hello, one question what table need modific or just run the query and ready? :?:

Thanks ^^

nice code :W

Quote:

---

Originally Posted by Trilest

What about a script that gives you 1 coin every hour you are online ingame ?

---

you can do that as well just don't remember how