[DiscordArchive] I've got another sort-of newbie question. I've ...
[DiscordArchive] I've got another sort-of newbie question. I've ...
Original source
rektbyfaith
02-28-2025, 12:26 AM #1Archived author: Needle • Posted: 2025-02-28T00:26:39.915000+00:00
Original source
Original source
rektbyfaith
02-28-2025, 12:26 AM #2Archived author: Needle • Posted: 2025-02-28T00:26:40.921000+00:00
Original source
Original source
```INSERT INTO creature_template (entry, name, subname, minlevel, maxlevel, faction, npcflag, speed_walk, speed_run, scale, `rank`, dmgschool, BaseAttackTime, RangeAttackTime, unit_class, unit_flags, unit_flags2, dynamicflags, family, type, type_flags, lootid, pickpocketloot, skinloot, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, HoverHeight, HealthModifier, ManaModifier, DamageModifier, ArmorModifier, ExperienceModifier, RacialLeader, RegenHealth, mechanic_immune_mask, flags_extra, modelid1, modelid2, modelid3, modelid4, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3)
VALUES (50002, 'Grubnik', 'Reluctant Digger', 80, 80, 35, 131, 1.1, 1.17, 1, 0, 0, 1500, 2000, 1, 3, 0, 1, 0, 7, 80, 0, 0, 0, 0, 0, 0, 0, 'NullAI', 0, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 373, 0, 0, 0, 0, 0, 0);
INSERT INTO creature_template_addon (mount, StandState, emote, auras, entry) VALUES (0, 0, 233, '', 50002);
INSERT INTO creature_equip_template (ItemID1, ItemID2, ItemID3, CreatureID) VALUES (2901, 0, 0, 50002);
INSERT INTO creature_template_movement (CreatureID, Ground, Swim, Flight) VALUES (50002, 1, 1, 0);
INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES (57033, 50017, 0);
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `BroadcastTextID0`, `lang0`, `Probability0`, `EmoteDelay0_0`, `Emote0_0`, `EmoteDelay0_1`, `Emote0_1`, `EmoteDelay0_2`, `Emote0_2`, `text1_0`, `text1_1`, `BroadcastTextID1`, `lang1`, `Probability1`, `EmoteDelay1_0`, `Emote1_0`, `EmoteDelay1_1`, `Emote1_1`, `EmoteDelay1_2`, `Emote1_2`, `text2_0`, `text2_1`, `BroadcastTextID2`, `lang2`, `Probability2`, `EmoteDelay2_0`, `Emote2_0`, `EmoteDelay2_1`, `Emote2_1`, `EmoteDelay2_2`, `Emote2_2`, `text3_0`, `text3_1`, `BroadcastTextID3`, `lang3`, `Probability3`, `EmoteDelay3_0`, `Emote3_0`, `EmoteDelay3_1`, `Emote3_1`, `EmoteDelay3_2`, `Emote3_2`, `text4_0`, `text4_1`, `BroadcastTextID4`, `lang4`, `Probability4`, `EmoteDelay4_0`, `Emote4_0`, `EmoteDelay4_1`, `Emote4_1`, `EmoteDelay4_2`, `Emote4_2`, `text5_0`, `text5_1`, `BroadcastTextID5`, `lang5`, `Probability5`, `EmoteDelay5_0`, `Emote5_0`, `EmoteDelay5_1`, `Emote5_1`, `EmoteDelay5_2`, `Emote5_2`, `text6_0`, `text6_1`, `BroadcastTextID6`, `lang6`, `Probability6`, `EmoteDelay6_0`, `Emote6_0`, `EmoteDelay6_1`, `Emote6_1`, `EmoteDelay6_2`, `Emote6_2`, `text7_0`, `text7_1`, `BroadcastTextID7`, `lang7`, `Probability7`, `EmoteDelay7_0`, `Emote7_0`, `EmoteDelay7_1`, `Emote7_1`, `EmoteDelay7_2`, `Emote7_2`, `VerifiedBuild`)
VALUES (
50017, 'Grubnik text', '', 77867, 0, 1, 0, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `broadcast_text` (
`ID`, `LanguageID`, `Text`, `Text1`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `SoundEntriesID`, `EmotesID`, `Flags`, `VerifiedBuild`)
VALUES (77867, 0, "Mining? More like slave labor! Been stuck here for weeks now, digging up whatever I can find. The boss says I gotta meet quotas, but my back's killing me.", '', 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);
UPDATE `world`.`creature_template` SET `gossip_menu_id`=57033 WHERE `entry`=50002;```
rektbyfaith
02-28-2025, 12:27 AM #3Archived author: Go • Posted: 2025-02-28T00:27:31.921000+00:00
Original source
```INSERT INTO creature_template (entry, name, subname, minlevel, maxlevel, faction, npcflag, speed_walk, speed_run, scale, `rank`, dmgschool, BaseAttackTime, RangeAttackTime, unit_class, unit_flags, unit_flags2, dynamicflags, family, type, type_flags, lootid, pickpocketloot, skinloot, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, HoverHeight, HealthModifier, ManaModifier, DamageModifier, ArmorModifier, ExperienceModifier, RacialLeader, RegenHealth, mechanic_immune_mask, flags_extra, modelid1, modelid2, modelid3, modelid4, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3)
VALUES (50002, 'Grubnik', 'Reluctant Digger', 80, 80, 35, 131, 1.1, 1.17, 1, 0, 0, 1500, 2000, 1, 3, 0, 1, 0, 7, 80, 0, 0, 0, 0, 0, 0, 0, 'NullAI', 0, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 373, 0, 0, 0, 0, 0, 0);
INSERT INTO creature_template_addon (mount, StandState, emote, auras, entry) VALUES (0, 0, 233, '', 50002);
INSERT INTO creature_equip_template (ItemID1, ItemID2, ItemID3, CreatureID) VALUES (2901, 0, 0, 50002);
INSERT INTO creature_template_movement (CreatureID, Ground, Swim, Flight) VALUES (50002, 1, 1, 0);
INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES (57033, 50017, 0);
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `BroadcastTextID0`, `lang0`, `Probability0`, `EmoteDelay0_0`, `Emote0_0`, `EmoteDelay0_1`, `Emote0_1`, `EmoteDelay0_2`, `Emote0_2`, `text1_0`, `text1_1`, `BroadcastTextID1`, `lang1`, `Probability1`, `EmoteDelay1_0`, `Emote1_0`, `EmoteDelay1_1`, `Emote1_1`, `EmoteDelay1_2`, `Emote1_2`, `text2_0`, `text2_1`, `BroadcastTextID2`, `lang2`, `Probability2`, `EmoteDelay2_0`, `Emote2_0`, `EmoteDelay2_1`, `Emote2_1`, `EmoteDelay2_2`, `Emote2_2`, `text3_0`, `text3_1`, `BroadcastTextID3`, `lang3`, `Probability3`, `EmoteDelay3_0`, `Emote3_0`, `EmoteDelay3_1`, `Emote3_1`, `EmoteDelay3_2`, `Emote3_2`, `text4_0`, `text4_1`, `BroadcastTextID4`, `lang4`, `Probability4`, `EmoteDelay4_0`, `Emote4_0`, `EmoteDelay4_1`, `Emote4_1`, `EmoteDelay4_2`, `Emote4_2`, `text5_0`, `text5_1`, `BroadcastTextID5`, `lang5`, `Probability5`, `EmoteDelay5_0`, `Emote5_0`, `EmoteDelay5_1`, `Emote5_1`, `EmoteDelay5_2`, `Emote5_2`, `text6_0`, `text6_1`, `BroadcastTextID6`, `lang6`, `Probability6`, `EmoteDelay6_0`, `Emote6_0`, `EmoteDelay6_1`, `Emote6_1`, `EmoteDelay6_2`, `Emote6_2`, `text7_0`, `text7_1`, `BroadcastTextID7`, `lang7`, `Probability7`, `EmoteDelay7_0`, `Emote7_0`, `EmoteDelay7_1`, `Emote7_1`, `EmoteDelay7_2`, `Emote7_2`, `VerifiedBuild`)
VALUES (
50017, 'Grubnik text', '', 77867, 0, 1, 0, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `broadcast_text` (
`ID`, `LanguageID`, `Text`, `Text1`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `SoundEntriesID`, `EmotesID`, `Flags`, `VerifiedBuild`)
VALUES (77867, 0, "Mining? More like slave labor! Been stuck here for weeks now, digging up whatever I can find. The boss says I gotta meet quotas, but my back's killing me.", '', 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);
UPDATE `world`.`creature_template` SET `gossip_menu_id`=57033 WHERE `entry`=50002;```
Original source
```
INSERT INTO npc_vendor (entry, item, slot, maxcount, incrtime, ExtendedCost) VALUES (50002, 60000, 0, 50, 6, 0);
INSERT INTO npc_vendor (entry, item, slot, maxcount, incrtime, ExtendedCost) VALUES (50002, 60002, 1, 5, 20, 0);
INSERT INTO npc_vendor (entry, item, slot, maxcount, incrtime, ExtendedCost) VALUES (50002, 60003, 2, 1, 60, 0);
-- gossip menu option
INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`)
VALUES (57033, 0, 1, "How's the mining going?", 77868, 3, 128, 0, 0, 0, 0, '', 0, 0);
-- tried flags 128, 2, and 0
-- broadcast text id
INSERT INTO `broadcast_text` (
`ID`, `LanguageID`, `Text`, `Text1`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `SoundEntriesID`, `EmotesID`, `Flags`, `VerifiedBuild`)
VALUES (77868, 0, "How's the mining going?", '', 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);````
rektbyfaith
02-28-2025, 12:27 AM #4Archived author: Go • Posted: 2025-02-28T00:27:37.820000+00:00
Original source
```
INSERT INTO npc_vendor (entry, item, slot, maxcount, incrtime, ExtendedCost) VALUES (50002, 60000, 0, 50, 6, 0);
INSERT INTO npc_vendor (entry, item, slot, maxcount, incrtime, ExtendedCost) VALUES (50002, 60002, 1, 5, 20, 0);
INSERT INTO npc_vendor (entry, item, slot, maxcount, incrtime, ExtendedCost) VALUES (50002, 60003, 2, 1, 60, 0);
-- gossip menu option
INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`)
VALUES (57033, 0, 1, "How's the mining going?", 77868, 3, 128, 0, 0, 0, 0, '', 0, 0);
-- tried flags 128, 2, and 0
-- broadcast text id
INSERT INTO `broadcast_text` (
`ID`, `LanguageID`, `Text`, `Text1`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `SoundEntriesID`, `EmotesID`, `Flags`, `VerifiedBuild`)
VALUES (77868, 0, "How's the mining going?", '', 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);````
Original source
My ultimate goal is to make this shopping dialogue also gated by a quest, which would have to be completed before the shop option would be accessable.
rektbyfaith
02-28-2025, 12:28 AM #5Archived author: Go • Posted: 2025-02-28T00:28:39.800000+00:00
Original source
My ultimate goal is to make this shopping dialogue also gated by a quest, which would have to be completed before the shop option would be accessable.
Original source
This can be done super easly with eluna
rektbyfaith
02-28-2025, 07:49 AM #6Archived author: thunder • Posted: 2025-02-28T07:49:06.990000+00:00
Original source
This can be done super easly with eluna
Original source
With sql too but i have no fucking idea how
rektbyfaith
02-28-2025, 07:49 AM #7Archived author: thunder • Posted: 2025-02-28T07:49:23.937000+00:00
Original source
With sql too but i have no fucking idea how
Original source
type_flags 134217728 CREATURE_TYPE_FLAG_FORCE_GOSSIP
then delete cache
rektbyfaith
02-28-2025, 08:19 AM #8Archived author: john • Posted: 2025-02-28T08:19:39.328000+00:00
Original source
type_flags 134217728 CREATURE_TYPE_FLAG_FORCE_GOSSIP
then delete cache
Original source
Thank you!
rektbyfaith
02-28-2025, 01:35 PM #9Archived author: Go • Posted: 2025-02-28T13:35:14.036000+00:00
Original source
Thank you!
1 Guest(s)
1 Guest(s)