Register for your free account! | Forgot your password?

You last visited: Today at 21:35

  • 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: 4
Join Date: May 2017
Posts: 1,124
Received Thanks: 247
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,032
Received Thanks: 1,249
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 21:36.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

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