سؤال بخصوص Uniq - الموقع العربي الاول للعبة Silkroad Online

**Blizzard** · 27-04-2016, 02:17 PM

انا كنت عاوز انزل New Uniq الى عندى فى السيرفر فى مكان تانى بس عاوز اخليه ينزل فى كذا مكان مش مكان محدد زاى Lord , Tiger , Captin lvy, isy . Demon
زاى دول بس مش دول انا اقصد New Uniq الى انا ضايفها عندى فى السيرفير
ياريت تكونو فهمتونى

**Dev.Ri3o** · 27-04-2016, 04:47 PM

افتح اى Char عندك فى اللعبة ووقفو فى المكان اللى انت عايز تنزل فى ال Uniqe وبعد كده اعمل ال Query ده

 
USE SRO_VT_SHARD /* Add Unique Spot By Ri3o */ 

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 = 'Esm el acc 3shan el SPOT' -- 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 '' 
print '' 
print 'Done!'

**Blizzard** · 27-04-2016, 06:11 PM

المشاركة الأصلية كتبت بواسطة ameral عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

افتح اى Char عندك فى اللعبة ووقفو فى المكان اللى انت عايز تنزل فى ال Uniqe وبعد كده اعمل ال Query ده

USE SRO_VT_SHARD /* Add Unique Spot By Ri3o */ 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 = 'Esm el acc 3shan el SPOT' -- 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 '' print '' print 'Done!'

تمام بس ايه دول

SET @UNIQUE = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table SET @CHARNAME = 'Esm el acc 3shan el SPOT' -- 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

**Jayden** · 27-04-2016, 06:16 PM

كود ال Unique اللى انت عايز تعمله اماكن
- و اسم ال Character اللى انت موقفها فى مكان ال Unique

**Dev.Ri3o** · 27-04-2016, 06:22 PM

ده Code ال Uniqe من ال RefObjCommon اللى انت عايز تعملو Spot

**Blizzard** · 27-04-2016, 10:47 PM

يا جدعان انتو فهمتونى غلط
انا عاوز اخلى Uniq الواحد ينزل فى كذا مكان
مش مكان محدد زاى Lord, Tiger Girl
انا مش عاوز انزله فى مكان واحد
انا عاوز لما نزل مثلا فى هوتان المره الى جايه
مثلا ينزل فى جانجان
ياريت تكونو فهمتونى

**Jayden** · 28-04-2016, 05:33 AM

يا باشا ايوه اعمل ال Query كذا مره فى كذا مكان مختلف و هو هينزل زى مانت بتقول

**Blizzard** · 28-04-2016, 03:40 PM

تمام اوى هو ينفع استخدم Query وانا فاتح الكونت ولى لازم اقفله ؟

**Blizzard** · 28-04-2016, 07:20 PM

طيب دول بتوع ايه

@INITRADIUS = 100 -- Radius around spot unique can generated at @RADIUS = 500 -- Radius around spot Unique can move in

**Blizzard** · 28-04-2016, 08:18 PM

المشاركة الأصلية كتبت بواسطة ameral عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

افتح اى Char عندك فى اللعبة ووقفو فى المكان اللى انت عايز تنزل فى ال Uniqe وبعد كده اعمل ال Query ده

USE SRO_VT_SHARD /* Add Unique Spot By Ri3o */ 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 = 'Esm el acc 3shan el SPOT' -- 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 '' print '' print 'Done!'

على فكره مش شغال

دى الرساله الىبتجيلى

Msg 8106, Level 16, State 1, Line 25 Table 'Tab_RefTactics' does not have the identity property. Cannot perform SET operation.

**Dev.Ri3o** · 28-04-2016, 08:31 PM

مفيش مشكلة انك تبقى فاتح الاكونت المهم انو ياخد احداثياتو ثانيا اتاكد ان اسم الdatabase عندك sro vt shard او غيرها فى الquery للاسم اللى عندك
واللى انت بتسال عليها دى ان ممكن الuniqe يعملspotجنب المكان الاصلى

**Blizzard** · 29-04-2016, 02:07 PM

غيرت اسم الداتا و نفس المشكله على فكره و نفس الرساله

Msg 8106, Level 16, State 1, Line 25
Table 'Tab_RefTactics' does not have the identity property. Cannot perform SET operation.

**Dev.BigBear** · 29-04-2016, 05:27 PM

لازم تقفل الايدينتى بتاعت _ RefTactiesعلشان تعرف تشغل علية

**Blizzard** · 29-04-2016, 08:22 PM

اولا: انا بشكر الناس الى سعديتنى

ثانيا:هو اشتغل بس فى مشكله انه نزل 4 Uniq مكان الاماكن الى رحتهوم المفروض انه ينزل واحد بس فى 4 اماكن دول

يارت حد يقولى ازاى انزل 1 بس فى 4 اماكن زاى Tiger Girl ما بتزهر الناس بتروح تدور عليها فى مكان محدد انا بقى عاوز الناس تدور على New Uniq دول

ياريت تكونو فهمتونى

**Jayden** · 29-04-2016, 08:41 PM

dwMaxTotalCount اللى فى Tab_RefNest اعملها 1
فى ال Line بتاع ال Unique بتاعك

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

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
طلب بخصوص Uniq	Blizzard	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	4	11-07-2016 02:27 AM
سؤال بخصوص Uniq Job	Blizzard	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	4	28-04-2016 01:52 AM
طلب بخصوص Uniq	Blizzard	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	13	08-04-2016 12:38 AM
بخصوص uniq	Mr.Alexander	قـسـم الاسـئـلـه و الاسـتـفـسـارات حـول الـلـعـبـة	17	22-03-2013 01:54 PM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)