شـريـط الاهـداءات |
|
| قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
 |
|
|
أدوات الموضوع | انواع عرض الموضوع |
29-04-2017, 02:23 PM
|
#1 | ||||||||||||
 
|
جربت الاتنين دول بيقولى Succues بس مافيش اي حاجة بتحصل USE [SRO_VT_SHARD] ----------------------------Made By AnTaKa---------------------------- DECLARE @KINGEDITOR1 VARCHAR (129) DECLARE @CHARNAME VARCHAR (64) SET @KINGEDITOR1 = 'NPC_D13_ITEMS' ----- Your Npc Name SET @CHARNAME = '[GM]Tyko' ----- 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 ------------------------------------------------------------ * this is query created by KingDollar not others , don't copy and post it under your name god see you xD */ Declare @CharName varchar(MAX) Declare @CodeName varchar(MAX) Declare @dwNestID int Declare @dwHiveID int Declare @dwTacticsID int Declare @nRegionDBID int Declare @fLocalPosX int Declare @fLocalPosY int Declare @fLocalPosZ int Declare @wInitialDir int set @CharName = (Select CharName16 From _Char Where CharName16 = 'KingDollar') -- Your Character Name set @CodeName = (Select ID From _RefObjCommon Where CodeName128 = 'NPC_CA_POTION') -- Your Npc Code Name set @dwNestID = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1 set @dwHiveID = '2' set @dwTacticsID = (Select dwTacticsID From Tab_RefTactics Where dwObjID = @CodeName) set @nRegionDBID = (Select LatestRegion From _Char Where CharName16 = @CharName) set @fLocalPosX = (Select PosX From _Char Where CharName16 = @CharName) set @fLocalPosY = (Select PosY From _Char Where CharName16 = @CharName) set @fLocalPosZ = (Select PosZ From _Char Where CharName16 = @CharName) set @wInitialDir = '-32587' if (@CharName is null) begin print 'please be sure from charname which you write because its back null no result so please be sure from it' end else if (@CodeName is null) begin print 'please be sure from codename which you write because its back null no result so please be sure from it' end else if (@CharName is not null) And (@CodeName is not null) begin 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 (@dwNestID,@dwHiveID,@dwTacticsID,@nRegionDBID,@fL ocalPosX,@fLocalPosY,@fLocalPosZ,@wInitialDir,0,0, 0,0,0,1,0,1,0) print 'gratz you have copied NPC' |
||||||||||||
|
|
| إعلانات google |
|
|
|
30-04-2017, 01:17 AM
|
#2 | ||||||||||||
  
|
المفروض يجيبلك (1) rows affect.... |
||||||||||||
|
|
|
30-04-2017, 01:41 AM
|
#3 | ||||||||||||
  
|
أتفضل جرب الكويري ده هتحط أسم الأن بي سي و أسم الكراكتر
اللي وقفتها في المكان الجديد اللي هتنقل فيه و بعد ما تخلص رستر ملفات السيرفر كلها كود:
USE [SRO_VT_SHARD] ----------------------------Made By MORJANA---------------------------- DECLARE @KINGEDITOR1 VARCHAR (129) DECLARE @CHARNAME VARCHAR (64) SET @KINGEDITOR1 = 'NPC_ARENA' ----- NPC Name SET @CHARNAME = 'MORJANA' ----- Charactar name [ where you Want to move 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 |
||||||||||||
|
|
|
30-04-2017, 04:40 AM
|
#4 | |||||||||||||
 
|
اقتباس:
|
|||||||||||||
|
|
|
30-04-2017, 04:48 AM
|
#5 | |||||||||||||
|
اقتباس:
أتفضل حضرتك كود:
USE SRO_VT_SHARD DECLARE @RefID int,@Cord_X int,@Cord_Y int,@Cord_Z int,@Region int SELECT @Cord_X = PosX,@Cord_Y = PosY,@Cord_Z = PosZ,@Region = LatestRegion FROM _Char WHERE CharName16 = 'CharName' SELECT @RefID = R.dwTacticsID FROM Tab_RefTactics R JOIN _RefObjCommon O ON O.ID = R.dwObjID WHERE O.CodeName128 LIKE 'NPC Name' UPDATE TAB_RefNest SET fLocalPosX = @CORD_X, fLocalPosY = @CORD_Y, fLocalPosZ = @CORD_Z, nRegionDBID = @Region WHERE dwTacticsID = @RefID |
|||||||||||||
|
|
|
30-04-2017, 11:20 AM
|
#6 | |||||||||||||||
|
اقتباس:
اقتباس:
اقتباس:
|
|||||||||||||||
|
|
|
30-04-2017, 03:41 PM
|
#7 | |||||||||||||
|
اقتباس:
يعني أيه كل ده  هو حضرتك جربت و مشتغلش مثلا !  شغال يافندم و حضرتك تقدر تقرا الكويري  |
|||||||||||||
|
|
|
02-05-2017, 05:15 AM
|
#8 | |||||||||||||
|
اقتباس:
و كلة تمام و ارستر الملفات كلها و ادخل ملاقيش تعديل .. اية السبب |
|||||||||||||
|
|
|
02-05-2017, 05:39 AM
|
#9 | |||||||||||||
 
|
اقتباس:
|
|||||||||||||
|
|
|
02-05-2017, 05:39 AM
|
#10 | ||||||||||||
|
@@
|
||||||||||||
|
|
|
| يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
.gif){kind=icon}
العرض العادي
