rAthena > Hercules Conversion

[Tranquility]

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]

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]

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]

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