Search by string in DB

[mlejnek2]

ok i forgot the function to search the DB in sql by the scrips name to find items any help would be nice tyvm

[Albedaia]

Where name like '%name item%'

[c1ph3r]

A little info^^ Your string resource should be in the correct language As far as i know the released dbs contain only one almost complete arabic stringresource.

You need to dump the string resource from your client first.

Step 2:

SELECT * FROM dbo.ItemResource ITEM, dbo.StringResource STRING
where STRING.code=ITEM.name_id and STRING.value like '%searchterm%'

You can replace the ItemResource with every other table. You only have to change the table and the sometimes the field with the name_id is called text_id that's all.

[Makai_King_Zero]

Another way to list is:
SELECT ITEM.id, item.name_id, STRING.value
FROM Arcadia.dbo.ItemResource ITEM, Arcadia.dbo.StringResource STRING
WHERE item.name_id = string.code
ORDER BY id ASC

I actually posted these queries like half a year ago....

[Musta²]

Originally Posted by Makai_King_Zero

Another way to list is:
SELECT ITEM.id, item.name_id, STRING.value
FROM Arcadia.dbo.ItemResource ITEM, Arcadia.dbo.StringResource STRING
WHERE item.name_id = string.code
ORDER BY id ASC

I actually posted these queries like half a year ago....

Join Date: Sep 2012 --> Yeah, half year ago.

This query was pasted by HeavenOnlyWishes in an index in Arcadia-Dev forums.

(You must have leeched it from Raskim's index -Page 5-).

[Makai_King_Zero]

Actually I AM HeavenOnlyWishes.... This is my alt account for newer dev groups....

I know I've stated that before... Keep up Musta

[HeavenOnlyWishes]

See it's Makai King.... I can talk to myself, kool huh Musta XP

[Musta²]

My bad

[c1ph3r]

Originally Posted by Makai_King_Zero

Another way to list is:
SELECT ITEM.id, item.name_id, STRING.value
FROM Arcadia.dbo.ItemResource ITEM, Arcadia.dbo.StringResource STRING
WHERE item.name_id = string.code
ORDER BY id ASC

I actually posted these queries like half a year ago....

But with this method you have to go through about 20000 items and search for the correct one

But hey everyone can decide on his own how to search for items^^ or something like this.

[Makai_King_Zero]

Actually if you add:

AND value LIKE '%something%'

just below the WHERE statement, then you can search for specific item names....

Common c1ph3r... we can't give them everything...... Well we could, but then they'd learn nothing.... lol

I just didn't add this because this was discussed in another post.... It's not like this is rocket science, I wouldn't even bother explaining that... The post would be waaaayyyyyyyyyyyy too long......

[glandu2]

everything about the select statement is here:
Or maybe this community wants all sql reference here for rappelz dbs :x