yushiva stone

radik32 · 08/04/2019, 12:53

hi all, who have id yushiva stone ?
and dark cube?

medaion · 08/04/2019, 15:51

2016145 Pierre de Yushiva : Ange
2016146 Pierre de Yushiva : Mortel
2016147 Pierre de Yushiva : Esprit Malin
2016148 Pierre de Yushiva : Mort-Vivant
2016149 Pierre de Yushiva : Bête
2016150 Pierre de Yushiva : Humanoïde
2016151 Pierre de Yushiva : Mecha
2016152 Pierre de Yushiva : Dragon
2016161 Pierre de Yushiva : Antique
705047 Cube Obscur
705048 Cube Obscur (lié)

ThunderNikk · 08/04/2019, 16:42

Code:

USE [Arcadia]
SELECT ir.id, sr.[value]
FROM dbo.ItemResource AS ir
JOIN dbo.StringResource AS sr
ON ir.name_id = sr.code
WHERE sr.[value] LIKE '%Yushiva%s Stone%'

Code:

USE [Arcadia]
SELECT ir.id, sr.[value]
FROM dbo.ItemResource AS ir
JOIN dbo.StringResource AS sr
ON ir.name_id = sr.code
WHERE sr.[value] LIKE '%Dark Cube%'

radik32 · 08/04/2019, 17:03

ty all bro