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,
See all Magic pop items with names and service :
See All Magic Pop items by Item Degree :
(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 :
Disable Magic Pop Items by CodeName128 :
(Change '%_11_%' to what ever you want )
Watch All drops (items) included names and Services and groups :
disable/enable drop "items" by Codename :
(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.
here is some simple but yet useful queries that i created and might be useful for people who needs it,
----------
Magic Pop
----------
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 :
-------
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: