-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Czas wygenerowania: 27 Paź 2011, 15:17
-- Wersja serwera: 5.1.58
-- Wersja PHP: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Baza danych: `ots`
--

-- --------------------------------------------------------

--
-- Struktura tabeli dla  `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,
  `pid` int(11) NOT NULL DEFAULT '0',
  `bought` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Zrzut danych tabeli `z_shop_offer`
--

INSERT INTO `z_shop_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`, `pid`, `bought`) VALUES
(1, 50, 9778, 1, 0, 0, 'item', 'Yalahari mask (Arm:5, magic level +2).\r\nIt can only be wielded properly by sorcerers and druids of level 80 or higher.', 'Yalahari Mask', 0, 15),
(2, 50, 9776, 1, 0, 0, 'item', 'Yalahari armor (Arm:16, protection death +3%).\r\nIt can only be wielded properly by knights of level 80 or higher.', 'Yalahari Armor', 0, 0),
(3, 50, 9777, 1, 0, 0, 'item', '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.', 'Yalahari Leg Piece', 0, 2),
(4, 50, 8266, 1, 0, 0, 'item', 'Koshei''s ancient amulet (protection holy -50%, death +8%).', 'Koshei''s Ancient Amulet', 0, 17),
(5, 150, 7488, 1, 0, 0, 'item', 'You see a donator mana potion. Infinity. For all vocations. Give 350-430 mana per use!', 'Donator Potion', 0, 24),
(6, 50, 2160, 100, 0, 0, 'item', '100x Crystal Coins.', '100 Crystal Coins', 0, 13),
(7, 50, 2640, 1, 0, 0, 'item', 'Regenerate 50 mana, 30 health per seconds and speed +15.', 'Pair of Soft Boots', 0, 5),
(8, 150, 9932, 1, 0, 0, 'item', '(Arm:2, protection fire +12%, speed +20) Regenerate 70 mana and 50 health per seconds.', 'Firewalker Boots', 0, 24),
(9, 100, 7735, 1, 0, 0, 'item', '(Atk: 150-250) Only Druids and Sorceres.', 'Star Wand', 0, 27),
(10, 100, 5907, 1, 0, 0, 'item', '(Atk:70, speed +20). Only Paladins and Royal Paladins.', 'Slingshot', 0, 6),
(11, 150, 8931, 1, 0, 0, 'item', 'Donator sword (Atk:65, Def:45).', 'Donator Sword', 0, 7),
(12, 150, 8925, 1, 0, 0, 'item', 'Donator axe (Atk:65, Def:45).', 'Donator Axe', 0, 5),
(13, 150, 2421, 1, 0, 0, 'item', 'Donator club (Atk:65, Def:45).', 'Donator Club', 0, 0),
(14, 100, 2471, 1, 0, 0, 'item', 'Golden helmet (Arm:12).', 'Golden Helmet', 0, 2),
(15, 50, 8883, 1, 0, 0, 'item', 'Windborn colossus armor (Arm:15, club fighting +2, protection energy +5%, earth -5%). Only for Knights.', 'Windborn Colossus', 0, 0),
(16, 50, 8881, 1, 0, 0, 'item', 'Fireborn giant armor (Arm:15, sword fighting +2, protection fire +5%, ice -5%). Only Knights.', 'Fireborn Giant', 0, 2),
(17, 50, 8918, 1, 0, 0, 'item', 'Spellbook of dark mysteries (Def:16, magic level +3). Only Druids and Sorcerers.', 'Spellbook of Dark Mysteries', 0, 18),
(18, 50, 6391, 1, 0, 0, 'item', 'Nightmare shield (Def:37).', 'Nightmare Shield', 0, 3),
(19, 100, 2469, 1, 0, 0, 'item', 'Dragon scale legs (Arm:10).', 'Dragon Scale Legs', 0, 5),
(20, 150, 8865, 1, 0, 0, 'item', 'Donator cloak (Arm:22, protection all +15%, speed +30, magic level +5). Sorcerers and Druids.', 'Donator Cloak', 0, 18),
(21, 50, 8888, 1, 0, 0, 'item', 'Master archer''s armor (Arm:15, distance fighting +3). Only Paladins.', 'Master Archer''s Armor', 0, 0),
(22, 50, 8890, 1, 0, 0, 'item', 'Robe of the underworld (Arm:12, protection holy -12%, death +12%). Only Druids and Sorcerers.', 'Robe of the Underworld', 0, 2),
(23, 50, 8884, 1, 0, 0, 'item', 'Oceanborn leviathan armor (Arm:15, shielding +1, protection energy -5%, ice +5%). Only Knights.', 'Oceanborn Leviathan Armor', 0, 0),
(24, 50, 8882, 1, 0, 0, 'item', 'Earthborn titan armor (Arm:15, axe fighting +2, protection earth +5%, fire -5%). Only for Knights.', 'Earthborn Titan', 0, 0),
(26, 150, 8886, 1, 0, 0, 'item', '(Arm:22, Distance +8,Axe +8,Sword +8,Club +8,Shield +8,speed +25, protection all +10%) Knights and Paladins.', 'Donator Armor', 0, 8),
(27, 50, 9969, 1, 0, 0, 'item', 'This rune is removed frags and red skull.', 'Frag Rune', 0, 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;