Jump to content
  • 0
Tranquility

rAthena > Hercules Conversion

Question

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

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.