Skip to content

npcflock updates select definition ID but do not use it in update #28

@Bler

Description

@Bler

See code below. DefinitionID is set but then not used in update
SET @definitionID = (SELECT TOP 1 definition from entitydefaults WHERE [definitionname] = 'def_npc_laird_basic_rank1' ORDER BY definition DESC); SET @flockID = (SELECT TOP 1 id from npcflock WHERE [name] = 'laird_by_terminal' ORDER BY id DESC); UPDATE [dbo].[npcflock] SET [name] = 'laird_by_terminal' ,[presenceid] = @presenceID, [flockmembercount] = 4, [definition] = 2402, [spawnoriginX] = 1120, [spawnoriginY] = 920 ,[spawnrangeMin] = 0, [spawnrangeMax] = 5,[respawnseconds] = 60, [totalspawncount] = 0, [homerange] = 15 ,[note] = 'laird_by_terminal', [respawnmultiplierlow] = 1, [enabled] = 1, [iscallforhelp] = 0, [behaviorType] = 1 WHERE id=@flockID;

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions