From d4887311e39527e036419ebd966f399fdbdae67a Mon Sep 17 00:00:00 2001 From: Traesh Date: Sun, 25 Sep 2016 16:13:12 +0200 Subject: Core/Scenes: Implemented scene system Closes #17858 Closes #17976 --- src/server/database/Database/Implementation/HotfixDatabase.cpp | 6 ++++++ src/server/database/Database/Implementation/HotfixDatabase.h | 4 ++++ 2 files changed, 10 insertions(+) (limited to 'src/server/database/Database') diff --git a/src/server/database/Database/Implementation/HotfixDatabase.cpp b/src/server/database/Database/Implementation/HotfixDatabase.cpp index 5ecd9c17357..60197392569 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.cpp +++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp @@ -687,6 +687,12 @@ void HotfixDatabaseConnection::DoPrepareStatements() PrepareStatement(HOTFIX_SEL_SCALING_STAT_DISTRIBUTION, "SELECT ID, ItemLevelCurveID, MinLevel, MaxLevel FROM scaling_stat_distribution" " ORDER BY ID DESC", CONNECTION_SYNCH); + // SceneScript.db2 + PrepareStatement(HOTFIX_SEL_SCENE_SCRIPT, "SELECT ID, Name, Script, PrevScriptId, NextScriptId FROM scene_script ORDER BY ID DESC", CONNECTION_SYNCH); + + // SceneScriptPackage.db2 + PrepareStatement(HOTFIX_SEL_SCENE_SCRIPT_PACKAGE, "SELECT ID, Name FROM scene_script_package ORDER BY ID DESC", CONNECTION_SYNCH); + // SkillLine.db2 PrepareStatement(HOTFIX_SEL_SKILL_LINE, "SELECT ID, DisplayName, Description, AlternateVerb, SpellIconID, Flags, CategoryID, CanLink, " "ParentSkillLineID FROM skill_line ORDER BY ID DESC", CONNECTION_SYNCH); diff --git a/src/server/database/Database/Implementation/HotfixDatabase.h b/src/server/database/Database/Implementation/HotfixDatabase.h index 57c1512eca5..eafc14e07e3 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.h +++ b/src/server/database/Database/Implementation/HotfixDatabase.h @@ -372,6 +372,10 @@ enum HotfixDatabaseStatements HOTFIX_SEL_SCALING_STAT_DISTRIBUTION, + HOTFIX_SEL_SCENE_SCRIPT, + + HOTFIX_SEL_SCENE_SCRIPT_PACKAGE, + HOTFIX_SEL_SKILL_LINE, HOTFIX_SEL_SKILL_LINE_LOCALE, -- cgit v1.2.3