GET ALL Costume Item on item_db_re

[kangfredy]

hi i want to ask.how to get All costume item on database sql? how to query get that item?any specifiec type to detect what is costume item?

[Chaos92]

2 hours ago, kangfredy said:

 

SELECT * FROM `item_db_re` WHERE `name_aegis` LIKE '%costume%'

 

5 hours ago, kangfredy said:

hi i want to ask.how to get All costume item on database sql? how to query get that item?any specifiec type to detect what is costume item?

Most of costume have 'costume' or 'C_' word in its name in item_db_re_equip.sql

[kangfredy]

so how to get that via query? im try using  this query (in attachment) but the result is different

3 hours ago, Chaos92 said:

Most of costume have 'costume' or 'C_' word in its name in item_db_re_equip.sql

 

2 hours ago, Chaos92 said:

SELECT * FROM `item_db_re` WHERE `name_aegis` LIKE '%costume%'

ahhhhhhh thanks it's solve