Jump to content
RF-Dev | RF Online Development

byou

Member
  • Content count

    34
  • Joined

  • Last visited

  • Days Won

    2
  1. 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.
  2. Edit User Interface

    I think this is good for you reference https://www.behance.net/gallery/35459961/RF-Online-Interface-Vanadium
  3. 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.
  4. 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
  5. 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.
  6. 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...
  7. All Race Tax Rate always at 10%

    no one knows?
  8. Offset to fix GM access backdoor

    is this for zone server?
  9. 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.
  10. 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....
  11. 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 = ((@[email protected])*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
  12. CashCoin Regent /Level / Map

    I think this procedure can be removed, since it is just log updating CMIIW
  13. CashCoin Regent /Level / Map

    SET @TimeDiff = @*G*P*l*a*y-*@*B*Play remove the *
  14. Cash Shop and Cash Coin for 2.2.3.2

    Looks like I solved my issue by using a tools from RZ. basically this tools is helping to sync value based on StoreList.dat
  15. Race Economy

    Has anyone ever been fiddling with the race economy manually? ex. through tbl_economy_history or worldsystem.ini To be honest, I don't know how the tax rate mechanics in this game works.
×