[DiscordArchive] <@!831495913028452424> I think this is the only way, definitely not the best way to do this. Are you
[DiscordArchive] <@!831495913028452424> I think this is the only way, definitely not the best way to do this. Are you
Original source
<@!831495913028452424> I think this is the only way, definitely not the best way to do this. Are you scripting something blizzlike or custom?
![[Image: unknown.png?ex=690c6346&is=690b11c6&hm=3...de6216c3d&]](https://cdn.discordapp.com/attachments/376074477114490890/839788272087859240/unknown.png?ex=690c6346&is=690b11c6&hm=38208b7f9a8967190cf63a31fd6143d57351a28869c85e4f1172eadde6216c3d&)
rektbyfaith
05-06-2021, 08:58 AM #1Archived author: bandysc • Posted: 2021-05-06T08:58:47.176000+00:00
Original source
<@!831495913028452424> I think this is the only way, definitely not the best way to do this. Are you scripting something blizzlike or custom?
Original source
I'm trying to get some non functional blizz content working. Since i'm really bad in C++, SQL is the only way to go for me
rektbyfaith
05-06-2021, 09:03 AM #2Archived author: subsix • Posted: 2021-05-06T09:03:50.907000+00:00
Original source
I'm trying to get some non functional blizz content working. Since i'm really bad in C++, SQL is the only way to go for me
Original source
so that's the best you can get from gameobject SAI
rektbyfaith
05-06-2021, 09:05 AM #3Archived author: bandysc • Posted: 2021-05-06T09:05:05.563000+00:00
Original source
so that's the best you can get from gameobject SAI
Original source
Seems not to work
`SET @ENTRY := 364374;
DELETE FROM smart_scripts WHERE entryOrGuid = 364374 AND source_type = 1;
UPDATE gameobject_template SET AIName="SmartGameObjectAI" WHERE entry=@ENTRY;
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_x, target_y, target_z, target_o, comment) VALUES
(@ENTRY, 1, 0, 0, 60, 0, 100, 0, 1000, 1000, 0, 0, 62, 2453, 0, 0, 0, 0, 0, 21, 10, 0, 0, 1646.56, 2318.66, 380.96, 4.70021, "Time = 1 seconds - None: Teleport to (1646.56, 2318.66, 380.96, 4.70021) on map 2453");
`
rektbyfaith
05-06-2021, 09:06 AM #4Archived author: subsix • Posted: 2021-05-06T09:06:04.181000+00:00
Original source
Seems not to work
`SET @ENTRY := 364374;
DELETE FROM smart_scripts WHERE entryOrGuid = 364374 AND source_type = 1;
UPDATE gameobject_template SET AIName="SmartGameObjectAI" WHERE entry=@ENTRY;
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_x, target_y, target_z, target_o, comment) VALUES
(@ENTRY, 1, 0, 0, 60, 0, 100, 0, 1000, 1000, 0, 0, 62, 2453, 0, 0, 0, 0, 0, 21, 10, 0, 0, 1646.56, 2318.66, 380.96, 4.70021, "Time = 1 seconds - None: Teleport to (1646.56, 2318.66, 380.96, 4.70021) on map 2453");
`
Original source
repeat minimum and repeat meximum also needs to be set to 1000
rektbyfaith
05-06-2021, 09:06 AM #5Archived author: bandysc • Posted: 2021-05-06T09:06:40.740000+00:00
Original source
repeat minimum and repeat meximum also needs to be set to 1000
Original source
otherwise the event will be executed only once (when object timer is more or less 1 second)
rektbyfaith
05-06-2021, 09:07 AM #6Archived author: bandysc • Posted: 2021-05-06T09:07:00.324000+00:00
Original source
otherwise the event will be executed only once (when object timer is more or less 1 second)
Original source
Ah that makes sense
rektbyfaith
05-06-2021, 09:07 AM #7Archived author: subsix • Posted: 2021-05-06T09:07:16.171000+00:00
Original source
Ah that makes sense
1 Guest(s)
1 Guest(s)