Neocraft

Vendor_id in creature_template is the entry in npc_vendor_template. You can set same Vendor_id entry for several NPC. The npc_vendor table, is just for one NPC.

Try this: UPDATE `creature_template` SET `vendor_id` = '0' WHERE `vendor_id` = '1'; INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (5815, 16302, 0, 0, 0), (5815, 16316, 0, 0, 0), (5815, 16317, 0, 0, 0), (5815, 16318, 0, 0, 0), (5815, 16319, 0, 0, 0), (5815, 16320, 0, 0, 0), (5815, 16321, 0, 0, 0), (5815, 16322, 0, 0, 0), (5815, 16323, 0, 0, 0), (5815, 16324, 0, 0, 0), (5815, 16325, 0, 0, 0), (5815, 16326, 0, 0, 0), (5815, 16327, 0, 0, 0), (5815, 16328, 0, 0, 0), (5815, 16329, 0, 0, 0), (5815, 16330, 0, 0, 0), (5815, 16331, 0, 0, 0), (5815, 16346, 0, 0, 0), (5815, 16347, 0, 0, 0), (5815, 16348, 0, 0, 0), (5815, 16349, 0, 0, 0), (5815, 16350, 0, 0, 0), (5815, 16351, 0, 0, 0), (5815, 16352, 0, 0, 0), (5815, 16353, 0, 0, 0), (5815, 16354, 0, 0, 0), (5815, 16355, 0, 0, 0), (5815, 16356, 0, 0, 0), (5815, 16357, 0, 0, 0), (5815, 16358, 0, 0, 0), (5815, 16359, 0, 0, 0), (5815, 16360, 0, 0, 0), (5815, 16361, 0, 0, 0), (5815, 16362, 0, 0, 0), (5815, 16363, 0, 0, 0), (5815, 16364, 0, 0, 0), (5815, 16365, 0, 0, 0), (5815, 16366, 0, 0, 0), (5815, 16368, 0, 0, 0), (5815, 16371, 0, 0, 0), (5815, 16372, 0, 0, 0), (5815, 16373, 0, 0, 0), (5815, 16374, 0, 0, 0), (5815, 16375, 0, 0, 0), (5815, 16376, 0, 0, 0), (5815, 16377, 0, 0, 0), (5815, 16378, 0, 0, 0), (5815, 16379, 0, 0, 0), (5815, 16380, 0, 0, 0), (5815, 16381, 0, 0, 0), (5815, 16382, 0, 0, 0), (5815, 16383, 0, 0, 0), (5815, 16384, 0, 0, 0), (5815, 16385, 0, 0, 0), (5815, 16386, 0, 0, 0), (5815, 16387, 0, 0, 0), (5815, 16388, 0, 0, 0), (5815, 16389, 0, 0, 0), (5815, 16390, 0, 0, 0), (5815, 22179, 0, 0, 0), (5815, 22180, 0, 0, 0), (5815, 22181, 0, 0, 0), (5815, 22182, 0, 0, 0), (5815, 22184, 0, 0, 0), (5815, 22185, 0, 0, 0), (5815, 22186, 0, 0, 0), (5815, 22187, 0, 0, 0), (5815, 22188, 0, 0, 0), (5815, 22189, 0, 0, 0), (5815, 22190, 0, 0, 0), (5815, 23711, 0, 0, 0), (5815, 23730, 0, 0, 0), (5815, 23731, 0, 0, 0), (5815, 23734, 0, 0, 0), (5815, 23745, 0, 0, 0), (5815, 23755, 0, 0, 0), (5815, 25469, 0, 0, 0), (5815, 25900, 0, 0, 0), (5815, 28068, 0, 0, 0), (5815, 28071, 0, 0, 0), (5815, 28072, 0, 0, 0), (5815, 28073, 0, 0, 0); Insert into npc_vendor with this entry: (All demon trainers) 5815 / 5520 / 5753 / 6382 / 12807 / 16267 / 16649 / 23535

Hi, The spell learn by all profession trainers are not good in the npc_trainer_template. So, the core doesn't understand, the spell learn is a "ProfessionFirstRankSpell", so you can learn all profession. You must replace all wrong spell for all profession trainer.

Indeed. The SQL work only for one specific GUID. For the example it was "200100".

I edit the sql, so use it again please.

Use the SQL. I juste test it on my server, and it's works

gameobject_template: Set type = 1 (not 22) Faction = 0 gameobject_scripts: ID = GUID of the gameobject Sql: DELETE FROM `gameobject_template` WHERE `gameobject_template`.`entry` = 300000; DELETE FROM `gameobject` WHERE `gameobject`.`GUID` = 200100; DELETE FROM `gameobject_scripts` WHERE `gameobject_scripts`.`ID` = 200100; INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `ScriptName`) VALUES ('300000', '1', '4397', 'Portal to Azshara Crater', '', '', '0', '0', '1', '0', '0', '196608', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''); INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (200100, 300000, 1, 1, 16226.2, 16257, 13.2022, 1.65007, 0, 0, 0.734572, 0.678531, 25, 100, 0); INSERT INTO `gameobject_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES ('200100', '0', '6', '37', '0', '0', '0', '0', '0', '0', '0', '0', '1026.02', '286.68', '332.55', '0', 'Teleport to Azshara Crater'); For the exemple, the portal is located to gmisland

Hello, gameobject_template: Set: Type = 1 All Data = 0 Except Data2 = 196608 gameobject_scripts: Set: Command = 6 Then: datalong : Map ID And X/Y/Z/O coordinate