Leaderboard

View File Class Restriction This is a script that Prevent / Block certain job from entering specific maps. Configuration : (v2) Refer to db/[pre-]re/job_noenter_map.txt Submitter Emistry Submitted 07/29/12 Category Utilities Video Content Author Emistry

Hello rA community, This is the new translation project i made in 2015, though I've worked in translation "business" since 2014. Project description : - Translated items and skills based on kRO - Translated textures - Support Oldest and Newest STABLE client date (NOTE: 2017-05-17bRagexeRE will be the last client this project supported) - Support iRO's spesific quests (Bounty boards, Turn-in, etc) - Compatible with current rAthena I've separated the renewal and prenewal project so it's easier to manage. Renewal project : PRE-renewal project : (I'm not including other files, like function (_f), you can grab them from renewal page, beware there are incompatibilties with older clients, ex:2011 and older.) Client resources : (Item sprites and textures, grab this if you missing some item files) Item DB updated by me: Protip: Use "Issue page" on Github to report project related issue. A pull request is always welcome, don't forget to link the "proof" of your fixes. ---------------------------------------------------------------------------------------------- Credits: All people who gave contributions on translation in the past.

Your question very strange. In your message i do not see any information how to help you. Please provide much much more details about your problem, like: are you have any problems with your database right now (any performance, etc) how big player base? How many active players usually per day? Tell some info about your server customization (it's for array / variable optimizations only, but i think you have kamishi-like addons which uses millons of rows for just stupid pallets or something like that) total database size tables list with tables size what is your mysql --version? show your my.cnf (mysql configuration) how many ram using your mysql server for now with your db? show information about your CPU (model \ Ghz \ cpuinfo) show information about your current disk \ model \ what speed of drive, how many iops etc Only then depends on this information possible to walk to next step of understanding where is a problem and how optimize it. This issue very hard and complicated to be clear, but you can follow some basic recommendations for your server optimizations like: use latest up to date mysql version, and see benchmarks of it. For example 5.7.* version faster then 5.5, 5.6 proof. but at the same time mysql 5.7 has some compatibility issues, like: https://github.com/rathena/rathena/issues/1210 Usually when very large data available your disk drive (if your database not loaded to memory) will be bottleneck, so get only SSD / SSD NVMe disks for your database Then, it's not correct, but better if you will use some tools like mysqltunner to understand some basic guide where need to move next, or for example https://tools.percona.com/wizard to configure your database depends on your problem. Then, please start to analyze your database, and understand what table sizes are big, and check the most common tables, and find reason what thing generate it, maybe it's time to rewrite some of your scripts? What do you think? Then, please enable for some time slow querries log to understand what querries uses hell a lot of your server resources, and optimize it (do not forget to disable it) log database, maybe it's time to review logging things, maybe hell a lot of things at logs you are not using, or you can compress for example in seperate database? It's just few cents what need to do... But for sure, there can be hell a lot more optimizations, because this problem very actual and very popular, and very complicated. Ah, and last, don't try to switch your mysql server to percona / mariadb, they will not give any benefits for you, tested, and confirmed on large databases by me several times, + you can see different benches in internet about it. 5.7 mysql version very fast

Hi, Pleased to present work of my life last 4 days. Decide to remake my old server list, which were used by nobody actually I believe that it's next-gen top in comparison with other like xtremetop100 and etc. https://top.dsro.ru So actually almost nothing special. Player side: Search servers with any set of parameters(max lvl, stat, etc). Like or Dislike servers once per 12 hrs And ofc V4P Admin side: Add your server(s) Upload few banners Download and install FluxCP addon (hercules, rathena, eathena supported). Why DSRO/top.dsro.ru Just my very old domain, like it Sorting Sorting algo is one of most interesting parts(at least for me). Since we have up and down votes, we need something more than just sorting by total votes. Server rank calculated with algo that called: Lower bound of Wilson score confidence interval for a Bernoulli parameter Max rank is about 95(%). FluxCP Addon You can easily install addon to any of FluxCP version. Then you need just put your server ID in config file(/dsro/config/addon.php). And configure reward type and amount(#CASHPOINTS or FluxCP internal credits) And most interesting part - players will not leave your site even. Addon makes integration through iframe. So players voting inside your site and get reward instantly. Notice: player get reward only in case positive vote So you reach end of post, thank you. I'm still working on it and will try to make it better. And i believe that you will use it for your own servers and help me distribute it over players Feedback is very welcome. Skype: sanasol2008 Telegram: @Sanasol (https://telegram.me/Sanasol) Email: [email protected] Hope it will help find some players for your server