|
You last visited: Today at 01:15
Advertisement
how can i set it arena coin drops?
Discussion on how can i set it arena coin drops? within the SRO Private Server forum part of the Silkroad Online category.
03/09/2019, 02:27
|
#1
|
elite*gold: 0 
Join Date: Feb 2014
Posts: 2
Received Thanks: 0
|
how can i set it arena coin drops?
Hi all
I would like to ask for help so that I can set it to all mob drop arena coin
thx for help
|
|
|
|
03/09/2019, 11:15
|
#2
|
elite*gold: 47
Join Date: Oct 2017
Posts: 574
Received Thanks: 967
|
this is a query by town.. set the drop rate and etc.. btw it's wrong section
PHP Code:
USE SRO_VT_SHARD
DECLARE @Place VARCHAR(MAX),@Drop VARCHAR(MAX),@Rate real,@rows int = 0,@MinAmount int,@MaxAmount int,@RowsCount int
,@MobCode varchar(max),@ID int,@ItemID int
-------------------------------------------------------------------------------
SET @Place = 'JG' -- your desired area Jangan = JG, Donwhang = DW, Hotan = HT, Alex = AX, JobTemple = TP
SET @Drop = 'ITEM_ETC_SD_TOKEN_01' --Item CodeName
SET @Rate = '1' -- Drop Rate
SET @MinAmount = '1' --Minimum amount of item
SET @MaxAmount = '1' --Max amount of item
-------------------------------------------------------------------------------
IF @Place = 'JG'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like 'CHINA'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Jangan Mobs Successfully!'
END
ELSE IF @Place = 'DW'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like 'West_China'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Donwhang Mobs Successfully!'
END
ELSE IF @Place = 'HT'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like 'Oasis_Kingdom'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
END
ELSE IF @Place = 'AX'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like '%DELTA%' or ContinentName like '%SD%' or ContinentName like '%Pharaoh%' or ContinentName like '%KingsValley%'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Alexandria Mobs Successfully!'
END
ELSE IF @Place = 'TP'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like '%TEMPLE%'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Temple Mobs Successfully!'
END
ELSE
PRINT 'You wrote a wrong place name'
|
|
|
|
|
09/11/2019, 21:14
|
#3
|
elite*gold: 0
Join Date: Nov 2011
Posts: 228
Received Thanks: 18
|
Quote:
Originally Posted by bimbum*
this is a query by town.. set the drop rate and etc.. btw it's wrong section
PHP Code:
USE SRO_VT_SHARD
DECLARE @Place VARCHAR(MAX),@Drop VARCHAR(MAX),@Rate real,@rows int = 0,@MinAmount int,@MaxAmount int,@RowsCount int
,@MobCode varchar(max),@ID int,@ItemID int
-------------------------------------------------------------------------------
SET @Place = 'JG' -- your desired area Jangan = JG, Donwhang = DW, Hotan = HT, Alex = AX, JobTemple = TP
SET @Drop = 'ITEM_ETC_SD_TOKEN_01' --Item CodeName
SET @Rate = '1' -- Drop Rate
SET @MinAmount = '1' --Minimum amount of item
SET @MaxAmount = '1' --Max amount of item
-------------------------------------------------------------------------------
IF @Place = 'JG'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like 'CHINA'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Jangan Mobs Successfully!'
END
ELSE IF @Place = 'DW'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like 'West_China'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Donwhang Mobs Successfully!'
END
ELSE IF @Place = 'HT'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like 'Oasis_Kingdom'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
END
ELSE IF @Place = 'AX'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like '%DELTA%' or ContinentName like '%SD%' or ContinentName like '%Pharaoh%' or ContinentName like '%KingsValley%'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Alexandria Mobs Successfully!'
END
ELSE IF @Place = 'TP'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like '%TEMPLE%'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Temple Mobs Successfully!'
END
ELSE
PRINT 'You wrote a wrong place name'
|
"EXECUTING QUERY" NEVER ENDS :S
|
|
|
|
|
09/14/2019, 11:08
|
#4
|
elite*gold: 0
Join Date: Jun 2019
Posts: 43
Received Thanks: 9
|
Quote:
USE SRO_VT_SHARD
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
SET @MonsterID = 24082 --Enter the Monster ID you find here in the RefObjCommon table.
SET @DropRatio = 0.00004 -- This is the drop rate of the item (100% = 1, 50% = 0.5, 0% = 0)
SET @ItemID = 3851 --Enter the Item ID you find in the RefObjCommon table.
INSERT _RefMonster_AssignedItemDrop
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
)
VALUES(@MonsterID , @ItemID, 0, 0, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , '***')
|
u can try it
|
|
|
|
|
09/19/2019, 19:41
|
#5
|
elite*gold: 0
Join Date: Jul 2019
Posts: 89
Received Thanks: 22
|
USE SRO_VT_SHARD
GO
DECLARE @  ID int DECLARE @ ID int
DECLARE @ atio real
SET @ ID = 1954 -------- Mob,Unique ID you want Add Drop in SET @ atio = 1 -------- Item drop rate 1=100% , 0.3 = 30%
SET @ ID = 24670 -------- ITEM ID You want Add in Drops
INSERT _RefMonster_AssignedItemDrop
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
)
VALUES @ ID , @ ID, 0, 0, 1, 2, @ atio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')
Quote:
Originally Posted by ThievesUTD
"EXECUTING QUERY" NEVER ENDS :S
|
its working fine
|
|
|
|
 |
Similar Threads
|
Update 3 Weapon set Batman set Demon set and Barone set
03/21/2020 - Metin2 PServer Designs, Websites & Scripts - 5 Replies
Update my 3 Set weapon new claw weapon for lycan
Barone Set
Screen : http://djxm2m.com/photo/BaroneDjx.png
: http://djxm2m.com/photo/barone.jpg
Demon Set
Screen: http://i.imgur.com/FRan59H.gif
http://djxm2m.com/photo/game.jpg
: http://djxm2m.com/photo/DemonDjx.png
|
[Buying] Arena (Booster) Set/evtl Elite Set +, Ranking nicht Wichtig
09/27/2015 - World of Warcraft Trading - 6 Replies
Hey ihr lieben,
suche einen Aktiven und Seriösen Arena Booster.
Ich kann leider keine hunderte von Euros dafür Investieren, aber hoffe
dennoch auf einen angemessenen und fairen Preis.
Mir ist es nicht ganz so wichtig eine Arena Wertung von
von 3-4k oder mehr zu haben, das wichtigste für mich ist,
ich möchte sehr gerne das Arena Set + Waffen, alles was dazu gehört haben.
|
[Selling] Vampire vr14 arena set and other g armour set 400000gold
04/02/2015 - The Elder Scrolls Online Trading - 2 Replies
alot off mule chars alot off stuff done pvp rank 20 pve not much done around 50%missing lvl 50 horse with speed desk armored and bags then i sell another char called the wonderwoman vr lvl 12 necromancer set dont know how much gold but not much left i think no horse yet but u can buy 1 with the gold from the vr14 char the vr14 char name is mcmozes they have 0 gametime left but both got the veteran stuff pretty crappy pets ....game is nice but i dislike it since my guild left the game and pvp...
|
All times are GMT +1. The time now is 01:15.
|
|
