¨´[Query] Receive Coins for Hours Our Minutes

[jorklenis2]

When executing this query in your database, the characters receive coins automatically, it's up to you to do what you want with it and interact, it's suitable for everyone.

Note: if they sold you this, it will turn out that you were scammed because it is already public.

USE [GunzDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spUpdateCharPlayTime]
   [USER=2000229413]Playtime[/USER]Inc    int,
   [USER=369615]Cid[/USER]            int
AS
SET NOCOUNT ON
DECLARE @Coins int
DECLARE  [USER=420555]Aid[/USER] int
SELECT  [USER=420555]Aid[/USER]=AID FROM Character(nolock) WHERE CID =  [USER=369615]Cid[/USER]

BEGIN

SELECT @Coins =  [USER=2000229413]Playtime[/USER]Inc / 18000 /* Time add here*/

UPDATE Character 
SET PlayTime=PlayTime+  [USER=2000229413]Playtime[/USER]Inc), LastTime=GETDATE() 
WHERE CID  [USER=369615]Cid[/USER]

UPDATE Account 
SET Coins = Coins+(@Coins) 
WHERE AID =  [USER=420555]Aid[/USER]
END

I also have the Kill for Coins and Clan War points for coins, you can contact me.