Inserting sql

chojuro · March 3

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);

how to fix this error im using old achievement system

KirieZ · March 4

I think you are missing a ; at the end of the alter table statement. not sure if this solves everything, but looking into a bit of SQL syntax should help understanding the other errors.

Sign In

Inserting sql

Question

chojuro 0

Share this post

Link to post

Share on other sites

1 answer to this question

Recommended Posts

KirieZ 88

Share this post

Link to post

Share on other sites

Join the conversation

Recently Browsing 0 members

Chat

GitHub

Community

Documentation

Important Information