Disable Drops/Magic Pop items by CodeName128/Degree

[Naty48]

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 :

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 :

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 :

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 :

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 :

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 :

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.

 

[denise456]

Nice Job

 

[Crue]

Good Job Dude

 

[MaDenGo]

Thanks

 

[meowlicious]

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?

 

[Naty48]

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"

 

[tapsie]

Same Problem -.-

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

 

[Naty48]

i just tested it again.. , it works perfectly.

do exactly like that :

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.

 

[tapsie]

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

 

[Naty48]

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.

 

[tk69]

can i Disable seal of sun from drop? if yes tell me how plz,thank you.

 

[lovers2]

how i can up rate items drop from mobs