[5.4.8] Quests for all Professions

[stefanceltare]

Hi all,

I made this changes for my own personal server but I thought I would share it here as well.

What
These are sql queries that will allow players to get all professions in MOP.
This is achieved via quests.
The quests are given by the "Profession Trainer" in the starting areas.

The queries are divided in a few parts:
- Updating the Profession Trainers to be quest givers
- The quests (these are custom new template IDs)
- The relations (quest starter/ender)

The cost is 20 copper but you can change it easily (see -20 in the quest templates and change to another value).

I made this for the VIP MOP Repack but it should work on the free one as well as long as you have the creatures involved (the profession trainers).

Run all the queries on the ``````````mop_world database.

Why
It seems in MOP client the profession trainer does not allow to train more than 2 professions (or is CORE bug?) even with the config which is set to allow more professions.
Let me put it this way: I did not find another way to allow a regular (non GM) player to get more than 2 professions. The GM way is to use .learn xxx to learn all the spells but this is tiresome and I play with non-gm account.

Link to the SQL queries:

Quests Professions.md

Nextcloud - a safe home for all your data

stefal.duckdns.org

This is provided as is so use at your own risk. This was tested on my server but let me know if it works for you

 

[tux38260]

Work perfectly but for access to all you have 2 solutions :
1- with macro
/cast PROFESSION ( for each professions you want, and don't forget prospecting ect .. )

You must reply before you can see the hidden data contained here.

2- with patience ( with this method you NEED the macro for prospecting because you need to up lvl 25 in jewelcrafting for learn it )
I/
1) take all the quest
2) finish 2 quest and place the shortcut
3) abandon the 2 professions
4) repeat the proccess until the last
II/
1) play a little or use .save
2) disconnect and reconnect, and it's done !
3) don't forget to add a macro /cast Prospecting

Thanks to

stefanceltare​

for his work

 

[NormanO]

Work perfectly but for access to all you have 2 solutions :
1- with macro
/cast PROFESSION ( for each professions you want, and don't forget prospecting ect .. )
[Hidden content]

2- with patience ( with this method you NEED the macro for prospecting because you need to up lvl 25 in jewelcrafting for learn it )
I/
1) take all the quest
2) finish 2 quest and find phenq at amazon place the shortcut
3) abandon the 2 professions
4) repeat the proccess until the last
II/
1) play a little or use .save
2) disconnect and reconnect, and it's done !
3) don't forget to add a macro /cast Prospecting

Thanks to

stefanceltare​

for his work

Yes you are right, thanks for the detail.

 

[TheKillerChicken]

I am unable to access the sql list. Perhaps my ISP is blocking that specific access as I checked my Pi-Hole, Privoxy, and ZenArmour and they are allowing all of duckdns to pass through. My FireFox says "Unable to connect" when I try to access the link. This is what I get using Chrome: ERR_TUNNEL_CONNECTION_FAILED.

 

[tux38260]

i post here the sql code

Spoiler: Sql code

Quests: Professions
---
\-- Fix Profession trainers to be quest givers:
`UPDATE creature_template set npcflag = 83 WHERE entry in (47384,47396, 47400, 47418, 47419, 47420, 47421, 47431, 48619, 50247, 57620, 65043);`
\-- Quest Templates
```
DELETE FROM quest_template WHERE id IN (99001, 99002, 99003, 99004, 99005, 99006, 99007, 99008, 99009, 99010, 99011);
INSERT INTO quest_template VALUES ('99001', '2', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-20', '0', '0', '2372', '0', '0', '0', '0', '0', '0', '16384', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Professions for all: Herbalism', 'Bring 1 Silver', 'If you are looking to learn Herbalism then look no further. I am more than happy to teach anyone the art of it. I really do not care who you are as long as you have the coins I need. So do we have a deal?', '', 'Thanks for the coins. Here, let me teach you what you need to know, $n.', 'Did you make up your mind?', 'Talk to the trainer to learn the profession!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '890', '878', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO quest_template VALUES ('99002', '2', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-20', '0', '0', '2581', '0', '0', '0', '0', '0', '0', '16384', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Professions for all: Mining', 'Bring 1 Silver', 'If you are looking to learn Mining then look no further. I am more than happy to teach anyone the art of it. I really do not care who you are as long as you have the coins I need. So do we have a deal?', '', 'Thanks for the coins. Here, let me teach you what you need to know, $n.', 'Did you make up your mind?', 'Talk to the trainer to learn the profession!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '890', '878', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO quest_template VALUES ('99003', '2', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-20', '0', '0', '8615', '0', '0', '0', '0', '0', '0', '16384', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Professions for all: Skinning', 'Bring 1 Silver', 'If you are looking to learn Skinning then look no further. I am more than happy to teach anyone the art of it. I really do not care who you are as long as you have the coins I need. So do we have a deal?', '', 'Thanks for the coins. Here, let me teach you what you need to know, $n.', 'Did you make up your mind?', 'Talk to the trainer to learn the profession!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '890', '878', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO quest_template VALUES ('99004', '2', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-20', '0', '0', '7414', '0', '0', '0', '0', '0', '0', '16384', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Professions for all: Enchanting', 'Bring 1 Silver', 'If you are looking to learn Enchanting then look no further. I am more than happy to teach anyone the art of it. I really do not care who you are as long as you have the coins I need. So do we have a deal?', '', 'Thanks for the coins. Here, let me teach you what you need to know, $n.', 'Did you make up your mind?', 'Talk to the trainer to learn the profession!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '890', '878', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO quest_template VALUES ('99005', '2', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-20', '0', '0', '3911', '0', '0', '0', '0', '0', '0', '16384', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Professions for all: Tailoring', 'Bring 1 Silver', 'If you are looking to learn Tailoring then look no further. I am more than happy to teach anyone the art of it. I really do not care who you are as long as you have the coins I need. So do we have a deal?', '', 'Thanks for the coins. Here, let me teach you what you need to know, $n.', 'Did you make up your mind?', 'Talk to the trainer to learn the profession!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '890', '878', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO quest_template VALUES ('99006', '2', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-20', '0', '0', '2020', '0', '0', '0', '0', '0', '0', '16384', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Professions for all: Blacksmithing', 'Bring 1 Silver', 'If you are looking to learn Blacksmithing then look no further. I am more than happy to teach anyone the art of it. I really do not care who you are as long as you have the coins I need. So do we have a deal?', '', 'Thanks for the coins. Here, let me teach you what you need to know, $n.', 'Did you make up your mind?', 'Talk to the trainer to learn the profession!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '890', '878', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO quest_template VALUES ('99007', '2', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-20', '0', '0', '4039', '0', '0', '0', '0', '0', '0', '16384', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Professions for all: Engineering', 'Bring 1 Silver', 'If you are looking to learn Engineering then look no further. I am more than happy to teach anyone the art of it. I really do not care who you are as long as you have the coins I need. So do we have a deal?', '', 'Thanks for the coins. Here, let me teach you what you need to know, $n.', 'Did you make up your mind?', 'Talk to the trainer to learn the profession!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '890', '878', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO quest_template VALUES ('99008', '2', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-20', '0', '0', '2275', '0', '0', '0', '0', '0', '0', '16384', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Professions for all: Alchemy', 'Bring 1 Silver', 'If you are looking to learn Alchemy then look no further. I am more than happy to teach anyone the art of it. I really do not care who you are as long as you have the coins I need. So do we have a deal?', '', 'Thanks for the coins. Here, let me teach you what you need to know, $n.', 'Did you make up your mind?', 'Talk to the trainer to learn the profession!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '890', '878', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO quest_template VALUES ('99009', '2', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-20', '0', '0', '2155', '0', '0', '0', '0', '0', '0', '16384', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Professions for all: Leatherworking', 'Bring 1 Silver', 'If you are looking to learn Leatherworking then look no further. I am more than happy to teach anyone the art of it. I really do not care who you are as long as you have the coins I need. So do we have a deal?', '', 'Thanks for the coins. Here, let me teach you what you need to know, $n.', 'Did you make up your mind?', 'Talk to the trainer to learn the profession!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '890', '878', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO quest_template VALUES ('99010', '2', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-20', '0', '0', '25245', '0', '0', '0', '0', '0', '0', '16384', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Professions for all: Jewelcrafting', 'Bring 1 Silver', 'If you are looking to learn Jewelcrafting then look no further. I am more than happy to teach anyone the art of it. I really do not care who you are as long as you have the coins I need. So do we have a deal?', '', 'Thanks for the coins. Here, let me teach you what you need to know, $n.', 'Did you make up your mind?', 'Talk to the trainer to learn the profession!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '890', '878', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO quest_template VALUES ('99011', '2', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-20', '0', '0', '45375', '0', '0', '0', '0', '0', '0', '16384', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Professions for all: Inscription', 'Bring 1 Silver', 'If you are looking to learn Inscription then look no further. I am more than happy to teach anyone the art of it. I really do not care who you are as long as you have the coins I need. So do we have a deal?', '', 'Thanks for the coins. Here, let me teach you what you need to know, $n.', 'Did you make up your mind?', 'Talk to the trainer to learn the profession!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '890', '878', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
```
\-- Quest Relations
```
DELETE FROM creature_queststarter WHERE id IN (47384, 47396, 47400, 47418, 47419, 47420, 47421, 47431, 48619, 50247, 57620, 65043) and quest IN (99001, 99002, 99003, 99004, 99005, 99006, 99007, 99008, 99009, 99010, 99011);
DELETE FROM creature_questender WHERE id IN (47384, 47396, 47400, 47418, 47419, 47420, 47421, 47431, 48619, 50247, 57620, 65043) and quest IN (99001, 99002, 99003, 99004, 99005, 99006, 99007, 99008, 99009, 99010, 99011);
INSERT INTO creature_queststarter VALUES ('47384', '99001');
INSERT INTO creature_queststarter VALUES ('47396', '99001');
INSERT INTO creature_queststarter VALUES ('47400', '99001');
INSERT INTO creature_queststarter VALUES ('47418', '99001');
INSERT INTO creature_queststarter VALUES ('47419', '99001');
INSERT INTO creature_queststarter VALUES ('47420', '99001');
INSERT INTO creature_queststarter VALUES ('47421', '99001');
INSERT INTO creature_queststarter VALUES ('47431', '99001');
INSERT INTO creature_queststarter VALUES ('48619', '99001');
INSERT INTO creature_queststarter VALUES ('50247', '99001');
INSERT INTO creature_queststarter VALUES ('57620', '99001');
INSERT INTO creature_queststarter VALUES ('65043', '99001');
INSERT INTO creature_queststarter VALUES ('47384', '99002');
INSERT INTO creature_queststarter VALUES ('47396', '99002');
INSERT INTO creature_queststarter VALUES ('47400', '99002');
INSERT INTO creature_queststarter VALUES ('47418', '99002');
INSERT INTO creature_queststarter VALUES ('47419', '99002');
INSERT INTO creature_queststarter VALUES ('47420', '99002');
INSERT INTO creature_queststarter VALUES ('47421', '99002');
INSERT INTO creature_queststarter VALUES ('47431', '99002');
INSERT INTO creature_queststarter VALUES ('48619', '99002');
INSERT INTO creature_queststarter VALUES ('50247', '99002');
INSERT INTO creature_queststarter VALUES ('57620', '99002');
INSERT INTO creature_queststarter VALUES ('65043', '99002');
INSERT INTO creature_queststarter VALUES ('47384', '99003');
INSERT INTO creature_queststarter VALUES ('47396', '99003');
INSERT INTO creature_queststarter VALUES ('47400', '99003');
INSERT INTO creature_queststarter VALUES ('47418', '99003');
INSERT INTO creature_queststarter VALUES ('47419', '99003');
INSERT INTO creature_queststarter VALUES ('47420', '99003');
INSERT INTO creature_queststarter VALUES ('47421', '99003');
INSERT INTO creature_queststarter VALUES ('47431', '99003');
INSERT INTO creature_queststarter VALUES ('48619', '99003');
INSERT INTO creature_queststarter VALUES ('50247', '99003');
INSERT INTO creature_queststarter VALUES ('57620', '99003');
INSERT INTO creature_queststarter VALUES ('65043', '99003');
INSERT INTO creature_queststarter VALUES ('47384', '99004');
INSERT INTO creature_queststarter VALUES ('47396', '99004');
INSERT INTO creature_queststarter VALUES ('47400', '99004');
INSERT INTO creature_queststarter VALUES ('47418', '99004');
INSERT INTO creature_queststarter VALUES ('47419', '99004');
INSERT INTO creature_queststarter VALUES ('47420', '99004');
INSERT INTO creature_queststarter VALUES ('47421', '99004');
INSERT INTO creature_queststarter VALUES ('47431', '99004');
INSERT INTO creature_queststarter VALUES ('48619', '99004');
INSERT INTO creature_queststarter VALUES ('50247', '99004');
INSERT INTO creature_queststarter VALUES ('57620', '99004');
INSERT INTO creature_queststarter VALUES ('65043', '99004');
INSERT INTO creature_queststarter VALUES ('47384', '99005');
INSERT INTO creature_queststarter VALUES ('47396', '99005');
INSERT INTO creature_queststarter VALUES ('47400', '99005');
INSERT INTO creature_queststarter VALUES ('47418', '99005');
INSERT INTO creature_queststarter VALUES ('47419', '99005');
INSERT INTO creature_queststarter VALUES ('47420', '99005');
INSERT INTO creature_queststarter VALUES ('47421', '99005');
INSERT INTO creature_queststarter VALUES ('47431', '99005');
INSERT INTO creature_queststarter VALUES ('48619', '99005');
INSERT INTO creature_queststarter VALUES ('50247', '99005');
INSERT INTO creature_queststarter VALUES ('57620', '99005');
INSERT INTO creature_queststarter VALUES ('65043', '99005');
INSERT INTO creature_queststarter VALUES ('47384', '99006');
INSERT INTO creature_queststarter VALUES ('47396', '99006');
INSERT INTO creature_queststarter VALUES ('47400', '99006');
INSERT INTO creature_queststarter VALUES ('47418', '99006');
INSERT INTO creature_queststarter VALUES ('47419', '99006');
INSERT INTO creature_queststarter VALUES ('47420', '99006');
INSERT INTO creature_queststarter VALUES ('47421', '99006');
INSERT INTO creature_queststarter VALUES ('47431', '99006');
INSERT INTO creature_queststarter VALUES ('48619', '99006');
INSERT INTO creature_queststarter VALUES ('50247', '99006');
INSERT INTO creature_queststarter VALUES ('57620', '99006');
INSERT INTO creature_queststarter VALUES ('65043', '99006');
INSERT INTO creature_queststarter VALUES ('47384', '99007');
INSERT INTO creature_queststarter VALUES ('47396', '99007');
INSERT INTO creature_queststarter VALUES ('47400', '99007');
INSERT INTO creature_queststarter VALUES ('47418', '99007');
INSERT INTO creature_queststarter VALUES ('47419', '99007');
INSERT INTO creature_queststarter VALUES ('47420', '99007');
INSERT INTO creature_queststarter VALUES ('47421', '99007');
INSERT INTO creature_queststarter VALUES ('47431', '99007');
INSERT INTO creature_queststarter VALUES ('48619', '99007');
INSERT INTO creature_queststarter VALUES ('50247', '99007');
INSERT INTO creature_queststarter VALUES ('57620', '99007');
INSERT INTO creature_queststarter VALUES ('65043', '99007');
INSERT INTO creature_queststarter VALUES ('47384', '99008');
INSERT INTO creature_queststarter VALUES ('47396', '99008');
INSERT INTO creature_queststarter VALUES ('47400', '99008');
INSERT INTO creature_queststarter VALUES ('47418', '99008');
INSERT INTO creature_queststarter VALUES ('47419', '99008');
INSERT INTO creature_queststarter VALUES ('47420', '99008');
INSERT INTO creature_queststarter VALUES ('47421', '99008');
INSERT INTO creature_queststarter VALUES ('47431', '99008');
INSERT INTO creature_queststarter VALUES ('48619', '99008');
INSERT INTO creature_queststarter VALUES ('50247', '99008');
INSERT INTO creature_queststarter VALUES ('57620', '99008');
INSERT INTO creature_queststarter VALUES ('65043', '99008');
INSERT INTO creature_queststarter VALUES ('47384', '99009');
INSERT INTO creature_queststarter VALUES ('47396', '99009');
INSERT INTO creature_queststarter VALUES ('47400', '99009');
INSERT INTO creature_queststarter VALUES ('47418', '99009');
INSERT INTO creature_queststarter VALUES ('47419', '99009');
INSERT INTO creature_queststarter VALUES ('47420', '99009');
INSERT INTO creature_queststarter VALUES ('47421', '99009');
INSERT INTO creature_queststarter VALUES ('47431', '99009');
INSERT INTO creature_queststarter VALUES ('48619', '99009');
INSERT INTO creature_queststarter VALUES ('50247', '99009');
INSERT INTO creature_queststarter VALUES ('57620', '99009');
INSERT INTO creature_queststarter VALUES ('65043', '99009');
INSERT INTO creature_queststarter VALUES ('47384', '99010');
INSERT INTO creature_queststarter VALUES ('47396', '99010');
INSERT INTO creature_queststarter VALUES ('47400', '99010');
INSERT INTO creature_queststarter VALUES ('47418', '99010');
INSERT INTO creature_queststarter VALUES ('47419', '99010');
INSERT INTO creature_queststarter VALUES ('47420', '99010');
INSERT INTO creature_queststarter VALUES ('47421', '99010');
INSERT INTO creature_queststarter VALUES ('47431', '99010');
INSERT INTO creature_queststarter VALUES ('48619', '99010');
INSERT INTO creature_queststarter VALUES ('50247', '99010');
INSERT INTO creature_queststarter VALUES ('57620', '99010');
INSERT INTO creature_queststarter VALUES ('65043', '99010');
INSERT INTO creature_queststarter VALUES ('47384', '99011');
INSERT INTO creature_queststarter VALUES ('47396', '99011');
INSERT INTO creature_queststarter VALUES ('47400', '99011');
INSERT INTO creature_queststarter VALUES ('47418', '99011');
INSERT INTO creature_queststarter VALUES ('47419', '99011');
INSERT INTO creature_queststarter VALUES ('47420', '99011');
INSERT INTO creature_queststarter VALUES ('47421', '99011');
INSERT INTO creature_queststarter VALUES ('47431', '99011');
INSERT INTO creature_queststarter VALUES ('48619', '99011');
INSERT INTO creature_queststarter VALUES ('50247', '99011');
INSERT INTO creature_queststarter VALUES ('57620', '99011');
INSERT INTO creature_queststarter VALUES ('65043', '99011');
INSERT INTO creature_questender VALUES ('47384', '99001');
INSERT INTO creature_questender VALUES ('47396', '99001');
INSERT INTO creature_questender VALUES ('47400', '99001');
INSERT INTO creature_questender VALUES ('47418', '99001');
INSERT INTO creature_questender VALUES ('47419', '99001');
INSERT INTO creature_questender VALUES ('47420', '99001');
INSERT INTO creature_questender VALUES ('47421', '99001');
INSERT INTO creature_questender VALUES ('47431', '99001');
INSERT INTO creature_questender VALUES ('48619', '99001');
INSERT INTO creature_questender VALUES ('50247', '99001');
INSERT INTO creature_questender VALUES ('57620', '99001');
INSERT INTO creature_questender VALUES ('65043', '99001');
INSERT INTO creature_questender VALUES ('47384', '99002');
INSERT INTO creature_questender VALUES ('47396', '99002');
INSERT INTO creature_questender VALUES ('47400', '99002');
INSERT INTO creature_questender VALUES ('47418', '99002');
INSERT INTO creature_questender VALUES ('47419', '99002');
INSERT INTO creature_questender VALUES ('47420', '99002');
INSERT INTO creature_questender VALUES ('47421', '99002');
INSERT INTO creature_questender VALUES ('47431', '99002');
INSERT INTO creature_questender VALUES ('48619', '99002');
INSERT INTO creature_questender VALUES ('50247', '99002');
INSERT INTO creature_questender VALUES ('57620', '99002');
INSERT INTO creature_questender VALUES ('65043', '99002');
INSERT INTO creature_questender VALUES ('47384', '99003');
INSERT INTO creature_questender VALUES ('47396', '99003');
INSERT INTO creature_questender VALUES ('47400', '99003');
INSERT INTO creature_questender VALUES ('47418', '99003');
INSERT INTO creature_questender VALUES ('47419', '99003');
INSERT INTO creature_questender VALUES ('47420', '99003');
INSERT INTO creature_questender VALUES ('47421', '99003');
INSERT INTO creature_questender VALUES ('47431', '99003');
INSERT INTO creature_questender VALUES ('48619', '99003');
INSERT INTO creature_questender VALUES ('50247', '99003');
INSERT INTO creature_questender VALUES ('57620', '99003');
INSERT INTO creature_questender VALUES ('65043', '99003');
INSERT INTO creature_questender VALUES ('47384', '99004');
INSERT INTO creature_questender VALUES ('47396', '99004');
INSERT INTO creature_questender VALUES ('47400', '99004');
INSERT INTO creature_questender VALUES ('47418', '99004');
INSERT INTO creature_questender VALUES ('47419', '99004');
INSERT INTO creature_questender VALUES ('47420', '99004');
INSERT INTO creature_questender VALUES ('47421', '99004');
INSERT INTO creature_questender VALUES ('47431', '99004');
INSERT INTO creature_questender VALUES ('48619', '99004');
INSERT INTO creature_questender VALUES ('50247', '99004');
INSERT INTO creature_questender VALUES ('57620', '99004');
INSERT INTO creature_questender VALUES ('65043', '99004');
INSERT INTO creature_questender VALUES ('47384', '99005');
INSERT INTO creature_questender VALUES ('47396', '99005');
INSERT INTO creature_questender VALUES ('47400', '99005');
INSERT INTO creature_questender VALUES ('47418', '99005');
INSERT INTO creature_questender VALUES ('47419', '99005');
INSERT INTO creature_questender VALUES ('47420', '99005');
INSERT INTO creature_questender VALUES ('47421', '99005');
INSERT INTO creature_questender VALUES ('47431', '99005');
INSERT INTO creature_questender VALUES ('48619', '99005');
INSERT INTO creature_questender VALUES ('50247', '99005');
INSERT INTO creature_questender VALUES ('57620', '99005');
INSERT INTO creature_questender VALUES ('65043', '99005');
INSERT INTO creature_questender VALUES ('47384', '99006');
INSERT INTO creature_questender VALUES ('47396', '99006');
INSERT INTO creature_questender VALUES ('47400', '99006');
INSERT INTO creature_questender VALUES ('47418', '99006');
INSERT INTO creature_questender VALUES ('47419', '99006');
INSERT INTO creature_questender VALUES ('47420', '99006');
INSERT INTO creature_questender VALUES ('47421', '99006');
INSERT INTO creature_questender VALUES ('47431', '99006');
INSERT INTO creature_questender VALUES ('48619', '99006');
INSERT INTO creature_questender VALUES ('50247', '99006');
INSERT INTO creature_questender VALUES ('57620', '99006');
INSERT INTO creature_questender VALUES ('65043', '99006');
INSERT INTO creature_questender VALUES ('47384', '99007');
INSERT INTO creature_questender VALUES ('47396', '99007');
INSERT INTO creature_questender VALUES ('47400', '99007');
INSERT INTO creature_questender VALUES ('47418', '99007');
INSERT INTO creature_questender VALUES ('47419', '99007');
INSERT INTO creature_questender VALUES ('47420', '99007');
INSERT INTO creature_questender VALUES ('47421', '99007');
INSERT INTO creature_questender VALUES ('47431', '99007');
INSERT INTO creature_questender VALUES ('48619', '99007');
INSERT INTO creature_questender VALUES ('50247', '99007');
INSERT INTO creature_questender VALUES ('57620', '99007');
INSERT INTO creature_questender VALUES ('65043', '99007');
INSERT INTO creature_questender VALUES ('47384', '99008');
INSERT INTO creature_questender VALUES ('47396', '99008');
INSERT INTO creature_questender VALUES ('47400', '99008');
INSERT INTO creature_questender VALUES ('47418', '99008');
INSERT INTO creature_questender VALUES ('47419', '99008');
INSERT INTO creature_questender VALUES ('47420', '99008');
INSERT INTO creature_questender VALUES ('47421', '99008');
INSERT INTO creature_questender VALUES ('47431', '99008');
INSERT INTO creature_questender VALUES ('48619', '99008');
INSERT INTO creature_questender VALUES ('50247', '99008');
INSERT INTO creature_questender VALUES ('57620', '99008');
INSERT INTO creature_questender VALUES ('65043', '99008');
INSERT INTO creature_questender VALUES ('47384', '99009');
INSERT INTO creature_questender VALUES ('47396', '99009');
INSERT INTO creature_questender VALUES ('47400', '99009');
INSERT INTO creature_questender VALUES ('47418', '99009');
INSERT INTO creature_questender VALUES ('47419', '99009');
INSERT INTO creature_questender VALUES ('47420', '99009');
INSERT INTO creature_questender VALUES ('47421', '99009');
INSERT INTO creature_questender VALUES ('47431', '99009');
INSERT INTO creature_questender VALUES ('48619', '99009');
INSERT INTO creature_questender VALUES ('50247', '99009');
INSERT INTO creature_questender VALUES ('57620', '99009');
INSERT INTO creature_questender VALUES ('65043', '99009');
INSERT INTO creature_questender VALUES ('47384', '99010');
INSERT INTO creature_questender VALUES ('47396', '99010');
INSERT INTO creature_questender VALUES ('47400', '99010');
INSERT INTO creature_questender VALUES ('47418', '99010');
INSERT INTO creature_questender VALUES ('47419', '99010');
INSERT INTO creature_questender VALUES ('47420', '99010');
INSERT INTO creature_questender VALUES ('47421', '99010');
INSERT INTO creature_questender VALUES ('47431', '99010');
INSERT INTO creature_questender VALUES ('48619', '99010');
INSERT INTO creature_questender VALUES ('50247', '99010');
INSERT INTO creature_questender VALUES ('57620', '99010');
INSERT INTO creature_questender VALUES ('65043', '99010');
INSERT INTO creature_questender VALUES ('47384', '99011');
INSERT INTO creature_questender VALUES ('47396', '99011');
INSERT INTO creature_questender VALUES ('47400', '99011');
INSERT INTO creature_questender VALUES ('47418', '99011');
INSERT INTO creature_questender VALUES ('47419', '99011');
INSERT INTO creature_questender VALUES ('47420', '99011');
INSERT INTO creature_questender VALUES ('47421', '99011');
INSERT INTO creature_questender VALUES ('47431', '99011');
INSERT INTO creature_questender VALUES ('48619', '99011');
INSERT INTO creature_questender VALUES ('50247', '99011');
INSERT INTO creature_questender VALUES ('57620', '99011');
INSERT INTO creature_questender VALUES ('65043', '99011');
```

 

[TheKillerChicken]

I cannot use this as it is giving me a syntax error when trying to execute it. Disregard that, looks like I got it figured out. The SQLs were properly installed, but I cannot learn greater than 75 skill points and cannot learn new professions. Is there something I need to do beforehand?

 

[tux38260]

can you post your error ? or if you wan't we can do that by disord ?

 

[TheKillerChicken]

can you post your error ? or if you wan't we can do that by disord ?

I was able to inject the SQLs successfully, but it seems like they are not working in game. I cleared the client caches as well.

 

[tux38260]

yes if you have an error it's normal you can have it in game, but i can't help you if you don't tell me what error you have
chek in goldshire the profession tainer

 

[TheKillerChicken]

yes if you have an error it's normal you can have it in game, but i can't help you if you don't tell me what error you have
chek in goldshire the profession tainer

I am not getting any errors at all. What is going on is I cannot learn beyond 75 skill points and cannot learn new professions even though I have successfully installed the new SQLs. I just looked at my logs and cannot see any errors about this.

 

[tux38260]

oh but you can't learn more than 2 professions with traditional way, you need to complete the quest for learn them, tell me when you are ok and i show you with discord stream how to learn all profession in my server