Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 02:08

  • Please register to post and access all features, it's quick, easy and FREE!

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.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2014
Posts: 1
Received Thanks: 0
Question 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



mam54 is offline  
Old 03/09/2019, 11:15   #2
 
elite*gold: 0
Join Date: Oct 2017
Posts: 169
Received Thanks: 78
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 JGDonwhang DWHotan HTAlex AXJobTemple 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(CodeName128From _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 < @RowsCountBEGIN 
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 ''[email protected]Drop+' has been added to Jangan Mobs Successfully!' 
END 
ELSE IF @Place 'DW' 
BEGIN 
SET 
@RowsCount = (SELECT COUNT(CodeName128From _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 < @RowsCountBEGIN 
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 ''[email protected]Drop+' has been added to Donwhang Mobs Successfully!' 
END 
ELSE IF @Place 'HT' 
BEGIN 
SET 
@RowsCount = (SELECT COUNT(CodeName128From _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 < @RowsCountBEGIN 
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(CodeName128From _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 < @RowsCountBEGIN 
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 ''[email protected]Drop+' has been added to Alexandria Mobs Successfully!' 
END 
ELSE IF @Place 'TP' 
BEGIN 
SET 
@RowsCount = (SELECT COUNT(CodeName128From _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 < @RowsCountBEGIN 
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 ''[email protected]Drop+' has been added to Temple Mobs Successfully!' 
END 
ELSE  
PRINT 
'You wrote a wrong place name' 


bimbum* is offline  
Old 09/11/2019, 21:14   #3
 
elite*gold: 0
Join Date: Nov 2011
Posts: 84
Received Thanks: 3
Unhappy

Quote:
Originally Posted by bimbum* View Post
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 JGDonwhang DWHotan HTAlex AXJobTemple 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(CodeName128From _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 < @RowsCountBEGIN 
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 ''[email protected]Drop+' has been added to Jangan Mobs Successfully!' 
END 
ELSE IF @Place 'DW' 
BEGIN 
SET 
@RowsCount = (SELECT COUNT(CodeName128From _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 < @RowsCountBEGIN 
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 ''[email protected]Drop+' has been added to Donwhang Mobs Successfully!' 
END 
ELSE IF @Place 'HT' 
BEGIN 
SET 
@RowsCount = (SELECT COUNT(CodeName128From _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 < @RowsCountBEGIN 
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(CodeName128From _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 < @RowsCountBEGIN 
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 ''[email protected]Drop+' has been added to Alexandria Mobs Successfully!' 
END 
ELSE IF @Place 'TP' 
BEGIN 
SET 
@RowsCount = (SELECT COUNT(CodeName128From _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 < @RowsCountBEGIN 
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 ''[email protected]Drop+' has been added to Temple Mobs Successfully!' 
END 
ELSE  
PRINT 
'You wrote a wrong place name' 
"EXECUTING QUERY" NEVER ENDS :S
ThievesUTD is offline  
Old 09/14/2019, 11:08   #4
 
elite*gold: 0
Join Date: Jun 2019
Posts: 10
Received Thanks: 4
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
LiteSro is offline  
Reply


Similar Threads
[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...
Update 3 Weapon set Batman set Demon set and Barone set
03/02/2015 - Metin2 PServer Guides & Strategies - 3 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



All times are GMT +2. The time now is 02:08.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

BTC: 33E6kMtxYa7dApCFzrS3Jb7U3NrVvo8nsK
ETH: 0xc6ec801B7563A4376751F33b0573308aDa611E05

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2019 elitepvpers All Rights Reserved.