اتجاه npc

[ibrahimix]

عاوز طريقه اعدل بيه ال npc , جربت كذا كويري والطرق الي موجودين علي المنتدي بس مش عاوز يتظبط خالص.

[ibrahimix]

تم الحل

[ماجيكو]

حلتها ازاااااااااي انا عندي نفس المشكله ؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟

[Youssef joo]

الكوارى ده مش موجود مع حد نهائى إلا قليل خالص وأسهل وأسرع طريقة تضيف بيها أن بي سي وبدون مشاكل بس لاذم تفهمو وتعمل كل الأجراءات صح

/* NPC QUERY FIXED BY Mr J00 */

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,OrgObjCodeName1 28,NameStrID128,DescStrID128,CashItem,Bionic,TypeI D1,TypeID2,TypeID3,TypeID4,DecayTime,Country
,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop, CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price, CostRepair,CostRevive,CostBorrow,KeepingFee,SellPr ice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel 2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4, MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Sp eed1,Speed2,Scale,BCHeight,BCRadius
,EventID,AssocFileObj128,AssocFileDrop128,AssocFil eIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES
(1,@MAXCOMMONID,'NPC_'+@NPCNAME,'xxx','xxx','SN_NP C_'+@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,Resist Frostbite,ResistBurn,ResistEShock,ResistPoison,Res istZombie,ResistSleep,ResistRoot,ResistSlow,Resist Fear
,ResistMyopia,ResistBlood,ResistStone,ResistDark,R esistStun,ResistDisea,ResistChaos,ResistCsePD,Resi stCseMD,ResistCseSTR,ResistCseINT,ResistCseHP,Resi stCseMP,Resist24,ResistBomb,Resist26
,Resist27,Resist28,Resist29,Resist30,Resist31,Resi st32,InventorySize,CanStore_TID1,CanStore_TID2,Can Store_TID3,CanStore_TID4,CanBeVehicle,CanControl,D amagePortion,MaxPassenger,AssocTactics,PD,MD,PAR,M AR,ER,BR,HR,CHR
,ExpToGive,CreepType,Knockdown,KO_RecoverTime,Defa ultSkill_1,DefaultSkill_2,DefaultSkill_3,DefaultSk ill_4,DefaultSkill_5,DefaultSkill_6,DefaultSkill_7 ,DefaultSkill_8,DefaultSkill_9,DefaultSkill_10,Tex tureType,Except_1
,Except_2,Except_3,Except_4,Except_5,Except_6,Exce pt_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_Desc 128,Param2,Param2_Desc128,Param3,Param3_Desc128,Pa ram4,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,Par am1,Param1_Desc128,Param2,Param2_Desc128,Param3,Pa ram3_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_STO RE_'+@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,RefTabGroupCodeNam e,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,RefTabGroupCodeNam e,StrID128_Tab)
VALUES (1,15,@ShopTabID1,'STORE_'+@NPCNAME+'_TAB1','STORE _'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB1+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeNam e,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,RefTabGroupCodeNam e,StrID128_Tab)
VALUES (1,15,@ShopTabID1,'STORE_'+@NPCNAME+'_TAB1','STORE _'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB1+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeNam e,StrID128_Tab)
VALUES (1,15,@ShopTabID2,'STORE_'+@NPCNAME+'_TAB2','STORE _'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB2+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeNam e,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,RefTabGroupCodeNam e,StrID128_Tab)
VALUES (1,15,@ShopTabID1,'STORE_'+@NPCNAME+'_TAB1','STORE _'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB1+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeNam e,StrID128_Tab)
VALUES (1,15,@ShopTabID2,'STORE_'+@NPCNAME+'_TAB2','STORE _'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB2+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeNam e,StrID128_Tab)
VALUES (1,15,@ShopTabID3,'STORE_'+@NPCNAME+'_TAB3','STORE _'+@NPCNAME+'_GROUP1','SN_TAB_'+@TAB3+'')
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeNam e,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,@P OSZ,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 Mr J00.'
END