Auto increment ECoins based in PlayTime

Some guys have asked me how I do for self insert coins played for a while so I decided to post here what I did to insert a coin every 5horas online in the game.

To change the time you just change the number 18000 for an appropriate value for 18000 are five hours, 3600 seconds is one hour and so it goes ...

PS: The name of my column is ECoins of type int you do not have numbers broken

Code:

---

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


/* ??? ??? ?? ???? */
ALTER PROC [dbo].[spUpdateCharPlayTime]
  @PlayTimeInc    int,
  @CID            int
AS
SET NOCOUNT ON
DECLARE @ECoins int
DECLARE @AID int
SELECT @AID=AID FROM Character(nolock) WHERE CID = @CID

BEGIN

SELECT @ECoins = @PlayTimeInc / 18000

UPDATE Character
SET PlayTime=PlayTime+(@PlayTimeInc), LastTime=GETDATE()
WHERE CID=@CID

UPDATE Account
SET ECoins = ECoins+(@ECoins)
WHERE AID = @AID
END

---

Credits: Me :laugh:

@darkduxxxx
Owned. Stop being a child please.

@Robertinho
Thanks for the release o/
Very good work!

@mod
Ban darkduxxxx ^^

Nice one mate, Good job :)

Well, I'm sorry for the Google translator.
He wanted to know how you give more coins instead of one?

Quote:

---

Originally Posted by FlavitoBR

Well, I'm sorry for the Google translator.
He wanted to know how you give more coins instead of one?

---

Just use logic, 18000 seconds = 1 coin, if you want 2 coins each you put 9000 seconds

NVM not a bad idea already released previously though

Quote:

---

Originally Posted by phoenix_147

You're the real spammer here.

---

lol ,jalous , vitor = gunzking :w00t:

Quote:

---

Originally Posted by AllahAkbar

lol ,jalous , vitor = gunzking :w00t:

---

Not true.i mean its false.. lol

nice dude .

Quote:

---

Originally Posted by robertinh07

Some guys have asked me how I do for self insert coins played for a while so I decided to post here what I did to insert a coin every 5horas online in the game.

To change the time you just change the number 18000 for an appropriate value for 18000 are five hours, 3600 seconds is one hour and so it goes ...

PS: The name of my column is ECoins of type int you do not have numbers broken

Code:

---

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


/* ??? ??? ?? ???? */
ALTER PROC [dbo].[spUpdateCharPlayTime]
  @PlayTimeInc    int,
  @CID            int
AS
SET NOCOUNT ON
DECLARE @ECoins int
DECLARE @AID int
SELECT @AID=AID FROM Character(nolock) WHERE CID = @CID

BEGIN

SELECT @ECoins = @PlayTimeInc / 18000

UPDATE Character
SET PlayTime=PlayTime+(@PlayTimeInc), LastTime=GETDATE()
WHERE CID=@CID

UPDATE Account
SET ECoins = ECoins+(@ECoins)
WHERE AID = @AID
END

---

Credits: Me :laugh:

---

how to install ? teach me please xD
Como eu faso para instalar pode encina?:cool:

Quote:

---

Originally Posted by AllahAkbar

how to install ? teach me please xD
Como eu faso para instalar pode encina?:cool:

---

New query > ctrl + c > ctrl + v > execute (gunzdb)

Thanks , -

AFK in GAME with the room with pass = Free coins? xd

Thanx was searching for this..

Good Job