لو سمحتم يا جماعة كنت محتاج بس طريقة او كويري لنسخ npc

الحالة
مغلق و غير مفتوح للمزيد من الردود.
H

hazemsamir

عضو
19 ديسمبر 2017
3
0
1
جيزة

المستوي:

  • #1
    لو سمحتم يا جماعة كنت محتاج بس طريقة او كويري لنسخ npc
    ياريت يكون نسخ مش نقل عشان عاوز احطهم في كل المدن
     




    التعديل الأخير بواسطة المشرف:
    الحل
    Muuhammed Rifaii

    المستوي:

    رد: لو سمحتم يا جماعة كنت محتاج بس طريقة او كويري لنسخ npc

    ممكن تجرب ده​




    PHP: 
    DECLARE @CHARNAME VARCHAR (30)    
DECLARE @NPCNAME VARCHAR (30)    
DECLARE @ADDNEW VARCHAR (30)    
DECLARE @GAMEWORDID INT    
SET @CHARNAME = 'DaD' --U Char Name    
SET @NPCNAME = 'DAD' --U NPC NAME    
SET @GAMEWORDID = 1 --IMPORTANT! GET GAMEWORLD ID FROM THE LOCALY U WANT ADD THE NPC NORMAL CITYs = 1    
SET @ADDNEW = 'NPC'    
--    
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...
    ترتيب حسب التاريخ ترتيب حسب الأصوات
    Muuhammed Rifaii

    Muuhammed Rifaii

    عضو
    5 يونيو 2017
    51
    1
    2
    11
    Giza - 3omrania

    المستوي:

  • #3
    رد: لو سمحتم يا جماعة كنت محتاج بس طريقة او كويري لنسخ npc

    ممكن تجرب ده​




    PHP: 
    DECLARE @CHARNAME VARCHAR (30)    
DECLARE @NPCNAME VARCHAR (30)    
DECLARE @ADDNEW VARCHAR (30)    
DECLARE @GAMEWORDID INT    
SET @CHARNAME = 'DaD' --U Char Name    
SET @NPCNAME = 'DAD' --U NPC NAME    
SET @GAMEWORDID = 1 --IMPORTANT! GET GAMEWORLD ID FROM THE LOCALY U WANT ADD THE NPC NORMAL CITYs = 1    
SET @ADDNEW = 'NPC'    
--    
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,'npc\npc\chinawoman_Noblegirl_event.bsr','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 @ShopTabID VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+1    
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)    
VALUES (1,15,@ShopTabID,'STORE_'+@NPCNAME+'_TAB1','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_Stones')    
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,@GAMEWORDID,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+'    '+@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    npc\npc\chinawoman_Noblegirl_event.bsr    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 refshoptab.txt @ server_dep\silkroad\textdata'    
PRINT ''    
PRINT '1    15    '+@SHOPTABID+'    '+'STORE_'+@NPCNAME+'_TAB1    '+'STORE_'+@NPCNAME+'_GROUP1     SN_TAB_Stones'    
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 'A New NPC Has ADD Succesfuly Restart U Server and Login in '+@CHARNAME    
END
     




    تأييد 0 تصويت سلبي
    الحل
    S

    Sha Kro

    عضو
    8 يناير 2018
    3
    1
    0
    1
    بنها

    المستوي:

  • #4
    رد: لو سمحتم يا جماعة كنت محتاج بس طريقة او كويري لنسخ npc

    اتفضل

    USE [SRO_VT_SHARD]
    ----------------------------Made By ShaKro----------------------------
    DECLARE @KINGEDITOR1 VARCHAR (129)
    DECLARE @CHARNAME VARCHAR (64)

    SET @KINGEDITOR1 = 'NPC_RANGO' ----- Your Npc Name
    SET @CHARNAME = 'test2' ----- Charactar name [ where you Want to set npc ]

    Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @KINGEDITOR1)
    Declare @AS2 int SET @AS2 = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @AS1)
    Declare @AS3 int SET @AS3 = (SELECT dwNestID FROM Tab_RefNest WHERE dwTacticsID = @AS2)

    Declare @ASpos1 int SET @ASpos1 = (SELECT latestregion FROM _char WHERE charname16 = @CHARNAME)
    Declare @ASpos2 int SET @ASpos2 = (SELECT posx FROM _char WHERE charname16 = @CHARNAME)
    Declare @ASpos3 int SET @ASpos3 = (SELECT posy FROM _char WHERE charname16 = @CHARNAME)
    Declare @ASpos4 int SET @ASpos4 = (SELECT posz FROM _char WHERE charname16 = @CHARNAME)









    USE [SRO_VT_SHARD]
    ----------------------------Made By ShaKro----------------------------
    DECLARE @KINGEDITOR1 VARCHAR (129)
    DECLARE @CHARNAME VARCHAR (64)

    SET @KINGEDITOR1 = 'NPC_LEGENDKNIGHT_05' ----- Your Npc Name
    SET @CHARNAME = 'ShaKro' ----- Charactar name [ where you Want to set npc ]

    Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @KINGEDITOR1)
    Declare @AS2 int SET @AS2 = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @AS1)
    Declare @AS3 int SET @AS3 = (SELECT dwNestID FROM Tab_RefNest WHERE dwTacticsID = @AS2)

    Declare @ASpos1 int SET @ASpos1 = (SELECT latestregion FROM _char WHERE charname16 = @CHARNAME)
    Declare @ASpos2 int SET @ASpos2 = (SELECT posx FROM _char WHERE charname16 = @CHARNAME)
    Declare @ASpos3 int SET @ASpos3 = (SELECT posy FROM _char WHERE charname16 = @CHARNAME)
    Declare @ASpos4 int SET @ASpos4 = (SELECT posz FROM _char WHERE charname16 = @CHARNAME)

    UPDATE Tab_RefNest
    SET nregiondbid = @ASpos1,
    flocalposx = @ASpos2,
    flocalposy = @ASpos3,
    flocalposz = @ASpos4
    WHERE dwnestid = @AS3 and dwtacticsid = @AS2
     




    تأييد 0 تصويت سلبي
    DraCula

    DraCula

    V.I.P
    Designer & Pk2 Editor
    عضو
    2 فبراير 2017
    624
    15
    237
    244
    الجيزة
    Facebook
    Abdo.Dracula

    المستوي:

  • #5
    رد: لو سمحتم يا جماعة كنت محتاج بس طريقة او كويري لنسخ npc

    اتفضل الكويرى ده
    HTML: 
    SE [SRO_VT_SHARD]  
----------------------------Made By [Dev]LegendKnight----------------------------  
DECLARE @LEGENDKNIGHT1 VARCHAR(max)  
DECLARE @CHARNAME VARCHAR(max)  


SET @LEGENDKNIGHT1 = 'NPC_LEGENDKNIGHT09' ----- Your Npc Name  
SET @CHARNAME = '1111' ----- Charactar name [ where you Want to set npc ]  

Declare @LK1 int SET @LK1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT1)  
Declare @LK2 int SET @LK2 = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @LK1)  
Declare @LK3 int SET @LK3 = (SELECT dwNestID FROM Tab_RefNest WHERE dwTacticsID = @LK2)  
declare @dwHiveID int = (select dwHiveID from Tab_RefNest where dwnestid = @lk3 and dwtacticsid = @lk2 )  

Declare @LKpos1 int SET @LKpos1 = (SELECT latestregion FROM _char WHERE charname16 = @CHARNAME)  
Declare @LKpos2 int SET @LKpos2 = (SELECT posx FROM _char WHERE charname16 = @CHARNAME)  
Declare @LKpos3 int SET @LKpos3 = (SELECT posy FROM _char WHERE charname16 = @CHARNAME)  
Declare @LKpos4 int SET @LKpos4 = (SELECT posz FROM _char WHERE charname16 = @CHARNAME)  

insert into Tab_RefNest ([dwHiveID],[dwTacticsID],[nRegionDBID],[fLocalPosX],[fLocalPosY],[fLocalPosZ],[wInitialDir],[nRadius],[nGenerateRadius],[nChampionGenPercentage],[dwDelayTimeMin],[dwDelayTimeMax],[dwMaxTotalCount],[btFlag],[btRespawn],[btType])  
values (@dwHiveID,@LK2,@lkpos1,@lkpos2,@lkpos3,@lkpos4,0,0,0,0,0,0,1,0,1,0)

    +
    يغلق لعدم الاهتمام بالموضوع​
     




    تأييد 0 تصويت سلبي
    الحالة
    مغلق و غير مفتوح للمزيد من الردود.

    كلمة مدير الموقع

    بسم الله الرحمن الرحيم تم اعادة فتح المنتدي بطريقة حديثة متزامنه مع تطورات المواقع وتطبيقات الويب الحديثة وهيتم تحديث المنتدي اول بأول واضافة نظم وطرق جديده اول ب اول ومتابعه الاعضاء النشطين مع نظام مكافئات هعلن عنه قريب ..
    أعلى أسفل
    قائمة