Register for your free account! | Forgot your password?

You last visited: Today at 01:49

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

Advertisement



Help SQL query add drop to multiple mobs.

Discussion on Help SQL query add drop to multiple mobs. within the SRO PServer Questions & Answers forum part of the SRO Private Server category.

Reply
 
Old   #1
 
janicka's Avatar
 
elite*gold: 0
Join Date: Jun 2008
Posts: 701
Received Thanks: 213
Help SQL query add drop to multiple mobs.

Hello, i wanna add drop to all mobs in JG Cave, but im not good in SQL query, can someone help me ? im thinking on some like "Select ID from _RefObjCommon where CodeName128 like 'MOB_TQ_% Insert @id 2493 into _RefMonster_AssignedItemDrop " Or some like that. Can someone pls help me? Thx
janicka is offline  
Old 03/19/2025, 00:34   #2

 
Worshiper's Avatar
 
elite*gold: 136
Join Date: May 2017
Posts: 1,160
Received Thanks: 253
yes you can use this
Worshiper is offline  
Old 03/19/2025, 07:16   #3
 
janicka's Avatar
 
elite*gold: 0
Join Date: Jun 2008
Posts: 701
Received Thanks: 213
Quote:
Originally Posted by Worshiper View Post
yes you can use this
No, i cant, its for single mob. I need it for many mobs.
janicka is offline  
Old 03/25/2025, 06:21   #4




 
VORTEX*'s Avatar
 
elite*gold: 1014
Join Date: Apr 2015
Posts: 1,037
Received Thanks: 1,255
RefDropItemGroup
_RefMonster_AssignedItemDropRnd
VORTEX* is offline  
Thanks
1 User
Reply


Similar Threads Similar Threads
[SQL Query] Show All MOBS and MOBID's and ITEMS DROPPED
03/01/2017 - SRO PServer Guides & Releases - 3 Replies
This query will show every MOB and MOB ID as well as all ITEMS and ITEM ID's that MOBS have assigned to them. This will not show the drop classes for item groups, only the data within RefMonster_AssignedItemDrop USE SRO_VT_SHARD; SELECT innertable.MonsterID, innertable.Monster, innertable.ItemID, _RefObjCommon.CodeName128 AS Item FROM (SELECT _RefObjCommon.CodeName128 AS Monster, _RefMonster_AssignedItemDrop.RefMonsterID AS MonsterID,
[Query]Disable Drop Tablets, And Add Drop Stones
10/27/2016 - SRO PServer Guides & Releases - 10 Replies
This query disable all tablet from mobs: Update _RefDropItemAssign set service = 0 where RefItemID between 6295 and 6678 and add stones to drop:
[php][sql] php-sql query fetch JID as '0'
04/02/2016 - SRO Private Server - 1 Replies
fghfhgfhgfhgfh



All times are GMT +1. The time now is 01:50.


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

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