27-03-2019, 10:39 PM
|
#1
|
|
• الانـتـسـاب » Mar 2017
|
• رقـم العـضـويـة » 132467
|
• المشـــاركـات » 327
|
• الـدولـة » Samanoud
|
• الـهـوايـة » Design / Developer
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 10
|
|
|
Query for change teleport spot by Hitler
انا واحد من ال كانو بيدورو علي الQuery ده بص ملقتش فايده روحت عملت واحد
فا انا قولت اخلي غيري يستفاد منو بالمره
كود PHP:
USE [SRO_VT_SHARD]
----Query Created By Hitler----
DECLARE @HITLER2 VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
SET @HITLER2 = 'STORE_TQ_SNAKEGATE' ----- Your Npc Name
SET @CHARNAME = '[GM]Hitler' ----- Charactar name [ where you Want to set npc ]
Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @HITLER2)
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 _RefObjCommon
SET RegionID = @ASpos1,
OffsetX = @ASpos2,
OffsetY = @ASpos3,
OffsetZ = @ASpos4
WHERE ID = @as1
PRINT ''
PRINT 'Edit in client too @ server_dep\silkroad\textdata\teleportbuilding'
PRINT ''
متنساش تعدل غلي الكلينت
teleportbuilding.txt
بالتوفيق
|
|
|