Leaderboard

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

@eug2b Be sure to add the mob_db entries in db/import/mob_db.txt not the db/re/mob_db.txt, that way when rAthena makes changed to re/mob_db.txt it it won't get overwritten. Also look below for the corrected entries. @rakuzas I only encounted the script stuck when I was testing the stuff below, by @reloadscript. By creating and destroying the instance, no issue happened. Edit: So I took a look at it and the last two mobs 3009 and 3010 are a different instance > Bio Island Also the 2999 and 3000 had wrong sprite names, which didn't affect much but still. I also edited the movement speeds of all mobs: See this part: 0x6203695,300 The 300 is the speed, previously was 100 which is "normal" according to doc/mob_db.txt. Higher values means slower. I also changed the stats of 3008 which were a bit wrong, it's not used in the Morse Cave itself anyway. These should be the correct or rather mostly correct entries: // Morse Cave 2998,EP14_MORS_EVENT,Weakened Morocc,Weakened Morocc,158,1771440,1,5874,6618,1,1872,2272,113,45,87,51,45,88,106,50,10,12,2,0,20,0x6203695,300,1500,500,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 2999,EP14_MORS_BOSSA,Morocc Necromancer,Morocc Necromancer,158,4000000,1,5874,6618,1,700,701,215,555,165,190,142,146,299,93,10,12,1,0,20,0x6203695,300,1500,500,1000,0,0,0,0,0,0,0,607,2000,603,200,604,200,522,200,0,0,0,0,0,0,0,0,0,0,0,0 3000,EP14_MORS_BOSSB,Morocc Necromancer,Morocc Necromancer,101,80000000,1,5874,6618,12,700,701,1,1,1,1,1,180,1,1,12,14,1,0,20,0x6203695,300,1500,500,1000,0,0,0,0,0,0,0,607,2000,603,200,604,200,22537,10000,22537,10000,522,200,0,0,0,0,0,0,0,0 3001,EP14_MORS_MOB1,Morocc Ghoul,Morocc Ghoul,158,295240,1,5874,6618,1,1872,2772,113,45,87,51,45,88,106,50,10,12,2,0,20,0x6203695,300,1500,500,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 3002,EP14_MORS_MOB2,Morocc Osiris,Morocc Osiris,158,442860,1,5874,6618,1,1872,2772,113,45,87,51,45,88,106,50,10,12,2,0,20,0x6203695,300,1500,500,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 3003,EP14_MORS_MOB3,Morocc Archer Skeleton,Morocc Archer Skeleton,158,295240,1,5874,6618,3,1872,2772,113,45,87,51,45,88,106,50,10,12,2,0,20,0x6203695,300,1500,500,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 3004,EP14_MORS_MOB4,Morocc Wraith,Morocc Wraith,158,100000,1,5874,6618,1,90,180,113,45,87,51,45,88,106,50,10,12,2,0,20,0x6203695,300,1500,500,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 3005,EP14_MORS_MOB5,Morocc Verit,Morocc Verit,158,442860,1,5874,6618,1,1872,2772,113,45,87,51,45,88,106,50,10,12,2,0,20,0x6203695,300,1500,500,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 3006,EP14_MORS_MOB6,Morocc Lude,Morocc Lude,158,885720,1,5874,6618,1,113,226,113,45,87,51,45,88,299,50,10,12,2,0,20,0x6203695,300,1500,500,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 3007,EP14_MORS_DUMMY,Morocc Shadow,Morocc Shadow,158,99999999,1,5874,6618,1,1872,2772,113,45,87,51,45,88,106,50,10,12,2,0,20,0x6203695,300,1500,500,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 3008,EP14_MORS_HIDDEN,Morocc Plankton,Morocc Plankton,158,295240,1,0,0,1,159,413,113,45,1,51,45,255,106,50,10,12,0,6,60,0x6203695,300,1500,500,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 As for the Script, I noticed a few attachrid errors and made some changes to it: First of all I removed the instance_destroy commands itself, it makes the warp NPC useless. Second: Near line 564, at this part: sleep2 15000; getpartymember getcharid(1),2; There is also an attachrid error, because of the missing attachrid 'mocTalking; To complete it: sleep2 15000; attachrid 'mocTalking; getpartymember getcharid(1),2; Third: According to iRo Wiki you get an Token of Hero after the Instance for each Party Member. Looked up also an Nova Ro Video about Morse Cave. Fourth: The Yanko NPC is missing at the end. Fifth: The item "Prize of Hero" gives random items not spawn random monsters: https://irowiki.org/wiki/Morse's_Cave I'm not gonna add Third, Fourth and Fifght myself, that's up to Alayne. Regards, Chris

i want to purchase your permanent gepard shield 2.0 ? for how much? please email me [email protected]

Hi, you can find achievment commands here. ============================ |15.- Achievement commands.| ============================ Add your custom achieves in db/re/achievement_db.yml or db/pre/achievement_db.yml like: - ID: 220060 Group: "AG_ADVENTURE" Name: "Complete my quest" Score: 10 and this to your script when quest complete. achievementcomplete(220060); *achievementcomplete(<achievement id>{,<char id>}) This function will complete an achievement for the attached player or the supplied <char id>. The objective requirements are ignored when using this function. Returns true on success and false on failure. don`t forget add your custom achievment to client: yourclient\System\achievement_list.lub [220060] = { UI_Type = 0, group = "ADVENTURE", major = 2, minor = 0, title = "Complete my quest", content = { summary = "Text", details = "Text" }, resource = { [1] = { text = "Text" } }, reward = {}, score = 10 }, I think this will work