[VS22] v15

Results 1 to 12 of 12
  1. #1
    ‎‎‎‎ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    New YorkLocation
    2,591Posts

    information [VS22] v15

    You can follow this 100% FREE and awesome guide by @Groxy101 on how to install vs, sql server and setup these files: Click Here!

    Requirements:

    What's included?
    • Source is fully updated to VS22.
    • Game guard has been removed.
    • Boost has been removed.
    • FFLdump has been removed.
    • Lua was updated to 5.3.4
    • CW quest & sound are also working.

    Tested On:
    • Visual Studio Community 2022
    • Sql Server 2019 Standard
    • Windows 10 Professional

    Some Notes:
    • These files have been tested and appear to be working fine out of the box. I am however not responsible for security fixes, added features and etc. If you want those things then you need to add them yourselves.

    Notice:
    • Due to the RANKING_DBF causing crash issues i have decided to delete it by default.
    • You can re-enable all of this by simply defining __GUILDRANK
    • If you re-enable it you will have to add the RANKING_DBF and tables yourself.

    Defines:
    Code:
    //|: ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
    /*
    															`.-`
    													   .:/+oo++oo+/:-
    													.+sso++++///+++oss+-
    						 .                       `./yysooo++o--o+++oosyh+:-..``             ``.-://.
    						 shysoo+/:--..--:/++oshdmmmhyso/.-+syhhhs+-.:osyhdmmddhyysoo+////+osyyyhmmmy`
    						sdmmdyo+ooo+++++ooossssyyyhhy/. `:oshddhso:` `:syhossoooo+++++///////ohhydsyy`
    					  `sy+sh+syy+/:------::::://::hys/-` .:+osso+/- `-/syh:.::::::--....--/oys//ho//oy.
    					 `ys///ss///ss+:-.....---:::`+hhyyss+///+++++//+ssyyhhs `:::--.....-:os+::/so/::/oy:
    					.yo/:::/s+::::+s+:.....--:-  /hhhyyyssoooooooosssyyhhho  `-:--....-+o/---:/s/----:+s+.
    				   :s+:----:+s/--..-/o/-...--:`   ohhhyyyyssssysssyyyyhhhs`   `:--..-/o/.....-s/-..`...-/o+-
    				 :o+:-..``..-oo-.....-/+/:--::    `shhhhhhhhhyyhhhhyhhhhy`     ::::/+/-..```./o-.````...-://::.
    			   -++/-...````..:o:.```...-/+///:     `/yhhhhhhyyyyhhhhhhh+.      ://++:--.....-o:......--..``  `.
    			 :/--------......./+.....--::/+++:       `/yhhhhhhyhhhhhy/`        :++/:::------/+-----.`
    			``       ``..-----:+:-::-.....--:-          .:/yhhhhy/:.           `.````   .-::+/::.`
    						  `.-::++::.                       hNmmm.                         `:+-`
    							  .:+.                         mmmmo
    														  `mmmd`
    														  -mmm+
    														   yhs
    														  `hh/
    														  `hh-
    														  `yy`
    														   os.
    														  :s-
    														  .o-
    														   o:
    														   -+.`-`
    															`//so:`
    															  .++:-`
    															   .o+:-`
    																os+/
    																 -/-
    */
    //|: ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
    
    #define	NEUZ_TITLE	"[VS22] Ketchup V15"				//: Window title of the client.
    #define	NEUZ_BHASH	"sunkist"							//: String to boot the client.
    #define	NEUZ_IPSET	"127.0.0.1"							//: Ip of the server, must match AccountServer.ini & LoginServer.ini.
    #define	NEUZ_CPORT	"5400"								//: Cache port, must match CacheServer.ini.
    #define	NEUZ_PHASH	"kikugalanet"						//: Md5 password salt.
    #define	NEUZ_MSGVR	"20100412"							//: Ver of the server, must match AccountServer.ini & LoginServer.ini.
    
    //|: ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
    
    #define WEB_FIRST_PAGE	"http://mycoolflyff.com/index.html"
    #define SERVER_ROOT		"/RESCLIENT/"
    #define PATCHSEVER_URL	"patcher.mycoolflyff.com"
    #define HOME_LINK		"http://mycoolflyff.com/"
    #define REGISTER_LINK	"http://mycoolflyff.com/register.html"
    
    //|: ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
    
    #define COLOR_ADMINISTRATOR     0xFFFF4500				//: Name coloring of admin characters.
    #define	TITLE_ADMINISTRATOR		"[Admin]"				//: Title for admin characters.
    
    #define COLOR_GAMEMASTER        0xFFFF4500				//: Name coloring of gm characters.
    #define	TITLE_GAMEMASTER		"[Gm]"					//: Title for gm characters.
    
    enum { ENCHANT_TIME = 1 };								//: Adjust the time of upgrading.
    
    //|: ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
    Download: Click Here
    Password: RZxKetchup
    Last edited by Ketchup; 4 Weeks Ago at 09:08 PM. Reason: Updated


  2. #2
    Enthusiast FlyFFerz is offline
    MemberRank
    Mar 2022 Join Date
    48Posts

    Re: [VS22] v15

    Hello sir, do you have tutorials regarding how to make the patcher works specifically for this server file? I have my own website and I don't know how.

  3. #3
    ‎‎‎‎ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    New YorkLocation
    2,591Posts

    Re: [VS22] v15

    Quote Originally Posted by FlyFFerz View Post
    Hello sir, do you have tutorials regarding how to make the patcher works specifically for this server file? I have my own website and I don't know how.
    https://forum.ragezone.com/f724/crea...lient-1193225/ <- Is on the first page of the tutorial section.

  4. #4
    Member MakVee is online now
    MemberRank
    Mar 2021 Join Date
    MarsLocation
    60Posts
    Hello @Ketchup i got a question about the ranking database if it's posible to add a normal ranking database in sql with no crash issues after i re-enabled it?


    --I getting bother about this redline when the server is online after i re-enable it
    /*

    - Due to the RANKING_DBF causing crash issues i have decided to delete it by default.
    - You can re-enable all of this by simply defining __GUILDRANK

    - If you re-enable it you will have to add the RANKING_DBF and tables yourself.

    */

  5. #5
    ‎‎‎‎ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    New YorkLocation
    2,591Posts
    Quote Originally Posted by MakVee View Post
    Hello @Ketchup i got a question about the ranking database if it's posible to add a normal ranking database in sql with no crash issues after i re-enabled it?


    --I getting bother about this redline when the server is online after i re-enable it
    /*

    - Due to the RANKING_DBF causing crash issues i have decided to delete it by default.
    - You can re-enable all of this by simply defining __GUILDRANK

    - If you re-enable it you will have to add the RANKING_DBF and tables yourself.

    */
    Sure, if you fix the crash lol.

  6. #6
    Member MakVee is online now
    MemberRank
    Mar 2021 Join Date
    MarsLocation
    60Posts
    Quote Originally Posted by Ketchup View Post
    Sure, if you fix the crash lol.

    lol how about the K18.3? it has the same issue when you re-enable the ranking database?

  7. #7
    ‎‎‎‎ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    New YorkLocation
    2,591Posts
    Quote Originally Posted by MakVee View Post
    lol how about the K18.3? it has the same issue when you re-enable the ranking database?
    Same.

  8. #8
    ‎‎‎‎ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    New YorkLocation
    2,591Posts

    Updated

    Quick Update:
    • Some of the useless logging in my V18 has also been removed now in the V15.
    • Staff titles and coloring was added to kCommon.h
    • Upgrading rates was also added to kCommon.h
    • Fixed a bug with the guild warehouse not being the correct size, thanks @tmlp

    A big thanks to those who contribute fixes and make me aware of things. Also shout-out to all my obsessive fans who sit in private discords talking about me daily.

    There won't be anymore updates for this V15 and you can download the latest / last update in my original post.

  9. #9
    Enthusiast tmlp is offline
    MemberRank
    Apr 2014 Join Date
    28Posts
    Quote Originally Posted by MakVee View Post
    lol how about the K18.3? it has the same issue when you re-enable the ranking database?


    I've looked at the code and tbh I don't see how it can crash.
    Basically you need a way (be it via a SQL agent job, I would guess that's how they did on official servers) to call MAKE_RANKING_STR procedure, then have the database server run the RANKING_STR procedure (it's already built in, but it's only called upon database server startup or through a dedicated packet that admin can fire through a GM command). This procedures allows the database server to store the guild rankings in memory.

    The aformentioned crash could come from a poorly designed MAKE_RANKING_STR usage, everytime it is called it creates 8 "relations " (called R1,R2...R8) that each represent how guild are going to be compared on a specific criteria (there are 8 criterias). Several calls to it insert new lines everytime, nothing is updated. Maybe the RANKING_STR procedure could have issues with too many lines.

    I don't know how those we were run back then on official servers, but if you clean the RANKING_TBL before running MAKE_RANKING_STR, no crash should ever happen really. And even if it crashes, it would be really easy to fix, you would just have to debug the database server with the RANKING_TBL in that causing-crash state in worst case scenario.

    I've tested the guild rankings recently and had no issues whatsoever with it.
    Last edited by tmlp; 4 Weeks Ago at 01:18 PM.

  10. #10
    Member MakVee is online now
    MemberRank
    Mar 2021 Join Date
    MarsLocation
    60Posts
    Quote Originally Posted by tmlp View Post

    I've looked at the code and tbh I don't see how it can crash.
    Basically you need a way (be it via a SQL agent job, I would guess that's how they did on official servers) to call MAKE_RANKING_STR procedure, then have the database server run the RANKING_STR procedure (it's already built in, but it's only called upon database server startup or through a dedicated packet that admin can fire through a GM command). This procedures allows the database server to store the guild rankings in memory.

    The aformentioned crash could come from a poorly designed MAKE_RANKING_STR usage, everytime it is called it creates 8 "relations " (called R1,R2...R8) that each represent how guild are going to be compared on a specific criteria (there are 8 criterias). Several calls to it insert new lines everytime, nothing is updated. Maybe the RANKING_STR procedure could have issues with too many lines.

    I don't know how those we were run back then on official servers, but if you clean the RANKING_TBL before running MAKE_RANKING_STR, no crash should ever happen really. And even if it crashes, it would be really easy to fix, you would just have to debug the database server with the RANKING_TBL in that causing-crash state in worst case scenario.

    I've tested the guild rankings recently and had no issues whatsoever with it.

    i've try to enable __GUILDRANK and add ranking_dbf in sql and run the program server so far there's no crashing issues after i run it is that means the files was ok? i just enable __GUILDRANK and add ranking database on sql

  11. #11
    ‎‎‎‎ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    New YorkLocation
    2,591Posts
    Quote Originally Posted by MakVee View Post
    i've try to enable __GUILDRANK and add ranking_dbf in sql and run the program server so far there's no crashing issues after i run it is that means the files was ok? i just enable __GUILDRANK and add ranking database on sql
    If it's working fine for you then it's probably fine.
    The main issue was with my 18 so i just removed it from both.

    However your like the only person that really seems to care about this as most people just use their websites for guild ranking anyways lol.

  12. #12
    Enthusiast tmlp is offline
    MemberRank
    Apr 2014 Join Date
    28Posts
    Quote Originally Posted by MakVee View Post
    i've try to enable __GUILDRANK and add ranking_dbf in sql and run the program server so far there's no crashing issues after i run it is that means the files was ok? i just enable __GUILDRANK and add ranking database on sql
    If database server starts without issues, it means it's querying the RANKING_DBF database properly. However, as I said, to actually have the ranking in-games, you need to run the stored procedure called MAKE_RANKING_STR. Then for it to update in-game, database server must call the RANKING_STR procedure, which is either done on startup or via a dedicated packet that admins can send through a GM command (/GuildRanking is the command if I recall correctly).
    Beware that the v15 client released by Ketchup also has the guild ranking button selections removed, you'll have to add them back to the NPC.



Advertisement