Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 11:06

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

 

[looking for]New Items ID's

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2012
Posts: 13
Received Thanks: 0
[looking for]New Items ID's

Anybody got new item's ID's including dura equips/Master equips and skill card + all pets id's ?
Or tell me how do i check it in DB
Thanks in advance



Denis9518 is offline  
Old   #2


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
Use the fckng Search.......


Xijezu is offline  
Thanks
3 Users
Old   #3
 
elite*gold: 0
Join Date: Jan 2011
Posts: 134
Received Thanks: 61
SQL -> Arcadia -> ItemResource.

Good search
bwr_62 is offline  
Thanks
1 User
Old   #4
 
elite*gold: 0
Join Date: Aug 2011
Posts: 170
Received Thanks: 32
use brain
go
select Idea from brain


Modamer9 is offline  
Old   #5
 
elite*gold: 0
Join Date: Jan 2010
Posts: 390
Received Thanks: 392
Error Dbo.Brain Not found... \o/
ptifou78 is offline  
Thanks
1 User
Old   #6
 
elite*gold: 0
Join Date: Apr 2010
Posts: 389
Received Thanks: 289
Quote:
Originally Posted by ptifou78 View Post
Error Dbo.Brain Not found... \o/
XD
Strange2010 is offline  
Old   #7
 
elite*gold: 0
Join Date: Apr 2012
Posts: 22
Received Thanks: 1
try to search brain.exe in google
₡ĦŘǾ₥£ is offline  
Old   #8
 
elite*gold: 0
Join Date: Oct 2009
Posts: 154
Received Thanks: 11
would be to easy to give him an answer? just everbody spam **** in the topic.
sdone is offline  
Thanks
1 User
Old   #9
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
SELECT ITEM.id, STRING.value
FROM ARCADIA.dbo.ItemResource ITEM, ARCADIA.dbo.StringResource STRING
WHERE STRING.code=ITEM.name_id and STRING.value like '%Searchterm%'
c1ph3r is offline  
Thanks
1 User
Old   #10
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
USE Arcadia
SELECT I.id, S.value
FROM dbo.ItemResource I
WITH (NOLOCK) INNER JOIN dbo.StringResource S
WITH (NOLOCK) ON I.name_text_id = S.Code AND S.name LIKE '%name_item_%'
ORDER BY name_text_id ASC
ismokedrow is offline  
Thanks
1 User
Old   #11


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
Quote:
Originally Posted by ismokedrow View Post
USE Arcadia
SELECT I.id, S.value
FROM dbo.ItemResource I
WITH (NOLOCK) INNER JOIN dbo.StringResource S
WITH (NOLOCK) ON I.name_text_id = S.Code AND S.name LIKE '%name_item_%'
ORDER BY name_text_id ASC
ehhh, wtf?
Whats the sence on the nolock thingly? o.0
also ItemResource has the column name_id, not name_text_id....
Xijezu is offline  
Old   #12
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
Well then why don't you just correct it? Oh that's right because you have this whole superiority thing going on. Forgot, here we go with you and your minion's huh?

CORRECTED BY XIJEZU (So he can have his fame, you know how girls act when they want to be the prettiest)

USE Arcadia
SELECT I.id, S.value
FROM dbo.ItemResource I
INNER JOIN dbo.StringResource S
ON I.name_id = S.Code AND S.name LIKE '%name_item_%'
ORDER BY name_id ASC
ismokedrow is offline  
Thanks
1 User
Old   #13
 
elite*gold: 0
Join Date: Jun 2010
Posts: 573
Received Thanks: 161
NOLOCK is pretty handy but not needed for a "small" query like this i'd say. It just reduces the overhead for a query but on the other hand you can't be 100% sure about the data you get, cause it could be under update the same moment.
haxti is offline  
Old   #14
 
elite*gold: 0
Join Date: Jul 2011
Posts: 57
Received Thanks: 7
Quote:
Originally Posted by ismokedrow View Post
Well then why don't you just correct it? Oh that's right because you have this whole superiority thing going on. Forgot, here we go with you and your minion's huh?

CORRECTED BY XIJEZU (So he can have his fame, you know how girls act when they want to be the prettiest)

USE Arcadia
SELECT I.id, S.value
FROM dbo.ItemResource I
INNER JOIN dbo.StringResource S
ON I.name_id = S.Code AND S.name LIKE '%name_item_%'
ORDER BY name_id ASC
You must register and activate your account in order to view images.
pavilion82 is offline  
Old   #15
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
Quote:
Originally Posted by pavilion82 View Post
You must register and activate your account in order to view images.
You still can't be original?


ismokedrow is offline  
Thanks
1 User
Reply



« Previous Thread | Next Thread »

Similar Threads
ID's help
Hi everyone! I am asking if there is an id for redchips and Demon set (M) :confused: Thanks ;)
1 Replies - Flyff Main - Discussions / Questions
item id's and mob id's
can someone give me the full list of all the id's of mobs and items ingame? cheers for that :D
0 Replies - SRO PServer Ask the Experts
[Suche] Alle Upp-Items Id's
Hallo liebe Com! ICh suche schon seit langem alle Upp-Items id, für meinen Server! Jedoch finde ich sie nicht, ich bin zwar schon auf dem...
3 Replies - Metin2 PServer - Discussions / Questions
new mob id's
This might be a simple question but does anybody know what the mob ID is for the new mob Kasha's Eye or is there an easy way through walker to find...
0 Replies - Lin2 Exploits, Hacks, Bots, Tools & Macros
[REQUEST]Full list NPC ID's ITEMS ID's, MAP ID's for 5095 source
Any have a full list? TY in advanced.
1 Replies - CO2 PServer - Discussions / Questions



All times are GMT +2. The time now is 11:06.


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

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