Delete NPC

[hodamoseba]

لو فية query او اى حاجة امسح بيها npc من الجيم خالص ويطلع لاين المديا عاوز امسح npc بل ايتم اللى فيه:groupwave:

[F77]

خش شيل المكان بتاعه من الداتا بس من تاب
Tab_RefNest

[افندينا ™Hamboka™]

USE SRO_VT_SHARD go DECLARE @NPC_COMMON VARCHAR (129) SET @NPC_COMMON = 'PUT NPC OBJCOMMON NAME' --Npc Name /* get ID of NPC by code name */ Declare @NPC_ID int SET @NPC_ID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @NPC_COMMON) /* get Tactics ID of NPC by common id */ Declare @NPC_TID int SET @NPC_TID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @NPC_ID) /* delete NPC of refnest byTactics ID */ delete from Tab_RefNest WHERE dwTacticsID = @NPC_TID

[Scrox]

جيب id بتاعت ال npc واستخدام الكيورى دى

USE SRO_VT_SHARD
delete from Tab_RefNest
where dwTacticsID=(Select dwTacticsID from Tab_RefTactics where dwObjID='12345')

[hodamoseba]

تمام شكرا

[Scrox]

##