Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 16:56

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

 

Need ethreal stuff's IDs

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Sep 2011
Posts: 14
Received Thanks: 0
Need ethreal stuff's IDs

null



X6axx34 is offline  
Old   #2
 
elite*gold: 0
Join Date: Jun 2010
Posts: 573
Received Thanks: 161
Go search them.


haxti is offline  
Old   #3
 
elite*gold: 0
Join Date: Oct 2011
Posts: 38
Received Thanks: 27
Use a MSSQL SELECT query, include Arcadia.dbo.ItemResource and Arcadia.dbo.StringResource, then ORDER BY whateveryouwant.

1. Sorted by CODE (shows the weapons etc. from rank 1-7 etc.):
Code:
SELECT item.id, item.name_id, item.rank, item.use_min_level, string.value 
FROM Arcadia.dbo.ItemResource item, Arcadia.dbo.StringResource string
WHERE item.name_id = string.code
ORDER BY id ASC
2. Sorted by VALUE (shows all dura items in a row):
Code:
SELECT item.id, item.name_id, item.rank, item.use_min_level, string.value 
FROM Arcadia.dbo.ItemResource item, Arcadia.dbo.StringResource string
WHERE item.name_id = string.code
ORDER BY value ASC
If you are looking for the MC weapons, you should use query 1, then scroll down until you find a row with the value "?????? ????".
This row should be behind the t1/t2/t3 weapons of that type (2H mace and so on).

With query 2, the dura items are sorted by their name (alphabetical).

Greez,

Ciel
ci4lblFmPW is offline  
Thanks
1 User
Old   #4
 
elite*gold: 0
Join Date: Mar 2012
Posts: 13
Received Thanks: 2
STOP POST YOU HAVE THREAD HELP TO POST....
NO CREATE NEW THREAD..
SEARCH IN YOUR DB AND YOU FIND ID ......

#CLOSEDREQUEST


ProdStar is offline  
Old   #5
 
elite*gold: 0
Join Date: Jan 2012
Posts: 354
Received Thanks: 32
lol for 1 i knwo all the id's but for 2 you still have to fix the dura on them and oh ya i know those too but im not fully done fixing them all as there is so far alot prob over 2+k so far


mlejnek2 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[Need] L2Phx Working Echant Srv. [Offer] Stuff's
Hi @ All I need one interlude server where l2phx 3.1.6 works.. or any version to enchant items. The one who will give me that server/s will get...
0 Replies - Lineage 2



All times are GMT +2. The time now is 16:56.


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.