Register for your free account! | Forgot your password?

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

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

 

Dura Equip Item IDS?

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Aug 2009
Posts: 435
Received Thanks: 74
Dura Equip Item IDS?

Hey guys, any1 have a list of the dura items (weapons / armors / rings / earrings ...)

thank you in advance



GeneraL_SchnitzeL is offline  
Old   #2
 
elite*gold: 0
Join Date: Jun 2010
Posts: 573
Received Thanks: 161
Please! I posted the query to make a list of all buffs. Change 3 names and the query will create a item list. Once again: WE ARE NOT YOUR NANNYS!

Furthermore: You don't need to create a new Thread for a question like this.

If you need further assistance with the query: Just post your attempt here and I will try to help you.


haxti is offline  
Old   #3
 
elite*gold: 0
Join Date: Mar 2012
Posts: 200
Received Thanks: 23
Quote:
Originally Posted by haxti View Post
Please! I posted the query to make a list of all buffs. Change 3 names and it will create a item list. Once again: WE ARE NOT YOUR NANNYS!

Furthermore: You don't need to create a new Thread for a question like this.
O_O ? he say

Quote:
dura items (weapons / armors / rings / earrings ...)
Not BUFFS O.o
AngelOwns is offline  
Old   #4
 
elite*gold: 0
Join Date: Jun 2010
Posts: 573
Received Thanks: 161
Quote:
Originally Posted by AngelOwns View Post
O_O ? he say



Not BUFFS O.o

I know so. Read the WHOLE post again, and think about it.


haxti is offline  
Old   #5
 
elite*gold: 0
Join Date: Oct 2011
Posts: 251
Received Thanks: 4
This is a Forum for Question's Haxti you cannot say post this in help thread or don't make new threads for this.
when you don't have a answer then post not bullshit . sry

/edit need ids too for dura eq .^
falkenman is offline  
Old   #6


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
If you don't get it how to use a simply query, ... Well... I don't say anything.
Xijezu is offline  
Thanks
2 Users
Old   #7
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
First i thought to ignore this Thread, but....


OFM Dumbasse´s. WE NEED, WE NEED!!! WHAT?! YOU DONT GIVE US ALL WE WANT WITHOUT SELFWORK?! LEAVE HERE!!!!


TheOnlyOneRaskim is offline  
Thanks
3 Users
Old   #8
 
elite*gold: 0
Join Date: Jun 2010
Posts: 573
Received Thanks: 161
Quote:
Originally Posted by haxti View Post
Code:
SELECT skill.id, skill.text_id, string.value
FROM Arcadia.dbo.SkillResource skill, Arcadia.dbo.StringResource string
WHERE skill.text_id = string.code
ORDER BY value ASC

Still no DB at hand. Let me see:

1.) You don't need Skills but Items. Change ALL skill -> item
2.) item.text_id is *probably* item.name_id ! Just check the table.
3.) If you aren't able to figure it out, how querys are working, you prolly should not try to start a server.

Btw: I'm just a normal guy, like many others. I never learned anything about SQL before. I started using this shit with the whole rappelz pserver thing popping up JUST BY INSPECTING OTHER QUERYS AND LOOK WHAT THEY DO!

Really. It's even easier then lua since you get an instant and very informative error message, if you did something wrong!

Quote:
Originally Posted by falkenman View Post
This is a Forum for Question's Haxti you cannot say post this in help thread or don't make new threads for this.
when you don't have a answer then post not bullshit . sry

/edit need ids too for dura eq .^

You posted in the same thread with Schnitzel maybe a week ago. Thought you are the Dev-Pro...
haxti is offline  
Old   #9
 
elite*gold: 0
Join Date: Oct 2011
Posts: 251
Received Thanks: 4
it's easy. learning by doing
falkenman is offline  
Old   #10


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
Quote:
Originally Posted by falkenman View Post
it's easy. learning by doing
...You are the best example...
Xijezu is offline  
Thanks
2 Users
Old   #11
 
elite*gold: 0
Join Date: Oct 2011
Posts: 38
Received Thanks: 27
Post

Before this thread becomes yet another "hallpp pl0x!11"-thread, I'll show you the working query:

Quote:
SELECT item.id, item.name_id, string.value -- Selects an item and it's name_id and gives out the string value
FROM Arcadia.dbo.ItemResource item, Arcadia.dbo.StringResource string -- tells the query where to look for le files
WHERE item.name_id = string.code -- connected to the FROM-command: shows the string(readable name) assigned to the name_id
ORDER BY value ASC -- Sorted by order: ascending, desc would be descending, means, all values are sorted by a logical alphabet (special characters, 0-9, A-Z)
(The query is written as quote since the [code]-command messes up with the colors and makes it unusable)
This should be self explanatory.

Please, by no means, delete the "--" as they mark the beginning of a comment section and MSSQL would fail at executing the query.

Even though I myself have never used MSSQL or similiar software, I am able to figure out how these stupid queries work.
I guess that a horde of braindeaf monkeys could handle it, meh...

Partial credits go to haxti for giving a useable approach.

If you need the comments in german, write me a PM.

Greez,

Ciel
ci4lblFmPW is offline  
Old   #12
 
elite*gold: 0
Join Date: Jun 2010
Posts: 573
Received Thanks: 161
Quote:
Originally Posted by ci4lblFmPW View Post
[...]
Becareful with linebreaks tho when using comments!
haxti is offline  
Old   #13
 
elite*gold: 0
Join Date: Oct 2011
Posts: 38
Received Thanks: 27
Post

Yeah, originally there was no linebreak.. EPvP's layout messed it up.
When you c/p it into a new Query, it will show correctly.

Just to be on the safe side, I've uploaded the query - don't be puzzled about the german name.

[Query attached as Item-Liste.zip]


[The 7.3 item list is attached as Item List 7.3 PDF+SXC.zip, it contains a list of 26000+ items with their id's, available as readable .pdf and as Open Office .sxc-table]
Attached Files
File Type: zip ITEM-Liste.zip (467 Bytes, 158 views)
File Type: zip Item List 7.3 PDF+SXC.zip (1.45 MB, 215 views)


ci4lblFmPW is offline  
Thanks
2 Users
Reply



« Previous Thread | Next Thread »

Similar Threads
[PServ - Req] Dura Equip
It was indroduced in Epic 6.2 if i'm not wrong... Is it supported by herlock/current databases?
1 Replies - Rappelz
Equip same item
Is there any way you can go around and equip same item more then one time ? If there's not can it be hacked ? Thanks!
17 Replies - 9Dragons
KTS Dura Equip
Hello, I have a Problem on KTS ( i dont make anyone Account) I have Dura equip but i dont know we i can repair it, when anyone can Help me Pls...
1 Replies - Rappelz
5250+ Equip Item Problem
When I go to equip an item it shows that it is equiped but doesn't show on the actual player that it is equiped. :/ I'm sending the right packets....
13 Replies - CO2 PServer - Discussions / Questions
Defeat DMA for item dura
Allright you have all seen the bozo's who macroed to much and items broke do to low dura.... Well i propose we work to gether defeating the dma for...
5 Replies - CO2 Main - Discussions / Questions



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


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.