Auto Add coins for ijji site rip

[SHEEN[GB]]

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.

[Anniversary]

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

[Joe9099]

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

[gregon13]

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

[corrado]

Remember : Create column "coins" in dbo.Account

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

[alfredao]

Why is needed to multiply @Coins by 1? lol

[gregon13]

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

[Trilest]

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

[victordav]

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

[Sir Creative]

Thanks ^^

[Kanoru]

nice code :W

[gregon13]

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