[Custom] Deathknight Trainer (100% working for Mangos)

[newfang]

I created this, from scratch after getting tired of servers with no deathknight spells(excluding the basic ones), so credits for it to me =P
Thought I'd share it with you all, just open Navicat and right click mangos, click execute batch file and select Deathknight_trainer

When its done refresh mangos and start up your server.

.npc add 4

to add the trainer.
You can't see the spells unless your the right level and all (they are chained so you can't skip certain spells to learn the higher rank, also have level req. on them)
Each spell by default costs 10 copper to learn.twocents

Enjoy!

MEGAUPLOAD - The leading online storage and file delivery service



Credits also to Mike, who made this all possible(for me)

[Synris]

ty +rep .

[Power of Illuminati]

Wth, +Rep for making it Even if I don't have any use for it.
Good work, keep it up

[Danox]

+
respect =)

[Danox]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''creature_model_info' ('24641','0','24641')

INSERT INTO `npc_trainer` VALUES ' at line 1
[Err] INSERT INTO 'creature_model_info' ('24641','0','24641')

INSERT INTO `npc_trainer` VALUES ('4', '49926', '1', '0', '0', '60');
[Msg] Finished - Unsuccessfully
navicat =(

[Power of Illuminati]

A little bit unsure why you get that error
But do you got the wotl repack for mangos? As I think this is for mangos. Or... ?

[newfang]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''creature_model_info' ('24641','0','24641')

INSERT INTO `npc_trainer` VALUES ' at line 1
[Err] INSERT INTO 'creature_model_info' ('24641','0','24641')

INSERT INTO `npc_trainer` VALUES ('4', '49926', '1', '0', '0', '60');
[Msg] Finished - Unsuccessfully
navicat =(

EDIT: My bad, I messed up that bit of code, Fixed it in the new link up top x.x sorry.
Let me know if you have any other troubles. =S

[Danox]

db 1.4 from Mike topic

[Power of Illuminati]

Think I found the error! The most common programming error Oo

You forgot ';' after

INSERT INTO 'creature_model_info' ('24641','0','24641')

It should be like

INSERT INTO 'creature_model_info' ('24641','0','24641');

[Danox]

again error

[Err] 1062 - Duplicate entry '100001' for key 1
[Err] INSERT INTO `creature` VALUES ('100001', '4', '0', '1', '24641', '0', '1397.25', '-3244.14', '160.908', '0.007055', '120', '5', '0', '10000000', '10000000', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Power of Illuminati]

[Err] 1062 - Duplicate entry '100001' for key 1

You have runned this one time, so some stuff is already in.

Would say that you remake the first lines of codes (to the creature model part) so it looks like this

##INSERT INTO `creature` VALUES ('100001', '4', '0', '1', '24641', '0', '1397.25', '-3244.14', '160.908', '0.007055', '120', '5', '0', '10000000', '10000000', '0', '0');
##INSERT INTO `creature` VALUES ('100013', '4', '571', '1', '0', '0', '1705.87', '-4108.62', '270.618', '0', '25', '0', '0', '1000000', '10000', '0', '1');
##INSERT INTO `creature` VALUES ('100014', '4', '0', '1', '0', '0', '1772.96', '57.1609', '-46.3214', '5.78322', '25', '0', '0', '1000000', '10000', '0', '1');
##INSERT INTO `creature` VALUES ('100020', '4', '0', '1', '0', '0', '2661.12', '-2475.34', '71.7427', '0', '25', '0', '0', '1000000', '10000', '0', '1');
##INSERT INTO `creature` VALUES ('100007', '4', '571', '1', '0', '0', '1403.36', '-3244.8', '161.198', '3.0489', '25', '0', '0', '1000000', '10000', '0', '1');

##INSERT INTO `creature_template` VALUES ('4', '24641', '0', '24641', '0', 'Derak', 'Deathknight Trainer', '', '80', '80', '1000000', '1000000', '10000', '10000', '10000', '1818', '1818', '19', '10', '1', '0', '100000', '100000', '0', '10000', '100', '0', '0', '0', '0', '0', '0', '6', '0', '1', '1', '11', '7', '1', '0', '3', '3', '0', '1', '1', '1', '1', '1', '1', '0', '0', '0', '0', '32', '47', '', '1', '3', '0', '1', '0', '0', '');

Full code would be like this then (if you executed and had an error on the model info)

##INSERT INTO `creature` VALUES ('100001', '4', '0', '1', '24641', '0', '1397.25', '-3244.14', '160.908', '0.007055', '120', '5', '0', '10000000', '10000000', '0', '0');
##INSERT INTO `creature` VALUES ('100013', '4', '571', '1', '0', '0', '1705.87', '-4108.62', '270.618', '0', '25', '0', '0', '1000000', '10000', '0', '1');
##INSERT INTO `creature` VALUES ('100014', '4', '0', '1', '0', '0', '1772.96', '57.1609', '-46.3214', '5.78322', '25', '0', '0', '1000000', '10000', '0', '1');
##INSERT INTO `creature` VALUES ('100020', '4', '0', '1', '0', '0', '2661.12', '-2475.34', '71.7427', '0', '25', '0', '0', '1000000', '10000', '0', '1');
##INSERT INTO `creature` VALUES ('100007', '4', '571', '1', '0', '0', '1403.36', '-3244.8', '161.198', '3.0489', '25', '0', '0', '1000000', '10000', '0', '1');

##INSERT INTO `creature_template` VALUES ('4', '24641', '0', '24641', '0', 'Derak', 'Deathknight Trainer', '', '80', '80', '1000000', '1000000', '10000', '10000', '10000', '1818', '1818', '19', '10', '1', '0', '100000', '100000', '0', '10000', '100', '0', '0', '0', '0', '0', '0', '6', '0', '1', '1', '11', '7', '1', '0', '3', '3', '0', '1', '1', '1', '1', '1', '1', '0', '0', '0', '0', '32', '47', '', '1', '3', '0', '1', '0', '0', '');

INSERT INTO 'creature_model_info' ('24641','0','24641')

INSERT INTO `npc_trainer` VALUES ('4', '49926', '1', '0', '0', '60');
INSERT INTO `npc_trainer` VALUES ('4', '49927', '1', '0', '0', '64');
INSERT INTO `npc_trainer` VALUES ('4', '49928', '1', '0', '0', '68');
INSERT INTO `npc_trainer` VALUES ('4', '49929', '1', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('4', '49930', '1', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('4', '48721', '1', '0', '0', '61');
INSERT INTO `npc_trainer` VALUES ('4', '49939', '1', '0', '0', '65');
INSERT INTO `npc_trainer` VALUES ('4', '49940', '1', '0', '0', '70');
INSERT INTO `npc_trainer` VALUES ('4', '49941', '1', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('4', '48743', '1', '0', '0', '62');
INSERT INTO `npc_trainer` VALUES ('4', '49934', '1', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('4', '49998', '1', '0', '0', '56');
INSERT INTO `npc_trainer` VALUES ('4', '49999', '1', '0', '0', '60');
INSERT INTO `npc_trainer` VALUES ('4', '45463', '1', '0', '0', '64');
INSERT INTO `npc_trainer` VALUES ('4', '49923', '1', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('4', '49924', '1', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('4', '47476', '1', '0', '0', '60');
INSERT INTO `npc_trainer` VALUES ('4', '49913', '1', '0', '0', '62');
INSERT INTO `npc_trainer` VALUES ('4', '49914', '1', '0', '0', '67');
INSERT INTO `npc_trainer` VALUES ('4', '49915', '1', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('4', '49916', '1', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('4', '45524', '1', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('4', '48766', '1', '0', '0', '66');
INSERT INTO `npc_trainer` VALUES ('4', '48792', '1', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('4', '49896', '1', '0', '0', '60');
INSERT INTO `npc_trainer` VALUES ('4', '49903', '1', '0', '0', '68');
INSERT INTO `npc_trainer` VALUES ('4', '49904', '1', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('4', '49909', '1', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('4', '47528', '1', '0', '0', '60');
INSERT INTO `npc_trainer` VALUES ('4', '49910', '1', '0', '0', '66');
INSERT INTO `npc_trainer` VALUES ('4', '49911', '1', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('4', '49912', '1', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('4', '48263', '1', '0', '0', '60');
INSERT INTO `npc_trainer` VALUES ('4', '48707', '1', '0', '0', '61');
INSERT INTO `npc_trainer` VALUES ('4', '42650', '1', '0', '0', '66');
INSERT INTO `npc_trainer` VALUES ('4', '43265', '1', '0', '0', '56');
INSERT INTO `npc_trainer` VALUES ('4', '49936', '1', '0', '0', '60');
INSERT INTO `npc_trainer` VALUES ('4', '49937', '1', '0', '0', '67');
INSERT INTO `npc_trainer` VALUES ('4', '49938', '1', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('4', '49892', '1', '0', '0', '60');
INSERT INTO `npc_trainer` VALUES ('4', '49893', '1', '0', '0', '67');
INSERT INTO `npc_trainer` VALUES ('4', '49894', '1', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('4', '49895', '1', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('4', '45843', '1', '0', '0', '62');
INSERT INTO `npc_trainer` VALUES ('4', '49932', '1', '0', '0', '66');
INSERT INTO `npc_trainer` VALUES ('4', '49933', '1', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('4', '49917', '1', '0', '0', '56');
INSERT INTO `npc_trainer` VALUES ('4', '49918', '1', '0', '0', '61');
INSERT INTO `npc_trainer` VALUES ('4', '49919', '1', '0', '0', '66');
INSERT INTO `npc_trainer` VALUES ('4', '49920', '1', '0', '0', '70');
INSERT INTO `npc_trainer` VALUES ('4', '49921', '1', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('4', '46584', '1', '0', '0', '70');
INSERT INTO `npc_trainer` VALUES ('4', '48265', '1', '0', '0', '55');

INSERT INTO `spell_chain` VALUES ('49939', '48721', '48721', '2');
INSERT INTO `spell_chain` VALUES ('49940', '49939', '48721', '3');
INSERT INTO `spell_chain` VALUES ('49941', '49940', '48721', '4');
INSERT INTO `spell_chain` VALUES ('49926', '45902', '45902', '2');
INSERT INTO `spell_chain` VALUES ('49927', '49926', '45902', '3');
INSERT INTO `spell_chain` VALUES ('49928', '49927', '45902', '4');
INSERT INTO `spell_chain` VALUES ('49929', '49928', '45902', '5');
INSERT INTO `spell_chain` VALUES ('49930', '49929', '45902', '6');
INSERT INTO `spell_chain` VALUES ('49999', '49998', '49998', '2');
INSERT INTO `spell_chain` VALUES ('45463', '49999', '49998', '3');
INSERT INTO `spell_chain` VALUES ('49923', '45463', '49998', '4');
INSERT INTO `spell_chain` VALUES ('49924', '49923', '49998', '5');
INSERT INTO `spell_chain` VALUES ('49913', '47476', '47476', '2');
INSERT INTO `spell_chain` VALUES ('49914', '49913', '47476', '3');
INSERT INTO `spell_chain` VALUES ('49915', '49914', '47476', '4');
INSERT INTO `spell_chain` VALUES ('49916', '49915', '47476', '5');
INSERT INTO `spell_chain` VALUES ('49896', '45477', '45477', '2');
INSERT INTO `spell_chain` VALUES ('49903', '49896', '45477', '3');
INSERT INTO `spell_chain` VALUES ('49904', '49903', '45477', '4');
INSERT INTO `spell_chain` VALUES ('49909', '49904', '45477', '5');
INSERT INTO `spell_chain` VALUES ('49910', '47528', '47528', '2');
INSERT INTO `spell_chain` VALUES ('49911', '49910', '47528', '3');
INSERT INTO `spell_chain` VALUES ('49912', '49911', '47528', '4');
INSERT INTO `spell_chain` VALUES ('49936', '43265', '43265', '2');
INSERT INTO `spell_chain` VALUES ('49937', '49936', '43265', '3');
INSERT INTO `spell_chain` VALUES ('49938', '49937', '43265', '4');
INSERT INTO `spell_chain` VALUES ('49892', '47541', '47541', '2');
INSERT INTO `spell_chain` VALUES ('49893', '49892', '47541', '3');
INSERT INTO `spell_chain` VALUES ('49894', '49893', '47541', '4');
INSERT INTO `spell_chain` VALUES ('49895', '49894', '47541', '5');
INSERT INTO `spell_chain` VALUES ('49932', '45843', '45843', '2');
INSERT INTO `spell_chain` VALUES ('49933', '49932', '45843', '3');
INSERT INTO `spell_chain` VALUES ('49917', '45462', '45462', '2');
INSERT INTO `spell_chain` VALUES ('49918', '49917', '45462', '3');
INSERT INTO `spell_chain` VALUES ('49919', '49918', '45462', '4');
INSERT INTO `spell_chain` VALUES ('49920', '49919', '45462', '5');
INSERT INTO `spell_chain` VALUES ('49921', '49920', '45462', '6');

## stands for comment. = That lines isn't executed.

[Danox]

error
I need to remove the trainer. Then to establish. How it to make?

[Power of Illuminati]

Think you change the INSERT INTO to DELETE FROM.

[zerqq]

INSERT INTO 'creature_model_info' ('24641','0','24641');

this make an error.

[cristi13]

w00t! thank you very much! +rep