Project
DOL Server
Forum
I worked on translations for spell related messages and spell info.
There is a new table "languagespell" to translate name, target, description and message1 to message4.
Also added: Translation of player starts to cast and has finished casting a spell.
Attention: Because of mob name translation I also changed LanguageMgr condition regarding language == DefaultLanguage. I have both set to "DE", so there is no translation --> changed it to language == "EN": Then the object will not be translated if language is "EN" (will be taken from DB), and will be translated if not "EN" (hope you understand, maybe I've done it wrong when trying to do some translations).
This one you need for translation of castign start and casting end:
- Code: Select all
INSERT INTO `languagesystem` (`Text`, `TranslationId`, `Language`, `Tag`, `LastTimeRowUpdated`, `LanguageSystem_ID`) VALUES ('{0} spricht einen Zauber!', 'SpellHandler.CastingEndRoaming', 'DE', NULL, '2017-11-04 00:00:00', 'SpellHandler.CastingEndRoaming_de');
INSERT INTO `languagesystem` (`Text`, `TranslationId`, `Language`, `Tag`, `LastTimeRowUpdated`, `LanguageSystem_ID`) VALUES ('{0} casts a spell!', 'SpellHandler.CastingEndRoaming', 'EN', NULL, '2017-11-04 00:00:00', 'SpellHandler.CastingEndRoaming_en');
INSERT INTO `languagesystem` (`Text`, `TranslationId`, `Language`, `Tag`, `LastTimeRowUpdated`, `LanguageSystem_ID`) VALUES ('Ihr sprecht den Zauber {0}!', 'SpellHandler.CastingEnd', 'DE', NULL, '2017-11-04 00:00:00', 'SpellHandler.CastingEnd_de');
INSERT INTO `languagesystem` (`Text`, `TranslationId`, `Language`, `Tag`, `LastTimeRowUpdated`, `LanguageSystem_ID`) VALUES ('You cast a {0} spell!', 'SpellHandler.CastingEnd', 'EN', NULL, '2017-11-04 00:00:00', 'SpellHandler.CastingEnd_en');
INSERT INTO `languagesystem` (`Text`, `TranslationId`, `Language`, `Tag`, `LastTimeRowUpdated`, `LanguageSystem_ID`) VALUES ('You begin casting a {0} spell!', 'SpellHandler.CastingStart', 'EN', NULL, '2017-11-04 00:00:00', 'SpellHandler.CastingStart_en');
INSERT INTO `languagesystem` (`Text`, `TranslationId`, `Language`, `Tag`, `LastTimeRowUpdated`, `LanguageSystem_ID`) VALUES ('Ihr beginnt {0} zu spielen!', 'SpellHandler.PlayingStart', 'DE', NULL, '2017-11-04 00:00:00', 'SpellHandler.PlayingStart_de');
INSERT INTO `languagesystem` (`Text`, `TranslationId`, `Language`, `Tag`, `LastTimeRowUpdated`, `LanguageSystem_ID`) VALUES ('You begin playing {0}!', 'SpellHandler.PlayingStart', 'EN', NULL, '2017-11-04 00:00:00', 'SpellHandler.PlayingStart_en');
INSERT INTO `languagesystem` (`Text`, `TranslationId`, `Language`, `Tag`, `LastTimeRowUpdated`, `LanguageSystem_ID`) VALUES ('Ihr beginnt den Zauber {0} zu sprechen!', 'SpellHandler.CastingStart', 'DE', NULL, '2017-11-04 00:00:00', 'SpellHandler_CastingStart_de');
- Code: Select all
USE `dol`;
CREATE TABLE IF NOT EXISTS `languagespell` (
`LanguageSpell_ID` varchar(255) NOT NULL,
`TranslationId` varchar(255) NOT NULL,
`Language` varchar(255) NOT NULL,
`Tag` mediumtext,
`Name` mediumtext,
`Description` mediumtext,
`Target` mediumtext,
`Message1` mediumtext,
`Message2` mediumtext,
`Message3` mediumtext,
`Message4` mediumtext,
`LastTimeRowUpdated` datetime NOT NULL,
PRIMARY KEY (`LanguageSpell_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Insert ignore into languagespell (LanguageSpell_ID, TranslationId, `Language`, Tag, Name, Description, Target, Message1, Message2, Message3, Message4, LastTimeRowUpdated) (select CONCAT(spell.SpellID, "_en"), spell.SpellID, "EN", spell.Name, spell.Name, spell.Description, spell.Target, spell.Message1, spell.Message2, spell.Message3, spell.Message4, CURRENT_DATE() from spell);
Insert ignore into languagespell (LanguageSpell_ID, TranslationId, `Language`, Tag, Name, Description, Target, Message1, Message2, Message3, Message4, LastTimeRowUpdated) (select CONCAT(spell.SpellID, "_de"), spell.SpellID, "DE", spell.Name, spell.Name, spell.Description, spell.Target, spell.Message1, spell.Message2, spell.Message3, spell.Message4, CURRENT_DATE() from spell);
Insert ignore into languagespell (LanguageSpell_ID, TranslationId, `Language`, Tag, Name, Description, Target, Message1, Message2, Message3, Message4, LastTimeRowUpdated) (select CONCAT(spell.SpellID, "_fr"), spell.SpellID, "FR", spell.Name, spell.Name, spell.Description, spell.Target, spell.Message1, spell.Message2, spell.Message3, spell.Message4, CURRENT_DATE() from spell);
/* Updates for german language */
/* Target */
update languagespell set Target = "Selbst" where Target = "Self" and `Language` = "DE";
update languagespell set Target = "Reich" where Target = "Realm" and `Language` = "DE";
update languagespell set Target = "Feind" where Target = "Enemy" and `Language` = "DE";
update languagespell set Target = "Gebiet" where Target = "Area" and `Language` = "DE";
update languagespell set Target = "Kegel" where Target = "cone" and `Language` = "DE";
update languagespell set Target = "Leichnam" where Target = "corpse" and `Language` = "DE";
update languagespell set Target = "Gruppe" where Target = "Group" and `Language` = "DE";
update languagespell set Target = "Begleiter" where Target = "Pet" and `Language` = "DE";
/* Message 1 */
update languagespell set Message1 = "Ihr werdet von einem Kraftfeld geschützt." where Message1 = "A power shield covers you." and `Language` = "DE";
update languagespell set Message1 = "Ihr werdet von einem Kristallschild geschützt." where Message1 = "A crystal shield covers you." and `Language` = "DE";
update languagespell set Message1 = "Ihr seid von einem Schild umgeben." where Message1 = "A shield surrounds you." and `Language` = "DE";
update languagespell set Message1 = "Ihr wurdet mit einem schwächenden Effekt belegt!" where Message1 = "A weakening effect has been placed on you!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid von einer Säurewolke umgeben!" where Message1 = "An acidic cloud surrounds you!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid infiziert worden!" where Message1 = "An infection affects you!" and `Language` = "DE";
update languagespell set Message1 = "Eure Waffe ist von gefährlicher Energie umgeben!" where Message1 = "Dangerous energy surrounds your weapon!" and `Language` = "DE";
update languagespell set Message1 = "Ihr bewegt Euch lagsamer!" where Message1 = "You are begins moving more slowly!" and `Language` = "DE";
update languagespell set Message1 = "Ihr werdet von einer unsichtbaren Kraft zermalmt!" where Message1 = "You are being crushed by an invisible force!" and `Language` = "DE";
update languagespell set Message1 = "Ihr werdet von einer nahezu unüberwindbaren Macht beschützt!" where Message1 = "You are being protected by a near impregnable force!" and `Language` = "DE";
update languagespell set Message1 = "Ihr blutet!" where Message1 = "You are bleeding!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid mit zusätzlichen Schutz gesegnet!" where Message1 = "You are blessed with extra protection." and `Language` = "DE";
update languagespell set Message1 = "Ihr seid mit Lava überdeckt!" where Message1 = "You are covered in lava!" and `Language` = "DE";
update languagespell set Message1 = "Ihr wurdet mit einer knorrigen Wurzel umhüllt!" where Message1 = "You are enveloped by a gnarled root!" and `Language` = "DE";
update languagespell set Message1 = "Ihr wurdet mit sengender Hitze umhüllt!" where Message1 = "You are enveloped by a searing heat!" and `Language` = "DE";
update languagespell set Message1 = "Ihr wurdet mit einem unsichtbaren Geist umhüllt!" where Message1 = "You are enveloped by an invisible spirit!" and `Language` = "DE";
update languagespell set Message1 = "Ihr wurdet mit betäubender Kälte umhüllt!" where Message1 = "You are enveloped by numbing cold!" and `Language` = "DE";
update languagespell set Message1 = "Ihr wurdet mit einer schmutzigen Wolke umhüllt!" where Message1 = "You are enveloped in a cloud of dirt!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid eingefroren!" where Message1 = "You are frozen!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid hypnotisiert!" where Message1 = "You are mesmerized." and `Language` = "DE";
update languagespell set Message1 = "Ihr seid hypnotisiert!" where Message1 = "You are Mezmerized." and `Language` = "DE";
update languagespell set Message1 = "Ihr seid hypnotisiert!" where Message1 = "You are entranced!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid zusätzlich geschützt!" where Message1 = "You are more protected!" and `Language` = "DE";
update languagespell set Message1 = "Ihr verwendet nun stumpfe Pfeile." where Message1 = "You are now using blunt arrows" and `Language` = "DE";
update languagespell set Message1 = "Ihr verwendet nun scharfe Pfeile." where Message1 = "You are now using slashing arrows" and `Language` = "DE";
update languagespell set Message1 = "Ihr verwendet nun spitze Pfeile." where Message1 = "You are now using thrusting arrows" and `Language` = "DE";
update languagespell set Message1 = "Ihr wurdet vergiftet und festgehalten!" where Message1 = "You are poisoned and snared!" and `Language` = "DE";
update languagespell set Message1 = "Ihr wurdet vergiftet!" where Message1 = "You are poisoned!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid von einer defensiven Aura geschützt!" where Message1 = "You are protected by a defensive aura!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid vor Körpermagie geschützt!" where Message1 = "You are protected from body magic!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid vor Kälte geschützt!" where Message1 = "You are protected from cold!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid vor Energie geschützt!" where Message1 = "You are protected from energy!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid vor Hitze geschützt!" where Message1 = "You are protected from heat!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid vor Materiemagie geschützt!" where Message1 = "You are protected from matter magic!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid vor Geistmagie geschützt!" where Message1 = "You are protected from spirtual magic!" and `Language` = "DE";
update languagespell set Message1 = "Ihr empfangt {0}!" where Message1 = "You are reviving {0}!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid von einer heiligen Aura umgeben!" where Message1 = "You are surrounded by a holy aura." and `Language` = "DE";
update languagespell set Message1 = "Ihr seid von einer schützenden Aura umgeben!" where Message1 = "You are surrounded by a protective aura!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seid von einem Schild aus magischer Energie umgeben!" where Message1 = "You are surrounded by a shield of magical energy." and `Language` = "DE";
update languagespell set Message1 = "Ihr seid von Schmerzen geplagt!" where Message1 = "You are wracked with pain!" and `Language` = "DE";
update languagespell set Message1 = "Ihr greift schnell wie der Wind an!" where Message1 = "You attacks move with the speed of the wind!" and `Language` = "DE";
update languagespell set Message1 = "Ihr werdet gegen Schlagschaden resistenter!" where Message1 = "You become more resistant to crushing damage!" and `Language` = "DE";
update languagespell set Message1 = "Ihr werdet gegen Schnittschaden resistenter!" where Message1 = "You become more resistant to slashing damage!" and `Language` = "DE";
update languagespell set Message1 = "Ihr werdet gegen Stoßschaden resistenter!" where Message1 = "You become more resistant to thrust damage!" and `Language` = "DE";
update languagespell set Message1 = "Ihr könnt Euch nicht bewegen!" where Message1 = "You cannot move!" and `Language` = "DE";
update languagespell set Message1 = "Ihr schreit vor Angst, als Euch die Lebenskraft entzogen wird!" where Message1 = "You cry out in horror as you feel your lifeforce being drained!" and `Language` = "DE";
update languagespell set Message1 = "Ihr könnt besonders geschickt ausweichen!" where Message1 = "You evade with extra skill!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Gelassenheit über Euch kommen." where Message1 = "You feel a calmness come over you." and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt, wie Eure Rüstung zerbrechlich wird!" where Message1 = "You feel as though your armor has become paper thin!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch gelassen und gesund." where Message1 = "You feel calm and healthy." and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch gestärkt!" where Message1 = "You feel invigorated!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch ruhiger." where Message1 = "You feel more at ease." and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch geschickter!" where Message1 = "You feel more dextrous!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch gesünder!" where Message1 = "You feel more healthy!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch gegenüber Kälte empfindlicher!" where Message1 = "You feel more vulnerable to cold!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch gegenüber Energie empfindlicher!" where Message1 = "You feel more vulnerable to energy!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch gegenüber Hitze empfindlicher!" where Message1 = "You feel more vulnerable to heat!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch gegenüber Materiemagie empfindlicher!" where Message1 = "You feel more vulnerable to matter magic!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch gegenüber Magie empfindlicher!" where Message1 = "You feel more vulnerable to physical magic!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch gegenüber Geistmagie empfindlicher!" where Message1 = "You feel more vulnerable to spirit magic!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch erfrischt!" where Message1 = "You feel refreshed!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch schlauer!" where Message1 = "You feel smarter." and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch stärker und gesünder!" where Message1 = "You feel stronger and healthier!" and `Language` = "DE";
update languagespell set Message1 = "Ihr fühlt Euch stärker!" where Message1 = "You feel stronger!" and `Language` = "DE";
update languagespell set Message1 = "Ihr sammelt eine handvoll Schmutz!" where Message1 = "You gather a handful of dirt!" and `Language` = "DE";
update languagespell set Message1 = "Ihr seht gesünder aus!" where Message1 = "You look more healthy!" and `Language` = "DE";
update languagespell set Message1 = "Ihr könnt besonders geschickt parieren!" where Message1 = "You parry with extra skill!" and `Language` = "DE";
update languagespell set Message1 = "Ihr stürzt den fischigen Trank herunter und spürt, daß Ihr schneller schwimmen und Wasser wie Luft atmen könnt!" where Message1 = "You quaff the fishy tasting potion and find yourself able to move freely and breathe water like air!" and `Language` = "DE";
update languagespell set Message1 = "Ihr ruft einen Söldner herbei." where Message1 = "You summon a mercenary." and `Language` = "DE";
update languagespell set Message1 = "Ihr ruft eine Belagerungsramme herbei." where Message1 = "You summon a siege ram." and `Language` = "DE";
update languagespell set Message1 = "Ihr ruft ein Belagerungstrebuchet herbei." where Message1 = "You summon a siege trebuchet." and `Language` = "DE";
update languagespell set Message1 = "Ihr schwingt Eure Waffe mit Inbrunst!" where Message1 = "You swing your weapon with zeal!" and `Language` = "DE";
update languagespell set Message1 = "Ihr nutzt Eure zweite Luft!" where Message1 = "You take a second wind!" and `Language` = "DE";
update languagespell set Message1 = "Ihr werft einen Schneeball!" where Message1 = "You throw a snowball!" and `Language` = "DE";
update languagespell set Message1 = "Ihr nutzt Eure Macht!" where Message1 = "You use your power !." and `Language` = "DE";
update languagespell set Message1 = "Ihr wurdet von einem Schneeball getroffen!" where Message1 = "You've been hit with a snowball!" and `Language` = "DE";
update languagespell set Message1 = "Euch wurde die Macht der dunklen Mächte gewährt." where Message1 = "Your are granted power by dark forces." and `Language` = "DE";
update languagespell set Message1 = "Eure Rüstung wird zum berühren zu heiß." where Message1 = "Your armor becomes too hot to touch." and `Language` = "DE";
update languagespell set Message1 = "Eure Angriffsgeschwindigkeit wurde verringert." where Message1 = "Your attack speed has decreased." and `Language` = "DE";
update languagespell set Message1 = "Eure Angriffsgeschwindigkeit wurde erhöht." where Message1 = "Your attack speed increases." and `Language` = "DE";
update languagespell set Message1 = "Eure Angriffsgeschwindigkeit wird durch eine unsichtbare Macht verringert!" where Message1 = "Your attacks are being slowed by an invisible force!" and `Language` = "DE";
update languagespell set Message1 = "Ihr greift mit aller Grausamkeit an!" where Message1 = "Your attacks gain a ferocious edge!" and `Language` = "DE";
update languagespell set Message1 = "Ihr greift schnell wie der Wind an!" where Message1 = "Your attacks move with the speed of the wind!" and `Language` = "DE";
update languagespell set Message1 = "Eure Klinge schlägt genauer zu!" where Message1 = "Your blade strikes more accurately!" and `Language` = "DE";
update languagespell set Message1 = "Eure Zauber können nun Leben von Euren Feinden stehlen!" where Message1 = "Your blows can now steal the life from your foes!" and `Language` = "DE";
update languagespell set Message1 = "Eure Effektivität hat sich erhöht." where Message1 = "Your effectiveness has increased." and `Language` = "DE";
update languagespell set Message1 = "Eure Ausdauer wurde verringert!" where Message1 = "Your endurance has been drained." and `Language` = "DE";
update languagespell set Message1 = "Eure Füße sind am Boden festgefroren!" where Message1 = "Your feet are frozen to the ground!" and `Language` = "DE";
update languagespell set Message1 = "Eure Nahkampfresistenz hat sich verringert!" where Message1 = "Your melee resistance has decreased!" and `Language` = "DE";
update languagespell set Message1 = "Eure Nahkampfresistenz hat sich erhöht!" where Message1 = "Your melee resistance has increased." and `Language` = "DE";
update languagespell set Message1 = "Euch überkommt Herzlichkeit!" where Message1 = "Your overcome with warmth!" and `Language` = "DE";
update languagespell set Message1 = "Eure Haut bricht zu offenen Wunden auf!" where Message1 = "Your skin erupts in open wounds!" and `Language` = "DE";
update languagespell set Message1 = "Eure Haut wird härter." where Message1 = "Your skin hardens." and `Language` = "DE";
update languagespell set Message1 = "Eure Waffe kanalisiert die Kraft der Erde." where Message1 = "Your weapon begins channeling the strength of the earth." and `Language` = "DE";
update languagespell set Message1 = "Eure Waffe knistert vor Elektrizität!" where Message1 = "Your weapon crackles with electricity!" and `Language` = "DE";
update languagespell set Message1 = "Eure Waffe ist von den Göttern gesegnet!" where Message1 = "Your weapon is blessed by the gods!" and `Language` = "DE";
update languagespell set Message1 = "Eure Waffe ist von den Himmeln gesegnet!" where Message1 = "Your weapon is blessed by the heavens!" and `Language` = "DE";
update languagespell set Message1 = "Eure Waffe wurde mit magischer Kraft verzaubert!" where Message1 = "Your weapon is enchanted with magical power!" and `Language` = "DE";
update languagespell set Message1 = "Eure Waffe wurde für zusätzlichen Schaden mit einer Rune verziert." where Message1 = "Your weapon is inscribed with a rune to inflict more damage." and `Language` = "DE";
update languagespell set Message1 = "Eure Waffe ist leichter!" where Message1 = "Your weapon looses it's weight!" and `Language` = "DE";
/* Message 2 */
update languagespell set Message2 = "{0} Haut wird von einem Kristallschild geschützt." where Message2 = "A crystal shield covers {0}'s skin." and `Language` = "DE";
update languagespell set Message2 = "{0} Haut wird von einem Kraftfeld geschützt." where Message2 = "A power shield covers {0}'s skin." and `Language` = "DE";
update languagespell set Message2 = "{0} ist in einem geschwächten Zustand!" where Message2 = "{0} is in a weakened state!" and `Language` = "DE";
update languagespell set Message2 = "{0} ist von einer Säurewolke umgeben!" where Message2 = "{0} is surrounded by an acidic cloud!" and `Language` = "DE";
update languagespell set Message2 = "{0} wurde infiziert!" where Message2 = "An infection affects {0}!" and `Language` = "DE";
update languagespell set Message2 = "{0}s Waffe ist von gefährlicher Energie umgeben!" where Message2 = "{0}'s weapon is surrounded by dangerous energy!" and `Language` = "DE";
update languagespell set Message2 = "{0} bewegt sich langsamer!" where Message2 = "{0} begins moving more slowly!" and `Language` = "DE";
update languagespell set Message2 = "{0} wird von einer unsichtbaren Kraft zermalmt!" where Message2 = "{0} is being crushed by an invisible force!" and `Language` = "DE";
update languagespell set Message2 = "{0} wird von einer nahezu unüberwindbaren Macht beschützt!" where Message2 = "{0} is being protected by a near impregnable force!" and `Language` = "DE";
update languagespell set Message2 = "{0} blutet!" where Message2 = "{0} is bleeding!" and `Language` = "DE";
update languagespell set Message2 = "{0} ist mit heiligem Schutz gesegnet!" where Message2 = "{0} is blessed with holy protection." and `Language` = "DE";
update languagespell set Message2 = "{0} ist mit Lava überdeckt!" where Message2 = "{0} is covered in lava!" and `Language` = "DE";
update languagespell set Message2 = "{0} wurde mit betäubender Kälte umhüllt!" where Message2 = "{0} is enveloped by numbing cold!" and `Language` = "DE";
update languagespell set Message2 = "{0} wurde mit einer schmutzigen Wolke umhüllt!" where Message2 = "{0} is enveloped in a cloud of dirt!" and `Language` = "DE";
update languagespell set Message2 = "{0} ist eingefroren!" where Message2 = "Time slows around {0}'s body!" and `Language` = "DE";
update languagespell set Message2 = "{0} ist hypnotisiert!" where Message2 = "{0} is entranced." and `Language` = "DE";
update languagespell set Message2 = "{0} kann sich scheinbar nicht bewegen!" where Message2 = "{0} cannot seem to move!" and `Language` = "DE";
update languagespell set Message2 = "{0} wurde vergiftet und festgehalten!" where Message2 = "{0} is poisoned and snared!" and `Language` = "DE";
update languagespell set Message2 = "{0} wurde vergiftet!" where Message2 = "{0} has been poisoned!" and `Language` = "DE";
update languagespell set Message2 = "{0} wurde vergiftet!" where Message2 = "{0} is poisoned!" and `Language` = "DE";
update languagespell set Message2 = "{0} ist von einer heiligen Aura umgeben!" where Message2 = "{0} is surrounded by a holy aura." and `Language` = "DE";
update languagespell set Message2 = "{0} ist von einem Schild aus magischer Energie umgeben!" where Message2 = "{0} is surrounded by a shield of magical energy." and `Language` = "DE";
update languagespell set Message2 = "{0}s Haut wird härter." where Message2 = "{0}'s skin hardens." and `Language` = "DE";
update languagespell set Message2 = "{0} wird von Schmerzen geplagt!" where Message2 = "{0} is wracked with pain!" and `Language` = "DE";
update languagespell set Message2 = "{0} greift schnell wie der Wind an!" where Message2 = "{0} attacks move with the speed of the wind!" and `Language` = "DE";
update languagespell set Message2 = "{0} ist von einem Blitzlicht betäubt!" where Message2 = "{0} is stunned by a flash of light!" and `Language` = "DE";
update languagespell set Message2 = "{0} schreit vor Angst, als die Lebenskraft entzogen wird!" where Message2 = "{0} cries out in horror as their lifeforce is drained!" and `Language` = "DE";
update languagespell set Message2 = "{0} sieht ruhiger aus." where Message2 = "{0} looks calmer." and `Language` = "DE";
update languagespell set Message2 = "{0} Rüstung sieht schwach und zerbrechlich aus!" where Message2 = "{0}'s armor looks weak and brittle!" and `Language` = "DE";
update languagespell set Message2 = "{0} fühlt sich gelassen und gesund." where Message2 = "{0} seems calm and healthy." and `Language` = "DE";
update languagespell set Message2 = "{0} sieht geschickter aus." where Message2 = "{0} looks more agile!" and `Language` = "DE";
update languagespell set Message2 = "{0} sieht gesünder aus." where Message2 = "{0} looks more healthy!" and `Language` = "DE";
update languagespell set Message2 = "{0} scheint gegenüber Kälte empfindlicher zu sein!" where Message2 = "{0} seems vulnerable to cold!" and `Language` = "DE";
update languagespell set Message2 = "{0} scheint gegenüber Energie empfindlicher zu sein!" where Message2 = "{0} seems vulnerable to energy!" and `Language` = "DE";
update languagespell set Message2 = "{0} scheint gegenüber Hitze empfindlicher zu sein!" where Message2 = "{0} seems vulnerable to heat!" and `Language` = "DE";
update languagespell set Message2 = "{0} scheint gegenüber Materiemagie empfindlicher zu sein!" where Message2 = "{0} seems vulnerable to matter magic!" and `Language` = "DE";
update languagespell set Message2 = "{0} scheint gegenüber Magie empfindlicher zu sein!" where Message2 = "{0} seems vulnerable to physical magic!" and `Language` = "DE";
update languagespell set Message2 = "{0} scheint gegenüber Geistmagie empfindlicher zu sein!" where Message2 = "{0} seems vulnerable to spirit magic!" and `Language` = "DE";
update languagespell set Message2 = "{0} fühlt sich erfrischt!" where Message2 = "{0} feels refreshed!" and `Language` = "DE";
update languagespell set Message2 = "{0} sieht schlauer aus!" where Message2 = "{0} looks smarter." and `Language` = "DE";
update languagespell set Message2 = "{0} sieht stärker und gesünder aus!" where Message2 = "{0} looks stronger and healthier!" and `Language` = "DE";
update languagespell set Message2 = "{0} fühlt sich stärker!" where Message2 = "{0} feels stronger!" and `Language` = "DE";
update languagespell set Message2 = "{0} sieht gesünder aus!" where Message2 = "{0} looks more healthy!" and `Language` = "DE";
update languagespell set Message2 = "{0} ruft einen Söldner herbei." where Message2 = "{0} summons a mercenary." and `Language` = "DE";
update languagespell set Message2 = "{0} ruft eine Belagerungsramme herbei." where Message2 = "{0} summons a siege ram." and `Language` = "DE";
update languagespell set Message2 = "{0} ruft ein Belagerungstrebuchet herbei." where Message2 = "{0} summons a siege trebuchet." and `Language` = "DE";
update languagespell set Message2 = "{0} nutzt seine zweite Luft!" where Message2 = "{0} takes a second wind!" and `Language` = "DE";
update languagespell set Message2 = "{0} wirft einen Schneeball!" where Message2 = "{0} throws a snowball!" and `Language` = "DE";
update languagespell set Message2 = "{0} wurde von einem Schneeball getroffen!" where Message2 = "{0} has been hit with a snowball!" and `Language` = "DE";
update languagespell set Message2 = "{0} Rüstung wird zum berühren zu heiß." where Message2 = "{0}'s armor becomes too hot to touch." and `Language` = "DE";
update languagespell set Message2 = "{0} Angriffsgeschwindigkeit wurde verringert." where Message2 = "{0} attack speed has decreased!" and `Language` = "DE";
update languagespell set Message2 = "{0} kann nicht mehr so schnell angreifen!" where Message2 = "{0} can't attack as fast as normal !" and `Language` = "DE";
update languagespell set Message2 = "{0} greift mit aller Grausamkeit an!" where Message2 = "{0}'s attacks gain a ferocious edge!" and `Language` = "DE";
update languagespell set Message2 = "{0}s Klinge schlägt genauer zu!" where Message2 = "{0}'s blade strikes more accurately!" and `Language` = "DE";
update languagespell set Message2 = "{0}s Effektivität hat sich erhöht." where Message2 = "{0} effectiveness has increased." and `Language` = "DE";
update languagespell set Message2 = "{0}s verliert Ausdauer!" where Message2 = "{0} loose endurance!" and `Language` = "DE";
update languagespell set Message2 = "{0}s Füße sind am Boden festgefroren!" where Message2 = "{0}'s feet are frozen to the ground!" and `Language` = "DE";
update languagespell set Message2 = "{0}s Nahkampfresistenz hat sich verringert!" where Message2 = "{0} melee resistance has decreased!" and `Language` = "DE";
update languagespell set Message2 = "{0}s Nahkampfresistenz hat sich erhöht!" where Message2 = "{0} melee resistance has increased." and `Language` = "DE";
update languagespell set Message2 = "{0} fühlt sich geliebt!" where Message2 = "{0} feels loved!" and `Language` = "DE";
update languagespell set Message2 = "{0}s Haut bricht zu offenen Wunden auf!" where Message2 = "{0}'s skin erupts in open wounds!" and `Language` = "DE";
update languagespell set Message2 = "{0}s Haut wird härter." where Message2 = "{0}'s skin hardens." and `Language` = "DE";
update languagespell set Message2 = "{0}s Waffe kanalisiert die Kraft der Erde." where Message2 = "{0}'s weapon begins channeling the strength of the earth." and `Language` = "DE";
update languagespell set Message2 = "{0}s Waffe knistert vor Elektrizität!" where Message2 = "{0}'s weapon crackles with electricity!" and `Language` = "DE";
update languagespell set Message2 = "{0}s Waffe leuchtet durch die Kraft der Götter!" where Message2 = "{0}'s weapon glows with the power of the gods!" and `Language` = "DE";
update languagespell set Message2 = "{0}s Waffe ist von den Himmeln gesegnet!" where Message2 = "{0}'s weapon is blessed by the heavens!" and `Language` = "DE";
update languagespell set Message2 = "{0}s Waffe wurde verzaubert!" where Message2 = "{0}'s weapon is enchanted." and `Language` = "DE";
update languagespell set Message2 = "{0}s Waffe wurde für zusätzlichen Schaden mit einer Rune verziert." where Message2 = "{0}'s weapon is inscribed with a rune to inflict more damage." and `Language` = "DE";
/* Message 3 */
update languagespell set Message3 = "Euer Kristallschild verblasst." where Message3 = "Your crystal shield fades." and `Language` = "DE";
update languagespell set Message3 = "Euer Kraftfeld verblasst." where Message3 = "Your power shield fades." and `Language` = "DE";
update languagespell set Message3 = "Der schwächende Effekt um Euch verschwindet." where Message3 = "The weakening effect around you dissipates." and `Language` = "DE";
update languagespell set Message3 = "Die Säurewolke um Euch verschwindet." where Message3 = "The acidic mist around you dissipates." and `Language` = "DE";
update languagespell set Message3 = "Die Säurewolke um Euch verschwindet." where Message3 = "The acidic cloud around you dissipates." and `Language` = "DE";
update languagespell set Message3 = "Eure Infektion hat sich aufgelöst." where Message3 = "Your infection clears up." and `Language` = "DE";
update languagespell set Message3 = "Eure Waffe ist wieder normal." where Message3 = "Your weapon returns to normal." and `Language` = "DE";
update languagespell set Message3 = "Die zerstörerische Energie um Euch schwindet." where Message3 = "The destructive energy around you fades." and `Language` = "DE";
update languagespell set Message3 = "Die nahezu unüberwindbare Macht um Euch schwindet." where Message3 = "The near impregnable force around you fades." and `Language` = "DE";
update languagespell set Message3 = "Die Lava fällt von Eurer Haut ab." where Message3 = "The lava falls from your skin." and `Language` = "DE";
update languagespell set Message3 = "Die schmutzige Wolke um Euch verschwindet." where Message3 = "The cloud of dirt around you dissipates." and `Language` = "DE";
update languagespell set Message3 = "Euer zusätzlicher Schutz schwindet." where Message3 = "Your extra protection fades." and `Language` = "DE";
update languagespell set Message3 = "Ihr seht wieder gesund aus." where Message3 = "You look healthy again." and `Language` = "DE";
update languagespell set Message3 = "Euer zusätzlicher Schutz vor Körpermagie schwindet." where Message3 = "Your extra protection against body magic fades." and `Language` = "DE";
update languagespell set Message3 = "Euer zusätzlicher Schutz vor Kälte schwindet." where Message3 = "Your extra protection against cold fades." and `Language` = "DE";
update languagespell set Message3 = "Euer zusätzlicher Schutz vor Energie schwindet." where Message3 = "Your extra protection against energy fades." and `Language` = "DE";
update languagespell set Message3 = "Euer zusätzlicher Schutz vor Hitze schwindet." where Message3 = "Your extra protection against heat fades." and `Language` = "DE";
update languagespell set Message3 = "Euer zusätzlicher Schutz vor Materiemagie schwindet." where Message3 = "Your extra protection against matter magic fades." and `Language` = "DE";
update languagespell set Message3 = "Euer zusätzlicher Schutz vor Geistmagie schwindet." where Message3 = "Your extra protection against spiritual magic fades." and `Language` = "DE";
update languagespell set Message3 = "Eure heilige Aura lässt nach." where Message3 = "Your holy aura wears off." and `Language` = "DE";
update languagespell set Message3 = "Euer Energieschild verschwindet." where Message3 = "Your energy shield fades." and `Language` = "DE";
update languagespell set Message3 = "Eure Haut verliert die zusätzliche Stärke." where Message3 = "Your skin loses its extra strength." and `Language` = "DE";
update languagespell set Message3 = "Eure Angriffsgeschwindigkeit hat sich normalisiert." where Message3 = "Your attacks return to normal." and `Language` = "DE";
update languagespell set Message3 = "Euer innerer Frieden verlässt Euch wieder." where Message3 = "Your inner peace leaves you." and `Language` = "DE";
update languagespell set Message3 = "Euer meditativer Zustand schwindet." where Message3 = "Your meditative state fades." and `Language` = "DE";
update languagespell set Message3 = "Eure Gelassenheit schwindet." where Message3 = "Your serenity fades." and `Language` = "DE";
update languagespell set Message3 = "Eure Geschicklichkeit normalisiert sich." where Message3 = "Your agility returns to normal." and `Language` = "DE";
update languagespell set Message3 = "Eure Gesundheit normalisiert sich." where Message3 = "Your health returns to normal." and `Language` = "DE";
update languagespell set Message3 = "Eure Auffrischung beginnt zu schwinden." where Message3 = "Your refreshment begins to fade." and `Language` = "DE";
update languagespell set Message3 = "Eure Sinnesschärfe normalisiert sich." where Message3 = "Your smarts return to normal." and `Language` = "DE";
update languagespell set Message3 = "Eure Stärke und Gesundheit normalisieren sich." where Message3 = "Your strength and health returns to normal." and `Language` = "DE";
update languagespell set Message3 = "Eure Stärke normalisiert sich." where Message3 = "Your strength returns to normal." and `Language` = "DE";
update languagespell set Message3 = "Eure Stärke normalisiert sich." where Message3 = "Your strength begins to fade." and `Language` = "DE";
update languagespell set Message3 = "Eure Gesundheit normalisiert sich." where Message3 = "Your health returns to normal." and `Language` = "DE";
update languagespell set Message3 = "Ihr schnappt ach Luft und realisiert, daß Ihr nicht mehr unter Wasser atmen könnt!" where Message3 = "With a gulp and a gasp you realize that you are unable to breathe underater any longer!" and `Language` = "DE";
update languagespell set Message3 = "Ihr verliert Eure zusätzliche Ausdauer." where Message3 = "You loose your increased stamina." and `Language` = "DE";
update languagespell set Message3 = "Ihr wurdet von einem Schneeball getroffen!" where Message3 = "You've been hit with a snowball!" and `Language` = "DE";
update languagespell set Message3 = "Eure Rüstung normalisiert sich." where Message3 = "Your armor returns to normal." and `Language` = "DE";
update languagespell set Message3 = "Eure Angriffsgeschwindigkeit hat sich normalisiert." where Message3 = "Your attack speed is back to normal." and `Language` = "DE";
update languagespell set Message3 = "Eure Grausamkeit schwindet." where Message3 = "Your ferocity fades." and `Language` = "DE";
update languagespell set Message3 = "Eure Lebenskraftentzug-Aura schwindet." where Message3 = "Your life stealing aura fades." and `Language` = "DE";
update languagespell set Message3 = "Eure Effektivität hat sich normalisiert." where Message3 = "Your effectiveness is back to normal." and `Language` = "DE";
update languagespell set Message3 = "Eure Nahkampfresistenz hat sich normalisiert." where Message3 = "Your melee resistance is back to normal." and `Language` = "DE";
update languagespell set Message3 = "Eure Haut verliert die zusätzliche Stärke." where Message3 = "Your skin loses its extra strength." and `Language` = "DE";
update languagespell set Message3 = "Eure Waffe normalisiert sich." where Message3 = "Your weapon returns to normal." and `Language` = "DE";
update languagespell set Message3 = "Eure Waffenrune schwindet." where Message3 = "Your weapon's rune fades." and `Language` = "DE";
/* Message 4 */
update languagespell set Message4 = "Der schwächende Effekt um {0} verschwindet." where Message4 = "The weakening effect around {0} dissipates." and `Language` = "DE";
update languagespell set Message4 = "Die Säurewolke um {0} verschwindet." where Message4 = "The acidic mist around {0} dissipates." and `Language` = "DE";
update languagespell set Message4 = "Die Säurewolke um {0} verschwindet." where Message4 = "The acidic cloud around {0} dissipates." and `Language` = "DE";
update languagespell set Message4 = "{0}s Infektion hat sich aufgelöst." where Message4 = "{0}'s infection clears up." and `Language` = "DE";
update languagespell set Message4 = "{0}s Waffe ist wieder normal." where Message4 = "{0}'s weapon returns to normal." and `Language` = "DE";
update languagespell set Message4 = "Die zerstörerische Energie um {0} schwindet." where Message4 = "The destructive energy around {0} fades." and `Language` = "DE";
update languagespell set Message4 = "Die nahezu unüberwindbare Macht um {0} schwindet." where Message4 = "The near impregnable force around {0} fades." and `Language` = "DE";
update languagespell set Message4 = "Die Lava fällt von {0}s Haut ab." where Message4 = "The lava falls from {0}'s skin." and `Language` = "DE";
update languagespell set Message4 = "Die schmutzige Wolke um {0} verschwindet." where Message4 = "The cloud of dirt around {0} dissipates." and `Language` = "DE";
update languagespell set Message4 = "{0} sieht wieder gesund aus." where Message4 = "{0} look healthy again." and `Language` = "DE";
update languagespell set Message4 = "{0} sieht wieder gesund aus." where Message4 = "{0} looks healthy again." and `Language` = "DE";
update languagespell set Message4 = "{0}s Angriffsgeschwindigkeit hat sich normalisiert." where Message4 = "{0}'s attacks return to normal." and `Language` = "DE";
update languagespell set Message4 = "{0}s Gelassenheit schwindet." where Message4 = "{0} calmness leaves." and `Language` = "DE";
update languagespell set Message4 = "{0}s meditativer Zustand schwindet." where Message4 = "{0}'s meditative state fades." and `Language` = "DE";
update languagespell set Message4 = "{0}s Gelassenheit schwindet." where Message4 = "{0}'s serenity fades." and `Language` = "DE";
update languagespell set Message4 = "{0}s erhöhte Geschicklichkeit schwindet." where Message4 = "{0}'s enhanced agility fades." and `Language` = "DE";
update languagespell set Message4 = "{0}s erhöhte Lebenskraft schwindet." where Message4 = "{0}'s enhanced vigor fades." and `Language` = "DE";
update languagespell set Message4 = "{0}s Auffrischung beginnt zu schwinden." where Message4 = "{0}'s refreshment begins to fade." and `Language` = "DE";
update languagespell set Message4 = "{0}s Sinnesschärfe normalisiert sich." where Message4 = "{0}'s smarts seems to return to normal." and `Language` = "DE";
update languagespell set Message4 = "{0}s Stärke und Gesundheit normalisieren sich." where Message4 = "{0}'s extra strength and health fades." and `Language` = "DE";
update languagespell set Message4 = "{0}s Stärke normalisiert sich." where Message4 = "{0}'s extra strength fades." and `Language` = "DE";
update languagespell set Message4 = "{0}s Stärke normalisiert sich." where Message4 = "{0}'s strength begins to fade." and `Language` = "DE";
update languagespell set Message4 = "{0}s Gesundheit normalisiert sich." where Message4 = "{0}'s enhanced vigor fades." and `Language` = "DE";
update languagespell set Message4 = "{0} verliert seine zusätzliche Ausdauer." where Message4 = "{0}'s increased stamina fades." and `Language` = "DE";
update languagespell set Message4 = "{0} wurde von einem Schneeball getroffen!" where Message4 = "{0} has been hit with a snowball!" and `Language` = "DE";
update languagespell set Message4 = "{0}s Rüstung normalisiert sich." where Message4 = "{0}'s armor returns to normal." and `Language` = "DE";
update languagespell set Message4 = "{0}s Angriffsgeschwindigkeit hat sich normalisiert." where Message4 = "{0} attack speed is back to normal." and `Language` = "DE";
update languagespell set Message4 = "{0}s Grausamkeit schwindet." where Message4 = "{0}'s ferocity fades." and `Language` = "DE";
update languagespell set Message4 = "{0}s Effektivität hat sich normalisiert." where Message4 = "{0} effectiveness is back to normal." and `Language` = "DE";
update languagespell set Message4 = "{0}s Nahkampfresistenz hat sich normalisiert." where Message4 = "{0} melee resistance is back to normal." and `Language` = "DE";
update languagespell set Message4 = "Rinde fällt von {0}s Haut." where Message4 = "Bark falls from {0}'s skin." and `Language` = "DE";
update languagespell set Message4 = "{0}s Waffe normalisiert sich." where Message4 = "{0}'s weapon returns to normal." and `Language` = "DE";
update languagespell set Message4 = "{0}s Waffenrune schwindet." where Message4 = "{0}'s weapon's rune fades." and `Language` = "DE";
