BlazingSpear

March 4

already fixed

18 hours ago, Tokei said:
You forgot the semi-colon after the first line:
ALTER TABLE `char` ADD `achievement_points` INT
to
ALTER TABLE `char` ADD `achievement_points` INT;
Other than that, it ran fine for me.

(Also you may want to use a proper SQL editor like HeidiSQL instead of phpmyadmin...)

using this

March 3

ill try this later thanks

March 3

im using this script

ALTER TABLE `char` ADD `achievement_points` INT

CREATE TABLE IF NOT EXISTS `achievement_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ach_id` int(11) unsigned NOT NULL,
  `char_id` int(11) unsigned NOT NULL,
  `crdate` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ach_id` (`ach_id`,`char_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=91 ;

CREATE TABLE IF NOT EXISTS `achievement_force` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ach_id` int(11) unsigned NOT NULL,
  `char_id` int(11) unsigned NOT NULL,
  `mode` enum('add','del') NOT NULL DEFAULT 'add',
  `done` enum('y','n') NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`),
  KEY `ach_id` (`ach_id`,`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `achievement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) NOT NULL,
  `title` varchar(256) NOT NULL,
  `desc` text COMMENT 'Just for your overview scripts',
  `mode` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=no trigger, 1=item, 2= mob, 3=mvp, 4=pvp, 5=blvl, 6=jlvl, 7=lvldiff, 8=map, 9=damage, 10=set',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'see achievement_script for details',
  `deleted` enum('y','n') NOT NULL DEFAULT 'n',
  `cutin` varchar(256) DEFAULT NULL,
  `points` int(11) unsigned NOT NULL DEFAULT '0',
  `single_val` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'pvp,mvp,lvl,jlvl need this column',
  `mapname` varchar(256) NOT NULL,
  `val1` int(11) unsigned NOT NULL DEFAULT '0',
  `val1amount` int(11) unsigned NOT NULL DEFAULT '0',
  `val2` int(11) unsigned NOT NULL DEFAULT '0',
  `val2amount` int(11) unsigned NOT NULL DEFAULT '0',
  `val3` int(11) unsigned NOT NULL DEFAULT '0',
  `val3amount` int(11) unsigned NOT NULL DEFAULT '0',
  `val4` int(11) unsigned NOT NULL DEFAULT '0',
  `val4amount` int(11) unsigned NOT NULL DEFAULT '0',
  `val5` int(11) unsigned NOT NULL DEFAULT '0',
  `val5amount` int(11) unsigned NOT NULL DEFAULT '0',
  `val6` int(11) unsigned NOT NULL DEFAULT '0',
  `val6amount` int(11) unsigned NOT NULL DEFAULT '0',
  `val7` int(11) unsigned NOT NULL DEFAULT '0',
  `val7amount` int(11) unsigned NOT NULL DEFAULT '0',
  `val8` int(11) unsigned NOT NULL DEFAULT '0',
  `val8amount` int(11) unsigned NOT NULL DEFAULT '0',
  `val9` int(11) unsigned NOT NULL DEFAULT '0',
  `val9amount` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=103 ;

INSERT INTO `achievement` (`id`, `name`, `title`, `desc`, `mode`, `type`, `deleted`, `cutin`, `points`, `single_val`, `mapname`, `val1`, `val1amount`, `val2`, `val2amount`, `val3`, `val3amount`, `val4`, `val4amount`, `val5`, `val5amount`, `val6`, `val6amount`, `val7`, `val7amount`, `val8`, `val8amount`, `val9`, `val9amount`) VALUES
(1, 'Poring Hunter', 'PoringHunter', 'Kill 500 Porings without any mercy.\r\n*Boing Boing*\r\n', 2, 0, 'n', 'ach_0001', 100, 0, '', 1002, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(2, 'Poring Slayer', 'PoringSlayer', 'Kill 1000 Porings without any mercy.\r\n*Boing Boing*', 2, 0, 'n', 'ach_0002', 200, 0, '', 1002, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3, 'Poring Nemesis', 'PoringNemesis', 'Kill 5000 Porings without any mercy.\r\n*Boing Boing*', 2, 0, 'n', 'ach_0003', 500, 0, '', 1002, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(4, 'Ultimate', 'Ultimate', 'Reach base level 99 and rock the community.', 5, 0, 'n', 'ach_0004', 500, 99, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(5, 'PvP Madness', 'PvPMadness', 'Win 1x PvP Fight. You will never be the one!', 4, 0, 'n', 'ach_0005', 50, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(6, 'PvP Hunter', 'PvPHunter', 'Win 15x PvP Fight. You are not the one!', 4, 0, 'n', 'ach_0006', 100, 25, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(7, 'Dead or Alive', 'DoA', 'Win 100x PvP Fight. You can be the one!', 4, 0, 'n', 'ach_0007', 250, 100, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(8, 'Most Wanted', 'MostWanted', 'Win 666x PvP Fight. You are the one!', 4, 0, 'n', 'ach_0008', 600, 666, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(9, 'Emperium Breaker', 'Breaker', 'Destroy 1 Emperium and bring glory to your guild!', 2, 0, 'n', 'ach_0009', 50, 0, '', 1288, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(10, 'Guild Despair', 'GuildDespair', 'Destroy 10 Emperium and bring glory to your guild!', 2, 0, 'n', 'ach_0010', 100, 0, '', 1288, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(11, 'Emperium Madness', 'EmpMadness', 'Destroy 50 Emperium and bring glory to your guild!', 2, 0, 'n', 'ach_0011', 250, 0, '', 1288, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(12, 'Rune Midgard, here I come', 'Novice', 'Reach job level 10, then you can finally change your job', 6, 0, 'n', 'ach_0012', 50, 10, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13, 'MvP Hunter', 'MvPHunter', 'Bring 1x MvP down and be the MvP.', 3, 0, 'n', 'ach_0013', 50, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(14, 'MvP Seeker', 'MvPSeeker', 'Bring 15x MvP down and be the MvP.', 3, 0, 'n', 'ach_0014', 100, 15, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(15, 'MvP Sweeper', 'MvpSweeper', 'Bring 50x MvP down and be the MvP.', 3, 0, 'n', 'ach_0015', 100, 50, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(16, 'MvP Bringer', 'MvPBringer', 'Bring 150x MvP down and be the MvP.', 3, 0, 'n', 'ach_0016', 150, 150, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(17, 'Rags-to-Riches', 'Riches', 'Get 1.000.000 zeny and be one of the richest persons in Rune Midgard.', 0, 0, 'n', 'ach_0017', 100, 1000000, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18, 'Magnate', 'Magnate', 'Get 50.000.000 zeny and be the richest persons in Rune Midgard.', 0, 0, 'n', 'ach_0017', 250, 50000000, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(19, 'Thanatos Killer', 'Thanatos', 'Kill Thanatos one time.', 3, 0, 'n', 'ach_0001', 300, 0, '', 1708, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(20, 'Valkyrie Killer', 'Valkyrie', 'Kill Valkyrie Randgris one time.', 3, 0, 'n', 'ach_0001', 500, 0, '', 1751, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(21, 'Beelzebub Killer', 'Beelzebub', 'Kill Beelzebub one time.', 3, 0, 'n', 'ach_0001', 500, 0, '', 1873, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(22, 'Ifrit Killer', 'Ifrit', 'Kill Ifrit one time.', 3, 0, 'n', 'ach_0001', 600, 0, '', 1832, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(23, 'Fallen Bishop Killer', 'Fallen', 'Kill Fallen Bishop Hibram one time.', 3, 0, 'n', 'ach_0001', 300, 0, '', 1871, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(24, 'Gloom Under Night Killer', 'Gloom', 'Kill Gloom Under Night one time.', 3, 0, 'n', 'ach_0001', 250, 0, '', 1768, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(25, 'Orcs Killer', 'Orcs', 'Kill Orc Lord and Orc Hero one time each.', 3, 0, 'n', 'ach_0001', 200, 0, '', 1190, 1, 1087, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(26, 'Wounded Killer', 'Wounded', 'Kill Wounded Morroc one time.', 3, 0, 'n', 'ach_0001', 1000, 0, '', 1917, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(27, 'Baphomet Killer', 'Baphomet', 'Kill Baphomet one time.', 3, 0, 'n', 'ach_0001', 200, 0, '', 1848, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(28, 'Ktullanux Killer', 'Ktullanux', 'Kill Ktullanux one time.', 3, 0, 'n', 'ach_0001', 400, 0, '', 1779, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(29, 'Nacht Sieger Killer', 'Nacht', 'Kill Nacht Sieger one time.', 3, 0, 'n', 'ach_0001', 700, 0, '', 1956, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(30, 'Nidhoggur Shadow Killer', 'Nidhoggur', 'Kill Nidhoggur Shadow one time.', 3, 0, 'n', 'ach_0001', 500, 0, '', 2022, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(31, 'Survivor', 'Survivor', 'Die 10 times.', 0, 0, 'n', 'ach_0001', 100, 10, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(32, 'Dead Raising', 'DeadRaising', 'Die 30 times.', 0, 0, 'n', 'ach_0001', 200, 30, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(33, 'The Undying', 'Undying', 'Die 50 times.', 0, 0, 'n', 'ach_0001', 300, 50, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(34, 'Neutrality at it''s best', 'Neutrality', 'Kill 500 Neutral monsters.', 2, 1, 'n', 'ach_0001', 300, 0, '', 0, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(35, 'Waterbender', 'Waterbender', 'Kill 500 Water monsters.', 2, 1, 'n', 'ach_0001', 300, 0, '', 1, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(36, 'Earthbender', 'Earthbender', 'Kill 500 Earth monsters.', 2, 1, 'n', 'ach_0001', 300, 0, '', 2, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(37, 'Firebender', 'Firebender', 'Kill 500 Fire monsters.', 2, 1, 'n', 'ach_0001', 300, 0, '', 3, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(38, 'Windbender', 'Windbender', 'Kill 500 Wind monsters.', 2, 1, 'n', 'ach_0001', 300, 0, '', 4, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(39, 'Poisonner', 'Poisonner', 'Kill 500 Poison monsters.', 2, 1, 'n', 'ach_0001', 300, 0, '', 5, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(40, 'Evil', 'Evil', 'Kill 500 Holy monsters.', 2, 1, 'n', 'ach_0001', 300, 0, '', 6, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(41, 'Saint', 'Saint', 'Kill 500 Shadow monsters.', 2, 1, 'n', 'ach_0001', 300, 0, '', 7, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(42, 'Ghost Buster', 'GhostBuster', 'Kill 500 Ghost monsters.', 2, 1, 'n', 'ach_0001', 300, 0, '', 8, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(43, 'Zombie Hunter', 'ZombieHunter', 'Kill 500 Undead monsters.', 2, 1, 'n', 'ach_0001', 300, 0, '', 9, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(44, 'Bully', 'Bully', 'Kill 250 Small monsters.', 2, 3, 'n', 'ach_0001', 200, 0, '', 0, 250, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(45, 'Just like me', 'LikeMe', 'Kill 250 Medium monsters.', 2, 3, 'n', 'ach_0001', 200, 0, '', 1, 250, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(46, 'Size doesn''t matter', 'SizeMatter', 'Kill 250 Large monsters.', 2, 3, 'n', 'ach_0001', 200, 0, '', 2, 250, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(47, 'Serial Killer', 'SerialKiller', 'Kill 1000 Demi Human monsters.', 2, 2, 'n', 'ach_0001', 400, 0, '', 7, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(48, 'Brute Master', 'Brute', 'Kill 1000 Brute monsters.', 2, 2, 'n', 'ach_0001', 400, 0, '', 2, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(49, 'Debugger', 'Debugger', 'Kill 1000 Insect monsters.', 2, 2, 'n', 'ach_0001', 400, 0, '', 4, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(50, 'Fisherman', 'Fisherman', 'Kill 1000 Fish monsters.', 2, 2, 'n', 'ach_0001', 400, 0, '', 5, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(51, 'Dragonisher', 'Dragonisher', 'Kill 1000 Dragon monsters.', 2, 2, 'n', 'ach_0001', 400, 0, '', 9, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(52, 'Gardener', 'Gardener', 'Kill 1000 Plant monsters.', 2, 2, 'n', 'ach_0001', 400, 0, '', 3, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(53, 'Now you see me', 'Formless', 'Kill 1000 Formless monsters.', 2, 2, 'n', 'ach_0001', 400, 0, '', 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(54, 'Demon', 'Demon', 'Kill 1000 Angel monsters.', 2, 2, 'n', 'ach_0001', 400, 0, '', 8, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(55, 'Archangel', 'Archangel', 'Kill 1000 Demon monsters.', 2, 2, 'n', 'ach_0001', 400, 0, '', 6, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(56, 'Zombie Slaughter', 'Slaughter', 'Kill 1000 Undead monsters.', 2, 2, 'n', 'ach_0001', 400, 0, '', 1, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(57, 'Pronterer', 'Pronterer', 'Visit Prontera.', 8, 0, 'n', 'ach_0001', 150, 0, 'prontera', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(58, 'Geffener', 'Geffener', 'Visit Geffen.', 8, 0, 'n', 'ach_0001', 150, 0, 'geffen', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(59, 'Moroccer', 'Moroccer', 'Visit Morocc.', 8, 0, 'n', 'ach_0001', 150, 0, 'morocc', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(60, 'Hugeler', 'Hugeler', 'Visit Hugel.', 8, 0, 'n', 'ach_0001', 150, 0, 'hugel', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(61, 'Payoner', 'Payoner', 'Visit Payon.', 8, 0, 'n', 'ach_0001', 150, 0, 'payon', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(62, 'Lutier', 'Lutier', 'Visit Lutie.', 8, 0, 'n', 'ach_0001', 150, 0, 'xmas', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(63, 'Aldebarer', 'Aldebarer', 'Visit Aldebaran.', 8, 0, 'n', 'ach_0001', 150, 0, 'aldebaran', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(64, 'Alberter', 'Alberter', 'Visit Alberta.', 8, 0, 'n', 'ach_0001', 150, 0, 'alberta', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(65, 'Comodor', 'Comodor', 'Visit Comodo.', 8, 0, 'n', 'ach_0001', 150, 0, 'comodo', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(66, 'Amatser', 'Amatser', 'Visit Amatsu.', 8, 0, 'n', 'ach_0001', 150, 0, 'amatsu', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(67, 'Ayothayer', 'Ayothayer', 'Visit Ayothaya.', 8, 0, 'n', 'ach_0001', 150, 0, 'ayothaya', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(68, 'Brasiliser', 'Brasiliser', 'Visit Brasilis.', 8, 0, 'n', 'ach_0001', 150, 0, 'brasilis', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(69, 'Niflheimer', 'Niflheimer', 'Visit Niflheim.', 8, 0, 'n', 'ach_0001', 150, 0, 'niflheim', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(70, 'Izluder', 'Izluder', 'Visit Izlude.', 8, 0, 'n', 'ach_0001', 150, 0, 'izlude', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71, 'Morer', 'Morer', 'Visit Mora.', 8, 0, 'n', 'ach_0001', 150, 0, 'mora', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(72, 'El Dicaster', 'Dicaster', 'Visit El Dicastes.', 8, 0, 'n', 'ach_0001', 150, 0, 'dicastes01', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(73, 'Einbecher', 'Einbecher', 'Visit Einbech.', 8, 0, 'n', 'ach_0001', 150, 0, 'einbech', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(74, 'Einbrocher', 'Einbrocher', 'Visit Einbroch.', 8, 0, 'n', 'ach_0001', 150, 0, 'einbroch', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(75, 'Eclager', 'Eclager', 'Visit Eclage.', 8, 0, 'n', 'ach_0001', 150, 0, 'eclage', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(76, 'Gonryuner', 'Gonryuner', 'Visit Gonryun.', 8, 0, 'n', 'ach_0001', 150, 0, 'gonryun', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(77, 'Dewater', 'Dewater', 'Visit Dewata.', 8, 0, 'n', 'ach_0001', 150, 0, 'dewata', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(78, 'Jawaiier', 'Jawaiier', 'Visit Jawaii.', 8, 0, 'n', 'ach_0001', 150, 0, 'jawaii', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79, 'Lighthazelner', 'Lighthazelner', 'Visit Lighthazeln.', 8, 0, 'n', 'ach_0001', 150, 0, 'lighthazeln', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(80, 'Louyanger', 'Louyanger', 'Visit Louyang.', 8, 0, 'n', 'ach_0001', 150, 0, 'louyang', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(81, 'Malangder', 'Malangder', 'Visit Malangdo.', 8, 0, 'n', 'ach_0001', 150, 0, 'malangdo', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(82, 'Manuker', 'Manuker', 'Visit Manuk.', 8, 0, 'n', 'ach_0001', 150, 0, 'manuk', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(83, 'Racheler', 'Racheler', 'Visit Rachel.', 8, 0, 'n', 'ach_0001', 150, 0, 'rachel', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(84, 'Splendider', 'Splendider', 'Visit Splendid.', 8, 0, 'n', 'ach_0001', 150, 0, 'splendid', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(85, 'Umbala', 'Umbala', 'Visit Umbala.', 8, 0, 'n', 'ach_0001', 150, 0, 'umbala', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(86, 'Veinser', 'Veinser', 'Visit Veins.', 8, 0, 'n', 'ach_0001', 150, 0, 'veins', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(87, 'Yunoer', 'Yunoer', 'Visit Yuno.', 8, 0, 'n', 'ach_0001', 150, 0, 'yuno', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(88, 'Midgardien', 'Midgardien', 'Visit all cities in Midgard.', 10, 0, 'n', 'ach_0001', 50, 8, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(89, 'Monster Nemesis', 'Nemesis', 'Obtain all monsters achievements.', 10, 0, 'n', 'ach_0001', 15000, 2, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(90, 'MvP', 'MvP', 'Obtain all MvP achievements.', 10, 0, 'n', 'ach_0001', 15000, 3, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(91, 'PvP Highly Wanted', 'HighWanted', 'Obtain all PvP achievements.', 10, 0, 'n', 'ach_0001', 17000, 4, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(92, 'Bully', 'Bully', 'Kill a monster with 10 lvl lower than you.', 7, 0, 'n', 'ach_0001', 200, 10, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(93, 'Big Bully', 'BigBully', 'Kill a monster with 20 lvl lower than you.', 7, 0, 'n', 'ach_0001', 700, 20, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(94, 'Be Brave', 'Brave', 'Kill a monster with 10 lvl higher than you.', 7, 1, 'n', 'ach_0001', 200, 10, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(95, 'Suicidal', 'Suicidal', 'Kill a monster with 20 lvl higher than you.', 7, 1, 'n', 'ach_0001', 700, 20, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(96, 'Kill the Weak', 'KillTheWeak', 'Kill a player with 10 lvl lower than you.', 7, 2, 'n', 'ach_0001', 200, 10, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(97, 'Coward', 'Coward', 'Kill a player with 20 lvl lower than you.', 7, 2, 'n', 'ach_0001', 700, 20, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(98, 'Foolish', 'Foolish', 'Kill a player with 10 lvl higher than you.', 7, 3, 'n', 'ach_0001', 200, 10, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(99, 'Master', 'Master', 'Kill a player with 20 lvl higher than you.', 7, 3, 'n', 'ach_0001', 700, 20, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(100, 'Doomed', 'Doomed', 'Obtain all doomed sword.', 1, 0, 'n', 'ach_0001', 500, 0, '', 1139, 1, 1169, 1, 1138, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(101, 'Collectionner', 'Collectionner', 'Obtain all item achievements.', 10, 0, 'n', 'ach_0001', 700, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(102, 'Achiever', 'Achiever', 'Obtain all achievements.', 10, 0, 'n', 'ach_0001', 5000, 10, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(103, 'Class Master', 'Class Master', 'Reach base level 175 without dying! What a challenge.', 5, 0, 'n', 'ach_0004', 1500, 175, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(104, 'Doomed', 'Doomed', 'Obtain all doomed sword.', 1, 0, 'n', 'ach_0001', 500, 0, '', 1139, 1, 1169, 1, 1138, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(105, 'Class Master', 'Class Master', 'Reach base level 175 without dying! What a challenge.', 5, 0, 'n', 'ach_0004', 1500, 175, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(106, 'Golden Magic Knight', 'Golden Magic Knight', 'Kill Golden Thief Bug one time.', 3, 0, 'n', 'ach_0001', 300, 0, '', 1086, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(107, 'Liche King', 'Liche King', 'Kill Angeling and Arc Angeling one time each.', 3, 0, 'n', 'ach_0001', 500, 0, '', 1388, 1, 1096, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(108, 'Angel Redeemer', 'Angel Redeemer', 'Kill Deviling one time.', 3, 0, 'n', 'ach_0001', 300, 0, '', 1582, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(109, 'Reaper', 'Reaper', 'Kill Lord of the Dead one time.', 3, 0, 'n', 'ach_0001', 500, 0, '', 1373, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(110, 'Lucky Boy', 'Lucky Boy', 'Obtain one Emperium.', 1, 0, 'n', 'ach_0001', 200, 0, '', 714, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(111, 'Cooker', 'Cooker', 'Obtain one exmplary of each lvl 1 cooked plate.', 1, 0, 'n', 'ach_0001', 200, 0, '', 12041, 1, 12051, 1, 12046, 1, 12056, 1, 12066, 1, 0, 0, 0, 0, 0, 0, 0, 0),
(112, 'The Picker', 'The Picker', 'Collect Stones. Lots of Stones.', 1, 0, 'n', 'ach_0001', 100, 0, '', 7049, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(113, 'Raise Machine', 'Raise Machine', 'Collect 10 Yggdrasil Leafs.', 1, 0, 'n', 'ach_0001', 1000, 0, '', 610, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(114, 'What is that?!', 'Golder', 'Obtain 15 Gold Coins.', 1, 0, 'n', 'ach_0001', 100, 0, '', 7517, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(115, 'Celebrity Gathering', 'Celebrity Gathering', 'Hunt for the reknown items: Gungnir, Murasama, Alca Bringer, Brionac', 1, 0, 'n', 'ach_0001', 900, 0, '', 1413, 1, 1191, 1, 1470, 1, 1164, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

September 8, 2023

not available anymore

April 30, 2023

14 hours ago, Chaos92 said:

Try to use Chris Translation, read the Wiki from his git. https://github.com/llchrisll/ROenglishRE

i already use this bro

April 29, 2023

how to resolved this error

April 23, 2023

https://forum.ragezone.com/threads/ragnarok-m-korea-mobile-game-source-o.1212464/

here the link

April 5, 2023

looking for this wing sprite? kindly share thanks

November 21, 2022

On 10/15/2022 at 11:43 PM, Emistry said:
you are probably not using rathena.
	/* ai */
	export_constant(AI_NONE);
	export_constant(AI_ATTACK);
	export_constant(AI_SPHERE);
	export_constant(AI_FLORA);
	export_constant(AI_ZANZOU);
	export_constant(AI_LEGION);
	export_constant(AI_FAW);
	export_constant(AI_GUILD);
	export_constant(AI_WAVEMODE);
	export_constant(AI_ABR);
	export_constant(AI_BIONIC);
your emulator doesn't detect these constants, either you didnt have it, or you removed it, or you somehow changed it.

make sure your emulator have these constants value defined.

where im going to put this?

November 9, 2022

im using 2015 client as of now but the available is only for headgear i want also for armor weapon shield etc

November 9, 2022

as the title said what is the minimum client version support shadow equipment?

October 24, 2022

basically you don't have jail.txt/pvp.txt/towns.txt in your npc/mobs folder

April 18, 2022

its like goddameit script you can look for that

April 9, 2022

you can edit it in skill treeview in your lua files

April 9, 2022

english please

April 7, 2022

8 hours ago, JoJoSW said:

I'm using the SAGE class to create a custom class, but the mage tab appears, how do I remove the first class's tab?

can you show a screenshot bro?

April 4, 2022

it involves source coding too

April 3, 2022

Just now, IsabelaFernandez said:

how can i script these buffs using rAthena codes?

look for herc.ws that SC_ and copy it to your rathena

March 18, 2022

you can ignore missing resource file in patch

March 18, 2022

i have error like this before i just dont remember what i did to solved this hahaha

March 18, 2022

click New then put the name of database

March 13, 2022

When i execute ./configure bad interprete apprear to the putty console

im tried this following commands

chmod a+x configure ./configure

yum install dos2unixdos2unix ./configure

yum install dos2unix

dos2unix configure

image.png.2e8891895cb035c3de6e93d611944aea.png

March 11, 2022

On 3/10/2022 at 1:27 PM, davilord said:

More auras.

i like that aura in lord knight

March 1, 2022

it is already in latest version

March 1, 2022

you need to edit sprite of the specific weapon to make it appear like dual

Sign In

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by BlazingSpear