achievement system compatible diff

[stiflerxx 2]

hi i found this system of conquest in eAthena /

could someone leaves it compatible with Hercules?achievement.patch

 

sql:

CREATE TABLE IF NOT EXISTS `achievement_db` (
`achievement_id` int(11) unsigned NOT NULL auto_increment,
`type` int(10) NOT NULL,
`name` varchar(32) NOT NULL,
`cutin` varchar(64) NOT NULL,
`base_exp` bigint(20) NOT NULL,
`job_exp` bigint(20) NOT NULL,
`nameid` smallint(5) unsigned NOT NULL,
`points` int(10) unsigned NOT NULL,
PRIMARY KEY (`achievement_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


--
-- Tabellenstruktur für Tabelle `achievement_tracker`
--

CREATE TABLE IF NOT EXISTS `achievement_tracker` (
`char_id` int(11) unsigned NOT NULL,
`achievement_id` int(11) unsigned NOT NULL,
`finished` tinyint(1) NOT NULL,
`amount1` int(10) unsigned NOT NULL,
`amount2` int(10) unsigned NOT NULL,
`amount3` int(10) unsigned NOT NULL,
`amount4` int(10) unsigned NOT NULL,
`amount5` int(10) unsigned NOT NULL,
`time` timestamp NOT NULL default CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Tabellenstruktur für Tabelle `explore_achievement`
--

CREATE TABLE IF NOT EXISTS `explore_achievement` (
`achievement_id` int(11) unsigned NOT NULL,
`map1` varchar(11) NOT NULL,
`map2` varchar(11) NOT NULL,
`map3` varchar(11) NOT NULL,
`map4` varchar(11) NOT NULL,
`map5` varchar(11) NOT NULL,
PRIMARY KEY (`achievement_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Tabellenstruktur für Tabelle `item_achievement`
--


CREATE TABLE IF NOT EXISTS `item_achievement` (
`achievement_id` int(11) unsigned NOT NULL,
`type` int(10) NOT NULL,
`value1` int(11) NOT NULL,
`amount1` int(10) NOT NULL,
`value2` int(11) NOT NULL,
`amount2` int(10) NOT NULL,
`value3` int(11) NOT NULL,
`amount3` int(10) NOT NULL,
`value4` int(11) NOT NULL,
`amount4` int(10) NOT NULL,
`value5` int(11) NOT NULL,
`amount5` int(10) NOT NULL,
PRIMARY KEY (`achievement_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Tabellenstruktur für Tabelle `mob_achievement`
--


CREATE TABLE IF NOT EXISTS `mob_achievement` (
`achievement_id` int(11) unsigned NOT NULL,
`type` int(10) NOT NULL,
`value1` int(11) NOT NULL,
`amount1` int(10) NOT NULL,
`value2` int(11) NOT NULL,
`amount2` int(10) NOT NULL,
`value3` int(11) NOT NULL,
`amount3` int(10) NOT NULL,
`value4` int(11) NOT NULL,
`amount4` int(10) NOT NULL,
`value5` int(11) NOT NULL,
`amount5` int(10) NOT NULL,
PRIMARY KEY (`achievement_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Tabellenstruktur für Tabelle `quest_achievement`
--


CREATE TABLE IF NOT EXISTS `quest_achievement` (
`achievement_id` int(11) unsigned NOT NULL,
`quest1` int(11) NOT NULL default '-1',
`quest2` int(11) NOT NULL default '-1',
`quest3` int(11) NOT NULL default '-1',
`quest4` int(11) NOT NULL default '-1',
`quest5` int(11) NOT NULL default '-1',
PRIMARY KEY (`achievement_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Tabellenstruktur für Tabelle `itemuse_achievement`
--


CREATE TABLE IF NOT EXISTS `itemuse_achievement` (
`achievement_id` int(11) unsigned NOT NULL,
`type` int(10) NOT NULL,
`value1` int(11) NOT NULL,
`amount1` int(10) NOT NULL,
`value2` int(11) NOT NULL,
`amount2` int(10) NOT NULL,
`value3` int(11) NOT NULL,
`amount3` int(10) NOT NULL,
`value4` int(11) NOT NULL,
`amount4` int(10) NOT NULL,
`value5` int(11) NOT NULL,
`amount5` int(10) NOT NULL,
PRIMARY KEY (`achievement_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;