شـريـط الاهـداءات |
|
| قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
 |
|
|
أدوات الموضوع | انواع عرض الموضوع |
05-12-2017, 10:51 AM
|
#1 | ||||||||||||
|
Super Designer  
|
لو سمحت عندي مشكلتين بعد أزنكم أول مشكله هيه إن Magic Pop Npc مش ظاهر عندي فى اللعبه خالص والتانيه ان ال FGW الاكونت مكنتش بيدخل جواها فتحت ال TOWN بتاعها وبقي الاكونت يدخل جوا عادي بس أول ما يدخل يجيلوا DC |
||||||||||||
|
|
| إعلانات google |
|
|
|
05-12-2017, 02:13 PM
|
#2 | ||||||||||||
  
|
من Text_Object في الميديا اعرف NPC الــ Magic Pop Npc و بعد كدا افتحوا من الميديا كلها من عند الـ Service اللي هو اول صف على الشمال بدل 0 خليه 1 و كذلك في RefObjCommon في DataBas و بالنسبة لــ FGW كود:
USE [SRO_VT_SHARD] GO --/*Fix Envy By MyOwnJ3lood*/ UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41540' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41550' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41560' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41570' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41580' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41590' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42460' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42470' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42480' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42490' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42500' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42510' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42520' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42530' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43420' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43430' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43440' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43450' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43460' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43470' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43480' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43490' كود:
USE [SRO_VT_SHARD] GO --/*Fix Boss Uniques By MyOwnJ3lood*/ UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43580' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43590' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43600' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43610' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43620' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43630' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43640' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43650' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43660' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43670' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43680' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43690' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43700' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43710' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43720' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43730' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43740' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43750' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43760' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43770' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43780' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43790' كود:
USE [SRO_VT_SHARD] GO --/*For Treasure Box By MyOwnJ3lood*/ UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41600' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41610' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41620' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41630' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41640' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41650' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42540' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42550' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42560' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42570' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42580' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42590' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42600' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42610' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43500' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43510' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43520' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43530' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43540' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43550' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43560' UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43570' |
||||||||||||
|
|
|
05-12-2017, 02:48 PM
|
#3 | ||||||||||||
|
Super Designer
|
عملت موضوع الـ FGW زى ما بعتهولي وكتبلي انه اتعمل فى ال SQL ورسترت السيرفر كله ولسه برضوا بيجيلي كدا أول ما بدخل  والماجيك بوب عملت كل الشوبات الخاصه بيه فى ال sql زى ماهوا باين 1 وفى الميديا ملقتش غير واحد بس ولقيته معمول لوحده 1 ولسه برضوا مبيظهروش ..  
|
||||||||||||
|
|
|
05-12-2017, 03:09 PM
|
#4 | ||||||||||||
  
|
بالنسبة لل FGW هتعمل ال Query ده كود:
USE [SRO_VT_SHARD]
GO
/******By Jangan ******/
/******Fix By Asuradoll ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
--##If you want to only have one not both, then just modify the line below!
--if (@JobID = 1 and @Category = 2 and @Serial64=0) or (@JobID = 2 and @Category = 2 and @Serial64=0) --For Guild and CharJob
if (@JobID = 1 and @Category = 2 and @Serial64=0) --Only for Guild
BEGIN
set @CharID = 0
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @NewJobID
وال MagicPop كدة السطر بتاع ال Tab_RefNest بتاعها ممسوح ضيف السطر ده فى ال Tab_RefNest وجرب وشوف كود:
11112 2 1118 25000 1612.97 0 1193 32767 0 0 0 0 0 1 0 1 0 26441 12 1118 26959 444.24 80.32 225.94 16565 0 0 0 0 0 1 0 1 0 26458 301 1118 27244 913.69 180 1828.76 16565 0 0 0 0 0 1 0 1 0 26461 5 1118 26265 543.91 -106.74 1533.36 16565 0 0 0 0 0 1 0 1 0 26508 6 1118 23687 1652.38 243.82 776.57 -26215 0 0 0 0 0 1 0 1 0 29291 554 1118 23088 1364.37 863.36 1130.77 23665 0 0 0 0 0 1 0 1 0 NPC_CH_GACHA_MACHINE وتوقف Char وتعمل Spot فى المكان اللى انت عايزو , بس تخلى Identity بتاع ال Tab_RefNest و Tab_RefTactics و Tab_RefHive تبقى Yes عشان ال Query يشتغل معاك كود:
USE SRO_VT_SHARD /* Add Unique Spot By Arabianfox */ DECLARE @UNIQUE VARCHAR (129) DECLARE @CHARNAME VARCHAR (64) DECLARE @mindealy INT DECLARE @maxdelay int DECLARE @INITRADIUS INT DECLARE @RADIUS int DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1 DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1 DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1 /* put your settings here */ SET @UNIQUE = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z SET @mindealy = 60 -- Minimum time before appears in seconds SET @maxdelay = 120 -- Maximum time before appears in seconds SET @INITRADIUS = 100 -- Radius around spot unique can generated at SET @RADIUS = 500 -- Radius around spot Unique can move in /* end of settings area */ /* get ID of mob by code name */ Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE) SET IDENTITY_INSERT Tab_RefTactics ON INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128) VALUES (@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,2,0,0,112,@UNIQUE) SET IDENTITY_INSERT Tab_RefTactics OFF SET IDENTITY_INSERT Tab_RefHive ON INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128) VALUES (@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE) SET IDENTITY_INSERT Tab_RefHive OFF /* get position coordinates of your character */ DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME) SET IDENTITY_INSERT Tab_RefNest ON INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) VALUES (@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0) SET IDENTITY_INSERT Tab_RefNest OFF print '' |
||||||||||||
|
|
|
05-12-2017, 03:35 PM
|
#5 | ||||||||||||
|
Super Designer
|
تم الحل شكرا لمجهودك
|
||||||||||||
|
|
|
05-12-2017, 05:53 PM
|
#6 | ||||||||||||
  
|
##
|
||||||||||||
|
|
|
| يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
.gif){kind=icon}
.gif){kind=icon}
العرض العادي
