الموقع العربي الاول للعبة Silkroad Online

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

اقتباس:

/* 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