Shamag

Hello! I try following your step by step, but I have encounter a problem. when I ran char-server it said this DB error - Table 'rathena_re_db.vip_storage' doesn't exist [Debug]: at E:\RO_offline\Project_Return_to_Morroc\02 emu rathena\src\char\int_storage.cpp:164 - SELECT `id`,`account_id`,`nameid`,`amount`,`equip`,`identify`,`refine`,`attribute`,`card0`,`card1`,`card2`,`card3`,`option_id0`,`option_val0`,`option_parm0`,`option_id1`,`option_val1`,`option_parm1`,`option_id2`,`option_val2`,`option_parm2`,`option_id3`,`option_val3`,`option_parm3`,`option_id4`,`option_val4`,`option_parm4`,`expire_time`,`bound`,`unique_id`,`enchantgrade` FROM `vip_storage` LIMIT 1; and the script/command aren't working, I try using storage2 storage3 storage4 - script vip_storage -1,{ OnInit: bindatcmd "storage2",strnpcinfo(3)+"::OnAtcommand"; end; OnAtcommand: openstorage2(1,STOR_MODE_GET|STOR_MODE_PUT); end; } - script storage2 -1,{ OnInit: bindatcmd "storage2",strnpcinfo(3)+"::OnAtcommand"; end; OnAtcommand: openstorage2(2,STOR_MODE_GET|STOR_MODE_PUT); end; } - script storage3 -1,{ OnInit: bindatcmd "storage2",strnpcinfo(3)+"::OnAtcommand"; end; OnAtcommand: openstorage2(3,STOR_MODE_GET|STOR_MODE_PUT); end; } - script storage4 -1,{ OnInit: bindatcmd "storage2",strnpcinfo(3)+"::OnAtcommand"; end; OnAtcommand: openstorage2(4,STOR_MODE_GET|STOR_MODE_PUT); end; } and my premium_storage.sql are like this -- -- Table structure for table `vip_storage` -- CREATE TABLE IF NOT EXISTS `vip_storage` ( `id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `nameid` int(10) 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` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) 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', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `storage2` -- CREATE TABLE IF NOT EXISTS `storage2` ( `id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `nameid` int(10) 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` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) 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', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `storage3` -- CREATE TABLE IF NOT EXISTS `storage3` ( `id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `nameid` int(10) 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` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) 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', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `storage4` -- CREATE TABLE IF NOT EXISTS `storage4` ( `id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `nameid` int(10) 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` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) 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', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `vip_storage` -- CREATE TABLE IF NOT EXISTS `vip_storage` ( `id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `nameid` int(10) 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` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) 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', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `storage2` -- CREATE TABLE IF NOT EXISTS `storage2` ( `id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `nameid` int(10) 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` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) 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', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `storage3` -- CREATE TABLE IF NOT EXISTS `storage3` ( `id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `nameid` int(10) 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` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) 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', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `storage4` -- CREATE TABLE IF NOT EXISTS `storage4` ( `id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `nameid` int(10) 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` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) 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', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM;