Jump to content

sukesuka

Member
  • Content Count

    11
  • Joined

  • Last visited

  • Days Won

    1

sukesuka last won the day on May 22

sukesuka had the most liked content!

About sukesuka

  • Rank
    Regular

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. sukesuka

    Edit Map Portal

    @DeusEx wow very good. I tried to change to Platform01 and it also worked! MapIndex 10 (Platform01) MapIndexOnServer 8 (dpfrom_bellato_hq)
  2. sukesuka

    Edit Map Portal

    @Maree wow, thank you very much. after I changed 7 to 1, no error again. how do you know about this value? it's different from this -- Map Data -- -- 0 NeutralB -- 1 NeutralC -- 2 resources -- 3 NeutralA -- 4 NeutralBS1 -- 5 NeutralBS2 -- 6 NeutralCS1 -- 7 NeutralCS2 -- 8 NeutralAS1 -- 9 NeutralAS2 -- 10 Platform01 -- 11 Sette -- 12 Cauldron01 -- 13 Elan -- 14 Dungeon00 -- 15 Transport01 -- 16 Dungeon01 -- 17 AccGSD -- 18 BellaGSD -- 19 CoraGSD -- 20 AccGSP -- 21 BellaGSP -- 22 CoraGSP -- 23 Dungeon02 -- 24 Exile_Land -- 25 Mountain_Beast -- 26 Medicallab -- 27 Cora -- 28 Dungeon03 -- 29 Medicallab2 -- 30 Dungeon04 MapIndex is 27 means it's for map Cora (Hidden Land of Elf. but in Unknown is 1. does it mean map NeutralC? I dont understand. where do you get that value from? Hi, @Serafim . I'm sorry that I dont use Skype. Is it OK to use only forum?
  3. sukesuka

    Edit Map Portal

    Hi, @ravennvm which one should I match? I dont know it
  4. sukesuka

    Edit Map Portal

    Hello, I would like to know whether anyone knows the solution for the error I got. I want to change portal from Sette to Hidden Land of Elf in Bellato HQ. First, I did change Map.edf (dpgoto_Sette to dpgoto_Cora) Second, I changed PortDests MapIndex (11 to 27) Third, I changed Portal Name in NDMap.edf Fourth, I changed dpgoto_Sette to dpgoto_Cora in Neutral-[PORTAL].dat Fifth, I changed dpfrom_Sette to dpfrom_bellato_HQ in Cora-[PORTAL].spt Sixth, I added *dpgoto_Cora in NeutralB.spt Seventh, I added dpfrom_bellato_HQ in Cora.spt The result in game: Portal name has changed to Hidden Land of Elf But when I click the button, it shows an error The character didnt move to Hidden Land of Elf. But after logout, the character has been moved to Hidden Land of Elf. Please, help me. Any help would be much appreciated. Regards, sukesuka
  5. sukesuka

    CashCoin Regent /Level / Map

    you can use CASE statement rather than IF ELSE
  6. sukesuka

    CashCoin Regent /Level / Map

    yeah, it has bug at the first 5 minutes. it will update cash and TotalPlayMin as 4 minutes. not 5 minutes. but for next 5 minutes, it will update the cash coin constantly for 5 minutes. glad that it works on your server.
  7. sukesuka

    CashCoin Regent /Level / Map

    is it working now? cash regens?
  8. sukesuka

    CashCoin Regent /Level / Map

    you excecuted the sql successfully, right? no error during that process?
  9. sukesuka

    CashCoin Regent /Level / Map

    I'm using Database from Fyurith (I cant remember forum where I got from)
  10. sukesuka

    CashCoin Regent /Level / Map

    Hi @ErlBinary, I've tried to login and logout but nothing happen. Maybe I've mistaken to understand what you said
  11. sukesuka

    CashCoin Regent /Level / Map

    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 USE [RF_World] -- ================================================ -- Pembuat : <Hanry Roslaw Saputra> -- Dibuat Tanggal : <13 April 2014> -- Keterangan : <Trigger AutoCash Version 1.2> -- ================================================ ALTER TABLE [dbo].[tbl_base] ADD LogPlay INT NOT NULL DEFAULT ((0)) 2. Create A Procedure to Save TotalPlayMin as LogPlay USE [RF_World] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ================================================ -- Pembuat : <Hanry Roslaw Saputra> -- Dibuat Tanggal : <13 April 2014> -- Keterangan : <Prosedur AutoCash Version 1.2> -- ================================================ CREATE PROCEDURE [dbo].[pUpdate_LogPlay] @serial INT, @logPlay INT AS BEGIN SET NOCOUNT ON UPDATE [dbo].[tbl_base] SET LogPlay = @logPlay WHERE Serial = @serial END GO 3. Create A Procedure to Add Cash Coin and Check Current Map. USE [Billing] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ================================================ -- Pembuat : <Hanry Roslaw Saputra> -- Dibuat Tanggal : <13 April 2014> -- Keterangan : <Prosedur AutoCash Version 1.2> -- ================================================ CREATE PROCEDURE [dbo].[RF_RegenCash] @id VARCHAR(17), @cash INT, @serial INT AS BEGIN declare @rate int declare @status int declare @map int declare @currentmap int set @rate='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 [email protected]) if @[email protected] begin if exists (select id from billing.dbo.tbl_UserStatus where id [email protected]) begin set @status=(select status from BILLING.dbo.tbl_UserStatus where [email protected]) if @status = 2 begin update billing.dbo.tbl_UserStatus set cash=cash+(@cash*@rate) where [email protected] end else begin update billing.dbo.tbl_UserStatus set [email protected] where [email protected] end end else begin insert into billing.dbo.tbl_UserStatus(id,status,Cash) values(@id,1,@cash) end end END GO 4. Create A Trigger to Update Cash Coin Per 5 Minutes -- ================================================ -- Pembuat : <Hanry Roslaw Saputra> -- Dibuat Tanggal : <13 April 2014> -- Keterangan : <Trigger AutoCash Version 1.2> -- ================================================ 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 @regencash INT declare @cash int set @cash='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 @regencash = ((@[email protected])*@cash) IF @regencash > 0 BEGIN EXEC [Billing].[dbo].[RF_RegenCash] @[email protected],@[email protected],@[email protected] EXEC [RF_World].[dbo].[pUpdate_LogPlay] @[email protected],@[email protected] 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.
×
×
  • Create New...