Compare text

Find the difference between two text files

Real-time editor

Hide whitespace changes

Hide unchanged lines

Disable line wrap

Layout

Diff precision

Text styles

Syntax highlighting

Diffchecker Desktop The most secure way to run Diffchecker. Get the Diffchecker Desktop app: your diffs never leave your computer!Get Desktop

Difference SQL

Created 4 years agoDiff never expires

9 removals

Lines
Total
Removed

Characters
Total
Removed

To continue using this feature, upgrade to Diffchecker Pro View Pricing

207 lines

4 additions

Lines
Total
Added

Characters
Total
Added

To continue using this feature, upgrade to Diffchecker Pro View Pricing

201 lines

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

-- Host: 127.0.0.1

-- Server version: 5.5.9-log - MySQL Community Server (GPL)

-- Server OS: Win32

-- HeidiSQL Version: 9.4.0.5125

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

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET NAMES utf8 */;

/*!50503 SET NAMES utf8mb4 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping database structure for mop_world

CREATE DATABASE IF NOT EXISTS `mop_world` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `mop_world`;

-- Dumping structure for table mop_world.battle_pay_entry

CREATE TABLE IF NOT EXISTS `battle_pay_entry` (

`id` int(10) unsigned NOT NULL DEFAULT '0',

`productId` int(10) unsigned NOT NULL DEFAULT '0',

`groupId` int(10) unsigned NOT NULL DEFAULT '0',

`idx` int(10) NOT NULL DEFAULT '0',

`title` varchar(50) NOT NULL,

`description` varchar(500) NOT NULL,

`icon` int(10) unsigned NOT NULL DEFAULT '0',

`displayId` int(10) unsigned NOT NULL DEFAULT '0',

`banner` tinyint(3) unsigned NOT NULL DEFAULT '0',

`flags` int(10) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table mop_world.battle_pay_entry: 34 rows

DELETE FROM `battle_pay_entry`;

/*!40000 ALTER TABLE `battle_pay_entry` DISABLE KEYS */;

INSERT INTO `battle_pay_entry` (`id`, `productId`, `groupId`, `idx`, `title`, `description`, `icon`, `displayId`, `banner`, `flags`) VALUES

(44, 44, 2, 0, 'Experience Potion (300%)', 'Experience Potion', 0, 0, 2, 0),

(1, 83, 1, 0, 'Level 90 Character Boost', 'There comes a time in every hero\'s quest when they need a little boost to help get them over the hump and back into the action. With a level 90 character boost, you can grant one character a one-time boost to level 90 instantly.', 614740, 0, 2, 0),

(3, 3, 2, 0, 'Experience Potion (100%)', 'Experience Potion', 0, 0, 2, 0),

(4, 4, 4, 0, 'Foror\'s Crate of Storage', 'Bag 36 Slots', 0, 0, 0, 0),

(5, 5, 3, 0, 'Mini Teleporter', 'Pet', 913566, 0, 2, 0),

(5, 5, 3, 0, 'Perky Pug', 'A Store Pet', 913566, 0, 2, 0),

(6, 6, 5, 0, 'Thunderfury, Blessed Blade of the Windseeker', 'Legendary Weapon', 135349, 0, 2, 0),

(7, 7, 6, 0, '25,000 Gold', 'Gold', 133786, 0, 2, 0),

(8, 8, 6, 0, '100,000 Gold', 'Gold', 133784, 0, 2, 0),

(9, 9, 5, 0, 'Legendary Cloak : Qian-Le, Courage of Niuzao', 'Legendary Cloak', 0, 0, 2, 0),

(10, 10, 5, 0, 'Legendary Cloak : Xing-Ho, Breath of Yu\'lon', 'Legendary Cloak', 0, 0, 2, 0),

(11, 11, 5, 0, 'Legendary Cloak : Jina-Kang, Kindness of Chi-Ji', 'Legendary Cloak', 0, 0, 2, 0),

(12, 12, 5, 0, 'Legendary Cloak : Fen-Yu, Fury of Xuen', 'Legendary Cloak', 0, 0, 2, 0),

(13, 13, 5, 0, 'Legendary Cloak : Gong-Lu, Strength of Xuen', 'Legendary Cloak', 0, 0, 2, 0),

(14, 14, 5, 0, 'Legendary Cloak : Qian-Ying, Fortitude of Niuzao', 'Legendary Cloak', 0, 0, 2, 0),

(18, 18, 8, 0, 'Heart of the Aspects', 'A Store Mount', 576138, 0, 2, 0),

(19, 19, 8, 0, 'Iron Skyreaver', 'A Store Mount', 943739, 0, 2, 0),

(20, 20, 8, 0, 'Armored Bloodwing', 'A Store Mount', 804461, 0, 2, 0),

(17, 17, 8, 0, 'Celestial Steed', 'A Store Mount', 369225, 0, 2, 0),

(21, 21, 8, 0, 'Swift Windsteed', 'A Store Mount', 773250, 0, 2, 0),

(22, 22, 8, 0, 'Tyrael\'s Charger', 'A Store Mount', 577318, 0, 2, 0),

(23, 23, 8, 0, 'Winged Guardian', 'A Store Mount', 526356, 0, 2, 0),

(24, 24, 8, 0, 'Enchanted Fey Dragon', 'A Store Mount', 841541, 0, 2, 0),

(25, 25, 3, 0, 'Alterac Brew-Pup', 'A Store Pet', 930453, 0, 2, 0),

(26, 26, 3, 0, 'Lil KT', 'A Store Pet', 134514, 0, 2, 0),

(27, 27, 3, 0, 'Soul of the Aspects', 'A Store Pet', 574806, 0, 2, 0),

(28, 28, 3, 0, 'Lil Ragnaros', 'A Store Pet', 254652, 0, 2, 0),

(29, 29, 3, 0, 'Cinder Kitten', 'A Store Pet', 666530, 0, 2, 0),

(30, 30, 3, 0, 'Cenarion Hatchling', 'A Store Pet', 656241, 0, 2, 0),

(31, 31, 3, 0, 'Lil XT', 'A Store Pet', 254104, 0, 2, 0),

(16, 16, 8, 0, 'Grinning Reaver', 'A Store Mount', 986420, 0, 2, 0),

(15, 15, 8, 0, 'Warforged Nightmare', 'A Store Mount', 986419, 0, 2, 0),

(32, 32, 8, 0, 'Imperial Quilen', 'A Store Mount', 644374, 0, 2, 0),

(33, 33, 8, 0, 'Hearthsteed', 'A Store Mount', 853211, 0, 2, 0),

(34, 34, 8, 0, 'Armored Dread Raven', 'A Store Mount', 952015, 0, 2, 0);

/*!40000 ALTER TABLE `battle_pay_entry` ENABLE KEYS */;

-- Dumping structure for table mop_world.battle_pay_group

CREATE TABLE IF NOT EXISTS `battle_pay_group` (

`id` int(10) unsigned NOT NULL DEFAULT '0',

`idx` int(10) unsigned NOT NULL DEFAULT '0',

`name` varchar(16) NOT NULL,

`icon` int(10) unsigned NOT NULL DEFAULT '0',

`type` tinyint(3) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

UNIQUE KEY `id` (`idx`,`name`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table mop_world.battle_pay_group: 7 rows

DELETE FROM `battle_pay_group`;

/*!40000 ALTER TABLE `battle_pay_group` DISABLE KEYS */;

INSERT INTO `battle_pay_group` (`id`, `idx`, `name`, `icon`, `type`) VALUES

(1, 1, 'Featured', 939376, 1),

(2, 2, 'Consumables', 236883, 0),

(3, 3, 'Pets', 939380, 0),

(4, 4, 'Bags', 940857, 0),

(5, 5, 'Legendaries', 940868, 0),

(6, 6, 'Currencies', 133785, 0),

(8, 8, 'Mounts', 939379, 0);

/*!40000 ALTER TABLE `battle_pay_group` ENABLE KEYS */;

-- Dumping structure for table mop_world.battle_pay_product

CREATE TABLE IF NOT EXISTS `battle_pay_product` (

`id` int(10) unsigned NOT NULL DEFAULT '0',

`title` varchar(50) NOT NULL,

`description` varchar(500) NOT NULL,

`icon` int(10) unsigned NOT NULL DEFAULT '0',

`price` int(10) unsigned NOT NULL DEFAULT '0',

`discount` int(10) unsigned NOT NULL DEFAULT '0',

`displayId` int(10) unsigned NOT NULL DEFAULT '0',

`type` tinyint(3) unsigned NOT NULL DEFAULT '0',

`choiceType` tinyint(3) unsigned NOT NULL DEFAULT '0',

`flags` int(10) unsigned NOT NULL DEFAULT '0',

`flagsInfo` int(10) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table mop_world.battle_pay_product: 34 rows

DELETE FROM `battle_pay_product`;

/*!40000 ALTER TABLE `battle_pay_product` DISABLE KEYS */;

INSERT INTO `battle_pay_product` (`id`, `title`, `description`, `icon`, `price`, `discount`, `displayId`, `type`, `choiceType`, `flags`, `flagsInfo`) VALUES

(44, 'Experience Potion (300%)', 'Experience Potion', 236884, 500, 0, 0, 0, 1, 47, 0),

(83, 'Level 90 Character Boost', 'Boost your character to level 90!', 614740, 2000, 0, 0, 2, 1, 975, 0),

(3, 'Experience Potion (100%)', 'Experience Potion', 236883, 175, 0, 0, 0, 1, 47, 0),

(4, 'Foror\'s Crate of Resist Storage', 'Bag', 133633, 500, 0, 0, 0, 1, 47, 0),

(5, 'Mini Teleporter', 'Teleporter', 913566, 5, 0, 38484, 0, 1, 47, 0),

(5, 'Perky Pug', 'A Store Pet', 913566, 5, 0, 38484, 0, 1, 47, 0),

(6, 'Thunderfury, Blessed Blade of the Windseeker', 'Legendary Weapon', 135349, 10000, 0, 0, 0, 1, 47, 0),

(7, '25,000 Gold', 'Gold', 133786, 500, 0, 0, 0, 1, 47, 0),

(8, '100,000 Gold', 'Gold', 133784, 2000, 0, 0, 0, 1, 47, 0),

(9, 'Legendary Cloak : Qian-Le, Courage of Niuzao', 'Legendary Cloak', 852265, 10000, 0, 0, 0, 1, 47, 0),

(10, 'Legendary Cloak : Xing-Ho, Breath of Yu\'lon', 'Legendary Cloak', 852263, 10000, 0, 0, 0, 1, 47, 0),

(11, 'Legendary Cloak : Jina-Kang, Kindness of Chi-Ji', 'Legendary Cloak', 874780, 10000, 0, 0, 0, 1, 47, 0),

(12, 'Legendary Cloak : Fen-Yu, Fury of Xuen', 'Legendary Cloak', 852267, 10000, 0, 0, 0, 1, 47, 0),

(13, 'Legendary Cloak : Gong-Lu, Strength of Xuen', 'Legendary Cloak', 852267, 10000, 0, 0, 0, 1, 47, 0),

(14, 'Legendary Cloak : Qian-Ying, Fortitude of Niuzao', 'Legendary Cloak', 852265, 10000, 0, 0, 0, 1, 47, 0),

(17, 'Celestial Steed', 'A Store Mount', 369225, 25000, 0, 31958, 0, 1, 47, 0),

(18, 'Heart of the Aspects', 'A Store Mount', 576138, 25000, 0, 40029, 0, 1, 47, 0),

(19, 'Iron Skyreaver', 'A Store Mount', 943739, 25000, 0, 53038, 0, 1, 47, 0),

(25, 'Alterac Brew-Pup', 'A Store Pet', 930453, 1500, 0, 51988, 0, 1, 47, 0),

(20, 'Armored Bloodwing', 'A Store Mount', 804461, 25000, 0, 48020, 0, 1, 47, 0),

(23, 'Winged Guardian', 'A Store Mount', 526356, 25000, 0, 38260, 0, 1, 47, 0),

(22, 'Tyrael\'s Charger', 'A Store Mount', 577318, 25000, 0, 39530, 0, 1, 47, 0),

(21, 'Swift Windsteed', 'A Store Mount', 773250, 25000, 0, 46729, 0, 1, 47, 0),

(24, 'Enchanted Fey Dragon', 'A Store Mount', 841541, 25000, 0, 48714, 0, 1, 47, 0),

(26, 'Lil KT', 'A Store Pet', 134514, 1500, 0, 30507, 0, 1, 47, 0),

(27, 'Soul of the Aspects', 'A Store Pet', 574806, 1500, 0, 40019, 0, 1, 47, 0),

(28, 'Lil Ragnaros', 'A Store Pet', 254652, 1500, 0, 37541, 0, 1, 47, 0),

(29, 'Cinder Kitten', 'A Store Pet', 666530, 1500, 0, 46720, 0, 1, 47, 0),

(30, 'Cenarion Hatchling', 'A Store Pet', 656241, 1500, 0, 16943, 0, 1, 47, 0),

(31, 'Lil XT', 'A Store Pet', 254104, 1500, 0, 32031, 0, 1, 47, 0),

(16, 'Grinning Reaver', 'A Store Mount', 986420, 25000, 0, 55907, 0, 1, 47, 0),

(15, 'Warforged Nightmare', 'A Store Mount', 986419, 25000, 0, 55896, 0, 1, 47, 0),

(32, 'Imperial Quilen', 'A Store Mount', 644374, 25000, 0, 43254, 0, 1, 47, 0),

(33, 'Hearthsteed', 'A Store Mount', 853211, 25000, 0, 48931, 0, 1, 47, 0),

(34, 'Armored Dread Raven', 'A Store Mount', 952015, 25000, 0, 53774, 0, 1, 47, 0);

/*!40000 ALTER TABLE `battle_pay_product` ENABLE KEYS */;

-- Dumping structure for table mop_world.battle_pay_product_items

CREATE TABLE IF NOT EXISTS `battle_pay_product_items` (

`id` int(10) unsigned NOT NULL DEFAULT '0',

`itemId` int(10) unsigned NOT NULL DEFAULT '0',

`count` int(10) unsigned NOT NULL DEFAULT '0',

`productId` int(10) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

UNIQUE KEY `productId` (`itemId`,`productId`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table mop_world.battle_pay_product_items: 34 rows

DELETE FROM `battle_pay_product_items`;

/*!40000 ALTER TABLE `battle_pay_product_items` DISABLE KEYS */;

INSERT INTO `battle_pay_product_items` (`id`, `itemId`, `count`, `productId`) VALUES

(83, 0, 0, 83),

(44, 86574, 1, 44),

(3, 103557, 1, 3),

(4, 23162, 1, 4),

(5, 49912, 1, 5),

(6, 19019, 1, 6),

(7, 926019, 1, 7),

(8, 926020, 1, 8),

(9, 102245, 1, 9),

(10, 102246, 1, 10),

(11, 102247, 1, 11),

(12, 102248, 1, 12),

(13, 102249, 1, 13),

(14, 102250, 1, 14),

(17, 54811, 1, 17),

(22, 76755, 1, 22),

(21, 92724, 1, 21),

(20, 95341, 1, 20),

(19, 107951, 1, 19),

(18, 78924, 1, 18),

(23, 69846, 1, 23),

(24, 97989, 1, 24),

(25, 106240, 1, 25),

(26, 49693, 1, 26),

(27, 78916, 1, 27),

(28, 68385, 1, 28),

(29, 92707, 1, 29),

(30, 70099, 1, 30),

(31, 54847, 1, 31),

(16, 112327, 1, 16),

(15, 112326, 1, 15),

(32, 85870, 1, 32),

(33, 98618, 1, 33),

(34, 109013, 1, 34);

/*!40000 ALTER TABLE `battle_pay_product_items` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;

/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Saved diffs

Original text

Open file

-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.5.9-log - MySQL Community Server (GPL)
-- Server OS:                    Win32
-- HeidiSQL Version:             9.4.0.5125
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping database structure for mop_world
CREATE DATABASE IF NOT EXISTS `mop_world` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `mop_world`;

-- Dumping structure for table mop_world.battle_pay_entry
CREATE TABLE IF NOT EXISTS `battle_pay_entry` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `productId` int(10) unsigned NOT NULL DEFAULT '0',
  `groupId` int(10) unsigned NOT NULL DEFAULT '0',
  `idx` int(10) NOT NULL DEFAULT '0',
  `title` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `icon` int(10) unsigned NOT NULL DEFAULT '0',
  `displayId` int(10) unsigned NOT NULL DEFAULT '0',
  `banner` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `flags` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table mop_world.battle_pay_entry: 34 rows
DELETE FROM `battle_pay_entry`;
/*!40000 ALTER TABLE `battle_pay_entry` DISABLE KEYS */;
INSERT INTO `battle_pay_entry` (`id`, `productId`, `groupId`, `idx`, `title`, `description`, `icon`, `displayId`, `banner`, `flags`) VALUES
	(44, 44, 2, 0, 'Experience Potion (300%)', 'Experience Potion', 0, 0, 2, 0),
	(1, 83, 1, 0, 'Level 90 Character Boost', 'There comes a time in every hero\'s quest when they need a little boost to help get them over the hump and back into the action. With a level 90 character boost, you can grant one character a one-time boost to level 90 instantly.', 614740, 0, 2, 0),
	(3, 3, 2, 0, 'Experience Potion (100%)', 'Experience Potion', 0, 0, 2, 0),
	(4, 4, 4, 0, 'Foror\'s Crate of Storage', 'Bag 36 Slots', 0, 0, 0, 0),
	(5, 5, 3, 0, 'Mini Teleporter', 'Pet', 913566, 0, 2, 0),
	(6, 6, 5, 0, 'Thunderfury, Blessed Blade of the Windseeker', 'Legendary Weapon', 135349, 0, 2, 0),
	(7, 7, 6, 0, '25,000 Gold', 'Gold', 133786, 0, 2, 0),
	(8, 8, 6, 0, '100,000 Gold', 'Gold', 133784, 0, 2, 0),
	(9, 9, 5, 0, 'Legendary Cloak : Qian-Le, Courage of Niuzao', 'Legendary Cloak', 0, 0, 2, 0),
	(10, 10, 5, 0, 'Legendary Cloak : Xing-Ho, Breath of Yu\'lon', 'Legendary Cloak', 0, 0, 2, 0),
	(11, 11, 5, 0, 'Legendary Cloak : Jina-Kang, Kindness of Chi-Ji', 'Legendary Cloak', 0, 0, 2, 0),
	(12, 12, 5, 0, 'Legendary Cloak : Fen-Yu, Fury of Xuen', 'Legendary Cloak', 0, 0, 2, 0),
	(13, 13, 5, 0, 'Legendary Cloak : Gong-Lu, Strength of Xuen', 'Legendary Cloak', 0, 0, 2, 0),
	(14, 14, 5, 0, 'Legendary Cloak : Qian-Ying, Fortitude of Niuzao', 'Legendary Cloak', 0, 0, 2, 0),
	(18, 18, 8, 0, 'Heart of the Aspects', 'A Store Mount', 576138, 0, 2, 0),
	(19, 19, 8, 0, 'Iron Skyreaver', 'A Store Mount', 943739, 0, 2, 0),
	(20, 20, 8, 0, 'Armored Bloodwing', 'A Store Mount', 804461, 0, 2, 0),
	(17, 17, 8, 0, 'Celestial Steed', 'A Store Mount', 369225, 0, 2, 0),
	(21, 21, 8, 0, 'Swift Windsteed', 'A Store Mount', 773250, 0, 2, 0),
	(22, 22, 8, 0, 'Tyrael\'s Charger', 'A Store Mount', 577318, 0, 2, 0),
	(23, 23, 8, 0, 'Winged Guardian', 'A Store Mount', 526356, 0, 2, 0),
	(24, 24, 8, 0, 'Enchanted Fey Dragon', 'A Store Mount', 841541, 0, 2, 0),
	(25, 25, 3, 0, 'Alterac Brew-Pup', 'A Store Pet', 930453, 0, 2, 0),
	(26, 26, 3, 0, 'Lil KT', 'A Store Pet', 134514, 0, 2, 0),
	(27, 27, 3, 0, 'Soul of the Aspects', 'A Store Pet', 574806, 0, 2, 0),
	(28, 28, 3, 0, 'Lil Ragnaros', 'A Store Pet', 254652, 0, 2, 0),
	(29, 29, 3, 0, 'Cinder Kitten', 'A Store Pet', 666530, 0, 2, 0),
	(30, 30, 3, 0, 'Cenarion Hatchling', 'A Store Pet', 656241, 0, 2, 0),
	(31, 31, 3, 0, 'Lil XT', 'A Store Pet', 254104, 0, 2, 0),
	(16, 16, 8, 0, 'Grinning Reaver', 'A Store Mount', 986420, 0, 2, 0),
	(15, 15, 8, 0, 'Warforged Nightmare', 'A Store Mount', 986419, 0, 2, 0),
	(32, 32, 8, 0, 'Imperial Quilen', 'A Store Mount', 644374, 0, 2, 0),
	(33, 33, 8, 0, 'Hearthsteed', 'A Store Mount', 853211, 0, 2, 0),
	(34, 34, 8, 0, 'Armored Dread Raven', 'A Store Mount', 952015, 0, 2, 0);
/*!40000 ALTER TABLE `battle_pay_entry` ENABLE KEYS */;

-- Dumping structure for table mop_world.battle_pay_group
CREATE TABLE IF NOT EXISTS `battle_pay_group` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `idx` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(16) NOT NULL,
  `icon` int(10) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`idx`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table mop_world.battle_pay_group: 7 rows
DELETE FROM `battle_pay_group`;
/*!40000 ALTER TABLE `battle_pay_group` DISABLE KEYS */;
INSERT INTO `battle_pay_group` (`id`, `idx`, `name`, `icon`, `type`) VALUES
	(1, 1, 'Featured', 939376, 1),
	(2, 2, 'Consumables', 236883, 0),
	(3, 3, 'Pets', 939380, 0),
	(4, 4, 'Bags', 940857, 0),
	(5, 5, 'Legendaries', 940868, 0),
	(6, 6, 'Currencies', 133785, 0),
	(8, 8, 'Mounts', 939379, 0);
/*!40000 ALTER TABLE `battle_pay_group` ENABLE KEYS */;

-- Dumping structure for table mop_world.battle_pay_product
CREATE TABLE IF NOT EXISTS `battle_pay_product` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `title` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `icon` int(10) unsigned NOT NULL DEFAULT '0',
  `price` int(10) unsigned NOT NULL DEFAULT '0',
  `discount` int(10) unsigned NOT NULL DEFAULT '0',
  `displayId` int(10) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `choiceType` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `flags` int(10) unsigned NOT NULL DEFAULT '0',
  `flagsInfo` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table mop_world.battle_pay_product: 34 rows
DELETE FROM `battle_pay_product`;
/*!40000 ALTER TABLE `battle_pay_product` DISABLE KEYS */;
INSERT INTO `battle_pay_product` (`id`, `title`, `description`, `icon`, `price`, `discount`, `displayId`, `type`, `choiceType`, `flags`, `flagsInfo`) VALUES
	(44, 'Experience Potion (300%)', 'Experience Potion', 236884, 500, 0, 0, 0, 1, 47, 0),
	(83, 'Level 90 Character Boost', 'Boost your character to level 90!', 614740, 2000, 0, 0, 2, 1, 975, 0),
	(3, 'Experience Potion (100%)', 'Experience Potion', 236883, 175, 0, 0, 0, 1, 47, 0),
	(4, 'Foror\'s Crate of Resist Storage', 'Bag', 133633, 500, 0, 0, 0, 1, 47, 0),
	(5, 'Mini Teleporter', 'Teleporter', 913566, 5, 0, 38484, 0, 1, 47, 0),
	(6, 'Thunderfury, Blessed Blade of the Windseeker', 'Legendary Weapon', 135349, 10000, 0, 0, 0, 1, 47, 0),
	(7, '25,000 Gold', 'Gold', 133786, 500, 0, 0, 0, 1, 47, 0),
	(8, '100,000 Gold', 'Gold', 133784, 2000, 0, 0, 0, 1, 47, 0),
	(9, 'Legendary Cloak : Qian-Le, Courage of Niuzao', 'Legendary Cloak', 852265, 10000, 0, 0, 0, 1, 47, 0),
	(10, 'Legendary Cloak : Xing-Ho, Breath of Yu\'lon', 'Legendary Cloak', 852263, 10000, 0, 0, 0, 1, 47, 0),
	(11, 'Legendary Cloak : Jina-Kang, Kindness of Chi-Ji', 'Legendary Cloak', 874780, 10000, 0, 0, 0, 1, 47, 0),
	(12, 'Legendary Cloak : Fen-Yu, Fury of Xuen', 'Legendary Cloak', 852267, 10000, 0, 0, 0, 1, 47, 0),
	(13, 'Legendary Cloak : Gong-Lu, Strength of Xuen', 'Legendary Cloak', 852267, 10000, 0, 0, 0, 1, 47, 0),
	(14, 'Legendary Cloak : Qian-Ying, Fortitude of Niuzao', 'Legendary Cloak', 852265, 10000, 0, 0, 0, 1, 47, 0),
	(17, 'Celestial Steed', 'A Store Mount', 369225, 25000, 0, 31958, 0, 1, 47, 0),
	(18, 'Heart of the Aspects', 'A Store Mount', 576138, 25000, 0, 40029, 0, 1, 47, 0),
	(19, 'Iron Skyreaver', 'A Store Mount', 943739, 25000, 0, 53038, 0, 1, 47, 0),
	(25, 'Alterac Brew-Pup', 'A Store Pet', 930453, 1500, 0, 51988, 0, 1, 47, 0),
	(20, 'Armored Bloodwing', 'A Store Mount', 804461, 25000, 0, 48020, 0, 1, 47, 0),
	(23, 'Winged Guardian', 'A Store Mount', 526356, 25000, 0, 38260, 0, 1, 47, 0),
	(22, 'Tyrael\'s Charger', 'A Store Mount', 577318, 25000, 0, 39530, 0, 1, 47, 0),
	(21, 'Swift Windsteed', 'A Store Mount', 773250, 25000, 0, 46729, 0, 1, 47, 0),
	(24, 'Enchanted Fey Dragon', 'A Store Mount', 841541, 25000, 0, 48714, 0, 1, 47, 0),
	(26, 'Lil KT', 'A Store Pet', 134514, 1500, 0, 30507, 0, 1, 47, 0),
	(27, 'Soul of the Aspects', 'A Store Pet', 574806, 1500, 0, 40019, 0, 1, 47, 0),
	(28, 'Lil Ragnaros', 'A Store Pet', 254652, 1500, 0, 37541, 0, 1, 47, 0),
	(29, 'Cinder Kitten', 'A Store Pet', 666530, 1500, 0, 46720, 0, 1, 47, 0),
	(30, 'Cenarion Hatchling', 'A Store Pet', 656241, 1500, 0, 16943, 0, 1, 47, 0),
	(31, 'Lil XT', 'A Store Pet', 254104, 1500, 0, 32031, 0, 1, 47, 0),
	(16, 'Grinning Reaver', 'A Store Mount', 986420, 25000, 0, 55907, 0, 1, 47, 0),
	(15, 'Warforged Nightmare', 'A Store Mount', 986419, 25000, 0, 55896, 0, 1, 47, 0),
	(32, 'Imperial Quilen', 'A Store Mount', 644374, 25000, 0, 43254, 0, 1, 47, 0),
	(33, 'Hearthsteed', 'A Store Mount', 853211, 25000, 0, 48931, 0, 1, 47, 0),
	(34, 'Armored Dread Raven', 'A Store Mount', 952015, 25000, 0, 53774, 0, 1, 47, 0);
/*!40000 ALTER TABLE `battle_pay_product` ENABLE KEYS */;

-- Dumping structure for table mop_world.battle_pay_product_items
CREATE TABLE IF NOT EXISTS `battle_pay_product_items` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `itemId` int(10) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `productId` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `productId` (`itemId`,`productId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table mop_world.battle_pay_product_items: 34 rows
DELETE FROM `battle_pay_product_items`;
/*!40000 ALTER TABLE `battle_pay_product_items` DISABLE KEYS */;
INSERT INTO `battle_pay_product_items` (`id`, `itemId`, `count`, `productId`) VALUES
	(83, 0, 0, 83),
	(44, 86574, 1, 44),
	(3, 103557, 1, 3),
	(4, 23162, 1, 4),
	(5, 49912, 1, 5),
	(6, 19019, 1, 6),
	(7, 926019, 1, 7),
	(8, 926020, 1, 8),
	(9, 102245, 1, 9),
	(10, 102246, 1, 10),
	(11, 102247, 1, 11),
	(12, 102248, 1, 12),
	(13, 102249, 1, 13),
	(14, 102250, 1, 14),
	(17, 54811, 1, 17),
	(22, 76755, 1, 22),
	(21, 92724, 1, 21),
	(20, 95341, 1, 20),
	(19, 107951, 1, 19),
	(18, 78924, 1, 18),
	(23, 69846, 1, 23),
	(24, 97989, 1, 24),
	(25, 106240, 1, 25),
	(26, 49693, 1, 26),
	(27, 78916, 1, 27),
	(28, 68385, 1, 28),
	(29, 92707, 1, 29),
	(30, 70099, 1, 30),
	(31, 54847, 1, 31),
	(16, 112327, 1, 16),
	(15, 112326, 1, 15),
	(32, 85870, 1, 32),
	(33, 98618, 1, 33),
	(34, 109013, 1, 34);
/*!40000 ALTER TABLE `battle_pay_product_items` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Changed text

Open file

-- Dumping database structure for mop_world
CREATE DATABASE IF NOT EXISTS `mop_world` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `mop_world`;

-- Dumping data for table mop_world.battle_pay_entry: 34 rows
DELETE FROM `battle_pay_entry`;
/*!40000 ALTER TABLE `battle_pay_entry` DISABLE KEYS */;
INSERT INTO `battle_pay_entry` (`id`, `productId`, `groupId`, `idx`, `title`, `description`, `icon`, `displayId`, `banner`, `flags`) VALUES
	(44, 44, 2, 0, 'Experience Potion (300%)', 'Experience Potion', 0, 0, 2, 0),
	(1, 83, 1, 0, 'Level 90 Character Boost', 'There comes a time in every hero\'s quest when they need a little boost to help get them over the hump and back into the action. With a level 90 character boost, you can grant one character a one-time boost to level 90 instantly.', 614740, 0, 2, 0),
	(3, 3, 2, 0, 'Experience Potion (100%)', 'Experience Potion', 0, 0, 2, 0),
	(4, 4, 4, 0, 'Foror\'s Crate of Storage', 'Bag 36 Slots', 0, 0, 0, 0),
	(5, 5, 3, 0, 'Perky Pug', 'A Store Pet', 913566, 0, 2, 0),
	(6, 6, 5, 0, 'Thunderfury, Blessed Blade of the Windseeker', 'Legendary Weapon', 135349, 0, 2, 0),
	(9, 9, 5, 0, 'Legendary Cloak : Qian-Le, Courage of Niuzao', 'Legendary Cloak', 0, 0, 2, 0),
	(10, 10, 5, 0, 'Legendary Cloak : Xing-Ho, Breath of Yu\'lon', 'Legendary Cloak', 0, 0, 2, 0),
	(11, 11, 5, 0, 'Legendary Cloak : Jina-Kang, Kindness of Chi-Ji', 'Legendary Cloak', 0, 0, 2, 0),
	(12, 12, 5, 0, 'Legendary Cloak : Fen-Yu, Fury of Xuen', 'Legendary Cloak', 0, 0, 2, 0),
	(13, 13, 5, 0, 'Legendary Cloak : Gong-Lu, Strength of Xuen', 'Legendary Cloak', 0, 0, 2, 0),
	(14, 14, 5, 0, 'Legendary Cloak : Qian-Ying, Fortitude of Niuzao', 'Legendary Cloak', 0, 0, 2, 0),
	(18, 18, 8, 0, 'Heart of the Aspects', 'A Store Mount', 576138, 0, 2, 0),
	(19, 19, 8, 0, 'Iron Skyreaver', 'A Store Mount', 943739, 0, 2, 0),
	(20, 20, 8, 0, 'Armored Bloodwing', 'A Store Mount', 804461, 0, 2, 0),
	(17, 17, 8, 0, 'Celestial Steed', 'A Store Mount', 369225, 0, 2, 0),
	(21, 21, 8, 0, 'Swift Windsteed', 'A Store Mount', 773250, 0, 2, 0),
	(22, 22, 8, 0, 'Tyrael\'s Charger', 'A Store Mount', 577318, 0, 2, 0),
	(23, 23, 8, 0, 'Winged Guardian', 'A Store Mount', 526356, 0, 2, 0),
	(24, 24, 8, 0, 'Enchanted Fey Dragon', 'A Store Mount', 841541, 0, 2, 0),
	(25, 25, 3, 0, 'Alterac Brew-Pup', 'A Store Pet', 930453, 0, 2, 0),
	(26, 26, 3, 0, 'Lil KT', 'A Store Pet', 134514, 0, 2, 0),
	(27, 27, 3, 0, 'Soul of the Aspects', 'A Store Pet', 574806, 0, 2, 0),
	(28, 28, 3, 0, 'Lil Ragnaros', 'A Store Pet', 254652, 0, 2, 0),
	(29, 29, 3, 0, 'Cinder Kitten', 'A Store Pet', 666530, 0, 2, 0),
	(30, 30, 3, 0, 'Cenarion Hatchling', 'A Store Pet', 656241, 0, 2, 0),
	(31, 31, 3, 0, 'Lil XT', 'A Store Pet', 254104, 0, 2, 0),
	(16, 16, 8, 0, 'Grinning Reaver', 'A Store Mount', 986420, 0, 2, 0),
	(15, 15, 8, 0, 'Warforged Nightmare', 'A Store Mount', 986419, 0, 2, 0),
	(32, 32, 8, 0, 'Imperial Quilen', 'A Store Mount', 644374, 0, 2, 0),
	(33, 33, 8, 0, 'Hearthsteed', 'A Store Mount', 853211, 0, 2, 0),
	(34, 34, 8, 0, 'Armored Dread Raven', 'A Store Mount', 952015, 0, 2, 0);
/*!40000 ALTER TABLE `battle_pay_entry` ENABLE KEYS */;

-- Dumping data for table mop_world.battle_pay_product: 34 rows
DELETE FROM `battle_pay_product`;
/*!40000 ALTER TABLE `battle_pay_product` DISABLE KEYS */;
INSERT INTO `battle_pay_product` (`id`, `title`, `description`, `icon`, `price`, `discount`, `displayId`, `type`, `choiceType`, `flags`, `flagsInfo`) VALUES
	(44, 'Experience Potion (300%)', 'Experience Potion', 236884, 500, 0, 0, 0, 1, 47, 0),
	(83, 'Level 90 Character Boost', 'Boost your character to level 90!', 614740, 2000, 0, 0, 2, 1, 975, 0),
	(3, 'Experience Potion (100%)', 'Experience Potion', 236883, 175, 0, 0, 0, 1, 47, 0),
	(4, 'Foror\'s Crate of Resist Storage', 'Bag', 133633, 500, 0, 0, 0, 1, 47, 0),
	(5, 'Perky Pug', 'A Store Pet', 913566, 5, 0, 38484, 0, 1, 47, 0),
	(6, 'Thunderfury, Blessed Blade of the Windseeker', 'Legendary Weapon', 135349, 10000, 0, 0, 0, 1, 47, 0),
	(9, 'Legendary Cloak : Qian-Le, Courage of Niuzao', 'Legendary Cloak', 852265, 10000, 0, 0, 0, 1, 47, 0),
	(10, 'Legendary Cloak : Xing-Ho, Breath of Yu\'lon', 'Legendary Cloak', 852263, 10000, 0, 0, 0, 1, 47, 0),
	(11, 'Legendary Cloak : Jina-Kang, Kindness of Chi-Ji', 'Legendary Cloak', 874780, 10000, 0, 0, 0, 1, 47, 0),
	(12, 'Legendary Cloak : Fen-Yu, Fury of Xuen', 'Legendary Cloak', 852267, 10000, 0, 0, 0, 1, 47, 0),
	(13, 'Legendary Cloak : Gong-Lu, Strength of Xuen', 'Legendary Cloak', 852267, 10000, 0, 0, 0, 1, 47, 0),
	(14, 'Legendary Cloak : Qian-Ying, Fortitude of Niuzao', 'Legendary Cloak', 852265, 10000, 0, 0, 0, 1, 47, 0),
	(17, 'Celestial Steed', 'A Store Mount', 369225, 25000, 0, 31958, 0, 1, 47, 0),
	(18, 'Heart of the Aspects', 'A Store Mount', 576138, 25000, 0, 40029, 0, 1, 47, 0),
	(19, 'Iron Skyreaver', 'A Store Mount', 943739, 25000, 0, 53038, 0, 1, 47, 0),
	(25, 'Alterac Brew-Pup', 'A Store Pet', 930453, 1500, 0, 51988, 0, 1, 47, 0),
	(20, 'Armored Bloodwing', 'A Store Mount', 804461, 25000, 0, 48020, 0, 1, 47, 0),
	(23, 'Winged Guardian', 'A Store Mount', 526356, 25000, 0, 38260, 0, 1, 47, 0),
	(22, 'Tyrael\'s Charger', 'A Store Mount', 577318, 25000, 0, 39530, 0, 1, 47, 0),
	(21, 'Swift Windsteed', 'A Store Mount', 773250, 25000, 0, 46729, 0, 1, 47, 0),
	(24, 'Enchanted Fey Dragon', 'A Store Mount', 841541, 25000, 0, 48714, 0, 1, 47, 0),
	(26, 'Lil KT', 'A Store Pet', 134514, 1500, 0, 30507, 0, 1, 47, 0),
	(27, 'Soul of the Aspects', 'A Store Pet', 574806, 1500, 0, 40019, 0, 1, 47, 0),
	(28, 'Lil Ragnaros', 'A Store Pet', 254652, 1500, 0, 37541, 0, 1, 47, 0),
	(29, 'Cinder Kitten', 'A Store Pet', 666530, 1500, 0, 46720, 0, 1, 47, 0),
	(30, 'Cenarion Hatchling', 'A Store Pet', 656241, 1500, 0, 16943, 0, 1, 47, 0),
	(31, 'Lil XT', 'A Store Pet', 254104, 1500, 0, 32031, 0, 1, 47, 0),
	(16, 'Grinning Reaver', 'A Store Mount', 986420, 25000, 0, 55907, 0, 1, 47, 0),
	(15, 'Warforged Nightmare', 'A Store Mount', 986419, 25000, 0, 55896, 0, 1, 47, 0),
	(32, 'Imperial Quilen', 'A Store Mount', 644374, 25000, 0, 43254, 0, 1, 47, 0),
	(33, 'Hearthsteed', 'A Store Mount', 853211, 25000, 0, 48931, 0, 1, 47, 0),
	(34, 'Armored Dread Raven', 'A Store Mount', 952015, 25000, 0, 53774, 0, 1, 47, 0);
/*!40000 ALTER TABLE `battle_pay_product` ENABLE KEYS */;

-- Dumping data for table mop_world.battle_pay_product_items: 34 rows
DELETE FROM `battle_pay_product_items`;
/*!40000 ALTER TABLE `battle_pay_product_items` DISABLE KEYS */;
INSERT INTO `battle_pay_product_items` (`id`, `itemId`, `count`, `productId`) VALUES
	(83, 0, 0, 83),
	(44, 86574, 1, 44),
	(3, 103557, 1, 3),
	(4, 23162, 1, 4),
	(5, 49912, 1, 5),
	(6, 19019, 1, 6),
	(9, 102245, 1, 9),
	(10, 102246, 1, 10),
	(11, 102247, 1, 11),
	(12, 102248, 1, 12),
	(13, 102249, 1, 13),
	(14, 102250, 1, 14),
	(17, 54811, 1, 17),
	(22, 76755, 1, 22),
	(21, 92724, 1, 21),
	(20, 95341, 1, 20),
	(19, 107951, 1, 19),
	(18, 78924, 1, 18),
	(23, 69846, 1, 23),
	(24, 97989, 1, 24),
	(25, 106240, 1, 25),
	(26, 49693, 1, 26),
	(27, 78916, 1, 27),
	(28, 68385, 1, 28),
	(29, 92707, 1, 29),
	(30, 70099, 1, 30),
	(31, 54847, 1, 31),
	(16, 112327, 1, 16),
	(15, 112326, 1, 15),
	(32, 85870, 1, 32),
	(33, 98618, 1, 33),
	(34, 109013, 1, 34);
/*!40000 ALTER TABLE `battle_pay_product_items` ENABLE KEYS */;