|
You last visited: Today at 13:29
Advertisement
[Query]Disable Drop Tablets, And Add Drop Stones
Discussion on [Query]Disable Drop Tablets, And Add Drop Stones within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
03/20/2013, 17:50
|
#1
|
elite*gold: 0 
Join Date: Mar 2013
Posts: 47
Received Thanks: 14
|
[Query]Disable Drop Tablets, And Add Drop Stones
This query disable all tablet from mobs:
Code:
Update _RefDropItemAssign
set service = 0
where RefItemID between 6295 and 6678
and add stones to drop:
Code:
Update _RefDropItemAssign
set service = 1
where RefItemID between 6679 and 7062
and u can check it:
Stones service = 1
Code:
select * from _RefDropItemAssign where RefItemID between 6679 and 7062
Tablets service = 0
Code:
select * from _RefDropItemAssign where RefItemID between 6295 and 6678
by friend aqua2to.
|
|
|
|
03/20/2013, 18:28
|
#2
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,309
Received Thanks: 6,470
|
#approved
|
|
|
|
|
03/21/2013, 02:23
|
#3
|
elite*gold: 0
Join Date: Sep 2012
Posts: 222
Received Thanks: 91
|
Ty..
|
|
|
|
|
03/21/2013, 09:26
|
#4
|
elite*gold: 460
Join Date: Jul 2012
Posts: 394
Received Thanks: 271
|
old but thanks
|
|
|
|
|
05/10/2016, 07:13
|
#5
|
elite*gold: 0
Join Date: Aug 2012
Posts: 43
Received Thanks: 1
|
Msg 208, Level 16, State 1, Line 1
Invalid object name '_RefDropItemAssign'.
????
i can not query
|
|
|
|
|
05/10/2016, 09:29
|
#6
|
elite*gold: 0
Join Date: Jul 2009
Posts: 1,860
Received Thanks: 757
|
Quote:
Originally Posted by Anonyxx
Msg 208, Level 16, State 1, Line 1
Invalid object name '_RefDropItemAssign'.
????
i can not query
|
|
|
|
|
|
05/12/2016, 04:43
|
#7
|
elite*gold: 0
Join Date: Aug 2012
Posts: 43
Received Thanks: 1
|
Quote:
Originally Posted by blapanda
|
how >>??
HELP ME !!!! 
|
|
|
|
|
05/14/2016, 02:25
|
#8
|
elite*gold: 0
Join Date: Aug 2012
Posts: 43
Received Thanks: 1
|
i wanna disbale stone ? can u help me??
|
|
|
|
|
05/26/2016, 12:10
|
#9
|
elite*gold: 0
Join Date: May 2016
Posts: 89
Received Thanks: 30
|
Thank You
|
|
|
|
|
10/25/2016, 14:28
|
#10
|
elite*gold: 0
Join Date: Jan 2009
Posts: 944
Received Thanks: 404
|
Quote:
Originally Posted by Anonyxx
how >>??
HELP ME !!!! |
make sure you execute it into your shard db
|
|
|
|
|
10/27/2016, 20:58
|
#11
|
elite*gold: 0
Join Date: Mar 2016
Posts: 68
Received Thanks: 37
|
Quote:
Originally Posted by Anonyxx
i wanna disbale stone ? can u help me??
|
use this querys to disable stones drop
Code:
Use
SRO_VT_SHARD
update _RefDropClassSel_Alchemy_ATTRStone set ProbGroup1 = '0' , ProbGroup2 = '0' , ProbGroup3 = '0' , ProbGroup4 = '0' ,
ProbGroup5 = '0' , ProbGroup6 = '0' , ProbGroup7 = '0' , ProbGroup8 = '0' , ProbGroup9
= '0' , ProbGroup10 = '0' , ProbGroup11 = '0' , ProbGroup1 = '0' , ProbGroup12 = '0'
Code:
Use
SRO_VT_SHARD
update _RefDropClassSel_Alchemy_MagicStone set ProbGroup1 = '0' , ProbGroup2 = '0' , ProbGroup3 = '0' , ProbGroup4 = '0' ,
ProbGroup5 = '0' , ProbGroup6 = '0' , ProbGroup7 = '0' , ProbGroup8 = '0' , ProbGroup9
= '0' , ProbGroup10 = '0' , ProbGroup11 = '0' , ProbGroup1 = '0' , ProbGroup12 = '0'
|
|
|
|
 |
Similar Threads
|
[Release] Query To Drop D13
03/25/2019 - SRO PServer Guides & Releases - 9 Replies
Welcome All
I Know Its Very Old And 90 % Do It But Begnnier Still Can't Do It !
So Today I Will Share This To Help Begnniers
Lets Start
First Query
UPDATE . set ProbGroup34='14.999' where MonLevel='121'
UPDATE . set ProbGroup35='14.999' where MonLevel='121'
UPDATE . set ProbGroup36='14.999' where MonLevel='121'
UPDATE . set ProbGroup34='14.999' where MonLevel='122'
|
[QUESTION] Stones Drop
04/16/2012 - EO PServer Hosting - 8 Replies
Hello guys :handsdown:
I placed in my cq_dropitemrule the Stones ID, but i think it isn't only there, i expect it's in cq_monstertype but don't know the exact place.
Can someone help-me to set the Stones drop chance?
Ty!
|
Help Add Drop Stones 13D
04/12/2012 - SRO Private Server - 0 Replies
I need some help with drop stones 13D. The problem is in sr_gameserver show me job overlop so i dont have idea what i need to fix it thanks
|
Trick or hack to make the character stones fast drop like the zero stones?
01/06/2012 - Grand Chase Philippines - 4 Replies
Is there a Trick or hack to make the characters stones in dungeon x2 or a fast drop????
like ley mission 50 stones at the 1st 50 stones to second so boring....
:handsdown::handsdown::handsdown:
|
[REQUEST] Boss drop Query compatible with Revos DB (Sword Stalker)!
03/07/2011 - EO PServer Hosting - 2 Replies
someone have the boss drop query compatible with revos db by sword stalker.
i need it :(
regards.
|
All times are GMT +2. The time now is 13:29.
|
|
![[Query]Disable Drop Tablets, And Add Drop Stones](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/query-disable-drop-tablets-add-drop-stones_ltr.gif){kind=small}
