Teleport crash // PLS HELP
Hey guys....
I have an Problem but i cant fix it alone....
My F****** BU****** Problem:
I fount that in this forum
PHP Code:
USE SRO_VT_SHARD /* Add new Teleport By Arabianfox */
DECLARE [MENTION=2110853]teleport[/MENTION] VARCHAR (64)
DECLARE [MENTION=551894]Char[/MENTION]NAME1 VARCHAR (30)
DECLARE [MENTION=551894]Char[/MENTION]NAME2 VARCHAR (30)
DECLARE [MENTION=334703]Own[/MENTION]Teleport INT
DECLARE [MENTION=265699]Fee[/MENTION] INT
DECLARE [MENTION=1331661]Required[/MENTION]LVL INT
/* Put your settings here */
SET [MENTION=2110853]teleport[/MENTION] = 'PVP_ZONE' -- any name you want ex: PK_ZONE or PVP_ZONE
SET [MENTION=551894]Char[/MENTION]NAME1 = 'CHARNAME1' -- Teleport position
SET [MENTION=551894]Char[/MENTION]NAME2 = 'CHARNAME2' -- Spawn position after teleport
SET [MENTION=334703]Own[/MENTION]Teleport = 1 -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople
SET [MENTION=265699]Fee[/MENTION] = 50000 -- Gold amount to Pass the teleport
SET [MENTION=1331661]Required[/MENTION]LVL = 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_' [MENTION=2110853]teleport[/MENTION])
BEGIN
raiserror('The stated teleportname of %s is already exist!',11,1 [MENTION=2110853]teleport[/MENTION]);
RETURN;
END
DECLARE [MENTION=447213]Max[/MENTION]OBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1
DECLARE [MENTION=527330]region[/MENTION]1 INT SET [MENTION=527330]region[/MENTION]1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME1)
DECLARE @POSX1 INT SET @POSX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME1)
DECLARE @POSY1 INT SET @POSY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME1)
DECLARE @POSZ1 INT SET @POSZ1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME1)
DECLARE [MENTION=2000172648]link[/MENTION] INT = (SELECT MAX (ID) FROM _RefObjStruct)+1
SET IDENTITY_INSERT _RefObjCommon ON
INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES
(1 [MENTION=447213]Max[/MENTION]OBJ,'STORE_' [MENTION=2110853]teleport[/MENTION] [MENTION=2110853]teleport[/MENTION],'xxx','SN_STORE_' [MENTION=2110853]teleport[/MENTION],'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 [MENTION=527330]region[/MENTION]1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,'quest\teleport01.bsr','xxx','xxx','xxx','xxx' [MENTION=2000172648]link[/MENTION])
SET IDENTITY_INSERT _RefObjCommon OFF
print ''
print 'Add the following line to teleportbuilding.txt [MENTION=412249]Server[/MENTION]_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max) [MENTION=447213]Max[/MENTION]OBJ)+' '+'STORE_' [MENTION=2110853]teleport[/MENTION]+' ' [MENTION=2110853]teleport[/MENTION]+' xxx '+'SN_STORE_' [MENTION=2110853]teleport[/MENTION]+' 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) [MENTION=527330]region[/MENTION]1)+' 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) [MENTION=2000172648]link[/MENTION])
print ''
print 'Add the following line to textdata_object.txt [MENTION=412249]Server[/MENTION]_dep\silkroad\textdata folder'
print ''
print '1 '+'SN_STORE_' [MENTION=2110853]teleport[/MENTION]+' ' [MENTION=2110853]teleport[/MENTION]
print ''
print ''
SET IDENTITY_INSERT _RefObjStruct ON
INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES
[MENTION=2000172648]link[/MENTION],0)
SET IDENTITY_INSERT _RefObjStruct OFF
DECLARE [MENTION=447213]Max[/MENTION]TELID INT = (SELECT MAX (ID) FROM _RefTeleport)+1
DECLARE [MENTION=3975794]worldi[/MENTION]D INT = (SELECT (WorldID) FROM _Char where CharName16 = [MENTION=551894]Char[/MENTION]NAME2)
DECLARE [MENTION=527330]region[/MENTION]2 INT SET [MENTION=527330]region[/MENTION]2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME2)
DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME2)
DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME2)
DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME2)
INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID,BindInteractionMask,FixedService) VALUES
(1 [MENTION=447213]Max[/MENTION]TELID,'GATE_' [MENTION=2110853]teleport[/MENTION],'STORE_' [MENTION=2110853]teleport[/MENTION] [MENTION=447213]Max[/MENTION]OBJ,'SN_STORE_' [MENTION=2110853]teleport[/MENTION] [MENTION=527330]region[/MENTION]2,@POSX2,@POSY2,@POSZ2,30,0,0 [MENTION=3975794]worldi[/MENTION]D,1,0)
print ''
print 'Add the following line to teleportdata.txt [MENTION=412249]Server[/MENTION]_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max) [MENTION=447213]Max[/MENTION]TELID)+' '+'GATE_' [MENTION=2110853]teleport[/MENTION]+' '+CONVERT(varchar(max) [MENTION=447213]Max[/MENTION]OBJ)+' '+'SN_STORE_' [MENTION=2110853]teleport[/MENTION]+' '+CONVERT(varchar(max) [MENTION=527330]region[/MENTION]2)+' '+CONVERT(varchar(max),@POSX2)+' '+CONVERT(varchar(max),@POSY2)+' '+CONVERT(varchar(max),@POSZ2)+' 30 0 0 '+CONVERT(varchar(max) [MENTION=3975794]worldi[/MENTION]D)+' 1 0'
print ''
print ''
IF [MENTION=1331661]Required[/MENTION]LVL = 0
BEGIN
INSERT INTO _RefTeleLink (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) VALUES
(1 [MENTION=334703]Own[/MENTION]Teleport [MENTION=447213]Max[/MENTION]TELID [MENTION=265699]Fee[/MENTION],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,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) VALUES
(1 [MENTION=447213]Max[/MENTION]TELID [MENTION=334703]Own[/MENTION]Teleport [MENTION=265699]Fee[/MENTION],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 [MENTION=412249]Server[/MENTION]_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max) [MENTION=334703]Own[/MENTION]Teleport)+' '+CONVERT(varchar(max) [MENTION=447213]Max[/MENTION]TELID)+' '+CONVERT(varchar(max) [MENTION=265699]Fee[/MENTION])+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
print '1 '+CONVERT(varchar(max) [MENTION=447213]Max[/MENTION]TELID)+' '+CONVERT(varchar(max) [MENTION=334703]Own[/MENTION]Teleport)+' '+CONVERT(varchar(max) [MENTION=265699]Fee[/MENTION])+' 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,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) VALUES
(1 [MENTION=334703]Own[/MENTION]Teleport [MENTION=447213]Max[/MENTION]TELID [MENTION=265699]Fee[/MENTION],0,0,0,1 [MENTION=1331661]Required[/MENTION]LVL,999,0,0,0,0,0,0,0,0,0,0,0,0)
print ''
print ''
print 'Add the following line to teleportlink.txt [MENTION=412249]Server[/MENTION]_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max) [MENTION=334703]Own[/MENTION]Teleport)+' '+CONVERT(varchar(max) [MENTION=447213]Max[/MENTION]TELID)+' '+CONVERT(varchar(max) [MENTION=265699]Fee[/MENTION])+' 0 0 0 1 '+CONVERT(varchar(max) [MENTION=1331661]Required[/MENTION]LVL)+' 999 0 0 0 0 0 0 0 0 0 0 0 0'
print ''
END
print ''
print 'Done!'
OK.. script = working
so....
i insert this:
teleportbuilding.txt
PHP Code:
1 62083 STORE_SALT_DESERT SALT_DESERT xxx SN_STORE_SALT_DESERT 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 21835 0 1548 131 1054 0 0 50 50 30 0 quest\teleport01.bsr xxx xxx xxx xxx 338
1 62084 STORE_KIRK KIRK xxx SN_STORE_KIRK 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 22098 0 1265 329 502 0 0 50 50 30 0 quest\teleport01.bsr xxx xxx xxx xxx 339
and
teleportdata.txt
PHP Code:
1 556 GATE_SALT_DESERT 62083 SN_STORE_SALT_DESERT 21835 1444 119 1034 30 0 0 1 1 0
1 557 GATE_KIRK 62084 SN_STORE_KIRK 22098 1291 324 564 30 0 0 1 1 0
and
teleportlink.txt
PHP Code:
1 557 556 50000 0 0 0 1 115 999 0 0 0 0 0 0 0 0 0 0 0 0
1 556 557 50000 0 0 0 1 115 999 0 0 0 0 0 0 0 0 0 0 0 0
and last but not least this
textdata_object.txt
PHP Code:
1 SN_STORE_SALT_DESERT Salt Desert
1 SN_STORE_KIRK Kirk
into the MEDIA.... ( teleportdata / teleportlink / teleportbuilding / textdata_object )
Server starts without errors..
open Client
-
push Start
-
Login
-
select the Char
-
push START
-
LOADING
-
SRO Close without any error or something else.....
WTF... I checked all but i cant find any error....
SO WHAT IS MY FAILURE?
maby wrong entry? or false table?
did i have connect all tables correct???
or can anyone tell me the right way to add an new teleport....
Pls guys help me
I´m searching a long time for some fix but i cant find one.....
Sry for my worst english!
