-- phpMyAdmin SQL Dump
-- version 2.11.9.2
--
phpMyAdmin
--
-- Värd: localhost
-- Skapad: 06 mars 2009 kl 09:08
-- Serverversion: 5.0.67
-- PHP-version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Databas: `lol`
--
-- --------------------------------------------------------
--
-- Struktur för tabell `z_shop_offer`
--
CREATE TABLE IF NOT EXISTS `z_shop_offer` (
`id` int(11) NOT NULL auto_increment,
`points` int(11) NOT NULL default '0',
`itemid1` int(11) NOT NULL default '0',
`count1` int(11) NOT NULL default '0',
`itemid2` int(11) NOT NULL default '0',
`count2` int(11) NOT NULL default '0',
`offer_type` varchar(255) default NULL,
`offer_description` text NOT NULL,
`offer_name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
--
-- Data i tabell `z_shop_offer`
--
INSERT INTO `z_shop_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`) VALUES
(2, 2, 9776, 1, 0, 0, 'item', 'Buy Magic Plate Armor , Arm:17', 'Magic plate armor , Arm:17'),
(3, 6, 2466, 1, 1987, 8, 'container', 'Buy bag with 8 Golden Armor! Become a rich mother fucker!', '8x Golden Armor'),
(5, 1, 5890, 100, 0, 0, 'item', 'Buy 100 Chicken Feathers!', '100x Chicken Feather'),
(11, 9, 2517, 1, 0, 0, 'item', 'Sweddy Shield 42 Armor\r\nA mighty shield warded by the gods of Tibia', 'Sweddy Shield , Def : 42'),
(14, 3, 6529, 1, 0, 0, 'item', '1x unlimited infernal bolt ... 16:23 You see an infernal bolt.\r\nIt can only be wielded properly by players of level 70 or higher.\r\nIt weighs 0.90 oz.', '1x infernal bolt.'),
(16, 10, 9933, 1, 0, 0, 'item', 'You see a firewalker boots (Arm:3, protection fire +90%) Give your char Faster Regeneration, Give 2 Mlvls , that has energy for UNLIMITED minutes left.\r\nGive You 20 Speed (Boh Is 15)\r\nIt can only be wielded properly by players of level 130 or higher.\r\nIt weighs 9.50 oz.\r\nWearing these boots reduces the damage gotten from fiery ground.', 'Firewalker boots , Arm 3 ,'),
(17, 1, 5902, 50, 0, 0, 'item', 'Buy 50 Honeycomb!', '50x Honeycomb'),
(18, 1, 5897, 100, 0, 0, 'item', 'Buy 100 Wolf Paw!', '100x Wolf Paw'),
(19, 6, 8918, 1, 0, 0, 'item', 'Spellbook of Dark Mysteries\r\nHave this on your char , 5+ mlvl \r\nand 15 def ', 'Spellbook of Dark Mysteries'),
(20, 2, 6119, 1, 0, 0, 'item', 'Tp Scroll , Tp you to the middle of the city , good to use when you are traped !', 'Tp Scroll'),
(21, 7, 8851, 1, 0, 0, 'item', 'Royal Crossbow , It can only be wielded properly by paladins of level 130 or higher. Range:6, Atk +5, Hit% +3.', 'Royal Crossbow'),
(22, 7, 9778, 1, 0, 0, 'item', 'You see a sweddy helmet (Arm:9, magic level +5, protection holy +4%, death +6%).\r\nIt can only be wielded properly by sorcerers, master sorcerers, druids, elder druids, paladins, royal paladins, knights and elite knights of\r\nlevel 80 or higher.\r\nIt weighs 35.00 oz.', 'Sweddy Helmet'),
(23, 8, 9776, 1, 0, 0, 'item', 'You see a sweddy armor (Arm:18, club fighting +5, sword fighting +5, axe fighting +5, distance fighting +5, magic level +2, protectiondeath +3%).\r\nIt can only be wielded properly by knights, elite knights, druids, elder druids, sorcerers, master sorcerers, paladins and royal paladins of\r\nlevel 80 or higher.\r\nIt weighs 70.00 oz.', 'Sweddy Armor'),
(24, 8, 9777, 1, 0, 0, 'item', 'You see a sweddy legs (Arm:10, club fighting +2, sword fighting +2, axe fighting +2, distance fighting +2, protection holy +5%, death+5%).\r\nIt can only be wielded properly by paladins, royal paladins, druids, elder druids, sorcerers, master sorcerers, knights and elite knights of\r\nlevel 80 or higher.\r\nIt weighs 65.00 oz.', 'Sweddy Legs'),
(25, 10, 8293, 1, 0, 0, 'item', 'You see a Sweddy axe (Atk:110 physical + 20 death, Def:39 +1).\r\nIt weighs 10.00 oz.\r\nThe blade is magic.', 'Sweddy Axe'),
(26, 10, 8931, 1, 0, 0, 'item', 'You see a Sweddy sword (Atk:110 physical + 20 death, Def:39 +1).\r\nIt weighs 10.00 oz.\r\nThe blade is magic. ', 'Sweddy Sword'),
(27, 9, 6119, 1, 1987, 8, 'container', 'Buy bag with 8 Tp Scroll''s!', '8 Tp Scroll''s'),
(29, 2, 9774, 1, 0, 0, 'item', 'Sweddy Backpack , 40 Slot (Backpack Only have 20 slot) , Give You 3 Arm''s , 2+ Speed .. It weighs 18.00 oz.', 'Sweddy Backpack'),
(30, 3, 10012, 1, 0, 0, 'item', 'Give The Item To A Gm Or Host They Will Give You A Addon', 'Addon'),
(31, 3, 2263, 1, 0, 0, 'item', 'Heal 200 more mana then normal mana rune', 'Donation Mana Rune');
Love You