[REQUEST] Custom Teleport Problem

04/17/2017 21:07 vampi88#1
Hey guys....

I have an Problem but i cant fix it alone....

My F****** BU****** Problem:

I fount that via google..:

PHP Code:
USE SRO_VT_SHARD /* Add new Teleport By Arabianfox */


DECLARE  [MENTION=2110853]teleport[/MENTION] VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
DECLARE @CHARNAME2 VARCHAR (30)
DECLARE [MENTION=333751]Ownt[/MENTION]eleport INT
DECLARE @Fee 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 @CHARNAME1 = 'CHARNAME1' -- Teleport position
SET @CHARNAME2 = 'CHARNAME2' -- Spawn position after teleport
SET [MENTION=333751]Ownt[/MENTION]eleport = 1  -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople
SET @Fee = 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 @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1
    DECLARE  [MENTION=1184112]region[/MENTION]1 INT SET  [MENTION=1184112]region[/MENTION]1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1)
    DECLARE [MENTION=1524007]pos[/MENTION]X1 INT SET [MENTION=1524007]pos[/MENTION]X1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1)
    DECLARE [MENTION=1837537]posy[/MENTION]1 INT SET [MENTION=1837537]posy[/MENTION]1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1)
    DECLARE [MENTION=1914174]posz[/MENTION]1 INT SET [MENTION=1914174]posz[/MENTION]1 = (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,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,@MAXOBJ,'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=1184112]region[/MENTION]1,0 [MENTION=1524007]pos[/MENTION]X1 [MENTION=1837537]posy[/MENTION]1 [MENTION=1914174]posz[/MENTION]1,0,0,50,50,30,0,'quest\teleport01.bsr','xxx','xxx','xxx','xxx',@link)
    SET IDENTITY_INSERT _RefObjCommon OFF
    
    print ''
    print 'Add the following line to teleportbuilding.txt  [MENTION=485444]server[/MENTION]_dep\silkroad\textdata folder'
    print '1    '+CONVERT(varchar(max),@MAXOBJ)+'    '+'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=1184112]region[/MENTION]1)+'    0    '+CONVERT(varchar(max) [MENTION=1524007]pos[/MENTION]X1)+'    '+CONVERT(varchar(max) [MENTION=1837537]posy[/MENTION]1)+'    '+CONVERT(varchar(max) [MENTION=1914174]posz[/MENTION]1)+'    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  [MENTION=485444]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
  (@LINK,0)
  SET IDENTITY_INSERT _RefObjStruct OFF
  
  DECLARE [MENTION=835493]maxtel[/MENTION]ID INT = (SELECT MAX (ID) FROM _RefTeleport)+1
  DECLARE  [MENTION=3975794]worldi[/MENTION]D INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2)
  DECLARE  [MENTION=1184112]region[/MENTION]2 INT SET  [MENTION=1184112]region[/MENTION]2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2)
  DECLARE [MENTION=1524007]pos[/MENTION]X2 INT SET [MENTION=1524007]pos[/MENTION]X2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2)
  DECLARE [MENTION=1837537]posy[/MENTION]2 INT SET [MENTION=1837537]posy[/MENTION]2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2)
  DECLARE [MENTION=1914174]posz[/MENTION]2 INT SET [MENTION=1914174]posz[/MENTION]2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2)

  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=835493]maxtel[/MENTION]ID,'GATE_'  [MENTION=2110853]teleport[/MENTION],'STORE_'  [MENTION=2110853]teleport[/MENTION],@MAXOBJ,'SN_STORE_'  [MENTION=2110853]teleport[/MENTION]  [MENTION=1184112]region[/MENTION]2 [MENTION=1524007]pos[/MENTION]X2 [MENTION=1837537]posy[/MENTION]2 [MENTION=1914174]posz[/MENTION]2,30,0,0  [MENTION=3975794]worldi[/MENTION]D,1,0)
  
  print ''
  print 'Add the following line to teleportdata.txt  [MENTION=485444]server[/MENTION]_dep\silkroad\textdata folder'
  print '1    '+CONVERT(varchar(max) [MENTION=835493]maxtel[/MENTION]ID)+'    '+'GATE_'  [MENTION=2110853]teleport[/MENTION]+'    '+CONVERT(varchar(max),@MAXOBJ)+'    '+'SN_STORE_'  [MENTION=2110853]teleport[/MENTION]+'    '+CONVERT(varchar(max)  [MENTION=1184112]region[/MENTION]2)+'    '+CONVERT(varchar(max) [MENTION=1524007]pos[/MENTION]X2)+'    '+CONVERT(varchar(max) [MENTION=1837537]posy[/MENTION]2)+'    '+CONVERT(varchar(max) [MENTION=1914174]posz[/MENTION]2)+'    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=333751]Ownt[/MENTION]eleport [MENTION=835493]maxtel[/MENTION]ID,@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,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=835493]maxtel[/MENTION]ID [MENTION=333751]Ownt[/MENTION]eleport,@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  [MENTION=485444]server[/MENTION]_dep\silkroad\textdata folder'
    print '1    '+CONVERT(varchar(max) [MENTION=333751]Ownt[/MENTION]eleport)+'    '+CONVERT(varchar(max) [MENTION=835493]maxtel[/MENTION]ID)+'    '+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) [MENTION=835493]maxtel[/MENTION]ID)+'    '+CONVERT(varchar(max) [MENTION=333751]Ownt[/MENTION]eleport)+'    '+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,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=333751]Ownt[/MENTION]eleport [MENTION=835493]maxtel[/MENTION]ID,@Fee,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=485444]server[/MENTION]_dep\silkroad\textdata folder'
    print '1    '+CONVERT(varchar(max) [MENTION=333751]Ownt[/MENTION]eleport)+'    '+CONVERT(varchar(max) [MENTION=835493]maxtel[/MENTION]ID)+'    '+CONVERT(varchar(max),@Fee)+'    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....


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....

Pls guys help me


I´m searching a long time for some fix but i cant find one.....


Sry for my worst english! Love ya ^^
04/18/2017 14:08 Snow*#2
Double check your texts for multiple ID's or upload the text files in here and also the dmp file
04/18/2017 16:21 vampi88#3
So i added all....


I checked all lines again.... but i cant found an error


Thx for ur help
04/18/2017 16:47 blapanda#4
A teleporter is a structure, structures need to be added like items, NPCs and mobs inside their respective file structure (in this case chardata_#####.txt) and accordingly to your listed "what I've added so far where and what", I clearly see that you are missing that one entirely.

Just think "how is the client supposed to load something on that spot, when the regular base/raw data and information is missing?".
04/18/2017 17:03 vampi88#5
Quote:
Originally Posted by blapanda View Post
A teleporter is a structure, structures need to be added like items, NPCs and mobs inside their respective file structure (in this case chardata_#####.txt) and accordingly to your listed "what I've added so far where and what", I clearly see that you are missing that one entirely.

Just think "how is the client supposed to load something on that spot, when the regular base/raw data and information is missing?".
i add the lines and nothing changes......

so i opend the dmp file too and found that some missing

prim\mtrl\mob\taklamakan\devile

i add these and now i get the same DUMP but without that error



//////////////////////////////////////////////////////////////////


I checked the Chardata again and found a mistake...... with that freaking "0"

so now get i dc after login without any dump fild ;-( ;-) :-P
hmmmmmm
04/18/2017 21:20 WickedNite.#6
If you're a beginner, best advice I can give you is to learn how and which tables are connected, do some work manually until you understand, then either write your own queries or read what's released to understand what they do, cause nobody is just gonna fix a broken query that you have no idea what it actually does.
04/18/2017 23:14 vampi88#7
Sure i understand what u mean.... i hope u understand now what i say... because my english grammar is not so well....

I think that i know what the query do.... i have an whiteboard with all connections into that db.... so i try it every day to understand what i do and to solve that error but i cant find the answer.

The biggest problem is that nobody explain the problem. U cant find any guide...

Many guides are bull**** ....
every time try that or try that.....

so u cant learn anything....

I had never found an guide with good informations...

-> first u creat this line because..... -> then u must insert this line to that files because.....

thats the right way that people can lern something.....

I want to learn it.... so i try my best again and again and again...

I try it many times befor i open a post for help... so i only want a hint to fix that.... i dont want an full fix...


So pls tell me how i can do it right to lern more....

Im realy sorry for that horror english :-( I hope u can understand the main information ;-(



Gesendet von meinem HUAWEI LYO-L21 mit Hilfe von Elitepvpers, bereitgestellt von appyet.com
04/24/2017 11:13 vampi88#8
THX FOR UR HELP.....