29-12-2017, 05:31 AM
|
#3
|
|
• الانـتـسـاب » Sep 2012
|
• رقـم العـضـويـة » 105765
|
• المشـــاركـات » 3,016
|
• الـدولـة » تحت البحر
|
• الـهـوايـة » hack Site
|
• اسـم الـسـيـرفـر » No Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 25
|
|
|
رد: Delete NPC
كود PHP:
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
|
|
|