Hello Guys
First Thanks in advance
1- How To Add A New Telebort?!
And How To Add Minimum Level To Telebort ?!
And I Have A Teleport Gate In Jangan How to Move It To Downhang ?!
2- How To Add A New Elixir Have A Higher Amount Of Success Like crystal Elixir Etc
3- How To Change Trade Reward To 50 Arena Not 1 Like That Poor Query Do
4- Thanks Again
welcome , those who can help on here usually wont , those who do usually only answer with smart azz remarks like use brain.exe or google even though this "IS" the help section and Ask the Experts ....lol so here is a few answers to your questions and hope they help
--------------------
how to add a new teloporter
first you need 2 chars for this one where you want the new teleporter to be located which will be CHARNAME1 and the other one to locate where you want this teleporter to teleport you to CHARNAME2 now you must log them on and take them exactly where you want them to be then log them off completely that sets your location on the database to read from and here is a hint the teleporter will round up or down to the nearest whole number you can not use like 234.567 you can use 234 or 235 and so on
be sure to run a full backup "ANY" time you run a script especially one you find from someone you don't know and trust and its a good point to do it anyways and at any time you run one , just running scripts is a good way to destroy a database.
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' -- Teleporter 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 = 5000 -- 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
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)
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!'
be sure to edit your setting in the top to your char names and teleporter names , this script will also give you a full print out for your text data to put in your Media.pk2
at : Set @RequiredLvl you can set the min level there which answers the second part and to answer the 3rd part of your first question you go to database open table
dbo._RefTeleLink and see if you have OwnerTeleport =1 to TargetTeleport = 2
that mean Jangan teleporter "1" teleports you to Donwang teleporter "2" if not just insert this line into it and save it into your Media.pk2 text file reftelelink.txt
ok that takes care of all 3 parts of your first question...lol
ok for the elixer part i am not sure exactly what your meaning , are you wanting to make an all new elixer ? or fix the ones you already have or do all of them ?
as for Trade Reward you can set it to whatever you want by going to table dbo.TriJobRewards and edit them however you wish them to be like this:
welcome , those who can help on here usually wont , those who do usually only answer with smart azz remarks like use brain.exe or google even though this "IS" the help section and Ask the Experts ....lol so here is a few answers to your questions and hope they help
Aha ...
"smart azz", period.
You are deserving a cookie for your flawless help
welcome , those who can help on here usually wont , those who do usually only answer with smart azz remarks like use brain.exe or google even though this "IS" the help section and Ask the Experts ....lol so here is a few answers to your questions and hope they help
--------------------
how to add a new teloporter
first you need 2 chars for this one where you want the new teleporter to be located which will be CHARNAME1 and the other one to locate where you want this teleporter to teleport you to CHARNAME2 now you must log them on and take them exactly where you want them to be then log them off completely that sets your location on the database to read from and here is a hint the teleporter will round up or down to the nearest whole number you can not use like 234.567 you can use 234 or 235 and so on
be sure to run a full backup "ANY" time you run a script especially one you find from someone you don't know and trust and its a good point to do it anyways and at any time you run one , just running scripts is a good way to destroy a database.
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' -- Teleporter 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 = 5000 -- 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
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)
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!'
be sure to edit your setting in the top to your char names and teleporter names , this script will also give you a full print out for your text data to put in your Media.pk2
at : Set @RequiredLvl you can set the min level there which answers the second part and to answer the 3rd part of your first question you go to database open table
dbo._RefTeleLink and see if you have OwnerTeleport =1 to TargetTeleport = 2
that mean Jangan teleporter "1" teleports you to Donwang teleporter "2" if not just insert this line into it and save it into your Media.pk2 text file reftelelink.txt
ok that takes care of all 3 parts of your first question...lol
ok for the elixer part i am not sure exactly what your meaning , are you wanting to make an all new elixer ? or fix the ones you already have or do all of them ?
as for Trade Reward you can set it to whatever you want by going to table dbo.TriJobRewards and edit them however you wish them to be like this:
hope all this helps you out and if you need any more just private message me and i will be glad to help , Good Luck
Thanks Alot Bro You just Made Me Happy
Quote:
Originally Posted by mtnman33
welcome , those who can help on here usually wont , those who do usually only answer with smart azz remarks like use brain.exe or google even though this "IS" the help section and Ask the Experts ....lol so here is a few answers to your questions and hope they help
--------------------
how to add a new teloporter
first you need 2 chars for this one where you want the new teleporter to be located which will be CHARNAME1 and the other one to locate where you want this teleporter to teleport you to CHARNAME2 now you must log them on and take them exactly where you want them to be then log them off completely that sets your location on the database to read from and here is a hint the teleporter will round up or down to the nearest whole number you can not use like 234.567 you can use 234 or 235 and so on
be sure to run a full backup "ANY" time you run a script especially one you find from someone you don't know and trust and its a good point to do it anyways and at any time you run one , just running scripts is a good way to destroy a database.
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' -- Teleporter 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 = 5000 -- 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
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)
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!'
be sure to edit your setting in the top to your char names and teleporter names , this script will also give you a full print out for your text data to putyE=mtnman33;33096608]welcome , those who can help on here usually wont , those who do usually only answer with smart azz remarks like use brain.exe or google even though this "IS" the help section and Ask the Experts ....lol so here is a few answers to your questions and hope they help
--------------------
how to add a new teloporter
first you need 2 chars for this one where you want the new teleporter to be located which will be CHARNAME1 and the other one to locate where you want this teleporter to teleport you to CHARNAME2 now you must log them on and take them exactly where you want them to be then log them off completely that sets your location on the database to read from and here is a hint the teleporter will round up or down to the nearest whole number you can not use like 234.567 you can use 234 or 235 and so on
be sure to run a full backup "ANY" time you run a script especially one you find from someone you don't know and trust and its a good point to do it anyways and at any time you run one , just running scripts is a good way to destroy a database.
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' -- Teleporter 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 = 5000 -- 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
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)
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!'
be sure to edit your setting in the top to your char names and teleporter names , this script will also give you a full print out for your text data to put in your Media.pk2
at : Set @RequiredLvl you can set the min level there which answers the second part and to answer the 3rd part of your first question you go to database open table
dbo._RefTeleLink and see if you have OwnerTeleport =1 to TargetTeleport = 2
that mean Jangan teleporter "1" teleports you to Donwang teleporter "2" if not just insert this line into it and save it into your Media.pk2 text file reftelelink.txt
ok that takes care of all 3 parts of your first question...lol
ok for the elixer part i am not sure exactly what your meaning , are you wanting to make an all new elixer ? or fix the ones you already have or do all of them ?
as for Trade Reward you can set it to whatever you want by going to table dbo.TriJobRewards and edit them however you wish them to be like this:
Just assure yourself, elixiers does have a different parameter style.
For instance
-
Only 3 parameters are changing, always, (edit) for 12 pluses. You can also have a plus of 16, that means the column Param5 needs to get a lower value.
The calculation is like a byte counter.
First plus: (need to take a look, being online with my tablet)
Second plus: -
Third: -
Fourth: -
If you just set each plus chance to "1" (at my tool), which means literally 1% chance to succeed.
And your are just simply making an addition of those 4 values for a column (First Plus Result + Second Plus Result + Third Plus Result + Fourth Plus Result = Param#).
You know what? Post me your desired percentage chances, how many pluses you want, and I will paste those values here.
As I said above, either leave a notice here with your desired wishing values, or calculate them by yourself, if you want to learn anything.
Do as many Parameters (Param2, Param3, Param4, Param5, etc.) you like.
Thanks Actually It's Pretty Awesome Tool But What About Higher Plus I Mean More High Than The Tool Controls It ?!
One More Question How Could I Set A Max Plus ?!
I explained you the terms about "how to add more params", the table above is just an example for Param2 (plus 1 2 3 4) and Param3 (5 6 7 8). If you want more, because Param4 (9 10 11 12), you gotta add some more values to Param5 as 13 14 15 16, Param6 for 17 18 19 20, etc...
I don't remember any kind of offset which keeps limiting the enchantment to +12.
I only saw people developing checking queries for the procedures on the log database.
So, try it as I said. You can use the table above like a raw sheet for your parameters. You only need to lower the 4 values declared at the column [Desired Chance (%)], the more plus you have, the lower the value should be (lower value = lower success chance on the alchemy table, got it?).
I explained you the terms about "how to add more params", the table above is just an example for Param2 (plus 1 2 3 4) and Param3 (5 6 7 8). If you want more, because Param4 (9 10 11 12), you gotta add some more values to Param5 as 13 14 15 16, Param6 for 17 18 19 20, etc...
I don't remember any kind of offset which keeps limiting the enchantment to +12.
I only saw people developing checking queries for the procedures on the log database.
So, try it as I said. You can use the table above like a raw sheet for your parameters. You only need to lower the 4 values declared at the column [Desired Chance (%)], the more plus you have, the lower the value should be (lower value = lower success chance on the alchemy table, got it?).
Adv. B Elixir 10/05/2011 - SRO Private Server - 5 Replies What are the odds of this weapon giving Advanced B Elixir (SoX)?
http://img190.imageshack.us/img190/5234/weaponh.p ng
Thanks for the answers.
Adv. Elixir B Question 09/10/2011 - Silkroad Online - 11 Replies last night I got a D9 dark staff Seal of moon drop .. so I decided to destroy it & get a sealed Adv Elixir B for my D9 sun staff+5 & make it +7
so the question is do I need to make the moon staff +5 in order to be sure that I'll get an adv B or should I just destroy it now ?
please answer me if you have done it before I dont want to waste the moon staff :P .. thanks
Elixir Question 12/21/2010 - Silkroad Online - 9 Replies How many elixir do i nid to reach +7? or +5?
How many less with luck stone?
how many luck stone do i nid to reach +7 or +5?
