Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Disable Drops/Magic Pop items by CodeName128/Degree

CPP/C#/PHP/ASM
Joined
Apr 7, 2009
Messages
452
Reaction score
189
hey guys ,

here is some simple but yet useful queries that i created and might be useful for people who needs it,
----------
Magic Pop
----------

See all Magic pop items with names and service :

Code:
select p.Service,p.RefItemID, p.Set_ID, a.ID, a.CodeName128from _RefGachaItemSet p
inner join _RefObjCommon a on a.ID = p.RefItemID

See All Magic Pop items by Item Degree :

Code:
select p.Service,p.RefItemID, p.Set_ID, a.ID, a.CodeName128from _RefGachaItemSet p
inner join _RefObjCommon a on a.ID = p.RefItemID
where a.CodeName128 like '[COLOR=#ff0000]%_10_%C_RARE%[/COLOR]' and p.Service = [COLOR=#ff0000]0[/COLOR] and a.CodeName128 not like '%etc%'

(you can change %_10_%C_RARE% to what ever you want "%_10_%C_RARE%" = Suns 10D and also if you want to see Disabled Items too , just remove "and p.Service = 0")


see all items from magic pop that you can get if you fail :

Code:
select 
p.Service,
p.RefItemID,
p.Set_ID,
a.ID,
a.CodeName128
from _RefGachaItemSet p
inner join _RefObjCommon a on a.ID = p.RefItemID
where p.Set_ID = 2 and p.Service = 1


Disable Magic Pop Items by CodeName128 :

Code:
update _RefGachaItemSet
SET [COLOR=#ff0000]Service = 0[/COLOR]
from _RefGachaItemSet p
inner join _RefObjCommon a on a.ID = p.RefItemID
where a.CodeName128 like '[COLOR=#ff0000]%_11_%[/COLOR]' and p.Service = [COLOR=#ff0000]1[/COLOR] and a.CodeName128 not like '%etc%'




(Change '%_11_%' to what ever you want )

-------
Drops :
-------


Watch All drops (items) included names and Services and groups :


Code:
select p.Service,p.RefItemID, a.ID, a.CodeName128,p.DropCount,p.AssignedGroup,p.Prob_Relative
from _RefDropItemAssign p
inner join _RefObjCommon a on a.ID = p.RefItemID

disable/enable drop "items" by Codename :


Code:
update _RefDropItemAssign
SET Service = [COLOR=#ff0000]0[/COLOR]
from _RefDropItemAssign p
inner join _RefObjCommon a on a.ID = p.RefItemID
where a.CodeName128 like '[COLOR=#ff0000]%_11_%[/COLOR]' and p.Service = [COLOR=#ff0000]1[/COLOR]


(To Enable Set Service to 1 instead of 0, to change the items edit the "'%_11_%'" for anything else you want , '%_11_%' = all 11D Items! .)



i will update you guys with more queries soon , got plenty of them .

if someone needs something in particular , just pm me.
 
Last edited:
Newbie Spellweaver
Joined
Sep 16, 2011
Messages
15
Reaction score
0
use SRO_VT_SHARD
select p.Service,p.RefItemID, p.Set_ID, a.ID, a.CodeName128from _RefGachaItemSet p
inner join _RefObjCommon a on a.ID = p.RefItemID

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'p'.


why this? :)
 
CPP/C#/PHP/ASM
Joined
Apr 7, 2009
Messages
452
Reaction score
189
select p.Service,p.RefItemID, p.Set_ID, a.ID, a.CodeName128
from _RefGachaItemSet p
inner join _RefObjCommon a on a.ID = p.RefItemID

dont remove the space from CodeName128 to "from _RefGachaItemSet"
 
Newbie Spellweaver
Joined
Oct 22, 2011
Messages
33
Reaction score
1
Same Problem -.-

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'p'.
 
CPP/C#/PHP/ASM
Joined
Apr 7, 2009
Messages
452
Reaction score
189
i just tested it again.. , it works perfectly.

do exactly like that :

Code:
select p.Service,p.RefItemID, p.Set_ID, a.ID, a.CodeName128


from _RefGachaItemSet p


inner join _RefObjCommon a on a.ID = p.RefItemID

- DO NOT REMOVE THE SPACES/NEW LINES!.

all those queries must be used at "
SRO_VT_SHARD_INIT" in order to work.

if it's still don't work , upload a picture from the sql query analzyer , i wanna watch what you did that caused that.


 
Newbie Spellweaver
Joined
Oct 22, 2011
Messages
33
Reaction score
1
ok working fine this code :

select p.Service,p.RefItemID, p.Set_ID, a.ID, a.CodeName128
from _RefGachaItemSet p
inner join _RefObjCommon a on a.ID = p.RefItemID

i have rename SRO_VT_SHARD ----> SRO_VT_SHARD_INIT
THX for this lines :thumbup:
 
CPP/C#/PHP/ASM
Joined
Apr 7, 2009
Messages
452
Reaction score
189
enjoy mate .


im working on a few more.

removing all monster spawns with the same pk2 name .

remove all monsters from X level to X level.

multiplay monsters spawn from X level to X Level or Specific Area.

multiplay all attack pets attack .

and probably more later on.
 
Newbie Spellweaver
Joined
Oct 17, 2013
Messages
70
Reaction score
0
can i Disable seal of sun from drop? if yes tell me how plz,thank you.
 
Back
Top