rAthena > Hercules Conversion

[Tranquility 12]

Hello everyone,

 

I'm currently revising jaBote's rAthena > Hercules (main) database convertor and so far I've got it working without any errors.

However, I was wondering something about the rAthena table market, can we just drop it, or does it's data need to be migrated to an existing Hercules table?

I noticed my own server doesn't have the table (probably since it's recently added in the updates), but I am just wondering since I'm revising the current convertor anyway.

 

Thanks in advance,

 

Tranquility

[evilpuncker 503]

we got one market, I guess you can just drop it and use ours:

 

https://github.com/HerculesWS/Hercules/blob/master/sql-files/main.sql#L586

[Tranquility 12]

we got one market, I guess you can just drop it and use ours:

 

https://github.com/HerculesWS/Hercules/blob/master/sql-files/main.sql#L586

In that case, there's data in market that might need to be transferred:

rAthena's market table:

CREATE TABLE IF NOT EXISTS `market` (  `name` varchar(32) NOT NULL DEFAULT '',  `nameid` SMALLINT(5) UNSIGNED NOT NULL,  `price` INT(11) UNSIGNED NOT NULL,  `amount` SMALLINT(5) UNSIGNED NOT NULL,  `flag` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0',  PRIMARY KEY  (`name`,`nameid`)) ENGINE = MyISAM;

Hercules' npc_market_data table:

CREATE TABLE IF NOT EXISTS `npc_market_data` (  `name` VARCHAR(24) NOT NULL DEFAULT '',  `itemid` INT(11) UNSIGNED NOT NULL DEFAULT '0',  `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',  PRIMARY KEY (`name`,`itemid`)) ENGINE=MyISAM;

The question will be then, is it used for similar purposes (which I assume it does), or will a simple drop table suffice?

Merely asking for future orientation of the convertor and since I don't personally need it, might be a little bit redundant currently =P

Thanks again for the swift reply!

[evilpuncker 503]

if your table is empty (since you said that you don't got one) you can just ignore it