[Release] AutoCashPoint new version with All Character fix get Regen Cash

sadi · Jul 3, 2015

FeralXan said:
for step 4 i found error like this :
Msg 102, Level 15, State 1, Procedure AutocashRoslaw, Line 36
Incorrect syntax near ')'.

Get the same error

dodojimbun · Jul 3, 2015

IF regencash > 0)

IF regencash > 0

sadi · Jul 4, 2015

dodojimbun said:
IF regencash > 0)

IF regencash > 0

According to your reply

I have resolved

Thank you Sir

ROSLAW · Jul 8, 2015

The problem is from Ragezone auto-spell

Code:

Some query changed to another language. sorry.

agoenk · Jul 8, 2015

Thank a lot sir, but how to make autocash in cash/5minutes or more? Not in 1minute

FeralXan · Jul 10, 2015

oh ya, why i found @ my rf private.

not all player get autocash regen.

can you help me sir roslaw

agoenk · Jul 13, 2015

May be in register.php must connected to Billing

Btw cant regent for new player or ?

FeralXan · Jul 15, 2015

agoenk said:
May be in register.php must connected to Billing
Btw cant regent for new player or ?

last player sir. sorry bad english.

Killerwoody · Feb 28, 2016

I'd like to see the release for amount per map! Seen on Indo servers using it!

kazueta · Mar 24, 2016

sir ROSLAW
my query not show error but not working in game its still 0 cash point :$:
all ini file NATION = RU and i use BILLING RU
how to fix this???

thank's
sory for my bad english sir

agoenk · Mar 27, 2016

kazueta said:
sir ROSLAW
my query not show error but not working in game its still 0 cash point :$:
all ini file NATION = RU and i use BILLING RU
how to fix this???

thank's
sory for my bad english sir

try to connect BILLING db in register.php script too

ginno44 · Apr 22, 2016

the script is working out, i check on database the cash has increased but why cash in game still 0 ?
I already have set all my .ini to RU

---

solved after use RShield zoneserver
thanks ROSLAW

spayderbr · Jun 20, 2018

After installing in the database, all players take disconect after 5 or 7 minutes logged in

sukesuka · May 22, 2019

Hi,
I tried this in my little server that using RU nation database
These sqls will regen your cash coin for premium and non-premium user. it will multiply your cash coin if user's status is a premium user. It also checks current map to regen. You can remove it if you want to regen your cash coin in every map. You also can add level or other check.
Remove previous table, procedure and trigger before use these sql codes.

1. Create A Table for LogPlay

Code:

USE [RF_World]

-- ================================================
-- Pembuat             : [COLOR=#000088]<Hanry[/COLOR] [COLOR=#660066]Roslaw[/COLOR] [COLOR=#660066]Saputra[/COLOR][COLOR=#000088]>[/COLOR]
-- Dibuat Tanggal    : <13 April 2014>
-- Keterangan        : [COLOR=#000088]<Trigger[/COLOR] [COLOR=#660066]AutoCash[/COLOR] [COLOR=#660066]Version[/COLOR] 1.2[COLOR=#000088]>[/COLOR]
-- ================================================

ALTER TABLE [dbo].[tbl_base]
ADD LogPlay INT NOT NULL DEFAULT ((0))

2. Create A Procedure to Save TotalPlayMin as LogPlay

Code:

USE [RF_World]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- ================================================
-- Pembuat : [COLOR=#000088]<Hanry[/COLOR] [COLOR=#660066]Roslaw[/COLOR] [COLOR=#660066]Saputra[/COLOR][COLOR=#000088]>[/COLOR]
-- Dibuat Tanggal : <13 April 2014>
-- Keterangan : [COLOR=#000088]<Prosedur[/COLOR] [COLOR=#660066]AutoCash[/COLOR] [COLOR=#660066]Version[/COLOR] 1.2[COLOR=#000088]>[/COLOR]
-- ================================================

CREATE PROCEDURE [dbo].[pUpdate_LogPlay]
@[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I] INT,
@[I][B][URL="http://forum.ragezone.com/members/2000163149.html"]log[/URL][/B][/I]Play INT
AS
BEGIN
SET NOCOUNT ON
UPDATE [dbo].[tbl_base]
SET LogPlay = @[I][B][URL="http://forum.ragezone.com/members/2000163149.html"]log[/URL][/B][/I]Play
WHERE Serial = @[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I]
END
GO

3. Create A Procedure to Add Cash Coin and Check Current Map.

Code:

USE [Billing]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- ================================================
-- Pembuat : [COLOR=#000088]<Hanry[/COLOR] [COLOR=#660066]Roslaw[/COLOR] [COLOR=#660066]Saputra[/COLOR][COLOR=#000088]>[/COLOR]
-- Dibuat Tanggal : <13 April 2014>
-- Keterangan : [COLOR=#000088]<Prosedur[/COLOR] [COLOR=#660066]AutoCash[/COLOR] [COLOR=#660066]Version[/COLOR] 1.2[COLOR=#000088]>[/COLOR]
-- ================================================

CREATE PROCEDURE [dbo].[RF_RegenCash]
@[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I] VARCHAR(17),
@[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h INT,
@[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I] INT
AS
BEGIN
declare @[I][B][URL="http://forum.ragezone.com/members/1333430432.html"]Rat[/URL][/B][/I]e int
declare @status int
declare @map int
declare @currentmap int

set @[I][B][URL="http://forum.ragezone.com/members/1333430432.html"]Rat[/URL][/B][/I]e='2' -- multiply your cash coin for Premium user
set @map='11' -- map code for Sette

SET NOCOUNT ON
set @currentmap=(select map from RF_World.dbo.tbl_general where Serial @[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I])
if @currentmap=@map
begin
if exists (select id from billing.dbo.tbl_UserStatus where id @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I])
begin
set @status=(select status from BILLING.dbo.tbl_UserStatus where id @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I])
if @status = 2
begin
update billing.dbo.tbl_UserStatus set cash=cash+ @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h @[I][B][URL="http://forum.ragezone.com/members/1333430432.html"]Rat[/URL][/B][/I]e) where id @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I]
end else
begin
update billing.dbo.tbl_UserStatus set cash=cash @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h where id @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I]
end
end else
begin
insert into billing.dbo.tbl_UserStatus(id,status,Cash)
values @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I],1 @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h)
end
end
END
GO

4. Create A Trigger to Update Cash Coin Per 5 Minutes

Code:

-- ================================================
-- Pembuat : [COLOR=#000088]<Hanry[/COLOR] [COLOR=#660066]Roslaw[/COLOR] [COLOR=#660066]Saputra[/COLOR][COLOR=#000088]>[/COLOR]
-- Dibuat Tanggal : <13 April 2014>
-- Keterangan : [COLOR=#000088]<Trigger[/COLOR] [COLOR=#660066]AutoCash[/COLOR] [COLOR=#660066]Version[/COLOR] 1.2[COLOR=#000088]>[/COLOR]
-- ================================================
USE [RF_World]
GO
/****** Object: Trigger [dbo].[RF_TimeUpdate] Script Date: 06/02/2016 19:37:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[RegenCash]
ON [dbo].[tbl_general]
AFTER UPDATE

as
begin
SET NOCOUNT ON;
DECLARE @GSerial INT
DECLARE @GPlay INT
DECLARE @BSerial INT
DECLARE @BAccount VARCHAR(17)
DECLARE @BPlay INT
DECLARE @[I][B][URL="http://forum.ragezone.com/members/807898.html"]regenc[/URL][/B][/I]ash INT
declare @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h int
set @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h='100' -- amount for your cash coin per minute


IF UPDATE(TotalPlayMin)
BEGIN
SELECT @GSerial = Serial,@GPlay = TotalPlayMin FROM INSERTED
SELECT @BSerial = Serial,@BAccount=account, @BPlay = LogPlay FROM [dbo].[tbl_base] WHERE Serial = @GSerial
SELECT @[I][B][URL="http://forum.ragezone.com/members/807898.html"]regenc[/URL][/B][/I]ash = ((@GPlay-@BPlay) @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h)
IF @[I][B][URL="http://forum.ragezone.com/members/807898.html"]regenc[/URL][/B][/I]ash > 0
BEGIN
EXEC [Billing].[dbo].[RF_RegenCash] @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I]=@BAccount @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h @[I][B][URL="http://forum.ragezone.com/members/807898.html"]regenc[/URL][/B][/I]ash @[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I]=@Gserial
EXEC [RF_World].[dbo].[pUpdate_LogPlay] @[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I]=@GSerial @[I][B][URL="http://forum.ragezone.com/members/2000163149.html"]log[/URL][/B][/I]Play=@GPlay
END 
END
END

I don't know if it will works on your server. I've tried this for 1 hour and got not disconnected from server. But my server is very little.
You may edit this to improve.

likertuban · May 22, 2019

sukesuka said:

Hi,
I tried this in my little server that using RU nation database
These sqls will regen your cash coin for premium and non-premium user. it will multiply your cash coin if user's status is a premium user. It also checks current map to regen. You can remove it if you want to regen your cash coin in every map. You also can add level or other check.
Remove previous table, procedure and trigger before use these sql codes.

1. Create A Table for LogPlay

Code:

USE [RF_World]

-- ================================================
-- Pembuat             : [COLOR=#000088]<Hanry[/COLOR] [COLOR=#660066]Roslaw[/COLOR] [COLOR=#660066]Saputra[/COLOR][COLOR=#000088]>[/COLOR]
-- Dibuat Tanggal    : <13 April 2014>
-- Keterangan        : [COLOR=#000088]<Trigger[/COLOR] [COLOR=#660066]AutoCash[/COLOR] [COLOR=#660066]Version[/COLOR] 1.2[COLOR=#000088]>[/COLOR]
-- ================================================

ALTER TABLE [dbo].[tbl_base]
ADD LogPlay INT NOT NULL DEFAULT ((0))

2. Create A Procedure to Save TotalPlayMin as LogPlay

Code:

USE [RF_World]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- ================================================
-- Pembuat : [COLOR=#000088]<Hanry[/COLOR] [COLOR=#660066]Roslaw[/COLOR] [COLOR=#660066]Saputra[/COLOR][COLOR=#000088]>[/COLOR]
-- Dibuat Tanggal : <13 April 2014>
-- Keterangan : [COLOR=#000088]<Prosedur[/COLOR] [COLOR=#660066]AutoCash[/COLOR] [COLOR=#660066]Version[/COLOR] 1.2[COLOR=#000088]>[/COLOR]
-- ================================================

CREATE PROCEDURE [dbo].[pUpdate_LogPlay]
@[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I] INT,
@[I][B][URL="http://forum.ragezone.com/members/2000163149.html"]log[/URL][/B][/I]Play INT
AS
BEGIN
SET NOCOUNT ON
UPDATE [dbo].[tbl_base]
SET LogPlay = @[I][B][URL="http://forum.ragezone.com/members/2000163149.html"]log[/URL][/B][/I]Play
WHERE Serial = @[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I]
END
GO

3. Create A Procedure to Add Cash Coin and Check Current Map.

Code:

USE [Billing]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- ================================================
-- Pembuat : [COLOR=#000088]<Hanry[/COLOR] [COLOR=#660066]Roslaw[/COLOR] [COLOR=#660066]Saputra[/COLOR][COLOR=#000088]>[/COLOR]
-- Dibuat Tanggal : <13 April 2014>
-- Keterangan : [COLOR=#000088]<Prosedur[/COLOR] [COLOR=#660066]AutoCash[/COLOR] [COLOR=#660066]Version[/COLOR] 1.2[COLOR=#000088]>[/COLOR]
-- ================================================

CREATE PROCEDURE [dbo].[RF_RegenCash]
@[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I] VARCHAR(17),
@[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h INT,
@[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I] INT
AS
BEGIN
declare @[I][B][URL="http://forum.ragezone.com/members/1333430432.html"]Rat[/URL][/B][/I]e int
declare @status int
declare @map int
declare @currentmap int

set @[I][B][URL="http://forum.ragezone.com/members/1333430432.html"]Rat[/URL][/B][/I]e='2' -- multiply your cash coin for Premium user
set @map='11' -- map code for Sette

SET NOCOUNT ON
set @currentmap=(select map from RF_World.dbo.tbl_general where Serial @[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I])
if @currentmap=@map
begin
if exists (select id from billing.dbo.tbl_UserStatus where id @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I])
begin
set @status=(select status from BILLING.dbo.tbl_UserStatus where id @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I])
if @status = 2
begin
update billing.dbo.tbl_UserStatus set cash=cash+ @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h @[I][B][URL="http://forum.ragezone.com/members/1333430432.html"]Rat[/URL][/B][/I]e) where id @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I]
end else
begin
update billing.dbo.tbl_UserStatus set cash=cash @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h where id @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I]
end
end else
begin
insert into billing.dbo.tbl_UserStatus(id,status,Cash)
values @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I],1 @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h)
end
end
END
GO

4. Create A Trigger to Update Cash Coin Per 5 Minutes

Code:

-- ================================================
-- Pembuat : [COLOR=#000088]<Hanry[/COLOR] [COLOR=#660066]Roslaw[/COLOR] [COLOR=#660066]Saputra[/COLOR][COLOR=#000088]>[/COLOR]
-- Dibuat Tanggal : <13 April 2014>
-- Keterangan : [COLOR=#000088]<Trigger[/COLOR] [COLOR=#660066]AutoCash[/COLOR] [COLOR=#660066]Version[/COLOR] 1.2[COLOR=#000088]>[/COLOR]
-- ================================================
USE [RF_World]
GO
/****** Object: Trigger [dbo].[RF_TimeUpdate] Script Date: 06/02/2016 19:37:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[RegenCash]
ON [dbo].[tbl_general]
AFTER UPDATE

as
begin
SET NOCOUNT ON;
DECLARE @GSerial INT
DECLARE @GPlay INT
DECLARE @BSerial INT
DECLARE @BAccount VARCHAR(17)
DECLARE @BPlay INT
DECLARE @[I][B][URL="http://forum.ragezone.com/members/807898.html"]regenc[/URL][/B][/I]ash INT
declare @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h int
set @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h='100' -- amount for your cash coin per minute


IF UPDATE(TotalPlayMin)
BEGIN
SELECT @GSerial = Serial,@GPlay = TotalPlayMin FROM INSERTED
SELECT @BSerial = Serial,@BAccount=account, @BPlay = LogPlay FROM [dbo].[tbl_base] WHERE Serial = @GSerial
SELECT @[I][B][URL="http://forum.ragezone.com/members/807898.html"]regenc[/URL][/B][/I]ash = ((@GPlay-@BPlay) @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h)
IF @[I][B][URL="http://forum.ragezone.com/members/807898.html"]regenc[/URL][/B][/I]ash > 0
BEGIN
EXEC [Billing].[dbo].[RF_RegenCash] @[I][B][URL="http://forum.ragezone.com/members/19862.html"]id[/URL][/B][/I]=@BAccount @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h @[I][B][URL="http://forum.ragezone.com/members/807898.html"]regenc[/URL][/B][/I]ash @[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I]=@Gserial
EXEC [RF_World].[dbo].[pUpdate_LogPlay] @[I][B][URL="http://forum.ragezone.com/members/445157.html"]serial[/URL][/B][/I]=@GSerial @[I][B][URL="http://forum.ragezone.com/members/2000163149.html"]log[/URL][/B][/I]Play=@GPlay
END 
END
END

I don't know if it will works on your server. I've tried this for 1 hour and got not disconnected from server. But my server is very little.
You may edit this to improve.

I suggest not to use map in sql query, because it's not updated in real time, and sometimes you even got wrong map in sql (if I remember correctly)

thanks for sharing anyway

sukesuka · May 22, 2019

yes you are right. I tried using map checking and the zone updated the sql every 5 minutes if you always stay in the game. but if you logout, zone will update it as fast as it can. I can say that this is a bug. if you stay in the game in required map for 4 minutes then do teleport to non-required map, you wont get the cash coin at all. I dont find the solution yet

paoxbr · Aug 1, 2019

I made this crap code to fix my problem that was not having data on tbl userstatus,can someone help me make it better?

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

CREATE TRIGGER dbo.UserStatusUpdater
ON dbo.tbl_base
AFTER INSERT AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Just INSERT everything from the [inserted] pseudotable into
--the target table
INSERT INTO [BILLING].dbo.tbl_UserStatus
(id, Status, DTStartPrem, DTEndPrem, Cash, Bonus)
SELECT Account, '1', '2019-08-01 13:04:12.400','2019-08-01 13:04:12.400', '1','0'
FROM inserted
WHERE Account NOT IN (SELECT id FROM [BILLING].dbo.tbl_UserStatus);

END
GO

Welcome!

[Release] AutoCashPoint new version with All Character fix get Regen Cash

sadi

Experienced Elementalist

dodojimbun

no failure, no greget!

sadi

Experienced Elementalist

ROSLAW

Skilled Illusionist

agoenk

Junior Spellweaver

FeralXan

Newbie Spellweaver

agoenk

Junior Spellweaver

FeralXan

Newbie Spellweaver

Killerwoody

Bored

kazueta

Junior Spellweaver

agoenk

Junior Spellweaver

ginno44

Newbie Spellweaver

spayderbr

Newbie Spellweaver

sukesuka

Initiate Mage

likertuban

Moderator

sukesuka

Initiate Mage

paoxbr

Junior Spellweaver

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor