- Joined
- Oct 3, 2011
- Messages
- 832
- Reaction score
- 155
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.
I also have the Kill for Coins and Clan War points for coins, you can contact me.
Note: if they sold you this, it will turn out that you were scammed because it is already public.
Code:
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.