summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-12-14 23:38:11 +0000
committerultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-12-14 23:38:11 +0000
commit1382b22cd68bf90f2adc4ae13187416982f9a12f (patch)
tree60602ab8f3578407bffbd1859603c3a586c52256 /sql-files
parent78474fe9877675f3fc173f0b7e7235fd6c105067 (diff)
downloadhercules-1382b22cd68bf90f2adc4ae13187416982f9a12f.tar.gz
hercules-1382b22cd68bf90f2adc4ae13187416982f9a12f.tar.bz2
hercules-1382b22cd68bf90f2adc4ae13187416982f9a12f.tar.xz
hercules-1382b22cd68bf90f2adc4ae13187416982f9a12f.zip
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
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/upgrade_svn11914.sql9
1 files changed, 9 insertions, 0 deletions
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`;