diff options
| author | Rat <none@none> | 2010-10-27 21:01:47 +0200 |
|---|---|---|
| committer | Rat <none@none> | 2010-10-27 21:01:47 +0200 |
| commit | 5cb119e617195bfe4ddb35ce377201e0d01807fb (patch) | |
| tree | aa8a528ec76b9b28081714dbdb769ccbdfa22556 /sql | |
| parent | c9fba03da9b095ee1b76329af4db90ce18b31598 (diff) | |
Core/AI: implemented SmartScripts System (still beta) not 100% complete
WARNING: Use scripts at own risk. You were warned.
NOTE0: creature, gameobject, areatrigger type scripts should be fully functional
NOTE1: has no effect on any core related stuff if not using any SmartScript
NOTE2: all event/action/etc descriptions can be found in SmartScriptMgr.h
SmartScripts is a reloadable DB-Sript system, with full control for special scripting,
like escorting, following, complex combat handling, pre-stored AI templates(caster, turret, etc) and much more
with a total of 66 events, 78 actions, 22 target types, and can be easily extended
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/10320_world_smart_scripts.sql | 32 | ||||
| -rw-r--r-- | sql/updates/10320_world_waypoints.sql | 10 |
2 files changed, 42 insertions, 0 deletions
diff --git a/sql/updates/10320_world_smart_scripts.sql b/sql/updates/10320_world_smart_scripts.sql new file mode 100644 index 00000000000..99fdaf747a0 --- /dev/null +++ b/sql/updates/10320_world_smart_scripts.sql @@ -0,0 +1,32 @@ +DROP TABLE IF EXISTS smart_scripts; +CREATE TABLE `smart_scripts` ( + `entryorguid` mediumint(11) NOT NULL, + `source_type` mediumint(5) unsigned NOT NULL DEFAULT '0', + `id` mediumint(11) unsigned NOT NULL DEFAULT '0', + `link` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_type` mediumint(5) unsigned NOT NULL DEFAULT '0', + `event_phase_mask` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_chance` mediumint(5) unsigned NOT NULL DEFAULT '100', + `event_flags` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_param1` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_param2` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_param3` mediumint(11) unsigned NOT NULL DEFAULT '0', + `event_param4` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_type` mediumint(5) unsigned NOT NULL DEFAULT '0', + `action_param1` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_param2` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_param3` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_param4` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_param5` mediumint(11) unsigned NOT NULL DEFAULT '0', + `action_param6` mediumint(11) unsigned NOT NULL DEFAULT '0', + `target_type` mediumint(11) unsigned NOT NULL DEFAULT '0', + `target_param1` mediumint(11) unsigned NOT NULL DEFAULT '0', + `target_param2` mediumint(11) unsigned NOT NULL DEFAULT '0', + `target_param3` mediumint(11) unsigned NOT NULL DEFAULT '0', + `target_x` float NOT NULL DEFAULT '0', + `target_y` float NOT NULL DEFAULT '0', + `target_z` float NOT NULL DEFAULT '0', + `target_o` float NOT NULL DEFAULT '0', + `comment` varchar(255) NOT NULL DEFAULT '' COMMENT 'Event Comment', + PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; diff --git a/sql/updates/10320_world_waypoints.sql b/sql/updates/10320_world_waypoints.sql new file mode 100644 index 00000000000..6fc27aa9d9c --- /dev/null +++ b/sql/updates/10320_world_waypoints.sql @@ -0,0 +1,10 @@ +DROP TABLE IF EXISTS waypoints; +CREATE TABLE `waypoints` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `pointid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `position_x` float NOT NULL DEFAULT '0', + `position_y` float NOT NULL DEFAULT '0', + `position_z` float NOT NULL DEFAULT '0', + `point_comment` text, + PRIMARY KEY (`entry`,`pointid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature waypoints'; |