Jump to content
RF-Dev | RF Online Development

Roslaw

Member
  • Content count

    24
  • Joined

  • Last visited

  • Days Won

    3

Roslaw last won the day on February 2

Roslaw had the most liked content!

4 Followers

About Roslaw

  • Rank
    Regular

Recent Profile Visitors

513 profile views
  1. Best Zone Protection

    Dev-Corp is good enough for all you need in RF Private Server. I have alot of server using Dev-Corp Protection and Cerberus Protection. They are both is good in terms of protect your server from cheat activity. Dev-Corp prices is USD 400 - USD 600 for 6 months and 1 years License of use. Cerberus prices is USD 2000 - USD 3000 for permanent use and 1 years update / supports.
  2. roslaw bom dia poderia me passar a query 

    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].[RF_TimeUpdate]
        ON [dbo].[tbl_general]
        AFTER 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 @BAccountSerial INT;
        DECLARE @BAccountName VARCHAR(17);
        DECLARE @BLevel INT;
        DECLARE @BLogLevel INT;
        DECLARE @BPlay INT;
        
        DECLARE @TimeDiff INT;
        
        -- Binding Refresh Update for Column TotalPlayMin on tbl_general.
        IF UPDATE([TotalPlayMin])
        BEGIN
            SELECT
                @GSerial = [Serial],
                @GDCK = [DCK],
                @GPlay = [TotalPlayMin],
                @GMap = [Map]
            FROM INSERTED
            
            IF (@GSerial > 0 AND @GDCK = 0)
            BEGIN
                SELECT
                    @BSerial = [Serial],
                    @BDCK = [DCK],
                    @BAccountSerial = [AccountSerial],
                    @BAccountName = [Account],
                    @BLevel = [Lv],
                    @BLogLevel = [LogLevel],
                    @BPlay = [LogPlay]
                FROM [dbo].[tbl_base]
                WHERE [Serial] = @GSerial
                
                -- Calculating Time Different OldTimePlay and CurrentTimePlay.
                SET @TimeDiff = @[email protected]
                
                IF (@BSerial > 0 AND @BPlay > 0 AND @BLogLevel > 0 AND @BDCK = 0)
                BEGIN
                    -- Executing Procedure RF_Autocash to Update Cashpoint Formula.
                    EXEC [BILLING].[dbo].[RF_Autocash]
                                            @AName = @BAccountName,
                                            @ALevel = @BLevel,
                                            @ALevelLog = @BLogLevel,
                                            @ATimeDiff = @TimeDiff,
                                            @AMap = @GMap
                END
                
                IF (@BLogLevel < 1)
                BEGIN
                    SET @BLevel = 1
                END
                
                -- Executing Procedure RF_LogTime to Update Log.
                EXEC [RF_WORLD].[dbo].[RF_LogTime]
                                        @USerial = @GSerial,
                                        @UTimePlay = @GPlay,
                                        @ULevel = @BLevel
            END    
        END
    END

     

    1. hbsilva3

      hbsilva3

      Msg 207, Level 16, State 1, Procedure RF_TimeUpdate, Line 42
      Invalid column name 'LogLevel'.
       

  3. CashCoin Regent /Level / Map

    They even do this lol... removing my name in comment and my logical procedure
  4. CashCoin Regent /Level / Map

    Aw... some guys copying my stuff and say if this is their own stuff.... VERY WELL.... @Ron @Nuna This is make me sicks 1. This is make me sicks 2. This is make me sicks 3.
  5. Yorozuya - Open Source Zone Guard [2.2.3.2]

    I'm trying my best to ignore stupid comment but this kid trying so hard to making fake story about me. Out Of Topic Back to topic Please discuss well. The bad feedback is not intended to discredit the product. I love this source code and its framework implementation. Now Im following @i7Core advice to re-write all the code to the single project and single .dll file. I will be silent reader now. don't worry, I will not giving any bad feedback again.
  6. Yorozuya - Open Source Zone Guard [2.2.3.2]

    This video is valid, and the owner using your guard version 1.4 release version (not pre-release version). the video is came from his Players who record it with their own SmartPhone. but you say that is not protected by your ZoneServer / Guard. Since 2009 I have never heard, or rarely get a report from players that experienced critical errors due to actively use items with SetItemEffect. But okay. I will not try to againts your statement... This is all just my fault, because I'm always talking bullshit about your guard . You can move forward and keep developing this good things. ThankYou’ for all your great work.. :cheers
  7. Yorozuya - Open Source Zone Guard [2.2.3.2]

    8. Okay, sorry my bad. the auction part is not include in Client Side modification. when I check it again. you only change 2 offset in RF_Online.bin But I am not lying when I say that I have experienced more Critical Error while using your RF_Online.bin instead of using Original RF_Online.bin. Im using same client, same files, same launcher and same server, I only change RF_Online.bin then publish it to my players. and I got more report about critical error than before. ** don't get me wrong, I just want to give you information based on what I experienced. ps: I only test that bug when I still using this guard in my production server. but after I found this guard is not capable to handle my need. I change it again with another guard and now I need test server to test that bug using your guard. you PM me before, that you have test server. I'm waiting you to give me access to that server.
  8. Yorozuya - Open Source Zone Guard [2.2.3.2]

    Don't complain anything to him,. He provide full source code in GitHub. So,.. if you find some problems and know how to fix it, just send commit in github to help him improve this guard. the list of problem in this guard is : Heavy process. Need high Server Resources. Wrong Alogarithm in speedhack and flyhack. (speedhack tolerance too high). Wrong Alogarithm in Skill / Force Checking. (timing check tolerance too high, range skill target check not available / not work). RF_World DB Connection issue if using old version of SQL / Windows. Crash Dump need Large space of hardisk (1 crash case need 1gb-3gb dump files). Not capable to handle players over than 500 population even with High End Server (i7 7700k, 64GB Ram, Supermicro, NVMe SSD). Have modification in Client RF_Online.bin to fix server side problem. (Example: Set Item Effect). using this version RF_Online.bin triggering more Critical Error than Normal RF_Online.bin without modification. (I have testing it for 1 weeks with Language=USA and en-gb from PlayRF Client).
  9. Ban port 80 and 8080

    Open your Launcher in HXD program or any software that capable to see hex/binaries code of exe program. You can search those port so easy in String ANSI (80, 8080, 10007) or you can simply search "update.dll" in String ANSI because port 80,8080,10007 always close to "update.dll" in String Area. After you find it, you can replace the port direct on there. This way more compatible with all launcher type. You doesn't need using other tools to working on simple thing like this. The advantage of this way is, you can learning the fundamental of structure on exe program to find other interesting things. I hope all the members in here can give more Information and knowledge than just giving the finished program. because that is the fundamental of developing
  10. Yorozuya - Open Source Zone Guard [2.2.3.2]

    Ah so its deleted, I'm curious to see all the comment. lol Ok never mind. the truth will always comes later.........
  11. Yorozuya - Open Source Zone Guard [2.2.3.2]

    Im not bluffing when Im saying if Im testing this protection in server with alot of population more than 500 total online / day's.
  12. Yorozuya - Open Source Zone Guard [2.2.3.2]

    Like i said before. this source code is looks clean and profesional but that is doesn't mean everything is good :). you need to reasearch and test it before you use this protection in release / production server. I already test it. with high end server. 500+ population will Boommm. welcome to hell. You need to research and fix some function/class/structure before using this protection in your server.
  13. Yorozuya - Open Source Zone Guard [2.2.3.2]

    This is not dupe re-registration Item event. That title is misleading
  14. Yorozuya - Open Source Zone Guard [2.2.3.2]

    I will. but to test the auction bug. I need to wait until Re-Registration Item available in Auction. Since I test this guard in production server. so I can't change the server date to manipulating Re-Registration time and make it available without wait.. I do not want to mess up Player Data. When Video is available, I will PM you in here
  15. Yorozuya - Open Source Zone Guard [2.2.3.2]

    Yeah, I know.... That's why you always check all the Structure/Classes that you want to use with "ATF::checkSize()" and compare it with the actual size from IDAPro structure View. And sorry if Im out of topic. I want to ask about your ATFGenerator plugin, can it be used for IDAPro 7.0?
×