query remove npc by code

[Mr(X)]

http://store2.up-00.com/Nov11/kR723675.gif

انهارد حيبلكم query remove npc by code

http://store2.up-00.com/Nov11/1rs21705.gif

USE SRO_VT_SHARD go DECLARE @NPC (http://forum.ragezone.com/members/806871.html)_COMMON VARCHAR (129) SET @NPC (http://forum.ragezone.com/members/806871.html)_COMMON = 'PUT NPC OBJCOMMON NAME' --Npc Name /* get ID of NPC by code name */ Declare @NPC (http://forum.ragezone.com/members/806871.html)_ID int SET @NPC (http://forum.ragezone.com/members/806871.html)_ID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @NPC (http://forum.ragezone.com/members/806871.html)_COMMON) /* get Tactics ID of NPC by common id */ Declare @NPC (http://forum.ragezone.com/members/806871.html)_TID int SET @NPC (http://forum.ragezone.com/members/806871.html)_TID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @NPC (http://forum.ragezone.com/members/806871.html)_ID) /* delete NPC of refnest byTactics ID */ delete from Tab_RefNest WHERE dwTacticsID = @NPC (http://forum.ragezone.com/members/806871.html)_TID

http://store2.up-00.com/Nov11/SyC23690.gif

[Ayman shawky]

الله ينور ياريس :) تسلم ^^
بس مكانه مش هنا

[Mr(X)]

معلش اى مشرف ينقلو

[Shevo Manser]

طب ليه كل ده

ده صعب اوى انا هعمل موضوع يكون سهل

[Mr(X)]

ايه الى صعب انت هتحط الكود و هيمسح npc ?

[Hero]

ينقل

[Dallin]

ايه الى صعب انت هتحط الكود و هيمسح npc ?

anta kda rwsh y3ny ama t3ml fake name 3la mr.x l2a prince srsly

[Silver4NET]

يــــا بـــرنــــســــ دهــــ داتــــا بــــيــــز بـــســـ :swords:

[MyRȝturn]

الله ينور

[Mr(X)]

anta kda rwsh y3ny ama t3ml fake name 3la mr.x l2a prince srsly
bos ya zamel ana owner افندينا ™Hamboka™ بس acc و اخد بلوك فا عملت MR x و مبعملش fk name لى حد