From 943b3195da5076727bfeba4090f6ee605605e4fe Mon Sep 17 00:00:00 2001
From: _manuel_ <none@none>
Date: Tue, 12 Jan 2010 15:03:31 -0300
Subject: Fix stats table to update 2 missing health values by Malcrom.

--HG--
branch : trunk
---
 sql/updates/6980_world_creature_classlevelstats.sql | 2 ++
 sql/world.sql                                       | 4 ++--
 2 files changed, 4 insertions(+), 2 deletions(-)
 create mode 100644 sql/updates/6980_world_creature_classlevelstats.sql

(limited to 'sql')

diff --git a/sql/updates/6980_world_creature_classlevelstats.sql b/sql/updates/6980_world_creature_classlevelstats.sql
new file mode 100644
index 00000000000..76a00828e63
--- /dev/null
+++ b/sql/updates/6980_world_creature_classlevelstats.sql
@@ -0,0 +1,2 @@
+UPDATE `creature_classlevelstats` SET `basehp1`=1 WHERE `class`=1 AND `level` IN (78,79);
+
diff --git a/sql/world.sql b/sql/world.sql
index 57fad9c75f3..b0552ec6646 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -978,8 +978,8 @@ INSERT INTO `creature_classlevelstats` (`class`,`level`,`basehp0`,`basehp1`,`bas
 (1,75,4652,8025,10635,0,8219),
 (1,76,4781,8247,11001,0,8520),
 (1,77,4916,8480,11379,0,8822),
-(1,78,5052,0,11770,0,9124),
-(1,79,5194,0,12175,0,9426),
+(1,78,5052,1,11770,0,9124),
+(1,79,5194,1,12175,0,9426),
 (1,80,5342,9215,12600,0,9729),
 (1,81,5496,1,13033,0,10033),
 (1,82,5647,1,13481,0,10356),
-- 
cgit v1.2.3