Popular Content

Showing content with the highest reputation since 03/21/2018 in all areas

  1. 42 points
    Current Version: 01 March 2019 To make an RO offline server usually you need: setup and configure MySQL database git clone emulator source code get from somewhere client files create a database for the emulator set correct permissions for database users which will be used via emulator for working with DB download and install Visual Studio Community 2017 with all packages (size ~10GB) configure mechanic, turn off some SRC functionality and so on Take from somewhere exe file, apply correct patches to your exe Build a GRF with all required for exe resources and files Compile the server (from sources to a binary file (what you can run on your OS)) Configure server-side (emulator), set proper settings, and so on to make it work copy-paste your game-client files and exe to kRO game client start MySQL database, run the emulator, launch game client This is hard for newbies. Because you will do a lot of mistakes because you can't know the different details. The package solve almost all steps above and leave to you only 2 last steps (copypaste, launch, and play) How to make everything work (2-minute guide) Download Extract Watch the video or read readme.txt Launch OpenServer and start server (Green Flag) Copy-paste 1 time only game client files to kRO folder Launch emulator Launch game exe from kRO client folder Login and play This is super easy, is not it? I have prepared for you almost everything, to make sure that you will skip the painful newbie entry point with making it just work. This package can be used as a template for building your own server (if you really wish to and will be stuck somewhere). All emulators, client, repository folders are connected to remote repos, so you can always easy update emulator or client by yourself without waiting for any updates from my side. I made almost everything what you need to keep always up to date emulator. But for making it up to date, please read the section below later, this requires some steps and understanding from your side (I failed to make 1 click solution to update it, because of problems inside emulator) Download Links Google Drive | Mega Alternative Link: Part 1 (1.2GB) (just pack (emulator)) Part 2 Client (2.7GB) (game client) Please download the whole folder what you see if you are a newbie. Current Full Pack Size: 3.36 GB (include kRO client and everything else) 1.2GB = emulators, packed grfs, tools, openserver, and so on (this is a raw package) 2.16GB = kRO clean game client which is required for the files above (07_clean_kRO_client) If you let your friend connect to the server (online) you can read the guide: https://gist.github.com/anacondaqq/3eae8e4afb5d3c3880d08b95b2c54b78 Old topic (first version from 2017, 2018 years): 2018: http://web.archive.org/web/20190212101235/https://rathena.org/board/topic/109823-ragnarok-online-complete-offline-server-client-pack-2018-make-your-ro-server-in-less-then-5-minutes/ 2017: https://web.archive.org/web/20180420124127/https://rathena.org/board/topic/109823-ragnarok-online-complete-local-server-client-pack-2018-make-your-ro-server-in-less-then-5-minutes Please read readme.txt before asking any question. Changelog: 01 March 2019 - fixed many issues related to the game client, turned off custom NPCs, updated emulators, recompiled everything, fixed earlier reported issues, re-uploaded and repacked everything to different hostings. If you want to update your package, search for my post on page 30. 12 February 2019 - many many many fixes to emulator, client, everything updated, and all known issues fixed. Everything is up to date and works great. 07 July 2018 - updated all content inside the package to their actual versions. Also, changed exe to 20180530 one from 20170614, and also repacked game clients as well too. Fixed small minor reported issues. Download links updated (please use the client) 01 June 2018 - updated and repacked kRO client (merged rdata.grf into data.grf for reducing total size of full kRO client), updated rAthena codebase up to 01 June 2018, recompiled all servers, fixed reported bugs related to the VIP system, fixed crash issue with Gentleman Pipe, all download links updated, if you want to take the update, re-download the whole package. 02 May 2018 - added VIP system options April 2018 - second unbounded version from the anacondaqq (you can update manually the whole package) March 2017 - initial release
  2. 33 points


    This awesome feature can be on your server soon! 😉 Keep in mind most of this money will run into my pocket, so if you ever wanted to buy me a coffee or beer for one of my releases, here's your chance. 😛 Edit: Since I have been asked already. This feature is available for clients 2017-02-08RagexeRE or later. Another edit: Since this might have been unclear. This is not to get me working on this feature, but to release it. I have already completed it and it is ready for release. And it will be released as the goal has been completed. 😉 Yet another edit: Since the community seems like they do not want the feature yet I extended the goal until January. Just to make things clear: I will not sell this system in private. If you want it donate the amount you want to pay for it to the goal and you will get it sooner. Funny side fact: I got a few PMs that offered me more money from a single person than what is currently in the donation pot. 😅 And here comes my final edit: I have decided to decrease the target value, since it is really getting on my nerves seriously. I got another request who wanted to buy the feature for 500$ for his server and the community cannot build this up in more than 2 months now. To make things clear the feature is only going to be released if the donation goal is reached. If you want to comment anything on this, please use this thread:
  3. 26 points
    Need the latest kRO Install folder for your private server? Look no further! ----> Download <---- Latest: 2018-08-13 Installation: Official kRO Updated: 25/02/2019 Download Link: http://bit.ly/latestkro Package contains RSU RO Patcher Lite for kRO and kRO RE by [Ai4rei] This package is maintained by [Akkarin] This ZIP archive is 3.14GB in size and includes all BGMs plus the latest RSU ([2018-10-23] Release Simply download, extract, play! A fan of this topic? Hit the rep button
  4. 22 points

    Version 2.2.0


    Third Job Costumes + New Classes The Correction With the advent of jRO releasing new Job Costumes, and also, the new classes from the Taekwon branch, many of server owners want to replace the vanilla sprites or even, implement the bodystyle system. But, there's a catch! Originally jRO, and now, even kRO spriters, have made it completely off of the default pattern of palette. In a classic example, you can notice the pattern of the RO palettes. What matters is the position of the colours, as an example, for all jobs, the white-ish tones will be always on the same row, so we can use it to create custom palettes. See how it works: But jRO didn't follow the classic pattern, making it incompatible with custom palettes (@Kamishi ones included). So, I edited frame by frame of each job sprite, of each gender, mounted or not, correcting them, converting them in a way so many of the previously created palettes will work. This package includes: Alternate Outfits: Alternate Royal Guard M/F + Gryffon Battlemount + Lion Mount Alternate Ranger M/F + Warg Battlemount + Ostrich Mount Alternate Minstrel/Wanderer + Ostrich Mount Alternate ArchBishop M/F + Alpaca Mount Alternate Warlock M/F + Fox Mount Alternate Mechanic M/F + Savage Mount Alternate Genetic M/F + Savage Mount Alternate Guillotine Cross M/F + Hyena Mount Alternate Shadow Chaser M/F + Hyena Mount Alternate Sorcerer M/F + Fox Mount Alternate Sura M/F + Alpaca Mount Alternate Rune Knight M/F + Dragon Battlemount + Lion Mount New Classes Star Emperor M/F + Wolf Mount Soul Reaper M/F + Wolf Mount As requested by @Emistry, I also added an extra, making it more compatible to default palettes: Kagerou/Oboro + Frog Mount Following the another @Emistry's request, all files are now already on GRFs. The previous version had no Cashmount palette included, this one fixes the issue. Only the already released costumes are supported at this moment. The Rune Knight seems to be the last of them, it's over a year from the first release! As a final part of the package, I'm including Classic Palettes for all Alternate Costumes. Enjoy the final product!


  5. 20 points
    This morning started as any other day, I wake up, I check my personal emails, I eat breakfast, I check my business emails, I put my boots on then check rAthena emails. This is where this morning differed. Over the last fortnight an astonishing number of chargeback disputes have been filed with Paypal, and a particular dispute that was closed by Paypal this morning in favor of the buyer was the last straw. This particular dispute was for a file that cost $10. The fee for chargeback disputes to the seller when lost is now $20. rAthena is essentially being scammed out of more and more money each month because of these fees and dirty scumbags, and I can no longer justify spending my own money to cover them. And people wonder why it's taking a while for Withdrawals to be processed. Paypal has been removed as a payment method on rAthena. Users who have submitted chargeback disputes have been banned. What does this mean? It means that if you would like to pay for an invoice, you may use your credit/debit card which will be processed by Stripe. Your card details are not saved on our webserver. Since the Stripe module was enabled almost 2 weeks ago, there have been a number of attempted transactions that have been refused by Stripe due to their fraud rules. And we are loving it! If your rAthena account name, address and phone number don't match the cardholder's details, you'll be declined. If you don't put in your CVC (3 digits on the back), you'll be declined. If your rAthena account is less than 20 days old, your transaction will be authorised but placed on hold for manual review. If you're dumb, you'll be banned. How does this affect Withdrawals? Essentially, it doesn't. Your Withdrawal request will still be processed through Paypal via our automated script. To be quite honest, i'm very disappointed with a select area of our community.
  6. 19 points
    View File Extended Battleground [eAmod BG] Extended Battleground [eAmod BG] Made in Git Hash: '91169d7ebccccaf5008076383c89ff3a6c514a9e' Repository (db/npc/clientside): https://github.com/xEasycore/ExtendedBG Description Battleground System from eAmod compatibilized with rA c++. Features - Temporal guild System (Fake Guild) - Queue System (@joinbg) - Guild Skills usable in Battleground - Guild Skills separated cooldown - Anti AFK system - Enable/Disable BG Announces Commands @joinbg: queue join @leavebg: queue leave @order: sends a message to your team @leader: change team leader @reportafk: kick an AFK player @listenbg: enable/disable display bg announces Admin Commands @bgstart: enable BG queue @bgstop: disable BG queue @bgmode: change actual BG arena (own creation) @bgsize: change min/max players for an Arena (own creation) Arenas availables - Capture the Flag - Team DeathMatch - Conquest - Rush - Triple Inferno - Eye of the Storm - Domination - Feel free to Donate if you want to support me Note: This release is not stable, use it at your own risk. Submitter Easycore Submitted 07/08/2018 Category Source Modifications Video Content Author Zephyrus, Easycore  
  7. 19 points

    Version 1.0.6


    Extended Battleground [eAmod BG] Made in Git Hash: '91169d7ebccccaf5008076383c89ff3a6c514a9e' Repository (db/npc/clientside): https://github.com/xEasycore/ExtendedBG Description Battleground System from eAmod compatibilized with rA c++. Features - Temporal guild System (Fake Guild) - Queue System (@joinbg) - Guild Skills usable in Battleground - Guild Skills separated cooldown - Anti AFK system - Enable/Disable BG Announces Commands @joinbg: queue join @leavebg: queue leave @order: sends a message to your team @leader: change team leader @reportafk: kick an AFK player @listenbg: enable/disable display bg announces Admin Commands @bgstart: enable BG queue @bgstop: disable BG queue @bgmode: change actual BG arena (own creation) @bgsize: change min/max players for an Arena (own creation) Arenas availables - Capture the Flag - Team DeathMatch - Conquest - Rush - Triple Inferno - Eye of the Storm - Domination - Feel free to Donate if you want to support me Note: This release is not stable, use it at your own risk.


  8. 16 points

    Version 1.0.0


    Hello everyone! I'm maken06. I'm learning to create sprites and this is my first monster "Wooden Training Doll from Maple Story". Special thanks to @smiths12 thanks to his teachings, I managed to animate the monster. pd: Do not forget to give me a reputation or reaction.


  9. 15 points
    Discord Rich Presence Hello rA, today I'm here to show you a client-plugin for RO that I made recently. This plugin is Discord-RPC or better known as Discord Rich Presence. What is Discord Rich Presence? "Rich Presence allows you to leverage the totally overhauled "Now Playing" section in a Discord user's profile to help people play your game together. Rich game data—including duration, score, current boss or map, and so much more—lives inside Discord." Source: Discord Documentation So, basically, this plugin allows players to display basic information about their game in Discord, some examples: Main Menu In-game information The plugin is very configurable and It's possible show even your Guild Name. Currently this plugin only works in 2018-06-20 RagExe. Hope you liked this showcase. Regards~
  10. 13 points
    roCORD for rAthena Hey everyone, I am currently working on a Discord bot which allows interaction between a Discord server and an in game channel. Support for Version 1 is now dropped! Version 2 can be found under this link -> https://github.com/Normynator/roCORD/tree/development Documentation about installation and configuration can be found here -> https://github.com/Normynator/roCORD/tree/development/docs More updates on Version 2 will follow.
  11. 13 points

    Version 1.0.0


    CHESHIRE SET CUSTOM HEADGEAR & CUSTOM ROBE Greetings again, rAthena! I'm Haziel, once more, I'm back planning on new freebies every week! Cheshire Set consists in a one Custom Headgear and a Custom Garment, Cheshire Ears and Cheshire Tail. I hope you enjoy the final product! If you're interested on my work, Contact me on hyering or through one of the channels below! By downloading this file, you agree with my Terms of Service: • YOU WILL NOT remove my signature from any of the included files. • YOU WILL NOT alter, edit, recolour any of my files unless for your personal use. • YOU WILL NOT repost, repass or mirror my work nor edited versions of it anywhere. • YOU WILL NOT sell, resell or in any manner, ask money or rewards using my work as exchange. • YOU WILL NOT claim my work as yours.


  12. 12 points


    Walkthrough Conversion of Episode 16.1 * Main quest and the 2 instances Ritual of Blessing (pre-requis) and Room of Consciousness (daily quest) * Sidequests around the families, the kitchen, underground prison and old prontera * Enchants NPCs (enchant abusive robe and co.) > 17000 lines of npc script
  13. 12 points
    Evening all! I'm sure we've all come across a file that we really wanted to download, but found that we end up with a page that simply says "File Not Found". It's annoying. We feel your pain. You can help us to clean up these files! When you come across a file that doesn't actually have any files attached to it, you can click on the grey "Report this file" link near the bottom of the file page area. This will give you something that looks like this: When you select the Missing File option, your report will be placed into a special category. If moderators don't happen to have the original file on hand (which we tend to keep when approving files to make sure they work) they will send the original author a PM asking for a re-upload. If the author doesn't respond within 7 days, the file and support topic (if it has one) will be hidden. There are currently 2,760 file records in our database, and i'm almost willing to put money on the fact that ~15% of those files are ghost records (file records in our database without actual files saved on disk). Members who are particularly diligent will be awarded the Helper badge and will be displayed next to all of your posts and on your forum profile. It's like bug-hunting.. but for things that aren't there.. Happy reporting! Akky out~
  14. 11 points
    Hello, I'm Haziel. I've been a graphic artist for over 15 years. I've made commissions for several Ragnarök Servers and also, worked on the production of some Indie Games either as Concept or Pixel Artist. Spriter is my main role on game development but I'm also able to perform as Designer, Mapper and Programmer, drop me a PM if you're interested in any of those services. For the previews below, keep in mind: Headgears, Garments, Equipment, Weapon/Shield and Monsters. Headgears Divine Headgear Set A Gem Themed Headgear Set carrying the theme of mystical stones, targeted for each of the main class branches. Dragon Headgear Set In a similar fashion of the previous one, having one main headgear targeted to fit certain classes. Equipment Divergent Set The Divergent Set concept is based on evolution. After meeting some requirements, the player would be able to evolve the basic Divergent Equipment (grey-ish blue), to one of 8 different forms: Demon (Purple), Dragon (Green), Fox (Orange), Ox (Black), Phoenix (Red), Shark (Skyline Blue), Tiger (Yellow) and Wolf (White). Each one with its own properties. The Helmet has it's own appearances while the other equipment will have it's colour changed. Arcane Set The Arcane Set was meant to be a magical bundle of equipment with four options of headgears for combining, it also has a Weapon compatible with Wizards, Sages and their evolutions. Sacred Set Initially, the Sacred Shield was requested, then, a Swordsman Equipment set, I mixed both things and expanded it to an 8-piece Equipment Set. Plate themed, this one is intended for Knights, Crusaders and their respective evolutions, but can be used by any Class. The Shield is currently only available for Crusaders and evolutions but can be adapted for any Class, although a specific Diff from NEMO is required to implement it. An alternative Cursed theme is also available. Elemental Auras Four Aura-like headgears and four monsters/pets to go along the theme. Anime/Show/Game Themed Gears Anime/Game Themed Gears Miscellaneous Gears made based on some Anime/Game characters and/or artefacts. Above, Megaman X and Zero Helmets from Megaman X franchise, Dying Will from Katekyo Hitman Reborn anime, Kaneki Mask from Tokyo Ghoul anime. Sword Art Online 2 Headgears/Garments and 3 Weapons based on the Manga/Anime Sword Art Online. Elucidator and Dark Repulser both are available for Knights and Evolutions, Kirito Weapons for Assassins and Evolutions. Event Gears Valentine's Day Halloween Halloween Package includes 5 Headgears with matching Garments and also the Wicked Set, composed of 2 Headgears and a Garment. Auras 32bit Headgear Auras All of them available in 12 colours. Monsters Defence Turrets Those are monsters meant to be summoned and attack anything that goes near. Originally intended to be WoE-related. Untear, Unseal, Unnes & Undine My take on the concept of evolutive Pets, can also be used as monsters. Miscellaneous Monsters Situational mobs to be used in Custom Maps/Quests. Trickster Collection My own take on Trickster Online conversions. Christmas Boss: Evil Santa Meant for Christmas Events, this boss has some weirdly strong Reindeers as minions! Sword Art Online Collection Overlord Collection RE: Zero Collection Bosses Big Bosses Really Big Bosses VIP Badges Those were intended to be exclusive to certain VIP levels, there are alternate versions for PVP purposes. Logo Headgears I also offer the service of recreating a server's Logo in a promotional Headgear. Headgear Edits Examples of minor works I usually receive requests for, that may be, from little corrections or addition of details to recolours and mixing of headgears. Above, a symbolic gift to Nova and his request about a Sunglass equipped on the lower slot. Garments/Robes Garments are visual items Gravity made on Jan/05 of 2011, but even Gravity itself didn't make much of them. They're equipped on Cape or Costume Cape slot and must be made Class by Class to fit perfectly on each movement. Different from Headgears, they are layered correctly behind the character and does not stay floating around it as some custom content out there. Official examples of it are the Archangel Wings and the Adventurer's Backpack. Wing-Themed Collection My current Wing collection consists of several themes divided on Insect, Feathered, Leather and Other categories. Suitable for all classes. Miscellaneous Garment Collection Another set of Custom Garments, but with another kind of thematic, instead of the usual wings. Miscellaneous Equipment Sets These have no visual appearance, are only intended as common gear. Freebies Headgears Garments Monsters Freebies Click on the preview image to be redirected to download thread! Freebies will be posted weekly! Rules 1. DO NOT steal my work, it takes hours, days, sometimes weeks to be made, don't claim it yours. 2. DO NOT redistribute, mirror or redistribute my work. 3. DO NOT edit my work without my permission, It includes recolours. 4. DO NOT remove my signature included among my files, be respectful. 5. DO use my works as Donation Rewards, be kind and just ask me first. Additional Information • I'm a Freelancer and my work is for sale, contact me by PM, Facebook, Discord, E-Mail ([email protected]) or Skype (hyering) if you're interested. • I'll not edit or modify other Artists' work without their permission, be sure to have it before asking. • I do take references on Sprites from TalesWeaver, Trickster and other sources, but I'll not redistribute raw materials or teach how to get it. • Feel free to contact me speaking English or Spanish. I can also understand Portuguese at a certain level. • I'm not a master or a know-it-all, I'll share my knowledge when I feel appropriate to do so.
  15. 11 points
    Hello, I'll use this post to show you some of my projects and modifications. The name of my server is called RO: Zero, but it started before gravity announced theirs, so I chose to keep the name. LOGIN SCREEN https://vimeo.com/287302640 https://vimeo.com/300142810 https://vimeo.com/274177970 SCRIPT & SOURCE Bet System https://vimeo.com/297864967 Pick Item with Mouse Click https://vimeo.com/288068416 Hack'n Slash Attack System https://vimeo.com/285431474 SkillShot System https://vimeo.com/269528679 Header Hud Char Info https://vimeo.com/268928510 System Conversor Skill Target to Place https://vimeo.com/307620277 LEAGUE OF LEGENDS INSPIRED SKILLS Ivern https://vimeo.com/270423927 https://vimeo.com/270211429 Kalista https://vimeo.com/270518714 Ash https://vimeo.com/270728857 Orianna https://vimeo.com/270911850 Xayah https://vimeo.com/271172345 Katarina https://vimeo.com/269402201 Client Edit New Hud Interface New Game Filter https://vimeo.com/303199417 Item Summon Screen https://vimeo.com/300142810 Rain https://vimeo.com/298893681 Campfire Button Shortcut https://vimeo.com/298498848 Discord Integration ________________________________________ A lot of other things I haven't record, but I will try to keep this updated soon.
  16. 11 points
    Probably my most ambitious and personal project. I often met on my way interesting places in the world of RO, to which it was impossible to get. Then I began to find such places with the help of the BrowEdit program and make them available for visiting. As the project expanded, I decided to allow shooting and use skills from the hills on the maps, where this feature was disabled, add plants and trees, create comfortable climbs and so on. I suggest you watch a promo video that clearly explains my idea. .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. At the moment, almost ready the locations of the Schwartzwald and Arunafeltz for the release, there is a reserve for many other locations. Since the appearance of the video, there have been some changes, so the final result may be different. Below I attach screenshots from BrowEdit "before" and "after" and gif files with changes of territories on the finished mini-maps. Some screenshots of my work: From the important places are opened: the airport in Veins, the left exit from Einbroch, the northern Einbroch railway station on Ein_Field04, the industrial zone on Ein_Field02, the border post between Ein_Field04 and Ein_Field05, the fortress on the map of Yuno_Field12, the alternative entrance to the tower of Thanatos on Hu_Field01, the arch with a fountain on Ein_Fild09, the bridge in Lhz_Field02, the road from Ra_Fild06 to Ein_Field03 and more. Mini-maps changes (if any map is missing, it means everything is fine with it): .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. P>S> Since the map of Ein_Field05 won in the nomination of the most extended territory - a small comic video showing progress in its honor: .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. CODE: Warps lines below: //===== eAthena Script ======================================= //= New Warps for AMP //===== By: ================================================== //= w0wZukuBg //===== Current Version: ===================================== //= 1.0 //===== Compatible With: ===================================== //= eAthena SVN //===== Description: ========================================= //= New Warps for AMP //===== Additional Comments: ================================= //= The NPC's were born. [w0wZukuBg] //============================================================ //======================================================= // ein_fild //======================================================= ein_fild02,134,123,0 warp newein01 1,1,ein_fild02,118,134 ein_fild02,121,131,0 warp newein02 1,1,ein_fild02,137,123 ein_fild02,223,137,0 warp newein03 1,1,ein_fild02,223,148 ein_fild02,223,145,0 warp newein04 1,1,ein_fild02,220,137 ein_fild02,186,226,0 warp newein05 1,1,ein_fild02,204,224 ein_fild02,201,224,0 warp newein06 1,1,ein_fild02,183,229 ein_fild04,385,181,0 warp newein07 1,1,ein_fild05,36,185 ein_fild05,33,185,0 warp newein08 1,1,ein_fild04,382,181 ein_fild05,35,167,0 warp newein09 1,1,ein_fild04,382,181 ein_fild05,120,292,0 warp newein10 1,1,ein_fild05,120,300 ein_fild05,120,297,0 warp newein11 1,1,ein_fild05,120,289 ein_fild06,231,81,0 warp newein12 1,1,ein_fild06,231,67 ein_fild06,231,70,0 warp newein13 1,1,ein_fild06,231,84 ein_fild03,245,55,0 script Lift-E02 139,2,2,{ OnTouch: mes "Lift up?"; next; if(select("Yes","Stay")==1) warp "ein_fild03",201,41; close; } ein_fild03,204,43,0 script Lift-E01 139,2,2,{ OnTouch: mes "Lift down?"; next; if(select("Yes","Stay")==1) warp "ein_fild03",248,53; close; } //======================================================= // ra_fild //======================================================= ra_fild09,362,76,0 warp newra01 1,1,lhz_fild01,15,79 lhz_fild01,12,79,0 warp newra02 1,1,ra_fild09,359,76 //======================================================= // ra_fild -> ein_fild //======================================================= ein_fild03,19,181,0 warp newraein01 1,1,ra_fild06,374,223; ra_fild06,377,223,0 warp newraein02 1,1,ein_fild03,22,181; //======================================================= // hu_fild //======================================================= hu_fild02,378,244,0 warp newhu01 1,1,hu_fild03,22,253 hu_fild03,19,253,0 warp newhu02 1,1,hu_fild02,375,244 hu_fild02,378,194,0 warp newhu03 1,1,hu_fild03,22,205 hu_fild03,19,205,0 warp newhu04 1,1,hu_fild02,375,194 hu_fild02,375,303,0 warp newhu05 1,1,hu_fild03,22,308 hu_fild03,19,308,0 warp newhu06 1,1,hu_fild02,372,303 hu_fild02,378,125,0 warp newhu07 1,1,hu_fild03,22,129 hu_fild03,19,129,0 warp newhu08 1,1,hu_fild02,375,125 //======================================================= // ve_fild //======================================================= ve_fild03,327,294,0 warp newve01 1,1,ve_fild04,34,322 ve_fild04,31,322,0 warp newve02 1,1,ve_fild03,324,294 ve_fild03,316,251,0 warp newve03 1,1,ve_fild04,42,295 ve_fild04,39,295,0 warp newve04 1,1,ve_fild03,312,251 //======================================================= // einbroch //======================================================= einbech,50,223,0 warp neweinb01 1,1,einbech,50,230 einbech,50,227,0 warp neweinb02 1,1,einbech,50,220 einbech,37,223,0 warp neweinb03 1,1,einbech,37,230 einbech,37,227,0 warp neweinb04 1,1,einbech,37,220 //======================================================= // veins //======================================================= veins,296,335,0 warp newve05 1,1,veins,290,342 veins,293,342,0 warp newve06 1,1,veins,275,352 veins,278,352,0 warp newve07 1,1,veins,296,332 //======================================================= // lighthalzen //======================================================= lighthalzen,241,163,0 warp newlhzs01 1,1,lighthalzen,265,163 lighthalzen,262,163,0 warp newlhzs02 1,1,lighthalzen,238,163 lighthalzen,282,327,0 warp newlhzs03 1,1,lhz_fild01,278,19 lhz_fild01,278,16,0 warp newlhzs04 1,1,lighthalzen,282,324 //======================================================= // juperos_ //======================================================= juperos_01,96,220,0 warp newjup01 1,1,juperos_01,152,183 juperos_01,149,185,0 warp newjup01-1 1,1,juperos_01,93,217 //======================================================= // jawaii //======================================================= jawaii,138,182,4 script Stairs#ja1 111,{ mes "[Stairs]"; mes "Want to go up or go down?"; next; switch(select("Up","Down")) { case 1: warp "jawaii",136,183; close; case 2: warp "jawaii",140,180; close; } close; }
  17. 11 points

    Version 1.2


    Original Topic: http://herc.ws/board/topic/16037-campfire-to-regenerate-hpsp/ Herc Script Link : https://pastebin.com/fksPdpFQ The Idea: Camp Fire to restore / regenerate HP & SP. When you sit by the Camp fire, you start feeling the warmth and the comfort, so your HP & SP begin to regenerate. How to use : 1. add the source mode provided in the script. (or here) 2. make a usable item_db with these bonus script. callfunc("func_CreateCampFire", <range>, <duration>, <heal_rate>); // create campfire callfunc("func_UpdateCampFire", <range>, <duration>, <heal_rate>); // update the campfire duration/heal rate. Preview: Credits : @Dastgir & @Radian for the src mod and @Habilis for the idea


  18. 11 points
    Hi everyone; hope you enjoy your weekend This is a map I did as an improved version of the original Auch Map by the 2012 ...! The map was originally inspired on a city of this game I loved and close to Ragnarok Online. The city was improved a lot by remaking all the models and making more accurate textures. Like always the idea was to make it have the barroque style feeling of the original. This map contains a main town and a set of fields+dungeons. Hope you like it Auch City - Main Town This is a map I showed on social media for a while, yet not in the forum. I´ve been told I should be more active as I was on the forum and I think I have too It has been 5+ years when I made this map; I´m very glad there has been some improvement over the years The nostalgia is reallll!
  19. 11 points
    Welcome .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. mystvil Please rate it if the map is good enough
  20. 11 points
    Hi, At the occasion of the FIFA WORLDCUP in Russia, I wanted to show you my version of a soccer stadium for Ragnarok : It is designed for my Battleground Extended mod (Poring Ball mode). Cloakroom Please rate it
  21. 11 points
    April Digest 2018 The following digest covers the month of April, 2018. Staff Changes: @Nitrous is now a developer. @tr0n returns to his International Moderator position for the German section. @Azura Skyy, @crazyarashi, @Z3R0 and @Promise have left the Moderator teams. Development Highlights: CORE: Dropped an unused declaration (170da178) Added Random Option item data to getinventorylist (f07a1c4b) Fixed error in getinventorylist (1390930c) Added support for homunculus autofeeding (aff70f64) Added a config for disabling novice/summoner character creation (aab5d549) Adjusted Madogear interaction with skills (1efd7b5e) Fixed a compile warning from homunculus autofeed (7901c1b2) Corrected a potential integer overflow (1d539c3e) Applied MHP limit based on bLv (7f2c6cf2) Corrected item_db script curly parsing (ec1470b6) Fixed a bug with MAX_ITEM_RDM_OPT (f948b9a6) Updated getunitdata / setunitdata (cdae404e) Resolved storage saving on server crash (8893ef1c) Removed a stack push from getvar (25f2626c) Made the second parameter for bonus script command optional (07e2bf09, cc63bb59) Fixed default mob AI spawn (3b385d95) Changed SI_ enum to the official EFST_ enum (d13d6a6e, 55bf142a) Fixed a few problems with homunculus autofeed (2c68db9f) Added ZC_NPCACK_SERVERMOVE2 (aaffbaaa) Updated item_group_db column requirements (01846710, 4ffb1b04) Added support for missing 2018 clients (8c7cd293) DATABASE: Updated Item DB: Muscle Fool, Biscuit Stick, Hunting Arrow, Akaraje, Fidelity Necklace, Hero Judgement Shawl, Hero Target Suit, White Slim Potion Box (e96807cc, 71bf8cc8, 963d9b04, 72c0f9c8, e23f06d6, e7ccee76, fac4d9be) Updated Shadow Chaser skills (e509930a) Added new items, some fixes and missing duplicates (7a361690) Added Phantasmagorika mobskill placeholder (05dd7b31) Updated Mob and NPC identity (33e36809, ae65e2e2, 94e68930) Corrected some shadow equipment (33960fef) SCRIPT: Fixed a few typos and language mistakes (fdc48770) Fixed typos in Phantasmagorika quests (dca8cc60) Cleaned up custom battleground scripts (e2b9e42b) Corrected a NPC name in academy.txt (aee83557) Initial release of instance Isle Bios (5a0b72a7) Fixed Regenschirm Guard Laboratory Permit issue (3a8814ac) Added missing getpartymember calls in MVP ladder script (258069da) OTHERS: Added mailmap file to coalesce together commits (872eb00c) Updated Item Bonus documentation (c4d3f0fd) Statistics: Excluding merges, 14 authors have pushed 68 commits to master and 93 commits to all branches. On master, 125 files have changed and there have been 7,752 additions and 3,866 deletions. 43 Active Pull Requests 65 Active Issues 37 Merged Pull Requests 6 Proposed Pull Requests 44 Closed Issues 21 New Issues List of Contributors: @aleos89, @Akkarinage, @Angelic234, @AnnieRuru, @arby89, @Atemo, @BrOgBr, @crazystorm2017, @cydh, @ecdarreola, @Encon21, @Everade, @flamefury, @gegewu85, @iubantot, @juanfus, @kisuka, @Lemongrass3110, @llchrisll, @mrdiablo, @RadianFord, @sader1992, @secretdataz, @syracuase, @talesofragnarok, @teededung, @Valacobino, @vstumpf, @Yuchinin, @zackdreaver Show your support to rAthena by submitting your Issue or Pull Requests! By providing enough useful info (Git Hash, Client Date, RE/Pre-RE, crashdump, how to reproduce, etc) you will help us to solve the issues faster
  22. 11 points
    Time for some good news! The impromptu forum maintenance earlier this evening allowed me to upgrade our forum version to 4.3.1 - with the new version comes some new features! Emojis We've enjoyed Forum Emoticons for years, and as the rest of the world has been integrating Emoji's into their software, it's about time we had some too. The old forum emotes have now been removed and the custom RO specific emotes are now in their own category under the emote icon on the text editor. I've opted to use the Twitter style instead of the EmojiOne style as they are what we're used to seeing as the default Discord Emojis, but if enough members would prefer those instead then we can switch. Github uses a Native style, and we can only pick one. Apple Pay / Google Pay Many users have been sending me messages, PMs, hate mail, death threats, etc over the fact that we swapped Paypal for Credit/Debit Card only payment processing. I'm pleased to announce that our updated forum software is compatible with Apple and Google Pay platforms for both mobile devices and supported browsers. Spammers Over the last two to three months we've seen a dramatic increase in spambots posting their topics on how to grow your or build some . The new update includes several new algorithms that allows spambots to be caught more effectively without Moderator intervention. Searching It has been noted that the search method in the older IPB 3.x forum software was much smoother than the recent implementation - so IPS 4.3 has changed it all. We should now* have more accurate search results displaying when searching for more than one word, and don't forget you can encase your phrase in quotes "to search the string as-is". *When the search index has finished re-caching.. will probably take 5-6 hours still. ReCaptcha Those daft "type the words as you see them" have now been removed in favour of Google's "Invisible ReCaptcha" platform. The forums will now determine whether or not you're human and let you use the forums to one's heart's content without being randomly asked to read unreadable text. There are other improvements but nothing worth mentioning as normal members won't see/interact with them. If you come across something that doesn't work as it should, please let me know by posting as much detail as possible in https://rathena.org/board/forum/224-forum-issues/ I think that's enough good news for one day. Akky out~
  23. 10 points
    View File Extended Vending 2.0 Extended Vending 2.0 Made in Git Hash: '042b88623bf549b88ba619991aaa186d45f7f998' Description Yet another version of Extended Vending, this one works in actual rA c++. It has a few fixes, including vending tax only working with Zeny as currency. What is new? I tried to improve this amazing mod adding a new feature: Vending Report (Mailbox). Basically... whenever you buy items to a vendor, he receive a report that who bough,what items, how many and total profit of them. You can disable this feature through conf/feature, or If you want to disable it for a specific player you must set the permanent variable called NOVREPORT (by a NPC/Bindatcmd/Idk) For < 2015-05-13 Clients Since old mailbox has 300 characters less than RoDex, I decided to take off items name and amount. So only will send 'who bought' and 'total profit'. Feel free to Donate If you want to support me. Submitter Easycore Submitted 07/10/2018 Category Source Modifications Video Content Author Lilith, Easycore  
  24. 10 points
    Whatup rA. Here's something I've been working intermittently for the past few weeks, it's a massive overhaul of a town map I originally made back in 2012 (Please do not bump that thread back to the front page) that I was fairly proud of, but looks sorta old and outdated now. This is probably the most custom model and texture work I've ever done on a map so far, but while a lot of those assets were made brand new for this map, there's also a lot of custom stuff I've re-used from stuff I worked on in 2019. Ever since I figured out how to retexture things (and it took years, because believe it or not, I'm kind of dumb), I've kinda gone crazy and done a lot of it. Just counting new assets I made specifically for this map, there's 48 new models and 80 new textures. With that said, this map isn't just a revamp of the old one with slightly nicer models and textures. The town is much bigger and more modern. I always wanted it to be that way, but I couldn't really accomplish that with the assets available in 2012, and even if I did have those assets, I probably wasn't skilled enough back then to make them look good. I think the town's lost a little bit of its 'country' feel, and some landmarks have been changed- Most notably, the old graveyard with stone caskets in the northwest end is now a little marketplace with docks, and a few manor-style homes have been replaced with colorful apartment buildings and warehouses, but real world cities grow and change a lot over time, so I'm OK with this. I don't have any interior maps finished yet, and the original Aquitaine had quite a few fields and extra quest-related maps in the surrounding forests and marshlands, so I'll have to update those too, eventually. I'm not 100% satisfied with this map either, and cut a few corners just so I wouldn't be working on it for the next month: I'd like to eventually retexture Malaya's car models into something that looks more realistic and less like a theme park ride, and I'd like to try making some better, more modern looking boats, too. I also got lazy with the marquee sign for the cinema and didn't add any movie titles or show times. I'll probably change that in the future. First screenshot is the old map, everything else is the new one.
  25. 10 points
    1. Episode 17.1 "Illusion" "Terra Gloria" is returned to the Rune Midgarts Kingdom. The adventurers will have a new adventure with Secret Wing. New story line, new dungeons, new monsters and new equipment are waiting for you all! Secret Wing with their rebellions are ready for the new battle! New monsters are waiting for the adventurers. New equipment from new episode. 2. Third classes second costumes Finally. The second costumes for third classes are updated. Players can change their costume via "Costume change ticket" in Stylist Shop. "Costume change ticket" can be obtained from achievement when you reach level 170 with third class character. Second costume is available in Stylist Shop! "Costume change ticket" It's reward from reaching level 170 All third classes second costumes appearance  3. Expanding third class base level and job level. Unfortunately. Awakening system has been halted. Dev team decide to just expand third class base level to 185 and job level to 65 instead. So. There is no talent point system anymore. Dev team will develop these systems somehow in the future. BTW in this anniversary Dev team decide to just expand third class base level to 185 and job level to 65 and expand maximum level of some skills too. Dev team will adjust experience table from level 100 to 175 so third classes will gain exp more faster than before (this includes job exp table too). New aura of level 185 and job level has been increased to 65 4. Skill adjustment due to level expansion. The following skills will be adjusted by increasing their max level and improving some of their effects. 4.1 Rune Knight 4.1.1 Enchant Blade - Increases max level from 5 to 10. - Changes SP consumption per level. 4.1.2 Sonic Wave - Increases max level from 5 to 10. - Improves damage formula. - Improve accuracy check depends on skills level. - Changes SP consumption per level. 4.2 Royal Guard 4.2.1 Shield Press - Increases max level from 5 to 10. - Removes Stun status inflicting. - Improves damage formula. - Splits damage display to 5 hit. 4.2.2 Genesis Ray - Increases max level from 5 to 10. - Changes damage type from holy (physical + magical) damage to holy magical damage. - Reduces skill cooldown and delay. - Changes SP consumption per level. - Removes requirement of Banding party members and also removes increased damage from Banding party members too. 4.3 Mechanic 4.3.1 Power Swing - Increases max level from 5 to 10. - From level 6. Skill delay has been reduced by half. 4.3.2 Arm Cannon - Increases max level from 3 to 5. - Increases area of effect depends on skill level.  4.4 Genetic 4.4.1 Cart Tornado - Increases max level from 5 to 10. - Removes knockback effect. - Skill cooldown is fixed to 2 seconds. - Skill delay is increased by 1 second. - Improves damage formula. - Splits damage display to 3 hit. 4.4.2 Spore Explosion - Increases max level from 5 to 10. - Increases nearby target damage from 75% to 100%. - Explosion delay is fixed to 2 seconds. - Improves damage formula. 4.5 Guillotine Cross 4.5.1 Weapon Blocking - When blocking is success. Gains "Counter state" for 10 seconds. 4.5.2 Counter Slash - Increases max level from 5 to 10. - Changes skill condition to can be used while "Counter state" is active, not when Weapon Blocking is success. - Improves damage formula. - From level 6. Increases area of effect to 5x5. 4.6 Shadow Chaser 4.6.1 Fatal Menace - Increases max level from 5 to 10. - Removes teleport effect. - When uses skill while dagger is equipped. Damage will be doubled. - From level 7. Increases Hit rate. 4.6.2 Feint Bomb - Increases max level from 3 to 10. - Increases travel distance depends on skill level. 4.7 Warlock 4.7.1 Freezing Spell - Increases max level from 5 to 10. 4.7.2 Tetra Vortex - Increases max level from 5 to 10. - From level 6. The skill also deal damage to nearby enemies too. - Since it will be multiple target from level 6. Damage formula from level 6 will be changed. 4.8 Sorcerer 4.8.1 Spell Fist - Increases max level from 5 to 10. - Duration depends on skill level. - Increases attack count to 3 times of skill level. 4.8.2 Varetyr Spear - Increases max level from 5 to 10. - Changes damage type from wind (physical + magical) damage to wind magical damage. - Increases SP consumption. - Increases area of effect. - Splits damage display to 3 hit. 4.9 Archbishop 4.9.1 Judex - Increases max level from 5 to 10. 4.9.2 Renovatio - Increases max level from 1 to 4. - Increases HP recovery amount depends on skill level. - Duration depends on skill level. 4.10 Sura 4.10.1 Fallen Empire - Increases max level from 5 to 10. - Reduces SP consumption. - From level 6. Reduces Spirit Sphere consumption from 2 to 1. - Improves damage formula. 4.10.2 knuckle Arrow - Increases max level from 5 to 10. - From level 6. Removes Spirit Sphere consumption. 4.11 Ranger 4.11.1 Aimed Bolt - Increases fixed casting time to 1 second. Reduces variable casting time by half. - Added 1 second cooldown. - Lower damage formula. - Number of attack won't depend on the immobilize status of target. - Fixes SP consumption to 40 for all skill level. 4.11.2 Trap Research - Increases max level from 5 to 10. 4.12 Wanderer & Minstrel 4.12.1 Metallic Sound - Increases max level from 5 to 10. - Damage will be doubled. - Removes SP reduction effect. 4.12.2 Severe Rainstorm - Can be used while Whip or Musical Instrument is equipped. - When using skill while Whip or Musical Instrument is equipped. Damage formula will higher than using bow. Source: http://ro.gnjoy.com/news/devnote/View.asp?category=1&seq=3890090&curpage=1 Part 2 1. New Hair Style "Silent Breeze" and "Humming Voice" for male. "Zeno Slasher" and "Wild Storm" for female. 2. Enhance MVP boss and enhance compensation Some MVP bosses will receive only 10% of damage taken. They'll have distinct display as green aura. MVP boss who has a green aura can receive all damage only 10%!> 10% of total damage received The MVP rewards will be improved. "Mysterious Combination Bundle" will be given. Mysterious Combination Bundle will give you random combination scroll of equipment or shadow equipment when open it. Combination scroll will be used to craft powerful item. Mysterious Combination Bundle and "Cursed Knight's Shield combination scroll". In recipe. The first ingredient has been censored. The second ingredient is Gelunium 30 ea. MVP bosses also drop "Gelunium" and "Shadowdecon" which are used as ingredient in combination scrolls. Shadowdecon and Gelunium 3. Jumping Event Player will receive free level 99 third class character for participation the event and receive new equipment. "Temporal Transcendent" equipment. "Temporal Transcendent" shadow equipment. Source: http://ro.gnjoy.com/news/devnote/View.asp?category=2&amp;seq=3891525&amp;curpage=1
  26. 10 points

    Version 1.0.0


    Hello everyone! I'm maken06. This is my second monster, enjoy it Don't steal credits, give credits to me, that I cost my effort to do them. Do Not edit my work without my permission, It includes recolors. pd: Do not forget to give me a reputation or reaction


  27. 10 points

    Version 1.0.3


    Extended Vending 2.0 Made in Git Hash: '042b88623bf549b88ba619991aaa186d45f7f998' Description Yet another version of Extended Vending, this one works in actual rA c++. It has a few fixes, including vending tax only working with Zeny as currency. What is new? I tried to improve this amazing mod adding a new feature: Vending Report (Mailbox). Basically... whenever you buy items to a vendor, he receive a report that who bough,what items, how many and total profit of them. You can disable this feature through conf/feature, or If you want to disable it for a specific player you must set the permanent variable called NOVREPORT (by a NPC/Bindatcmd/Idk) For < 2015-05-13 Clients Since old mailbox has 300 characters less than RoDex, I decided to take off items name and amount. So only will send 'who bought' and 'total profit'. Feel free to Donate If you want to support me.


  28. 10 points

    Version 1.0.0


    Hey there everyone, long time no see! So it's been a very long time since I have been on these boards and I do miss it all. Feeling a little nostalgia looking through these all, I decided to release them all to the public, completely free. Going in no particular order after the first few, they are just my favorites. I hope you guys love them as I have. Sanctum Main town oriented map. My absolute favorite and latest work (When I was mapping). The idea I had for this was a chuck of a mountain broke off and landed here, subsequently creating a waterfall from atop and surrounding the town. Giving it protection and a perfect center for life. I never got around to finishing the outside of the map, I don't even know what I thought for the surroundings, perhaps just trees. Sanctum In And here is the inside map for Sanctum. The first picture is the general area where various NPC's can be placed. The second picture is where I planned to use an script to automatically place anyone who wished to vend in the one walkable/edited Gat. It would cycle through and remove those vending for a prolonged period of time and also anyone not vending at all. Guild Base This map was designed for the top guilds or just those who hold castles to have a domain of their own. The first picture is just a hangout spot for anyone in the guild. The second picture is for any combat/training/monster summoning to be done. The third picture is for the guild master where special NPC's can be placed as the server owners desire.  Novice Starter Grounds PvP Valkyrie A little small for a PvP map but I enjoyed making it and like how it turned out. Trinity The first main town I made some time back around 2010. Don't judge me on some of the rookie mistakes I made with lighting and such haha. The following Trinity ___ maps are connected via a warp on the edges of the map. Trinity In Trinity Courtyard Before the Sanctum maps, this was my favorite creation. I just liked the feel of this one. Trinity Vending Similar to the Sanctum In vending idea, I wanted to limit vending to only those tiles with the colored objects on it. Trinity Port Anexus A simple instance based map with a boss at the end. Another one of my earlier works. Works The beginnings of my templates map. I would urge any current mapper to use this technique to create unique model compilations and copy it over to the map in progress. I have used this to create a forest that looks completely customized in a matter of minutes. Well there they are, open to any and all. I hope to hear your feedback on these! Thanks, Truly ~


  29. 10 points

    Version 1.8.0


    Hey everyone, This is a GRF tool I started to develop for my own personnal use, but I thought I'd share it since I've upgraded the UI. Its primary goal is to be easy to use while offering a wide variety of options and customizations. The software is quite stable and can handle large operations easily. How to install Download the zip archive provided from the download link at the bottom of this description or directly from there : http://www.mediafire.com/?aflylbhblrzpz0h Install the application with GRF Editor Installer.exe; if you are missing a .NET Framework you will be prompted to download it. Once you are done, you can start the program from the link on your desktop. Key features Overall speed is faster (or at least equal) than any GRF tool. Common operations : add, delete, merge, extract, preview, save. Undo and redo for any operation. It can open any GRF file. Clean and very interactive interface. Saving formats supported : 0x200, 0x103 and 0x102 (through the Settings page) and conversion to the Thor format. Instant filter and search options (example : "map .gat"). File association and context menus integration for .grf, .gpf, .rgz and .thor (through the Settings page). Can rebuild separated images into one file easily. Drag and drop (with the ALT key, can be modified in the Settings page). This is a big part of the software; most of the items can be moved around within the application itself or from/to Windows Explorer. Tools Sprite editor : a simple sprite editor with powerful features. Semi-transparent images can be added, you can easily change the order or replace images, etc. This tool can convert images in the wrong type by showing you multiple solutions (merging a new palette, dithering the image by using current palette, using the closest color, and a few more). Grf validation : allows you to validate a GRF with multiple settings. It can detect corrupted GRF entries, invalid sprites, empty files, non-GRF files, duplicate files and a lot more. Flat maps maker : generates flat maps from .gat and .rsw files. Useful to generate WoE maps or to fasten up the loading time. Patch maker : generates a GRF patch based on two different GRFs. Hash viewer : shows the hash code (both CRC32 and MD5) for files. Image converter : converts an image to any format requested (BMP, PNG, JPG, TGA). GrfCL : used to create batch files (.bat) which can automate tasks on GRF files. See the content in GrfCL.rar in the download for more information. This tool can be customized from the sources as well. Palette recolorer : creates new sprites by changing their colors (this tool is now deprecated). Client database editor : allows modifications of the database client files (txt and lua) with easy and simple tools. Work in progress. Grf encryption The encryption feature has been enabled again. It's similar to what it used to be and it has been tested on client versions ranging from 2012-08-01 to 2014-02-05. Some error messages will be displayed if necessary. If you have an issue, copy the error message (with the code, if there's one) and send me the client executable with the cps.dll file generated by GRF Editor. There shouldn't be compatibility issues anymore though! Thor files Thor files are patches used by Thor Patcher ( http://thor.aeomin.net/ ). Because of their similarity with the GRF file structure, they have been integrated within GRF Editor. The primary utility of this feature is that it allows you to add encrypted files to a Thor patch. All the other options can be achieved by using Thor Maker. You'll find the necessary steps below, but test your patches before sending them off to players (I've done a lot of testing on my end, but better be safe). If you're using SecureGRF, then make a new GRF, add the files and encrypt it. In GRF Editor, open the encrypted GRF you just made, use "Save as" and name the new file with a .thor extension. That's it, if you want to change the output directory, click on the root node of the project and select the tab "Container options". You can select the output mode and the GRF to merge the patch with. Simply save again if you change these properties. If you're using GRF Editor's encryption, then make a new Thor file (File > New > New Thor) and add the files you want to patch it with. Right-click on the files you want to encrypt and use Encryption > Encrypt. Technical stuff Requires .Net Framework 3.5 (SP1) Client Profile to run (3.5 or more will work as well). Automatically converts file name encoding to their proper values (you can change the encoding). Data virtualization is used as much as possible to preview files, meaning the files aren't completely loaded. Right-clicking an item will bring up the available options with that file. Preview file formats : txt, log, xml, lua, lub, bmp, png, tga, jpp, db, ebm, pal, gnd, rsw, gat, rsm, str, spr, act, imf, fna and wav. Services are "crash ready", meaning that you will be warned about a failed operation and no work will be lost (the application won't close and crash). It tries to continue operating even if it meets unsual conditions. Operations can be cancelled by clicking on the button near the progress bar. The warning level can be changed to avoid messages like "Please select a folder first." When prompted with an error, use Ctrl-C to copy the current dialog's content. Some screenshots! 1) Previewing an act file, while showing the search feature 2) Preview of a model file (rsm) 3) Preview of GrfCL with the MakeGrf command 4) Preview of maps 5) Preview of Grf validation 6) Search feature (press Ctrl-F or Ctrl-H to bring up within a text editor) Got a feedback? I'd gladly hear you out and fix issues you have with the program.


  30. 9 points
    Good Morning Another Prontera Edition that was requested some time ago. I thought it was good to show up. Software used: zbrush (for sculpting the organic tree), Photoshop (textures) and browedit (legacy). The map is simple but, sometimes "less is more"
  31. 9 points
    [Client Mod] Chat Timestamp As you can see in the picture above this Mod enables chat timestamps. To get this mod you can visit my github and get all the required files. (https://github.com/Normynator/Ragnarok/tree/master/client/extension/release) How to apply to your client? Add your client date to client_ver.h Compile it for x86 Use something like CFF Explorer (https://ntcore.com/?page_id=388) to add the dll to your client. Done. What clients are supported? 20180620 more to come. I have trouble with XY If you run into a linker error make sure that detours.lib is linked and that you compile for x86. If your Client does weird things/crashes (or whatever) please enable debug in client_ver.h and compile again. Start debug_server.py and put in 1337 if you get asked for a port. Start your client and wait until your bug appears, then check output of debug_server.py and send it here. How to get it for client date XY? If you buy me a coffee or energy dring (2$ Donation) I will sit down and add your requested client date. Buy a coffee/energy drink Also I will try to add new clientdates from time to time. Please don’t PM me directly, feel free to post your questions here. (Maybe someone else would ask your question too)
  32. 9 points
    December Digest 2018 The following digest covers the month of December 2018. Staff Changes: None Development Highlights: CORE: Fixed possible string out of bounds in configurations (9dbd3cb) Corrected White Imprison and reflected damage (40a4edc4) Corrected vector issue (2f5e1203) Fixed Renewal bBaseAtk readparam returning wrong value (32c68c73) Fixed clearing of sp_vanish_race (4cff45b8) Fixed missing login date for guild members (18f9574a) Fixed Skill Damage Database parsing (2d4a5949) Fixed pre-renewal atk (e8a7daec) Fixed homunculus auto feed for broken luas (9183a54a) Fixed SU_GROOMING while being frozen (7fa903ce) Fixed CN Meteor and Lunatic Carrot Beat damage (faee0cde) Fixed zero termination for bg messages (742232d5) Corrected some Summoner skills (570c07d5) Removed deprecated SI constants from src (e3dd6238) Fixed wrong replacements of CD_CURRENT_ECONOMY (732059ac) Unified infinite tick usage (016d15b7) Corrected AutospellOnSkill (75aef6a5) Fixed autobonus removal (fb81e2d7) Switched supported client to Ragexe (ec3b7077) Fixed unknown map in character select (1c987de7) Added support for viewpointvalue command (49444912) Corrected some statuses and Mado Gear interaction (0d816975) Added support for 64bit ticks (01f61cfa, 46138645) Added a missing check to TK_HIGHJUMP (63bfd611) Fixed reloadmobdb status calculation (8e58f2ce) Initial Release of Equipment Switch (818ff109, f5f377a7) DATABASE: Updated Lasagna Boss spawn (9f24814a) Changed equippable jobs for some items in pre-re/item_db.txt (93cf1881) Changed Thanatos gears to Thanos in item_db.txt (f5b546d6) Corrected job mask of some items (818f35ab) SCRIPT: Ghost Palace instance NPC name fixes (b87a1758) Fixed Taekwon Jobchanger Location (200b55e0) OTHERS: Fixed a documentation typo for bDropAddClass (9f880768) Disabled iterator sanity checks on VS (7c271d7e) Added epoll support on linux (eb2e40c3) List of Contributors: @4144, @admkakaroto, @aleos89, @Atemo, @AzarthMZintos, @Balferian, @Encon21, @Everade, @exneval, @Haikenz, @laziem, @Lemongrass3310, @MathReaper, @mrjnumber1, @nubspixel, @Playtester, @RadianFord, @reunite-ro, @Rolfxx, @secretdataz, @teededung, @Tokeiburu, @vstumpf, @whupdo, @yoonjunho72, @zackdreaver January Digest 2019 The following digest covers the month of January 2019 Staff Changes: None Development Highlights: CORE: Fixed Full Blast delay on attack and using items (4ec0c010) Corrected item bonus FixedCastRate (59593652) Fixed Reflect Damage not reflecting damage (7282dd87) Adjusted reload item database (444d7394) Refactored achievement conditions (4706115d) Fixed points command using negative numbers (6c1d1a84) Fixed a few more leftovers from 64bit tick (a5fc39e0) Corrected skills that give bonuses while sitting (b1865b31) Fixed CDP not failing when haven't met the requirements (a9f868f8) Corrected a few potential crash points (6c864927) Fixed a crash from MVP Ladder Warper (db3267a8) Updated Quagmire status removal list (626c2b7f) Disconnect player on map-server switch failure (19eef173c) Corrected status attack's element (298cfefd2) DATABASE: Corrected Honor Token weight (246dd2aa) Corrected Faceworm Larva Card bonus (1d0a2238) Corrected Cat Ear Beret bonus (6c6baff1) Fixed Costume Pocketwatch Hair Ornament location (394b16b8) Corrected Palace Guard Cap bonus (24c121b7) Added missing Costume Flying Galapago (f49c68f7) Fixed duration for items 12274 and 12275 (39906dac2) Corrected Shadow Staff script error (8839fe95) Corrected Owl Viscount Silk Hat script error (ec305337) Fixed pre-re Barricade HP value (d5ca1c73) Corrected Card/Enchant Combos (6bea2da3) Item db update (9cd9cab2) Update re/item_trade.txt based on itemmoveinfov5 (54b2cf32) Corrected Sarah's Battle Robe bonus (9d272f8f) Corrected Sling Item bonuses (fe12d6f0) SCRIPT: Added Clothing Effect Removal Service (8ed8fd1a) Change Magic Gear Master NPC name to Mado Gear Armourer for Renter Merchants (02c69f64) Added new Rebellion Shops (f3bb7e4b) Fixed wrong exp values on 13.1 and 13.2 quests and other minor fixes (c96671fc) Removed noicewall mapflag from several instance maps (79dffbd7) Updated OnTouch Royal messenger NPC (53498865) Updated NPC locations according client's navi file (b1b9720f) Fixed variable typo in agit_main_se.txt (43b3bc08) Fixed Hunting Missions (ad960e47) OTHERS: Allow increasing connection limit on linux (8ae788b6) Add missing unit type documentation (de70e498) Added MS support for the function macro (e415e642) Changed skip into error (de8c707f) List of Contributors: @aleos89, @Angelic234, @Atemo, @attackjom, @Badarosk0, @Balferian, @bgamez23, @BrOgBr, @cydh, @Daegaladh, @danielbernard, @darhylism, @Everade, @Indigo000, @Kezzo, @laziem, @Lemongrass3110, @LunarSHINING, @mrjnumber1, @Normynator, @nubspixel, @RadianFord, @rAthenaCN, @sigtus, @teededung, @Tokeiburu, @zackdreaver
  33. 9 points
    Bonjour! I finished another map of the Gaia Series, totally customized, and with that touch of fantasy. The Enchanted Village! The idea of this map is to be the main city of the Gaia project, an idealized instance created by TioAkima, where there will be PVP, dungeons, fiefdoms, items, NPCs, Mobs, VIP Room, etc ... All this theme. (Below are some prints and video of the Map) One more touch of fantasy of TioAkima ... VIDEO SHOWING THE MAP MORE DETAIL LOOK THE MOVIE! Leets'rooock For those who have not seen yet, the PVP with the same theme, Look the video! LOOK THE MOVIE! GO! Leets'plaaaaaaaay guys This is GAIA PVP End! Thanks
  34. 9 points

    Version 1.0.0


    CRYSTAL II CUSTOM MONSTER Greetings again, rAthena! I'm Haziel, once more, I'm back planning on new freebies every week! For the first one of this new series of free content, I'm bringing a new utility sprite: Crystal II. Crystal II is a Custom Monster, an alternate version to my previous release Crystal, obviously meant to be used in Events, Battlegrounds, War of Emperium or any of those kinds of environments where breaking a seal, switch or crystal might be an objective. It has Standing, Damage and Dying animations. As usual, Sound Effects are included and it also comes in four colours: I hope you enjoy the final product! If you're interested on my work, Contact me on hyering or through one of the channels below! By downloading this file, you agree with my Terms of Service: • YOU WILL NOT remove my signature from any of the included files. • YOU WILL NOT alter, edit, recolour any of my files unless for your personal use. • YOU WILL NOT repost, repass or mirror my work nor edited versions of it anywhere. • YOU WILL NOT sell, resell or in any manner, ask money or rewards using my work as exchange. • YOU WILL NOT claim my work as yours.


  35. 9 points
    by short description There are 3 different generations of laboratory monsters: 1. Egnigem, Wickebine, Laurell, Errende, Josephina, Kavach, Armeyer 2. Seyren, Eremes, Kathryne, Margaretha, Cecil, Howard 3. Randel, Gertie, Celia, Chen, Trentini, Alphoccio, Flamel I collect them, correct mistakes, add every possible class to each monster, recolor them in 3 official color sets and improve their aura. As a basis, I took the logic of the first implemented sprites at lhz_dun01-03 If you compare the following kRO sprites with corrections in the changelog you will notice that the logic has ceased to be respected and the sprites do not even have sounds! [DONE] 1st classes, 2nd classes, advanced classes, 3rd classes, 3rd japan edition classes, king of the alley, the last one, custom extended classes, summoner The total number of sprites in the pack: ~150 classes (including different types of weapons) x 3 color sets x 2 different auras = ~900 sprites changelog: (!) Below are the non-clean gifs recorded using GifCam.exe over the Act Editor (!) So these can brake or accelerate and do not serve as an accurate image. These gifs are added just for reference For clarity, the background of the laboratory is taken, and the sprites are shown in transparent blue 969F9EE7 and with improved aura Seyren Windsor Eremes Guile Kathryne Keyron Margaretha Sorin Cecil Damon Howard Alt-Eisen Randel Lawrence Gertie Wie Celia Alde Chen Lio Trentini Ilaria Alphoccio Basil Flamel Emure Egnigem Chenia Wickebine Tres Laurell Weinder Errende Ebecee Josephina Kavach Icarus Armeyer Dinze The Last One & King of the Alley Cheril Belle (Custom) Weikath Valtz (Custom) Keytar Oracle (Custom) Rachel Wirth (Custom) Mary Liz Felany (Custom)
  36. 9 points
    Original guide is in Hercules forum, I just import the information into rAthena since both emulator share most of the similar trait when using query_sql and I guess the main reason is Olrox reminded me to do so ... because someone else might claim it as their own ... etc Anyway, this guide is a compilation of SQL commands that I have used, or Questions answered on the forum every single subject here are related to rAthena/Ragnarok Online in some ways, so you won't feel bored reading them XD Table of Content 1. When to use *escape_sql script command 2. How to build a case-sensitive table 3. Choose a table type, MyISAM or InnoDB ? 3a. How to index a table properly 3b. Why you shouldn't use `char_reg_num` table 4. AUTO_INCREMENT 5. How to do IF-ELSE in SQL query ? 5a. How to update multiple rows on different conditions in a single query 6. How to show the current rank of the player 7. INSERT INTO ... SELECT ... 8. Table JOIN vs AS 9. What is the maximum string limit for *query_sql 9a. UNION This topic will open to Suggestions, Ideas, Improvements, and Questions ~ You may also post up your tricks if you want to share with us 1. When to use escape_sql script command . input [email protected]$; dispbottom [email protected]$; dispbottom escape_sql([email protected]$); it doesn't has much differences, because it only affect 3 special characters ' <- single quotation mark " <- double quotation mark \ <- left slash if I input -> haha"lala'hehe <- it will return -> haha\"lala\'hehe <- this is what we call, Escape a character in rAthena script, we also know we can use " symbol in any string input mes "Susan says :\" Today I ate 3 eggs \"."; where in the game client, you can see the " symbol in the npc msg box let's say I have a sql script like this prontera,153,171,5 script Show Characters 1_F_MARIA,{ mes "input name, I'll show you all characters name it has on that player's account"; input [email protected]$; [email protected] = query_sql("SELECT `char_id`, `name` FROM `char` WHERE `name` LIKE '"+ [email protected]$ +"'", [email protected], [email protected]$); if ( [email protected] ) { mes "no result"; close; } for ( [email protected] = 0; [email protected] < [email protected]; [email protected] ) mes [email protected][[email protected]] +" "+ [email protected]$[[email protected]]; close; } this script has a possibility to be hacked because to perform sql injection, I can enclose the string with quotation mark, then use another sql command to hack BUT with an escape_sql command, if the user want to enclose the string with quotation mark to hack the script the escape_sql command escaped the string, the quotation mark the user input will be escaped thus the script will become impossible to hack just now that script was for string input prontera,153,171,5 script Show Characters 1_F_MARIA,{ mes "input account ID, I'll show you all characters name it has on that player's account"; input [email protected]$; [email protected] = query_sql("SELECT `char_id`, `name` FROM `char` WHERE `account_id` = "+ escape_sql([email protected]$), [email protected], [email protected]$); if ( [email protected] ) { mes "no result"; close; } for ( [email protected] = 0; [email protected] < [email protected]; [email protected] ) mes [email protected][[email protected]] +" "+ [email protected]$[[email protected]]; close; } this is another stupid case. 1. the scripter use string input while the script just needed a number 2. even with escape_sql command over there, there is no quotation mark at all yes this script also has a risk to be hack because escape_sql only escape quotation mark. that hacker don't even have to input quotation mark because it is a number and an injection query can be sent without any quotation mark input there are 2 ways to solve this either use numeric variable for the input command or enclose that .... ..... WHERE `account_id` = '"+ escape_sql([email protected]$) +"'", .... with single quotation mark, when the hacker input a quotation mark will be escaped by escape_sql command Reference : https://www.w3schools.com/sql/sql_injection.asp escape_sql command for another thing is if the player register their names containing ' or ", these characters are escaped only happens when the server have no restriction on the creation of players name rAthena\conf\char_athena.conf // Manage possible letters/symbol in the name of charater. Control character (0x00-0x1f) are never accepted. Possible values are: // NOTE: Applies to character, party and guild names. // 0: no restriction (default) // 1: only letters/symbols in 'char_name_letters' option. // 2: Letters/symbols in 'char_name_letters' option are forbidden. All others are possibles. char_name_option: 1 and this was what happened to my SQL dota pvpladder script Silo's Babies <-- this is a guild name you can see the 5th string has a single quotation mark with escape_sql command, that string will turn into Silo\'s Babies <-- the quotation mark is escaped when send to sql query 2. How to build a case-sensitive table this is the answer I found Reference : http://dba.stackexchange.com/questions/15250/how-to-do-a-case-sensitive-search-in-where-clause by default, the table creation use charset = latin1; means it couldn't do a case-sensitive search if you want to do a case-sensitive in a query, use BINARY SELECT * FROM `char` WHERE `name` = BINARY('AnnieRuru'); however using BINARY might have performance hit if it is a big table so its more recommend to convert your SQL table to collate with latin1_general_cs let's say this is a sample table CREATE TABLE `test` ( `id` INT(11) PRIMARY KEY AUTO_INCREMENT, `name` VARCHAR(23) )ENGINE = InnoDB; do an ALTER table syntax ALTER TABLE `test` MODIFY COLUMN `name` VARCHAR(23) COLLATE latin1_general_cs; or just put it into the table creation CREATE TABLE `test` ( `id` INT(11) PRIMARY KEY AUTO_INCREMENT, `name` VARCHAR(23) )ENGINE = InnoDB DEFAULT CHARSET = latin1 COLLATE latin1_general_cs; 3. Choose a table type, MyISAM or InnoDB ? https://stackoverflow.com/questions/20148/myisam-versus-innodb Before MySQL 5.5, MyISAM is mostly use for read-heavy + table locking storage engine = such as pvp ladder ( always select ... order by kill desc ) InnoDB is mostly use for write-heavy + row locking storage engine = such as quest script ( select ... from char_id ... only 1 row is retrieve ) After MySQL 5.6, (currently is 8.0) just stick to InnoDB there is only 1 reason MyISAM is better than InnoDB - MyISAM use smaller disk usage than InnoDB let's take a look at rAthena MyISAM to InnoDB converter https://github.com/rathena/rathena/blob/master/sql-files/tools/convert_engine_innodb.sql This converter is useful if you are using MySQL 5.6 or above There are 4 tables that are commented out the reason is simple, these 4 tables only read once and forgotten when server is live since MyISAM is good at reading (SELECT) + smaller disk usage, its no use to convert these 4 tables into InnoDB 3a. How to index a table properly http://mysql.rjweb.org/doc.php/index_cookbook_mysql http://www.dbta.com/Columns/DBA-Corner/Top-10-Steps-to-Building-Useful-Database-Indexes-100498.aspx a simple thumb of rule, anything that is SELECT .... WHERE `field` = ..... that `field` has to be index let's take a look at this PVP Ladder script that use Kill/Death ratio CREATE TABLE `pvpladder` ( `char_id` INT(11), `name` VARCHAR(23), `kills` INT(11), `death` INT(11), PRIMARY KEY (`char_id`), KEY (`kills`, `death`) ) ENGINE = InnoDB; prontera,155,186,6 script PVP Ladder 1_F_MARIA,{ [email protected] = query_sql( "SELECT `name`, `kills`/(`death`+1) FROM `pvpladder` WHERE `kills` > 0 ORDER BY `kills`/(`death`+1) DESC LIMIT 10", [email protected]$, [email protected]$ ); if ( [email protected] ) { mes "no entry"; close; } mes "Current Ranking :"; for ( [email protected] = 0; [email protected] < [email protected]; [email protected] ) mes "No."+([email protected] +1)+" ["+ [email protected]$[[email protected]] +"] "+ [email protected]$[[email protected]] +" kill"; close; OnPCKillEvent: if ( killedrid == getcharid(3) ) { // killing self should only increase death count. EG: Grand-cross query_sql "INSERT INTO `pvpladder` VALUES ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) )+"', 0,1 ) ON DUPLICATE KEY UPDATE `death` = `death` +1"; end; } query_sql "INSERT INTO `pvpladder` VALUES ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) )+"', 1,0 ) ON DUPLICATE KEY UPDATE `kills` = `kills` +1"; attachrid killedrid; query_sql "INSERT INTO `pvpladder` VALUES ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) )+"', 0,1 ) ON DUPLICATE KEY UPDATE `death` = `death` +1"; end; } This kind of query -> ORDER BY kills/death, needs to index them together like this KEY (`kills`, `death`) 3b. Why you shouldn't use `char_reg_num` table There are 2 reasons why you shouldn't even touch all these variable tables Reason no.1 This table is sorely meant for server usage Once these data is loaded, it is process internally, and only save character data according to this configuration Reason no.2 The `value` field is not index ! This line has ORDER BY `value`, try recheck our main.sql file CREATE TABLE IF NOT EXISTS `char_reg_num` ( `char_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` int(11) NOT NULL default '0', PRIMARY KEY (`char_id`,`key`,`index`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; SQL will search through every single line in the `value` field if that column isn't index Of course you can ... do ALTER table to add KEY to the `value` field but this table has already optimized in that way for server usage the more field you index into the table, the more disk usage space it use Conclusion : If you want to make a custom script, then make a custom table. Leave these table alone ! 4. AUTO_INCREMENT CREATE TABLE `support_ticket` ( `id` INT(11) AUTO_INCREMENT, `title` VARCHAR(70), `message` VARCHAR(255), PRIMARY KEY (`id`) ) ENGINE = InnoDB; In this kind of query that has AUTO_INCREMENT, many people do .... $support_ticket_id++; query_sql "INSERT INTO `support_ticket` VALUES ( "+ $support_ticket_id +", '"+ escape_sql([email protected]$) ... can be optimize .... using NULL query_sql "INSERT INTO `support_ticket` VALUES ( NULL, '"+ escape_sql([email protected]$) ... can retrieve the last row with query_sql "SELECT MAX(`id`) FROM `support_ticket`", [email protected]; // ----- OR ----- query_sql "SELECT LAST_INSERT_ID()", [email protected]; Question : This question was asked on eathena forum board One of my friend touched my custom table and the AUTO_INCREMENT has jump off the value | 1 | <data set 1> | 2 | <data set 2> | 3 | <data set 3> | 25854 | <data set 4> | 25855 | <data set 5> | 25856 | <data set 6> I want to make the value return back to normal as shown | 1 | <data set 1> | 2 | <data set 2> | 3 | <data set 3> | 4 | <data set 4> | 5 | <data set 5> | 6 | <data set 6> How to do this WITHOUT losing any of the current data ? Answer: The trick is ... just drop that column and rebuild it ALTER TABLE `inventory` DROP COLUMN `id`; ALTER TABLE `inventory` ADD COLUMN `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; convert the table into MyISAM will process the query much faster 5. How to do IF-ELSE in SQL query ? Question : I have a PVP ladder script that runs on Points system. Each kill plus 1 point and each death minus 1 point. The problem is, this query will make the points go into negative value if the player is being kill repeatedly query_sql "UPDATE `pvp_points` SET `points` = `points` - 1 WHERE `char_id` = "+ getcharid(0); How do I make the points stop at 0 if the player is already at 0 points ? Answer : query_sql "UPDATE `pvp_points` SET `points` = IF(`points` = 0, 0, `points` - 1) WHERE `char_id` = "+ getcharid(0); query_sql "UPDATE `pvp_points` SET `points` = (CASE WHEN `points` = 0 THEN 0 ELSE `points` - 1 END) WHERE `char_id` = "+ getcharid(0); Explanations: similar to rAthena script language, if (<condition>) <execute true condition>; else <execute false condition>; in SQL language IF(<condition>, <execute true condition>, <execute false condition>) CASE WHEN <condition> THEN <execute true condition> ELSE <execute false condition> END Reference : https://www.w3schools.com/sql/func_mysql_if.asp https://stackoverflow.com/questions/63447/how-do-i-perform-an-if-then-in-an-sql-select 5a. How to update multiple rows on different conditions in a single query This query will update multiple rows on different condition UPDATE `pvpladder` SET `points` = CASE WHEN `char_id` = 150000 THEN `points` +1 WHEN `char_id` = 150001 THEN `points` -1 END WHERE `char_id` IN (150000,150001); Reference : https://stackoverflow.com/questions/20255138/sql-update-multiple-records-in-one-query 6. How to show the current rank of the player Question : This is the part of the script, output as below [email protected] = query_sql("SELECT `name`, `kills` FROM `pvpladder` ORDER BY `kills` DESC LIMIT 5", [email protected]$, [email protected]); for ( [email protected] = 0; [email protected] < [email protected]; [email protected]++ ) mes "No."+([email protected]+1)+" ["+ [email protected]$[[email protected]] +"] ~ "+ [email protected][[email protected]] +" kills"; No.1 [Alice] ~ 19 kills No.2 [Emily] ~ 11 kills No.3 [Irene] ~ 11 kills No.4 [Brittany] ~ 8 kills No.5 [Fiona] ~ 7 kills 2nd place and 3rd place has the same amount of kills, how do I make both of them display as 2nd place like this ? No.1 [Alice] ~ 19 kills No.2 [Emily] ~ 11 kills No.2 [Irene] ~ 11 kills No.4 [Brittany] ~ 8 kills No.5 [Fiona] ~ 7 kills Answer : Method no.1: Convert the table into InnoDB will return the result faster. Allow to use OFFSET [email protected] = query_sql("SELECT `name`, `kills`, FIND_IN_SET(`kills`, (SELECT GROUP_CONCAT(`kills` ORDER BY `kills` DESC) FROM `pvpladder`)) FROM `pvpladder` ORDER BY `kills` DESC LIMIT 5", [email protected]$, [email protected], [email protected]); for ( [email protected] = 0; [email protected] < [email protected]; [email protected] ) mes "No."+ [email protected][[email protected]] +" ["+ [email protected]$[[email protected]] +"] ~ "+ [email protected][[email protected]] +" kills"; Method no.2: This method return result faster than method 1 in huge table. Not allow to use OFFSET [email protected]$ = "SELECT `name`, IF(@d=t.`kills`, @r, @r:[email protected]), @d:=t.`kills`, @i:[email protected]+1 "; [email protected]$ += "FROM `pvpladder` t, (SELECT @d:=0, @r:=0, @i:=1)q "; [email protected]$ += "ORDER BY `kills` DESC LIMIT 5"; [email protected] = query_sql([email protected]$, [email protected]$, [email protected], [email protected], [email protected]); for ( [email protected] = 0; [email protected] < [email protected]; [email protected] ) mes "No."+ [email protected][[email protected]] +" ["+ [email protected]$[[email protected]] +"] ~ "+ [email protected][[email protected]] +" kills"; . . Question : How do I show the current ranking of the player ? mes "Your kills -> "+ [email protected]; mes "Your rank -> "+ [email protected]; Answer : query_sql "SELECT `kills`, 1+(SELECT COUNT(1) FROM `pvpladder` t1 WHERE t1.`kills` > t2.`kills`) FROM `pvpladder` t2 WHERE `char_id` = "+ getcharid(0), [email protected], [email protected]; Remember to index the `kills` field Reference : https://dba.stackexchange.com/questions/13703/get-the-rank-of-a-user-in-a-score-table . 7. INSERT INTO ... SELECT ... Question : This question was asked on eathena forum . Note: at the time the old mail system was unstable and not many server use it I want to reward my players for supporting my server. I want to give every player who are still actively login in this year (2010) an item ID 22574 in their storage How do I achieve this ? Answer : Run this SQL command when your server is offline INSERT INTO `storage` (`account_id`, `nameid`, `amount`, `identify`) SELECT `account_id`, '22574', '1', '1' FROM `login` WHERE DATE(`lastlogin`) >= '2010-01-01' && `account_id` !=1; The reply from the topic starter gives a feed back, including this Inserted rows: 7738 Inserted row id: 8244859 (Query took 13.6253 sec) 8. Table JOIN vs AS CREATE TABLE `pvpladder` ( `char_id` int(11) PRIMARY KEY, `points` int(11) ) ENGINE = InnoDB; This table is missing the `name` field. So have to retrieve the `name` from the `char` table. A simple way is using table JOIN SELECT `char`.`char_id`, `char`.`name` , `pvpladder`.`points` FROM `pvpladder` LEFT JOIN `char` ON `pvpladder`.`char_id` = `char`.`char_id` ORDER BY `pvpladder`.`points` DESC LIMIT 10; However, there is an uncommon method, the same thing can be done using Aliases SELECT `char_id` AS `CID`, (SELECT `name` FROM `char` WHERE `char_id` = `CID`), `points` FROM `pvpladder` ORDER BY `points` DESC LIMIT 10; In this example, both tables `char` and `pvpladder` have the `char_id` field index as PRIMARY KEY and thus both examples return the result in same amount of time However, there is a key difference on the optimization speed if the one of the table is not index properly The below example, `item_id`.`id` field is index as PRIMARY KEY, but `mob_db`.`DropCardid` is not index SELECT `mob_db`.`ID`, `mob_db`.`kname`, `item_db`.`id`, `item_db`.`name_japanese` FROM `mob_db` LEFT JOIN `item_db` ON `mob_db`.`DropCardid` = `item_db`.`id` WHERE `mob_db`.`DropCardid` > 0; SELECT `ID`, `kname`, `DropCardid` AS `ITEM_ID`, (SELECT `name_japanese` FROM `item_db` WHERE `id` = `ITEM_ID`) FROM `mob_db` WHERE `mob_db`.`DropCardid` > 0; The 2nd query that uses Aliases will return result faster than table JOIN in this case Conclusion : If use table JOIN, you have to keep in mind that the joined column has to be index but if use AS, there is no need to consider this issue 9. What is the maximum string limit for *query_sql Since query_sql sending the query as a string, we can actually use string manipulation script commands such as *sprintf and *implode Example : *sprintf Example : *implode So, someone might ask, what is the string limit for query_sql until the map-server show error ? The answer is very surprising ... I just tested with above script, and it still works perfectly fine ! loop -> 64.210 seconds query -> 3.229 seconds it means, ahh .... or maybe ... The answer might be ... [SQL]: DB error - MySQL server has gone away [Debug]: showmsg: dynamic buffer used, increase the static buffer size to 4306185 or more. until MySQL stop responding XD 9a. UNION Just now the *implode example, it just shows the `mvp_id`, but if we want to display the information like this, +--------+------------------+------------+-----------------------+ | MVP_ID | MVP_NAME | DropCardid | MVP_CARD_NAME | +--------+------------------+------------+-----------------------+ | 1086 | Golden Thief Bug | 4128 | Golden Thiefbug Card | | 1115 | Eddga | 4123 | Eddga Card | | 1150 | Moonlight Flower | 4131 | Moonlight Flower Card | for ( [email protected] = 0; [email protected] < [email protected]; [email protected] ) [email protected]$[[email protected]] = "( "+ [email protected][[email protected]] +", (SELECT `kname` FROM `mob_db` WHERE ID = "+ [email protected][[email protected]] +"), (SELECT `DropCardid` FROM `mob_db` WHERE ID = "+ [email protected][[email protected]] +"), (SELECT `item_db`.`name_japanese` FROM `item_db` LEFT JOIN `mob_db` ON `item_db`.`id` = `mob_db`.`DropCardid` WHERE `mob_db`.`ID` = "+ [email protected][[email protected]] +") )"; query_sql "INSERT IGNORE INTO `mvp_table` VALUES "+ implode( [email protected]$, ", " ); This part ... can be optimize with UNION for ( [email protected] = 0; [email protected] < [email protected]; [email protected] ) [email protected]$[[email protected]] = "SELECT "+ [email protected][[email protected]] +", `kname`, `DropCardid` AS `MVP_CARD`, (SELECT `name_japanese` FROM `item_db` WHERE `id` = `MVP_CARD`) FROM `mob_db` WHERE ID = "+ [email protected][[email protected]]; query_sql "INSERT IGNORE INTO `mvp_table` "+ implode( [email protected]$, " UNION " ); DONE ---- FINALLY !! Yes, I knew the chapter 5 and beyond is very tough to understand ... it also took me longer time to write and test all these advance SQL techniques too Anyway, this topic is now open to Suggestions, Ideas, Improvements, and Questions ~ You may also post up your tricks if you want to share with us
  37. 9 points
    July Digest 2018 The following digest covers the month of July 2018. Staff Changes: None Development Highlights: CORE: Added a 'force' option to attachrid (b3643bfe4) Fixed broken guild notices (b3a51eaa) Fixed logging of #CASHPOINTS and #KAFRAPOINTS (ce9cbd2e) Added possibility to log without attached player (3faf7004) Added support for packet sending map data 0xAC5 (145b60f7) Added Guild Storage Expansion Skill (e13ca63c) Fixed a bug with warlock's spheres (cea5ad71) Corrected SC_MTF_CRIDAMAGE bonus not triggering (6b148d5c) Refactored roulette system (fe7c0a78) Missing returns for inarray and countinarray (500cfdc4) Added empty packet functions for private airship (74efc7d6) Cleaned up Summer 2 code (b2c026d4) Corrected some item bonuses not triggering (fdd24756) Pets should mimic master's walk speed (042b8862) Fixed Guild Storage Expansion skill saving (bfd7af34) Replaced HID timer function parameters in a macro (c4d7dc76) Freezing and Burning can occur at the same time (1a6bc209) Negative MDEF should not increase damage taken from magic (030443c9) Initial Release of Attendance Feature (a5588dd9) Updated max recovery weight to 70% for renewal (b409936f) Resolved Guild Storage Expansion not updating (bbe552d1) Cleaned up the mapflag system (a942853d, 93139226) Fixed missing curly braces in reloadscript (123303ef) Fixing party death icon in newer clients (95c3aed8) Fixed a bug with disable_items script command (6b3f0717) Fixed EXP bug and added failsafe to family check functions (952ac43e) Cleaned up map data storage (584fcac4) Fixes channel command crash (3de9a44f) Initial release of private airship system (8dea04a8) Fixed walk_choices's type (a05ed6e8) DATABASE: Fixed incorrect drop_id in quests (1b72f727) Updated Shield Spell behavior (d612788e) Updated Axe Mastery behavior (20a72e0c) Updated Masquerade effects (f2437f4a) Adjusted Amistr's Defense behavior (3de58247) Adjusted Shield Chain range (eeb01923) Corrected TWO skills according to aegis datas (cd05eb15) Update Airship Assault Monster stats (7717c1e6) Corrected Spiritual Sphere Absorption and Cursed Circle interaction (4f97c749) SCRIPT: Fixed issue with Gunslinger Manual (e4eddc3e) Fixed rate for HD material in shadow refiner npc (f9797109) Added comments in custom quest_shop.txt (84299027) Added extra npc checks (6e8599cd, 6b19b72d) Corrected Archer Training bug (532e043) Added Academy monster re-spawn (4db212bf) Fixed quest warning in quests_amatsu.txt (12f62e63) Implemented Banquet for Heroes ep 16.1 (7a8ac464) Added extra nowarpto on some maps (f1f47091) Fixed npc location for Lutie quest (58eadcda) Fixed a mistake in 2008 headgear quest (fa4021d2) OTHERS: Updated travis script (a8b7476c) Fixed a few compiler warnings on clang (91169d7e) Update tools/config.pl (62ac5be4) Added .editorconfig file to force editor settings for certain file types (3165e521) Statistics: Excluding merges, 11 authors have pushed 76 commits to master and 115 commits to all branches. On master, 194 files have changed and there have been 28,777 additions and 7,054 deletions. 61 Active Pull Requests 66 Active Issues 51 Merged Pull Requests 10 Proposed Pull Requests 49 Closed Issues 17 New Issues List of Contributors: @4144, @admkakaroto, @Akkarinage, @aleos89, @anacondaqq, @Atemo, @AzarthMZintos, @Balferian, @BrOgBr, @cydh, @Daniel4rt, @Daegaladh, @DavidPS92, @ecdarreola, @EthernalFriend, @Everade, @flamefury, @functor-x, @gladio78, @gustavobrigo, @Haikenz, @hendra814, @Kutikuti, @Lemongrass3110, @lRaikeNl, @MrLekkz, @nornane, @RadianFord, @Raf4h, @sader1992, @secretdataz, @spinzaku, @teededung, @tmav94, @uddevil, @V0rr, @vykimo, @yoonjunho72 Show your support to rAthena by submitting your Issue or Pull Requests!
  38. 9 points
    Sup rA. Here's a town map I put together a while ago, it's a fresh coat of paint on an old map made by someone else a really long time ago. You might've seen the old version a few servers, or if you look for it as part of Denny's map pack in the downloads section. This version is a lot better.
  39. 9 points
    June Digest 2018 The following digest covers the month of June 2018. Staff Changes: @sader1992 is now a Content Moderator. Development Highlights: CORE: Added new jRO hat effects (b2594f48) Corrected Tarot Card dispelling Clan buffs (f4e8dee5) Removed an extra semicolon typo (3a918fa4) Initial support for Star Emperor and Soul Reaper (fc951469) Moved common, config and mapcache to C++ (801d3ed9) Updated Mado Gear effects (dc413a3c) Resolved some compile issues (1ce3792a) Fixed over refine bonus (105cc3ab) Updated Freezing effects (5e9a23de) Corrected Cloud Kill behavior (f3eab9dd) Corrected Crystallized state effect (375f0ae4, 8e9f7a59) Fixed MariaDB compilation problems (21cb1a22) Synchronized source file headers (11b42569) Fixed CMake on Windows (4633ab5c) Fixed a map-server crash from getitem3 (23f7b945) Added item random options into picklog (d5a815a6) Cleaned up some hardcoded variables (880e227e) Added clan name display (9a7e27b6) Removed useless debug variables for an old issue (55f1b01b) Fixed Silvervine Root Twist animation for players (796a67be) Fixed compiler warnings in malloc.cpp on x86 (a4336fd8a) Enable autobonus to be reactivated (e7fd6aa5) DATABASE: Added lhz_d_n2 and other missing maps, plus its mapflags (f025be5f, 87db2326) Updated Achievement database (ef046159) Fixed Goldsmith Dagger class equip requirement (879ef2af) Fixed Chewy Ricecake and Oriental Pastry bonuses (f6758959) Corrected Variable Cast Rate for Geffen Magic Robe in Renewal (00e518b2) Fixed many items at Pre-RE and RE database (f7c62d28) Added missing maps to map_cache (acebcd38) Fixed Bloody_Roar and Bloody_Roar_C item scripts (e4a80565) Corrected Devil Whisper Costume drops (a215ed97) Corrected End Sektura bonus (4a64eb49) Corrected Sightless Mind range (aef23561) Fixed some accessory being refineable (380dde04, 9c50cd76) Additionally removed refineable value from Dungeon_Ticket (18873555) Fixed Drooping Pope and Imperial Spear item script (1c950627) Fixed Bunker Shield item script (8c4be8db) SCRIPT: Initial release of Morse Cave instance (d388a712) Added Old Glastheim Buffs (7c4d7692) Added Hero Ring exchanger and Enchant NPCs (6c0da909, 967f28ed) Updated custom mushroom script (006efe11) Corrected spelling issues in Dewata Quests (f67b353a) Corrected spelling and made name change in Rune Knight Job Change Quest (87913bcd) Fixed a typo in guildcastles.txt (915c1562) OTHERS: Added Inkfish to mailmap (98e2cfd2) Added Valaris to mailmap (85413183) Added jTynne to mailmap (37330448) Added a build test for GCC-8 (4044966e) Statistics: Excluding merges, 10 authors have pushed 72 commits to master and 131 commits to all branches. On master, 336 files have changed and there have been 5,878 additions and 10,015 deletions. 55 Active Pull Requests 60 Active Issues 40 Merged Pull Requests 15 Proposed Pull Requests 48 Closed Issues 12 New Issues List of Contributors: @aleos89, @Atemo, @Balferian, @bentheexo, @BrOgBr, @cahya1992, @crazystorm2017, @cydh, @danielbernard, @ecdarreola, @Everade, @exneval @Felleonel, @flamefury, @Haikenz, @laziem, @Lemongrass3110, @mazvi, @mrjnumber1, @Questune09, @Raf4h, @redlightliu, @Rytech2, @secretdataz, @teededung, @zackdreaver Show your support to rAthena by submitting your Issue or Pull Requests! By providing enough useful info (Git Hash, Client Date, RE/Pre-RE, crashdump, how to reproduce, etc) you will help us to solve the issues faster
  40. 9 points
    Hi, Here is my last map. Inspirated from this : Screenshots : The center platform is for players to manage their team. Rate it please
  41. 9 points
    Story Time: A lot of players run into problems. They disconnected in an instance, they bought the wrong item, someone is being a nuisance in battlegrounds. After cursing, they usually type `@request`. But alas, none of the GMs you hired are online! You need to dock their pay. The message is lost in the void. Until now. Discord has support for webhooks, which is a way to associate callbacks to HTTP requests. Their developer docs for webhooks can be found here. Basically, you can send a POST to your discord webhook url, and the contents will be printed to the associated channel. "So?" When someone uses `@request`, the message is sent from the map server to the character server, which then sends it back to all map servers, and the map servers send the message to all connected GMs. Because it sends it to the character server, we're able to send the POST request from the character server. This helps performance, since the map server is constantly doing things and the character server generally uses less resources. "That's great! But how do we send this POST request? Do I need a stamp?" If you're on Linux, there's a great command line tool called `curl`. It's mostly used to download files from a server, but it also has support for all other HTTP methods. "Command line? How do we put it in rathena?" Curl also comes with a library called libcurl that we can use in c/c++ programs! "I see, so we use libcurl to send the message to the discord webhook!" Exactly! How it looks: Installation: Two config options are added in this patch: gm_whisp_webhook and gm_whisp_webhook_url This makes a change to configure, and adds a new flag. You need to add --with-lcurl to your arguments. Example: ./configure --enable-prere --enable-vip --enable-packetver=20170614 --with-lcurl Disclaimers: This only works on linux. I don't run rAthena servers on windows, and neither should you. (personal opinion) You need to install libcurl-devel. On some OSes it could be called something else; on Ubuntu, it's libcurl4-openssl-dev. Don't ask me for a lot of help if you can't get it to work. This is supposed to be a showcase, but I'm giving the code out. I made this in a day, it's not the greatest code. Initializing curl and cleaning up on every call is not the greatest, but unless you are getting 100 requests a minute, it should be ok for now. Eventually, I want to add it to src/common or something. But that'll happen in a future weekend. Code: The code is here: https://pastebin.com/Z82M9ssf
  42. 8 points
    The forums have been sucessfully upgraded to the newly available IPS 4.4 branch. There are an awful lot of changes, which can been seen below. IPS Community Suite 4.4.0 Released 02/25/2019 Key Changes Major New Features / Enhancements Post Before Registering Animated GIFs AdminCP Notification Center New Email Features: Email Statistics Email Advertisements Unfollow Without Logging In SEO Improvements: Improved pagination with page number now in path (rather than query string) and unique page titles for paginated pages. Improved use of canonical tags. Improved handling of empty containers and profiles to reduce soft 404s. Improved JSON-LD markup, adding @id tags and fixing URLs for comments. Removed page output hidden by JavaScript. Performance Improvements: Added Lazy Loading for images, which will speed up page rendering. Added HTTP/2 support with prefetch/preload. Added support for Brotli compression. Improved default profile photos to use inline SVGs rather than generated images, which will speed up page rendering. Improved browser caching of pages served by the guest page cache, which will reduce the number of requests reaching the server. Improved handing of session data for guests to reduce database reads for guests. Optimized images to reduce file size for faster page rendering. Other minor performance improvements to reduce database queries and fix unnecessary code execution. Commerce Store Filters allow customers to filter products by price, review, stock, or custom admin-defined filters. Core Added setting to display user group formatting in more areas (see 6 New Micro Features). Added less intrusive browser notification prompt in Notifications menu (see 6 New Micro Features). Added ability to show sidebar blocks to only certain types of devices (see 6 New Micro Features). Added ability for club owners to reorder the navigation tabs (see 6 New Micro Features). Added ability for announcements to be linked to an URL or be a title only (see 6 New Micro Features), improved consistency in how announcements are shown in different areas. Improved UI for entering time intervals in AdminCP settings (see 6 New Micro Features). Added a new Icons & Logos section in the AdminCP which allows providing logos for use when sharing links from the community, adding the community as a home screen app on a mobile device (along with additional settings for a PWA manifest to control certain aspects the community’s behaviour when used in this way), and in Safari’s favourites menus and pinned tabs on macOS. Added a new UI for attachments, showing a box with some information about the file, rather than a plain line (see Turbo charging loading speeds). Commerce Braintree Gateway including support for PayPal (with recurring payments), Venmo, and cards. Deprecates some PayPal features. Added ability to target bulk mails to members who have spent certain amounts. Added sidebar widgets for best sellers, latest products, product reviews and a featured product. New Server Requirements: PHP 7.1.0 or higher required (7.3.x now supported). MySQL 5.5.3 or higher requires (5.6.2 recommended). Removed Features Removed EmojiOne-style emojis due to licensing issues. Removed Gravatar support due to privacy concerns and performance issues. Removed password hashes when downloading a member list from the AdminCP. This is for security, to reduce the ease of obtaining sensitive data if the AdminCP is ever compromised. Removed the name of the content (e.g. topic) from the “Next Unread” link which could consume significant server resources on large communities. Release Patches We sometimes release patches for issues that come up frequently between full releases. If you are experiencing any of the issues below on this version you can download and apply the patches using the instructions provided. Fixes several issues. Minor Changes Security We continuously audit the product for potential security issues. While none of these security changes are significant we are committed to making improvements wherever potential issues are found. We’d like to thank everyone who responsibly reported issues to us for this release. Added a setting to prevent Invision Community being used in an iframe to prevent clickjacking. Improved entropy of CSRF keys. Improved SSRF protection. Fixed potential leaking of sensitive keys via HTTP referrers. Fixed an issue where the redirect script could be tricked into outputting HTML from an unverified source. Fixed several minor XSS vulnerabilities. Fixed some missing CSRF checks. Fixed users being able to change the social account used for promoting. Fixed club owners being able to manipulate the meta tags for a page which could force users to be redirected to another website when visiting certain club areas. Fixed non-sensitive information on pending transactions made by guests in Commerce potentially viewable by other guests. Fixed users being able to post remote images when disallowed from doing so. Core - UI Added “Create” menu on mobile. Fixed ordering of custom emoji categories. Fixed the “pulse” animation when reacting to content not being correctly centered. Fixed the “popular” indicator overlapping reactions on mobile devices. Fixed clicking on the label for a field not causing focus to jump the field it is for in several locations. Fixed select boxes always dropping down, extending past the bottom of the screen in some situations (they will now drop “up” if near the bottom of the screen). Fixed node (e.g. forums, products, etc.) selection fields consuming significant server resources on communities which have lots of them by limiting the number that is shown when the select box is initially opened to 100. Fixed “stack” form fields (fields where multiple values can be entered) not showing the “Add another” Button" once an item was removed from the stack after the max elements were reached. Fixed “stack” form fields (fields where multiple values can be entered) not saving the correct values if one item is deleted and then another one added. Fixed carousels not being scrollable on very small devices (e.g. iPhone SE). Fixed carousels not behaving correctly with right-to-left languages. Fixed more than one sort options sometimes showing as selected in some content lists. Fixed styling of bullet points in some lists when using Microsoft Edge. Fixed various W3C validation errors (including removing CSS rules with vendor prefixes which are no longer needed in most browsers). Removed total reputation count in “mini” reputation view (used by Gallery comments and status updates), which isn’t necessary as each reaction type shows its own total. Core - Posting / Editor / Embeds Added tag suggestions from previously used tags as you type. Fixed @mentions not working in some circumstances. Fixed results lists showing in wrong place in some autocomplete fields. Fixed Flickr embeds. Fixed embeds for extremely long content causing crashes on mobile devices. Fixed pasting certain URLs into the editor escaping characters. Fixed certain content being pasted into an editor only actually pasting a single URL from the pasted content. Fixed UI when editing highlighted posts. Fixed a user not being able to post a review if they had previously posted a review which had been deleted. Fixed author of content that is set to be published in the future not being able to view and edit it if they do not usually have permission to view future items. Fixed content that is set to be published in the future being able to be commented or reviewed. Fixed sTex/LaTeX editor code syntax highlighting. Fixed an issue where previewing content with attachments may cause the content to be listed multiple times on the “My Attachments” page. Fixed double-clicking on an image to adjust its size could fail when multiple WYSIWYG editors are on the page. Upgraded CKEditor to 4.11.2. Core - Clubs Added option when splitting topics/other content to have the newly created topic/etc be in a club. Fixed paid clubs being able to be created without having a valid price. Fixed the number of members shown for a club not always being accurate. Fixed layout of the club member list when there is no sidebar (now shows 24 per page which divides evenly between the number shown per row both with and without the sidebar). Fixed club leaders not being able to crop the club icon. Fixed members being able to vote on polls in open clubs even if they aren’t members of the club. Fixed an issue where editing a club on PHP 7.2. Fixed HTML open-graph tags not being set in clubs. Core - Search & Activity Streams Added support for showing images from pages records and poll votes in the activity stream. Improved performance if using MySQL. Improved Elasticsearch integration: Added support for wildcard searches. Added support for custom analyzers. Improved performance for certain Elasticsearch queries. Removed the ability to filter by number of views when searching using Elasticsearch, which had significant performance issues.- Fixed deleted comments showing in activity streams. Fixed error in streams with certain content combinations. Fixed quick search dropdown being dismissed when selecting an option inside it. Fixed browser’s autocomplete box overlapping the quick search dropdown. Fixed behaviour of back button after visiting an unread item in a stream. Fixed search form not being reset when using the browser’s back button. Fixed new products icon floating over the title in streams. Fixed searching by “Select box” profile fields with multiple options. Fixed date filters being lost when changing the sort order in search. Fixed changing the date filters not working correctly if the search was originally initiated by the advanced search form. Fixed date filters showing the dates in the wrong timezone. Fixed “search by terms or tags” and “search by terms and tags” not showing on the search form initially. Fixed content not being highlighted correctly in search results. Fixed issues searches when using “&”, “_” or “%” in the search term. Core - Profiles & User Settings Added ability for users to re-crop their profile photos. Added custom field formatting options for profiles. Added ability for users to delete multiple attachments at a time from the “My Attachments” page. Added AdminCP settings for showing signatures to guests and mobile users. Added ability to disable profile photo imports from URL. Added ability to use $member variable (to access details about the member) in custom profile field formatting templates (“Custom topic formatting” and “Custom profile formatting”). Fixed duplicate entries in the “Reputation” section of member profiles. Fixed an issue where “Complete Your Profile” steps may not be dismissed properly and could re-appear later. Fixed links to ignored users and editing profiles showing even when these features were disabled. Fixed users being able to import profile photos from linked social network accounts even if they don’t have permission to use a profile photo. Fixed a generic error when attempting to import a profile photo from an invalid domain. Core - Notifications Added a new user notification to be notified when their content is embedded in other content. Added ability for administrators to set the default value for several notification settings: “Show popup window when members receive a new personal message?”, “Only send one email notification for followed content per member visit?”, and “Play a sound when notifications are received?” Added a small message when editing notification settings to clarify that changing the default method for following content will not affect content you are already following. Fixed notifications triggered by guests not showing an author name. Fixed notifications for users logged in anonymously. Fixed links to some notifications pages/settings using an old format which caused an unnecessary redirect to the correct URL. Core - Messenger Added ability for moderators to delete messenger conversations. Fixed pagination of messenger search results. Core - Leaderboard Fixed some items missing from the Leaderboard’s “Popular items” list. Fixed Leaderboard positions potentially switching if the positions are tied. Fixed AdminCP leaderboard settings form not showing/hiding fields correctly when turned on/off. Fixed “Top Members” page in the Leaderboard consuming significant server resources on large communities. Core - Members & Accounts Fixed the formatting setting not showing the color box when editing a group in the AdminCP. Fixed errors showing twice on registration form if it was submitted with errors. Fixed potential errors merging some member accounts. Fixed an issue which may allow users to bypass validation if they are held for admin approval by Spam Defense. Fixed login handlers sometimes not syncing email addresses or display names. Fixed login handlers syncing profile data even when disabled. Fixed “Complete Your Profile” not sending the user back to the same page they were previously viewing. Fixed some filters in member list downloads not working correctly. Fixed certain non-latin characters in member list downloads. Core - Status Updates Fixed attachments failing to save when editing a status update. Fixed attachments on status updates not being removed when a member is deleted. Fixed status updates and status update edits still showing as autosaved content after submission. Fixed number of replies to status updates sometimes showing incorrectly. Core - Moderation Added a link to the IP address tools for moderators who can see IP addresses in the online users list. Improved UI of the message which tells a user if their post will need to be approved by a moderator, and added the message in some areas it was missing from. Improved UX for flagging members as spammers: flagging a member as spammer from the AdminCP is now done without reloading the page, hiding/deleting content will be processed faster and notifications will not be sent in the meantime, and flagging a member as a spammer from the front-end will redirect back to the page previously being viewed. Fixed an issue where if a moderator deletes content, and then restores it, it is still permanently deleted after the time period it would have been as if it had not been restored. Fixed word filters not holding content for approval in all areas. Fixed automatic moderation rules needing more reports than set. Fixed automatic moderation not counting reports on status updates. Fixed an issue where banning a member and removing their profile photo would leave a broken image in their profile. Fixed deleting reviews or comments sometimes showing two confirmation dialogs. Fixed content items that require a comment not rendering correctly in the report center. Fixed potential error merging content when both items have reviews. Fixed moderators being able to merge content they cannot view if the URL is known. Fixed bad description on the merge form (said “a topic” rather than “the topic”). Fixed a recommend comment still showing in the content it previously belonged to if it is split into new content. Fixed some inconsistencies in behaviour when hiding/unhiding content which itself has hidden comments/reviews inside. Core - Sidebar Added a sidebar widget to show users with the most contributions. Fixed minimum comments/reviews filters in sidebar blocks. Fixed announcements being shown at the bottom of the on some pages, rather than at the top. Fixed the status update widget caching not taking into consideration if that member has status updates enabled, which may cause a text field when the current member has status updates disabled and vice-versa. Fixes missing margin between two blocks if there is a block between them which is hidden because it has no content. Fixed styling inconsistencies when editing some sidebar blocks versus when they are actually displayed. Fixed the recently browsing widget erroneously showing a guest when using Redis sessions. Fixed error rebuilding content (after changing certain settings) of some sidebar blocks. Core - Social / Sharing Added support for cover photos when promoting to social media. Fixed uploading a new promotional image when editing internally promoted content. Fixed unsorted of time options when scheduling social promotions. Fixed AdminCP > System > Social Media Promotion > Permissions not showing all groups in the list of groups with promote permissions. Fixed an issue where it was not always possible to remove existing Facebook social promotion settings. Removed StumbleUpon share service which no longer exists. Core - Files & Uploads Added ability for administrators to choose to move files when changing between file storage configurations. Improved error messages if an error occurs when uploading a file. Fixed uploading not possible in some areas on iPads. Fixed not being able to submit a form if the user tried to submit it while a file upload was in progress. Fixed an issue where an attachments may stop working while files are in the process of being moved after changing file storage configuration settings. Fixed not being able to delete file storage configurations in the AdminCP. Fixed sorting not being retained when deleting multiple attachments from the Files section of the AdminCP. Fixed deleting an attachment not deleting the file from disk. Core - Emails Fixed bulk mail replacement tags. Fixed HTML entities appearing in plaintext email content. Fixed reverting email templates disappearing (until a page refresh) as if they have been deleted. Fixed a broken language string in Sendgrid settings. Core - AdminCP Member Profile Added “Go to Public Profile” button. Fixed an error when viewing the profile if the member had scheduled content for future publishing. Fixed the profile consuming significant server resources on large communities by changing the content statistics section to count all content, regardless of whether containers (i.e. forums), increment the user’s post count. Fixed content statistics not displaying correctly for some locales. Fixed accounts which are linked to Twitter not showing the correct Twitter username. Fixed a broken link to the notifications page. Core - AdminCP Charts & Statistics Fixed charts consuming significant server resources on large communities by applying a default date range of the last 6 months. Fixed an error viewing the AdminCP keywords usage chart if the same keyword had been set more than once. Fixed errors in AdminCP statistics pages if there is no data. Fixed weekly charts showing the last week of the year twice when the year rolls over. Core - Advanced Settings Added new setting option to only serve non-https images from local server. Added basic Redis usage information to the support area of the AdminCP for self-hosted communities. Fixed some inconsistencies when running tasks using cron. Core - Misc Added administrator log entries for various actions which were not logging. Improved site mark as read process to avoid an unnecessary redirect. Fixed privacy policy not being accessible to banned members. Fixed searching of administrator/moderator logs with non-latin characters. Fixed moderator log showing an unparsed language string for some automatic moderation actions. Fixed error if a background task is working on something (such as sending notifications for a topic) which is deleted while the task is still running. Fixed error reporting when setting up Google Maps API. Fixed some background task not not showing their progress accurately on the AdminCP dashboard. Fixed guests not being able to hide announcements. Fixed potential error in calculating width and height of animated gifs when using ImageMagick. Fixed potential error generating the sitemap if orphaned content exists. Fixed the number of reviews on items not being recounted correctly (when upgrading from certain versions or after converting) if the item has reviews but no comments. Fixed some browsers not correctly caching remote images served by the local server. Fixed the code editor on the External Database login handler configuration screen not loading correctly. Fixed AdminCP Dashboard not loading when lots of background tasks are running by adding a limit of 100 to the number shown. Fixed “Configure Services” button in Community Enhancements truncating unnecessarily. Fixed reputation data for comments or reviews not being deleted from the database when the item they belong to is deleted. Fixed files not being removed from server when uninstalling an application. Upgraded JShrink to 1.3.1 (for PHP 7.3 compatibility). Forums Added setting to RSS feed imports to auto-follow the author to created topics. Improved the UI of the “Poll” sidebar block, fixed the “View topic” link disappearing after viewing results, and fixed an error if the topic the poll belongs to is deleted. Changed behaviour of rating questions and answers that a user has already rated - now clicking the same arrow will undo the original rating, and clicking the other will change the rating to that one (previously clicking the same arrow did nothing and clicking the other undid the original rating). Fixed topics still being shown in search results to users who can longer see them if the per-forum setting to only show topics to the person who created them is turned on for an existing forum. Fixed guests not being able to change the selected forums when using fluid view. Fixed fluid view showing the wrong forums checked. Fixed error viewing the topic preview hovercard if the topic has been moved or merged. Fixed breadcrumb navigation in forums/topics in clubs if there is only one forum outside of clubs. Fixed some inconsistencies with automatic locking and unlocking of topics. Fixed question and answer ratings not being merged properly when topics were merged. Fixed error when approving very old topics. Fixed topics not being accessible if a category with a “minimum posts to view” setting set is changed into a forum without removing the value from that setting. Fixed topics from clubs not being included in the sitemap. Fixed marking a topic as read consuming significant server resources on large communities. Commerce - Store Improved store display by hiding empty product categories. Changed the links to buy/redeem gift cards to be in the menu. Fixed possible error when searching products. Fixed products incorrectly showing as being in stock if they use different stock levels based on custom fields and all variations are out of stock. Fixed the “Continue Shopping” dialog showing multiple times when adding several products from the category list view. Fixed copying a product not copying all settings. Fixed broken UI when hovering over a product image in the store on communities which use a right-to-left language. Fixed product embed images not matching the styling of other embeds. Fixed an issue where copying a product could fail. Fixed meta description on product pages. Commerce - Checkout Added AJAX validation to email field when checking out as a guest. Added ability to disable a payment method by setting the countries it is available to to no value. Fixed partial gift card codes being accepted. Fixed grouped products showing incorrect renewal amount on the checkout form when ordering multiple quantities. Fixed the prompt to log in not being shown for guests checking out. Fixed purchase not being processed properly with third party payment gateways if Commerce app is only accessible to certain groups. Commerce - Payment Gateways Fixed possible error when saving a credit card using Stripe if customer already has a card on file. Fixed error when a guest pays using a Stripe method which requires redirect (3Secure, Bancontact, etc.) Commerce - Subscriptions Added ability to apply subscription package changes to existing purchases. Changed Subscriptions to require renewal terms. Fixed disabled Subscription Packages still being purchasable and viewable in the sidebar block. Fixed duplicate entries in the AdminCP subscriber list if a member has inactive subscriptions. Commerce - Client Area Added custom product fields to printed invoices. Fixed broken UI when viewing payment details on a $0 invoice. Fixed invoice status badges not being colored appropriately on the front end when using languages other than English. Commerce - General Payments / Invoices Added an option to filter invoices by payment status in the AdminCP Improved notification emails for upcoming purchase renewals and transaction refunds to include more information. Improved display of customer purchases in admin control panel by separating active/expired purchases. Fixed missing tax on purchase reactivation. Fixed duplicate items sometimes being added when generating an invoice in the AdminCP. Fixed a possible error when marking an invoice as paid if awarding commission to other users (for example, from Downloads purchases or referrals) in some circumstances. Fixed potential errors adjusting Account Credit settings in the AdminCP. Fixed button to mark an invoice paid showing to admins on invoices created by guests even before the guest has filled in any account details (which show an error if clicked). Fixed editing a coupon form showing the start / end dates in the wrong timezone. Commerce - Customer Management Fixed a potential error in the AdminCP member profile if a purchase has been deleted. Fixed an error in the Referrals tab of the customer page in the AdminCP. Fixed an error occurred when cloning customer fields. Fixed wrong AdminCP restrictions being checked for viewing customer statistics. Commerce - Support Added option for retaining the default reply wrapper when using a stock action as a staff member replying to a support request. Added ability to filter support requests older or newer than a specific date in AdminCP. Fixed incoming emails being routed incorrectly if the same sender had recently sent an email to a different department. Fixed incoming plaintext emails sometimes being parsed blank. Fixed the feature which holds a staff member’s reply if the customer replies while the staff member is writing their reply, which wasn’t working if the staff member submits their reply by replying to the email notification. Fixed trying to require an associated subscription in support department settings not working. Fixed handling of custom support request fields for pay-per-incident support requests. Fixed long ticket names breaking UI in ticket history sidebar. Fixed uninstalling Commerce not disable the task to check for incoming POP3 emails. Fixed missing language string on the stock action form. Fixed wrong language string being used in the description for the default reply content setting. Removed IP Addresses used for Support Requests from the ModCP. Commerce - Misc Fixed license key API handling of invisible characters. Pages Changed the severity level of the error when somebody without proper permissions tries to load the sidebar manager from 3 to 2. Fixed pages that have been renamed not redirecting to the new URL. Fixed databases showing in the “Create” menu to users without permission. Fixed records in databases with “wiki-style” editing enabled not actually being able to be edited by all users. Fixed an issue where the form may not be displayed when trying to move a database record. Fixed missing language string in the dialog that shows when choosing “Custom” from the “Sort by” menu when viewing database records. Fixed the wrong template being used for reviews. Fixed the currently chosen database being disabled on the database select menu when editing a page in WYSIWYG mode. Fixed searching for database categories in the AdminCP showing categories from all databases. Fixed missing canonical tags. Gallery Added a group setting to control whether users can download the original image or not, and whether it should be watermarked or not. Added the image to certain notification emails (new content, user mentioned, etc.). Added a setting to control whether showing a map defaults to on or off for images with GPS coordinates embedded. Added certain indicators (such as image pending approval) to the images shown on the Gallery index. Added “Lens Model” in EXIF data if present. Changed albums displayed on user profiles to sort by latest update (newest to oldest). Fixed an error when adding Gallery images with tags. Fixed an error if a guest tries to follow an image during the upload process. Fixed behaviour of the browser’s back button after viewing images in a lightbox and closing the lightbox. Fixed navigation between images not working correctly in the lightbox in some circumstances. Fixed images being marked as read before they have been seen when in the Lightbox. Fixed gallery albums and the uploaded images being shown separately in activity streams and on the “Overview” page in a club. Fixed deleting a club not deleting the albums inside it. Fixed members being able to move images into a category that normally cannot receive direct image submissions during the process of deleting an album. Fixed users being able to submit directly to a category if it requires albums to be used but the user does not have permission to create albums. Fixed a section for the category description showing even if the category has no description. Fixed image uploading on Internet Explorer 11. Fixed images not being accessible if the album is moved while they are being uploaded. Fixed “ModifyDate” EXIF tag being displayed as “Date Taken”. Fixed the wrong “last modified” date being used for albums in the sitemap. Fixed the files on disk being moved when rebuilding image thumbnails (it was placing all of the newly created images in the current monthly folder, rather than in the original folder). Removed ability to upload images in album descriptions, as this presented a source of confusion for some users. Downloads Added ability to show custom fields in a new tab, below the description, or in the sidebar. Fixed “Buy” button still showing on paid files which have had purchases disabled. Fixed an issue where files could get incorrectly removed when changing a version number, or updating screenshots. Fixed the average review rating counting reviews that are not visible. Fixed support topics not being created after enabling the setting and editing a file. Fixed screenshots with parenthesis in the filename not being shown while uploading a new file version. Fixed a template error on certain PHP versions during submission if importing screenshots from a URL is enabled. Fixed the tooltip shown when hovering over the number of purchases for a file (when Commerce integration is enabled) showing “downloads” rather than “purchases”. Blog Fixed clicking on a reaction for a blog entry sometimes opening an image lightbox. Fixed long blog names breaking UI. Fixed multiple icons (e.g. “pinned”, “hidden”, etc.) showing over multiple lines rather than next to the title when viewing a blog entry. Fixed cover photos not expanding if clicking on the same line as the title. Calendar Fixed dates and times showing in the wrong timezone in cached areas/pages. Fixed time summary formatting for some locales when creating events. Fixed error on activity streams if the event associated with an RSVP has been deleted. Fixed potential error when deleting iCalendar import feeds. Fixed cover photos not expanding if clicking on the same line as the title. REST & OAuth New Endpoints: Core: Added support for managing clubs. Core: Added support for managing user warnings and fetching warn reasons. Forums: Added support for creating and updating polls in topics and blog entries. Calendar: Added support for managing Calendar venues. Calendar: Added support for filtering Calendar events by date range Calendar: Added support for sorting events by event start or end date. Added a parameter when deleting a node via the REST API to determine what to do with child nodes (previously that would just become orphaned). Changed OAuth Server behaviour to reject authorization or token requests for users who are banned or suspended. Fixed OAuth refresh tokens being lost if an access token request omits it. Fixed some endpoints not being available to requests authenticated with an OAuth access token granted by Client Credentials. Fixed requests that attempt to unhide content items that are already visible not updating other details. Fixed deleting reviews on Pages records using the REST API. Fixed display names which have a “” in them being returned as null. Fixed the documentation for the Commerce purchases endpoint missing a possible exception which can be thrown. Installer / Upgrader Improved performance of UTF-8 converter in some instances when upgrading from 3.x. Changed the default MySQL collation to UTF8MB4 for new installations. Changed the upgrade message about hiding the AdminCP link when upgrading from older versions to recommend using two factor authentication instead of providing instructions about how to re-enable it. Fixed potential errors or inconsistencies after applying a patch if using disk caching for templates. Fixed an error when trying to upgrade if templates or CSS files exist in the database without an associated theme. Fixed bad conversion of Sparkpost settings when upgrading from 4.3.x. Fixed bad conversion of refund data in Commerce when upgrading from certain versions. Fixed an error when rebuilding legacy content (after a 3.x upgrade) when using PHP 7.2. Fixed an error in the messenger after upgrading from certain versions. Fixed soft-deleted content from older versions not being upgraded correctly. Fixed members potentially have an incorrect validating status after upgrading from 3.x. Fixed Gallery albums losing their sort orders may after upgrading from certain versions. Fixed UTF-8 Converter (part of upgrading from 3.x) potentially losing connection while compiling table information. Removed ability to access the AdminCP while an upgrade is in process to improve stability. Converters Improved conversion user experience and simplified approach to running a conversion. Improved redirects for vBulletin 3/4 including attachments.php and printthread.php. Improved performance of certain background tasks launched following a conversion. Improved BBCode conversion when converting from MyBB. Improved converting member titles from vBulletin. Improved support for converting posts with links from vBulletin 5. Improved Invision Community redirects to support multiple merged communities, now uses /ic-merge-{core_app_id}/*. Improved support for [img:alignment] bbcode when converting from UBB.Threads. Fixed an issue where incomplete accounts could be created during a conversion. Fixed an issue where images uploaded to vBulletin5 “photo” posts do not convert. Fixed an issue where legacy XenForo versions may not be detected correctly in some edge cases. Fixed an issue where certain usernames may not convert properly from vBulletin, MyBB and XenForo. Fixed an issue where converted MyBB posts with inline attachments may display the wrong attachment. Fixed an issue where in certain circumstances Gallery albums/images may be converted to a category that was removed. Fixed an issue where private messages may not be converted from vB3/4 in certain circumstances. Fixed an issue where vBulletin archive links may not be redirected. Fixed an issue where hidden posts from vBulletin (3.x/4.x) may not convert correctly. Fixed an issue where topic reply counts were not converted. Fixed an issue where vBulletin Blog Attachments may not convert correctly from vBulletin 3.x. Fixed an issue where member history group information may not display correctly after conversion. Was it necessary to paste the whole thing? Well... why not. Please let us know if you come across something not working correctly after the upgrade by posting about the issue, along with as much detail as possible, followed by images/screenshots, into the Forum Issues area.
  43. 8 points
    I have so many people asking how in my Discord PMs, so I'm writing this so I could copy-paste the link... This will be a step-by-step guide. But please use the Forum's search bar or Google search in case you are not familiar with some terms or programs. Client Part [2015-10-01aRagexeRE to 2017-06-14aRagexeRE] 1. There's a patch in NEMO that can disable Summoner, use it. Client Part [2017-06-21RagexeRE or later] 1. Use GRF Editor to open your GRF, search for ExternalSettings. One or more files will appear. If nothing shows up, grab one from data.grf. 2. If your use a Sakray(RagexeRE) client, click externalsettings_XX_sak.lub. Otherwise click externalsettings_XX.lub. XX will be the shorthand of the country name which is associated to your langtype. After that, click the Save As button to save the decompiled Lua file. 3. Open the file with any text editor that does not have Notepad in its name. 4. You'll see a lot of things you can customize. Let's ignore those. Find the line with this code MakeableRace = { Doram = true } 5. What's next? Let's change the value to false. 6. Save the file and put the edited Lua file back into your GRF. Make sure the file extension is lub not lua. 7. Now we're done with the client editing. Let's also configure the server just in case a smartass use WPE or edit the Lua file back. Server Part 1. Open conf/char_athena.conf in your server files. 2. Find this part // Restrict certain class from being created. (Only functional on 20151001aRagexe or later) // 0: No character creation is allowed // 1: Only novice is allowed to be created (pre-renewal default) // 2: Only summoner is allowed to be created // 3: Both novice and summoner can be created (renewal default) // Uncomment to customize the restriction //allowed_job_flag: 3 3. Uncomment the last line. (Yes, remove the slashes) 4. Change the value to 1. 5. Save the file. We're done now. 6. Oh, and don't forget to restart your server if it was running. PS. Don't PM me to get support, those PMs will be ignored.
  44. 8 points
    Idea Create a package of code compiler for the emulator, which took up little space, and will as portable as possible, it will not require installation, and which can be stored on a USB flash drive. Current Status: semi-done (works with almost emulator, except rAthena for reasons inside CMakeList.txt and other broken parts in code) Download Link: MEGA or Google Drive (189MB) How to use? Like on Linux, but on windows (thx to Cygwin) Download, extract, run start_console.cmd cd D:\path\to\your\emulator make clean && ./configure && make server wait when compilation will finish ./run-server.bat make sure that your SQL server is working fine (if you don't have any install, or take OpenServer from RO offline pack) If you wish to run a server outside the Cygwin environment, you need a lot of dlls copy-paste from /bin/ folder to emulator I give up to finish it and fix rAthena compiler issue (because the issue with CMake files, they are weird), because I have no time and it's out of my interest. Extra Notes Request: please, someone who can fix the rAthena to make work with this release. 189MB compiler is very helpful, because not need to download 1.9GB for lite MSBuild, and ~8-9GB for Visual Studio. Feel the difference. Note: cygwin always slower than original native code. Note: rAhena can't compile with -stl=c++11, use -stl=gnu++11 Note: even with this -stl=gnu+11 you will get a crash a char-server, if you are a developer, try to debug it by yourself and fix, this is rAthena issue, not a package issue. Note: tested: hercules, eathena, brathena, 3ceam -> works fine without any issues, even in gdb mode.
  45. 8 points
    Hii! This is a map I finally finished recently, after months of working on it. It's also the very first map that I've made. As the title says, it's based on the Hakurei Shrine from Touhou! Although with some variations to make it even more explorable! It has several custom retextured objects, as well as many places to explore! Specially thought for romantic or relaxing purposes ^^ It has a touristic area, an Onsen or Thermal Open Bath, and much more! (As you can see in the previews. Previews ☆○o 。NEW 。o○☆ The map is currently in Ver. 1.5. It has had several fixes and improvements durig this time, such as some wrong shadows and objects positions fixed. Also, now it has ground colouring, so certain parts now look better: Any comment is appreciated, thank you! x3 [SOLVED] Known issues: For some reason, if you have certain NVidia Graphic Cards, using "Direct3D" option in the setup can cause glitched graphics on the map. This is a known issue in certian maps, but to fix it you can do the following:
  46. 8 points
    [ Arlandria Mini ] (Satellite town) Here is the second Arlandria town I made. It's like Izlude for Prontera. I created only a winter edition for this one. Check it and leave comment ! Normal Winter
  47. 8 points
    ... I have long had an idea to make a location like a pop-up book ... to tell a story ... ... now I have a book ... even 4 ... and I'll tell the story let's seat and listen to ... .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. The Legend of the Great, Wise and Four Battle Books The legend has it that a long time ago a great, but very lonely wizard lived away from people who thought about creating four magic books of elemental magic: earth, wind, fire and water. Ordinary people feared his wonders as a fire, tried to address only the most hopeless cases and always walked around his house, but the great magician believed that thanks to his books people would learn to live in harmony with magic and in harmony with nature. He hoped that with the help of these books people would learn to control nature, use resources wisely, and he himself would receive the post of chief wizard of Rune-Midgard and become a respected man. Half a century of life, he spent writing his main manuscript. And then came the day when he created and endowed all four books with power, and set out on his journey to the king. On his way to the capital, he met a poor sage, who also went to the palace to present to the king amazing boots-speeders, capable of allowing him to instantly survey his huge possessions (these boots were even sewn specially to the size of the king's feet!). All day, the sage imagined what a great reward from the king would be for the invention of speedboots, and our great wizard only smiled back, because he knew that one pair of boots could not eclipse the glory of his manuscripts. And the sage walked and thought to himself that boots-speed are a reward at a time, but with magic books, more wealth will come out. And then came the evening. The sage waited until the great magician fell asleep, and, that is, pulled out the wizard's books and ran as quickly as he could to his native capital, the city of Juno. There, in the guild of sages, he, dressing his boots-speeders on his hands for agility, spent the whole night casting spells on empty scrolls to copy the texts of incantations from the books of the great magician. Gathering a heavy bag of parchment, he rushed all the way to Alberta town to his familiar influential merchant. This trader did not understand anything about magic, but he knew perfectly well where to make money. At first he did not want to get up for a long time (especially for a man wearing speed boots!), then he did not want to go to open the door, but as soon as he heard that there was a big gain, he himself dragged the sage to his house and closed all the doors and shutters . The merchant had a network of his shops and tents all around the Rune-Midgard, so he immediately sent a servant to order the sending of scrolls of magic in the morning as an exclusive to his stores (and especially valuable ordered to put in premium ones). To the sage he gave for start a large bag of gold coins and promised to reward him with a bunch of money and a new pair of good boots when their business is working. On that and decided. And he was not mistaken with new shoes. When the wise man reached the great wizard in the morning and returned his books to the place, the once shining polished boots-speed skates turned into scrapes and rags that are not capable of overtaking even Mi Gao. The great wizard did not notice anything, and for a week they walked together, as if nothing had happened, arguing about which of them would receive the title of chief magician from the king. Only when the gleaming gates appeared on the horizon, the wise man reported that he was heading to Izlude port to see his old friend and give in to the first visit to the wizard, because the sage was firmly convinced of his own victory. In fact, he wanted to hurry to hire a ship, ready to go to Alberta, take his share stake from the merchant and hide away from the wizard. The great magician said goodbye to the sage and headed across the pavement of the capital straight to the palace, clutching the books in his hands. Imagine his surprise when he saw the strange magic scrolls that had clogged the tents of Prontera. People around were discussing new-fangled scrolls, children were running around and playing with small lightning. The pleasant girl-saleswoman cheerfully invited him to try the magic of the scrolls and offered one for the trial. As soon as he touched the paper, the great wizard recognized his incantations and realized that the whole matter of his life had been stolen! But by whom?! In a fit of anger, he tore up the ill-fated scroll, and rushed for the dishonest sage. He knew that this wise man would not wear the speedboots, because they did not fit the size of his legs, but to be sure, the great wizard gathered air around him, and the wind lifted him above the ground, sweeping away everything in his path. So the magic of the wind became the magic of a hurricane. Flying over Izlude town, the great wizard noticed his old wise friend walking along the dock to the ship, which was about to sail. Then the great wizard took the power of the earth in his hands and began to destroy the white stones of the quay. So the magic of the earth became the magic of stone. The dishonest sage, seeing that the abyss was about to open, put on the remnants of the short boots-speeders, and barely had time to scatter and jump to the deck of the hastily raising anchor ship. Then the great wizard summoned the ghosts of the sea and froze the water around him to stop the ship. So the magic of water turned into the magic of ice. Having reached the ship, the great wizard began to search the cabins and in the last of them he found the sage, who was shaking in a corner, hovering in fear, "O great magician, now I see how powerful you are! If I had at least a little of your mind, it would never have occurred to me to steal from you! I was poor and dishonorable, and now I am rich and again dishonorable! Please take all the gold, just leave me alone!" With these words, the sage tossed a bag of coins to the great wizard. In his hands the coins were heated up to white and the fire spilled on the planks of the ship, so the magic of fire turned into the magic of lava. Returning through the air, the great wizard observed the terrible results of magic, he wanted to give to people. The flaming ship, the ice spikes that grew on the surface of the sea, the destroyed port of Izlude town, and the roofs of houses that had been torn down by the hurricane. He was horrified and broken, people pointing at him and shouting, "What is this awful wizard? Why did you cause us all this horror? We send an eternal curse on you, as you directed your magic against us!" So the great wizard became a terrible wizard. From that moment, now, wherever people notice his magic, he was always rebuffed and expelled from the settlement. From grief, he went mad and disappeared from the human eyes in the wild forests among the orcs, who became his only close demi-human creatures. From his books, people were left with only scattered scrolls with a bit of knowledge, copies of which are carefully stored in the Library of Juno and tirelessly reprinted by the sages word for word. Unfortunately the mystery of the boots-speed skates died with that wise man. It is rumored that sometimes the terrible wizard steals lost travelers with his magic and imprisons them in his magic books, forcing them to fight with each other for the sake of the orcs' pleasure. Although this story happened a long time ago, but even now if someone else enters these forests... no, no, he will go back... and she will go back... sure... .•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•. b_book1 b_book2 b_book3 b_book4 Please rate it if the maps are good enough
  48. 8 points
    Mapflag System Refactor As of Git Hash: a942853, rAthena Mapflag System has been refactored for the future! Features: Perhaps the biggest benefit to this update is how easy it is to add new mapflags. Adding a new boolean mapflag is as easy as defining a new enum value in the mapflag enum and creating a script constant! That's it! More complex mapflags can be added to the setter with their own unique checks if required. Everything is now consolidated to reduce redundancy that was all over the place which made adding new mapflags painful. There are now getter and setter functions source side when interacting with mapflags. Renamed mapflag nosumstarmiracle to nosunmoonstarmiracle. Some things that are somewhat minimal but help memory utilization: Mapflag pvp_nightmaredrop values are now stored as a vector. Mapflag skill_damage values are now stored as a vector. The global map index are now stored as a vector. Thanks to @Lemongrass for a lot of help and @Secrets for tips! Don't forget to leave comments and testing results! Thanks!
  49. 8 points
    View File Mapcache Editor Heya, This is a tool to edit mapcache files for rAthena (db/(pre-)re/map_cache.dat). It is already part of Server Database Editor as a sub tool, but I've made it a tool on its own instead. It was made to fix the issue with WeeMapCache not assigning the water tiles properly. Otherwise, it's pretty much the same interface, but easier to use. The most recent version will always be found from the mediafire link below: http://www.mediafire.com/file/tjlnooebx6am673 Source files: https://github.com/Tokeiburu/Mapcache-Editor Submitter Tokei Submitted 07/08/2018 Category Editors Video Content Author Tokeiburu  
  • Newsletter

    Want to keep up to date with all our latest news and information?

    Sign Up