[HELP] Magic Pop i wanna know some thing about magic pop

[Mr Yuni ™]

Hello everyone,

I wanna know how to add items in npc and remove items from too how

[Worshiper]

_RefGachaItemSet
gachaitemset.txt

[Judgelemental]

Originally Posted by Mr Yuni ™

Hello everyone,

I wanna know how to add items in npc and remove items from too how

Check my posts from here.

[ZαKuRα]

DB dbo._RefGachaItemSet
Media gachaitemset.txt
Red= is the item you want to add (it is the ID of RefobjComm)
Green= is the Rate that will have the probability of winning it (1%= 100 & 100% = 10000)
Orange= and this would be the identificationGacha item ID
Blue= is the parameter where we implement blue example in Flags <M:str,1,3> = 3 str



use this query both to know which items you want to delete and to know the rate has any item!

USE SRO_VT_SHARD
GO
SELECT SEE.ItemID,
       _RefObjCommon.CodeName128 AS CodeName,
	   SEE.Ratio,
	    SEE.GachaID
FROM   (SELECT   _RefGachaItemSet.RefItemID AS ItemID,
				 _RefGachaItemSet.Ratio AS Ratio,
				 _RefGachaItemSet.GachaID AS GachaID
        FROM     _RefGachaItemSet, _RefObjCommon
        WHERE    _RefGachaItemSet.RefItemID = _RefObjCommon.ID
        GROUP BY _RefObjCommon.CodeName128, _RefGachaItemSet.RefItemID,_RefGachaItemSet.Ratio,_RefGachaItemSet.GachaID) AS SEE, _RefObjCommon
WHERE  SEE.ItemID = _RefObjCommon.ID Order by GachaID

I know you will wonder how I order them, as in which table I want to add, well the system automatically (I think according to their TypeID) will place them in the respective Tab, so you just have to add it in the DB and the client and that's it

[Mr Yuni ™]

Originally Posted by ZαKuRα

DB dbo._RefGachaItemSet
Media gachaitemset.txt
Red= is the item you want to add (it is the ID of RefobjComm)
Green= is the Rate that will have the probability of winning it (1%= 100 & 100% = 10000)
Orange= and this would be the identificationGacha item ID
Blue= is the parameter where we implement blue example in Flags <M:str,1,3> = 3 str



use this query both to know which items you want to delete and to know the rate has any item!

USE SRO_VT_SHARD
GO
SELECT SEE.ItemID,
       _RefObjCommon.CodeName128 AS CodeName,
	   SEE.Ratio,
	    SEE.GachaID
FROM   (SELECT   _RefGachaItemSet.RefItemID AS ItemID,
				 _RefGachaItemSet.Ratio AS Ratio,
				 _RefGachaItemSet.GachaID AS GachaID
        FROM     _RefGachaItemSet, _RefObjCommon
        WHERE    _RefGachaItemSet.RefItemID = _RefObjCommon.ID
        GROUP BY _RefObjCommon.CodeName128, _RefGachaItemSet.RefItemID,_RefGachaItemSet.Ratio,_RefGachaItemSet.GachaID) AS SEE, _RefObjCommon
WHERE  SEE.ItemID = _RefObjCommon.ID Order by GachaID

I know you will wonder how I order them, as in which table I want to add, well the system automatically (I think according to their TypeID) will place them in the respective Tab, so you just have to add it in the DB and the client and that's it

Thanks alot my friend , i will try it now.

Originally Posted by [GM]Dejo

_RefGachaItemSet
gachaitemset.txt

Yup , solved thanks alot .

Originally Posted by Judgelemental

Check my posts from here.

Thanks , am check ZaKuRa steps , and solved any thing thanks alot for your reply buddy.

[Judgelemental]

Originally Posted by Mr Yuni ™

Thanks alot my friend , i will try it now.



Yup , solved thanks alot .



Thanks , am check ZaKuRa steps , and solved any thing thanks alot for your reply buddy.

You are welcome. Should you lose at magic pop you have to define what item you get in case this happens.
Otherwise the client crashes.