From 97166dfb92d7cbdef8731771c38923cc219a4fc3 Mon Sep 17 00:00:00 2001 From: rud0lp20 Date: Tue, 11 Dec 2012 17:20:44 +0000 Subject: 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 --- sql-files/main.sql | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) (limited to 'sql-files/main.sql') 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; -- cgit v1.2.3-60-g2f50