Jump to content
RF-Dev | RF Online Development

byou

Member
  • Content Count

    38
  • Joined

  • Last visited

  • Days Won

    2

byou last won the day on August 15

byou had the most liked content!

About byou

  • Rank
    Regular

Recent Profile Visitors

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

  1. This query return error EDIT: NVM, just need to change " to '
  2. byou

    RF Online versions

    to see level cap just open exp.dat
  3. byou

    CashCoin Regent /Level / Map

    Yes, the queries that posted by the OP is incomplete. But i think the one that I posted can be used. But it seems like no one used it
  4. I'm also using VM as my dev server. I run my client at my host machine and the VM network configuration is set to host only, so the host and the VM can communicate using class c ip address.
  5. byou

    Install SQL Server 2008 R2

    you can use any version of SQL Server. somehow rfacc.ini ignored the user and password, no matter what you input, that file only using the DSN to refer to whatever you inputted at ODBC settings.
  6. byou

    Edit User Interface

    I think this is good for you reference https://www.behance.net/gallery/35459961/RF-Online-Interface-Vanadium
  7. byou

    All Race Tax Rate always at 10%

    Thanks for response. I already checked tbl_economy_history, all of the values (12 values) are by default when i'm running the SQL query. oh i'm using 2.2.3.2 that released here by Ron.
  8. byou

    Help how to remove empty bytes

    CGameServerDoc Error - NetworkInit() == false ==> cant initialize network (or connection to accountDB?) Error - CGameServerView::OnCreate(...) : ==> cannot create world since it cannot initialize Recheck your .ini files
  9. byou

    RF Server & DB Server

    So I got my server up running, just in case there is someone in this forum wanted to try this configuration For Virtual Machine and OS i use this: Proxmox latest version Windows Server 2012 R2 SQL Server 2012 SP1 My Configuration, RF Server : 1 VM using Windows Server 2012 R2. This will be the server that run all server files and the launcher emulator. DB Server : 1 VM using WIndows Server 2012 R2. This will be my DB Server and Domain controller. Yes a Domain Controller, I only managed to get things running by joining both the rf server and db server in a domain. How about the detailed configuration (ODBC, port forwarding, etc)? There's so much configuration and I'm too lazy to write it here, but most of it can be found on google. Please feel free to discuss in this thread further.
  10. byou

    RF Server & DB Server

    I'm curious, is anyone here ever tried configure a 2 separate server for the RF Server it self and a DB Server? I'm trying to build 2 server using VM both are using OS Win2K12R2 and the DB Server using SQL Server 2012 SP1. Here is the issue that I found so far, even though I correctly setup my ODBC (tested & conected), AccountServerSD seems to always changing my ODBC and add ",61433" into server name (ex. sqlserv,61433). This is causing the account server always throw the infamous "accountDB failed". Tried using windows authentication and sql authentication and also running the account server normaly and run as admin, all resulting with the same changing the server name. OR is this because of the OS? since RF server software is quite old... Please share your experience and discuss, thanks...
  11. byou

    All Race Tax Rate always at 10%

    no one knows?
  12. byou

    Offset to fix GM access backdoor

    is this for zone server?
  13. Just like the title said. I have been running the server for 2 weeks and the tax rate for all of the race is always 10%. Anyone knows what the issue is? Any help or suggestions is really appreciated.
  14. byou

    Help Me Edit Item.edf

    Do you familiar with STRS? I saw your post about increasing max level so I assumed you familiar with editing .dat and .edf There are item.strs available in the release section that have a clear section and column name/description. I think you should start there....
  15. byou

    CashCoin Regent /Level / Map

    I'm bored....so I modified this script that originally made by @Roslaw all credits to him. I add some change to check Map and Level. I don't know if this script is working or not, or what impact this is on server load. Please post here if this is working, thanks. 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)) 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_RoslawBase] @serial INT, @logPlay INT AS BEGIN SET NOCOUNT ON UPDATE [dbo].[tbl_base] SET LogPlay = @logPlay WHERE Serial = @serial END GO 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_AutocashRoslaw] @id VARCHAR(17), @cash INT AS BEGIN SET NOCOUNT ON UPDATE [dbo].[tbl_UserStatus] SET Cash = (Cash + @cash) WHERE id = @id END GO USE [RF_World] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ================================================ -- Pembuat : <Hanry Roslaw Saputra> -- Dibuat Tanggal : <13 April 2014> -- Keterangan : <Trigger AutoCash Version 1.2> -- ================================================ CREATE TRIGGER [dbo].[AutocashRoslaw] ON [dbo].[tbl_general] FOR UPDATE AS BEGIN SET NOCOUNT ON DECLARE @GSerial INT DECLARE @GDCK BIT DECLARE @GPlay INT DECLARE @GMap INT DECLARE @BSerial INT DECLARE @BDCK BIT DECLARE @BAccount VARCHAR(17) DECLARE @BLevel INT DECLARE @BPlay INT DECLARE @BMap INT DECLARE @regencash INT IF UPDATE(TotalPlayMin) BEGIN SELECT @GSerial = Serial, @GDCK = DCK, @GPlay = TotalPlayMin, @GMap = Map FROM INSERTED IF (@GSerial > 0 AND @GDCK = 0 AND @GMap = 10) BEGIN SELECT @BSerial = Serial, @BDCK = DCK, @BAccount = Account, @BLevel = Lv, @BPlay = LogPlay FROM [dbo].[tbl_base] WHERE Serial = @GSerial IF (@BSerial > 0 AND @BDCK = 0 AND @BLevel >= 40) BEGIN SELECT @regencash = ((@GPlay - @BPlay)*10) IF @regencash > 0 BEGIN EXEC [Billing].[dbo].[RF_AutocashRoslaw] @id = @BAccount, @cash = @regencash EXEC [RF_World].[dbo].[pUpdate_RoslawBase] @serial = @GSerial, @logPlay = @GPlay END END END END END GO
×