حذف NPC

[الجوكر]

السلام عليكم ورحمة الله وبركاته

ممكن اعرف ازاى احذف NPC

وشكرا للاعضاء والمشرفين الكرام

[Dangers SrO]

ال query دي هتميحولك

USE SRO_VT_SHARD
go
DECLARE @NPC_COMMON VARCHAR (129)
SET @NPC_COMMON = 'NamE NpC Here' --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

[Xan]

برجاء الأهتمام بالموضوع

#يغلق

[Dangers SrO]

##