| قسم المواضيع المكررة و المخالفة هنا يتم وضع المواضيع المخالفة والمواضيع المكررة |
 |
|
|
أدوات الموضوع | تقييم الموضوع | انواع عرض الموضوع |
|
|
15-09-2013, 03:16 AM
|
#1 | ||||||||||
 
|
منزل المشكله دي من امبارح و مفيش حل و واحد يقولي الـ Query غلط و اداني واحد تاني و بردو لو انا كاتب حاجه غلط في الـ Query او ناسي حاجه مكتبتهاش ياريت حد يقولي ايه هيا و دي صور اهي من الـ Errors اللي بتطلعلي :  |
||||||||||
|
| إعلانات google |
|
|
|
15-09-2013, 04:03 AM
|
#2 | |||||||||||
 
|
اقتباس:
ص انشاء الله خير |
|||||||||||
|
|
|
15-09-2013, 04:09 AM
|
#3 | |||||||||||
|
اقتباس:
USE SRO_VT_ACCOUNT_TTablya /* 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_MAXIGAME_KARA_KING_MOLE' -- Unique code name from _RefobjCommon table SET @CHARNAME = 'Revolution' -- Character name from _Char table to get mob position X Y Z SET @mindealy = 3600 -- Minimum time before appears in seconds SET @maxdelay = 4200 -- Maximum time before appears in seconds SET @INITRADIUS = 20 -- Radius around spot unique can generated at SET @RADIUS = 70 -- Radius around spot Unique can move in /* end of settings area */ /* get ID of mob by code name */ Declare @MOBID int SET @43994 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @51264 SET IDENTITY_INSERT Tab_RefTactics ON INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStam inaVariance,nSightRange,btAggressType,AggressData, btChangeTarget,btHelpRequestTo,btHelpResponseTo,bt BattleStyle,BattleStyleData,btDiversionBasis,Diver sionBasisData1,DiversionBasisData2, DiversionBasisData3,DiversionBasisData4,DiversionB asisData5,DiversionBasisData6,DiversionBasisData7, DiversionBasisData8,btDiversionKeepBasis,Diversion KeepBasisData1,DiversionKeepBasisData2,DiversionKe epBasisData3,DiversionKeepBasisData4,DiversionKeep BasisData5,DiversionKeepBasisData6,DiversionKeepBa sisData7, DiversionKeepBasisData8,btKeepDistance,KeepDistanc eData,btTraceType,btTraceBoundary,TraceData,btHomi ngType,HomingData,btAggressTypeOnHoming,btFleeType ,dwChampionTacticsID,AdditionOptionFlag,szDescStri ng128) 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,dwOverwriteMaxTot alCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRat e,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjTyp e,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,fLocalP osX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGen erateRadius,nChampionGenPercentage,dwDelayTimeMin, dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,bt Type) 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!' اهو الـ Query ^^ و علي الخط الاحمر مش عارف بردو فين الغلط :S انا شاكك ان فيه حاجات انا مش كاتبها بس مش عارف اجبها منين و كده ^^ |
|||||||||||
|
|
|
15-09-2013, 04:13 AM
|
#4 | |||||||||||
|
اقتباس:
بص انا هاظبتلك الكويري بس اهم حاجة اتأكد من ان ال SRO_VT_ACCOUNT اسمها كده عندك ف ال sql بمعني ممكن تكون انت مغيرها و ده الكويري صح USE SRO_VT_ACCOUNT_TTablya] /* Add Unique Spot] * 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_MAXIGAME_KARA_KING_MOLE' -- Unique code name from _RefobjCommon table SET @CHARNAME = 'Revolution' -- Character name from _Char table to get mob position X Y Z SET @mindealy = 3600 -- Minimum time before appears in seconds SET @maxdelay = 4200 -- Maximum time before appears in seconds SET @INITRADIUS = 20 -- Radius around spot unique can generated at SET @RADIUS = 70 -- Radius around spot Unique can move in /* end of settings area */ /* get ID of mob by code name */ Declare @MOBID int SET @43994 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @51264 SET IDENTITY_INSERT Tab_RefTactics ON INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStam inaVariance,nSightRange,btAggressType,AggressData, btChangeTarget,btHelpRequestTo,btHelpResponseTo,bt BattleStyle,BattleStyleData,btDiversionBasis,Diver sionBasisData1,DiversionBasisData2, DiversionBasisData3,DiversionBasisData4,DiversionB asisData5,DiversionBasisData6,DiversionBasisData7, DiversionBasisData8,btDiversionKeepBasis,Diversion KeepBasisData1,DiversionKeepBasisData2,DiversionKe epBasisData3,DiversionKeepBasisData4,DiversionKeep BasisData5,DiversionKeepBasisData6,DiversionKeepBa sisData7, DiversionKeepBasisData8,btKeepDistance,KeepDistanc eData,btTraceType,btTraceBoundary,TraceData,btHomi ngType,HomingData,btAggressTypeOnHoming,btFleeType ,dwChampionTacticsID,AdditionOptionFlag,szDescStri ng128) 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,dwOverwriteMaxTot alCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRat e,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjTyp e,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,fLocalP osX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGen erateRadius,nChampionGenPercentage,dwDelayTimeMin, dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,bt Type) 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!' |
|||||||||||
|
|
|
15-09-2013, 04:49 AM
|
#5 | |||||||||||
|
اقتباس:
عملت كده نفس ال Query و بيطلعلي كده Msg 102, Level 15, State 1, Line 26 Incorrect syntax near 'inaVariance'. Msg 102, Level 15, State 1, Line 33 Incorrect syntax near 'alCount'. Msg 102, Level 15, State 1, Line 45 Incorrect syntax near 'osX'. ايه الحل بردو >.< متقل عليك معلش ^_^ |
|||||||||||
|
|
|
15-09-2013, 04:56 AM
|
#6 | |||||||||||
|
اقتباس:
بس شوف انت عايز ايه و ندور مع بعض |
|||||||||||
|
|
|
15-09-2013, 04:58 AM
|
#7 | |||||||||||
|
اقتباس:
|
|||||||||||
|
التعديل الأخير تم بواسطة ™Dev Microsoft™ ; 15-09-2013 الساعة 05:09 AM
|
|
| الكلمات الدليلية |
| بدون |
| يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
.gif){kind=icon}
.gif){kind=icon}
العرض المتطور
