Leaderboard

September Digest 2017 The following digest covers the month of September, 2017. Staff Changes None. Development Highlights CORE: Removed reset of monster drops on mobdb reload (f197f82f) Corrected broadcast item flag with autoloot (dfe714e9) Resolved bonus WeaponMATKRate (e92fc967) Migrated script.c to C++ (965edbf4,0379774c,60d59124,528539f6,38d225c4,6434a830) Adds allow_bound_sell configuration (557cccac) Corrected OPT1 behavior (5c7c0893) Refine overhaul (e24d30a7) Updated alternate 3rd job bodystyles (78c63c3a) Fixed msvc warning casting int to bool in getequiprefinecost (70f1d864) Corrected Elemental flee calculation (1bfe8475) Migrated clif.c to C++ (80a251ef) Shadow Refiner and getequiprefinecost (cd43f32f) Corrected script command instance ID lookups (82ed67a0) Changed atcommand follow behavior (d9a2bdbe) Updated Kaite renewal behavior (ee552d67) Adds pk_mode_mes displayed on joining a pk zone (0e4ffdac,e6ec0f52) Added support for some missing clients (7de74727) Corrected Elemental Cure healing behavior (ab014246) DATABASE: Updated Rune Stone item behavior (d353b668) Updated Guillotine Poison item behavior (6ef8a97c) Leprechaun_Hat should be refineable (969c10fb) Resolved Lex Aeterna autospell for Laser of Eagle (734ec225) Corrected Bawaya Agimat Tattoo item bonus (549d6f5b) Added new mob db placeholders (6899c89e) SCRIPT: Corrected a second changequest attempt in Assassin Job Change quest (470364cb) Fixed a warning in HorrorToyFactory (b275412b,3cc29d04) Fixed typo in achievements.txt (c71f1050) Fixed duplicate NPC location (052b9bc8) OTHERS: Fixed a potential map-server crash (b4952aae,5fda4f0f) Updated item group file location in documentation (82222084) Fixed potential crash in pc_bonus (0e74b5f5) Updated script command callshop documentation (2572bbbc) Statistics Excluding merges, 12 authors have pushed 41 commits to master and 74 commits to all branches. On master, 62 files have changed. There have been 2,632 additions and 694 deletions. There are 21 merged Pull Requests and 8 Proposed Pull Requests. There are 7 new Issues and 42 Closed Issues. List of Contributors @admkakaroto, @Akkarinage, @aleos89, @anacondaqq, @anity99, @Atemo, @Barigas, @cydh, @Daegaladh, @esu1214, @Everade, @Felleonel, @Haikenz, @jenkijo, @Jeybla, @Lemongrass3110, @LiamKarlMitchell, @luan122, @Mikegyver, @MrAntares, @panko11, @Paoly28, @Playtester, @plsfixrito, @RadianFord, @sader1992, @secretdataz, @technoken, @uddevil, @vstumpf, @whupdo, @Yuchinin, @Zellukas 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

Need the latest kRO Install folder for your private server? Look no further! ----> Download <---- Latest: 2023-04-04 Installation: Official kRO Updated: 04/04/2023 Download Link: https://mega.nz/folder/jUsDgRxQ#ttLmLjPY9p9cfU5_ShWVCw Package contains RSU RO Patcher Lite for kRO and kRO RE by [Ai4rei] This package is maintained by [Akkarin] Note: Due to continued abuse of my webservers, the files have been moved to MEGA. You can download an extractable .zip of an installed kRO directory, or you can download the official installer from kRO's website. Note: If you require older maps that are compatible with 2021 and older clients, download the 2021 .zip. A fan of this topic? Hit the rep button

Looking forward to your rate or upvote or comment on this release. Download the files here: LINK (Updated to v1.2!) Hi guys, Some of you may know me from the preview of this project a couple of days ago, I'm here to release the status icons as promised. Here's a preview of freeze effect: _______________________________________________________________________________________________________ Guide on how to install these status icon (8 Steps) Download the files here: LINK Emulator-Side Step 1: Go to src\map\status.c Look for: /* First we define the skill for common ailments. These are used in skill_additional_effect through sc cards. [Skotlex] */ set_sc( NPC_PETRIFYATTACK , SC_STONE , SI_BLANK , SCB_DEF_ELE|SCB_DEF|SCB_MDEF ); set_sc( NPC_WIDEFREEZE , SC_FREEZE , SI_BLANK , SCB_DEF_ELE|SCB_DEF|SCB_MDEF ); add_sc( NPC_STUNATTACK , SC_STUN ); add_sc( NPC_SLEEPATTACK , SC_SLEEP ); set_sc( NPC_POISON , SC_POISON , SI_BLANK , SCB_DEF2|SCB_REGEN ); set_sc( NPC_CURSEATTACK , SC_CURSE , SI_BLANK , SCB_LUK|SCB_BATK|SCB_WATK|SCB_SPEED ); add_sc( NPC_SILENCEATTACK , SC_SILENCE ); add_sc( NPC_WIDECONFUSE , SC_CONFUSION ); set_sc( NPC_BLINDATTACK , SC_BLIND , SI_BLANK , SCB_HIT|SCB_FLEE ); set_sc( NPC_BLEEDING , SC_BLEEDING , SI_BLEEDING , SCB_REGEN ); set_sc( NPC_POISON , SC_DPOISON , SI_BLANK , SCB_DEF2|SCB_REGEN ); Replace with: set_sc( NPC_PETRIFYATTACK , SC_STONE , SI_STONE , SCB_DEF_ELE|SCB_DEF|SCB_MDEF ); set_sc( NPC_WIDEFREEZE , SC_FREEZE , SI_FREEZE , SCB_DEF_ELE|SCB_DEF|SCB_MDEF ); set_sc( NPC_STUNATTACK , SC_STUN , SI_STUN , SCB_NONE ); set_sc( NPC_SLEEPATTACK , SC_SLEEP , SI_SLEEP , SCB_NONE ); set_sc( NPC_POISON , SC_POISON , SI_POISON , SCB_DEF2|SCB_REGEN ); set_sc( NPC_CURSEATTACK , SC_CURSE , SI_CURSE , SCB_LUK|SCB_BATK|SCB_WATK|SCB_SPEED ); set_sc( NPC_SILENCEATTACK , SC_SILENCE , SI_SILENCE , SCB_NONE ); set_sc( NPC_WIDECONFUSE , SC_CONFUSION , SI_CONFUSION , SCB_NONE ); set_sc( NPC_BLINDATTACK , SC_BLIND , SI_BLIND , SCB_HIT|SCB_FLEE ); set_sc( NPC_BLEEDING , SC_BLEEDING , SI_BLEEDING , SCB_REGEN ); set_sc( NPC_POISON , SC_DPOISON , SI_DPOISON , SCB_DEF2|SCB_REGEN ); Step 2: Go to src\map\status.h Look for: SI_JP_OTP = 816, Add below: SI_STONE = 818, SI_FREEZE = 819, SI_STUN = 820, SI_SLEEP = 821, SI_POISON = 822, SI_CURSE = 823, SI_SILENCE = 824, SI_CONFUSION = 825, SI_BLIND = 826, SI_CHANGEUNDEAD = 827, SI_DPOISON = 828, Step 3: Go to db\const.txt Look for: SI_JP_OTP 816 Add below: SI_STONE 818 SI_FREEZE 819 SI_STUN 820 SI_SLEEP 821 SI_POISON 822 SI_CURSE 823 SI_SILENCE 824 SI_CONFUSION 825 SI_BLIND 826 SI_CHANGEUNDEAD 827 SI_DPOISON 828 Step 4: Re-compile your server! Client-Side (You can skip this step if you use my .grf files to patch your server) Step 5: Go to \data\luafiles514\lua files\stateicon\efstids.lua (You can skip this step if you use my .grf files to patch your server) Look for: EFST_FLOWER_LEAF = 675, Add below: EFST_STONE = 818, EFST_FREEZE = 819, EFST_STUN = 820, EFST_SLEEP = 821, EFST_POISON = 822, EFST_CURSE = 823, EFST_SILENCE = 824, EFST_CONFUSION = 825, EFST_BLIND = 826, EFST_UNDEAD = 827, EFST_DPOISON = 828, Step 6: Go to \data\luafiles514\lua files\stateicon\stateiconimginfo.lua (You can skip this step if you use my .grf files to patch your server) Look for: [PRIORITY_RED] = { Add below: [EFST_IDs.EFST_STONE] = "STONEST.TGA", [EFST_IDs.EFST_FREEZE] = "FREEZEST.TGA", [EFST_IDs.EFST_STUN] = "STUNST.TGA", [EFST_IDs.EFST_SLEEP] = "SLEEPST.TGA", [EFST_IDs.EFST_POISON] = "POISONST.TGA", [EFST_IDs.EFST_CURSE] = "CURSEST.TGA", [EFST_IDs.EFST_SILENCE] = "SILENCEST.TGA", [EFST_IDs.EFST_CONFUSION] = "CONFUSIONST.TGA", [EFST_IDs.EFST_BLIND] = "BLINDST.TGA", [EFST_IDs.EFST_UNDEAD] = "UNDEADST.TGA", [EFST_IDs.EFST_DPOISON] = "DPOISONST.TGA", Step 7: Go to \data\luafiles514\lua files\stateicon\stateiconinfo.lua (You can skip this step if you use my .grf files to patch your server) Look for: StateIconList[EFST_IDs.EFST_HELLPOWER] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Hell Power", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"Can not be revived"}, {"Sacrifice is Disabled"}, {"Token of Siegfried disabled"} } } Add below: StateIconList[EFST_IDs.EFST_STONE] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Stone Cursed", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"All DEF contributed by items is reduced by 50%"}, {"If HP is over 25%, you will lose 1% of your HP every 5 seconds"}, {"Changes your elemental status as Earth LV 1"}, {"Ignores Steal and Lex Aeterna"}, {"Impossible to move, attack, pick up items, skill usage, sitting, force disconnection, and item usage"} } } StateIconList[EFST_IDs.EFST_FREEZE] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Frozen", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"All DEF contributed by items is reduced by 50%"}, {"Any FLEE will be negated"}, {"If HP is over 25%, you will lose 1% of your HP every 5 seconds"}, {"Changes your elemental status as Water LV 1"}, {"Ignores Steal, Lex Aeterna, Storm Gust and Snow Flake Draft"}, {"Impossible to move, attack, pick up items, skill usage, sitting, force disconnection, and item usage"} } } StateIconList[EFST_IDs.EFST_STUN] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Stunned", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"Any flee will be negated"}, {"Impossible to move, attack, pick up items, skill usage, sitting, force disconnection, and item usage"} } } StateIconList[EFST_IDs.EFST_SLEEP] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Asleep", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"If enemy attacks you, they will have 2x CRIT chance with their attack"}, {"Any flee will be negated"}, {"Impossible to move, attack, pick up items, skill usage, sitting, force disconnection, and item usage"} } } StateIconList[EFST_IDs.EFST_POISON] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Poisoned", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"Status-oriented DEF is reduced by 25%"}, {"If HP is over 25%, you will lose 1.5% + 2 HP of your max HP every second"}, {"SP Regeneration is disabled"} } } StateIconList[EFST_IDs.EFST_CURSE] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Cursed", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"Reduce your ATK by 25%"}, {"LUK becomes 0"}, {"Drastically Reduces your Movement Speed"} } } StateIconList[EFST_IDs.EFST_SILENCE] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Silenced", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"Inability to use any active skills"} } } StateIconList[EFST_IDs.EFST_CONFUSION] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Confused", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"Causes the character to move into unintended directions when trying to navigate"} } } StateIconList[EFST_IDs.EFST_BLIND] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Blinded", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"Reduce your HIT and FLEE rate by 25%"}, {"Also graphically reduces range of your visibility"} } } StateIconList[EFST_IDs.EFST_UNDEAD] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Turned Undead", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"You become Undead property"}, {"Support buffs such as Blessing and Increase AGI are removed"} } } StateIconList[EFST_IDs.EFST_DPOISON] = { haveTimeLimit = 1, posTimeLimitStr = 2, descript = { {"Deadly Poisoned", COLOR_TITLE_BUFF}, {"%s", COLOR_TIME}, {"Attack speed increased."}, {"Status-oriented DEF is reduced by 25%"}, {"If HP is over 25%, you will lose 1.5% + 2 HP of your max HP every second"}, {"SP Regeneration is disabled"} } } Step 8: (You can skip this step if you use my .grf files to patch your server) Go to \data\texture\effect and add in the .tga files Whew, that's it. Now, pack it up into .grf/.gpf file if you want to and look at it go! _______________________________________________________________________________________________________ At first I wanted to charge $1 for the pack because I'm so broke right now but I don't have the heart to do it since it is my first release. So here it is. Free stuff! Looking forward to hear what you guys think. Rate it if you guys have the chance. Enjoy it, Shade

Comment out this line

I've encountered that many times. Even i have the .bmp still it can't read my GRF. All you have to do is like this ----------------------------------START--------------------------------------------- 1. Extract your .bmp on GRF SAMPLE KAZEKAGE_HAT.bmp 2. After extracted. Open your KAZEKAGE_HAT.bmp on any picture editor SAMPLE (COREL DRAW, PHOTOSHOP)any version <-----WORKING SAMPLE (MICROSOFT PICTURE MANAGER) <----- Not Tried 3. Edit or put anything even small . on the picture to read it as new .BMP of any picture editor. 4. Save it using SAVE AS, then choose .bmp TIPS: Make sure the width and height should be same as before. 5. Put it again on your GRF at ITEM & COLLECTION FOLDER. then save. ------------------------------------END---------------------------------------------

http://lmgtfy.com/?q=create+a+new+mysql+user

Do not give any users global privileges. Just create a mysql user and give it permissions on specific tables. There are many guides on how to do this.

use the same password as your database's login password create user account username: ragnarok password: ragnarok watch the first video ( Step 1 & 2 ) at: 07:05

First of all I apologize for my bad English. Hello I want to show you my first map and take advantage to ask some questions with some problems that have arisen. The first problem I have is that I start my map with proportions of 200 by 200 and it seemed quite large but when developing it seems that it is not. Before I leave some captures so that you can see it and then squeeze it so it will be easier for me to understand. The part of the map that can be seen in these captures is what has worked the stairs the dock and its base. I like the way it looks, without ever being in the customer when you place yourself at the top of the stairs and its surroundings you can see the edge of the map and I do not like it. And well the question is, how to do to prevent the edges from being seen. It occurred to me to make a bigger map and to copy everything on the new one. But once copied when trying to save freezes the browedit. I hope someone can give me some advice Well now I show you the rest of the map. First we have a pair of 3d custom models

Reviving this topic with my broken hand

1st. Use the Direct3d HAL on the settings 2nd. Uncheck the Disable hardware Accelerated Graphics to make it fix. 3rd . Use Lua Settings

my own version of Rock Paper Scissor Roulette http://pastebin.com/raw.php?i=X7WLLpRZ

So you want your Yondaime Sprite to be your GM Sprite. Just go to your RO Folder/data/sprite/Àΰ£Á·/¸öÅë/³²/¿î¿µÀÚ_³² That's the path to the GM Sprite. Now rename your Yondaime.spr and Yondaime.act to ¿î¿µÀÚ_³².spr and to ¿î¿µÀÚ_³².act , then replace them in that folder. The restart your client,login and you should look like your Yondaime Class now.