diff options
| author | rud0lp20 <rud0lp20@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-12-11 17:20:44 +0000 |
|---|---|---|
| committer | rud0lp20 <rud0lp20@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-12-11 17:20:44 +0000 |
| commit | 97166dfb92d7cbdef8731771c38923cc219a4fc3 (patch) | |
| tree | b757962d8b2ef15de65fd62872f5dcc3a740e4a9 /sql-files | |
| parent | e6376945eb87a94974bfad2a5ca649c9b8d1288f (diff) | |
| download | hercules-97166dfb92d7cbdef8731771c38923cc219a4fc3.tar.gz hercules-97166dfb92d7cbdef8731771c38923cc219a4fc3.tar.bz2 hercules-97166dfb92d7cbdef8731771c38923cc219a4fc3.tar.xz hercules-97166dfb92d7cbdef8731771c38923cc219a4fc3.zip | |
Happy Holidays and Happy 12/12/12 :)
Update Elemental summon to its official behavior
- Fixed missing skill features of Ventus(bugreport:6792,bugreport:6723,bugreport:6511)
- Note: upgrade_svn17014.sql
- And other elemental skills are to follow :)
Fixed bugreport:6889 updated const.txt where it cause error to some items.
Fixed bugreport:6999 where matk damage deals miss atk to plant type targets.
Fixed status calculation where it doesn't give accurate result or how official calculation does.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17014 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 14 | ||||
| -rw-r--r-- | sql-files/upgrades/upgrade_svn17014.sql | 9 |
2 files changed, 17 insertions, 6 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index 3c4a2f2c4..198376017 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -146,12 +146,14 @@ CREATE TABLE IF NOT EXISTS `elemental` ( `sp` int(12) NOT NULL default '1', `max_hp` mediumint(8) unsigned NOT NULL default '0', `max_sp` mediumint(6) unsigned NOT NULL default '0', - `str` smallint(4) unsigned NOT NULL default '0', - `agi` smallint(4) unsigned NOT NULL default '0', - `vit` smallint(4) unsigned NOT NULL default '0', - `int` smallint(4) unsigned NOT NULL default '0', - `dex` smallint(4) unsigned NOT NULL default '0', - `luk` smallint(4) unsigned NOT NULL default '0', + `atk` MEDIUMINT(6) unsigned NOT NULL default '0', + `atk2` MEDIUMINT(6) unsigned NOT NULL default '0', + `matk` MEDIUMINT(6) unsigned NOT NULL default '0', + `aspd` smallint(4) unsigned NOT NULL default '0', + `def` smallint(4) unsigned NOT NULL default '0', + `mdef` smallint(4) unsigned NOT NULL default '0', + `flee` smallint(4) unsigned NOT NULL default '0', + `hit` smallint(4) unsigned NOT NULL default '0', `life_time` int(11) NOT NULL default '0', PRIMARY KEY (`ele_id`) ) ENGINE=MyISAM; diff --git a/sql-files/upgrades/upgrade_svn17014.sql b/sql-files/upgrades/upgrade_svn17014.sql new file mode 100644 index 000000000..68a279aa7 --- /dev/null +++ b/sql-files/upgrades/upgrade_svn17014.sql @@ -0,0 +1,9 @@ +ALTER TABLE `elemental` CHANGE COLUMN `str` `atk1` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT 0, + CHANGE COLUMN `agi` `atk2` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT 0, + CHANGE COLUMN `vit` `matk` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT 0, + CHANGE COLUMN `int` `aspd` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0, + CHANGE COLUMN `dex` `def` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0, + CHANGE COLUMN `luk` `mdef` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0, + CHANGE COLUMN `life_time` `flee` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0, + ADD COLUMN `hit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0 AFTER `flee`, + ADD COLUMN `life_time` INT(11) NOT NULL DEFAULT 0 AFTER `hit`;
\ No newline at end of file |