|
You last visited: Today at 01:25
Advertisement
[Release]Simple Query How to add Drops in Mobs,Uniques
Discussion on [Release]Simple Query How to add Drops in Mobs,Uniques within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
09/01/2012, 12:07
|
#1
|
elite*gold: 86 
Join Date: Jan 2012
Posts: 335
Received Thanks: 133
|
[Release]Simple Query How to add Drops in Mobs,Uniques
Hello guys iam here to show you how to add new item to drops with Vsro Server files
Use This Query
PHP Code:
USE SRO_VT_SHARD -----> By-Flowushy <-----
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%
SET @ItemID = 24165 -------- 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(@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 find item ID in RefObjCommon
Use this Query
[php] Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_SWORD_10_C_RARE'
To find Monster ID in Ref Obj Common
Use This Query
PHP Code:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'MOB_SD_ANUBIS'
|
|
|
|
09/08/2012, 00:51
|
#2
|
elite*gold: 0
Join Date: May 2008
Posts: 21
Received Thanks: 0
|
fix
Msg 102, Level 15, State 1, Line 8
Incorrect syntax near '<'.
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '<'.
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near '<'.
|
|
|
|
|
12/21/2012, 12:20
|
#3
|
elite*gold: 0
Join Date: Dec 2007
Posts: 138
Received Thanks: 14
|
nice query ty =)
|
|
|
|
|
12/22/2012, 15:30
|
#4
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,510
Received Thanks: 886
|
atleast say who made it ?!
|
|
|
|
|
12/23/2012, 07:10
|
#5
|
elite*gold: 0
Join Date: Dec 2007
Posts: 138
Received Thanks: 14
|
This query is fully workin =)
its really very nice..
@ ahmed: simply delete < before the -------
then it willw ork =)
|
|
|
|
|
12/26/2012, 21:35
|
#6
|
elite*gold: 0
Join Date: Apr 2010
Posts: 223
Received Thanks: 6
|
Some1 know how to remove Drop  ?
|
|
|
|
|
01/01/2013, 13:58
|
#7
|
elite*gold: 0
Join Date: Nov 2011
Posts: 353
Received Thanks: 199
|
Nice keep it up 
|
|
|
|
|
01/03/2013, 15:08
|
#8
|
elite*gold: 0
Join Date: Dec 2007
Posts: 138
Received Thanks: 14
|
Very very nice query.
Checkout, i needed to edit the amount, too.
So i updated it a little bit =)
Directly removed < from description for retards who cant read posts =)
I don`t give for sure that is working by all ppl.
In SQL 2005/2008r2 it is working for sure =)
PHP Code:
USE SRO_VT_SHARD_INIT -----> By-Flowushy <----- ------> Updated by Luuk <------
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
DECLARE @DropAmountMin int
DECLARE @DropAmountMax int
SET @MonsterID = 24062 -------- Mob,Unique ID you want Add Drop in
SET @DropRatio = 1 -------- Item drop rate 1=100% , 0.3 = 30%
SET @ItemID = 24670 -------- ITEM ID You want Add in Drops
SET @DropAmountMin = 5 -------- Amount of this item to Drop min
SET @DropAmountMax = 8 -------- Amount of this item to Drop max
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, @DropAmountMin, @DropAmountMax, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')
I ONLY EDITED CREDITS GO TO >>>> Flowushy <<<<
|
|
|
|
|
01/03/2013, 16:02
|
#9
|
elite*gold: 64
Join Date: Nov 2007
Posts: 1,167
Received Thanks: 1,005
|
Quote:
Originally Posted by Flowushy
Hello guys iam here to show you how to add new item to drops with Vsro Server files
Use This Query
PHP Code:
USE SRO_VT_SHARD -----> By-Flowushy <-----
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%
SET @ItemID = 24165 <-------- 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(@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 find item ID in RefObjCommon
Use this Query
[php] Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_SWORD_10_C_RARE'
To find Monster ID in Ref Obj Common
Use This Query
PHP Code:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'MOB_SD_ANUBIS'
i hoppe it works for all Elitepvpers Members, and sry for the bad english =) |
Nice, you can steal a simple query under your name.
|
|
|
|
|
02/07/2013, 23:18
|
#10
|
elite*gold: 0
Join Date: May 2010
Posts: 96
Received Thanks: 5
|
One question is it possible to add more then one item?? maybe 5-10 items in one querry to one monster...
|
|
|
|
|
02/08/2013, 13:55
|
#11
|
elite*gold: 41
Join Date: Oct 2012
Posts: 2,216
Received Thanks: 1,195
|
just give credits 
|
|
|
|
|
03/14/2013, 21:17
|
#12
|
elite*gold: 250
Join Date: Jan 2011
Posts: 389
Received Thanks: 182
|
Quote:
Originally Posted by terra006
Some1 know how to remove Drop ? |
DELETE FROM _RefMonster_AssignedItemDrop
WHERE REFMONSTERID='MOBID' AND REFITEMID='ITEMID'
Enjoy and Use ur Thanks :P
|
|
|
|
|
04/01/2013, 09:19
|
#13
|
elite*gold: 0
Join Date: Feb 2008
Posts: 225
Received Thanks: 22
|
does not work. I get dc right away after login. I used the arean coin to penon and muji.
|
|
|
|
|
05/21/2013, 08:56
|
#14
|
elite*gold: 0
Join Date: Dec 2009
Posts: 9
Received Thanks: 1
|
querry works nice on all mobs but not on new added mobs...exemple deathbone
|
|
|
|
|
06/11/2013, 18:01
|
#15
|
elite*gold: 0
Join Date: Aug 2006
Posts: 8
Received Thanks: 0
|
working 100% ty
|
|
|
|
 |
|
Similar Threads
|
Neue Mobs Query
08/21/2013 - Metin2 Private Server - 2 Replies
Hey, ich habe seit kurzem neue Serverfiles und dort sind die neuen monster leider nicht enthalten...
Ähm kann mir eventuell jemand die Querys Posten oder mir per PN schicken?
Mfg Langeweile2011
|
Uniques Drops
05/09/2012 - SRO Private Server - 10 Replies
Ive added some drops to uniques but if a lvl 120 kills tiger girl the item wont drop is this cause level to high or how would i set so will drop
|
Transfering EU mobs drops to China mobs
04/27/2012 - SRO Private Server - 2 Replies
Hello, maybe there is people who successfully made chinese mobs to drop europe items? I have no idea how it is possible to make it, because every weapon/armor part have different tiers (A, B, C) and so on. Doing this only mobs in CH, WC and OA needs to be edited, because from hotan (KT) region mobs starting to drop both, CH and EU items.
I think adding it to the _RefMonster_AssignedItemDrop table is not the way, because for weapons/equipment server randomly generates blues, whole item stats,...
|
[Release] VSRO Jupter + all mobs + drops itens D12
04/08/2012 - SRO Private Server - 15 Replies
CLOSED
|
[Release] Simple Auto CPs from Killing Mobs (LOFT)
08/28/2010 - CO2 PServer Guides & Releases - 37 Replies
By the way...this is first post about Auto CPs for LOFT OK?
Press Thanks Instead of Flame..:D
Here we go:
In Character.cs
Search for public void BlueNameGone()
under it, add
public void DirectCPs()//by UnoAmigos
{
|
All times are GMT +2. The time now is 01:25.
|
|
![[Release]Simple Query How to add Drops in Mobs,Uniques](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-simple-query-how-add-drops-mobs-uniques_ltr.gif){kind=small}
