[Archive] SQL 6xx For Alwyn: Make an NPC speak in SmartAI (EVENT_TEXT_OVER)
[Archive] SQL 6xx For Alwyn: Make an NPC speak in SmartAI (EVENT_TEXT_OVER)
11-04-2025, 05:04 PM
Original source
For more explian look this video thx =)
Demo SmartAI - EVENT_TEXT_OVER.f4v - YouTube
Creation of the NPC
Quote: REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `femaleName`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `exp_unk`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `HealthModifierExtra`, `ManaModifier`, `ManaModifierExtra`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUESCreation of the text assigned to the NPC 1000199
(1000199, 0, 0, 0, 0, 0, 26374, 26374, 0, 0, 'Alwyn', '', NULL, NULL, 0, 1, 1, 0, 0, 11, 0, 0.69999998807907, 0.69999998807907, 1, 0, 0, 3000, 3000, 1, 34, 2, 33685506, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 300, 'SmartAI', 2, 3, 1, 1, 1, 1, 1, 1, 1.2999999523163, 1, 0, 0, 1, 0, 2, '', 0);
Click to expand...
Quote: REPLACE INTO `creature_text` (` entry`, `groupid`,` id`, `text`,` type`, `language`,` probability`, `emote`,` duration`, `sound`,` BroadcastTextId`, `TextRange`,` comment`) VALUESSmall script to make the gnome speak
(1000199, 0, 0, "Bonjours toi la ... Welcome to a tutorial from the Aquayoup forum", 12, 0, 0, 14, 0, 0, 0, 0, "BlaBla 0 at spawn + emote show = 25" ),
(1000199, 1, 0, "It's me who speaks yes ... open your eyes and close your mouth STP", 12, 0, 0, 14, 0, 0, 0, 0, "BlaBla 1 + emote" ),
(1000199, 2, 0, "You see it's not difficult to make a gnome speak", 12, 0, 0, 21, 0, 0, 0, 0, "BlaBla 2 + emote"),
(1000199, 3, 0, "Just take inspiration from this script using EVENT_TEXT_OVER from the 2nd sentence", 12, 0, 0, 14, 0, 0, 0, 0, "BlaBla 3"),
(1000199, 4, 0, "this command is used to wait until the event that you specified for it is finished", 12, 0, 0, 21,0, 0, 0, 0, "BlaBla 4"),
(1000199, 5, 0, "and thus be able to say the following sentence in action", 12, 0, 0, 14, 0, 0, 0, 0, "BlaBla 5"),
(1000199, 6, 0, "you can also make speak another PNJ by this script in Target but it is necessary that the text which it will say is on its creature_text and not on that of this PNJ,", 12, 0, 0, 65, 0, 0, 0, 0, "BlaBla 6"),
(1000199, 7, 0, "... Well what is a bit hard is to procrastinate because it does not seem to be very fair.,", 12, 0, 0, 65, 0, 0, 0, 0, "BlaBla 7");
Click to expand...
Quote: - Alwyn SAIgood game =)
SET @ENTRY: = 1000199;
UPDATE `creature_template` SET` AIName` = "SmartAI" WHERE `entry` = @ ENTRY;
DELETE FROM `smart_scripts` WHERE` entryorguid` = @ ENTRY AND `source_type` = 0;
INSERT INTO `smart_scripts` (` entryorguid`, `source_type`,` id`, `link`,` event_type`, `event_phase_mask`,` event_chance`, `event_flags`,` event_param1`, `event_param2`,` event_param3`, `event_param4`,` action_type`, `action_param1`,` action_param2`, `action_param3`,` action_param4`, `action_param5`,` action_param6`, `target_type`,` target_param1`, `target_param2`,` target_param3`, `target_ `,` target_y`, `target_z`,` target_o`, `comment`) VALUES
(@ ENTRY, 0,10,0,11,0,100,0,0,0,0,0,1,0,6000,0,0,0,0,1,0,0,0,0,0,0, 0.0, "blah 0 with emote"),
(@ ENTRY, 0,11,0,52,0,100,0,0,1000199,0,0,1,1,8000,0,0,0,0,1,0,100,0,0,0,0, 0, "blabla 1"),
(@ ENTRY, 0.12.0.52.0.100.0.1.1000199.0.0.1.2.4000.0.0.0.0.1.0.100.0.0.0.0, 0, "blabla 2"),
(@ ENTRY, 0.13.0.52.0.100.0.2.1000199.0.0.1.3.1212.0.0.0.0.0.1.0.0.0.0.0, 0,0, "blabla 3"),
(@ ENTRY, 0,14,0,52,0,100,0,3,1000199,0,0,1,4,8000,0,0,0,0,1,0,0,0,0,0, 0,0, "blabla 4"),
(@ ENTRY, 0,15,0,52,0,100,0,4,1000199,0,0,1,5,8000,0,0,0,0,1,0,0,0,0,0, 0,0, "blabla 5"),
(@ ENTRY, 0,16,0,52,0,100,0,5,1000199,0,0,1,6,8000,0,0,0,0,1,0,0,0,0,0, 0,0, "blabla 6"),
(@ ENTRY, 0.17.0.52.0.100.0.6.1000199.0.0.1.7.8000.0.0.0.0.1.0.0.0.0.0, 0,0, "blabla 7"),
(@ ENTRY, 0.18,0.52.0,100.0.7.1000199.0.0.37.7.8000.0.0.0.0.1.0.0.0.0.0, 0.0, "Die");
Click to expand...
Credit to : Stitch from Aquayoup
rektbyfaith
11-04-2025, 05:04 PM #1Archived author: dokuro • Posted: 2025-11-04T18:04:35.689677
Original source
For more explian look this video thx =)
Demo SmartAI - EVENT_TEXT_OVER.f4v - YouTube
Creation of the NPC
Quote: REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `femaleName`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `exp_unk`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `HealthModifierExtra`, `ManaModifier`, `ManaModifierExtra`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUESCreation of the text assigned to the NPC 1000199
(1000199, 0, 0, 0, 0, 0, 26374, 26374, 0, 0, 'Alwyn', '', NULL, NULL, 0, 1, 1, 0, 0, 11, 0, 0.69999998807907, 0.69999998807907, 1, 0, 0, 3000, 3000, 1, 34, 2, 33685506, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 300, 'SmartAI', 2, 3, 1, 1, 1, 1, 1, 1, 1.2999999523163, 1, 0, 0, 1, 0, 2, '', 0);
Click to expand...
Quote: REPLACE INTO `creature_text` (` entry`, `groupid`,` id`, `text`,` type`, `language`,` probability`, `emote`,` duration`, `sound`,` BroadcastTextId`, `TextRange`,` comment`) VALUESSmall script to make the gnome speak
(1000199, 0, 0, "Bonjours toi la ... Welcome to a tutorial from the Aquayoup forum", 12, 0, 0, 14, 0, 0, 0, 0, "BlaBla 0 at spawn + emote show = 25" ),
(1000199, 1, 0, "It's me who speaks yes ... open your eyes and close your mouth STP", 12, 0, 0, 14, 0, 0, 0, 0, "BlaBla 1 + emote" ),
(1000199, 2, 0, "You see it's not difficult to make a gnome speak", 12, 0, 0, 21, 0, 0, 0, 0, "BlaBla 2 + emote"),
(1000199, 3, 0, "Just take inspiration from this script using EVENT_TEXT_OVER from the 2nd sentence", 12, 0, 0, 14, 0, 0, 0, 0, "BlaBla 3"),
(1000199, 4, 0, "this command is used to wait until the event that you specified for it is finished", 12, 0, 0, 21,0, 0, 0, 0, "BlaBla 4"),
(1000199, 5, 0, "and thus be able to say the following sentence in action", 12, 0, 0, 14, 0, 0, 0, 0, "BlaBla 5"),
(1000199, 6, 0, "you can also make speak another PNJ by this script in Target but it is necessary that the text which it will say is on its creature_text and not on that of this PNJ,", 12, 0, 0, 65, 0, 0, 0, 0, "BlaBla 6"),
(1000199, 7, 0, "... Well what is a bit hard is to procrastinate because it does not seem to be very fair.,", 12, 0, 0, 65, 0, 0, 0, 0, "BlaBla 7");
Click to expand...
Quote: - Alwyn SAIgood game =)
SET @ENTRY: = 1000199;
UPDATE `creature_template` SET` AIName` = "SmartAI" WHERE `entry` = @ ENTRY;
DELETE FROM `smart_scripts` WHERE` entryorguid` = @ ENTRY AND `source_type` = 0;
INSERT INTO `smart_scripts` (` entryorguid`, `source_type`,` id`, `link`,` event_type`, `event_phase_mask`,` event_chance`, `event_flags`,` event_param1`, `event_param2`,` event_param3`, `event_param4`,` action_type`, `action_param1`,` action_param2`, `action_param3`,` action_param4`, `action_param5`,` action_param6`, `target_type`,` target_param1`, `target_param2`,` target_param3`, `target_ `,` target_y`, `target_z`,` target_o`, `comment`) VALUES
(@ ENTRY, 0,10,0,11,0,100,0,0,0,0,0,1,0,6000,0,0,0,0,1,0,0,0,0,0,0, 0.0, "blah 0 with emote"),
(@ ENTRY, 0,11,0,52,0,100,0,0,1000199,0,0,1,1,8000,0,0,0,0,1,0,100,0,0,0,0, 0, "blabla 1"),
(@ ENTRY, 0.12.0.52.0.100.0.1.1000199.0.0.1.2.4000.0.0.0.0.1.0.100.0.0.0.0, 0, "blabla 2"),
(@ ENTRY, 0.13.0.52.0.100.0.2.1000199.0.0.1.3.1212.0.0.0.0.0.1.0.0.0.0.0, 0,0, "blabla 3"),
(@ ENTRY, 0,14,0,52,0,100,0,3,1000199,0,0,1,4,8000,0,0,0,0,1,0,0,0,0,0, 0,0, "blabla 4"),
(@ ENTRY, 0,15,0,52,0,100,0,4,1000199,0,0,1,5,8000,0,0,0,0,1,0,0,0,0,0, 0,0, "blabla 5"),
(@ ENTRY, 0,16,0,52,0,100,0,5,1000199,0,0,1,6,8000,0,0,0,0,1,0,0,0,0,0, 0,0, "blabla 6"),
(@ ENTRY, 0.17.0.52.0.100.0.6.1000199.0.0.1.7.8000.0.0.0.0.1.0.0.0.0.0, 0,0, "blabla 7"),
(@ ENTRY, 0.18,0.52.0,100.0.7.1000199.0.0.37.7.8000.0.0.0.0.1.0.0.0.0.0, 0.0, "Die");
Click to expand...
Credit to : Stitch from Aquayoup
11-04-2025, 05:04 PM
Original source
Thanks, very usefull to know.
rektbyfaith
11-04-2025, 05:04 PM #2Archived author: dokuro • Posted: 2025-11-04T18:04:35.689677
Original source
Thanks, very usefull to know.
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)