[DiscordArchive] <@!345123879272054786> which language are you going to write that in ?
[DiscordArchive] <@!345123879272054786> which language are you going to write that in ?
Original source
<@!345123879272054786> which language are you going to write that in ?
rektbyfaith
12-31-2020, 08:06 PM #1Archived author: jackpoz • Posted: 2020-12-31T20:06:45.653000+00:00
Original source
<@!345123879272054786> which language are you going to write that in ?
Original source
```sql
SET SESSION group_concat_max_len = 4096;
SET @id := 51;
SELECT CONCAT("SET @NPC := ", @id, ";", "\n"
"SET @PATH := @NPC * 10;", "\n"
"DELETE FROM `creature_addon` WHERE `guid` IN (@NPC);", "\n",
"INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES ",
(
SELECT GROUP_CONCAT("\n(", `id`, ",", `point`, ",", `position_x`, ",", `position_y`, ",", `position_z`, ",", `orientation`, ",", `delay`, ",", `move_type`, ",", `action`, ",", `action_chance`, ",", `wpguid`, ")")
FROM waypoint_data
WHERE id=@id*10
), ";", "\n",
"UPDATE `creature` SET `position_x` = (SELECT `position_x` FROM `waypoint_data` WHERE `id` = @PATH AND `point` = 1) , `position_y` = (SELECT `position_y` FROM `waypoint_data` WHERE `id` = @PATH AND `point` = 1) , `position_z` = (SELECT `position_z` FROM `waypoint_data` WHERE `id` = @PATH AND `point` = 1) , `spawndist`=0,`MovementType`=2 WHERE `guid` IN (@NPC);")
FROM waypoint_data
WHERE id=@id*10
LIMIT 1;
```
<@!345123879272054786> this sql will give you what you want
rektbyfaith
12-31-2020, 08:33 PM #2Archived author: jackpoz • Posted: 2020-12-31T20:33:50.044000+00:00
Original source
```sql
SET SESSION group_concat_max_len = 4096;
SET @id := 51;
SELECT CONCAT("SET @NPC := ", @id, ";", "\n"
"SET @PATH := @NPC * 10;", "\n"
"DELETE FROM `creature_addon` WHERE `guid` IN (@NPC);", "\n",
"INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES ",
(
SELECT GROUP_CONCAT("\n(", `id`, ",", `point`, ",", `position_x`, ",", `position_y`, ",", `position_z`, ",", `orientation`, ",", `delay`, ",", `move_type`, ",", `action`, ",", `action_chance`, ",", `wpguid`, ")")
FROM waypoint_data
WHERE id=@id*10
), ";", "\n",
"UPDATE `creature` SET `position_x` = (SELECT `position_x` FROM `waypoint_data` WHERE `id` = @PATH AND `point` = 1) , `position_y` = (SELECT `position_y` FROM `waypoint_data` WHERE `id` = @PATH AND `point` = 1) , `position_z` = (SELECT `position_z` FROM `waypoint_data` WHERE `id` = @PATH AND `point` = 1) , `spawndist`=0,`MovementType`=2 WHERE `guid` IN (@NPC);")
FROM waypoint_data
WHERE id=@id*10
LIMIT 1;
```
<@!345123879272054786> this sql will give you what you want
1 Guest(s)
1 Guest(s)