Hello Need Help

[X_MEN_X]

Hi I Am Interesting in Sro Coding And I Wonder What Programes I Need And What I Must Learn C++ or C# and How to Get My Data Base and How to Improve It If Any One Have Answer Please Give it to Me i Am Intrested In This Cause Or Add Me in Skype BrokenRules and we can talk Thxx..

[lesderid]

This all depends on what you want to do exactly.

If you want to edit and/or improve the leaked server files, you need to be able to use SQL and possibly x86 ASM. You can find the server files and the databases on this forum. This is not really considered on-topic in this subsection.

If you want to write an emulator or a bot for SRO, you can use any programming language and framework that can work with TCP sockets (e.g. C#, C++, Java, node.js, Python). The data you need for this can usually be extracted from the client's PK2 files, or you could use the official database for the leaked server files (probably not recommended).

[Schickl]

Originally Posted by lesderid

The data you need for this can usually be extracted from the client's PK2 files, or you could use the official database for the leaked server files (probably not recommended).

not recommended? why?
The Database contains information which is missing in the pk2 files and you have tables where you can store all the user data as well
->less work to do + you use a database(more possibilities, etc)

[lesderid]

Originally Posted by Schickl

not recommended? why?
The Database contains information which is missing in the pk2 files and you have tables where you can store all the user data as well
->less work to do + you use a database(more possibilities, etc)

I personally think it's easier to use a database you've designed yourself. There might be some design decisions that were made by JoyMax that you don't agree about, there might be stored procedures that are too slow and/or you won't use, etc. I personally would rather extract the data from the DB that isn't in the client's files and put it in my own DB than use the official DB directly.

On a side note, a lot of JoyMax's server files can actually be reused for games that are not even closely related to SRO. The only modules that are specific to SRO are those prefixed with SR_ (i.e. SR_GameServer and SR_ShardManager). Back when I still had a lot of time on my hands, I was making a Pokémon MMO using all modules that aren't specific to SRO. It was a fun experience because I had to reverse and implement the inter-module communication (it's slightly complex), which is something not many people had/have done before.

[IceAmStiel]

Gotta agree that Joymax's databases are awful imo, they have mostly outdated procedures in use and the table structure (Despite the fact that some tables are redundant anyway) is in the need of improvement. On some tables it just looks like they didn't bother to adjust them properly, thus they store information quite weirdly in columns that seem totally unsuitable and inefficient.

Outdated procedures.. they can be improved - I already rewrote every procedure that is frequently used to higher the overall performance. Plenty of ingame mechanics expect an sql response, the faster a procedure is completed, the earlier e.g. weapons get swapped.

Oh.. and there are some really mind-blowing bugs; means that if you change totally unrelated data in the database the Gameserver incomprehensibly starts to crash; you'd honestly never find out what's causing it, and I definitely don't mean the obvious crash triggering failures ;d

Nevertheless, their database works!