ok i forgot the function to search the DB in sql by the scrips name to find items any help would be nice tyvm
Search by string in DB
10/18/2012 21:53
mlejnek2#1
10/18/2012 21:57
Albedaia#2
Where name like '%name item%'
10/19/2012 11:59
c1ph3r#3
A little info^^ Your string resource should be in the correct language :D 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:
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.
You need to dump the string resource from your client first.
Step 2:
Code:
SELECT * FROM dbo.ItemResource ITEM, dbo.StringResource STRING where STRING.code=ITEM.name_id and STRING.value like '%searchterm%'
10/20/2012 00:38
Makai_King_Zero#4
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....
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....
10/20/2012 01:25
Musta²#5
Quote:
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-).
10/20/2012 06:32
Makai_King_Zero#6
Actually I AM HeavenOnlyWishes.... This is my alt account for newer dev groups....
I know I've stated that before... Keep up Musta
I know I've stated that before... Keep up Musta
10/20/2012 06:36
HeavenOnlyWishes#7
See it's Makai King.... I can talk to myself, kool huh Musta XP
10/20/2012 09:21
Musta²#8
My bad :)
10/20/2012 11:56
c1ph3r#9
But with this method you have to go through about 20000 items and search for the correct one :DQuote:
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 hey everyone can decide on his own how to search for items^^ or something like this.
10/20/2012 16:10
Makai_King_Zero#10
Actually if you add:
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......
just below the WHERE statement, then you can search for specific item names....Quote:
AND value LIKE '%something%'
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......
10/21/2012 13:53
glandu2#11
everything about the select statement is here: [Only registered and activated users can see links. Click Here To Register...]
Or maybe this community wants all sql reference here for rappelz dbs :x
Or maybe this community wants all sql reference here for rappelz dbs :x