عاوز كويري نقل NPC او نسخ NPC

[Tyko]

جربت الاتنين دول
بيقولى 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'

[.Gamer.]

المفروض يجيبلك
(1) rows affect....

[MORJANA]

أتفضل جرب الكويري ده هتحط أسم الأن بي سي و أسم الكراكتر
اللي وقفتها في المكان الجديد اللي هتنقل فيه
و بعد ما تخلص رستر ملفات السيرفر كلها

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

[MikrotikBody]

أتفضل جرب الكويري ده هتحط أسم الأن بي سي و أسم الكراكتر
اللي وقفتها في المكان الجديد اللي هتنقل فيه
و بعد ما تخلص رستر ملفات السيرفر كلها

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











كل ده ؟

[MikrotikBody]

جربت الاتنين دول
بيقولى 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'

انت عايز تنقل ولا عايز تحارب
أتفضل حضرتك

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

[.Gamer.]

كل ده ؟




انت عايز تنقل ولا عايز تحارب
أتفضل حضرتك

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

المفروض 24 ساعه علي مشاركةة تانية لحضرتك ... ثانيا



كل ده ؟

ايوة انا جربت الكويري وشغال تمام ؟:pile:

[MORJANA]

كل ده ؟

يعني أيه كل ده :crazy: هو حضرتك جربت و مشتغلش مثلا ! :bye1:
شغال يافندم و حضرتك تقدر تقرا الكويري :cheers:
:bye1:

[SAGY]

يعني أيه كل ده هو حضرتك جربت و مشتغلش مثلا !
شغال يافندم و حضرتك تقدر تقرا الكويري



علي فكرة انا عملت زي اللي مكتوب بالظبط
و كلة تمام و ارستر الملفات كلها و ادخل ملاقيش تعديل .. اية السبب

[Mahmoud Rashwan]

علي فكرة انا عملت زي اللي مكتوب بالظبط
و كلة تمام و ارستر الملفات كلها و ادخل ملاقيش تعديل .. اية السبب

تقدر تعمل موضوع بى مشكلتك

[Mahmoud Rashwan]

@@