a4hdR5nJ

1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Máquina: localhost
6-- Data de Criação: 04-Jan-2018 às 10:22
7-- Versão do servidor: 5.5.57-0ubuntu0.14.04.1
8-- versão do PHP: 5.5.9-1ubuntu4.22
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-- Base de Dados: `otx`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Estrutura da tabela `z_shop_offer`
27--
28
29CREATE TABLE IF NOT EXISTS `z_shop_offer` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
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  PRIMARY KEY (`id`)
40) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
41
42--
43-- Extraindo dados da tabela `z_shop_offer`
44--
45
46INSERT INTO `z_shop_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`) VALUES
47(1, 10, 0, 30, 0, 0, 'vipdays', 'Buy 30 Vip days in your account', '30 Vip days '),
48(2, 20, 0, 60, 0, 0, 'vipdays', 'Buy 60 Vip days in your account', '60 Vip days '),
49(3, 25, 0, 90, 0, 0, 'vipdays', 'Buy 90 Vip days in your account', '90 Vip days '),
50(4, 5, 7454, 1, 0, 0, 'item', 'Armor: 80 / Speed +75 / Ki Blasting +10 / Distance Fighting +10 and 50% speed+ /Ki +3000/s.', 'Cell Helmet'),
51(5, 5, 7478, 1, 0, 0, 'itemvip', 'Arm:175 Club Fighting +5 / Sword Fighting +5 / Axe Fighting +5 / Distance Fighting +5 / Shielding +5 / Protection All +5% and Health and Ki +5000/s', 'Supreme North Armor'),
52(6, 5, 7479, 1, 0, 0, 'itemvip', 'Arm:120 Club Fighting +5 / Sword Fighting +5 / Axe Fighting +5 / Distance Fighting +5 / Shielding +5 / Protection All +5% and Health and Ki +4500/s', 'Supreme North Legs'),
53(7, 5, 7480, 1, 0, 0, 'itemvip', 'Arm:80  Protection all +5% / Speed +50 Faster Regeneration / Health and Ki +4000/s.', 'Supreme North Boots'),
54(10, 10, 140, 1, 0, 0, 'vocation', 'Vegetto', 'Vegetto');
55
56/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
57/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
58/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;