vSRO Paylaşım Yeni Npc ekleme query,Npc Yönleri,Npc Taşıma Queryleri

Admin1

Admin1

silkroadpvp.com.tr
Yönetici
Katılım
26 Ocak 2022
Mesajlar
511
Tepkime puanı
1
Puanları
0
Konum
KRAL
--YENİ NPC EKLEME QUERY
[HIDE]
/* NPC QUERY FIXED BY SWAGGER1337 */

USE [SRO_VT_SHARD]
GO

DECLARE @CHARNAME VARCHAR (30)
DECLARE @NPCNAME VARCHAR (30)
DECLARE @NPCNAME_INGAME VARCHAR (30) , @NPCGROUP_NAME VARCHAR (30)
DECLARE @ADDNEW VARCHAR (30)
DECLARE @TAB1NAME VARCHAR (30) , @TAB2NAME VARCHAR (30) , @TAB3NAME VARCHAR (30) , @TAB4NAME VARCHAR (30)
DECLARE @TAB1 VARCHAR (30) , @TAB2 VARCHAR (30) , @TAB3 VARCHAR (30) , @TAB4 VARCHAR (30)
DECLARE @TABNUMBER INT , @npcBSR VARCHAR (50) , @npcChat VARCHAR (MAX)
/* DATABASE */
SET @CHARNAME = 'QQ' /* Charname , to get npc location */
SET @NPCNAME = 'NEW_AVATARS' /* NPC Name , try to name it: xxx , do not name it NPC_xxx */
SET @TABNUMBER = 3 -- Max 4 tabs , Credits goes to SWAGGER1337.
SET @TAB1 = 'DRESS' /* First Tab */
SET @TAB2 = 'HAT' /* Second Tab */
SET @TAB3 = 'ATTACH' /* Third Tab */
SET @TAB4 = 'Flags' /* Forth Tab */
SET @ADDNEW = 'NPC' /* Leave IT Please */
/* DATABASE */
/* IN GAME OPTIONS */
SET @NPCNAME_INGAME = 'NEW AVATARS' /* NPC in game name */
SET @NPCGROUP_NAME = 'New Avatars' /* Group in npc inside game name */
SET @TAB1NAME = 'DRESS' /* Tab1 in game name */
SET @TAB2NAME = 'HAT' /* Tab2 in game name */
SET @TAB3NAME = 'ATTACH' /* Tab3 in game name */
SET @TAB4NAME = 'Flags' /* Tab4 in game name */
SET @npcChat = 'Welcome in New Avatars Shop' /* npc chat, welcome message or anything you want */
SET @npcBSR = 'npc\npc\chinawoman_Noblegirl_event.bsr' /* do not edit if you don't know what is it */
--
IF @ADDNEW = 'NPC' BEGIN
DECLARE @MAXLINK VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjChar)+1
DECLARE @MAXCOMMONID VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjCommon)+1
SET IDENTITY_INSERT _RefObjCommon ON
INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country
,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius
,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES
(1,@MAXCOMMONID,'NPC_'+@NPCNAME,'xxx','xxx','SN_NPC_'+@NPCNAME,'xxx',0,1,1,2,2,0,5000,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,@npcBSR,'xxx','xxx','xxx','xxx',@MAXLINK)
SET IDENTITY_INSERT _RefObjCommon OFF
SET IDENTITY_INSERT _RefObjChar ON
INSERT INTO _RefObjChar (ID,Lvl,CharGender,MaxHP,MaxMP,ResistFrozen,ResistFrostbite,ResistBurn,ResistEShock,ResistPoison,ResistZombie,ResistSleep,ResistRoot,ResistSlow,ResistFear
,ResistMyopia,ResistBlood,ResistStone,ResistDark,ResistStun,ResistDisea,ResistChaos,ResistCsePD,ResistCseMD,ResistCseSTR,ResistCseINT,ResistCseHP,ResistCseMP,Resist24,ResistBomb,Resist26
,Resist27,Resist28,Resist29,Resist30,Resist31,Resist32,InventorySize,CanStore_TID1,CanStore_TID2,CanStore_TID3,CanStore_TID4,CanBeVehicle,CanControl,DamagePortion,MaxPassenger,AssocTactics,PD,MD,PAR,MAR,ER,BR,HR,CHR
,ExpToGive,CreepType,Knockdown,KO_RecoverTime,DefaultSkill_1,DefaultSkill_2,DefaultSkill_3,DefaultSkill_4,DefaultSkill_5,DefaultSkill_6,DefaultSkill_7,DefaultSkill_8,DefaultSkill_9,DefaultSkill_10,TextureType,Except_1
,Except_2,Except_3,Except_4,Except_5,Except_6,Except_7,Except_8,Except_9,Except_10,Link) VALUES
(@MAXLINK,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,336860180,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
SET IDENTITY_INSERT _RefObjChar OFF
SET IDENTITY_INSERT _RefShop ON
DECLARE @ShopID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShop)+1
INSERT INTO _RefShop (Service,Country,ID,CodeName128,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15,@ShopID,'STORE_'+@NPCNAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
SET IDENTITY_INSERT _RefShop OFF
SET IDENTITY_INSERT _RefShopGroup ON
DECLARE @ShopGroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopGroup)+1
INSERT INTO _RefShopGroup (Service,Country,ID,CodeName128,RefNPCCodeName,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15,@ShopGroupID,'GROUP_STORE_'+@NPCNAME,'NPC_'+@NPCNAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
SET IDENTITY_INSERT _RefShopGroup OFF
SET IDENTITY_INSERT _RefShopItemGroup ON
DECLARE @ShopItemID VARCHAR (30) = (SELECT MAX (GROUPID) FROM _RefShopItemGroup)+1
INSERT INTO _RefShopItemGroup (Service,GroupID,CodeName128,StrID128_Group)
VALUES (1,@ShopItemID,'STORE_'+@NPCNAME+'_GROUP1','SN_STORE_'+@NPCNAME+'_GROUP1')
SET IDENTITY_INSERT _RefShopItemGroup OFF
SET IDENTITY_INSERT _RefShopTab ON
DECLARE @ShopTabID1 VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+1
DECLARE @ShopTabID2 VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+2
DECLARE @ShopTabID3 VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+3
DECLARE @ShopTabID4 VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+4
/* TAB FUNCTION */
IF (@TABNUMBER = 1)
BEGIN
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15,@ShopTabID1,'STORE_'+@NPCNAME+'_TAB1','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB1+'')
end
IF (@TABNUMBER = 2)
BEGIN
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15,@ShopTabID1,'STORE_'+@NPCNAME+'_TAB1','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB1+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15,@ShopTabID2,'STORE_'+@NPCNAME+'_TAB2','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB2+'')
END
IF (@TABNUMBER = 3)
BEGIN
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15,@ShopTabID1,'STORE_'+@NPCNAME+'_TAB1','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB1+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15,@ShopTabID2,'STORE_'+@NPCNAME+'_TAB2','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB2+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15,@ShopTabID3,'STORE_'+@NPCNAME+'_TAB3','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB3+'')
END
IF (@TABNUMBER = 4)
BEGIN
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15,@ShopTabID1,'STORE_'+@NPCNAME+'_TAB1','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB1+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15,@ShopTabID2,'STORE_'+@NPCNAME+'_TAB2','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB2+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15,@ShopTabID3,'STORE_'+@NPCNAME+'_TAB3','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB3+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15,@ShopTabID4,'STORE_'+@NPCNAME+'_TAB4','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB4+'')
END
/* Tab End */
SET IDENTITY_INSERT _RefShopTab OFF
SET IDENTITY_INSERT _RefShopTabGroup ON
DECLARE @ShopTabGroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopTabGroup)+1
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group)
VALUES (1,15,@ShopTabGroupID,'STORE_'+@NPCNAME+'_GROUP1','SN_STORE_'+@NPCNAME+'_GROUP1')
SET IDENTITY_INSERT _RefShopTabGroup OFF
INSERT INTO _RefMappingShopGroup VALUES (1,15,'GROUP_STORE_'+@NPCNAME,'STORE_'+@NPCNAME)
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'+@NPCNAME,'STORE_'+@NPCNAME+'_GROUP1')
DECLARE @TACTICSID INT SET @TACTICSID = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+10
INSERT INTO Tab_RefTactics VALUES
(@TACTICSID,@MAXCOMMONID,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'NPC_'+@NPCNAME)
BEGIN
DECLARE @HIVEID INT SET @HIVEID = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
INSERT INTO Tab_RefHive VALUES
(@HIVEID,0,0,0,0,0,0,1,2,'NPC_'+@NPCNAME)
END
BEGIN
DECLARE @REGION VARCHAR (30) SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX VARCHAR (30) SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSY VARCHAR (30) SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSZ VARCHAR (30) SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @NESTID INT SET @NESTID = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
INSERT INTO Tab_RefNest VALUES
(@NESTID,@HIVEID,@TACTICSID,@REGION,@POSX,@POSY,@POSZ,0,0,0,0,0,0,1,0,1,0)
END
PRINT 'add this line to characterdata_45000 @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 '+@MAXCOMMONID+' NPC_'+@NPCNAME+' xxx xxx '+'SN_NPC_'+@NPCNAME+' xxx 0 1 1 2 2 0 5000 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 '+@npcBSR+' xxx xxx xxx xxx 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 336860180 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
PRINT ''
PRINT 'Add this line to refshop.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 '+@SHOPID+' '+'STORE_'+@NPCNAME+' -1 xxx -1 xxx -1 xxx -1 xxx'
PRINT ''
PRINT 'Add this line to refshopgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 '+@SHOPGROUPID+' '+'GROUP_STORE_'+@NPCNAME+' '+'NPC_'+@NPCNAME+' -1 xxx -1 xxx -1 xxx -1 xxx'
PRINT ''
PRINT 'Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 '+@SHOPITEMID+' '+'STORE_'+@NPCNAME+'_GROUP1 '+'SN_STORE_'+@NPCNAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to npcchat.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 '+'NPC_'+@NPCNAME+' '+'SN_NPC_'+@NPCNAME+'_BS '+'SN_NPC_'+@NPCNAME+'_PS'
PRINT ''
PRINT 'Add this line to textquest_speech&name.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 SN_NPC_'+@NPCNAME+'_BS '+@npcChat+''
PRINT ''
PRINT 'Add this line to textdata_object.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 SN_NPC_'+@NPCNAME+' '+@NPCNAME_INGAME+''
PRINT ''
PRINT 'Add this lines to textuisystem.txt @ server_dep\silkroad\textdata'
PRINT ''
IF (@TABNUMBER = 1)
BEGIN
PRINT '1 SN_TAB_'+@TAB1+' ?? 0 0 0 0 0 '+@TAB1NAME+' '+@TAB1NAME+' 0 0 0 0 0 0'
PRINT '1 SN_STORE_'+@NPCNAME+'_GROUP1 ?? ?? ??/?? 0 0 0 0 0 '+@NPCGROUP_NAME+' '+@NPCGROUP_NAME+' 0 0 0 0 0 0'
end
IF (@TABNUMBER = 2)
BEGIN
PRINT '1 SN_TAB_'+@TAB1+' ?? 0 0 0 0 0 '+@TAB1NAME+' '+@TAB1NAME+' 0 0 0 0 0 0'
PRINT '1 SN_TAB_'+@TAB2+' ?? 0 0 0 0 0 '+@TAB2NAME+' '+@TAB2NAME+' 0 0 0 0 0 0'
PRINT '1 SN_STORE_'+@NPCNAME+'_GROUP1 ?? ?? ??/?? 0 0 0 0 0 '+@NPCGROUP_NAME+' '+@NPCGROUP_NAME+' 0 0 0 0 0 0'
END
IF (@TABNUMBER = 3)
BEGIN
PRINT '1 SN_TAB_'+@TAB1+' ?? 0 0 0 0 0 '+@TAB1NAME+' '+@TAB1NAME+' 0 0 0 0 0 0'
PRINT '1 SN_TAB_'+@TAB2+' ?? 0 0 0 0 0 '+@TAB2NAME+' '+@TAB2NAME+' 0 0 0 0 0 0'
PRINT '1 SN_TAB_'+@TAB3+' ?? 0 0 0 0 0 '+@TAB3NAME+' '+@TAB3NAME+' 0 0 0 0 0 0'
PRINT '1 SN_STORE_'+@NPCNAME+'_GROUP1 ?? ?? ??/?? 0 0 0 0 0 '+@NPCGROUP_NAME+' '+@NPCGROUP_NAME+' 0 0 0 0 0 0'
END
IF (@TABNUMBER = 4)
BEGIN
PRINT '1 SN_TAB_'+@TAB1+' ?? 0 0 0 0 0 '+@TAB1NAME+' '+@TAB1NAME+' 0 0 0 0 0 0'
PRINT '1 SN_TAB_'+@TAB2+' ?? 0 0 0 0 0 '+@TAB2NAME+' '+@TAB2NAME+' 0 0 0 0 0 0'
PRINT '1 SN_TAB_'+@TAB3+' ?? 0 0 0 0 0 '+@TAB3NAME+' '+@TAB3NAME+' 0 0 0 0 0 0'
PRINT '1 SN_TAB_'+@TAB4+' ?? 0 0 0 0 0 '+@TAB4NAME+' '+@TAB4NAME+' 0 0 0 0 0 0'
PRINT '1 SN_STORE_'+@NPCNAME+'_GROUP1 ?? ?? ??/?? 0 0 0 0 0 '+@NPCGROUP_NAME+' '+@NPCGROUP_NAME+' 0 0 0 0 0 0'
END
PRINT ''
PRINT 'Add this line to refshoptab.txt @ server_dep\silkroad\textdata'
PRINT ''
/* TAB FUNCTION */
IF (@TABNUMBER = 1)
BEGIN
PRINT '1 15 '+@SHOPTABID1+' '+'STORE_'+@NPCNAME+'_TAB1 '+'STORE_'+@NPCNAME+'_GROUP1 SN_TAB_'+@TAB1+''
end
IF (@TABNUMBER = 2)
BEGIN
PRINT '1 15 '+@SHOPTABID1+' '+'STORE_'+@NPCNAME+'_TAB1 '+'STORE_'+@NPCNAME+'_GROUP1 SN_TAB_'+@TAB1+''
PRINT '1 15 '+@SHOPTABID2+' '+'STORE_'+@NPCNAME+'_TAB2 '+'STORE_'+@NPCNAME+'_GROUP1 SN_TAB_'+@TAB2+''
END
IF (@TABNUMBER = 3)
BEGIN
PRINT '1 15 '+@SHOPTABID1+' '+'STORE_'+@NPCNAME+'_TAB1 '+'STORE_'+@NPCNAME+'_GROUP1 SN_TAB_'+@TAB1+''
PRINT '1 15 '+@SHOPTABID2+' '+'STORE_'+@NPCNAME+'_TAB2 '+'STORE_'+@NPCNAME+'_GROUP1 SN_TAB_'+@TAB2+''
PRINT '1 15 '+@SHOPTABID3+' '+'STORE_'+@NPCNAME+'_TAB3 '+'STORE_'+@NPCNAME+'_GROUP1 SN_TAB_'+@TAB3+''
END
IF (@TABNUMBER = 4)
BEGIN
PRINT '1 15 '+@SHOPTABID1+' '+'STORE_'+@NPCNAME+'_TAB1 '+'STORE_'+@NPCNAME+'_GROUP1 SN_TAB_'+@TAB1+''
PRINT '1 15 '+@SHOPTABID2+' '+'STORE_'+@NPCNAME+'_TAB2 '+'STORE_'+@NPCNAME+'_GROUP1 SN_TAB_'+@TAB2+''
PRINT '1 15 '+@SHOPTABID3+' '+'STORE_'+@NPCNAME+'_TAB3 '+'STORE_'+@NPCNAME+'_GROUP1 SN_TAB_'+@TAB3+''
PRINT '1 15 '+@SHOPTABID4+' '+'STORE_'+@NPCNAME+'_TAB4 '+'STORE_'+@NPCNAME+'_GROUP1 SN_TAB_'+@TAB4+''
END
/* Tab End */
PRINT ''
PRINT 'Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 '+@SHOPTABGROUPID+' '+'STORE_'+@NPCNAME+'_GROUP1 '+'SN_STORE_'+@NPCNAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 '+'GROUP_STORE_'+@NPCNAME+' '+'STORE_'+@NPCNAME
PRINT ''
PRINT 'Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 '+'STORE_'+@NPCNAME+' '+'STORE_'+@NPCNAME+'_GROUP1'
PRINT ''
PRINT 'Congratulations!, New NPC Added Successfully. Query By Swagger1337.'
END
[/HIDE]
------------------------NPC TAŞIMA
[HIDE]
USE SRO_VT_SHARD /*DATABASE ISMI*/

DECLARE @charname1 VARCHAR (30)
DECLARE @NPCPOS VARCHAR (MAX)
DECLARE @ID INT
DECLARE @TACTICSID INT

SET @charname1 = 'Ultimate' -- NPC NİN KOCAĞI YERDEKİ CHAR İSMİ
SET @NPCPOS = 'NPC_SINAN1' -- NPC NİN KODU

DECLARE @regiON1 INT SET @regiON1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @charname1)
DECLARE @posX1 INT SET @posX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @charname1)
DECLARE @posY1 INT SET @posY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @charname1)
DECLARE @posZ1 INT SET @posZ1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @charname1)
SET @ID = (SELECT ID FROM _RefObjCommon WHERE CodeName128=@NPCPOS)
SET @TACTICSID =(SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID=@ID)

UPDATE Tab_RefNest SET fLocalPosX= @posX1,fLocalPosY= @posY1,fLocalPosZ= @posZ1,nRegionDBID= @regiON1 WHERE dwTacticsID=@TACTICSID
[/HIDE]

----------------NPC YÖNLERİ
+16384
-16384
0
-32767
------- KONUMUNUZA GÖRE AYARLAYINIZ
 
teşekkür
 
LockHD' Alıntı:
--YENİ NPC EKLEME QUERY
*** Gizli metin: alıntı yapılamaz. ***

------------------------NPC TAŞIMA
*** Gizli metin: alıntı yapılamaz. ***


----------------NPC YÖNLERİ
+16384
-16384
0
-32767
------- KONUMUNUZA GÖRE AYARLAYINIZ
Genişletmek için tıkla ...
thanks
 
Teşek
LockHD' Alıntı:
--YENİ NPC EKLEME QUERY
*** Gizli metin: alıntı yapılamaz. ***

------------------------NPC TAŞIMA
*** Gizli metin: alıntı yapılamaz. ***


----------------NPC YÖNLERİ
+16384
-16384
0
-32767
------- KONUMUNUZA GÖRE AYARLAYINI
Genişletmek için tıkla ...

Teşekkürler
 
Admin' Alıntı:
--YENİ NPC EKLEME QUERY
*** Gizli metin: alıntı yapılamaz. ***

------------------------NPC TAŞIMA
*** Gizli metin: alıntı yapılamaz. ***


----------------NPC YÖNLERİ
+16384
-16384
0
-32767
------- KONUMUNUZA GÖRE AYARLAYINIZ
Genişletmek için tıkla ...
Teşekkürler
 
Cevap yazmak için giriş yap yada kayıt ol.

Konu görüntüleyen kullanıcılar

Toplam: 2 (Kullanıcı: 0, ziyaretçi: 2)
Benzer konular Forum Tarih
espvp ESPVP.NET EŞİT PK SERVER YENİ ACİLDİ FARMDA VAR USERDE VAR GEL ASLA KAPANMAZ Knight Online Private Server Tanıtımları 1 53
C 110 Cap Cerberus C2 | Serbest Piyasa | 110 Cap | Uzun Soluklu | 210.000 TL Ödül Havuzu | Yeni Etkinlikler | Beta 15-11 | G.O 28.11 Silkroad Private Server Tanıtımları(TR) 0 80
sionist 100 Cap AEGON ONLINE / 100 CAP CH / DROP & BOX / YEP YENI BIR DENEYIM / BETA 1.11.24 / GRAND 8.11.24 Silkroad Private Server Tanıtımları(TR) 1 163
E 110 Cap Eternity Online || Cap 110 || CH/EU || Yenilenen Sistem || ve Daha Fazlası Silkroad Private Server Tanıtımları(TR) 0 134
T Trader Of Road 120 CAP Full Kervan Ve Yeni Jop Sistemleri Ve Free Server... Silkroad Private Server Tanıtımları(TR) 0 128
T Trader Of Road Oyunumuz Yeni Sistem -Sinirsiz Görev -Free Silk Saatteki Silk miktari 3 Silk/saat -Otomatik Rütbe Tanimla Silkroad Private Server Tanıtımları(TR) 0 90
T 110 Cap Sargon S2 - 110 Cap - Uzun Soluklu - Aktivite Tabanlı - Serbest Piyasa - Yeni Sistemler - Beta 15/02 Silkroad Private Server Tanıtımları(TR) 0 276
S 120 Cap Alfheim-R | 120 Cap | ISRO-R Files | Gelişmiş Survival Arena | Yeni Dungeonlar | Job Garden | G.O 16.02 Silkroad Private Server Tanıtımları(TR) 1 441

Benzer konular

Geri
Üst