|
You last visited: Today at 10:34
Advertisement
Question I Need X And Y Zone
Discussion on Question I Need X And Y Zone within the SRO Private Server forum part of the Silkroad Online category.
07/30/2012, 01:53
|
#1
|
elite*gold: 0
Join Date: Jan 2011
Posts: 373
Received Thanks: 71
|
Question I Need X And Y Zone
I just want to know where I have a new teleporter has to enter into the database so that I as can porten from the PVP Area or Area of GM back into the city without the one I use has to scroll retürn
The areas are all bug-free crash on me no ...
my _RefTeleport
_RefTeleport
Code:
ID GenPos_X GenPos_Y GenPos_Z GenAreaRadius CanBeResurrectPos CanGotoResurrectPos GenWorldID BindInteractionMask FixedService
1 235 GATE_GM_GATE xxx 0 SN_GATE_GM_GATE -32745 -3 -7 628 10 0 0 92 1 0
1 236 GATE_PVP_FREE xxx 0 SN_PVP_FREE 32467 952 413 1193 150 1 0 1 1 0
_RefTeleLink
Code:
Service OwnerTeleport TargetTeleport Fee RestrictBindMethod RunTimeTeleportMethod CheckResult Restrict1 Data1_1 Data1_2 Restrict2 Data2_1 Data2_2 Restrict3 Data3_1 Data3_2 Restrict4 Data4_1 Data4_2 Restrict5 Data5_1 Data5_2
1 5 235 5000 0 0 0 1 80 140 2 0 0 0 0 0 0 0 0 0 0 0
1 5 236 5000 0 0 0 1 80 140 2 0 0 0 0 0 0 0 0 0 0 0
and back
Code:
Service OwnerTeleport TargetTeleport Fee RestrictBindMethod RunTimeTeleportMethod CheckResult Restrict1 Data1_1 Data1_2 Restrict2 Data2_1 Data2_2 Restrict3 Data3_1 Data3_2 Restrict4 Data4_1 Data4_2 Restrict5 Data5_1 Data5_2
1 235 5 5000 0 0 0 1 80 140 2 0 0 0 0 0 0 0 0 0 0 0
1 236 5 5000 0 0 0 1 80 140 2 0 0 0 0 0 0 0 0 0 0 0
_RefObjCommon ???
_RefObjChar ???
|
|
|
07/30/2012, 02:33
|
#2
|
elite*gold: 0
Join Date: Jul 2012
Posts: 21
Received Thanks: 9
|
Just add the New Custom Npc For Teleport by this query
Quote:
USE SRO_VT_SHARD /* Add new Teleport By Arabianfox */
DECLARE @Teleport VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
DECLARE @CHARNAME2 VARCHAR (30)
DECLARE @OwnTeleport INT
DECLARE @Fee INT
DECLARE @RequiredLVL INT
/* Put your settings here */
SET @Teleport = 'PVP_ZONE' -- any name you want ex: PK_ZONE or PVP_ZONE
SET @CHARNAME1 = 'CHARNAME1' -- Teleport position
SET @CHARNAME2 = 'CHARNAME2' -- Spawn position after teleport
SET @OwnTeleport = 1 -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople
SET @Fee = 50000 -- Gold amount to Pass the teleport
SET @RequiredLVL = 0 -- minimum level required to teleport 0 for no restriction - ex:90 lvl 90 and higher can teleport
/* settings area end here */
IF EXISTS (SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = 'STORE_'+@Teleport)
BEGIN
raiserror('The stated teleportname of %s is already exist!',11,1,@Teleport);
RETURN;
END
DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1
DECLARE @REGION1 INT SET @REGION1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSX1 INT SET @POSX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSY1 INT SET @POSY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSZ1 INT SET @POSZ1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @LINK INT = (SELECT MAX (ID) FROM _RefObjStruct)+1
SET IDENTITY_INSERT _RefObjCommon ON
INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName1 28,NameStrID128,DescStrID128,CashItem,Bionic,TypeI D1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarit y,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPic k,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRe pair,CostRevive,CostBorrow,KeepingFee,SellPrice,Re qLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqL evelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxCon tain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,S peed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj 128,AssocFileDrop128,AssocFileIcon128,AssocFile1_1 28,AssocFile2_128,Link) VALUES
(1,@MAXOBJ,'STORE_'+@Teleport,@Teleport,'xxx','SN_ STORE_'+@Teleport,'xxx',0,0,4,1,1,0,0,3,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,@REGION1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,' quest\teleport01.bsr','xxx','xxx','xxx','xxx',@lin k)
SET IDENTITY_INSERT _RefObjCommon OFF
print ''
print 'Add the following line to teleportbuilding.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXOBJ)+' '+'STORE_'+@Teleport+' '+@Teleport+' xxx '+'SN_STORE_'+@Teleport+' xxx 0 0 4 1 1 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 '+CONVERT(varchar(max),@REGION1)+' 0 '+CONVERT(varchar(max),@POSX1)+' '+CONVERT(varchar(max),@POSY1)+' '+CONVERT(varchar(max),@POSZ1)+' 0 0 50 50 30 0 quest\teleport01.bsr xxx xxx xxx xxx '+CONVERT(varchar(max),@link)
print ''
print 'Add the following line to textdata_object.txt @server_dep\silkroad\textdata folder'
print ''
print '1 '+'SN_STORE_'+@Teleport+' '+@Teleport
print ''
print ''
SET IDENTITY_INSERT _RefObjStruct ON
INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES
(@LINK,0)
SET IDENTITY_INSERT _RefObjStruct OFF
DECLARE @MAXTELID INT = (SELECT MAX (ID) FROM _RefTeleport)+1
DECLARE @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2)
DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2)
INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,Ass ocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos _Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGot oResurrectPos,GenWorldID,BindInteractionMask,Fixed Service) VALUES
(1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport, @MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POS Y2,@POSZ2,30,0,0,@WORLDID,1,0)
print ''
print 'Add the following line to teleportdata.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+'GATE_'+@Teleport+' '+CONVERT(varchar(max),@MAXOBJ)+' '+'SN_STORE_'+@Teleport+' '+CONVERT(varchar(max),@REGION2)+' '+CONVERT(varchar(max),@POSX2)+' '+CONVERT(varchar(max),@POSY2)+' '+CONVERT(varchar(max),@POSZ2)+' 30 0 0 '+CONVERT(varchar(max),@WORLDID)+' 1 0'
print ''
print ''
IF @RequiredLVL = 0
BEGIN
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,Data5_1,Data5_2) VALUES
(1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0)
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,Data5_1,Data5_2) VALUES
(1,@MAXTELID,@OwnTeleport,@Fee,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0)
print ''
print 'Add the following lines to teleportlink.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
print ''
END
ELSE BEGIN
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,Data5_1,Data5_2) VALUES
(1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLV L,999,0,0,0,0,0,0,0,0,0,0,0,0)
print ''
print ''
print 'Add the following line to teleportlink.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 1 '+CONVERT(varchar(max),@RequiredLVL)+' 999 0 0 0 0 0 0 0 0 0 0 0 0'
print ''
END
print ''
print 'Done!'
|
|
|
|
07/30/2012, 03:35
|
#3
|
elite*gold: 0
Join Date: Jan 2011
Posts: 373
Received Thanks: 71
|
Bro I Need X And Y Area Hehe
|
|
|
07/30/2012, 05:46
|
#4
|
elite*gold: 0
Join Date: Jul 2012
Posts: 21
Received Thanks: 9
|
did you mean you want the warps of this areas ?
|
|
|
07/31/2012, 14:53
|
#5
|
elite*gold: 0
Join Date: May 2011
Posts: 211
Received Thanks: 14
|
i think he want to know how to add teleport portal
|
|
|
|
Similar Threads
|
How to get out of the met zone and item quality upgrade question!
02/03/2009 - Conquer Online 2 - 3 Replies
First of all
How do I get out of the met zone WITHOUT dieing! Because I lost all my mets! Can someone like give me a diagram/map/etc. or directions to help me be able to get out of the met zone. (Were met doves are! Duhh!)
And Secondly
If I get a uni sword that is 2 soc, lvl 40 or lower, can I only use 1 db to get it to elite? So it will be elite 2 soc? Thx!
|
noob question about met zone
08/14/2006 - Conquer Online 2 - 4 Replies
this is a noob question but i heard that we can do that im just not sure, i saw some topics here in elitepvpers but i couldnt understand well if its able or not 2 do. the question is: theres any way 2 find the real met dove in met zone? maybe changing size of the doves that r not the real Meteor Dove, maybe changing the color (using the ID of real MeteorDove), or maybe using another way
|
Nothing in Met zone~ Nub question
04/22/2006 - Conquer Online 2 - 8 Replies
ok so ive only been playing for conquer a little time maybe 1month? and yea well i went to met zome And it was Absolutly deserted !!!!! nothing!!! i didnt even see one dude or a bird wahts with this? i travelled all thew way to that litle town and still no one and where are all the damn birds lol
|
All times are GMT +2. The time now is 10:34.
|
|