Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 22:52

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

 

[looking for]New Items ID's

Reply
 
Old   #16


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
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
I personally don't see a sence of posting a searchquery (where the first one u posted didn't even worked!) when the best one was posted before...



Xijezu is offline  
Old   #17
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
To give the person who asked the question the ability to list ALL items, hell with some minor adjustments that query can list all Buffs, Skills, Items, Monsters, Looters, Summons. Shall I continue?


ismokedrow is offline  
Old   #18


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
Quote:
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
huh, I just see Itemresource *cough*
Xijezu is offline  
Old   #19
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
Quote:
Originally Posted by Xijezu View Post
huh, I just see Itemresource *cough*
USE Aracia
SELECT B.state_id, S.value
FROM dbo.StateResource B
INNER JOIN dbo.StringResource S
ON B.text_id = S.Code AND S.name LIKE '%name_state_%'
ORDER BY B.text_id ASC


-Cough- Now it's States.


ismokedrow is offline  
Thanks
1 User
Old   #20


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
Quote:
Originally Posted by c1ph3r View Post
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%'
Now let us change ItemResource to MonsterResource.
Huh, it's the same.
Xijezu is offline  
Old   #21
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
Hu hu, lets change it to anything and I'll bet you'll still ***** about it.
ismokedrow is offline  
Old   #22


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
Quote:
Originally Posted by ismokedrow View Post
Hu hu, lets change it to anything and I'll bet you'll still ***** about it.
You're right, just because you can't admit that your post was completely useless
Xijezu is offline  
Old   #23
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
Quote:
Originally Posted by Xijezu View Post
You're right, just because you can't admit that your post was completely useless
That makes a TON of sense o_O To mentally ill illiterate children.
ismokedrow is offline  
Old   #24
 
elite*gold: 0
Join Date: Jul 2006
Posts: 177
Received Thanks: 43
Would've been much easier and less argue worthy for someone to just upload a list of **** so the guy could move on with his life instead of putting down people that are trying to help him out~

I see this forum never changes~
nightguy13 is offline  
Old   #25
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by nightguy13 View Post
Would've been much easier and less argue worthy for someone to just upload a list of **** so the guy could move on with his life instead of putting down people that are trying to help him out~

I see this forum never changes~
Your are right: Fckng People aren't able to use the fckng search button to fix their fckng problems, which have been discussed about 100 times, on their own! Instead of searching they write stupid posts which will help nobody too. Nothing will ever change
c1ph3r is offline  
Old   #26
 
elite*gold: 0
Join Date: Apr 2012
Posts: 13
Received Thanks: 0
Quote:
Originally Posted by Xijezu View Post
You're right, just because you can't admit that your post was completely useless
at last only useless posts i see here are your posts...
Ismoke helped me many times... and you ? no because all you can say is "Use Search" what means ("I am too cool for you")
Denis9518 is offline  
Old   #27
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Denis9518 View Post
at last only useless posts i see here are your posts...
Ismoke helped me many times... and you ? no because all you can say is "Use Search" what means ("I am too cool for you")
Next time post your question in help thread to keep flaming at a minimum. It's not very hard and the help thread is for questions like that. You can't find anything in this forum if everyone opens a new thread for a simple question.

The anwer to your question (SQL-Script) was posted 6 month ago by Xijezu's team. That is the reason why he didn't answered your question.
c1ph3r is offline  
Thanks
1 User
Old   #28


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
90% of all fixes can be found via search in this forum.
100% of such... stupid questions can be answered via search in this forum within 1 minute.

It's quite funny to see when they complain about the sentence "use search" when:
Quote:
The anwer to your question (SQL-Script) was posted 6 month ago by Xijezu's team.
Doesn't even matter if it was my Team (DF) or NCarbon or someone else.

Fact is: Those "1-day-questions" can be found with the fkng search. If people are too stupid to use it: Don't even try to start those files...
Xijezu is offline  
Old   #29
 
elite*gold: 0
Join Date: Jun 2010
Posts: 573
Received Thanks: 161
Quote:
Originally Posted by nightguy13 View Post
Would've been much easier and less argue worthy for someone to just upload a list of **** so the guy could move on with his life instead of putting down people that are trying to help him out~

I see this forum never changes~
Nope! Posting Lists is ******* stupid, cause they are changing with different Rappelz Epics. Just save those ******* easy querys and use them!
Furthermore:

Quote:
Originally Posted by c1ph3r View Post
Your are right: Fckng People aren't able to use the fckng search button to fix their fckng problems, which have been discussed about 100 times, on their own! Instead of searching they write stupid posts which will help nobody too. Nothing will ever change
^this! Don't complain about flames or something. BTW nobody needs to say "I used search" cause we will instantly notice, whether you use the searchbutton. Cause this is the 20th time we heard exactly this question.


haxti is offline  
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 22:52.


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.