|
• الانـتـسـاب » Mar 2012
|
• رقـم العـضـويـة » 99172
|
• المشـــاركـات » 1,609
|
• الـدولـة » ⊰∣A̷l̷e̷x̷a̷n̷d̷r̷i̷a̷∣⊱
|
• الـهـوايـة » Developer - P.Server
|
• اسـم الـسـيـرفـر » No Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 385
|
|
|
|ـ|ـ|الموضوع ده كيف عمل npc فى العبه |ـ|ـ|
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
انا عارف ان فى ناس كتير عوزه الموضوع ده
وى عشان كده انا عملتو
بسم الله
انا هشرح كل حاجه
بس ياريت تركزووو كويس
1_dbo._RefObjCommon
كود:
1 46754 NPC_Arshivel xxx xxx SN_NPC_Arshivel 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\chinaquest_merchant_bow.bsr xxx xxx xxx xxx 25406
شيفين ال 46754 وا 25406
دول اخر ارقام عندك فى ال RefObjCommon
تعرفهم ازاى من ال Query ده
كود PHP:
USE SRO_VT_SHARD DECLARE @CommonID INT DECLARE @ItemLinkID INT SET @CommonID = (SELECT ID FROM _RefObJCommon WHERE ID = (SELECT MAX(ID) FROM _RefObJCommon))+1 SET @ItemLinkID = (SELECT ID FROM _RefObJItem WHERE ID = (SELECT MAX(ID) FROM _RefObJItem))+1 print 'Common ID you have to use: '+cast(@CommonID as varchar(15)) print 'Common Link ID you have to use: '+cast(@ItemLinkID as varchar(15))
اعمل Your ID and Link
تمام ده معيا
2_dbo._RefObjChar
كود:
25406 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
شيفن 25406 ده رقم ال Link
اعمل الرقم الفى Link بتاع ال RefObjCommon
كده تمام
3_dbo.Tab_RefHive
كود:
1575 0 0 0 0 0 0 1 2 NPC E£??
1575 ده اخر رقم فى ال RefHive
4_dbo.Tab_RefTactics
كود:
46071 46754 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_Test
الرقم ده 46754 بتاع ال RefObjCommon
وا ده 46071 اخر رقم فى ال RefTactics
تمام كده
5_dbo.Tab_RefNest
كود:
36832 1575 46071 25000 1035 -32.6088829 962 2094 0 0 0 0 0 1 0 1 0
ركزوا معيا انا وى اشرف واحد شاى علشان ينمى الزكاء شويه وى يشيل الصده ال فى الجمجمه :):)
الرقك ده هوا رقم 46071 بتاع ال RefTactics
وى ده 1575 رقم RefHive
وى ده رقم36832 ال RefNest
وى دول 25000 1035 -32.6088829 962 2094 ال [nRegionDBID][fLocalPosX][fLocalPosY][fLocalPosZ]
بتعرفهم من ال dbo._Char
تمام كده كده تعدل عليهم وى كلول هيكون تمام ان شاء الله
كده خلص ال DB
_*_*_*_*_*_*_*_*_*_*_*_*_*_*_*_*_*_*_*_*_*_*_*_*_* _*_*_*_*_*_*_*_*_*_*_
الشغل ده فى ال DB وا ال Media
6_dbo._RefShop
كود:
1 15 90 STORE_Arshivel -1 xxx -1 xxx -1 xxx -1 xxx
ال لون ملهوش علقه بى القديم اوك
ده اخر رقم90 فى ال RefShop
7_dbo._RefShopGroup
كود:
1 15 2816 GROUP_STORE_Arshivel NPC_Arshivel -1 xxx -1 xxx -1 xxx -1 xxx
ده اخر رقم2816 فى ال RefShopGroup
8_dbo._RefShopItemGroup
كود:
1 83 STORE_Arshivel_GROUP1 SN_STORE_Arshivel_GROUP1
1 84 STORE_Arshivel_GROUP2 SN_STORE_Arshivel_GROUP2
ده اخر رقم فى 84-83 ال RefShopItemGroup
9_dbo._RefShopTab
كود:
1 15 6427 STORE_Arshivel_TAB1 STORE_Arshivel_GROUP1 SN_TAB_WEAPON
1 15 6428 STORE_Arshivel_TAB2 STORE_Arshivel_GROUP2 SN_TAB_WEAPON
ازون فهمتو ايه ال بيتغير
10_
كود:
dbo._RefShopTabGroup
كود:
1 15 2833 STORE_Arshivel_GROUP1 SN_STORE_Arshivel_GROUP1
1 15 2834 STORE_Arshivel_GROUP2 SN_STORE_Arshivel_GROUP2
11_dbo._RefMappingShopGroup
كود:
1 15 GROUP_STORE_Arshivel STORE_Arshivel
12_dbo._RefMappingShopWithTab
كود:
1 15 STORE_Arshivel STORE_Arshivel_GROUP1
1 15 STORE_Arshivel STORE_Arshivel_GROUP2
بعد ما تعمل دول فى ال Media وا ال DB
_____________________
هتعمل دول فى ال Media بس
characterdata_45000
كود:
1 46754 NPC_Arshivel xxx xxx SN_NPC_Arshivel 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\chinaquest_merchant_bow.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 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
ده ID 46754ال فى Common
textuisystem
// Store GROUP name
كود:
1 SN_STORE_Arshivel_GROUP1 1 2 3 4 5 6 0 ITEM/ Chinse/ Weapon/ Set 0 0 0 0
1 SN_STORE_Arshivel_GROUP2 1 2 3 4 5 6 0 ITEM/ Europe/ Weapon/ Set 0 0 0 0
textdata_object.txt
كود:
1 SN_NPC_Arshivel Seller Item DG 11
ملحوظه ::::::
انتا ممكن تغير ال NPC من ال RefObjCommon
كود:
1 46754 NPC_Arshivel xxx xxx SN_NPC_Arshivel 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\chinaquest_merchant_bow.bsr xxx xxx xxx xxx 25406
شيفين ال ازرق ده هوا ده ال تغير منو ال NPC
_______________________________
ملحوظه:
_ RefShop
_RefShopGroup
_RefShopItemGroup = shopgroupdata.txt
_RefShopTab
_RefShopTabGroup
_RefMappingShopGroup
_RefMappingShopWithTab
وى ال عاوز اضافة Item فى ال NPC
من الموضوع ده
وى انا اسف ان مش عامل شرح بس والله ما فى وقت
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
صوره كده
الصوره دى مش من JusticeRoad بس انا معيا ال DB ^_^
وى الموضوع الجاى عشان ال DB :P
بعد ما خلصت ال NPC وا كل حاجه وى عاوز تعمل Chat NPC
هاو يا حج :):)
npcchat
كود:
1 NPC_Arshivel SN_NPC_Arshivel_BS SN_NPC_Arshivel_PS
[/CODE] textquest_speech&name
كود:
1 SN_NPC_Arshivel_BS Welcome Silkroad4arab :) i am [Dev] Arshivel.
[/CODE]صوره كده على الماشى :):):)
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
وى ده ال Query
بس انا مليش علقه بى :)
انا ليا بى مجهودى
منقول 100% :)
NPC
[PHP]
كود PHP:
DECLARE @CHARNAME VARCHAR (30) DECLARE @NPCNAME VARCHAR (30) DECLARE @ADDNEW VARCHAR (30) DECLARE @GAMEWORDID INT SET @CHARNAME = 'DW' --U Char Name SET @NPCNAME = '1' --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_WEAPON') 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_WEAPONS' 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
TAB
كود PHP:
DECLARE @CHARNAME VARCHAR (30) DECLARE @NPCNAME VARCHAR (30) DECLARE @ADDNEW VARCHAR (30) DECLARE @TABNAME VARCHAR (30) DECLARE @TABNUMBER VARCHAR (30) DECLARE @TABNEW VARCHAR (30) DECLARE @GROUPNUMBER VARCHAR (30) DECLARE @GROUPNEW VARCHAR (30) -- SET @ADDNEW = 'TAB' -- 'NPC' to add a new npc, 'TAB' for add a new Tab, 'GROUP' for add a new group! SET @CHARNAME = '[GM] STATIIC' --U Char Name SET @NPCNAME = 'STATIIC' --U NPC NAME SET @GROUPNUMBER = 1 SET @TABNUMBER = 4 SET @TABNAME = 'TEST' -- IF @TABNUMBER = 2 SET @TABNEW = '_TAB2' IF @TABNUMBER = 3 SET @TABNEW = '_TAB3' IF @TABNUMBER = 4 SET @TABNEW = '_TAB4' IF @GROUPNUMBER = 1 SET @GROUPNEW = '_GROUP1' IF @GROUPNUMBER = 2 SET @GROUPNEW = '_GROUP2' IF @GROUPNUMBER = 3 SET @GROUPNEW = '_GROUP3' IF @GROUPNUMBER = 4 SET @GROUPNEW = '_GROUP4' IF @GROUPNUMBER = 5 SET @GROUPNEW = '_GROUP5' IF @GROUPNUMBER = 6 SET @GROUPNEW = '_GROUP6' IF @ADDNEW = 'TAB' BEGIN SET IDENTITY_INSERT _RefShopTab ON DECLARE @ShopTabID VARCHAR (30) SET @ShopTabID = (SELECT MAX (ID) FROM _RefShopTab)+1 INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab) VALUES (1,15,@ShopTabID,'STORE_'+@NPCNAME+@TABNEW,'STORE_'+@NPCNAME+@GROUPNEW,'SN_'+@TABNAME) SET IDENTITY_INSERT _RefShopTab OFF PRINT '' PRINT 'New Tab added Sucessfully add this new line to refshoptab.txt @ server_dep\silkroad\textdata' PRINT '1 15 '+@SHOPTABID+' STORE_'+@NPCNAME+@TABNEW+' STORE_'+@NPCNAME+@GROUPNEW+' SN_TAB_'+@TABNAME END
GROUP
كود PHP:
DECLARE @CHARNAME VARCHAR (30) DECLARE @NPCNAME VARCHAR (30) DECLARE @ADDNEW VARCHAR (30) DECLARE @GROUPNUMBER VARCHAR (30) DECLARE @GROUPNEW VARCHAR (30) SET @CHARNAME = '[GM] TIEKO' --U Char Name SET @NPCNAME = 'STATIC' --U NPC NAME SET @GROUPNUMBER = 2 SET @ADDNEW = 'GROUP' -- IF @GROUPNUMBER = 2 SET @GROUPNEW = '_GROUP2' IF @GROUPNUMBER = 3 SET @GROUPNEW = '_GROUP3' IF @GROUPNUMBER = 4 SET @GROUPNEW = '_GROUP4' IF @GROUPNUMBER = 5 SET @GROUPNEW = '_GROUP5' IF @GROUPNUMBER = 6 SET @GROUPNEW = '_GROUP6' IF @ADDNEW = 'GROUP' BEGIN SET IDENTITY_INSERT _RefShopTabGroup ON DECLARE @ShopTabGroupID VARCHAR (30) SET @ShopTabGroupID = (SELECT MAX (ID) FROM _RefShopTabGroup)+1 INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group) VALUES (1,15,@ShopTabGroupID,'STORE_'+@NPCNAME+@GROUPNEW,'SN_STORE_'+@NPCNAME+@GROUPNEW) SET IDENTITY_INSERT _RefShopTabGroup OFF INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'+@NPCNAME,'STORE_'+@NPCNAME+@GROUPNEW) PRINT '' PRINT 'New Group Added Succesfully ' PRINT 'add this new line to refshoptabgroup.txt @ server_dep\silkroad\textdata' PRINT '1 15 '+@SHOPTABGROUPID+' STORE_'+@NPCNAME+@GROUPNEW+' SN_STORE_'+@NPCNAME+@GROUPNEW PRINT '' PRINT 'add this new line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata' PRINT '1 15 STORE_'+@NPCNAME+' STORE_'+@NPCNAME+@GROUPNEW END
|