Dev.Klito
04-01-2017, 09:19 PM
http://vb.elmstba.com/imgcache/elmstba.com_1457431694_954.gif
http://img.roro44.com/imgcache/2013/12/20620.gif
http://www4.0zz0.com/2015/11/27/18/702514124.gif
How To Add New Reverse Scroll Point
http://www6.0zz0.com/2016/12/28/21/407306154.png
طبعا الجواب باين من عنوانه انت هتجيب اى كركتر (CHAR) و توقفها مكان منتا عايز النقطة الجديدة و بعدين اعم الكوري دى بس متنساش تغير اسم النقطة و اسم الكركتر و اللفل
http://www6.0zz0.com/2016/12/28/21/407306154.png
USE [SRO_VT_SHARD]
DECLARE @Name VARCHAR (Max)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @minlv INT
DECLARE @maxlv int
SET @Name = 'ZONE_1' -- Name of Point
SET @CHARNAME = '[GM]Klito' -- Character name from _Char table to get mob position X Y Z
SET @minlv = 95 -- Minimum lvl to reverse
SET @maxlv = 999 -- Maximum lvl to reverse
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)
INSERT INTO _RefOptionalTeleport ([Service] ,[ObjName128] ,[ZoneName128] ,[RegionID] ,[Pos_X] ,[Pos_Y] ,[Pos_Z] ,[WorldID] ,[RegionIDGroup] ,[MapPoint] ,[LevelMin] ,[LevelMax] ,[Param1] ,[Param1_Desc_128] ,[Param2] ,[Param2_Desc_128] ,[Param3] ,[Param3_Desc_128])
VALUES (1,@Name ,'SN_'+ @Name , @REGION ,@POSX ,@POSY ,@POSZ, 1 ,-1 ,1 ,@minlv ,@maxlv, -1,'xxx' ,-1 ,'xxx' ,-1 ,'xxx')
PRINT 'Added Sucessfully'
http://www6.0zz0.com/2016/12/28/21/407306154.png
بالنسبة لل media هتعمل الكوري دى و النتائج حطها في refoptionalteleport.txt
http://www6.0zz0.com/2016/12/28/21/407306154.png
SELECT * FROM [SRO_VT_SHARD].[dbo].[_RefOptionalTeleport]
http://www6.0zz0.com/2016/12/28/21/407306154.png
و ده الشرح
https://www.youtube.com/watch?v=m7Dl6N2ZIM4&feature=youtu.be
والف مبروك عليك النقطة الجديدة :arf2:
http://www6.0zz0.com/2016/12/28/21/407306154.png
http://img.roro44.com/imgcache/2013/12/20620.gif
http://www4.0zz0.com/2015/11/27/18/702514124.gif
How To Add New Reverse Scroll Point
http://www6.0zz0.com/2016/12/28/21/407306154.png
طبعا الجواب باين من عنوانه انت هتجيب اى كركتر (CHAR) و توقفها مكان منتا عايز النقطة الجديدة و بعدين اعم الكوري دى بس متنساش تغير اسم النقطة و اسم الكركتر و اللفل
http://www6.0zz0.com/2016/12/28/21/407306154.png
USE [SRO_VT_SHARD]
DECLARE @Name VARCHAR (Max)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @minlv INT
DECLARE @maxlv int
SET @Name = 'ZONE_1' -- Name of Point
SET @CHARNAME = '[GM]Klito' -- Character name from _Char table to get mob position X Y Z
SET @minlv = 95 -- Minimum lvl to reverse
SET @maxlv = 999 -- Maximum lvl to reverse
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)
INSERT INTO _RefOptionalTeleport ([Service] ,[ObjName128] ,[ZoneName128] ,[RegionID] ,[Pos_X] ,[Pos_Y] ,[Pos_Z] ,[WorldID] ,[RegionIDGroup] ,[MapPoint] ,[LevelMin] ,[LevelMax] ,[Param1] ,[Param1_Desc_128] ,[Param2] ,[Param2_Desc_128] ,[Param3] ,[Param3_Desc_128])
VALUES (1,@Name ,'SN_'+ @Name , @REGION ,@POSX ,@POSY ,@POSZ, 1 ,-1 ,1 ,@minlv ,@maxlv, -1,'xxx' ,-1 ,'xxx' ,-1 ,'xxx')
PRINT 'Added Sucessfully'
http://www6.0zz0.com/2016/12/28/21/407306154.png
بالنسبة لل media هتعمل الكوري دى و النتائج حطها في refoptionalteleport.txt
http://www6.0zz0.com/2016/12/28/21/407306154.png
SELECT * FROM [SRO_VT_SHARD].[dbo].[_RefOptionalTeleport]
http://www6.0zz0.com/2016/12/28/21/407306154.png
و ده الشرح
https://www.youtube.com/watch?v=m7Dl6N2ZIM4&feature=youtu.be
والف مبروك عليك النقطة الجديدة :arf2:
http://www6.0zz0.com/2016/12/28/21/407306154.png