[looking for]New Items ID's

[Xijezu]

Originally Posted by ismokedrow

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...

[ismokedrow]

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?

[Xijezu]

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*

[ismokedrow]

Originally Posted by Xijezu

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.

[Xijezu]

Originally Posted by c1ph3r

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.

[ismokedrow]

Hu hu, lets change it to anything and I'll bet you'll still ***** about it.

[Xijezu]

Originally Posted by ismokedrow

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

[ismokedrow]

Originally Posted by Xijezu

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.

[nightguy13]

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~

[c1ph3r]

Originally Posted by nightguy13

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

[Denis9518]

Originally Posted by Xijezu

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")

[c1ph3r]

Originally Posted by Denis9518

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.

[Xijezu]

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:

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...

[haxti]

Originally Posted by nightguy13

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:

Originally Posted by c1ph3r

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.