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
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)
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?".
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
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.
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
Custom Teleport crashes 06/29/2017 - SRO Private Server - 13 Replies Hi,
I'm adding a new teleport buildings,and everything seems fine on both client and server side,but whenever I click on the option "Select Teleport area" the client crashes..
I added the structure line to characterdata aswell as teleportbuilding,modified telelink.txt,textdate_object.txt and teleportdata.txt
Any idea?
[Crash]Custom Teleport - Strange Problem 02/04/2016 - SRO Private Server - 2 Replies Hello guys , i've just added 4 new custom teleports and they worked fine ..
but i added 5th one ( the same way didn't change anything ) it keeps crashing me
TeleportBuilding.txt
1 41802 STORE_TELEPORT_5 TELEPORT_5 xxx SN_STORE_ TELEPORT_5 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 22661 0 361 1470 1853 0 0 50 50 30 0 quest\ins_quest_teleport. bsr xxx xxx xxx xxx 98
PS: the same bsr of the other 4 teleports
teleportdata.txt...
Custom teleport bug, 05/09/2015 - SRO Private Server - 19 Replies Hello guys,
So, i added a new custom teleport, using this query :
USE SRO_VT_SHARD
DECLARE @Teleport VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
Problem With CUstom teleport items 06/25/2010 - EO PServer Hosting - 4 Replies ok so i did everything i get it on my toons names right codes seem right
but when i click to use it. it puts it on like its a pieace of armor any1 tell me were i went wrong?
theres the code i created for it but dunno were i went wrong any help?
M2 Multihack 1.8, Custom Teleport 1.2 06/12/2008 - Metin2 - 2 Replies Moin , moin ^^
Ich habe ein problem mit diesen Cheats: M2 Multihack 1.8, Custom Teleport 1.2 ...:confused:
Egal wann ich die öffne , jedes mal kommt ein Fenster mit : "Unexpected error"
Aber Multihack Selector 1.7 funkzioniert !
Wenn jemand das gleiche problem hatte , und / oder weis wie ich das beheben könnte bitte einfach mal melden ^^
Würde mich freuen :D