|
You last visited: Today at 00:18
Advertisement
Fast Query to Add Drops in Mob , Unique or what ever ^^
Discussion on Fast Query to Add Drops in Mob , Unique or what ever ^^ within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
09/11/2012, 05:44
|
#1
|
elite*gold: 5
Join Date: May 2012
Posts: 217
Received Thanks: 113
|
Fast Query to Add Drops in Mob , Unique or what ever ^^
Quote:
USE SRO_VT_SHARD
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
SET @MonsterID = 3810 <-------- Mob,Unique ID you want Add Drop in
SET @DropRatio = 1 <-------- Drop Ration 1=100% , 0.5 = 50%
SET @ItemID = 24165 <-------- ITEM ID You want Add in Drop
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 , 'xxx')
|
To get mob ID use this Query
Quote:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC'
|
Change MOB_RM_ROC With your Monster or Unique Code
To get ITEM ID use this Query
Quote:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_TBLADE_11_SET_A_RARE'
|
Change ITEM_CH_TBLADE_11_SET_A_RARE to Any item you want
Hope Be Helpfull Thanks..
|
|
|
09/13/2012, 06:15
|
#2
|
elite*gold: 0
Join Date: Sep 2012
Posts: 116
Received Thanks: 64
|
I think this query released before
|
|
|
|
Similar Threads
|
[Release]Simple Query How to add Drops in Mobs,Uniques
01/22/2021 - SRO PServer Guides & Releases - 30 Replies
Hello guys iam here to show you how to add new item to drops with Vsro Server files
Use This Query
USE SRO_VT_SHARD -----> By-Flowushy <-----
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
|
[Help] SQL Query to make all unique spawn in one point :P
08/09/2012 - SRO Private Server - 0 Replies
SQL Query to make all unique spawn in one point :P
Thanks :) <3
|
Show Your Unique Kills, Drops, and Items
06/25/2012 - Silkroad Online - 2998 Replies
Post a picture along with what server youre playing on here
my partys dropp from a giant:
http://img40.imageshack.us/img40/1824/lvl8axe.jpg
|
Show your char, drops and unique Kills !
10/05/2010 - SRO Private Server - 7091 Replies
NOTE FROM YO123: EVERY POST WITHOUT A SCREENSHOT WILL BE INFRACTED!
________________
Hello guys Today i was grinding and i came home and i was eating and just i saw a sos Item Deamon Polearm
and Look what it is !
http://img26.imageshack.us/img26/2871/sro20090217 00481657ei6.th.jpg
|
[ZSZC] Show Your Char, Unique Kill, and Drops
05/05/2010 - SRO Private Server - 3 Replies
Hey Guys i wanted to make a Thread for Ppl in ZSZC ONLY to show their pics of their chars, Unique kills and Drops Whatever May Be
(Please Only from the ZSZC PServer)
Here is my Pic From LordYarken When Beta was opened Still:
http://i938.photobucket.com/albums/ad225/ssj34jon /SRO2010-05-0217-08-23_66.jpg
Here is another one that i killed Tigergirl today:
http://i938.photobucket.com/albums/ad225/ssj34jon /SRO2010-05-0419-13-55_97.jpg
|
All times are GMT +2. The time now is 00:18.
|
|