8qSPFYcM

1-- phpMyAdmin SQL Dump
2-- version 3.3.2deb1
3-- http://www.phpmyadmin.net
4--
5-- Machine: localhost
6-- Genereertijd: 14 Dec 2016 om 00:08
7-- Serverversie: 5.5.53
8-- PHP-Versie: 5.6.27-0+deb8u1
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Database: `ferana1098`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Tabelstructuur voor tabel `z_shop_offer`
26--
27
28CREATE TABLE IF NOT EXISTS `z_shop_offer` (
29  `id` int(11) NOT NULL AUTO_INCREMENT,
30  `points` int(11) NOT NULL DEFAULT '0',
31  `itemid1` int(11) NOT NULL DEFAULT '0',
32  `count1` int(11) NOT NULL DEFAULT '0',
33  `itemid2` int(11) NOT NULL DEFAULT '0',
34  `count2` int(11) NOT NULL DEFAULT '0',
35  `offer_type` varchar(255) DEFAULT NULL,
36  `offer_description` text NOT NULL,
37  `offer_name` varchar(255) NOT NULL,
38  PRIMARY KEY (`id`)
39) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=136 ;
40
41--
42-- Gegevens worden uitgevoerd voor tabel `z_shop_offer`
43--
44
45INSERT INTO `z_shop_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`) VALUES
46(10, 40, 18451, 1, 0, 0, 'item', 'You see a crystalline axe (Atk:51, Def:29 +3, axe fighting +1)..', 'crystalline axe'),
47(11, 40, 18452, 1, 0, 0, 'item', 'You see a mycological mace (Atk:50, Def:31 +3, club fighting +1)..', 'mycological mace'),
48(12, 40, 18465, 1, 0, 0, 'item', 'You see a shiny blade (Atk:50, Def:35 +3, sword fighting +1).', 'shiny blade '),
49(13, 15, 2160, 15, 0, 0, 'item', '15 Crystal Coins.', '15 Crystal Coins.'),
50(15, 20, 2494, 1, 0, 0, 'item', 'You see a demon armor (Arm:16).\r\nIt weighs 80.00 oz.', 'Demon Armor'),
51(17, 25, 15410, 1, 0, 0, 'item', 'You see a depth calcei (Arm:3, protection physical +5%, speed -5).\r\nIt can only be wielded properly by knights of level 150 or higher.\r\nIt weighs 37.00 oz.', 'Depth Calcei'),
52(18, 25, 15408, 1, 0, 0, 'item', 'You see a depth galea (Arm:8, protection drown +100%).\r\nIt can only be wielded properly by players of level 150 or higher.\r\nIt weighs 46.00 oz.\r\nEnables underwater exploration.', 'Depth Galea'),
53(19, 25, 15407, 1, 0, 0, 'item', 'You see a depth lorica (Arm:16, distance fighting +3, protection death +5%).\r\nIt can only be wielded properly by royal paladins and elite knights of level 80 or higher.\r\nIt weighs 145.00 oz.', 'Depth Lorica'),
54(20, 25, 15409, 1, 0, 0, 'item', 'You see a depth ocrea (Arm:8, protection mana drain +15%).\r\nIt can only be wielded properly by sorcerers and druids of level 80 or higher.\r\nIt weighs 48.00 oz.', 'Depth Ocrea'),
55(21, 25, 15411, 1, 0, 0, 'item', 'You see a depth scutum (Def:25, magic level +2).\r\nIt can only be wielded properly by sorcerers and druids of level 120 or higher.\r\nIt weighs 30.00 oz.', 'Depth Scutum'),
56(22, 25, 2472, 1, 0, 0, 'item', 'You see a magic plate armor (Arm:17).\r\nIt can only be wielded properly by knights and paladins.\r\nIt weighs 85.00 oz.', 'Magic Plate Armor'),
57(25, 25, 12642, 1, 0, 0, 'item', 'You see a royal draken mail (Arm:16, shielding +3, protection physical +5%).\r\nIt can only be wielded properly by knights of level 100 or higher.\r\nIt weighs 130.00 oz.', 'Royal Draken Mail'),
58(26, 20, 12643, 1, 0, 0, 'item', 'You see a royal scale robe (Arm:12, magic level +2, protection fire +5%).\r\nIt can only be wielded properly by sorcerers and druids of level 100 or higher.\r\nIt weighs 45.00 oz.', 'Royal Scale Robe'),
59(27, 15, 8884, 1, 0, 0, 'item', 'You see an oceanborn leviathan armor (Arm:15, shielding +1, protection energy -5%, ice +5%).\r\nIt can only be wielded properly by knights of level 100 or higher.\r\nIt weighs 100.00 oz.', 'Oceanborn Leviathan Armor '),
60(28, 40, 12645, 1, 0, 0, 'item', 'You see an elite draken helmet (Arm:9, distance fighting +1, protection death +3%).\r\nIt can only be wielded properly by paladins of level 100 or higher.\r\nIt weighs 43.00 oz.', 'Elite Draken Helmet'),
61(30, 20, 8882, 1, 0, 0, 'item', 'You see an earthborn titan armor (Arm:15, axe fighting +2, protection earth +5%, fire -5%).\r\nIt can only be wielded properly by knights of level 100 or higher.\r\nIt weighs 120.00 oz.', 'Earthborn Titan Armor'),
62(31, 20, 8883, 1, 0, 0, 'item', 'You see a windborn colossus armor (Arm:15, club fighting +2, protection energy +5%, earth -5%).\r\nIt can only be wielded properly by knights of level 100 or higher.\r\nIt weighs 120.00 oz.', 'Windborn Colossus Armor'),
63(32, 20, 8881, 1, 0, 0, 'item', 'You see a fireborn giant armor (Arm:15, sword fighting +2, protection fire +5%, ice -5%).\r\nIt can only be wielded properly by knights of level 100 or higher.\r\nIt weighs 120.00 oz.', 'Fireborn Giant Armor'),
64(33, 15, 6132, 1, 0, 0, 'item', 'You see a pair of soft boots that is brand-new.\r\nIt weighs 8.00 oz.', 'Soft Boots'),
65(34, 20, 18451, 1, 0, 0, 'item', 'You see the crystalline axe (Atk:51, Def:29 +3, axe fighting +1).\r\nIt can only be wielded properly by knights of level 120 or higher.\r\nIt weighs 76.00 oz.\r\nEven in the light of day, the stars seem to reflect in each facet of this crystalline axe.', 'Crystalline Axe'),
66(35, 20, 8888, 1, 0, 0, 'item', 'You see a master archer''s armor (Arm:15, distance fighting +3).\r\nIt can only be wielded properly by paladins of level 100 or higher.\r\nIt weighs 69.00 oz.', 'Master Archer''s Armor'),
67(37, 10, 2798, 100, 0, 0, 'decoracao', 'You see 100 blood herbs.\r\nThey weigh 120.00 oz.', '100 Blood Herb'),
68(38, 15, 2798, 50, 0, 0, 'decoracao', 'You see 50 blood herbs.\r\nThey weigh 120.00 oz.', '50 Blood Herb'),
69(39, 15, 2361, 1, 0, 0, 'decoracao', 'You see a frozen starlight.\r\nIt weighs 0.20 oz.', 'Frozen Starlight'),
70(40, 15, 2365, 1, 0, 0, 'mix', 'You see a backpack of holding (Vol:50).\r\nIt weighs 1411.20 oz.', 'Backpack of Holding'),
71(41, 15, 6500, 100, 0, 0, 'mix', 'You see demonic essence.\r\nIt weighs 10.00 oz.\r\nSomeone might be interested in trading this.', '100 Demonic Essences'),
72(42, 25, 8851, 1, 0, 0, 'item', 'You see a royal crossbow (Range:6, Atk+5, Hit%+3).\r\nIt can only be wielded properly by paladins of level 130 or higher.\r\nIt weighs 120.00 oz.', 'Royal Crossbow'),
73(68, 30, 16111, 1, 0, 0, 'item', 'You see a thorn spitter (Range:6, Atk+9, Hit%+1).\r\nIt can only be wielded properly by paladins of level 150 or higher.\r\nIt weighs 126.00 oz.', 'Thorn Spitter'),
74(73, 15, 9777, 1, 0, 0, 'item', 'You see a yalahari leg piece (Arm:8, distance fighting +2, protection death +5%).\r\nIt can only be wielded properly by paladins of level 80 or higher.\r\nIt weighs 65.00 oz.', 'Yalahari Leg Piece'),
75(74, 15, 9776, 1, 0, 0, 'item', 'You see a yalahari armor (Arm:16, protection death +3%).\r\nIt can only be wielded properly by knights of level 80 or higher.\r\nIt weighs 70.00 oz.', 'Yalahari Armor'),
76(75, 4, 9778, 1, 0, 0, 'item', 'You see a yalahari mask (Arm:5, magic level +2).\r\nIt can only be wielded properly by sorcerers and druids of level 80 or higher.\r\nIt weighs 35.00 oz.', 'Yalahari Mask'),
77(76, 15, 11101, 1, 0, 0, 'addon', 'Voce recebera o addon male e female full no jogo.', 'Barbarian Addon'),
78(77, 15, 11101, 1, 0, 0, 'addon', 'Voce recebera o addon male e female full no jogo.', 'Warrior Addon'),
79(78, 15, 11101, 1, 0, 0, 'addon', 'Voce recebera o addon male e female full no jogo.', 'Assassin Addon'),
80(79, 15, 11101, 1, 0, 0, 'addon', 'Voce recebera o addon male e female full no jogo.', 'Insectoid Addon'),
81(80, 5, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Draptor'),
82(81, 3, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Dromedary'),
83(82, 5, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Iron Blight'),
84(83, 5, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Magma Crawler'),
85(84, 10, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Lady Bug'),
86(85, 10, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Scorpion King'),
87(87, 20, 11101, 1, 0, 0, 'addon', 'Voce recebera o addon male e female full no jogo.', 'Summoner Addon'),
88(88, 20, 11101, 1, 0, 0, 'addon', 'Voce recebera o addon male e female full no jogo.', 'Red Baron Addon'),
89(90, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Shadow Draptor'),
90(91, 20, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Red Manta'),
91(92, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Golden Lion'),
92(93, 25, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Armoured War Horse'),
93(94, 20, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Blazebringer'),
94(95, 25, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Armoured Dragonling'),
95(96, 20, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Steelbeak'),
96(97, 25, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Armoured Scorpion'),
97(98, 25, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Armoured Cavebear'),
98(99, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Lion'),
99(100, 30, 11101, 1, 0, 0, 'addon', 'Voce recebera o addon male e female full no jogo.', 'Mage Addon'),
100(103, 30, 2798, 10, 0, 0, 'item', 'You see 10 blood herbs.\r\nThey weigh 12.00 oz.', '10 Blood Herb'),
101(104, 30, 2151, 10, 0, 0, 'item', 'You see 10 talons.\r\nThey weigh 2.00 oz.\r\nThere are many rumours about these magic gems.', '10 Talons'),
102(105, 20, 2504, 1, 0, 0, 'item', 'You see dwarven legs (Arm:7, protection physical +3%).\r\nIt weighs 49.00 oz.', 'Dwarven Legs'),
103(106, 15, 2503, 1, 0, 0, 'item', 'You see a dwarven armor (Arm:10, protection physical +5%).\r\nIt weighs 130.00 oz.', 'Dwarven Armor'),
104(108, 30, 12644, 1, 0, 0, 'item', 'You see a shield of corruption (Def:36, sword fighting +3).\r\nIt can only be wielded properly by knights of level 80 or higher.\r\nIt weighs 49.00 oz.', 'Shield of Corruption'),
105(109, 20, 15413, 1, 0, 0, 'item', 'You see an ornate shield (Def:36, protection physical +5%).\r\nIt can only be wielded properly by knights of level 130 or higher.\r\nIt weighs 71.00 oz.', 'Ornate Shield'),
106(110, 25, 6391, 1, 0, 0, 'item', 'You see a nightmare shield (Def:37).\r\nIt weighs 32.00 oz.\r\nIt was crafted by the ancient order of the nightmare knights.', 'Nightmare Shield '),
107(111, 15, 6433, 1, 0, 0, 'item', 'You see a necromancer shield (Def:37).\r\nIt weighs 32.00 oz.\r\nIt is enchanted with unholy, necromantic powers.', 'Necromancer Shield'),
108(112, 25, 18410, 1, 0, 0, 'item', 'You see a prismatic shield (Def:37, shielding +2, protection physical +4%).\r\nIt can only be wielded properly by knights of level 150 or higher.\r\nIt weighs 72.00 oz.', 'Prismatic Shield'),
109(113, 25, 8918, 1, 0, 0, 'item', 'You see a spellbook of dark mysteries (Def:16, magic level +3).\r\nIt can only be wielded properly by sorcerers and druids of level 80 or higher.\r\nIt weighs 28.50 oz.\r\nIt shows your spells and can also shield against attacks when worn.', 'Spellbook of Dark Mysteries'),
110(114, 25, 18422, 20, 0, 0, 'item', 'You see 20 minor crystalline tokens.\r\nThey weigh 50.00 oz.', 'Minor Crystalline Tokens'),
111(116, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Walker'),
112(117, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Azudocus'),
113(118, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Carpacosaurus'),
114(119, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Death Crawler'),
115(120, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Flamesteed'),
116(121, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Jade Lion'),
117(122, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Jade Pincer'),
118(123, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Nethersteed'),
119(124, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Tempest'),
120(125, 30, 11101, 1, 0, 0, 'mount', 'Voce recebera a montaria no jogo.', 'Winter King'),
121(126, 20, 11101, 1, 0, 0, 'addon', 'Voce recebera o addon male e female full no jogo.', 'Glooth Engineer Addon'),
122(127, 40, 11101, 1, 0, 0, 'addon', 'Voce recebera o addon male e female full no jogo.', 'Champion Addon'),
123(128, 50, 11101, 1, 0, 0, 'addon', 'Voce recebera o addon male e female full no jogo.', 'Conjurer Addon'),
124(129, 40, 11101, 1, 0, 0, 'addon', 'Voce recebera o addon male e female full no jogo.', 'Beastmaster Addon');