mirror of
https://github.com/ZhengPeiRu21/mod-individual-progression
synced 2025-11-29 23:44:51 +08:00
01b0ffc5f7
- all sql files moved to data directory - vanilla_regen_values is now labeled as optional. zz_optional_vanilla_regen_values.sql - vanilla_mob_factions removed, content moved to zone_ sql files - naxx40_remove_disables removed, content moved to naxx40 sql file - zone_elwynn_forest clean up - zone_durotar clean up - zone_tirisfal_glades clean up
127 lines
3.7 KiB
SQL
127 lines
3.7 KiB
SQL
/*
|
|
Due to significant power progression differences after level 60 and level 70,
|
|
this will modify PvP brackets to place players at these levels into lower brackets,
|
|
rather than grouping them with higher level players with much higher progression
|
|
*/
|
|
|
|
DROP TABLE IF EXISTS `pvpdifficulty_dbc`;
|
|
CREATE TABLE IF NOT EXISTS `pvpdifficulty_dbc` (
|
|
`ID` int NOT NULL DEFAULT '0',
|
|
`MapID` int NOT NULL DEFAULT '0',
|
|
`RangeIndex` int NOT NULL DEFAULT '0',
|
|
`MinLevel` int NOT NULL DEFAULT '0',
|
|
`MaxLevel` int NOT NULL DEFAULT '0',
|
|
`Difficulty` int NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
INSERT INTO `pvpdifficulty_dbc` (`ID`, `MapID`, `RangeIndex`, `MinLevel`, `MaxLevel`, `Difficulty`) VALUES
|
|
(1, 30, 0, 51, 60, 0), -- Alterac Valley
|
|
(2, 30, 1, 61, 70, 1),
|
|
(3, 30, 2, 71, 79, 2),
|
|
(4, 30, 3, 80, 85, 3),
|
|
(5, 489, 0, 10, 19, 0), -- Warsong Gulch
|
|
(6, 489, 1, 20, 29, 0),
|
|
(7, 489, 2, 30, 39, 0),
|
|
(8, 489, 3, 40, 49, 0),
|
|
(9, 489, 4, 50, 60, 0),
|
|
(10, 489, 5, 61, 70, 0),
|
|
(11, 489, 6, 71, 79, 0),
|
|
(12, 489, 7, 80, 85, 0),
|
|
(13, 529, 0, 20, 29, 0), -- Arathi Basin
|
|
(14, 529, 1, 30, 39, 0),
|
|
(15, 529, 2, 40, 49, 0),
|
|
(16, 529, 3, 50, 60, 0),
|
|
(17, 529, 4, 61, 70, 0),
|
|
(18, 529, 5, 71, 79, 0),
|
|
(19, 529, 6, 80, 85, 0),
|
|
(20, 559, 0, 10, 14, 0), -- Nagrand Arena
|
|
(21, 559, 1, 15, 19, 0),
|
|
(22, 559, 2, 20, 24, 0),
|
|
(23, 559, 3, 25, 29, 0),
|
|
(24, 559, 4, 30, 34, 0),
|
|
(25, 559, 5, 35, 39, 0),
|
|
(26, 559, 6, 40, 44, 0),
|
|
(27, 559, 7, 45, 49, 0),
|
|
(28, 559, 8, 50, 54, 0),
|
|
(29, 559, 9, 55, 60, 0),
|
|
(30, 559, 10, 61, 64, 0),
|
|
(31, 559, 11, 65, 70, 0),
|
|
(32, 559, 12, 71, 74, 0),
|
|
(33, 559, 13, 75, 79, 0),
|
|
(34, 559, 14, 80, 84, 0),
|
|
(35, 559, 15, 85, 89, 0),
|
|
(36, 562, 0, 10, 14, 0), -- Blade's Edge Arena
|
|
(37, 562, 1, 15, 19, 0),
|
|
(38, 562, 2, 20, 24, 0),
|
|
(39, 562, 3, 25, 29, 0),
|
|
(40, 562, 4, 30, 34, 0),
|
|
(41, 562, 5, 35, 39, 0),
|
|
(42, 562, 6, 40, 44, 0),
|
|
(43, 562, 7, 45, 49, 0),
|
|
(44, 562, 8, 50, 54, 0),
|
|
(45, 562, 9, 55, 60, 0),
|
|
(46, 562, 10, 61, 64, 0),
|
|
(47, 562, 11, 65, 70, 0),
|
|
(48, 562, 12, 71, 74, 0),
|
|
(49, 562, 13, 75, 79, 0),
|
|
(50, 562, 14, 80, 84, 0),
|
|
(51, 562, 15, 85, 89, 0),
|
|
(52, 566, 0, 61, 70, 0), -- Eye of the Storm
|
|
(53, 566, 1, 71, 79, 0),
|
|
(54, 566, 2, 80, 85, 0),
|
|
(55, 572, 0, 10, 14, 0), -- Ruins of Lordaeron
|
|
(56, 572, 1, 15, 19, 0),
|
|
(57, 572, 2, 20, 24, 0),
|
|
(58, 572, 3, 25, 29, 0),
|
|
(59, 572, 4, 30, 34, 0),
|
|
(60, 572, 5, 35, 39, 0),
|
|
(61, 572, 6, 40, 44, 0),
|
|
(62, 572, 7, 45, 49, 0),
|
|
(63, 572, 8, 50, 54, 0),
|
|
(64, 572, 9, 55, 60, 0),
|
|
(65, 572, 10, 61, 64, 0),
|
|
(66, 572, 11, 65, 70, 0),
|
|
(67, 572, 12, 71, 74, 0),
|
|
(68, 572, 13, 75, 79, 0),
|
|
(69, 572, 14, 80, 84, 0),
|
|
(70, 572, 15, 85, 89, 0),
|
|
(71, 607, 0, 71, 79, 0), -- Strand of the Ancients
|
|
(72, 607, 1, 80, 84, 1),
|
|
(73, 607, 2, 85, 85, 2),
|
|
(74, 617, 0, 10, 14, 0), -- Dalaran Sewers
|
|
(75, 617, 1, 15, 19, 0),
|
|
(76, 617, 2, 20, 24, 0),
|
|
(77, 617, 3, 25, 29, 0),
|
|
(78, 617, 4, 30, 34, 0),
|
|
(79, 617, 5, 35, 39, 0),
|
|
(80, 617, 6, 40, 44, 0),
|
|
(81, 617, 7, 45, 49, 0),
|
|
(82, 617, 8, 50, 54, 0),
|
|
(83, 617, 9, 55, 60, 0),
|
|
(84, 617, 10, 61, 64, 0),
|
|
(85, 617, 11, 65, 70, 0),
|
|
(86, 617, 12, 70, 74, 0),
|
|
(87, 617, 13, 75, 79, 0),
|
|
(88, 617, 14, 80, 84, 0),
|
|
(89, 617, 15, 85, 89, 0),
|
|
(90, 618, 0, 10, 14, 0), -- The Ring of Valor
|
|
(91, 618, 1, 15, 19, 0),
|
|
(92, 618, 2, 20, 24, 0),
|
|
(93, 618, 3, 25, 29, 0),
|
|
(94, 618, 4, 30, 34, 0),
|
|
(95, 618, 5, 35, 39, 0),
|
|
(96, 618, 6, 40, 44, 0),
|
|
(97, 618, 7, 45, 49, 0),
|
|
(98, 618, 8, 50, 54, 0),
|
|
(99, 618, 9, 55, 60, 0),
|
|
(100, 618, 10, 61, 64, 0),
|
|
(101, 618, 11, 65, 70, 0),
|
|
(102, 618, 12, 71, 74, 0),
|
|
(103, 618, 13, 75, 79, 0),
|
|
(104, 618, 14, 80, 84, 0),
|
|
(105, 618, 15, 85, 89, 0),
|
|
(106, 628, 0, 71, 79, 0), -- Isle of Conquest
|
|
(107, 628, 1, 80, 84, 1),
|
|
(108, 628, 2, 85, 89, 2);
|