From 5cb119e617195bfe4ddb35ce377201e0d01807fb Mon Sep 17 00:00:00 2001
From: Rat <none@none>
Date: Wed, 27 Oct 2010 21:01:47 +0200
Subject: 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
---
 sql/updates/10320_world_smart_scripts.sql | 32 +++++++++++++++++++++++++++++++
 sql/updates/10320_world_waypoints.sql     | 10 ++++++++++
 2 files changed, 42 insertions(+)
 create mode 100644 sql/updates/10320_world_smart_scripts.sql
 create mode 100644 sql/updates/10320_world_waypoints.sql

(limited to 'sql')

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';
-- 
cgit v1.2.3