Neocraft
-
Posts
8 -
Joined
-
Last visited
Never -
Donations
0.00 GBP
Content Type
Profiles
Bug Tracker
Wiki
Release Notes
Forums
Downloads
Blogs
Events
Posts posted by Neocraft
-
-
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
But how object template will know about object_script? I have to add object_cript ID somwhere in object_template?
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
Problem with demon trainers.
in OldGeneral support
Posted
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.