Jump to content
  • 0

Inserting sql

BlazingSpear

Asked by BlazingSpear,

 Share

Question

BlazingSpear Metaling

BlazingSpear

Posted
  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.01
  • Content Count:  75
  • Reputation:   9
  • Joined:  11/27/16
  • Last Seen:  
Posted

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

 

image.png

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0
Tokei Magmaring

Tokei

Posted
  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.00
  • Content Count:  662
  • Reputation:   671
  • Joined:  11/12/12
  • Last Seen:  
Posted

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

Link to comment
Share on other sites
  • 0
BlazingSpear Metaling

BlazingSpear

Posted
  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.01
  • Content Count:  75
  • Reputation:   9
  • Joined:  11/27/16
  • Last Seen:  
  • Author
Posted

ill try this later thanks

Link to comment
Share on other sites
  • 0
Rynbef Pouring

Rynbef

Posted
  • Group:  Forum Moderator
  • Topic Count:  44
  • Topics Per Day:  0.01
  • Content Count:  896
  • Reputation:   117
  • Joined:  05/23/12
  • Last Seen:  
Posted

Since MySQL 5.5.5 InnoDB is the engine instead of MyISAM. Better use this if u use newer MySQL version.

U can use: https://www.scaler.com/topics/sql/sql-validator/ to fix and validate ur sql query.

 

Rynbef~

Link to comment
Share on other sites
  • 0
BlazingSpear Metaling

BlazingSpear

Posted
  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.01
  • Content Count:  75
  • Reputation:   9
  • Joined:  11/27/16
  • Last Seen:  
  • Author
Posted

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

Link to comment
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.   Paste as plain text instead

  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.

×
 Share
Go to question listing
×
×
  • Create New...