diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/TBC-WLK converter/TBC-WLK_world.sql | 8 | ||||
| -rw-r--r-- | sql/mangos.sql | 101 | ||||
| -rw-r--r-- | sql/updates/7092_01_mangos_player_xp_for_level.sql | 93 |
3 files changed, 201 insertions, 1 deletions
diff --git a/sql/TBC-WLK converter/TBC-WLK_world.sql b/sql/TBC-WLK converter/TBC-WLK_world.sql index e9fe8600c37..806e9f9d866 100644 --- a/sql/TBC-WLK converter/TBC-WLK_world.sql +++ b/sql/TBC-WLK converter/TBC-WLK_world.sql @@ -218,11 +218,19 @@ CREATE TABLE `spell_proc_event` ( PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS `player_xp_for_level`; +CREATE TABLE `player_xp_for_level` ( + `lvl` int(3) unsigned NOT NULL, + `xp_for_next_level` int(10) unsigned NOT NULL, + PRIMARY KEY (`lvl`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + INSERT INTO world.player_classlevelstats SELECT * FROM mangos.player_classlevelstats; INSERT INTO world.player_levelstats SELECT * FROM mangos.player_levelstats; INSERT INTO world.playercreateinfo_spell SELECT * FROM mangos.playercreateinfo_spell; INSERT INTO world.playercreateinfo_action SELECT * FROM mangos.playercreateinfo_action; INSERT INTO world.spell_learn_spell SELECT * FROM mangos.spell_learn_spell; +INSERT INTO world.player_xp_for_level SELECT * FROM mangos.player_xp_for_level; DELETE FROM item_template WHERE entry IN (34648,34649,34650,34651,34652,34653,34655,34656,34657,34658,34659,38145,38147,41751); diff --git a/sql/mangos.sql b/sql/mangos.sql index 4d75aad4d6b..d6f89080644 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -22,7 +22,7 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, - `required_7078_01_mangos_spell_proc_event` bit(1) default NULL + `required_7092_01_mangos_player_xp_for_level` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -9291,6 +9291,105 @@ INSERT INTO `player_levelstats` VALUES /*!40000 ALTER TABLE `player_levelstats` ENABLE KEYS */; UNLOCK TABLES; +-- ---------------------------- +-- Table structure for player_xp_for_level +-- ---------------------------- +DROP TABLE IF EXISTS `player_xp_for_level`; +CREATE TABLE `player_xp_for_level` ( + `lvl` int(3) unsigned NOT NULL, + `xp_for_next_level` int(10) unsigned NOT NULL, + PRIMARY KEY (`lvl`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `player_xp_for_level` +-- + +LOCK TABLES `player_xp_for_level` WRITE; +/*!40000 ALTER TABLE `player_xp_for_level` DISABLE KEYS */; +INSERT INTO `player_xp_for_level` VALUES +('1', '400'), +('2', '900'), +('3', '1400'), +('4', '2100'), +('5', '2800'), +('6', '3600'), +('7', '4500'), +('8', '5400'), +('9', '6500'), +('10', '7600'), +('11', '8700'), +('12', '9800'), +('13', '11000'), +('14', '12300'), +('15', '13600'), +('16', '15000'), +('17', '16400'), +('18', '17800'), +('19', '19300'), +('20', '20800'), +('21', '22400'), +('22', '24000'), +('23', '25500'), +('24', '27200'), +('25', '28900'), +('26', '30500'), +('27', '32200'), +('28', '33900'), +('29', '36300'), +('30', '38800'), +('31', '41600'), +('32', '44600'), +('33', '48000'), +('34', '51400'), +('35', '55000'), +('36', '58700'), +('37', '62400'), +('38', '66200'), +('39', '70200'), +('40', '74300'), +('41', '78500'), +('42', '82800'), +('43', '87100'), +('44', '91600'), +('45', '96300'), +('46', '101000'), +('47', '105800'), +('48', '110700'), +('49', '115700'), +('50', '120900'), +('51', '126100'), +('52', '131500'), +('53', '137000'), +('54', '142500'), +('55', '148200'), +('56', '154000'), +('57', '159900'), +('58', '165800'), +('59', '172000'), +('60', '290000'), +('61', '317000'), +('62', '349000'), +('63', '386000'), +('64', '428000'), +('65', '475000'), +('66', '527000'), +('67', '585000'), +('68', '648000'), +('69', '717000'), +('70', '1523800'), +('71', '1539600'), +('72', '1555700'), +('73', '1571800'), +('74', '1587900'), +('75', '1604200'), +('76', '1620700'), +('77', '1637400'), +('78', '1653900'), +('79', '1670800'); +/*!40000 ALTER TABLE `player_xp_for_level` ENABLE KEYS */; +UNLOCK TABLES; + -- -- Table structure for table `playercreateinfo` -- diff --git a/sql/updates/7092_01_mangos_player_xp_for_level.sql b/sql/updates/7092_01_mangos_player_xp_for_level.sql new file mode 100644 index 00000000000..aa4fabd2866 --- /dev/null +++ b/sql/updates/7092_01_mangos_player_xp_for_level.sql @@ -0,0 +1,93 @@ +ALTER TABLE db_version CHANGE COLUMN required_7078_01_mangos_spell_proc_event required_7092_01_mangos_player_xp_for_level bit; + +DROP TABLE IF EXISTS `player_xp_for_level`; +CREATE TABLE `player_xp_for_level` ( + `lvl` int(3) unsigned NOT NULL, + `xp_for_next_level` int(10) unsigned NOT NULL, + PRIMARY KEY (`lvl`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `player_xp_for_level` +-- + +INSERT INTO `player_xp_for_level` VALUES +('1', '400'), +('2', '900'), +('3', '1400'), +('4', '2100'), +('5', '2800'), +('6', '3600'), +('7', '4500'), +('8', '5400'), +('9', '6500'), +('10', '7600'), +('11', '8700'), +('12', '9800'), +('13', '11000'), +('14', '12300'), +('15', '13600'), +('16', '15000'), +('17', '16400'), +('18', '17800'), +('19', '19300'), +('20', '20800'), +('21', '22400'), +('22', '24000'), +('23', '25500'), +('24', '27200'), +('25', '28900'), +('26', '30500'), +('27', '32200'), +('28', '33900'), +('29', '36300'), +('30', '38800'), +('31', '41600'), +('32', '44600'), +('33', '48000'), +('34', '51400'), +('35', '55000'), +('36', '58700'), +('37', '62400'), +('38', '66200'), +('39', '70200'), +('40', '74300'), +('41', '78500'), +('42', '82800'), +('43', '87100'), +('44', '91600'), +('45', '96300'), +('46', '101000'), +('47', '105800'), +('48', '110700'), +('49', '115700'), +('50', '120900'), +('51', '126100'), +('52', '131500'), +('53', '137000'), +('54', '142500'), +('55', '148200'), +('56', '154000'), +('57', '159900'), +('58', '165800'), +('59', '172000'), +('60', '290000'), +('61', '317000'), +('62', '349000'), +('63', '386000'), +('64', '428000'), +('65', '475000'), +('66', '527000'), +('67', '585000'), +('68', '648000'), +('69', '717000'), +('70', '1523800'), +('71', '1539600'), +('72', '1555700'), +('73', '1571800'), +('74', '1587900'), +('75', '1604200'), +('76', '1620700'), +('77', '1637400'), +('78', '1653900'), +('79', '1670800');
\ No newline at end of file |