· 8 years ago · Aug 04, 2018, 11:20 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2
3-- http://www.phpmyadmin.net
4--
5-- Värd: localhost
6-- Tid vid skapande: 04 aug 2018 kl 23:20
7-- Serverversion: 5.5.42-1-log
8-- PHP-version: 5.6.7-1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Databas: `evolera`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabellstruktur `z_shop_offer`
27--
28
29CREATE TABLE IF NOT EXISTS `z_shop_offer` (
30`id` int(11) NOT NULL,
31 `points` int(11) NOT NULL DEFAULT '0',
32 `itemid1` int(11) NOT NULL DEFAULT '0',
33 `count1` int(11) NOT NULL DEFAULT '0',
34 `itemid2` int(11) NOT NULL DEFAULT '0',
35 `count2` int(11) NOT NULL DEFAULT '0',
36 `offer_type` varchar(255) DEFAULT NULL,
37 `offer_description` text NOT NULL,
38 `offer_name` varchar(255) NOT NULL,
39 `pid` int(11) NOT NULL DEFAULT '0',
40 `addons` int(1) DEFAULT NULL,
41 `head` int(3) DEFAULT NULL,
42 `body` int(3) DEFAULT NULL,
43 `legs` int(3) DEFAULT NULL,
44 `feet` int(3) DEFAULT NULL
45) ENGINE=MyISAM AUTO_INCREMENT=2147483648 DEFAULT CHARSET=latin1;
46
47--
48-- Dumpning av Data i tabell `z_shop_offer`
49--
50
51INSERT INTO `z_shop_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`, `pid`, `addons`, `head`, `body`, `legs`, `feet`) VALUES
52(2275, 5, 2275, 1, 0, 0, 'runes', 'Best Healing Rune ingame!', '01 Emerald Uh', 0, NULL, NULL, NULL, NULL, NULL),
53(2298, 5, 2299, 1, 0, 0, 'runes', 'Best Manarune ingame!', '02 Emerald Manarune', 0, NULL, NULL, NULL, NULL, NULL),
54(8856, 2, 8856, 100, 0, 0, 'weapons', 'Best Bow ingame! Atk:+16000 Range:8 (Pallys only)', '04 Emerald Bow', 0, NULL, NULL, NULL, NULL, NULL),
55(7850, 3, 7850, 1, 0, 0, 'weapons', 'Best Arrow ingame! Its damages increases with every level! (Pallys only)', '05 Emerald Arrow', 0, NULL, NULL, NULL, NULL, NULL),
56(7857, 4, 7857, 100, 0, 0, 'weapons', 'Best Sword ingame! Its damages increases with every level! (Knights only)', '03 Emerald Sword', 0, NULL, NULL, NULL, NULL, NULL),
57(3972, 3, 3972, 100, 0, 0, 'equipment', 'Arm:360, club fighting +24, sword fighting +24, axe fighting +24, distance fighting +24, magic level +22, protection all +3%', '01 Emerald Helmet', 0, NULL, NULL, NULL, NULL, NULL),
58(3961, 4, 3961, 100, 0, 0, 'weapons', 'Best Wand ingame! Its damages increases with every level! (Sorcs only)', '01 Emerald Wand', 0, NULL, NULL, NULL, NULL, NULL),
59(8912, 4, 8912, 100, 0, 0, 'weapons', 'Best Rod ingame! Its damages increases with every level! (Druids only)', '02 Emerald Rod', 0, NULL, NULL, NULL, NULL, NULL),
60(8880, 3, 8880, 100, 0, 0, 'equipment', 'Arm:1250, club fighting +29, sword fighting +29, axe fighting +29, distance fighting +29, magic level +26, protection all +3%', '02 Emerald Armor', 0, NULL, NULL, NULL, NULL, NULL),
61(8923, 3, 8923, 100, 0, 0, 'equipment', 'Arm:500, club fighting +25, sword fighting +25, axe fighting +25, distance fighting +25, magic level +20, protection all +3%', '04 Emerald Legs', 0, NULL, NULL, NULL, NULL, NULL),
62(8869, 3, 8869, 100, 0, 0, 'equipment', 'Arm:850, magic level +56, protection all +3%)', '03 Emerald Robe', 0, NULL, NULL, NULL, NULL, NULL),
63(8909, 3, 8909, 100, 0, 0, 'equipment', 'Def:21000, protection all +3%\r\n[KNIGHT & ROGUE]', '06 Emerald Shield', 0, NULL, NULL, NULL, NULL, NULL),
64(11118, 3, 11118, 100, 0, 0, 'equipment', 'Arm:300, club fighting +18, sword fighting +18, axe fighting +18, distance fighting +18, magic level +24, protection all +3%', '05 Emerald Boots', 0, NULL, NULL, NULL, NULL, NULL),
65(6131, 3, 6131, 100, 0, 0, 'equipment', 'Def:300, magic level +260, protection all +3%', '07 Emerald Spellbook', 0, NULL, NULL, NULL, NULL, NULL),
66(11259, 7, 11259, 100, 0, 0, 'equipment', '15% More Mana & HP. Also Increases healing.', '08 Emerald Ring', 0, NULL, NULL, NULL, NULL, NULL),
67(5785, 5, 5785, 1, 0, 0, 'scrolls', '[10 DAYS] +15% Faster PVP Exp. 25% Cheaper Trinkets Shop(Protect Silence Paralyze Etc)', '04 VIP Medal', 0, NULL, NULL, NULL, NULL, NULL),
68(8189, 8, 8189, 100, 0, 0, 'scrolls', '!changename name', '02 Namechanging Scroll', 0, NULL, NULL, NULL, NULL, NULL),
69(2147483647, 20000000, 2466, 0, 0, 0, 'item', '', '1x Heaven Armor', 0, NULL, NULL, NULL, NULL, NULL),
70(7404, 4, 7404, 1, 0, 0, 'weapons', 'Best dagger ingame [ROGUE ONLY]', '01 Emerald Dagger', 0, NULL, NULL, NULL, NULL, NULL),
71(8977, 10, 8977, 100, 0, 0, 'scrolls', '30 Days of Forever Bless + Aol!', '03 Blessed Aol Book', 0, NULL, NULL, NULL, NULL, NULL),
72(7289, 3, 7289, 1, 0, 0, 'runes', 'Freezes your opponent for 5 seconds!', '04 Frost Charm', 0, NULL, NULL, NULL, NULL, NULL),
73(997, 7, 2004, 20, 2157, 100, 'container', '2000 Gold nuggets', 'Backpack of Gold Nuggets', 0, NULL, NULL, NULL, NULL, NULL),
74(7722, 25, 7722, 100, 0, 0, 'scrolls', 'This scroll will give you the same level as the current Top50 on highscores has.', '04 Top 50 Scroll', 0, NULL, NULL, NULL, NULL, NULL),
75(302, 10, 254, 100, 0, 0, 'outfits', 'Swordsman Outfit', '04 Swordsman Outfit', 0, 0, 50, 50, 50, 50),
76(299, 15, 12, 100, 0, 0, 'outfits', 'Morgaroth Outfit\r\n', '01 Morgaroth', 0, 0, 50, 50, 50, 50),
77(5956, 5, 5956, 100, 0, 0, 'runes', 'Exura Demonica Vita Scroll [PALADINS ONLY]', '03 Exura Demonica Vita', 0, NULL, NULL, NULL, NULL, NULL),
78(300, 10, 226, 100, 0, 0, 'outfits', 'Frog outfit', '02 Frog', 0, 0, 50, 50, 50, 50),
79(301, 10, 255, 100, 0, 0, 'outfits', 'Axeman Outfit', '07 Axeman Outfit', 0, 0, 50, 50, 50, 50),
80(303, 10, 159, 100, 0, 0, 'outfits', 'Elf Outfit', '03 Elf Outfit', 0, 0, 50, 50, 50, 50),
81(304, 10, 160, 100, 0, 0, 'outfits', 'Dwarf Outfit', '05 Dwarf Outfit', 0, 0, 50, 50, 50, 50),
82(305, 10, 253, 100, 0, 0, 'outfits', 'Double Axeman Outfit', '06 Double Axeman Outfit', 0, 0, 50, 50, 50, 50),
83(1964, 15, 1964, 1, 0, 0, 'scrolls', 'You will keep all your levels and talents will be reseted. Skills will reset however. [!sorcerer !paladin !druid !knight !rogue]', '05 Vocation Changer', 0, NULL, NULL, NULL, NULL, NULL),
84(264, 10, 264, 100, 0, 0, 'outfits', 'Barbarian Outfit\r\n', '14 Barbarian Brutetamer', 0, 0, 50, 50, 50, 50),
85(194, 10, 194, 100, 0, 0, 'outfits', 'Cult \r\n', '15 Cult', 0, 0, 50, 50, 50, 50);
86
87--
88-- Index för dumpade tabeller
89--
90
91--
92-- Index för tabell `z_shop_offer`
93--
94ALTER TABLE `z_shop_offer`
95 ADD PRIMARY KEY (`id`);
96
97--
98-- AUTO_INCREMENT för dumpade tabeller
99--
100
101--
102-- AUTO_INCREMENT för tabell `z_shop_offer`
103--
104ALTER TABLE `z_shop_offer`
105MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2147483648;
106/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
107/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
108/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;