From 1382b22cd68bf90f2adc4ae13187416982f9a12f Mon Sep 17 00:00:00 2001
From: ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Fri, 14 Dec 2007 23:38:11 +0000
Subject: Guardian hp handling code removal (see bugreport:342) - removed
 guardian hp from the castle data structure, database, savefiles and various
 script functions (use upgrade_svn11914.sql) - removed guardian hp calculation
 and manipulation from the castle manager npc, now the hp values are updated
 by the server itself (glitch: when castle defense changes, all guardians are
 healed to full) - tweaked script function 'guardianinfo' to provide some data
 needed by the manager npc (currently available are hp, maxhp and visibility);
 also, it doesn't need a player attached to execute anymore The whole thing is
 experimental, use at your own risk (seems to work though...)

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11915 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/upgrade_svn11914.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 sql-files/upgrade_svn11914.sql

(limited to 'sql-files/upgrade_svn11914.sql')

diff --git a/sql-files/upgrade_svn11914.sql b/sql-files/upgrade_svn11914.sql
new file mode 100644
index 000000000..ddf06957d
--- /dev/null
+++ b/sql-files/upgrade_svn11914.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `guild_castle`
+  DROP `gHP0`,
+  DROP `gHP1`,
+  DROP `gHP2`,
+  DROP `gHP3`,
+  DROP `gHP4`,
+  DROP `gHP5`,
+  DROP `gHP6`,
+  DROP `gHP7`;
-- 
cgit v1.2.3-70-g09d2

