Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 17:34

  • Please register to post and access all features, it's quick, easy and FREE!

 

Search by string in DB

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2012
Posts: 356
Received Thanks: 32
Search by string in DB

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



mlejnek2 is offline  
Old   #2
 
elite*gold: 0
Join Date: Jun 2011
Posts: 20
Received Thanks: 25
Where name like '%name item%'


Albedaia is online now  
Old   #3
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
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:

Code:
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.
c1ph3r is offline  
Old   #4
 
elite*gold: 0
Join Date: Sep 2012
Posts: 60
Received Thanks: 10
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....


Makai_King_Zero is offline  
Old   #5
 
elite*gold: 0
Join Date: May 2011
Posts: 526
Received Thanks: 346
Quote:
Originally Posted by Makai_King_Zero View Post
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-).
MuStA2222 is offline  
Old   #6
 
elite*gold: 0
Join Date: Sep 2012
Posts: 60
Received Thanks: 10
Actually I AM HeavenOnlyWishes.... This is my alt account for newer dev groups....

I know I've stated that before... Keep up Musta
Makai_King_Zero is offline  
Old   #7
 
elite*gold: 0
Join Date: Jul 2011
Posts: 236
Received Thanks: 74
See it's Makai King.... I can talk to myself, kool huh Musta XP
HeavenOnlyWishes is offline  
Old   #8
 
elite*gold: 0
Join Date: May 2011
Posts: 526
Received Thanks: 346
My bad
MuStA2222 is offline  
Old   #9
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Makai_King_Zero View Post
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.
c1ph3r is offline  
Old   #10
 
elite*gold: 0
Join Date: Sep 2012
Posts: 60
Received Thanks: 10
Actually if you add:
Quote:
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......
Makai_King_Zero is offline  
Old   #11
 
elite*gold: 0
Join Date: Apr 2012
Posts: 449
Received Thanks: 770
everything about the select statement is here: SELECT (Transact-SQL)
Or maybe this community wants all sql reference here for rappelz dbs :x


glandu2 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[Visual Basic] [Problem] String auslesen/String zufällig wählen
Code: #include <GUIConstants.au3> #Region ### START Koda GUI section ### Form= $Form1 = GUICreate("Name Generator", 236, 299, 815, 246)...
4 Replies - General Coding
[VB08]String in String mit mehreren Funden
Hey, bin gerade auf ein Problem gestoßen, an dem ich mir seit 3 Stunden die Zähne ausbeiße. Ich will eine Funktion schreiben, die der...
6 Replies - .NET Languages
[C++] string zwischen string
tag gibts direkt ne funktion, mit der man einen passenden string zwischen dem string suchen kann? also meine net .find() sondern sowas ähnliches,...
6 Replies - C/C++
[Search]Guide To make Edits With PhotoShop cs4 with Photos [Search]
Hello i founded this Post http://www.elitepvpers.com/forum/co2-guides-templates/155997-ultimate-guide-how-make-conquer-edits.html But its for cs2...
0 Replies - CO2 Guides & Templates



All times are GMT +2. The time now is 17:34.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.