Leaderboard

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

Euphy's Scripts Disclaimer You may use, modify, and host all of my released scripts. You may not sell them, re-release them in any way (modified or otherwise), or remove the credits. < Event Manager > < Hunting Missions > < Queue System > < Euphy's WOE Controller > < All-In-One NPC > < Euphy's Quest Shop > < Euphy's Warper > < Item Rewards > < Custom Currency Multi-Shop > < Build Manager + > < Class Mastery System > < Class Specialization > < Badge System > < Guarantee Refine Ticket > < Item Fusion > < Euphy's MVP Ladder > < Card Trader > < NPC Duplicate Generator > < Auto-Potion >

HI everyone! I want to share my script "Personal storage". This will allow each character on the account to have his own personal storage. This script supports 15 characters on the account. Free for use Script: prontera,159,193,4 script Personal storage#prt 113,{ mes "[Personal storage]"; mes "Here, let me open"; mes "your Storage for you."; mes "Thank you for using"; mes "the Kafra Service."; .@nb = query_sql("SELECT char_num FROM `char` WHERE char_id = '"+getcharid(0)+"' AND account_id = '"+getcharid(3)+"'", .@char_num$); close2; if (.@char_num$ == "0") openstorage2 50,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "1") openstorage2 51,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "2") openstorage2 52,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "3") openstorage2 53,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "4") openstorage2 54,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "5") openstorage2 55,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "6") openstorage2 56,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "7") openstorage2 57,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "8") openstorage2 58,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "9") openstorage2 59,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "10") openstorage2 60,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "11") openstorage2 61,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "12") openstorage2 62,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "13") openstorage2 63,STOR_MODE_GET|STOR_MODE_PUT; else if (.@char_num$ == "14") openstorage2 64,STOR_MODE_GET|STOR_MODE_PUT; else mes "Can`t open storage. Unknown char_id."; end; } Configuration: add this lines to conf/inter_server.yml # Char 1-3 - ID: 50 Name: "Storage" Table: "storage_char_0" Max: 300 - ID: 51 Name: "Storage" Table: "storage_char_1" Max: 300 - ID: 52 Name: "Storage" Table: "storage_char_2" Max: 300 # Char 4-6 - ID: 53 Name: "Storage" Table: "storage_char_3" Max: 300 - ID: 54 Name: "Storage" Table: "storage_char_4" Max: 300 - ID: 55 Name: "Storage" Table: "storage_char_5" Max: 300 # Char 7-9 - ID: 56 Name: "Storage" Table: "storage_char_6" Max: 300 - ID: 57 Name: "Storage" Table: "storage_char_7" Max: 300 - ID: 58 Name: "Storage" Table: "storage_char_8" Max: 300 # Char 10-12 - ID: 59 Name: "Storage" Table: "storage_char_9" Max: 300 - ID: 60 Name: "Storage" Table: "storage_char_10" Max: 300 - ID: 61 Name: "Storage" Table: "storage_char_11" Max: 300 # Char 13-15 - ID: 62 Name: "Storage" Table: "storage_char_12" Max: 300 - ID: 63 Name: "Storage" Table: "storage_char_13" Max: 300 - ID: 64 Name: "Storage" Table: "storage_char_14" Max: 300 Add new sql tables: CREATE TABLE IF NOT EXISTS `storage_char_0` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_1` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_2` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_3` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_4` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_5` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_6` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_7` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_8` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_9` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_10` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_11` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_12` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_13` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_14` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8;

The topic has been removed because of rAthena staff double standards and hypocrisy things. (rA staff blame me that I made a money on this topic while it's not and never was) All that I did for the last 2.5 years with around ~1k answers from my side is help for free for newbies here, but to rA staff, my topic is a pain in the ass. Sorry guys, but the topic can't be maintained on such a community anymore because of its admins. Bye

Just want to leave a BIG THANK YOU here, this package is a huge time saver for singleplayer/LAN, no more struggle for a quick play on localhost ? 3 years ago I compiled the emulator myself and collected the necessary data to be able to play around in the singleplayer afterwards.

check your link rss and paste to browser and use the front word, login with admin ID and check your Rss

the easiest way is rewrite an existing npc that you don't use ? in my opinion npcs are same as mobs you need id to add (search about how to add a custom mob for more info) but if you just rename your custom npc (to the name that you don't need) and add the npc to the npcs folder everything would work with no time