MONSTER
|
Last Activity: 07/25/2020 18:29
Mentions
| 04/19/2025 |
| 23:56 - Dacks87 mentioned MONSTER in post I-Sro R Files MonsterDrop ich habe da was für dich
USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By nukertube*/
GO
DECLARE mob VarChar(MAX) item VarChar(MAX) MONSTERID iNt itemID iNt Dropratio ReaL, DropAmountMin INT, DropAmountMax INT
--------------------------------------------------------------------------
SET mob = 'MOB_J... |
| 03/19/2025 |
| 00:34 - Worshiper mentioned MONSTER in post Help SQL query add drop to multiple mobs. yes you can use this
https://www.elitepvpers.com/forum/sro-pserver-guides-releases/2098458-release-simple-query-how-add-drops-mobs-uniques.html |
| 05/14/2020 |
| 21:13 - ...want to add 1 item to many unique i use this querry :
USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By nukertube*/
GO
DECLARE mob VarChar(MAX) item VarChar(MAX) MONSTERID iNt itemID iNt Dropratio ReaL, DropAmountMin INT, DropAmountMax INT
--------------------------------------------------------------------------
SET mob = 'MOB... |
| 09/19/2019 |
| 19:41 - USE SRO_VT_SHARD
GO
DECLARE MONSTERID int
DECLARE itemID int
DECLARE Dropratio real
SET MONSTERID = 1954 -------- Mob,Unique ID you want Add Drop in
SET Dropratio = 1 -------- Item drop rate 1=100% , 0.3 ... |
| 06/03/2019 |
| 21:49 - Hello!
i have question about drops
i added some global/reverse drops in uniques
2 each
with chance 100%
but its not always dropping 2 , sometimes 1 or 0 ..
DropAmountMin// Drop... |
| 11/29/2018 |
| 19:50 - Worshiper mentioned MONSTER in post Database vehalla help drop rate 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 -------- Item drop rate 1=100% , 0.3 = 30... |
| 07/04/2018 |
| 17:47 - NorseGodTyr mentioned MONSTER in post problem with drop & guild union ... guild members the 50 of em, wish means broke the limit of authority union
thanks in advance.
1. Query you need add to every single mob
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.... |
| 06/26/2018 |
| 22:44 - Mc-Diesel mentioned MONSTER in post ٍSQL Experts Wanna Make This Query Added multiple Value To make it Easier to Add Full Degree As A Drop
USE/**/[SRO_VT_SHARD]/**/
GO
DECLARE mob VarChar(MAX) item VarChar(MAX) MONSTERID iNt itemID iNt Dropratio ReaL, DropAmountMin INT, DropAmountMax INT
--------------------------------------------------------------------------
SET mob = '... |
| 09/11/2017 |
| 21:23 - sigel123456789 mentioned MONSTER in post Drop rate USE SRO_VT_SHARD -----> ( MaDenGo ) <-----
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%... |
| 05/27/2016 |
| 00:08 - TheKraken. mentioned MONSTER in post Vsro files: Add drops to elite mobs All you have to do is to get the elite monster code ( by GM/GA Char),
And to execute the next query with the code you got:
use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 = 'The code of the elite moster' ... |
| 03/09/2016 |
| 18:56 - NagySandor96 mentioned MONSTER in post Adding an item to a mob as a drop - why doesn't work to me ? ... can add any items to any mob as a drop,
after a quick searching I have found a query.
It's OK - I thought.
USE SRO_VT_SHARD -----> By-Flowushy <-----
GO
DECLARE @ MonsterID int
DECLARE @ ItemID int
DECLARE @ DropRatio real
SET = @ MonsterID = 9383 -------- Mob,Unique ID you want Add Drop in
SET @ DropRatio = 1 -------- Item drop rate... |
